OpenForum RSS: Postgresql �� pg_clog

Postgresql �� pg_clog (dtkr)

Fri, 29 Oct 2010 08:29:58 GMT

>[�� ]
>> ��. ��:
>>>�� pg_dump �� :
>>>----------
>>>pg_dump: Error message from server: ERROR: could not access status of transaction >3187692544
>>>��: Could not open file "pg_clog/0BE0": �� .
>>>pg_dump: The command was: COPY public.history (itemid, clock, value) TO stdout;
>>>pg_dump: *** aborted because of error
>> pg_dump ��
> � pg_clog �� .
> �� pg_resetxlog -f /var/lib/pgsql.

�� pg_resetxlog. �� .

Postgresql �� pg_clog (ImPressed)

Fri, 29 Oct 2010 03:28:45 GMT

>[�� ]
>> 5. ��
>> ��
> ��. ��:
>>�� pg_dump �� :
>>----------
>>pg_dump: Error message from server: ERROR: could not access status of transaction >3187692544
>>��: Could not open file "pg_clog/0BE0": �� .
>>pg_dump: The command was: COPY public.history (itemid, clock, value) TO stdout;
>>pg_dump: *** aborted because of error
> pg_dump ��

� pg_clog �� .
�� pg_resetxlog -f /var/lib/pgsql.

Postgresql �� pg_clog (dtkr)

Thu, 28 Oct 2010 19:49:03 GMT

>[�� ]
>> DETAIL: Could not open file "pg_clog/0BE0": �� .
>> CONTEXT: automatic vacuum of table "zabbix.public.history"
>> ERROR: invalid page header in block 15641 of relation base/16387/16731
>> CONTEXT: automatic vacuum of table "zabbix.public.history_uint"
> 1. �� .
> 2. �� /var/pgsql/data/
> 3. �� initdb -D /var/pgsql/data/
> 4. �� Postgres
> 5. ��
> ��

��. ��:

>�� pg_dump �� :
>----------
>pg_dump: Error message from server: ERROR: could not access status of transaction >3187692544
>��: Could not open file "pg_clog/0BE0": �� .
>pg_dump: The command was: COPY public.history (itemid, clock, value) TO stdout;
>pg_dump: *** aborted because of error

pg_dump �� .

Postgresql �� pg_clog (ImPressed)

Thu, 28 Oct 2010 18:02:57 GMT

>[�� ]
> ERROR: could not access status of transaction 3187692544
> DETAIL: Could not open file "pg_clog/0BE0": �� .
> CONTEXT: automatic vacuum of table "zabbix.public.history"
> ERROR: invalid page header in block 15641 of relation base/16387/16731
> CONTEXT: automatic vacuum of table "zabbix.public.history_uint"
> ERROR: could not access status of transaction 3187692544
> DETAIL: Could not open file "pg_clog/0BE0": �� .
> CONTEXT: automatic vacuum of table "zabbix.public.history"
> ERROR: invalid page header in block 15641 of relation base/16387/16731
> CONTEXT: automatic vacuum of table "zabbix.public.history_uint"

1. �� .
2. �� /var/pgsql/data/
3. �� initdb -D /var/pgsql/data/
4. �� Postgres
5. ��
��

Postgresql �� pg_clog (dtkr)

Thu, 28 Oct 2010 12:01:35 GMT

> �� -�� , �.�. ��
> �� pg_clog, �� , �� (��) �� .

��. � �� :

-----------
ls -ld /var/pgsql/data/pg_clog
drwx------ 2 postgres postgres 4096 �� 23 02:37 /var/pgsql/data/pg_clog

� �� :
------------------------------
CONTEXT: automatic vacuum of table "zabbix.public.history"
ERROR: invalid page header in block 15641 of relation base/16387/16731
CONTEXT: automatic vacuum of table "zabbix.public.history_uint"
ERROR: could not access status of transaction 3187692544
DETAIL: Could not open file "pg_clog/0BE0": �� .
CONTEXT: automatic vacuum of table "zabbix.public.history"
ERROR: could not access status of transaction 4278191119
DETAIL: Could not open file "pg_clog/0FF0": �� .
STATEMENT: delete from history where itemid=23496 and clock<1285812085
ERROR: invalid page header in block 1

Postgresql �� pg_clog (Fisher)

Thu, 28 Oct 2010 08:07:31 GMT

�� -�� , �.�. �� pg_clog, �� , �� (��) �� .

OpenForum RSS: Postgresql �������� � pg_clog

Postgresql �������� � pg_clog (dtkr)

Postgresql �������� � pg_clog (ImPressed)

Postgresql �������� � pg_clog (dtkr)

Postgresql �������� � pg_clog (ImPressed)

Postgresql �������� � pg_clog (dtkr)

Postgresql �������� � pg_clog (Fisher)

OpenForum RSS: Postgresql �� pg_clog

Postgresql �� pg_clog (dtkr)

Postgresql �� pg_clog (ImPressed)

Postgresql �� pg_clog (dtkr)

Postgresql �� pg_clog (ImPressed)

Postgresql �� pg_clog (dtkr)

Postgresql �� pg_clog (Fisher)