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

[Jochen Topf]

Hi Marc,

The selection.db should be generated by the sources/master/update.sh
script. You should see that being run later in your log. Can you post
your complete log?

Jochen

On Sat, Nov 25, 2023 at 07:15:09PM +0100, Marc_marc wrote:
> Date: Sat, 25 Nov 2023 19:15:09 +0100
> From: Marc_marc <marc_marc at mailo.com>
> To: Jochen Topf <jochen at remote.org>
> Cc: Taginfo-dev <taginfo-dev at openstreetmap.org>
> Subject: Re: [Taginfo-dev] no such table: projects.project_unique_keys on
>  an old instance
> 
> 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
> 
> 

-- 
Jochen Topf  jochen at remote.org  https://www.jochentopf.com/  +49-351-31778688