Обсуждение: Question about warning: "invalid resource manager ID 128 at ..." on hot stanby
Hi all.
Database version used 9.0.4 on FreeBSD 7.3.
Today ,after restart of replica db, I got the next warning in log:
>2012-03-23 03:10:08.221 MSK 55096 @ from [vxid:1/0 txid:0] []LOG: invalid resource manager ID 128 at 44E/4E7303B0
I searched over mailing lists but I still not sure is it harmless or no...
Full log looks like:
2012-03-23 03:08:46.465 MSK 38622 @ from [vxid: txid:0] []LOG: received fast shutdown request
2012-03-23 03:08:46.465 MSK 38622 @ from [vxid: txid:0] []LOG: aborting any active transactions
2012-03-23 03:08:46.465 MSK 38627 @ from [vxid: txid:0] []FATAL: terminating walreceiver process due to administrator command
2012-03-23 03:08:46.693 MSK 38718 @ from [vxid: txid:0] []LOG: shutting down
2012-03-23 03:08:46.696 MSK 38718 @ from [vxid: txid:0] []LOG: database system is shut down
2012-03-23 03:08:53.850 MSK 55096 @ from [vxid: txid:0] []LOG: database system was shut down in recovery at 2012-03-23 03:08:46 MSK
2012-03-23 03:08:53.874 MSK 55096 @ from [vxid: txid:0] []LOG: entering standby mode
2012-03-23 03:08:53.905 MSK 55096 @ from [vxid:1/0 txid:0] []LOG: redo starts at 44E/114060E8
2012-03-23 03:10:08.221 MSK 55096 @ from [vxid:1/0 txid:0] []LOG: consistent recovery state reached at 44E/4E7303B0
2012-03-23 03:10:08.221 MSK 55096 @ from [vxid:1/0 txid:0] []LOG: invalid resource manager ID 128 at 44E/4E7303B0
2012-03-23 03:10:08.222 MSK 55093 @ from [vxid: txid:0] []LOG: database system is ready to accept read only connections
2012-03-23 03:10:08.239 MSK 56317 @ from [vxid: txid:0] []LOG: streaming replication successfully connected to primary
Is that warning harmless on 9.0.4 or should I start to worry about?
--
Maxim Boguk
Senior Postgresql DBA.
Phone RU: +7 910 405 4718
Phone AU: +61 45 218 5678
Skype: maxim.boguk
Jabber: maxim.boguk@gmail.com
LinkedIn profile: http://nz.linkedin.com/in/maximboguk
"If they can send one man to the moon... why can't they send them all?"
МойКруг: http://mboguk.moikrug.ru/
"People problems are solved with people.
If people cannot solve the problem, try technology.
People will then wish they'd listened at the first stage."
Database version used 9.0.4 on FreeBSD 7.3.
Today ,after restart of replica db, I got the next warning in log:
>2012-03-23 03:10:08.221 MSK 55096 @ from [vxid:1/0 txid:0] []LOG: invalid resource manager ID 128 at 44E/4E7303B0
I searched over mailing lists but I still not sure is it harmless or no...
Full log looks like:
2012-03-23 03:08:46.465 MSK 38622 @ from [vxid: txid:0] []LOG: received fast shutdown request
2012-03-23 03:08:46.465 MSK 38622 @ from [vxid: txid:0] []LOG: aborting any active transactions
2012-03-23 03:08:46.465 MSK 38627 @ from [vxid: txid:0] []FATAL: terminating walreceiver process due to administrator command
2012-03-23 03:08:46.693 MSK 38718 @ from [vxid: txid:0] []LOG: shutting down
2012-03-23 03:08:46.696 MSK 38718 @ from [vxid: txid:0] []LOG: database system is shut down
2012-03-23 03:08:53.850 MSK 55096 @ from [vxid: txid:0] []LOG: database system was shut down in recovery at 2012-03-23 03:08:46 MSK
2012-03-23 03:08:53.874 MSK 55096 @ from [vxid: txid:0] []LOG: entering standby mode
2012-03-23 03:08:53.905 MSK 55096 @ from [vxid:1/0 txid:0] []LOG: redo starts at 44E/114060E8
2012-03-23 03:10:08.221 MSK 55096 @ from [vxid:1/0 txid:0] []LOG: consistent recovery state reached at 44E/4E7303B0
2012-03-23 03:10:08.221 MSK 55096 @ from [vxid:1/0 txid:0] []LOG: invalid resource manager ID 128 at 44E/4E7303B0
2012-03-23 03:10:08.222 MSK 55093 @ from [vxid: txid:0] []LOG: database system is ready to accept read only connections
2012-03-23 03:10:08.239 MSK 56317 @ from [vxid: txid:0] []LOG: streaming replication successfully connected to primary
Is that warning harmless on 9.0.4 or should I start to worry about?
--
Maxim Boguk
Senior Postgresql DBA.
Phone RU: +7 910 405 4718
Phone AU: +61 45 218 5678
Skype: maxim.boguk
Jabber: maxim.boguk@gmail.com
LinkedIn profile: http://nz.linkedin.com/in/maximboguk
"If they can send one man to the moon... why can't they send them all?"
МойКруг: http://mboguk.moikrug.ru/
"People problems are solved with people.
If people cannot solve the problem, try technology.
People will then wish they'd listened at the first stage."