database error

[born2hate]

hi there! get randomly error, changed already 2 servers, now i have 16gb 8 cpus:

PHP Warning: Error while sending QUERY packet. PID=27217 in /home/admin/web/mydomain.com/public_html/letsplay/lib/mysql.php on line 160
PHP Fatal error: Uncaught Exception: database insertion error: MySQL server has gone away in /home/admin/web/mydomain.com/public_html/letsplay/bot/Database.php:137
Stack trace:
#0 /home/admin/web/mydomain.com/public_html/letsplay/bot/utils.php(44): Database::log('Error during ma...')
#1 /home/admin/web/mydomain.com/public_html/letsplay/bot/Arbitrator.php(593): logg('Error during ma...')
#2 /home/admin/web/mydomain.com/public_html/letsplay/bot/Arbitrator.php(22): Arbitrator->innerRun()
#3 [internal function]: Arbitrator->{closure}(Object(React\EventLoop\Timer\Timer))
#4 /home/admin/web/mydomain.com/public_html/letsplay/lib/composer/vendor/react/event-loop/src/Timer/Timers.php(90): call_user_func(Object(Closure), Object(React\EventLoop\Timer\Timer))
#5 /home/admin/web/mydomain.com/public_html/letsplay/lib/composer/vendor/react/event-loop/src/StreamSelectLoop.php(177): React\EventLoop\Timer\Timers->tick()
#6 /home/admin/web/mydomain.com/public_html/letsplay/bot/Arbitrator.php(583): React\EventLoop\StreamSelectLoop->run()
#7 /hom in /home/admin/web/mydomain.com/public_html/letsplay/bot/Database.php on line 137
root@cryptogod:/home/admin/web/mydomain.com/public_html/letsplay#

whats wrong?

[born2hate]

solved, problem was in mysql timeout config

[Greatguy2]

how did you solved it?

[born2hate]

increased wait_timeout and interactive_timeout parametrs:

[client]
port=3306
socket=/var/run/mysqld/mysqld.sock

[mysqld_safe]
socket=/var/run/mysqld/mysqld.sock

[mysqld]
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
log_error=/var/log/mysql/error.log

symbolic-links=0

skip-external-locking
key_buffer_size = 1024M
max_allowed_packet = 10096M
table_open_cache = 256
sort_buffer_size = 20M
read_buffer_size = 20M
read_rnd_buffer_size = 32M
myisam_sort_buffer_size = 256M
thread_cache_size = 512
query_cache_size= 1024M

#innodb_use_native_aio = 0
innodb_file_per_table

max_connections=200
max_user_connections=50
wait_timeout=1000
interactive_timeout=5000
long_query_time=500

!includedir /etc/mysql/conf.d/

[Greatguy2]

Nope didnt helped me. still getting the same error.

[born2hate]

again stuck at this problem, helped: https://tools.percona.com/wizard
try to create config for you server