From: | "Gautam Sampathkumar" <gsampathkumar(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | "relation deleted while in use" encountered with Postgresql 8.0.8 |
Date: | 2007-11-29 22:44:25 |
Message-ID: | 9c2b3cc80711291444q50707963m2e13f1f65cc72808@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I'm using a python script w/ the PyGreSQL library to insert 1 billion rows
into a database table for an experiment (performing a commit every 10K
rows). My script failed at about 170M rows with the following exception:
File "/usr/lib64/python2.3/site-packages/pgdb.py", line 163, in execute
self.executemany(operation, (params,))
File "/usr/lib64/python2.3/site-packages/pgdb.py", line 185, in
executemany
raise DatabaseError, "error '%s' in '%s'" % ( msg, sql )
pg.DatabaseError: error 'ERROR: relation 184577 deleted while still in use
' in 'INSERT INTO nfs_files_10 (mxid, fhInode, fhGen, fhSnapId, fhFlags,
name, parentInode, parentGen, parentSnapId, parentFlags, extension, type,
atime, mtime, fileSize, owner, generation) VALUES (10, 120, 927370846, 0, 0,
'gummy0.txt', 1204041, 927370729, 0, 0, 'txt', 0, 1112147234, 1112147234,
40960, NULL, 2);'
After this error, my database table no longer exists and appeared to have
been dropped, although my script was doing only INSERT statements. Any ideas
on what might be causing this and/or if this a known issue and possible
solutions would be greatly appreciated.
thanks,
Gautam
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Lambert | 2007-11-29 23:11:47 | Re: log_line_prefix='%t %u %d %h %p %i %l %x ' causes error |
Previous Message | Ivan Sergio Borgonovo | 2007-11-29 22:40:59 | Re: \copy ... with null as '' csv doesn't get nulls |