PD_ALL_VISIBLE flag warnings
hello to all,
the last few days i have observed tons of msgs like the above on a db server
of ours. i have searched a lot on the internet but didn't find much relevant
information. i read that this could mean some kind of serious data
corruption, but didn't find more info in this direction. on the other hand i
read that this could originate from some hardware failure. i dont think that
this is the case (in our case) b/c on the same server there is another db
(much bigger than this one) and i dont find any messages like that in the
logs. these messages are about many tables of a specific database of the
server.
the server is 8.4.7. i dont know what kind of information i could provide to
you, in order to get some help, so please tell me what kind of info/stats i
could provide so that eventually the true meaning of these messages can be
found. thx in advanced
--
View this message in context: http://postgresql.1045698.n5.nabble.com/PD-ALL-VISIBLE-flag-warnings-tp4692473p4692473.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
On 12/08/2011 4:13 PM, MirrorX wrote:
hello to all,
the last few days i have observed tons of msgs like the above on a db server
of ours.
Please include the full text of the error from the server logs.
the server is 8.4.7. i dont know what kind of information i could provide to
you, in order to get some help
Thanks for asking! There's a list of the sorts of things you can collect
here:
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
that might help out.
Also, you're running an old patch release. The first thing you should do
is update to PostgreSQL 8.3.15 .
--
Craig Ringer
i wiil provide some info in case it is helpful
-the error msg is -> WARNING: PD_ALL_VISIBLE flag was incorrectly set in
relation "summary_data" page 54
(the same thing appears for many tables and many pages on each table)
-in my internet searching i found some cases where this issue was related to
vacuum operations. in this server, autovacuum is on and working on these
tables (since there are updates/deletes there). would it help to turn
autovacuum off, run manually vacuums once a day (to those tables needing it,
which is determined by the system params) and check the logs?
what is strange, is that these messages appear only on 1 db of the server,
tha smallest one. and never for the other
--
View this message in context: http://postgresql.1045698.n5.nabble.com/PD-ALL-VISIBLE-flag-warnings-tp4692473p4692566.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
On Friday, August 12, 2011 2:01:19 am MirrorX wrote:
i wiil provide some info in case it is helpful
-the error msg is -> WARNING: PD_ALL_VISIBLE flag was incorrectly set in
relation "summary_data" page 54
(the same thing appears for many tables and many pages on each table)-in my internet searching i found some cases where this issue was related
to vacuum operations. in this server, autovacuum is on and working on
these tables (since there are updates/deletes there). would it help to
turn autovacuum off, run manually vacuums once a day (to those tables
needing it, which is determined by the system params) and check the logs?what is strange, is that these messages appear only on 1 db of the server,
tha smallest one. and never for the other
By any chance have you used pg_upgrade to populate the database? See the these
messages for something similar:
http://archives.postgresql.org/pgsql-general/2011-04/msg00112.php
http://archives.postgresql.org/pgsql-general/2011-04/msg00353.php
The second message contains a link to the fix which is included in 8.4.8+.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/PD-ALL-VISIBLE-flag-warnings-tp469
2473p4692566.html Sent from the PostgreSQL - general mailing list archive
at Nabble.com.
--
Adrian Klaver
adrian.klaver@gmail.com
MirrorX <mirrorx@gmail.com> writes:
the last few days i have observed tons of msgs like the above on a db server
of ours. i have searched a lot on the internet but didn't find much relevant
information.
the server is 8.4.7.
These are almost certainly not something to worry about. See this 8.4.8
patch:
If you still see it after updating to 8.4.8, we'd like to know, though.
regards, tom lane
thx a lot for the answers
we will upgrade to 8.4.8 and i will monitor the situation :)
--
View this message in context: http://postgresql.1045698.n5.nabble.com/PD-ALL-VISIBLE-flag-warnings-tp4692473p4697106.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.