1.4.7 Server, CentOS 6 , server died

Server
1

Hello Everyone,

Today I had to restart urbackup-Server, it was dead. In log file I saw following

2015-02-05 06:18:22: SQLITE_BUSY in CQuery::Execute Stmt: [BEGIN IMMEDIATE;]
2015-02-05 06:18:22: Active query(0): BEGIN IMMEDIATE;
2015-02-05 06:18:22: Active query(1): UPDATE files SET did_count=0
2015-02-05 06:18:32: SQLITE_BUSY in CQuery::Execute Stmt: [BEGIN IMMEDIATE;]
2015-02-05 06:18:32: Active query(0): BEGIN IMMEDIATE;
2015-02-05 06:18:32: Active query(1): UPDATE files SET did_count=0
2015-02-05 06:18:42: SQLITE_BUSY in CQuery::Execute Stmt: [BEGIN IMMEDIATE;]
2015-02-05 06:18:42: Active query(0): BEGIN IMMEDIATE;
2015-02-05 06:18:42: Active query(1): UPDATE files SET did_count=0
2015-02-05 06:18:52: SQLITE_BUSY in CQuery::Execute Stmt: [BEGIN IMMEDIATE;]
2015-02-05 06:18:52: Active query(0): BEGIN IMMEDIATE;
2015-02-05 06:18:52: Active query(1): UPDATE files SET did_count=0
2015-02-05 06:19:02: SQLITE_BUSY in CQuery::Execute Stmt: [BEGIN IMMEDIATE;]
2015-02-05 06:19:02: Active query(0): BEGIN IMMEDIATE;
2015-02-05 06:19:02: Active query(1): UPDATE files SET did_count=0
2015-02-05 06:19:12: SQLITE_BUSY in CQuery::Execute Stmt: [BEGIN IMMEDIATE;]
2015-02-05 06:19:12: Active query(0): BEGIN IMMEDIATE;
2015-02-05 06:19:12: Active query(1): UPDATE files SET did_count=0
2015-02-05 06:19:22: SQLITE_BUSY in CQuery::Execute Stmt: [BEGIN IMMEDIATE;]
2015-02-05 06:19:22: Active query(0): BEGIN IMMEDIATE;
2015-02-05 06:19:22: Active query(1): UPDATE files SET did_count=0
2015-02-05 06:19:28: ERROR: Error preparing Query [SELECT t_right FROM settings_db.si_permissions WHERE clientid=? AND t_domain=?]: no such table: settings_db.si_permissions

Thank you

2

Hello,

same think here on a Debian Jessie with kernel 3.16.0-4-amd64.
Urbackup process crash while trying to recalculate statistic, last line on log is:

2015-02-05 06:19:28: ERROR: Error preparing Query [SELECT t_right FROM
settings_db.si_permissions WHERE clientid=? AND t_domain=?]: no such
table: settings_db.si_permissions

Thank you

3

This should now be fixed with 1.4.8.

4

Same problem on Debian 1.4.8

2015-03-20 08:39:34: Copying 0 files from tmp table...

2015-03-20 08:39:34: done.
2015-03-20 08:40:24: ERROR: Sending broadcast failed!
2015-03-20 08:40:36: Copying 0 files from tmp table…
2015-03-20 08:40:37: done.
2015-03-20 08:40:51: Copying 0 files from tmp table…
2015-03-20 08:40:51: done.
2015-03-20 08:41:05: Ping timeout in InternetServiceConnector::Run
2015-03-20 08:41:12: Copying 0 files from tmp table…
2015-03-20 08:41:12: done.
2015-03-20 08:41:14: ERROR: Sending broadcast failed!
2015-03-20 08:41:35: Copying 0 files from tmp table…
2015-03-20 08:41:35: done.
2015-03-20 08:41:44: Establish timeout: Deleting internet client “****”
2015-03-20 08:42:04: ERROR: Sending broadcast failed!
2015-03-20 08:42:54: ERROR: Sending broadcast failed!
2015-03-20 08:43:44: ERROR: Sending broadcast failed!
2015-03-20 08:44:34: Copying 0 files from tmp table…
2015-03-20 08:44:34: done.
2015-03-20 08:44:34: ERROR: Sending broadcast failed!
2015-03-20 08:45:04: Client exited: ****
2015-03-20 08:45:04: Stopping channel…
2015-03-20 08:45:04: Lost channel connection to client. has_error=true
2015-03-20 08:45:05: server_get Thread for client **** finished
2015-03-20 08:45:09: ERROR: Error preparing Query [SELECT t_right FROM settings_db.si_permissions WHERE clientid=? AND t_domain=?]: no such table: settings_db.si_permissions