Skip to content

Postgres coredump with exit code 250

I assume 250 is the same as 25000

The code I run on is

POSTGIS="3.2.0dev 3.1.0rc1-398-g9ee72d5cb" [EXTENSION] PGSQL="120" GEOS="3.9.0-CAPI-1.16.2" PROJ="7.2.1" LIBXML="2.9.10" LIBJSON="0.13.1" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)" TOPOLOGY (1 row)

(INVALID TRANSACTION STATE https://docstore.mik.ua/manuals/sql/postgresql-8.2.6/errcodes-appendix.html )

Here the log and there I find this

SELECT: MonotoneChainBuilder.cpp:76: static std::size_t geos::index::chain::MonotoneChainBuilder::findChainEnd(const geos::geom::CoordinateSequence&, std::size_t): Assertion `start < npts' failed.

This seems to be sama as this case

NOTICE:  For lockid a20b99e4-6ecc-11ec-8f38-6b0a9b1110b0 num rows num_rows_intersecting 0 ok_to_update t running_jobs 0 with _bbox_area_to_update 0103000020A21000000100000005000000F5D25BF955BC2640EA68F73FD0BF4D40F5D25BF955BC264030FA5F56F6C04D40BE7B1B4017C9264030FA5F56F6C04D40BE7B1B4017C92640EA68F73FD0BF4D40F5D25BF955BC2640EA68F73FD0BF4D40
2022-01-06 08:42:51.620 UTC [761150] topo_rein_crud1@ar5ngis_utv_ws LOG:  statement: select topo_ar5ngis.post_check_lock_area('a20b99e4-6ecc-11ec-8f38-6b0a9b1110b0','0103000020A21000000100000005000000A98F7BBFF29C26409C6B65212BB64D40A98F7BBFF29C2640AD46F49A16C74D40E8805A2FD9F02640AD46F49A16C74D40E8805A2FD9F026409C6B65212BB64D40A98F7BBFF29C26409C6B65212BB64D40')
2022-01-06 08:42:51.638 UTC [761015] topo_rein_crud1@ar5ngis_utv_ws LOG:  execute S_1: COMMIT
2022-01-06 08:42:51.649 UTC [761015] topo_rein_crud1@ar5ngis_utv_ws LOG:  execute S_2: BEGIN
2022-01-06 08:42:51.649 UTC [761015] topo_rein_crud1@ar5ngis_utv_ws LOG:  execute S_3: SET pgtopo_update.session_id = '9C3B54A3749E8E5CB9DA54BB5CE4966B'
2022-01-06 08:42:51.651 UTC [761015] topo_rein_crud1@ar5ngis_utv_ws LOG:  execute S_4: SET pgtopo_update.draw_line_opr = '0'
2022-01-06 08:42:51.652 UTC [761015] topo_rein_crud1@ar5ngis_utv_ws LOG:  execute <unnamed>: select * from topo_update.query_to_topojson($1,$2,$3,$4,$5,$6) as result
2022-01-06 08:42:52.040 UTC [761015] topo_rein_crud1@ar5ngis_utv_ws LOG:  execute S_1: COMMIT
2022-01-06 08:42:52.057 UTC [761015] topo_rein_crud1@ar5ngis_utv_ws LOG:  execute <unnamed>: SELECT * FROM topo_ar5ngis.nodes_3_more_surface_split($1,$2)
2022-01-06 08:43:11.734 UTC [761015] topo_rein_crud1@ar5ngis_utv_ws LOG:  execute S_2: BEGIN
2022-01-06 08:43:11.734 UTC [761015] topo_rein_crud1@ar5ngis_utv_ws LOG:  execute S_3: SET pgtopo_update.session_id = '9C3B54A3749E8E5CB9DA54BB5CE4966B'
2022-01-06 08:43:11.736 UTC [761015] topo_rein_crud1@ar5ngis_utv_ws LOG:  execute S_4: SET pgtopo_update.draw_line_opr = '0'
2022-01-06 08:43:11.737 UTC [761015] topo_rein_crud1@ar5ngis_utv_ws LOG:  execute <unnamed>: SET pgtopo_update.draw_line_opr = '1'
2022-01-06 08:43:11.739 UTC [761015] topo_rein_crud1@ar5ngis_utv_ws LOG:  execute S_3: SET pgtopo_update.session_id = '9C3B54A3749E8E5CB9DA54BB5CE4966B'
2022-01-06 08:43:11.741 UTC [761015] topo_rein_crud1@ar5ngis_utv_ws LOG:  execute S_4: SET pgtopo_update.draw_line_opr = '0'
2022-01-06 08:43:11.743 UTC [761015] topo_rein_crud1@ar5ngis_utv_ws LOG:  execute <unnamed>: select * from topo_ar5ngis.add_border($1,$2) as result
2022-01-06 08:43:11.786 UTC [761155] topo_rein_crud1@ar5ngis_utv_ws LOG:  statement: select topo_ar5ngis.pre_check_lock_area('ae442cc6-6ecc-11ec-8f39-33a52b0a48ad','0103000020A210000001000000050000007B4369F0B5C526409173EB0F52C04D407B4369F0B5C526406B8B780653C04D40E7654D84BDC526406B8B780653C04D40E7654D84BDC526409173EB0F52C04D407B4369F0B5C526409173EB0F52C04D40')
NOTICE:  For lockid ae442cc6-6ecc-11ec-8f39-33a52b0a48ad num rows num_rows_intersecting 0 ok_to_update t running_jobs 0 with _bbox_area_to_update 0103000020A210000001000000050000007B4369F0B5C526409173EB0F52C04D407B4369F0B5C526406B8B780653C04D40E7654D84BDC526406B8B780653C04D40E7654D84BDC526409173EB0F52C04D407B4369F0B5C526409173EB0F52C04D40
d1 ar5ngis_utv_ws 128.39.99.90(58368) SELECT: MonotoneChainBuilder.cpp:76: static std::size_t geos::index::chain::MonotoneChainBuilder::findChainEnd(const geos::geom::CoordinateSequence&, std::size_t): Assertion `start < npts' failed.
2022-01-06 08:43:11.854 UTC [615047] LOG:  server process (PID 761015) exited with exit code 250
2022-01-06 08:43:11.854 UTC [615047] LOG:  terminating any other active server processes
2022-01-06 08:43:11.854 UTC [761016] topo_rein_crud1@ar5ngis_utv_ws WARNING:  terminating connection because of crash of another server process
2022-01-06 08:43:11.854 UTC [760797] topo_rein_crud1@ar5ngis_test_ws WARNING:  terminating connection because of crash of another server process
2022-01-06 08:43:11.854 UTC [761017] topo_rein_crud1@ar5ngis_utv_ws WARNING:  terminating connection because of crash of another server process
2022-01-06 08:43:11.854 UTC [760977] topo_rein_crud1@ar5ngis_test_ws WARNING:  terminating connection because of crash of another server process
2022-01-06 08:43:11.854 UTC [760976] topo_rein_crud1@ar5ngis_test_ws WARNING:  terminating connection because of crash of another server process
2022-01-06 08:43:11.854 UTC [760917] topo_rein_crud1@ar5ngis_test_ws WARNING:  terminating connection because of crash of another server process
2022-01-06 08:43:11.854 UTC [691351] WARNING:  terminating connection because of crash of another server process
2022-01-06 08:43:11.854 UTC [760862] topo_rein_crud1@ar5ngis_test_ws WARNING:  terminating connection because of crash of another server process
2022-01-06 08:43:11.854 UTC [760863] topo_rein_crud1@ar5ngis_test_ws WARNING:  terminating connection because of crash of another server process
2022-01-06 08:43:11.870 UTC [761156] topo_rein_crud1@ar5ngis_utv_ws FATAL:  the database system is in recovery mode
2022-01-06 08:43:11.879 UTC [615047] LOG:  all server processes terminated; reinitializing
2022-01-06 08:43:13.038 UTC [761158] LOG:  database system was interrupted; last known up at 2022-01-06 08:28:37 UTC
2022-01-06 08:43:13.038 UTC [761159] topo_rein_crud1@ar5ngis_utv_ws FATAL:  the database system is in recovery mode
2022-01-06 08:43:13.199 UTC [761158] LOG:  database system was not properly shut down; automatic recovery in progress
2022-01-06 08:43:13.205 UTC [761158] LOG:  redo starts at 8C/BD7D6C08
2022-01-06 08:43:14.041 UTC [761161] topo_rein_crud1@ar5ngis_utv_ws FATAL:  the database system is in recovery mode
2022-01-06 08:43:14.497 UTC [761158] LOG:  redo done at 8C/BF5792F0
2022-01-06 08:43:14.668 UTC [615047] LOG:  database system is ready to accept connections
2022-01-06 08:43:15.054 UTC [761168] topo_rein_crud1@ar5ngis_utv_ws LOG:  execute <unnamed>: SET extra_float_digits = 3
2022-01-06 08:43:15.055 UTC [761168] topo_rein_crud1@ar5ngis_utv_ws LOG:  execute <unnamed>: SET application_name = 'PostgreSQL JDBC Driver'
2022-01-06 08:43:15.056 UTC [761168] topo_rein_crud1@ar5ngis_utv_ws LOG:  execute <unnamed>: SHOW TRANSACTION ISOLATION LEVEL
2022-01-06 08:44:14.759 UTC [761303] LOG:  autovacuum: dropping orphan temp table "ar5ngis_utv_ws.pg_temp_9.temp_result"

Edited by Lars Aksel Opsahl