Wgrałem zepsute pliki i o dziwo bez wywoływania pg_resetxlog postgres wstał. Co prawda nadal są błędy jednak nie wywalił się od razu na początku. W logach teraz znajduje:
%t LOG: database system was interrupted; last known up at 2009-06-18 15:26:18 CEST
%t LOG: database system was not properly shut down; automatic recovery in progress
%t LOG: record with zero length at 5F/73E3ACF8
%t LOG: redo is not required
%t DZIENNIK: database system is ready to accept connections
%t LOG: autovacuum launcher started
%t ERROR: index "V_POLA_ODNIESIENIA_pkey" contains unexpected zero page at block 245897
%t HINT: Please REINDEX it.
%t STATEMENT: SELECT max("ID") FROM "public"."V_POLA_ODNIESIENIA"
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t FATAL: could not open file "base/17549/PG_VERSION": Permission denied
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t FATAL: could not open file "base/21426/PG_VERSION": Permission denied
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t FATAL: could not open file "base/22237/PG_VERSION": Permission denied
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 0
%t DETAIL: Could not open file "pg_subtrans/1E5E": Permission denied.
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 0
%t DETAIL: Could not open file "pg_subtrans/1E5E": Permission denied.
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t ERROR: could not access status of transaction 471677341
%t DETAIL: Could not open file "pg_clog/01C1": Permission denied.
%t STATEMENT: DELETE FROM qrtz_FIRED_TRIGGERS WHERE ENTRY_ID = $1
%t PANIC: could not open file "pg_xlog/000000010000005F0000007A" (log file 95, segment 122): Permission denied
This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.
%t DZIENNIK: server process (PID 3356) exited with exit code 3
%t DZIENNIK: terminating any other active server processes
%t WARNING: terminating connection because of crash of another server process
%t DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
%t HINT: In a moment you should be able to reconnect to the database and repeat your command.
%t WARNING: terminating connection because of crash of another server process
%t DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
%t HINT: In a moment you should be able to reconnect to the database and repeat your command.
%t WARNING: terminating connection because of crash of another server process
%t DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
%t HINT: In a moment you should be able to reconnect to the database and repeat your command.
%t WARNING: terminating connection because of crash of another server process
%t DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
%t HINT: In a moment you should be able to reconnect to the database and repeat your command.
%t WARNING: terminating connection because of crash of another server process
%t DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
%t HINT: In a moment you should be able to reconnect to the database and repeat your command.
%t WARNING: terminating connection because of crash of another server process
%t DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
%t HINT: In a moment you should be able to reconnect to the database and repeat your command.
%t DZIENNIK: all server processes terminated; reinitializing
%t KATASTROFALNY: pre-existing shared memory block is still in use
%t PODPOWIEDŹ:Check if there are any old server processes still running, and terminate them.
Jak widać nadal są jakieś jazdy z uprawnieniami. Jutro spróbuje odpalić backup na tych tabelach może pójdzie, wtedy jak przywróce na nowej instalce wydaje mi się, że powinno być ok. Mam nadzieje. Musze jeszcze poczytać co jest w katalogu pg_clog. Dam znać jak poszło z backupem.
Ostatnio edytowany przez smdvq (2009-06-18 21:41:11)
