MySQL Forums
Forum List  »  General

MySQL server has gone away 104 Error
Posted by: Mark Constant
Date: February 13, 2020 02:14PM

I have an open source piece of software made up of different python scripts that I downloaded. Mostly all parts connect to the mysql backend. There is one python module that is getting the error (2006, "MySQL server has gone away (error(104, 'Connection reset by peer'))"). I thought it was the Insert statement maybe being too long or having to much information. On the MySQL side I tried in MySQL the command set global max_allowed_packet=1072731894; and when I do SHOW GLOBAL VARIABLES LIKE 'max_allowed_packet'; it says max_allowed_packet | 1072731136 |
So I am somewhat confused about what I can do when obviously the database is accepting connections for one part and keeps failing on one insert statement.

Options: ReplyQuote

Written By
MySQL server has gone away 104 Error
February 13, 2020 02:14PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.