[clamav-users] safebrowsing database problems

[Alex]

Hi,

I'm trying to set up safebrowsing on fedora32 and having a few
problems. I've set up the Google API key and believe I had it running
successfully for some time about three weeks ago, but now I'm unable
to keep it running.

Updates using the "build" option fail with a "duplicate entry" error:
sqlalchemy.exc.IntegrityError: (raised as a result of Query-invoked
autoflush; consider using a session.no_autoflush block if this flush
is occurring prematurely)
(MySQLdb._exceptions.IntegrityError) (1062, "Duplicate entry
'00093283-1' for key 'PRIMARY'")
[SQL: INSERT INTO sbclient_v4_prefixes (prefix, reflist_id) VALUES (%s, %s)]
[parameters: (b'00093283', 1)]
(Background on this error at: http://sqlalche.me/e/13/gkpj)

The database (mariadb) is on a remote remote machine that has a few
databases on it with a few clients connecting but is generally idle.

I also received the following error:
sqlalchemy.exc.OperationalError:
(MySQLdb._exceptions.OperationalError) (2006, 'MySQL server has gone
away')
[SQL: SELECT sbclient_v4_lists.id AS sbclient_v4_lists_id,
sbclient_v4_lists.`threatType` AS `sbclient_v4_lists_threatType`,
sbclient_v4_lists.`threatEntryType` AS
`sbclient_v4_lists_threatEntryType`, sbclient_v4_lists.`platformType`
AS `sbclient_v4_lists_platformType`, sbclient_v4_lists.last_update AS
sbclient_v4_lists_last_update, sbclient_v4_lists.state AS
sbclient_v4_lists_state
FROM sbclient_v4_lists WHERE sbclient_v4_lists.id = %s]
[parameters: (2,)]
(Background on this error at: http://sqlalche.me/e/13/e3q8)

I am running the following command:
# ./clamsbsync.py --config /etc/clamd.d/safebrowsing.conf -v build

# cat /etc/clamd.d/safebrowsing.conf
<safebrowsing>
    # Google's apikey for the safebrowsing datafeed
    apikey = IzaSyBwvwjUgIQ5t...WVaM

    ## MySQL database parameters
    db_host = havoc.mycompany.com
    db_user = sbclient
    db_pw = password
    db_name = sbclient

    ## outputdir is where the update python makes its safebrowsing.gdb
    outputdir = /var/lib/clamav/
</safebrowsing>

How can I troubleshoot this further?