osm-fr / osmose-frontend

Part of osmose that shows results on the website http://osmose.openstreetmap.fr
GNU General Public License v3.0
41 stars 38 forks source link

Python exception when opening a history graph #447

Open flacombe opened 1 year ago

flacombe commented 1 year ago

Hello

When accessing history graph from that source https://osmose.openstreetmap.fr/fr/issues/open?source=409598

At the URL https://osmose.openstreetmap.fr/fr/issues/graph.png?source=409598

I got the following output:

Traceback (most recent call last):
  File "/data/project/osmose/frontend/web_api/issues.py", line 30, in graph
    data = await errors_graph.make_plt(db, params, format)
  File "/data/project/osmose/frontend/web_api/errors_graph.py", line 193, in make_plt
    data = await get_data(db, params)
  File "/data/project/osmose/frontend/web_api/errors_graph.py", line 82, in get_data
    for r in await db.fetch(sql, *sql_params):
  File "/data/project/osmose/frontend/osmose-frontend-venv/lib/python3.9/site-packages/asyncpg/connection.py", line 620, in fetch
    return await self._execute(
  File "/data/project/osmose/frontend/osmose-frontend-venv/lib/python3.9/site-packages/asyncpg/connection.py", line 1658, in _execute
    result, _ = await self.__execute(
  File "/data/project/osmose/frontend/osmose-frontend-venv/lib/python3.9/site-packages/asyncpg/connection.py", line 1683, in __execute
    return await self._do_execute(
  File "/data/project/osmose/frontend/osmose-frontend-venv/lib/python3.9/site-packages/asyncpg/connection.py", line 1710, in _do_execute
    stmt = await self._get_statement(
  File "/data/project/osmose/frontend/osmose-frontend-venv/lib/python3.9/site-packages/asyncpg/connection.py", line 397, in _get_statement
    statement = await self._protocol.prepare(
  File "asyncpg/protocol/protocol.pyx", line 168, in prepare
asyncpg.exceptions.UndefinedColumnError: column markers.item does not exist

Sounds like a column or more is missing

All the best