Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: DBMail: users
behavior when losing database connection

Index | Next | Previous | View Flat

m.macura at gmail

Apr 13, 2012, 10:36 AM

Views: 413
behavior when losing database connection

My dbmail-imapd daemon died, because it tried to store a message
bigger than max_allowed_packet setting in MySQL. I would expect it to
rollback that transaction instead of dying, but it probably took some
time processing it and hit wait_timeout.

If this happens, I think the better behavior would be to try and
reconnect to the database, at least a couple of times, before dying.

Apr 13 10:30:23 dbmail-lmtpd[17011]: [0x1c39f40] Warning:[clientbase]
ci_readln(+415): insane line-length [72453]
Apr 13 10:33:31 dbmail-imapd[16948]: [0xc03d10] Error:[message]
blob_exists(+170): SQLException: Got a packet bigger than
'max_allowed_packet' bytes
Apr 13 10:33:32 dbmail-imapd[16948]: [0xc03d10] Error:[message]
blob_insert(+207): SQLException: Lost connection to MySQL server
during query
SQLException: MySQL server has gone away
raised in Connection_rollback at src/db/Connection.c:274

Also, is there a way to set mysql connection flags in dbmail?
specifically CLIENT_INTERACTIVE. I can't increase wait_timeout, but i
could use interactive_timeout which is set much higher.
DBmail mailing list
DBmail [at] dbmail

Subject User Time
behavior when losing database connection m.macura at gmail Apr 13, 2012, 10:36 AM

  Index | Next | Previous | View Flat

Interested in having your list archived? Contact Gossamer Threads
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.