feludwig / pgsql2osm Goto Github PK

INFO: detected middle database layout: legacy text[]
[ 1/5 start ] 2023-11-01_17:08:26
[ 2/5 within ] public.berlin_point row 907159 / 907159 100.0%
[ 2/5 within ] 907159 nodes within bounds
[ 2/5 within ] public.berlin_polygon row 637792 / 637792 100.0%
[ 2/5 within ] 632435 ways, 4931 rels from public.berlin_polygon
[ 2/5 within ] public.berlin_line row 427682 / 427682 100.0%
[ 2/5 within ] 1042324 ways, 6516 rels within bounds
[ 3/5 children ] 3 nodes, 13540 ways, 0 rels children of rel 6516 / 6516 100.0%
[ 3/5 children ] 8365309 nodes children of way 1051796 / 1051796 100.0%
[ 4/5 parents ] checking parent ways of 907159 nodes
Traceback (most recent call last):
File "/home/jaswanth/Desktop/SouthIndia/Package/pgsql2osm.py", line 1202, in
s.main()
File "/home/jaswanth/Desktop/SouthIndia/Package/pgsql2osm.py", line 306, in main
t=asyncio.run(stream_osm_xml(self))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/asyncio/runners.py", line 190, in run
return runner.run(main)
^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/asyncio/runners.py", line 118, in run
return self._loop.run_until_complete(task)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/asyncio/base_events.py", line 653, in run_until_complete
return future.result()
^^^^^^^^^^^^^^^
File "/home/jaswanth/Desktop/SouthIndia/Package/pgsql2osm.py", line 698, in stream_osm_xml
nodes_parent_wr(s,a,only_nodes_within=True)
File "/home/jaswanth/Desktop/SouthIndia/Package/pgsql2osm.py", line 514, in nodes_parent_wr
for node_c,way_ids,rel_ids in a.g_adaptive_parent_multiquery(nodes_name,s.c,
File "/home/jaswanth/Desktop/SouthIndia/Package/pgsql2osm.py", line 52, in g_adaptive_parent_multiquery
c.execute("SET statement_timeout='30s';")
psycopg2.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block.

Changed the timeout also, but getting the same error. Can you provide any assistance.