From: | Maxim Boguk <maxim(dot)boguk(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Question about warning: "invalid resource manager ID 128 at ..." on hot stanby |
Date: | 2012-03-22 23:34:43 |
Message-ID: | CAK-MWwT6j5ks8PEJ14t+f1m_kv88dMKFqW_XzvezZBzn54_gBQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)boguk(at)gmail(dot)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."
From | Date | Subject | |
---|---|---|---|
Next Message | Gauthier, Dave | 2012-03-23 02:03:16 | Is record handle available to a check constraint stored procedure call? |
Previous Message | Tom Lane | 2012-03-22 22:09:25 | Re: Index on System Table |