<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi Paul,<div><br></div><div>Just submitted a ticket as you suggested: <a href="http://trac.osgeo.org/postgis/ticket/1903">http://trac.osgeo.org/postgis/ticket/1903</a></div><div>Thanks!</div><div><br><div><div>On 2012-07-04, at 11:46 PM, Paul Ramsey wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>This is all well and good, but we need to know which 300 rows to load.<br>If you have a load file, just strip out the first 301 (or whatever)<br>rows, confirm that the file makes things go "boom" and then create a<br>ticket on the tracker with the dump file attached.<br><br><a href="http://trac.osgeo.org/">http://trac.osgeo.org/</a><br><br>Thanks!<br><br>P.<br><br>On Wed, Jul 4, 2012 at 2:01 AM, René Fournier <m5@renefournier.com> wrote:<br><blockquote type="cite">I've narrowed the point at which a crash will always happen: If I simply<br></blockquote><blockquote type="cite">create the table *without* the index...<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">CREATE INDEX address_location ON addresses USING GIST (location);<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">...it won't crash. (Inserts thousands of rows without a problem.) With that<br></blockquote><blockquote type="cite">index in place, it will always crash after ~300 rows. And here's the log<br></blockquote><blockquote type="cite">when it does crash:<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">LOG: server process (PID 98414) was terminated by signal 11: Segmentation<br></blockquote><blockquote type="cite">fault<br></blockquote><blockquote type="cite">LOG: terminating any other active server processes<br></blockquote><blockquote type="cite">WARNING: terminating connection because of crash of another server process<br></blockquote><blockquote type="cite">DETAIL: The postmaster has commanded this server process to roll back the<br></blockquote><blockquote type="cite">current transaction and exit, because another server process exited<br></blockquote><blockquote type="cite">abnormally and possibly corrupted shared memory.<br></blockquote><blockquote type="cite">HINT: In a moment you should be able to reconnect to the database and<br></blockquote><blockquote type="cite">repeat your command.<br></blockquote><blockquote type="cite">LOG: all server processes terminated; reinitializing<br></blockquote><blockquote type="cite">LOG: database system was interrupted; last known up at 2012-07-04 10:44:15<br></blockquote><blockquote type="cite">CEST<br></blockquote><blockquote type="cite">LOG: database system was not properly shut down; automatic recovery in<br></blockquote><blockquote type="cite">progress<br></blockquote><blockquote type="cite">LOG: redo starts at 0/78E4A50<br></blockquote><blockquote type="cite">LOG: record with zero length at 0/7B52580<br></blockquote><blockquote type="cite">LOG: redo done at 0/7B52540<br></blockquote><blockquote type="cite">LOG: last completed transaction was at log time 2012-07-04<br></blockquote><blockquote type="cite">10:44:40.712517+02<br></blockquote><blockquote type="cite">LOG: database system is ready to accept connections<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">On 2012-07-03, at 6:31 PM, Mark Cave-Ayland wrote:<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">On 03/07/12 13:20, René Fournier wrote:<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">So, it seems that the table gets full and corrupted to some extent.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">After my import script inserts ~290 rows, and then postgres crashes...<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> mydb=# select count(*) from addresses;INSERT INTO addresses (<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> account_id, territory_id, location ) VALUES ( 1, 75,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> ST_GeomFromText('POINT(-114.267388 51.089941)') );<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> count<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> -------<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> 284<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> (1 row)<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> The connection to the server was lost. Attempting reset: Failed.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">So, can't insert any more rows...<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> !> delete from addresses where id > 50;<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> You are currently not connected to a database.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Postgres client/connection is crashed.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> !> \q<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> Tue Jul 03 14:15:28 -- rene /opt/local/var/db:: psql -U postgres<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> mydb psql (9.1.4)<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> Type "help" for help.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> mydb=# delete from addresses where id > 50;<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> DELETE 234<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Deleting rows works...<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> mydb=# select count(*) from addresses;INSERT INTO addresses (<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> account_id, territory_id, location ) VALUES ( 1, 75,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> ST_GeomFromText('POINT(-114.267388 51.089941)') );<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> count<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> -------<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> 50<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> (1 row)<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> The connection to the server was lost. Attempting reset: Failed.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">SELECT and DELETE work, but I can't insert any new rows, until...<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> !> \q<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> Tue Jul 03 14:15:39 -- rene /opt/local/var/db:: psql -U postgres<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> mydb psql (9.1.4)<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> Type "help" for help.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> mydb=# vacuum;vacuum full;vacuum full analyze;<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> VACUUM<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> VACUUM<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> NOTICE: no notnull values, invalid stats<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> VACUUM<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> mydb=# select count(*) from addresses;INSERT INTO addresses (<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> account_id, territory_id, location ) VALUES ( 1, 75,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> ST_GeomFromText('POINT(-114.267388 51.089941)') );<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> count<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> -------<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> 50<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> (1 row)<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> INSERT 0 1<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> mydb=#<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">So, it appears there's some weird corruption going on... Still, not sure<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">what to try next. My PostGIS is via Macports, not sure how to enable the<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">debug mode...<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Hi René,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">I think that you need to create a new bug on the PostGIS bug tracker and<br></blockquote><blockquote type="cite">upload a file that causes the crash on your system, i.e. it can be run using<br></blockquote><blockquote type="cite">"psql -d postgis_db -f crash.sql" so that we can try and reproduce what you<br></blockquote><blockquote type="cite">are seeing.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Also as a matter of interest, do you see anything interesting in the<br></blockquote><blockquote type="cite">PostgreSQL log file at the time of the crash?<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">ATB,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Mark.<br></blockquote><blockquote type="cite">_______________________________________________<br></blockquote><blockquote type="cite">postgis-users mailing list<br></blockquote><blockquote type="cite">postgis-users@postgis.refractions.net<br></blockquote><blockquote type="cite">http://postgis.refractions.net/mailman/listinfo/postgis-users<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">_______________________________________________<br></blockquote><blockquote type="cite">postgis-users mailing list<br></blockquote><blockquote type="cite">postgis-users@postgis.refractions.net<br></blockquote><blockquote type="cite">http://postgis.refractions.net/mailman/listinfo/postgis-users<br></blockquote><blockquote type="cite"><br></blockquote>_______________________________________________<br>postgis-users mailing list<br>postgis-users@postgis.refractions.net<br>http://postgis.refractions.net/mailman/listinfo/postgis-users<br></div></blockquote></div><br></div></body></html>