syslog.txt
text/plain
Jan 25 13:49:10 wren postgres[6106]: [58-2] STATEMENT: VACUUM full ANALYZE;
Jan 25 13:59:58 wren postgres[6903]: [1-1] LOG: recycled transaction log file "000000230000009F"
Jan 25 14:17:35 wren postgres[1834]: [1-1] LOG: received fast shutdown request
Jan 25 14:17:35 wren postgres[1834]: [2-1] LOG: aborting any active transactions
Jan 25 14:17:35 wren postgres[6117]: [3-2] STATEMENT:
Jan 25 14:17:35 wren postgres[6117]: [3-3] ^Iselect
Jan 25 14:17:35 wren postgres[6117]: [3-4] ^I customer.custid,
Jan 25 14:17:35 wren postgres[6117]: [3-5] ^I login.login,
Jan 25 14:17:35 wren postgres[6117]: [3-6] ^I radacct.acctsessionid,
Jan 25 14:17:35 wren postgres[6117]: [3-7] ^I radacct.acctstoptime,
Jan 25 14:17:35 wren postgres[8708]: [4-1] FATAL: the database system is shutting down
Jan 25 14:17:35 wren postgres[6117]: [3-8] ^I billtype.datacost,
Jan 25 14:17:35 wren postgres[6117]: [3-9] ^I radacct.acctoutputoctets
Jan 25 14:17:35 wren postgres[6117]: [3-10] ^Ifrom
Jan 25 14:17:35 wren postgres[6117]: [3-11] ^I login,radacct,customer,billtype
Jan 25 14:17:35 wren postgres[6117]: [3-12] ^Iwhere
Jan 25 14:17:35 wren postgres[6117]: [3-13] ^I login.login = radacct.username and
Jan 25 14:17:35 wren postgres[6117]: [3-14] ^I login.custid = customer.custid and
Jan 25 14:17:35 wren postgres[6117]: [3-15] ^I date_trunc ('second', radacct.acctstoptime) > date_trunc ('second', customer.lastbilled) and
Jan 25 14:17:35 wren postgres[6117]: [3-16] ^I customer.billtype = billtype.code
Jan 25 14:17:35 wren postgres[6117]: [3-17] ^Iorder by radacct.acctstoptime
Jan 25 14:17:35 wren postgres[6117]: [3-18] ^I
Jan 25 14:17:35 wren postgres[6117]: [3-19] ^I
Jan 25 14:17:58 wren postgres[8762]: [4-1] FATAL: the database system is shutting down
Jan 25 14:18:45 wren postgres[1834]: [3-1] LOG: received immediate shutdown request
Jan 25 14:18:48 wren postgres[6111]: [3-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server
Jan 25 14:18:48 wren postgres[6111]: [3-3] process exited abnormally and possibly corrupted shared memory.
Jan 25 14:18:48 wren postgres[6111]: [3-4] HINT: In a moment you should be able to reconnect to the database and repeat your command.
Jan 25 14:18:48 wren postgres[6111]: [3-5] STATEMENT: VACUUM full ANALYZE;
Jan 25 14:18:48 wren postgres[8623]: [1-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server
Jan 25 14:18:48 wren postgres[8623]: [1-3] process exited abnormally and possibly corrupted shared memory.
Jan 25 14:18:48 wren postgres[8623]: [1-4] HINT: In a moment you should be able to reconnect to the database and repeat your command.
Jan 25 14:18:49 wren postgres[9120]: [1-1] LOG: database system was interrupted at 2007-01-25 14:10:27 EST
Jan 25 14:18:49 wren postgres[9120]: [2-1] LOG: checkpoint record is at 23/A13FD9FC
Jan 25 14:18:49 wren postgres[9120]: [3-1] LOG: redo record is at 23/A13D3318; undo record is at 0/0; shutdown FALSE
Jan 25 14:18:49 wren postgres[9120]: [4-1] LOG: next transaction ID: 105232106; next OID: 20947715
Jan 25 14:18:49 wren postgres[9120]: [5-1] LOG: database system was not properly shut down; automatic recovery in progress
Jan 25 14:18:49 wren postgres[9120]: [6-1] LOG: redo starts at 23/A13D3318
Jan 25 14:18:49 wren postgres[9120]: [7-1] PANIC: btree_delete_page_redo: lost target page
Jan 25 14:18:49 wren postgres[9114]: [1-1] LOG: startup process (PID 9120) was terminated by signal 6
Jan 25 14:18:49 wren postgres[9114]: [2-1] LOG: aborting startup due to startup process failure
Jan 25 14:20:35 wren postgres[9232]: [1-1] LOG: database system was interrupted while in recovery at 2007-01-25 14:18:49 EST
Jan 25 14:20:35 wren postgres[9232]: [1-2] HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
Jan 25 14:20:35 wren postgres[9232]: [2-1] LOG: checkpoint record is at 23/A13FD9FC
Jan 25 14:20:35 wren postgres[9232]: [3-1] LOG: redo record is at 23/A13D3318; undo record is at 0/0; shutdown FALSE
Jan 25 14:20:35 wren postgres[9232]: [4-1] LOG: next transaction ID: 105232106; next OID: 20947715
Jan 25 14:20:35 wren postgres[9232]: [5-1] LOG: database system was not properly shut down; automatic recovery in progress
Jan 25 14:20:35 wren postgres[9232]: [6-1] LOG: redo starts at 23/A13D3318
Jan 25 14:20:35 wren postgres[9232]: [7-1] PANIC: btree_delete_page_redo: lost target page
Jan 25 14:20:35 wren postgres[9226]: [1-1] LOG: startup process (PID 9232) was terminated by signal 6
Jan 25 14:20:35 wren postgres[9226]: [2-1] LOG: aborting startup due to startup process failure