[Tile-serving] [osm2pgsql-dev/osm2pgsql] osm2pgsql immediately crashes (Discussion #2326)

[majesticpdx]

Hello, 

I have spent the several hours trying to troubleshoot this crash, I'm not sure if this is a bug or something I am doing wrong:

`osm2pgsql -c -d Dev -U XXXXX -H XXXXX -W -O Flex -S "C:\osm2pgsql-latest-x64\osm2pgsql-bin\flex-config\simple.lua" "C:\GIS\Workspace\osm-raw\puerto-rico-latest.osm.pbf"`

osm2pgsql: 2.1.1 Database version: 17.4 PostGIS version: 3.5
Windows 11 Pro Version 24H2
13th Gen Intel(R) Core(TM) i7-13700HX   2.10 GHz
64.0 GB (63.7 GB usable)
C Drive: 1TB (677 Available) / D Drive: 4TB (3.69 TB Available)

This occurs will all lua files and different variations and syntax. I've also attempted on multiple DBs, including newly created, with POSTGIS installed, with and without HSTORE installed. I've also attempted this form both C and D drives just to rule out any storage issues.

One workaround that does work, is using version 1.5 and below and a .style file, however, it a better idea to use Flex and Lua.


The only logs that are showing any information:

```
2025-05-02 06:09:29  osm2pgsql version 2.1.1
2025-05-02 06:09:29  [00] SQL: (C0) SELECT pg_backend_pid()
2025-05-02 06:09:29  [00] SQL: (C0) New database connection (context=check, backend_pid=9268)
2025-05-02 06:09:29  [00] SQL: (C0) SET synchronous_commit = off
2025-05-02 06:09:29  [00] SQL: (C0) SELECT name, setting FROM pg_catalog.pg_settings
2025-05-02 06:09:29  [00] SQL: (C0) SELECT current_catalog
2025-05-02 06:09:29  [00] SQL: (C0) SELECT regexp_split_to_table(extversion, '\.') FROM pg_catalog.pg_extension WHERE extname='postgis'
2025-05-02 06:09:29  [00] Database version: 17.4
2025-05-02 06:09:29  [00] PostGIS version: 3.5
2025-05-02 06:09:29  [00] SQL: (C0) SELECT extname FROM pg_catalog.pg_extension WHERE true
2025-05-02 06:09:29  [00] SQL: (C0) SELECT nspname FROM pg_catalog.pg_namespace WHERE nspname !~ '^pg_' AND nspname <> 'information_schema'
2025-05-02 06:09:29  [00] SQL: (C0) SELECT spcname FROM pg_catalog.pg_tablespace WHERE spcname != 'pg_global'
2025-05-02 06:09:29  [00] SQL: (C0) SELECT amname FROM pg_catalog.pg_am WHERE amtype = 'i'
2025-05-02 06:09:29  [00] SQL: (C0) SELECT schemaname || '.' || tablename FROM pg_catalog.pg_tables WHERE schemaname NOT IN ('pg_catalog', 'information_schema')
2025-05-02 06:09:29  [00] Found properties table 'osm2pgsql_properties': false.
2025-05-02 06:09:29  [00] Reading file: C:\GIS\Workspace\osm-raw\puerto-rico-latest.osm.pbf
2025-05-02 06:09:29  [00] Started pool with 4 threads.
```

Thanks again for your help.

-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2326
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2326 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20250503/a20bd762/attachment.htm>