Database corruption caused by long insert strings

From: andrew(at)mycomport(dot)com
To: bugs(at)postgresql(dot)org
Subject: Database corruption caused by long insert strings
Date: 2000-05-03 05:47:15
Message-ID: Pine.LNX.4.21.0005031511350.9137-100000@tzetze.fith.priv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The system: Linux RedHat 6.2, running postgresql 6.5.3 (installed from the
RH 6.2 RPM)

The bug: attempts to insert large strings result in database
corruption. Not only does the attempted insert fail with a "too
large" error, but the table is corrupted, and further accesses can cause
the system to crash.

I originally discovered this bug while accessing the database using Perl,
but managed to replicate the problem using the command-line tools only.

Test case:
Create a database, connect to it using psql.

testdb=>CREATE TABLE test (testcol text);
CREATE
testdb=>INSERT INTO test (testcol) values (<a really long string literal>);
ERROR: Tuple is too big: size 10584

At this point, the database is corrupt. "Vacuum"ing the database will
detect and fix the corruption, but further queries without vacuuming may
cause the system to crash (the postmaster daemon consumes all available
CPU cycles). I have not determined exactly how to trigger this.

Thanks for an (otherwise) excellent product :-)

Andrew Bishop

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2000-05-03 09:07:43 Re: Database corruption caused by long insert strings
Previous Message Rolf C Stadheim 2000-05-01 16:08:03 gmake[3]: *** No rule to make target `page/SUBSYS.o'. Stop. ??????????????????