[Dxspider-support] dxspider disconnects from MySQL

[Tim Tuck]

Hi all,

We're in the process of building a node with additional functionality 
that depends on MySQL.

Occasionally dxspider stops putting spots into the database.

A restart of dxspider fixes the issue.

The only items in a log that suggests a problem is this from within the 
journal on Ubuntu 20.04LTS

Nov 03 20:02:29 dx.vkspotter.com sh[19901]: DBD::mysql::db begin_work 
failed: Turning off AutoCommit failed at /spider/perl/DXSql.pm line 89.
Nov 03 20:02:29 dx.vkspotter.com sh[19901]:  at /spider/perl/DXSql.pm 
line 89.
Nov 03 20:02:29 dx.vkspotter.com sh[19901]: DBD::mysql::db do warning:  
at /spider/perl/DXSql.pm line 84.
Nov 03 20:02:29 dx.vkspotter.com sh[19901]:  at /spider/perl/DXSql.pm 
line 84.
Nov 03 20:02:29 dx.vkspotter.com sh[19901]: commit ineffective with 
AutoCommit enabled at /spider/perl/DXSql.pm line 94.

I haven't found any other detail in any log to suggest what might be 
happening. i.e. I haven't found the trigger event to cause the disconnect.

Any help appreciated.

thanks

Tim

-- 
VK2XAX : QF56if : ITU59 : CQ30 : BMARC : WIA