[Dxspider-support] Bugreport/Issue: Reconnect to SQL Server

[Johannes Fellner]

Hello,

In my activity to fully docker'ize the DXSpider setup including
Webserver and MariaDB (
https://github.com/DocViper666/dxspider-deployment ) I am facing the
following issue.

On automatic updating of the MariaDB container (stopping, rebuild
container and starting the database again) the DXSpider (mojo) is not
reconnecting to the database even after the database up and running
again. The same would happen if the sql server stops and restarts (after
some minutes).

The error log is:

___________

1692777442^(*) DBD::mysql::db begin_work failed: Turning off AutoCommit
failed at /spider/perl/DXSql.pm line 90.
1692777442^(*)  at /spider/perl/DXSql.pm line 90.
1692777442^(*) DBD::mysql::db do failed: Server has gone away at
/spider/perl/DXSql.pm line 85.
1692777442^(*)  at /spider/perl/DXSql.pm line 85.
1692777442^(*) commit ineffective with AutoCommit enabled at
/spider/perl/DXSql.pm line 95.
1692777442^(*)  at /spider/perl/DXSql.pm line 95.

____________

Only a restart of DXSpider helps to re-establish the connection to the
SQL DB again.

Am I missing a config option?

Expected scenario would be that after the SQL has gone away a reconnect
would be attempted (for every spot or in fixed interval) to bring the
connection back without restart.

Thanks a lot for all the great work.

73 de Joe, OE5JFE

###