Mailing List Archive

[DBMail 0001063]: DBMail-LMTPD crashes when database not available/tables locked
A NOTE has been added to this issue.
======================================================================
http://dbmail.org/mantis/view.php?id=1063
======================================================================
Reported By: jasb
Assigned To:
======================================================================
Project: DBMail
Issue ID: 1063
Category: LMTP daemon
Reproducibility: always
Severity: major
Priority: normal
Status: new
target:
======================================================================
Date Submitted: 09-Nov-14 02:40 CET
Last Modified: 09-Nov-14 13:42 CET
======================================================================
Summary: DBMail-LMTPD crashes when database not
available/tables locked
Description:
Hi,

When the tables are locked, LMTPD crashes or sometimes get's zombie and
needs to be killed.
I gdb it, and the lines where it crashed, I figured out that is due to
table lock, as I was doing late night operations on the database and the
table "dbmail_headervalue" was locked due to the running job.

Attached a log with the stack trace.
I believe it's easy to reproduce, with just locking the dbmail_headervalue
table.
======================================================================

----------------------------------------------------------------------
(0003683) jasb (reporter) - 09-Nov-14 13:42
http://dbmail.org/mantis/view.php?id=1063#c3683
----------------------------------------------------------------------
Some extra info on this:

2014 Nov 9 12:32:48 lira Alert:[libzdb] TabortHandler(+43): SQLException:
MySQL server has gone away
raised in Connection_rollback at src/db/Connection.c:288

Issue History
Date Modified Username Field Change
======================================================================
09-Nov-14 02:40 jasb New Issue
09-Nov-14 02:40 jasb File Added: dbmail-lmtpd-2014.txt

09-Nov-14 13:42 jasb Note Added: 0003683
======================================================================

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
[DBMail 0001063]: DBMail-LMTPD crashes when database not available/tables locked [ In reply to ]
The following issue has been SUBMITTED.
======================================================================
http://dbmail.org/mantis/view.php?id=1063
======================================================================
Reported By: jasb
Assigned To:
======================================================================
Project: DBMail
Issue ID: 1063
Category: LMTP daemon
Reproducibility: always
Severity: major
Priority: normal
Status: new
target:
======================================================================
Date Submitted: 09-Nov-14 02:40 CET
Last Modified: 09-Nov-14 02:40 CET
======================================================================
Summary: DBMail-LMTPD crashes when database not
available/tables locked
Description:
Hi,

When the tables are locked, LMTPD crashes or sometimes get's zombie and
needs to be killed.
I gdb it, and the lines where it crashed, I figured out that is due to
table lock, as I was doing late night operations on the database and the
table "dbmail_headervalue" was locked due to the running job.

Attached a log with the stack trace.
I believe it's easy to reproduce, with just locking the dbmail_headervalue
table.
======================================================================

Issue History
Date Modified Username Field Change
======================================================================
09-Nov-14 02:40 jasb New Issue
09-Nov-14 02:40 jasb File Added: dbmail-lmtpd-2014.txt

======================================================================

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev