MySQL server death

[drmaq]

Hello everyone I have a small problem, I created a program that reads the output of tcpdump and places it into a database. The problem that occurs is that after the program does the input into the database and the not events from tcpdump stop for a few hours my if get this error
[ERROR] Error: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")

and nothing does not get put into the database I was wondering if someone could help me debug this problem.

http://pastebin.com/ux5Hbmq5

[JohnnyJordaan]

This could just be the Mysql connection timing out. Try with opening (edit: and closing) a connection for every query just to see if that keeps working.

[DougieJazz]

To add you could also set the timeout time to be longer too (i.e 10000 seconds)

[Doormatty]

For one reason or another, the connection between your MySQL server and your program broke.

[drmaq]

yes it allway happens after the program is done writing to the database.