OpenStreetMap
Aktualisierung von osm2pgsql mithilfe von Vagrant und Ansible.
Posted by aselnigu on 23 November 2024 in German (Deutsch). Last updated on 24 November 2024.Ausgangszustand
Wir haben via der nachfolgenden Aufrufe
- eine Vagrant Maschine mit dem Test-Import vom Hackathon in Karlsruhe aus dem Snapshot wiederhergestellt,
- den Branch mit dem neuen Playbook geladen
- das Datum in der virtuellen Maschine auf den aktuellen Stand gesetzt
- Datenbank Updates in der virtuellen Maschine getestet
- und die Aktualisierung der Datenbank gestoppt und deaktiviert.
amaschine@amaschine-hp-laptop:~/openstreetmap/osm-server/ansible_openstreetmap.de$ git branch
backport
* master
amaschine@amaschine-hp-laptop:~/openstreetmap/osm-server/ansible_openstreetmap.de$ vagrant snapshot restore bookworm afterimportanddoc
[fog][WARNING] Unrecognized arguments: libvirt_ip_command
==> bookworm: Restoring the snapshot 'afterimportanddoc'...
amaschine@amaschine-hp-laptop:~/openstreetmap/osm-server/ansible_openstreetmap.de$ date
Sa 23. Nov 15:39:14 CET 2024
amaschine@amaschine-hp-laptop:~/openstreetmap/osm-server/ansible_openstreetmap.de$ git checkout backport
M Vagrantfile
M private
Zu Zweig »backport« gewechselt
amaschine@amaschine-hp-laptop:~/openstreetmap/osm-server/ansible_openstreetmap.de$ git branch
* backport
master
amaschine@amaschine-hp-laptop:~/openstreetmap/osm-server/ansible_openstreetmap.de$ vagrant ssh bookworm
[fog][WARNING] Unrecognized arguments: libvirt_ip_command
Linux bookworm 6.1.0-26-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.112-1 (2024-09-30) x86_64
The programs included with the Debian GNU/Linux system are free software;
the exact distribution terms for each program are described in the
individual files in /usr/share/doc/*/copyright.
Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
permitted by applicable law.
Last login: Mon Oct 28 08:49:50 2024 from 192.168.121.1
vagrant@bookworm:~$ sudo date --set "23 Nov 2024 15:43:00"
Sat Nov 23 15:43:00 UTC 2024
vagrant@bookworm:~$ date
Sat Nov 23 15:43:20 UTC 2024
vagrant@bookworm:~$ sudo journalctl -u updatedb -f
Nov 23 15:46:48 bookworm osm2pgsql-replication[6836]: 2024-11-23 15:46:48 [INFO]: Using replication service 'http://download.geofabrik.de/europe/monaco-updates'. Current sequence 4249 (2024-11-22 21:20:41+00:00).
Nov 23 15:46:49 bookworm osm2pgsql-replication[6836]: 2024-11-23 15:46:49 [INFO]: Database already up-to-date.
Nov 23 15:46:49 bookworm systemd[1]: updatedb.service: Deactivated successfully.
Nov 23 15:47:39 bookworm systemd[1]: updatedb.service: Scheduled restart job, restart counter is at 41.
Nov 23 15:47:39 bookworm systemd[1]: Stopped updatedb.service - render database update.
Nov 23 15:47:39 bookworm systemd[1]: Starting updatedb.service - render database update...
Nov 23 15:47:39 bookworm systemd[1]: Started updatedb.service - render database update.
Nov 23 15:47:39 bookworm osm2pgsql-replication[6842]: 2024-11-23 15:47:39 [INFO]: Using replication service 'http://download.geofabrik.de/europe/monaco-updates'. Current sequence 4249 (2024-11-22 21:20:41+00:00).
Nov 23 15:47:39 bookworm osm2pgsql-replication[6842]: 2024-11-23 15:47:39 [INFO]: Database already up-to-date.
Nov 23 15:47:39 bookworm systemd[1]: updatedb.service: Deactivated successfully.
Nov 23 15:48:29 bookworm systemd[1]: updatedb.service: Scheduled restart job, restart counter is at 42.
Nov 23 15:48:29 bookworm systemd[1]: Stopped updatedb.service - render database update.
Nov 23 15:48:29 bookworm systemd[1]: Starting updatedb.service - render database update...
Nov 23 15:48:29 bookworm systemd[1]: Started updatedb.service - render database update.
Nov 23 15:48:30 bookworm osm2pgsql-replication[6852]: 2024-11-23 15:48:30 [INFO]: Using replication service 'http://download.geofabrik.de/europe/monaco-updates'. Current sequence 4249 (2024-11-22 21:20:41+00:00).
Nov 23 15:48:30 bookworm osm2pgsql-replication[6852]: 2024-11-23 15:48:30 [INFO]: Database already up-to-date.
Nov 23 15:48:30 bookworm systemd[1]: updatedb.service: Deactivated successfully.
vagrant@bookworm:~$ sudo systemctl stop updatedb
vagrant@bookworm:~$ sudo systemctl disable updatedb
Removed "/etc/systemd/system/multi-user.target.wants/updatedb.service".
vagrant@bookworm:~$ sudo systemctl status updatedb
○ updatedb.service - render database update
Loaded: loaded (/etc/systemd/system/updatedb.service; disabled; preset: enabled)
Active: inactive (dead)
Nov 23 15:48:30 bookworm osm2pgsql-replication[6852]: 2024-11-23 15:48:30 [INFO]: Database already up-to-date.
Nov 23 15:48:30 bookworm systemd[1]: updatedb.service: Deactivated successfully.
Nov 23 15:49:20 bookworm systemd[1]: updatedb.service: Scheduled restart job, restart counter is at 43.
Nov 23 15:49:20 bookworm systemd[1]: Stopped updatedb.service - render database update.
Nov 23 15:49:20 bookworm systemd[1]: Starting updatedb.service - render database update...
Nov 23 15:49:20 bookworm systemd[1]: Started updatedb.service - render database update.
Nov 23 15:49:20 bookworm osm2pgsql-replication[6858]: 2024-11-23 15:49:20 [INFO]: Using replication service 'http://download.geofabrik.de/europe/monaco->
Nov 23 15:49:20 bookworm osm2pgsql-replication[6858]: 2024-11-23 15:49:20 [INFO]: Database already up-to-date.
Nov 23 15:49:20 bookworm systemd[1]: updatedb.service: Deactivated successfully.
Nov 23 15:49:37 bookworm systemd[1]: Stopped updatedb.service - render database update
osm2pgsql --version zeigt die Version 1.8.0 an:
vagrant@bookworm:~$ osm2pgsql --version
2024-11-23 15:54:00 osm2pgsql version 1.8.0
Build: None
Compiled using the following library versions:
Libosmium 2.19.0
Proj [API 6] 9.1.1
Lua 5.3.6
Ausführen des Ansible Playbook mit den Änderungen für osm2pgsql version 2.0.0
amaschine@amaschine-hp-laptop:~/openstreetmap/osm-server/ansible_openstreetmap.de$ ansible-playbook -v -i vagrant.ini site.yml -u vagrant
Das Log in Auszügen:
Using /home/astrid/openstreetmap/osm-server/ansible_openstreetmap.de/ansible.cfg as config file
PLAY [all] *********************************************************************
...
TASK [tile : Ensure backports repository is enabled] ***************************
changed: [vagrant] => changed=true
repo: deb http://deb.debian.org/debian bookworm-backports main
sources_added:
- /etc/apt/sources.list.d/deb_debian_org_debian.list
sources_removed: []
state: present
TASK [tile : Update apt cache] *************************************************
ok: [vagrant] => changed=false
cache_update_time: 1732377360
cache_updated: false
TASK [tile : Install osm2pgsql from backports] *********************************
changed: [vagrant] => changed=true
cache_update_time: 1732377360
cache_updated: false
stderr: ''
stderr_lines: <omitted>
stdout: |-
Reading package lists...
Building dependency tree...
Reading state information...
The following packages will be upgraded:
osm2pgsql
1 upgraded, 0 newly installed, 0 to remove and 117 not upgraded.
Need to get 655 kB of archives.
After this operation, 376 kB of additional disk space will be used.
Get:1 https://deb.debian.org/debian bookworm-backports/main amd64 osm2pgsql amd64 2.0.0+ds-1~bpo12+1 [655 kB]
apt-listchanges: Reading changelogs...
Fetched 655 kB in 1s (1042 kB/s)
(Reading database ... (Reading database ... 5%(Reading database ... 10%(Reading database ... 15%(Reading database ... 20%(Reading database ... 25%(Reading database ... 30%(Reading database ... 35%(Reading database ... 40%(Reading database ... 45%(Reading database ... 50%(Reading database ... 55%(Reading database ... 60%(Reading database ... 65%(Reading database ... 70%(Reading database ... 75%(Reading database ... 80%(Reading database ... 85%(Reading database ... 90%(Reading database ... 95%(Reading database ... 100%(Reading database ... 118746 files and directories currently installed.)
Preparing to unpack .../osm2pgsql_2.0.0+ds-1~bpo12+1_amd64.deb ...
Unpacking osm2pgsql (2.0.0+ds-1~bpo12+1) over (1.8.0+ds-1) ...
Setting up osm2pgsql (2.0.0+ds-1~bpo12+1) ...
Processing triggers for man-db (2.11.2-2) ...
stdout_lines: <omitted>
TASK [tile : Install pyosmium with apt] ****************************************
ok: [vagrant] => changed=false
cache_update_time: 1732377360
cache_updated: false
TASK [tile : install required packages with apt] *******************************
ok: [vagrant] => changed=false
cache_update_time: 1732377360
cache_updated: false
TASK [tile : import script] ****************************************************
changed: [vagrant] => changed=true
checksum: 2935b0eb1ce39c8352e5a285d7bf71549353a30e
dest: /usr/local/sbin/import-osm2pgsql
gid: 0
group: root
md5sum: 3ac058ba5347d0f7a045b93a31d61144
mode: '0755'
owner: root
size: 2940
src: /home/vagrant/.ansible/tmp/ansible-tmp-1732373896.116979-30985-21719873806536/source
state: file
uid: 0
TASK [tile : Make sure destination dir for flatnode file, planet and bin dir exist] ***
ok: [vagrant] => (item=/srv/tile/flatnode) => changed=false
ansible_loop_var: item
gid: 996
group: tile
item: /srv/tile/flatnode
mode: '0755'
owner: tile
path: /srv/tile
size: 4096
state: directory
uid: 999
ok: [vagrant] => (item=/srv/tile/planet.osm.pbf) => changed=false
ansible_loop_var: item
gid: 996
group: tile
item: /srv/tile/planet.osm.pbf
mode: '0755'
owner: tile
path: /srv/tile
size: 4096
state: directory
uid: 999
ok: [vagrant] => (item=/srv/tile/bin/expire-tiles-single.py) => changed=false
ansible_loop_var: item
gid: 0
group: root
item: /srv/tile/bin/expire-tiles-single.py
mode: '0755'
owner: root
path: /srv/tile/bin
size: 4096
state: directory
uid: 0
TASK [tile : render database updates from minutely] ****************************
changed: [vagrant] => changed=true
checksum: d4ae42b13fa9a9b865fe2637c0c7cdc318abd03a
dest: /etc/systemd/system/updatedb.service
gid: 0
group: root
md5sum: d675df77f3f79a342c70e634357583b0
mode: '0644'
owner: root
size: 460
src: /home/vagrant/.ansible/tmp/ansible-tmp-1732373897.8073187-30998-33336710338320/source
state: file
uid: 0
TASK [tile : german style] *****************************************************
changed: [vagrant] => changed=true
after: b653267dc3ebf137a0aa1e5ca049f63005188b47
before: 49aac58bcad0f5022eb74c9852d61ffd400bc017
remote_url_changed: false
TASK [tile : Dependencies for style and localization functions for OpenStreetMap] ***
ok: [vagrant] => changed=false
cache_update_time: 1732377360
cache_updated: false
TASK [tile : node carto for style transformation] ******************************
ok: [vagrant] => changed=false
cmd: npm install --global carto
delta: null
end: null
msg: Did not run command since '/usr/local/bin/carto' exists
rc: 0
start: null
stderr: ''
stderr_lines: <omitted>
stdout: skipped, since /usr/local/bin/carto exists
stdout_lines: <omitted>
TASK [tile : generate mapnik xml] **********************************************
changed: [vagrant] => changed=true
cmd: make; git checkout project.mml
delta: '0:00:36.533775'
end: '2024-11-23 15:56:58.982713'
msg: ''
rc: 0
start: '2024-11-23 15:56:22.448938'
stderr: |-
Warning: style/landcover.mss:630:4 line-offset is unstable. It may change in the future.
Warning: style/landcover.mss:633:6 line-offset is unstable. It may change in the future.
Warning: style/water-features.mss:112:6 line-offset is unstable. It may change in the future.
....
Warning: style/admin.mss:18:6 Styles do not match layer selector #admin-low-zoom.
Updated 0 paths from the index
stderr_lines: <omitted>
stdout: |-
carto -a 3.0.15 project.mml > /tmp/tmp.wyCh5drKdz
mv /tmp/tmp.wyCh5drKdz osm-de.xml
sed -e 's/localized_[a-z_]\+/name_hrb/g' project.mml >project-hrb.mml
carto -a 3.0.15 project-hrb.mml > /tmp/tmp.wyCh5drKdz
mv /tmp/tmp.wyCh5drKdz osm-hrb.xml
stdout_lines: <omitted>
TASK [tile : Localization functions for OpenStreetMap] *************************
changed: [vagrant] => changed=true
after: d06b251bd6882d9ff9bc4e028cc593c8d02a3bb7
before: 8e3004b72f07b1cdb4b4c4a1d50c1dd765194448
remote_url_changed: false
TASK [tile : clear outdated .deb packages of osml10n] **************************
changed: [vagrant] => changed=true
cmd: rm -f /srv/tile/sources/osml10n*.deb /srv/tile/sources/osml10n/*.deb
delta: '0:00:00.006004'
end: '2024-11-23 15:57:01.335680'
msg: ''
rc: 0
start: '2024-11-23 15:57:01.329676'
stderr: ''
stderr_lines: <omitted>
stdout: ''
stdout_lines: <omitted>
TASK [tile : Build osml10n debian packages] ************************************
changed: [vagrant] => (item=/srv/tile/sources/osml10n) => changed=true
ansible_loop_var: item
cmd: make deb
delta: '0:00:03.223523'
end: '2024-11-23 15:57:04.879868'
item: /srv/tile/sources/osml10n
msg: ''
rc: 0
start: '2024-11-23 15:57:01.656345'
stderr: |2-
dpkg-source --before-build .
fakeroot debian/rules clean
debian/rules build
fakeroot debian/rules binary
dpkg-genbuildinfo --build=binary -O../osml10n_1.2.0_amd64.buildinfo
dpkg-genchanges --build=binary -O../osml10n_1.2.0_amd64.changes
dpkg-source --after-build .
stderr_lines: <omitted>
stdout: |-
dpkg-buildpackage -b -uc
dpkg-buildpackage: info: source package osml10n
dpkg-buildpackage: info: source version 1.2.0
dpkg-buildpackage: info: source distribution unstable
dpkg-buildpackage: info: source changed by Sven Geggus <sven-debian@geggus.net>
dpkg-buildpackage: info: host architecture amd64
make[1]: Entering directory '/srv/tile/sources/osml10n'
dh clean
dh_auto_clean
make -j1 clean
make[2]: Entering directory '/srv/tile/sources/osml10n'
echo "there is nothing to clean"
there is nothing to clean
make[2]: Leaving directory '/srv/tile/sources/osml10n'
dh_clean
make[1]: Leaving directory '/srv/tile/sources/osml10n'
make[1]: Entering directory '/srv/tile/sources/osml10n'
make[1]: 'build' is up to date.
make[1]: Leaving directory '/srv/tile/sources/osml10n'
make[1]: Entering directory '/srv/tile/sources/osml10n'
dh binary
dh_update_autotools_config
dh_autoreconf
dh_auto_configure
dh_auto_build
make -j1 "INSTALL=install --strip-program=true"
make[2]: Entering directory '/srv/tile/sources/osml10n'
make[2]: 'build' is up to date.
make[2]: Leaving directory '/srv/tile/sources/osml10n'
debian/rules override_dh_auto_test
make[2]: Entering directory '/srv/tile/sources/osml10n'
/bin/true
make[2]: Leaving directory '/srv/tile/sources/osml10n'
create-stamp debian/debhelper-build-stamp
dh_testroot
dh_prep
dh_installdirs
debian/rules override_dh_auto_install
make[2]: Entering directory '/srv/tile/sources/osml10n'
dh_auto_install -- prefix=/usr
make -j1 install DESTDIR=/srv/tile/sources/osml10n/debian/osml10n AM_UPDATE_INFO_DIR=no "INSTALL=install --strip-program=true" prefix=/usr
make[3]: Entering directory '/srv/tile/sources/osml10n'
mkdir -p /srv/tile/sources/osml10n/debian/osml10n/usr/share/lua/5.3
cp -a lua_osml10/osml10n /srv/tile/sources/osml10n/debian/osml10n/usr/share/lua/5.3/
chmod -R go+rX /srv/tile/sources/osml10n/debian/osml10n/usr/share/lua/5.3/osml10n
make[3]: Leaving directory '/srv/tile/sources/osml10n'
make[2]: Leaving directory '/srv/tile/sources/osml10n'
dh_installdocs
dh_installchangelogs
dh_perl
dh_link
dh_strip_nondeterminism
dh_compress
dh_fixperms
dh_missing
dh_installdeb
dh_gencontrol
dh_md5sums
dh_builddeb
dpkg-deb: building package 'osml10n' in '../osml10n_1.2.0_all.deb'.
make[1]: Leaving directory '/srv/tile/sources/osml10n'
dpkg-genchanges: info: binary-only upload (no source code included)
dpkg-buildpackage: info: binary-only upload (no source included)
stdout_lines: <omitted>
changed: [vagrant] => (item=/srv/tile/sources/osml10n/lua_unac) => changed=true
ansible_loop_var: item
cmd: make deb
delta: '0:00:04.232802'
end: '2024-11-23 15:57:09.371837'
item: /srv/tile/sources/osml10n/lua_unac
msg: ''
rc: 0
start: '2024-11-23 15:57:05.139035'
stderr: |2-
dpkg-source --before-build .
fakeroot debian/rules clean
debian/rules build
fakeroot debian/rules binary
dpkg-gencontrol: warning: package lua-unaccent: substitution variable ${shlibs:Depends} unused, but is defined
dpkg-gencontrol: warning: package lua-unaccent: substitution variable ${shlibs:Depends} unused, but is defined
dpkg-genbuildinfo --build=binary -O../lua-unaccent_1.8-1_amd64.buildinfo
dpkg-genchanges --build=binary -O../lua-unaccent_1.8-1_amd64.changes
dpkg-source --after-build .
stderr_lines: <omitted>
stdout: |-
dpkg-buildpackage -b -uc
dpkg-buildpackage: info: source package lua-unaccent
dpkg-buildpackage: info: source version 1.8-1
dpkg-buildpackage: info: source distribution unstable
dpkg-buildpackage: info: source changed by Sven Geggus <sven-debian@geggus.net>
dpkg-buildpackage: info: host architecture amd64
make[1]: Entering directory '/srv/tile/sources/osml10n/lua_unac'
dh clean
dh_auto_clean
make -j1 clean
make[2]: Entering directory '/srv/tile/sources/osml10n/lua_unac'
rm -f unaccent.so
make[2]: Leaving directory '/srv/tile/sources/osml10n/lua_unac'
dh_clean
make[1]: Leaving directory '/srv/tile/sources/osml10n/lua_unac'
make[1]: Entering directory '/srv/tile/sources/osml10n/lua_unac'
dh build
dh_update_autotools_config
dh_autoreconf
dh_auto_configure
dh_auto_build
make -j1 "INSTALL=install --strip-program=true"
make[2]: Entering directory '/srv/tile/sources/osml10n/lua_unac'
gcc -Wall -shared -fPIC -o unaccent.so -I/usr/include/lua5.3 -llua5.3 -Wl,--no-as-needed -lunac lua_unac.c
make[2]: Leaving directory '/srv/tile/sources/osml10n/lua_unac'
dh_auto_test
create-stamp debian/debhelper-build-stamp
make[1]: Leaving directory '/srv/tile/sources/osml10n/lua_unac'
make[1]: Entering directory '/srv/tile/sources/osml10n/lua_unac'
dh binary
dh_testroot
dh_prep
dh_installdirs
dh_auto_install --destdir=debian/lua-unaccent/
make -j1 install DESTDIR=/srv/tile/sources/osml10n/lua_unac/debian/lua-unaccent AM_UPDATE_INFO_DIR=no "INSTALL=install --strip-program=true"
make[2]: Entering directory '/srv/tile/sources/osml10n/lua_unac'
install -m 644 unaccent.so /srv/tile/sources/osml10n/lua_unac/debian/lua-unaccent/usr/lib/x86_64-linux-gnu/lua/5.3/
make[2]: Leaving directory '/srv/tile/sources/osml10n/lua_unac'
dh_installdocs
dh_installchangelogs
dh_perl
dh_link
dh_strip_nondeterminism
dh_compress
dh_fixperms
dh_missing
dh_strip
dh_makeshlibs
dh_shlibdeps
dh_installdeb
dh_gencontrol
dh_md5sums
dh_builddeb
dpkg-deb: building package 'lua-unaccent' in '../lua-unaccent_1.8-1_amd64.deb'.
dpkg-deb: building package 'lua-unaccent-dbgsym' in '../lua-unaccent-dbgsym_1.8-1_amd64.deb'.
make[1]: Leaving directory '/srv/tile/sources/osml10n/lua_unac'
dpkg-genchanges: info: binary-only upload (no source code included)
dpkg-buildpackage: info: binary-only upload (no source included)
stdout_lines: <omitted>
...
TASK [tile : Set up virtualenv] ************************************************
changed: [vagrant] => changed=true
cmd:
- /srv/tile/venv/bin/pip3
- install
- /srv/tile/sources/osml10n/
name:
- /srv/tile/sources/osml10n/
requirements: null
state: present
stderr: ''
stderr_lines: <omitted>
stdout: |-
Processing /srv/tile/sources/osml10n
Installing build dependencies: started
Installing build dependencies: finished with status 'done'
Getting requirements to build wheel: started
Getting requirements to build wheel: finished with status 'done'
Preparing metadata (pyproject.toml): started
Preparing metadata (pyproject.toml): finished with status 'done'
Requirement already satisfied: setuptools in /srv/tile/venv/lib/python3.11/site-packages (from osml10n==1.2.0) (66.1.1)
Requirement already satisfied: scipy in /srv/tile/venv/lib/python3.11/site-packages (from osml10n==1.2.0) (1.13.1)
Requirement already satisfied: scikit-learn in /srv/tile/venv/lib/python3.11/site-packages (from osml10n==1.2.0) (1.3.2)
Requirement already satisfied: pykakasi==2.2.1 in /srv/tile/venv/lib/python3.11/site-packages (from osml10n==1.2.0) (2.2.1)
Requirement already satisfied: tltk==1.8.0 in /srv/tile/venv/lib/python3.11/site-packages (from osml10n==1.2.0) (1.8)
Requirement already satisfied: pinyin_jyutping_sentence==1.3 in /srv/tile/venv/lib/python3.11/site-packages (from osml10n==1.2.0) (1.3)
Requirement already satisfied: pyicu in /usr/lib/python3/dist-packages (from osml10n==1.2.0) (2.10.2)
Requirement already satisfied: shapely in /srv/tile/venv/lib/python3.11/site-packages (from osml10n==1.2.0) (2.0.6)
Requirement already satisfied: sdnotify in /srv/tile/venv/lib/python3.11/site-packages (from osml10n==1.2.0) (0.3.2)
Requirement already satisfied: requests in /usr/lib/python3/dist-packages (from osml10n==1.2.0) (2.28.1)
Requirement already satisfied: pandas in /srv/tile/venv/lib/python3.11/site-packages (from osml10n==1.2.0) (2.2.3)
Requirement already satisfied: jieba in /srv/tile/venv/lib/python3.11/site-packages (from pinyin_jyutping_sentence==1.3->osml10n==1.2.0) (0.42.1)
Requirement already satisfied: jaconv in /srv/tile/venv/lib/python3.11/site-packages (from pykakasi==2.2.1->osml10n==1.2.0) (0.4.0)
Requirement already satisfied: deprecated in /srv/tile/venv/lib/python3.11/site-packages (from pykakasi==2.2.1->osml10n==1.2.0) (1.2.14)
Requirement already satisfied: nltk in /srv/tile/venv/lib/python3.11/site-packages (from tltk==1.8.0->osml10n==1.2.0) (3.9.1)
Requirement already satisfied: sklearn-crfsuite in /srv/tile/venv/lib/python3.11/site-packages (from tltk==1.8.0->osml10n==1.2.0) (0.5.0)
Requirement already satisfied: gensim in /srv/tile/venv/lib/python3.11/site-packages (from tltk==1.8.0->osml10n==1.2.0) (4.3.3)
Requirement already satisfied: numpy>=1.23.2 in /usr/lib/python3/dist-packages (from pandas->osml10n==1.2.0) (1.24.2)
Requirement already satisfied: python-dateutil>=2.8.2 in /srv/tile/venv/lib/python3.11/site-packages (from pandas->osml10n==1.2.0) (2.9.0.post0)
Requirement already satisfied: pytz>=2020.1 in /srv/tile/venv/lib/python3.11/site-packages (from pandas->osml10n==1.2.0) (2024.2)
Requirement already satisfied: tzdata>=2022.7 in /srv/tile/venv/lib/python3.11/site-packages (from pandas->osml10n==1.2.0) (2024.2)
Requirement already satisfied: joblib>=1.1.1 in /srv/tile/venv/lib/python3.11/site-packages (from scikit-learn->osml10n==1.2.0) (1.4.2)
Requirement already satisfied: threadpoolctl>=2.0.0 in /srv/tile/venv/lib/python3.11/site-packages (from scikit-learn->osml10n==1.2.0) (3.5.0)
Requirement already satisfied: six>=1.5 in /usr/lib/python3/dist-packages (from python-dateutil>=2.8.2->pandas->osml10n==1.2.0) (1.16.0)
Requirement already satisfied: wrapt<2,>=1.10 in /srv/tile/venv/lib/python3.11/site-packages (from deprecated->pykakasi==2.2.1->osml10n==1.2.0) (1.16.0)
Requirement already satisfied: smart-open>=1.8.1 in /srv/tile/venv/lib/python3.11/site-packages (from gensim->tltk==1.8.0->osml10n==1.2.0) (7.0.5)
Requirement already satisfied: click in /srv/tile/venv/lib/python3.11/site-packages (from nltk->tltk==1.8.0->osml10n==1.2.0) (8.1.7)
Requirement already satisfied: regex>=2021.8.3 in /srv/tile/venv/lib/python3.11/site-packages (from nltk->tltk==1.8.0->osml10n==1.2.0) (2024.9.11)
Requirement already satisfied: tqdm in /srv/tile/venv/lib/python3.11/site-packages (from nltk->tltk==1.8.0->osml10n==1.2.0) (4.66.5)
Requirement already satisfied: python-crfsuite>=0.9.7 in /srv/tile/venv/lib/python3.11/site-packages (from sklearn-crfsuite->tltk==1.8.0->osml10n==1.2.0) (0.9.11)
Requirement already satisfied: tabulate>=0.4.2 in /srv/tile/venv/lib/python3.11/site-packages (from sklearn-crfsuite->tltk==1.8.0->osml10n==1.2.0) (0.9.0)
Building wheels for collected packages: osml10n
Building wheel for osml10n (pyproject.toml): started
Building wheel for osml10n (pyproject.toml): finished with status 'done'
Created wheel for osml10n: filename=osml10n-1.2.0-py3-none-any.whl size=460510 sha256=17a7516b4a7471019c093c6815dcba1cbf3288ad8adb831eb8bd5a16af5e0af0
Stored in directory: /tmp/pip-ephem-wheel-cache-4lx_a458/wheels/58/59/6b/e33f37490a677616eceeaca7209a8dd775b4ee853e7f6b790b
Successfully built osml10n
Installing collected packages: osml10n
Attempting uninstall: osml10n
Found existing installation: osml10n 1.2.0
Uninstalling osml10n-1.2.0:
Successfully uninstalled osml10n-1.2.0
Successfully installed osml10n-1.2.0
stdout_lines: <omitted>
version: null
virtualenv: /srv/tile/venv
TASK [tile : Copy osml10n service] *********************************************
changed: [vagrant] => changed=true
cmd: make systemd-service PYTARGET=/srv/tile/venv
delta: '0:00:00.010277'
end: '2024-11-23 15:57:32.324989'
msg: ''
rc: 0
start: '2024-11-23 15:57:32.314712'
stderr: ''
stderr_lines: <omitted>
stdout: sed -e "s;%PYTARGET%;/srv/tile/venv;g" transcription-daemon/geo-transcript-srv.service.template >/etc/systemd/system/osml10n.service
stdout_lines: <omitted>
...
PLAY RECAP *********************************************************************
dummy : ok=0 changed=0 unreachable=1 failed=0 skipped=0 rescued=0 ignored=0
vagrant : ok=127 changed=21 unreachable=0 failed=0 skipped=29 rescued=0 ignored=0
osm2pgsql --version zeigt nun die Version 2.0.0 an:
vagrant@bookworm:~$ osm2pgsql --version
osm2pgsql version 2.0.0
Build: None
Compiled using the following library versions:
Libosmium 2.19.0
Proj 9.1.1
Lua 5.3.6
Neu-Import der Daten
Nach einem Neustart haben wir die Daten neu eingelesen. Dabei wird die Datenbank neu angelegt (kein append).
vagrant@bookworm:~$ sudo reboot
vagrant@bookworm:~$ sudo /usr/local/sbin/import-osm2pgsql
Redirecting output to ‘wget-log.1’.
2024-11-23 15:26:56 osm2pgsql version 2.0.0
2024-11-23 15:26:56 WARNING: RAM cache is disabled. This will likely slow down processing a lot.
2024-11-23 15:26:56 Database version: 15.8 (Debian 15.8-0+deb12u1)
2024-11-23 15:26:56 PostGIS version: 3.3
2024-11-23 15:26:56 Initializing properties table '"public"."osm2pgsql_properties"'.
2024-11-23 15:26:56 Storing properties to table '"public"."osm2pgsql_properties"'.
2024-11-23 15:26:57 WARNING: You should use the syntax 'object:get_bbox()' (with the colon, not a point) to call functions on the OSM object.
2024-11-23 15:27:01 Reading input files done in 4s.
2024-11-23 15:27:01 Processed 30936 nodes in 2s - 15k/s
2024-11-23 15:27:01 Processed 4973 ways in 1s - 5k/s
2024-11-23 15:27:01 Processed 291 relations in 1s - 291/s
2024-11-23 15:27:01 No marked nodes or ways (Skipping stage 2).
2024-11-23 15:27:01 Clustering table 'planet_osm_hstore_point' by geometry...
2024-11-23 15:27:01 Creating index on table 'planet_osm_hstore_point' ("way")...
2024-11-23 15:27:01 Creating id index on table 'planet_osm_hstore_point'...
2024-11-23 15:27:01 Analyzing table 'planet_osm_hstore_point'...
2024-11-23 15:27:01 Clustering table 'planet_osm_hstore_line' by geometry...
2024-11-23 15:27:01 Creating index on table 'planet_osm_hstore_line' ("way")...
2024-11-23 15:27:01 Creating id index on table 'planet_osm_hstore_line'...
2024-11-23 15:27:01 Analyzing table 'planet_osm_hstore_line'...
2024-11-23 15:27:02 Clustering table 'planet_osm_hstore_roads' by geometry...
2024-11-23 15:27:02 Creating index on table 'planet_osm_hstore_roads' ("way")...
2024-11-23 15:27:02 Creating id index on table 'planet_osm_hstore_roads'...
2024-11-23 15:27:02 Analyzing table 'planet_osm_hstore_roads'...
2024-11-23 15:27:02 Clustering table 'planet_osm_hstore_polygon' by geometry...
2024-11-23 15:27:02 Creating index on table 'planet_osm_hstore_polygon' ("way")...
2024-11-23 15:27:03 Creating id index on table 'planet_osm_hstore_polygon'...
2024-11-23 15:27:03 Analyzing table 'planet_osm_hstore_polygon'...
2024-11-23 15:27:03 No indexes to create on table 'planet_osm_hstore_route'.
2024-11-23 15:27:03 Creating id index on table 'planet_osm_hstore_route'...
2024-11-23 15:27:03 Analyzing table 'planet_osm_hstore_route'...
2024-11-23 15:27:03 Done postprocessing on table 'planet_osm_nodes' in 0s
2024-11-23 15:27:03 Building index on table 'planet_osm_ways'
2024-11-23 15:27:04 Done postprocessing on table 'planet_osm_ways' in 0s
2024-11-23 15:27:04 Building index on table 'planet_osm_rels'
2024-11-23 15:27:05 Done postprocessing on table 'planet_osm_rels' in 1s
2024-11-23 15:27:05 All postprocessing on table 'planet_osm_hstore_point' done in 0s.
2024-11-23 15:27:05 All postprocessing on table 'planet_osm_hstore_line' done in 0s.
2024-11-23 15:27:05 All postprocessing on table 'planet_osm_hstore_roads' done in 0s.
2024-11-23 15:27:05 All postprocessing on table 'planet_osm_hstore_polygon' done in 0s.
2024-11-23 15:27:05 All postprocessing on table 'planet_osm_hstore_route' done in 0s.
2024-11-23 15:27:05 Storing properties to table '"public"."osm2pgsql_properties"'.
2024-11-23 15:27:05 osm2pgsql took 9s overall.
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
using database: osm
CREATE VIEW
GRANT
CREATE VIEW
GRANT
CREATE VIEW
GRANT
CREATE VIEW
GRANT
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
2024-11-23 15:27:12 [INFO]: Initialised updates for service 'https://planet.openstreetmap.org/replication/minute'.
2024-11-23 15:27:12 [INFO]: Starting at sequence 6356693 (2024-11-21T07:51:46Z).
Using replication service 'https://planet.openstreetmap.org/replication/minute', which is at sequence 6359947 ( 2024-11-23T15:26:25Z )
Replication server's most recent data is 48 second(s) old
Local database is 3254 sequences behind the server, i.e. 2 day(s) 7 hour(s) 34 minute(s) 39 second(s)
Local database's most recent data is 2 day(s) 7 hour(s) 35 minute(s) 27 second(s) old
INFO:root:Starting load of external data into database
INFO:root:Checking table simplified_water_polygons
INFO:root: Download complete (23896068 bytes)
INFO:root: Decompressing file
INFO:root: Importing into database
INFO:root: Import complete
INFO:root:Checking table water_polygons
INFO:root: Download complete (871221776 bytes)
INFO:root: Decompressing file
INFO:root: Importing into database
INFO:root: Import complete
INFO:root:Checking table icesheet_polygons
INFO:root: Download complete (52714660 bytes)
INFO:root: Decompressing file
INFO:root: Importing into database
INFO:root: Import complete
INFO:root:Checking table icesheet_outlines
INFO:root: Download complete (53595955 bytes)
INFO:root: Decompressing file
INFO:root: Importing into database
INFO:root: Import complete
INFO:root:Checking table ne_110m_admin_0_boundary_lines_land
INFO:root: Table ne_110m_admin_0_boundary_lines_land did not require updating
Redirecting output to ‘wget-log’.
Archive: carto-fonts.zip
inflating: HanaMinA.ttf
inflating: HanaMinB.ttf
inflating: NotoEmoji-Bold.ttf
inflating: NotoEmoji-Regular.ttf
inflating: NotoSansAdlamUnjoined-Bold.ttf
inflating: NotoSansAdlamUnjoined-Regular.ttf
inflating: NotoSansArabicUI-Bold.ttf
inflating: NotoSansArabicUI-Regular.ttf
inflating: NotoSansArmenian-Bold.ttf
inflating: NotoSansArmenian-Regular.ttf
inflating: NotoSansBalinese-Bold.ttf
inflating: NotoSansBalinese-Regular.ttf
inflating: NotoSansBamum-Bold.ttf
inflating: NotoSansBamum-Regular.ttf
inflating: NotoSansBatak-Regular.ttf
inflating: NotoSansBengaliUI-Bold.ttf
inflating: NotoSansBengaliUI-Regular.ttf
inflating: NotoSans-Bold.ttf
inflating: NotoSansBuginese-Regular.ttf
inflating: NotoSansBuhid-Regular.ttf
inflating: NotoSansCanadianAboriginal-Bold.ttf
inflating: NotoSansCanadianAboriginal-Regular.ttf
inflating: NotoSansChakma-Regular.ttf
inflating: NotoSansCham-Bold.ttf
inflating: NotoSansCham-Regular.ttf
inflating: NotoSansCherokee-Bold.ttf
inflating: NotoSansCherokee-Regular.ttf
inflating: NotoSansCJKjp-Bold.otf
inflating: NotoSansCJKjp-Regular.otf
inflating: NotoSansCoptic-Regular.ttf
inflating: NotoSansDevanagariUI-Bold.ttf
inflating: NotoSansDevanagariUI-Regular.ttf
inflating: NotoSansEthiopic-Bold.ttf
inflating: NotoSansEthiopic-Regular.ttf
inflating: NotoSansGeorgian-Bold.ttf
inflating: NotoSansGeorgian-Regular.ttf
inflating: NotoSansGujaratiUI-Bold.ttf
inflating: NotoSansGujaratiUI-Regular.ttf
inflating: NotoSansGurmukhiUI-Bold.ttf
inflating: NotoSansGurmukhiUI-Regular.ttf
inflating: NotoSansHanunoo-Regular.ttf
inflating: NotoSansHebrew-Bold.ttf
inflating: NotoSansHebrew-Regular.ttf
inflating: NotoSans-Italic.ttf
inflating: NotoSansJavanese-Bold.ttf
inflating: NotoSansJavanese-Regular.ttf
inflating: NotoSansKannadaUI-Bold.ttf
inflating: NotoSansKannadaUI-Regular.ttf
inflating: NotoSansKayahLi-Bold.ttf
inflating: NotoSansKayahLi-Regular.ttf
inflating: NotoSansKhmerUI-Bold.ttf
inflating: NotoSansKhmerUI-Regular.ttf
inflating: NotoSansLaoUI-Bold.ttf
inflating: NotoSansLaoUI-Regular.ttf
inflating: NotoSansLepcha-Regular.ttf
inflating: NotoSansLimbu-Regular.ttf
inflating: NotoSansLisu-Bold.ttf
inflating: NotoSansLisu-Regular.ttf
inflating: NotoSansMalayalamUI-Bold.ttf
inflating: NotoSansMalayalamUI-Regular.ttf
inflating: NotoSansMandaic-Regular.ttf
inflating: NotoSansMongolian-Regular.ttf
inflating: NotoSansMyanmarUI-Bold.ttf
inflating: NotoSansMyanmarUI-Regular.ttf
inflating: NotoSansNewTaiLue-Regular.ttf
inflating: NotoSansNKo-Regular.ttf
inflating: NotoSansOlChiki-Bold.ttf
inflating: NotoSansOlChiki-Regular.ttf
inflating: NotoSansOriyaUI-Bold.ttf
inflating: NotoSansOriyaUI-Regular.ttf
inflating: NotoSansOsage-Regular.ttf
inflating: NotoSansOsmanya-Regular.ttf
inflating: NotoSans-Regular.ttf
inflating: NotoSansSamaritan-Regular.ttf
inflating: NotoSansSaurashtra-Regular.ttf
inflating: NotoSansShavian-Regular.ttf
inflating: NotoSansSinhalaUI-Bold.ttf
inflating: NotoSansSinhalaUI-Regular.ttf
inflating: NotoSansSundanese-Bold.ttf
inflating: NotoSansSundanese-Regular.ttf
inflating: NotoSansSymbols2-Regular.ttf
inflating: NotoSansSymbols-Bold.ttf
inflating: NotoSansSymbols-Regular.ttf
inflating: NotoSansSyriac-Black.ttf
inflating: NotoSansSyriac-Regular.ttf
inflating: NotoSansTagalog-Regular.ttf
inflating: NotoSansTagbanwa-Regular.ttf
inflating: NotoSansTaiLe-Regular.ttf
inflating: NotoSansTaiTham-Bold.ttf
inflating: NotoSansTaiTham-Regular.ttf
inflating: NotoSansTaiViet-Regular.ttf
inflating: NotoSansTamilUI-Bold.ttf
inflating: NotoSansTamilUI-Regular.ttf
inflating: NotoSansTeluguUI-Bold.ttf
inflating: NotoSansTeluguUI-Regular.ttf
inflating: NotoSansThaana-Bold.ttf
inflating: NotoSansThaana-Regular.ttf
inflating: NotoSansThaiUI-Bold.ttf
inflating: NotoSansThaiUI-Regular.ttf
inflating: NotoSansTifinagh-Regular.ttf
inflating: NotoSansVai-Regular.ttf
inflating: NotoSansYi-Regular.ttf
inflating: NotoSerifTibetan-Bold.ttf
inflating: NotoSerifTibetan-Regular.ttf
Created symlink /etc/systemd/system/multi-user.target.wants/updatedb.service → /etc/systemd/system/updatedb.service.
vagrant@bookworm:~$ sudo journalctl -u updatedb -f
Nov 23 19:22:54 bookworm osm2pgsql-replication[7785]: 2024-11-23 19:22:54 Done postprocessing on table 'planet_osm_nodes' in 0s
Nov 23 19:22:54 bookworm osm2pgsql-replication[7785]: 2024-11-23 19:22:54 Done postprocessing on table 'planet_osm_ways' in 0s
Nov 23 19:22:54 bookworm osm2pgsql-replication[7785]: 2024-11-23 19:22:54 Done postprocessing on table 'planet_osm_rels' in 0s
Nov 23 19:22:54 bookworm osm2pgsql-replication[7785]: 2024-11-23 19:22:54 All postprocessing on table 'planet_osm_hstore_point' done in 0s.
Nov 23 19:22:54 bookworm osm2pgsql-replication[7785]: 2024-11-23 19:22:54 All postprocessing on table 'planet_osm_hstore_line' done in 0s.
Nov 23 19:22:54 bookworm osm2pgsql-replication[7785]: 2024-11-23 19:22:54 All postprocessing on table 'planet_osm_hstore_roads' done in 0s.
Nov 23 19:22:54 bookworm osm2pgsql-replication[7785]: 2024-11-23 19:22:54 All postprocessing on table 'planet_osm_hstore_polygon' done in 0s.
Nov 23 19:22:54 bookworm osm2pgsql-replication[7785]: 2024-11-23 19:22:54 All postprocessing on table 'planet_osm_hstore_route' done in 0s.
Nov 23 19:22:54 bookworm osm2pgsql-replication[7785]: 2024-11-23 19:22:54 Storing properties to table '"public"."osm2pgsql_properties"'.
Nov 23 19:22:54 bookworm osm2pgsql-replication[7785]: 2024-11-23 19:22:54 osm2pgsql took 6s overall.
Nov 23 19:23:00 bookworm osm2pgsql-replication[4791]: 2024-11-23 19:23:00 [INFO]: Data imported until 2024-11-21T13:06:41Z. Backlog remaining: 2 day(s) 6 hour(s) 16 minute(s) 19 second(s)
Nov 23 19:23:19 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:19 osm2pgsql version 2.0.0
Nov 23 19:23:19 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:19 Database version: 15.8 (Debian 15.8-0+deb12u1)
Nov 23 19:23:19 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:19 PostGIS version: 3.3
Nov 23 19:23:19 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:19 Loading properties from table '"public"."osm2pgsql_properties"'.
Nov 23 19:23:19 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:19 Not using flat node file (same as on import).
Nov 23 19:23:19 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:19 Using output 'flex' (same as on import).
Nov 23 19:23:19 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:19 Using style file '/srv/tile/sources/osml10n/openstreetmap-carto-hstore-only-l10n.lua' (same as on import).
Nov 23 19:23:19 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:19 Storing properties to table '"public"."osm2pgsql_properties"'.
Nov 23 19:23:19 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:19 Storing properties to table '"public"."osm2pgsql_properties"'.
Nov 23 19:23:19 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:19 WARNING: You should use the syntax 'object:get_bbox()' (with the colon, not a point) to call functions on the OSM object.
Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: [408B blob data]
Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Processed 75007 nodes in 1s - 75k/s
Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Processed 13579 ways in 3s - 5k/s
Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Processed 365 relations in 2s - 182/s
Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Going over 20 pending ways
Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Processing 20 pending ways took 0s at a rate of 0.00/s
Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Going over 13 pending relations
Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Processing 13 pending relations took 0s at a rate of 0.00/s
Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Skipping stage 1c for nodes (no marked nodes).
Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Skipping stage 1c for ways (no marked ways).
Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 No marked nodes or ways (Skipping stage 2).
Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Done postprocessing on table 'planet_osm_nodes' in 0s
Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Done postprocessing on table 'planet_osm_ways' in 0s
Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Done postprocessing on table 'planet_osm_rels' in 0s
Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 All postprocessing on table 'planet_osm_hstore_point' done in 0s.
Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 All postprocessing on table 'planet_osm_hstore_line' done in 0s.
Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 All postprocessing on table 'planet_osm_hstore_roads' done in 0s.
Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 All postprocessing on table 'planet_osm_hstore_polygon' done in 0s.
Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 All postprocessing on table 'planet_osm_hstore_route' done in 0s.
Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Storing properties to table '"public"."osm2pgsql_properties"'.
Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 osm2pgsql took 6s overall.
Nov 23 19:23:32 bookworm osm2pgsql-replication[4791]: 2024-11-23 19:23:32 [INFO]: Data imported until 2024-11-21T13:38:15Z. Backlog remaining: 2 day(s) 5 hour(s) 45 minute(s) 17 second(s)
Nov 23 19:23:55 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:23:55 osm2pgsql version 2.0.0
Nov 23 19:23:55 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:23:55 Database version: 15.8 (Debian 15.8-0+deb12u1)
Nov 23 19:23:55 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:23:55 PostGIS version: 3.3
Nov 23 19:23:55 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:23:55 Loading properties from table '"public"."osm2pgsql_properties"'.
Nov 23 19:23:55 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:23:55 Not using flat node file (same as on import).
Nov 23 19:23:55 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:23:55 Using output 'flex' (same as on import).
Nov 23 19:23:55 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:23:55 Using style file '/srv/tile/sources/osml10n/openstreetmap-carto-hstore-only-l10n.lua' (same as on import).
Nov 23 19:23:55 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:23:55 Storing properties to table '"public"."osm2pgsql_properties"'.
Nov 23 19:23:55 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:23:55 Storing properties to table '"public"."osm2pgsql_properties"'.
Nov 23 19:23:55 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:23:55 WARNING: You should use the syntax 'object:get_bbox()' (with the colon, not a point) to call functions on the OSM object.
Nov 23 19:24:01 bookworm osm2pgsql-replication[8007]: [537B blob data]
Nov 23 19:24:01 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:01 Processed 79789 nodes in 2s - 40k/s
Nov 23 19:24:01 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:01 Processed 13820 ways in 3s - 5k/s
Nov 23 19:24:01 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:01 Processed 365 relations in 1s - 365/s
Nov 23 19:24:01 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:01 Going over 32 pending ways
Nov 23 19:24:01 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:01 Processing 32 pending ways took 0s at a rate of 0.00/s
Nov 23 19:24:01 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:01 Going over 32 pending relations
Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 Processing 32 pending relations took 0s at a rate of 0.00/s
Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 Skipping stage 1c for nodes (no marked nodes).
Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 Skipping stage 1c for ways (no marked ways).
Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 No marked nodes or ways (Skipping stage 2).
Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 Done postprocessing on table 'planet_osm_nodes' in 0s
Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 Done postprocessing on table 'planet_osm_ways' in 0s
Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 Done postprocessing on table 'planet_osm_rels' in 0s
Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 All postprocessing on table 'planet_osm_hstore_point' done in 0s.
Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 All postprocessing on table 'planet_osm_hstore_line' done in 0s.
Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 All postprocessing on table 'planet_osm_hstore_roads' done in 0s.
Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 All postprocessing on table 'planet_osm_hstore_polygon' done in 0s.
Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 All postprocessing on table 'planet_osm_hstore_route' done in 0s.
Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 Storing properties to table '"public"."osm2pgsql_properties"'.
Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 osm2pgsql took 6s overall.
Nov 23 19:24:07 bookworm osm2pgsql-replication[4791]: 2024-11-23 19:24:07 [INFO]: Data imported until 2024-11-21T14:18:45Z. Backlog remaining: 2 day(s) 5 hour(s) 5 minute(s) 22 second(s)
Nov 23 19:24:28 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:28 osm2pgsql version 2.0.0
Nov 23 19:24:28 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:28 Database version: 15.8 (Debian 15.8-0+deb12u1)
Nov 23 19:24:28 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:28 PostGIS version: 3.3
Nov 23 19:24:28 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:28 Loading properties from table '"public"."osm2pgsql_properties"'.
Nov 23 19:24:28 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:28 Not using flat node file (same as on import).
Nov 23 19:24:28 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:28 Using output 'flex' (same as on import).
Nov 23 19:24:28 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:28 Using style file '/srv/tile/sources/osml10n/openstreetmap-carto-hstore-only-l10n.lua' (same as on import).
Nov 23 19:24:28 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:28 Storing properties to table '"public"."osm2pgsql_properties"'.
Nov 23 19:24:28 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:28 Storing properties to table '"public"."osm2pgsql_properties"'.
Nov 23 19:24:28 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:28 WARNING: You should use the syntax 'object:get_bbox()' (with the colon, not a point) to call functions on the OSM object.
Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: [468B blob data]
Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Processed 89837 nodes in 2s - 45k/s
Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Processed 13210 ways in 3s - 4k/s
Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Processed 303 relations in 2s - 152/s
Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Going over 78 pending ways
Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Processing 78 pending ways took 0s at a rate of 0.00/s
Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Going over 28 pending relations
Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Processing 28 pending relations took 0s at a rate of 0.00/s
Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Skipping stage 1c for nodes (no marked nodes).
Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Skipping stage 1c for ways (no marked ways).
Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 No marked nodes or ways (Skipping stage 2).
Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Done postprocessing on table 'planet_osm_nodes' in 0s
Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Done postprocessing on table 'planet_osm_ways' in 0s
Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Done postprocessing on table 'planet_osm_rels' in 0s
Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 All postprocessing on table 'planet_osm_hstore_point' done in 0s.
Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 All postprocessing on table 'planet_osm_hstore_line' done in 0s.
Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 All postprocessing on table 'planet_osm_hstore_roads' done in 0s.
Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 All postprocessing on table 'planet_osm_hstore_polygon' done in 0s.
Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 All postprocessing on table 'planet_osm_hstore_route' done in 0s.
Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Storing properties to table '"public"."osm2pgsql_properties"'.
Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 osm2pgsql took 6s overall.
Nov 23 19:24:45 bookworm osm2pgsql-replication[4791]: 2024-11-23 19:24:45 [INFO]: Data imported until 2024-11-21T14:51:13Z. Backlog remaining: 2 day(s) 4 hour(s) 33 minute(s) 32 second(s)
....
Nov 24 08:40:32 bookworm systemd[1]: updatedb.service: Consumed 1.415s CPU time.
Nov 24 08:41:22 bookworm systemd[1]: updatedb.service: Scheduled restart job, restart counter is at 496.
Nov 24 08:41:22 bookworm systemd[1]: Stopped updatedb.service - render database update.
Nov 24 08:41:22 bookworm systemd[1]: updatedb.service: Consumed 1.415s CPU time.
Nov 24 08:41:22 bookworm systemd[1]: Starting updatedb.service - render database update...
Nov 24 08:41:22 bookworm systemd[1]: Started updatedb.service - render database update.
Nov 24 08:41:22 bookworm osm2pgsql-replication[120519]: 2024-11-24 08:41:22 [INFO]: Using replication service 'https://planet.openstreetmap.org/replication/minute'.
Nov 24 08:41:24 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:24 osm2pgsql version 2.0.0
Nov 24 08:41:24 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:24 Database version: 15.10 (Debian 15.10-0+deb12u1)
Nov 24 08:41:24 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:24 PostGIS version: 3.3
Nov 24 08:41:24 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:24 Loading properties from table '"public"."osm2pgsql_properties"'.
Nov 24 08:41:24 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:24 Not using flat node file (same as on import).
Nov 24 08:41:24 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:24 Using output 'flex' (same as on import).
Nov 24 08:41:24 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:24 Using style file '/srv/tile/sources/osml10n/openstreetmap-carto-hstore-only-l10n.lua' (same as on import).
Nov 24 08:41:24 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:24 Storing properties to table '"public"."osm2pgsql_properties"'.
Nov 24 08:41:24 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:24 Storing properties to table '"public"."osm2pgsql_properties"'.
Nov 24 08:41:24 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:24 WARNING: You should use the syntax 'object:get_bbox()' (with the colon, not a point) to call functions on the OSM object.
Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: [144B blob data]
Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Processed 765 nodes in 0s - 765/s
Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Processed 171 ways in 0s - 171/s
Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Processed 9 relations in 1s - 9/s
Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Going over 2 pending ways
Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Processing 2 pending ways took 0s at a rate of 0.00/s
Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Going over 2 pending relations
Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Processing 2 pending relations took 0s at a rate of 0.00/s
Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Skipping stage 1c for nodes (no marked nodes).
Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Skipping stage 1c for ways (no marked ways).
Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 No marked nodes or ways (Skipping stage 2).
Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Done postprocessing on table 'planet_osm_nodes' in 0s
Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Done postprocessing on table 'planet_osm_ways' in 0s
Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Done postprocessing on table 'planet_osm_rels' in 0s
Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 All postprocessing on table 'planet_osm_hstore_point' done in 0s.
Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 All postprocessing on table 'planet_osm_hstore_line' done in 0s.
Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 All postprocessing on table 'planet_osm_hstore_roads' done in 0s.
Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 All postprocessing on table 'planet_osm_hstore_polygon' done in 0s.
Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 All postprocessing on table 'planet_osm_hstore_route' done in 0s.
Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Storing properties to table '"public"."osm2pgsql_properties"'.
Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 osm2pgsql took 0s overall.
Nov 24 08:41:25 bookworm osm2pgsql-replication[120519]: 2024-11-24 08:41:25 [INFO]: Data imported until 2024-11-24T08:40:44Z. Backlog remaining: 41 second(s)
Nov 24 08:41:26 bookworm systemd[1]: updatedb.service: Deactivated successfully.
Nov 24 08:41:26 bookworm systemd[1]: updatedb.service: Consumed 1.409s CPU time.
Nov 24 08:42:16 bookworm systemd[1]: updatedb.service: Scheduled restart job, restart counter is at 497.
Nov 24 08:42:16 bookworm systemd[1]: Stopped updatedb.service - render database update.
Nov 24 08:42:16 bookworm systemd[1]: updatedb.service: Consumed 1.409s CPU time.
Nov 24 08:42:16 bookworm systemd[1]: Starting updatedb.service - render database update...
Nov 24 08:42:16 bookworm systemd[1]: Started updatedb.service - render database update.
Nov 24 08:42:16 bookworm osm2pgsql-replication[120565]: 2024-11-24 08:42:16 [INFO]: Using replication service 'https://planet.openstreetmap.org/replication/minute'.
Nov 24 08:42:17 bookworm osm2pgsql-replication[120565]: 2024-11-24 08:42:17 [INFO]: Database already up-to-date.
Nov 24 08:42:17 bookworm systemd[1]: updatedb.service: Deactivated successfully.
...
OpenStreetMap Carto German Version v5.9.0-de0 und Localization functions for Openstreetmap (osml10n) Version v1.2.1 sind korrekte Version:
Discussion