"Compressed data is corrupt"

From: Matthias Leisi <matthias(at)leisi(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: "Compressed data is corrupt"
Date: 2012-03-01 14:18:40
Message-ID: CALgnk9rw3DsaQ9RoSAsMJpz08iimKtevBhLFzNws9dF3puFVdA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a behaviour of Postgres which I do not understand (and thus can
not fix...). When inserting into a log-like table, I get the error
message "compressed data is corrupt" for certain (rare) combination of
values. When I re-create the same table structure from scratch and
insert the same data in to that table, the error does not appear.

Situation which triggers the error:

dnswl=# \d+ requesthistory
Table "public.requesthistory"
Column | Type | Modifiers |
Storage | Description
-----------------+------------------------+--------------------+----------+-------------
requestip | inet | not null | main |
requesthostname | character varying(255) | not null | extended |
requestdate | date | not null | plain |
requestcount | integer | not null default 0 | plain |
Indexes:
"requesthistory_pkey" PRIMARY KEY, btree (requestip, requestdate)
Has OIDs: no
dnswl=# insert into requesthistory values ('209.166.168.6',
'myhostname', '2012-02-29', 23);
ERROR: compressed data is corrupt

Situation which does not lead to the error:

dnswl=# \d+ testip
Table "public.testip"
Column | Type | Modifiers | Storage | Description
----------+------------------------+--------------------+----------+-------------
ip | inet | not null | main |
hostname | character varying(255) | not null | extended |
mydate | date | not null | plain |
count | integer | not null default 0 | plain |
Indexes:
"testip_pkey" PRIMARY KEY, btree (ip, mydate)
Has OIDs: no
dnswl=# insert into testip values ('209.166.168.6', 'myhostname',
'2012-02-29', 23);
INSERT 0 1

Changing the hostname, date or count fields does not change the
situation. Changing the IP address slightly (eg from "..6" to "..5")
makes the error disappear.

Any clue what may be going on? Any more things I should try and test?

Running Postgresql 8.4.7 on an openSuSE machine (64bit).

-- Matthias

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2012-03-01 14:47:17 Re: Allowed DML on replicas?
Previous Message Vincent de Phily 2012-03-01 14:14:27 Re: Privilege on schema 'public' not revokable