> >
> >
> > I have kept all that database files for the future investigation.
> >
> > What I should look into first?
> Could you reproduce the error with log_error_verbosity=verbose? Or even
> better
> provide a backtrace with gdb?
>
>
There log with log_error_verbosity=verbose:
2012-08-21 14:04:18.973 MSK 33950 @ from [vxid: txid:0] []LOG: 00000:
database system was interrupted while in recovery at log time 2012-08-21
08:21:42 MSK
2012-08-21 14:04:18.973 MSK 33950 @ from [vxid: txid:0] []HINT: If this
has occurred more than once some data might be corrupted and you might need
to choose an earlier recovery target.
2012-08-21 14:04:18.973 MSK 33950 @ from [vxid: txid:0] []LOCATION:
StartupXLOG, xlog.c:5757
2012-08-21 14:04:18.973 MSK 33950 @ from [vxid: txid:0] []LOG: 00000:
creating missing WAL directory "pg_xlog/archive_status"
2012-08-21 14:04:18.973 MSK 33950 @ from [vxid: txid:0] []LOCATION:
ValidateXLOGDirectoryStructure, xlog.c:3452
2012-08-21 14:04:19.009 MSK 33950 @ from [vxid: txid:0] []LOG: 00000:
entering standby mode
2012-08-21 14:04:19.009 MSK 33950 @ from [vxid: txid:0] []LOCATION:
StartupXLOG, xlog.c:5827
2012-08-21 14:04:19.041 MSK 33951 @ from [vxid: txid:0] []LOG: 00000:
streaming replication successfully connected to primary
2012-08-21 14:04:19.041 MSK 33951 @ from [vxid: txid:0] []LOCATION:
libpqrcv_connect, libpqwalreceiver.c:169
2012-08-21 14:04:20.140 MSK 33950 @ from [vxid:1/0 txid:0] []LOG: 00000:
redo starts at 925/2C0004C8
2012-08-21 14:04:20.140 MSK 33950 @ from [vxid:1/0 txid:0] []LOCATION:
StartupXLOG, xlog.c:6199
2012-08-21 14:04:20.160 MSK 33950 @ from [vxid:1/0 txid:0] []FATAL:
XX000: could not access status of transaction 361788644
2012-08-21 14:04:20.161 MSK 33950 @ from [vxid:1/0 txid:0] []DETAIL:
Could not read from file "pg_multixact/offsets/1590" at offset 114688:
Unknown error: 0.
2012-08-21 14:04:20.161 MSK 33950 @ from [vxid:1/0 txid:0] []CONTEXT:
xlog redo create multixact 361788644 offset 822580965: 1768508061 1768508078
2012-08-21 14:04:20.161 MSK 33950 @ from [vxid:1/0 txid:0] []LOCATION:
SlruReportIOError, slru.c:840
2012-08-21 14:04:20.169 MSK 33948 @ from [vxid: txid:0] []LOG: 00000:
startup process (PID 33950) exited with exit code 1
2012-08-21 14:04:20.169 MSK 33948 @ from [vxid: txid:0] []LOCATION:
LogChildExit, postmaster.c:2840
2012-08-21 14:04:20.169 MSK 33948 @ from [vxid: txid:0] []LOG: 00000:
terminating any other active server processes
2012-08-21 14:04:20.169 MSK 33948 @ from [vxid: txid:0] []LOCATION:
HandleChildCrash, postmaster.c:2674
Kind Regards,
Maksym
