On Wed, Dec 16, 2015 at 9:48 PM, Victor Blomqvist wrote:
> From time to time I get this and similar errors in my Postgres log file:
>
> < 2015-12-17 07:45:05.976 CST >ERROR: index
> "user_pictures_picture_dhash_idx" contains unexpected zero page at block
> 123780
> < 2015-12-17 07:45:05.976 CST >
Sorry, I should have included the index definition, its a normal btree
index on a bigint column:
CREATE INDEX user_pictures_picture_dhash_idx
ON user_pictures
USING btree
(picture_dhash);
And the table itself:
CREATE TABLE user_pictures (picture_dhash bigint)
(and ~10 other columns not rele
Victor Blomqvist writes:
>> From time to time I get this and similar errors in my Postgres log file:
> < 2015-12-17 07:45:05.976 CST >ERROR: index
> "user_pictures_picture_dhash_idx" contains unexpected zero page at block
> 123780
Hm, can't tell for sure from the error message text, but the inde
>From time to time I get this and similar errors in my Postgres log file:
< 2015-12-17 07:45:05.976 CST >ERROR: index
"user_pictures_picture_dhash_idx" contains unexpected zero page at block
123780
< 2015-12-17 07:45:05.976 CST >HINT: Please REINDEX it.
< 2015-12-17 07:45:05.976 CST >CONTEXT: P
Le 2014-07-04 à 14:42, François Beausoleil a écrit :
> Hi,
>
> I ran a query on the slave and got the error message in the subject. I
> rebuilt the slave two days ago on ZFS (with compression). I’m wondering how
> that unexpected zero page happened in the first place.
>
> Master:
> Linux kal
Hi,
I ran a query on the slave and got the error message in the subject. I rebuilt
the slave two days ago on ZFS (with compression). I’m wondering how that
unexpected zero page happened in the first place.
Master:
Linux kalanchoe 3.2.0-58-generic #88-Ubuntu SMP Tue Dec 3 17:37:58 UTC 2013
x86_
