[Tile-serving] [osm2pgsql-dev/osm2pgsql] Example "public-transport.lua" fails with error: ERROR: Database format for tags invalid. (Issue #2298)

[Tobias G]

<!-- Please don't use screenshots. Copy and paste the *text* output here if that's needed for context. -->

## What version of osm2pgsql are you using?

<!-- Paste output of `osm2pgsql --version` here. Please use the [latest
release](https://osm2pgsql.org/releases/) of osm2pgsql if at all
possible. -->
osm2pgsql version 2.0.1
Build: None
Compiled using the following library versions:
Libosmium 2.20.0
Proj 9.5.1
Lua 5.3.6

## What operating system and PostgreSQL/PostGIS version are you using?
<!-- Also what Linux distribution if applicable, OS version? -->
ubuntu:25.04 on Docker

## Tell us something about your system

<!-- How much RAM do you have, how many CPUs, bare metal or cloud setup? -->
Irrelevant

## What did you do exactly?

<!-- Please provide the command(s) you used including all options etc. Include
links to input files. -->
Using PBF `https://download.geofabrik.de/europe/cyprus-latest.osm.pbf`  to test around with a small dataset
Imported using flex style from examples: [ flex-config/public-transport.lua](https://github.com/osm2pgsql-dev/osm2pgsql/blob/f900e2c3a1309e357377bd0ce97ad10ee8ef61df/flex-config/public-transport.lua)

Command `osm2pgsql --create --slim --database postgresql://osmuser@db/osm --schema public --middle-schema public --output=flex --style=./public-transport.lua --log-progress=true ./data/cyprus-latest.osm.pbf`


## What did you expect to happen?
Data to be imported without issues.

## What did happen instead?

<!-- Please describe what happened and why you think this is wrong. Please include
(or link to, if it is too verbose) the log output. -->
Encountered an error: 
```
2025-01-16 16:08:21  osm2pgsql version 2.0.1
2025-01-16 16:08:22  Database version: 17.2 (Debian 17.2-1.pgdg110+1)
2025-01-16 16:08:22  PostGIS version: 3.5
2025-01-16 16:08:22  Initializing properties table '"public"."osm2pgsql_properties"'.
2025-01-16 16:08:22  Storing properties to table '"public"."osm2pgsql_properties"'.
2025-01-16 16:08:55  Reading input files done in 33s.
2025-01-16 16:08:55    Processed 4167670 nodes in 24s - 174k/s
2025-01-16 16:08:55    Processed 472207 ways in 6s - 79k/s
2025-01-16 16:08:55    Processed 8641 relations in 3s - 3k/s
2025-01-16 16:08:55  Reprocess marked nodes/ways (stage 2)...
2025-01-16 16:08:55  Creating id index on table 'lines'...
2025-01-16 16:08:55  Creating id indexes took 0s
2025-01-16 16:08:55  There are 676 nodes to reprocess...
2025-01-16 16:08:55  ERROR: Database format for tags invalid.
```

## What did you do to try analyzing the problem?

<!-- Describe what steps you already did to try analyzing the problem before
reporting. -->
Looked into the database. 
All tags columns are of type `jsonb``

I was actually working on a different example that failed in the same way. Then I used the example and encountered the same issue.

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

Message ID: <osm2pgsql-dev/osm2pgsql/issues/2298 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20250116/3e236162/attachment.htm>