Am Donnerstag, 21. Februar 2019 19:38:44 UTC+1 schrieb Björn Ott: > Hi *, > > updated my Bareos v17 Installation to v18. Backup is working fine, but the I > tried to restore a few files for testing and boom Bareos-dir is crashing. > Tested in bconsole and webui, now difference. I started Bareos-dir in debug > and got the following message right after try a restore: > > backup1-dir (100): cats/sql_query.cc:124-0 called: bool > BareosDb::SqlQuery(const char*, int) with query DROP TABLE btempb200061928 > backup1-dir (50): cats/postgresql.cc:687-0 Result status fatal: DROP TABLE > btempb200061928 > backup1-dir (10): cats/postgresql.cc:692-0 ERROR TERMINATION: Fatal database > error > backup1-dir: ERROR TERMINATION at cats/postgresql.cc:692 > Fatal database error > > My Postgres shows an error, too. That's telling me bareos tries to delete a > table which doesn't exist: > > 2019-02-21 12:23:22.479 CET [26313] bareos@bareos ERROR: table > "btempb200061928" does not exist > 2019-02-21 12:23:22.479 CET [26313] bareos@bareos STATEMENT: DROP TABLE > btempb200061928 > > But that's not a database issue. Postgres is doing the right things. > > I can repeat that again and again. Just tested a clean setup with a > fresh/empty database, same thing here. Really bad --> backup w/o restore not > a good combination... > > When I look a the whole debug text I can not find any CREATE statement > creating the not existing (and finally resulting in a crash) table. > > OS: Ubuntu 16.04.5 LTS 32-Bit x86 > Database: server 10.7 (Ubuntu 10.7-1.pgdg16.04+1) > Bareos Packages: > ii bareos 18.2.5-139.1 > i386 Backup Archiving Recovery Open Sourced - metapackage > ii bareos-bconsole 18.2.5-139.1 > i386 Backup Archiving Recovery Open Sourced - text console > ii bareos-client 18.2.5-139.1 > i386 Backup Archiving Recovery Open Sourced - client > metapackage > ii bareos-common 18.2.5-139.1 > i386 Backup Archiving Recovery Open Sourced - common files > ii bareos-database-common 18.2.5-139.1 > i386 Backup Archiving Recovery Open Sourced - common > catalog files > ii bareos-database-postgresql 18.2.5-139.1 > i386 Backup Archiving Recovery Open Sourced - PostgreSQL > backend > ii bareos-database-tools 18.2.5-139.1 > i386 Backup Archiving Recovery Open Sourced - database tools > ii bareos-director 18.2.5-139.1 > i386 Backup Archiving Recovery Open Sourced - director > daemon > ii bareos-filedaemon 18.2.5-139.1 > i386 Backup Archiving Recovery Open Sourced - file daemon > ii bareos-storage 18.2.5-139.1 > i386 Backup Archiving Recovery Open Sourced - storage daemon > ii bareos-storage-tape 18.2.5-139.1 > i386 Backup Archiving Recovery Open Sourced - storage > daemon tape support > ii bareos-tools 18.2.5-139.1 > i386 Backup Archiving Recovery Open Sourced - common tools > rc bareos-traymonitor 14.2.1-31.1 > i386 Backup Archiving Recovery Open Sourced - tray monitor > ii bareos-webui 18.2.5-126.1 > all Backup Archiving Recovery Open Sourced - webui > > Can somebody confirm that problem? Is there a common sollution for that issue? > > > Regards > Björn
So, 18.2.5 is gone. Reverted all to 17.2.4. Backup and Restore working fine again. -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
