Communication Packets

[justin2234]

So i been getting these mysql errors lately.

Code: Select all

2016-08-26T07:41:23.139175Z 20458 [Note] Aborted connection 20458 to db: 'donation_store' user: '44mhknbio' host: 'v-74-91-127-165.managed-vds.internap-atlanta.nfoservers.com' (Got an error reading communication packets)
2016-08-26T07:41:23.139240Z 63311 [Note] Aborted connection 63311 to db: 'globalbans' user: '44mhknbio' host: 'v-74-91-127-165.managed-vds.internap-atlanta.nfoservers.com' (Got an error reading communication packets)
2016-08-26T07:41:23.139321Z 20470 [Note] Aborted connection 20470 to db: 'globalbans' user: '44mhknbio' host: 'v-74-91-127-165.managed-vds.internap-atlanta.nfoservers.com' (Got an error reading communication packets)
2016-08-26T07:41:23.139467Z 20461 [Note] Aborted connection 20461 to db: 'globalbans' user: '44mhknbio' host: 'v-74-91-127-165.managed-vds.internap-atlanta.nfoservers.com' (Got an error reading communication packets)
2016-08-26T07:41:23.139613Z 20908 [Note] Aborted connection 20908 to db: 'globalbans' user: '44mhknbio' host: 'v-74-91-127-165.managed-vds.internap-atlanta.nfoservers.com' (Got an error reading communication packets)
2016-08-26T07:44:50.251702Z 63382 [Note] Aborted connection 63382 to db: 'globalbans' user: '44mhknbio' host: 'v-74-91-127-165.managed-vds.internap-atlanta.nfoservers.com' (Got an error reading communication packets)
2016-08-26T07:44:50.251869Z 63385 [Note] Aborted connection 63385 to db: 'globalbans' user: '44mhknbio' host: 'v-74-91-127-165.managed-vds.internap-atlanta.nfoservers.com' (Got an error reading communication packets)
2016-08-26T07:44:50.251937Z 63384 [Note] Aborted connection 63384 to db: 'globalbans' user: '44mhknbio' host: 'v-74-91-127-165.managed-vds.internap-atlanta.nfoservers.com' (Got an error reading communication packets)
2016-08-26T07:44:50.252016Z 63695 [Note] Aborted connection 63695 to db: 'donation_store' user: '44mhknbio' host: 'v-74-91-127-165.managed-vds.internap-atlanta.nfoservers.com' (Got an error reading communication packets)
2016-08-26T07:44:50.252145Z 63386 [Note] Aborted connection 63386 to db: 'player_activity_comp' user: '44mhknbio' host: 'v-74-91-127-165.managed-vds.internap-atlanta.nfoservers.com' (Got an error reading communication packets)

Any way how to fix this?

[It'sRandinator]

It's a network/firewall issue. Try raising the max_allowed_packet to a much larger number, since the default is 1M.

Code: Select all

To set the max_allowed_packet to 256M, you can add it to /etc/my.cnf or my.ini

[mysqld]
max_allowed_packet=256M

Keep us updated!

[justin2234]

It's a network/firewall issue. Try raising the max_allowed_packet to a much larger number, since the default is 1M.

Code: Select all

To set the max_allowed_packet to 256M, you can add it to /etc/my.cnf or my.ini

[mysqld]
max_allowed_packet=256M

Keep us updated!

You sure its /etc/my.cnf or my.ini?
I added this in /etc/mysql/mysql.conf.d/mysqld.cnf which didnt fix my issue but when i restart mysql services, i saw that it changed the values in the sql error logs.

Code: Select all

[mysqld]
#
# * Basic Settings
#
user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
lc-messages-dir	= /usr/share/mysql
skip-external-locking
max_connections=9000
max_allowed_packet=9000

[It'sRandinator]

my.cnf or my.ini is fine. If I remember correctly you don't edit mysqld.cnf.

[justin2234]

my.cnf or my.ini is fine. If I remember correctly you don't edit mysqld.cnf.

Yeah well my.cnf is what i have and it was useless and didnt change anything. max_allowed_packet was in mysqld.cnf so i changed it to 512M and then ran mysqld --verbose --help which showed that it was now at 512M but still seem to be getting the same communication errors.

[It'sRandinator]

Use

mysql --print-defaults

after restarting to see that your settings have taken effect. And post it. Are you hosting mysql yourself?

Things to do:

Check the ifconfig -a output on the MySQL server to check if there are errors.

Check to see if you have enough memory allocated to mysql.

Try raising net_write_timeout see if that helps.

[justin2234]

Use mysql --print-defaults after restarting to see that your settings have taken effect.

I tried it and it said "mysql would have been started with the following arguements:" (then nothing else shows)

And post it. Are you hosting mysql yourself?

Yes hosting mysql myself

Check the ifconfig -a output on the MySQL server to check if there are errors.

0 errors

Check to see if you have enough memory allocated to mysql.

Not sure how to check this.

Try raising net_write_timeout see if that helps.

net_write_timeout isnt in my /etc/mysql/my.cnf or /etc/mysql/mysql.conf.d/mysqld.cnf (i could possibly add it here manually but have not sure how much you'd want me to set it to.)

[It'sRandinator]

Set these options in command line.

set session net_read_timeout=3600;

set session wait_timeout=3600;

[justin2234]

Set these options in command line.

set session net_read_timeout=3600;

set session wait_timeout=3600;

not sure where to set that.

[It'sRandinator]

Cmd line or the option file is fine.

[justin2234]

Oh my apologies i actually had these values set already for a while and they never solved the issue.

[justin2234]

Any help? :/