Nominatim update sequence id 103002

[MALKARAJ]

Hi Team,

Nominatim update issue couldn't pass the sequence id after(103002) I have attached the screenshot of the issues.

2024-07-28 19:00:01: Using project directory: /nominatim 2024-07-28 19:00:01: Using project directory: /nominatim 2024-07-28 19:00:01: Initialising replication updates 2024-07-28 19:00:04: Updates initialised at sequence 103002 (2024-06-13 01:33:38+00:00) 2024-07-28 19:00:04: Create functions Traceback (most recent call last): File "/usr/local/bin/nominatim", line 14, in <module> exit(cli.nominatim(module_dir='/usr/local/lib/nominatim/module', File "/usr/local/lib/nominatim/lib-python/nominatim/cli.py", line 264, in nominatim return parser.run(**kwargs) File "/usr/local/lib/nominatim/lib-python/nominatim/cli.py", line 126, in run return args.command.run(args) File "/usr/local/lib/nominatim/lib-python/nominatim/clicmd/replication.py", line 196, in run self._update(args) File "/usr/local/lib/nominatim/lib-python/nominatim/clicmd/replication.py", line 153, in _update state = replication.update(conn, params, socket_timeout=args.socket_timeout) File "/usr/local/lib/nominatim/lib-python/nominatim/tools/replication.py", line 133, in update run_osm2pgsql_updates(conn, options) File "/usr/local/lib/nominatim/lib-python/nominatim/tools/replication.py", line 148, in run_osm2pgsql_updates cur.execute('TRUNCATE place_to_be_deleted') File "/usr/local/lib/nominatim/lib-python/nominatim/db/connection.py", line 36, in execute super().execute(query, args) File "/usr/lib/python3/dist-packages/psycopg2/extras.py", line 146, in execute return super().execute(query, vars) psycopg2.errors.LockNotAvailable: canceling statement due to lock timeout

Thanks

[lonvia]

You have killed an update process and not properly cleaned the remains, also see #3445 (comment).

Stop update, restart Postgresql, restart updates.