Skip to content

Import Failed :- psycopg.errors.InternalError_: cache lookup failed for function 12196315 #642

@MALKARAJ

Description

@MALKARAJ

Describe the bug
getting import error psycopg.errors.InternalError_: cache lookup failed for function 12196315

To Reproduce
Steps to reproduce the behavior:

  1. when try to import the data during the setup process

Expected behavior
1.complete the import process without any breaksage

Screenshots & Logs
2025-12-29 20:00:23: Done 42622195 in 42272 @ 1008.278 per second - rank 26 ETA (seconds): 63491.05
2025-12-29 20:00:24: Done 42623205 in 42273 @ 1008.279 per second - rank 26 ETA (seconds): 63489.99
2025-12-29 20:00:24: Done 42624210 in 42273 @ 1008.303 per second - rank 26 ETA (seconds): 63487.52
2025-12-29 20:00:24: Done 42625220 in 42273 @ 1008.325 per second - rank 26 ETA (seconds): 63485.10
2025-12-29 20:00:24: Done 42626225 in 42273 @ 1008.348 per second - rank 26 ETA (seconds): 63482.67
Traceback (most recent call last):
File "/usr/local/bin/nominatim", line 5, in
exit(cli.nominatim())
^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/dist-packages/nominatim_db/cli.py", line 244, in nominatim
return get_set_parser().run(cli_args=cli_args, environ=environ)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/dist-packages/nominatim_db/cli.py", line 116, in run
return args.command.run(args)
^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/dist-packages/nominatim_db/clicmd/setup.py", line 82, in run
return asyncio.run(self.async_run(args))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.12/asyncio/runners.py", line 194, in run
return runner.run(main)
^^^^^^^^^^^^^^^^
File "/usr/lib/python3.12/asyncio/runners.py", line 118, in run
return self._loop.run_until_complete(task)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.12/asyncio/base_events.py", line 687, in run_until_complete
return future.result()
^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/dist-packages/nominatim_db/clicmd/setup.py", line 121, in async_run
await indexer.index_full(analyse=not args.index_noanalyse)
File "/usr/local/lib/python3.12/dist-packages/nominatim_db/indexer/indexer.py", line 68, in index_full
if await self.index_by_rank(26, 30) > 1000:
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/dist-packages/nominatim_db/indexer/indexer.py", line 147, in index_by_rank
total += await self._index(runners.RankRunner(rank, analyzer),
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/dist-packages/nominatim_db/indexer/indexer.py", line 199, in index
async for place in cur.stream(runner.sql_get_objects()):
File "/usr/local/lib/python3.12/dist-packages/psycopg/cursor_async.py", line 179, in stream
raise ex.with_traceback(None)
psycopg.errors.InternalError
: cache lookup failed for function 12196315

Desktop / Server (please complete the following information):

  • OS & Version:
    NAME="Debian GNU/Linux"
    VERSION_ID="12"
    VERSION="12 (bookworm)"
  • Docker Version: Docker version 20.10.14, build a224086
  • Nominatim Version: 5.2.0

Additional context
Add any other context about the problem here.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions