Error after update on raspberry - missing table "directory_link_journal"


After updating from 2.1.x to 2.2.9 (and now 2.2.11) on a raspberry the server stops with the following message:

2018-04-19 10:56:29: WARNING: SQLite: no such table: directory_link_journal errorcode: 1
2018-04-19 10:56:29: ERROR: Error preparing Query [SELECT linkname, linktarget FROM directory_link_journal]: no such table: directory_link_journal. Retrying in 1s…

I have checked my tables in the backup_server.db. There is no such a table directory_link_journal:

sqlite> .tables
alert_script_params clients_hist misc
alert_scripts clients_hist_id orig_client_settings
assoc_images del_stats restores
backup_images log_data tokens_on_client
backups logs user_tokens
clients mail_queue users_on_client

Does someone of you have a solution?

Well it’s (in your case not) in backup_server_link_journal.db. You should probably restore that from a backup…

Thanks. In that file there is the missing table. But it is empty.
I tried to repair the database with “urbackupsrv --repair_database” first, but it didn’t helped.

Finally I did the last step from, but this will not restore the file backup_server_link_journal.db

In the meantime I downgraded to 2.1.19 which is running well. I will start a second attempt soon and keep you informed.