[Taginfo-dev] Problem updating to latest taginfo

[Shaun McDonald]

Hi Jochen,

I’m updating the GB taginfo to the latest OS (from Ubuntu LTS 18.04 to 20.04) and taginfo code. 

I’m using nginx and passenger and getting the following error:

[ E 2020-12-30 16:56:06.4398 39087/T8 age/Cor/Con/CheckoutSession.cpp:274 ]: [Client 2-145] Cannot checkout session because a spawning error occurred. The identifier of the error is ecfe71c7. Please see earlier logs for details about the error.
App 80895 output: Error: The application encountered the following error: no such table: sources (SQLite3::SQLException)
App 80895 output:     /var/lib/gems/2.7.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:147:in `initialize'
App 80895 output:     /var/lib/gems/2.7.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:147:in `new'
App 80895 output:     /var/lib/gems/2.7.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:147:in `prepare'
App 80895 output:     /var/lib/gems/2.7.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:193:in `execute'
App 80895 output:     /home/shaunmcdonald/taginfo-gb/taginfo/web/lib/sql.rb:79:in `block in execute'
App 80895 output:     /home/shaunmcdonald/taginfo-gb/taginfo/web/lib/sql.rb:61:in `wrap_query'
App 80895 output:     /home/shaunmcdonald/taginfo-gb/taginfo/web/lib/sql.rb:78:in `execute'
App 80895 output:     /home/shaunmcdonald/taginfo-gb/taginfo/web/lib/sql.rb:223:in `execute'
App 80895 output:     /home/shaunmcdonald/taginfo-gb/taginfo/web/lib/sql.rb:15:in `init'
App 80895 output:     /home/shaunmcdonald/taginfo-gb/taginfo/web/taginfo.rb:68:in `<top (required)>'
App 80895 output:     /usr/lib/ruby/2.7.0/rubygems/core_ext/kernel_require.rb:92:in `require'
App 80895 output:     /usr/lib/ruby/2.7.0/rubygems/core_ext/kernel_require.rb:92:in `require'
App 80895 output:     config.ru:8:in `block in <main>'
App 80895 output:     /var/lib/gems/2.7.0/gems/rack-2.2.3/lib/rack/builder.rb:125:in `instance_eval'
App 80895 output:     /var/lib/gems/2.7.0/gems/rack-2.2.3/lib/rack/builder.rb:125:in `initialize'
App 80895 output:     config.ru:1:in `new'
App 80895 output:     config.ru:1:in `<main>'
App 80895 output:     /usr/share/passenger/helper-scripts/rack-preloader.rb:101:in `eval'
App 80895 output:     /usr/share/passenger/helper-scripts/rack-preloader.rb:101:in `preload_app'
App 80895 output:     /usr/share/passenger/helper-scripts/rack-preloader.rb:189:in `block in <module:App>'
App 80895 output:     /usr/lib/ruby/vendor_ruby/phusion_passenger/loader_shared_helpers.rb:382:in `run_block_and_record_step_progress'
App 80895 output:     /usr/share/passenger/helper-scripts/rack-preloader.rb:188:in `<module:App>'
App 80895 output:     /usr/share/passenger/helper-scripts/rack-preloader.rb:30:in `<module:PhusionPassenger>'
App 80895 output:     /usr/share/passenger/helper-scripts/rack-preloader.rb:29:in `<main>'
[ E 2020-12-30 16:56:27.7325 39087/T13w age/Cor/App/Implementation.cpp:221 ]: Could not spawn process for application /home/shaunmcdonald/taginfo-gb/taginfo/web: The application encountered the following error: no such table: sources (SQLite3::SQLException)
  Error ID: d0b53fe5
  Error details saved to: /tmp/passenger-error-88c2fN.html

I’m wonder if this is something you’ve come across before and what it could be? What’s forced me to get around to updating the code is the updating stopped mid November, potentially due to an upstream change in the download data.

It’s the first update of the code in probably a year or so. I’ve not enabled the new chronology things.

The hill shape on https://taginfo.openstreetmap.org/tags/highway=road#chronology <https://taginfo.openstreetmap.org/tags/highway=road#chronology> makes it rather interesting as shows the rise and fall of the usage of the tag, so will look into it at some point. Will need to find out how to keep a limited country OSM history file up to date.

Thanks
Shaun
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/taginfo-dev/attachments/20201230/9d9ebac2/attachment.htm>