[Taginfo-dev] no such table: projects.project_unique_keys on an old instance

[Marc_marc]

Hello Jochen,

No, the file selection.db doesn't exist in the server
the only line about selection.bd is that the file doesn't exist
and the next run should solve the problem.
but the next time it's run, it's the same error

Regards,
Marc


Le 25.11.23 à 15:32, Jochen Topf a écrit :
> Hi Marc,
> 
> the first run should create that selection.db and the next run should
> then use it. Do you have the selection.db? Is it in the right place?
> 
> Jochen
> 
> On Fri, Nov 24, 2023 at 07:39:48PM +0100, Marc_marc wrote:
>> Date: Fri, 24 Nov 2023 19:39:48 +0100
>> From: Marc_marc <marc_marc at mailo.com>
>> To: Taginfo-dev <taginfo-dev at openstreetmap.org>
>> Subject: Re: [Taginfo-dev] no such table: projects.project_unique_keys on
>>   an old instance
>>
>> Hello,
>>
>> Thanks for the reply.
>>
>> I have updated taginfo + taginfo-tools + recompile
>> this require sqlite update.
>> sqlite update require os update
>> after that, the previous errors seems gone
>>
>> but now the error is
>> 2023-11-24T18:21:38 | 5 | all | update_source | Running
>> chronology/update.sh...
>> 2023-11-24T18:21:38 | 5 | chronology | main | Start chronology...
>> 2023-11-24T18:21:38 | 5 | chronology | initialize_database | Running SQL
>> script '/data/project/taginfo/taginfo/sources/chronology/../init.sql' on
>> database '/data/work/taginfo/build/chronology/taginfo-chronology.db'...
>> 2023-11-24T18:21:38 | 5 | chronology | initialize_database | Running SQL
>> script '/data/project/taginfo/taginfo/sources/chronology/pre.sql' on
>> database '/data/work/taginfo/build/chronology/taginfo-chronology.db'...
>> 2023-11-24T18:21:38 | 5 | chronology | run_chronology | Selection database
>> '/data/work/taginfo/build/chronology/../selection.db' not found. Not
>> creating some statistics.
>> 2023-11-24T18:21:38 | 5 | chronology | run_chronology |   The next taginfo
>> update should automatically correct this.
>>
>> running it again, as adviced by the log, doesn't solve the issue
>>
>> Regards,
>> Marc
>>
>> Le 21.11.23 à 09:12, Jochen Topf a écrit :
>>> Hi!
>>>
>>> the table project_unique_keys moved from the projects to the master db.
>>> Please update your taginfo to the tag "osmorg-taginfo-live" from the
>>> repo. That is the version running on the OSMF servers and everybody
>>> should keep up with that version.
>>>
>>> Jochen
>>>
>>> On Mon, Nov 20, 2023 at 11:04:08PM +0100, Marc_marc wrote:
>>>> Date: Mon, 20 Nov 2023 23:04:08 +0100
>>>> From: Marc_marc <marc_marc at mailo.com>
>>>> To: Taginfo-dev <taginfo-dev at openstreetmap.org>
>>>> Subject: [Taginfo-dev] no such table: projects.project_unique_keys on an
>>>>    old instance
>>>>
>>>> Hello,
>>>>
>>>> The instance of osm-fr is running with last commit on Nov 26 2020
>>>> the instance has the following error:
>>>>
>>>> 2023-11-20 06:17:23+01:00 DEBUG: before update_all.sh
>>>> 2023-11-20 06:32:21+01:00 ERROR: ./update_all.sh /data/work/taginfo/build
>>>>
>>>> last 5 lines from /data/work/taginfo/build/log/20231120T0617.log
>>>> 2023-11-20T06:32:12 | 14 | master | main | Start master...
>>>> 2023-11-20T06:32:12 | 14 | master | create_master_database | Running SQL
>>>> script '/data/project/taginfo/taginfo/sources/master/languages.sql' on
>>>> database '/data/work/taginfo/build/taginfo-master.db'...
>>>> 2023-11-20T06:32:12 | 14 | master | create_master_database | Running SQL
>>>> script '/data/project/taginfo/taginfo/sources/master/master.sql' on database
>>>> '/data/work/taginfo/build/taginfo-master.db'...
>>>> 2023-11-20T06:32:12 | 14 | master | create_master_database |   with
>>>> parameter: DIR=/data/work/taginfo/build
>>>> Error: near line 55: no such table: projects.project_unique_keys
>>>>
>>>> any tips to solve that ?
>>>>
>>>> Regards,
>>>> Marc