Hi All,

This is my first post, so I hope I'm in the right area and doing it correctly.

We are having MAJOR & URGENT problems with Postresql occaisonly corrupting tables on insert.  I had a quick look through your archive and couldn't find anything. It seems to happen mostly on large inserts (lots of data into one text field). This results in corrupting the table and hanging the psql console whenever I try to INSERT, UPDATE, DELETE, SELECT, etc. Doing an "EXPLAIN SELECT * FROM table" shows that I have around 100 - 1000 extra rows. The problem is often fixed by running VACUUM against the table, however VACUUM often hangs leaving the table locked until I delete the lock file. 

Its only a basic INSERT statement into a basic table.

Thanks in advance.

Bruce Irvine.
SportingPulse.







Hi All,
 
This is my first post, so I hope I'm in the right 
area and doing it correctly.
 
We are having MAJOR & URGENT problems with 
Postresql occaisonly corrupting tables on insert.  I had a quick look 
through your archive and couldn't find anything. It seems to happen mostly 
on large inserts (lots of data into one text field). This results in 
corrupting the table and hanging the psql console whenever I try to 
INSERT, UPDATE, DELETE, SELECT, etc. Doing an "EXPLAIN SELECT * FROM table" 
shows that I have around 100 - 1000 extra rows. The problem is often fixed by 
running VACUUM against the table, however VACUUM often hangs leaving the table 
locked until I delete the lock file. 
 
Its only a basic INSERT statement into a basic 
table.
 
Thanks in advance.
 
Bruce Irvine.
SportingPulse.
Wed, 6 Jun 2001 09:47:10 +1000
"Bruce Irvine" <b.irvine@sportingpulse.com>
URGENT PROBLEM
How 'bout posting what version of pgsql you're running, and we'll start 
back at square one :)

-d

Bruce Irvine wrote:

> Hi All,
>
>  
>
> This is my first post, so I hope I'm in the right area and doing it 
> correctly.
>
>  
>
> We are having MAJOR & URGENT problems with Postresql occaisonly 
> corrupting tables on insert.  I had a quick look through your archive 
> and couldn't find anything. It seems to happen mostly on large inserts 
> (lots of data into one text field). This results in corrupting the 
> table and hanging the psql console whenever I try to INSERT, UPDATE, 
> DELETE, SELECT, etc. Doing an "EXPLAIN SELECT * FROM table" shows that 
> I have around 100 - 1000 extra rows. The problem is often fixed by 
> running VACUUM against the table, however VACUUM often hangs leaving 
> the table locked until I delete the lock file. 
>
>  
>
> Its only a basic INSERT statement into a basic table.
>
>  
>
> Thanks in advance.
>
>  
>
> Bruce Irvine.
>
> SportingPulse.
>



Tue, 05 Jun 2001 17:08:08 -0700
David Ford <david@blue-labs.org>
Re: URGENT PROBLEM
"Bruce Irvine" <b.irvine@sportingpulse.com> writes:
> We are having MAJOR & URGENT problems with Postresql occaisonly corrupting =
> tables on insert.

Can't help you with that much information.

What Postgres version is this?  (If your answer is not "7.0.3" or
"7.1.2", I'm going to tell you to upgrade before anything else.)

What is the table schema?  What kind of corruption do you see exactly?

			regards, tom lane

Tue, 05 Jun 2001 20:09:53 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: URGENT PROBLEM 