TIGER import failing, error says "UndefinedTable: relation "location_road_2" does not exist"

[danitheturtle]

I've verified the rest of my database is working as intended. I downloaded TIGER data and compiled it from source, and my CSV files look accurate. I even added some print() statements in the tools/tiger_data.py script to make sure everything was being loaded properly (it was). The only problem is that no data ever makes it into my database. Running SELECT COUNT(*) FROM location_property_tiger_import returns 0 no matter when in the process I query.

To try and debug further, I enabled sql error logging in the tools/tiger_data.py and got this error:

2021-10-09 15:35:33: Using project directory: /srv/nominatim/map-server
2021-10-09 15:35:33: Found 3234 CSV files in path ../TIGER-data/output-data/
Traceback (most recent call last):
  File "/usr/local/bin/nominatim", line 11, in <module>
    exit(cli.nominatim(module_dir='/usr/local/lib/nominatim/module',
  File "/usr/local/lib/nominatim/lib-python/nominatim/cli.py", line 235, in nominatim
    return parser.run(**kwargs)
  File "/usr/local/lib/nominatim/lib-python/nominatim/cli.py", line 96, in run
    return args.command.run(args)
  File "/usr/local/lib/nominatim/lib-python/nominatim/clicmd/add_data.py", line 52, in run
    return tiger_data.add_tiger_data(args.tiger_data,
  File "/usr/local/lib/nominatim/lib-python/nominatim/tools/tiger_data.py", line 100, in add_tiger_data
    handle_threaded_sql_statements(pool, fd, analyzer)
  File "/usr/local/lib/nominatim/lib-python/nominatim/tools/tiger_data.py", line 66, in handle_threaded_sql_statements
    pool.next_free_worker().perform(sql, args=args)
  File "/usr/local/lib/nominatim/lib-python/nominatim/db/async_connection.py", line 180, in next_free_worker
    return next(self.free_workers)
  File "/usr/local/lib/nominatim/lib-python/nominatim/db/async_connection.py", line 188, in _yield_free_worker
    if thread.is_done():
  File "/usr/local/lib/nominatim/lib-python/nominatim/db/async_connection.py", line 138, in is_done
    if self.conn.poll() == psycopg2.extensions.POLL_OK:
psycopg2.errors.UndefinedTable: relation "location_road_2" does not exist
LINE 1: SELECT place_id FROM location_road_2
                             ^
QUERY:  SELECT place_id FROM location_road_2
          WHERE ST_DWithin(line, geometry, search_diameter)
          ORDER BY (ST_distance(geometry, p1)+
                    ST_distance(geometry, p2)+
                    ST_distance(geometry, p3)) ASC limit 1
CONTEXT:  PL/pgSQL function getnearestparallelroadfeature(integer,geometry) line 56 at FOR over SELECT rows
SQL statement "SELECT getNearestParallelRoadFeature(out_partition, linegeo)"
PL/pgSQL function tiger_line_import(geometry,integer,integer,text,jsonb,text) line 60 at SQL statement

My best guess is that I need to import the base nominatim data with an additional parameter I missed somewhere. I ran the import with the settings/import-address.style setting. Thought I'd ask here before deleting my table and trying again.

[lonvia]

Did you use --drop during or after the import?

[danitheturtle]

ah I see, so I can't do a static database import (not planning to update, just need the dataset once) and then import the tiger data, I have to set up the database for updates, import TIGER, and then drop?

[lonvia]

Yes, exactly. That's how it works at the moment. I can see where this is rather annoying. And thinking about it, we have the search_name table it can use instead. It will be a bit slower but definitely faster than doing a reimport. Let me open an issue for that...

[lonvia]

There we go: #2463