Too many errors in log

Server
1

I have in log many these errors:
ERROR: Error unserializing state data
ERROR: Error executing alert script id 1. Return value -1.

Any advice? Thank you very much!

2

Could you post the output of

echo "SELECT hex(alerts_state) FROM clients WHERE alerts_state IS NOT NULL AND length(alerts_state)>0;" | sqlite3 /var/urbackup/backup_server.db

? Thanks!

3

64
64
04166C6173745F696D6167655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F7469667903
64
64
64
64
04156C6173745F66696C655F6661696C5F6E6F7469667903
04166C6173745F696D6167655F6661696C5F6E6F7469667903
64
64
64
04166C6173745F696D6167655F6661696C5F6E6F7469667903
04166C6173745F696D6167655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F7469667903
04166C6173745F696D6167655F6661696C5F6E6F7469667903
04166C6173745F696D6167655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F7469667903
04166C6173745F696D6167655F6661696C5F6E6F7469667903
04166C6173745F696D6167655F6661696C5F6E6F7469667903

4

Seems to be an issue with storing null bytes. I wonder why it works for me? Are you using a separate sqlite? Or are you not using Linux etc.?

5

I’m using Debian Stretch. Package sqlite3 is installed.

6

Just experienced the same issue.
urbackupsrv crashed due to it.

# cat /etc/lsb-release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=18.04
DISTRIB_CODENAME=bionic
DISTRIB_DESCRIPTION="Ubuntu 18.04.4 LTS"

# sqlite3 --version
3.22.0 2018-01-22 18:45:57     0c55d179733b46d8d0ba4d88e01a25e10677046ee3da1d5b1581e86726f2alt1

echo “SELECT hex(alerts_state) FROM clients WHERE alerts_state IS NOT NULL AND length(alerts_state)>0;” | sqlite3 /var/urbackup/backup_server.db

04156C6173745F66696C655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F7469667903
04166C6173745F696D6167655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F7469667903
04166C6173745F696D6167655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F7469667903
04166C6173745F696D6167655F6661696C5F6E6F7469667903
04166C6173745F696D6167655F6661696C5F6E6F7469667903
04166C6173745F696D6167655F6661696C5F6E6F7469667903
04166C6173745F696D6167655F6661696C5F6E6F7469667903
04166C6173745F696D6167655F6661696C5F6E6F7469667903
04166C6173745F696D6167655F6661696C5F6E6F7469667903
04166C6173745F696D6167655F6661696C5F6E6F7469667903
04166C6173745F696D6167655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F7469667903
04166C6173745F696D6167655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F7469667903
04156C6173745F66696C655F6661696C5F6E6F74696679030000004E2BF4D74164
04156C6173745F66696C655F6661696C5F6E6F7469667903000000C829F4D74164
04156C6173745F66696C655F6661696C5F6E6F7469667903000000E42BF4D74164
04156C6173745F66696C655F6661696C5F6E6F74696679030000004E2BF4D74104166C6173745F696D6167655F6661696C5F6E6F7469667903000000EAB3E1D74164
04156C6173745F66696C655F6661696C5F6E6F7469667903000000E629F4D74164
04156C6173745F66696C655F6661696C5F6E6F74696679030000005F29F4D74104166C6173745F696D6167655F6661696C5F6E6F74696679030000C09003E4D74164
04156C6173745F66696C655F6661696C5F6E6F74696679030000C0F627F4D74104166C6173745F696D6167655F6661696C5F6E6F74696679030000C0F627F4D74164
04156C6173745F66696C655F6661696C5F6E6F74696679030000C0F627F4D74164
04156C6173745F66696C655F6661696C5F6E6F74696679030000C0C828F4D74164