tomcat - Packet for query is too large MySQL -

i have tomcat app connecting mysql db / java application

i keep getting

packet query large 1080>1024

i tried changing my.cnf: in my.cnf max packet size defined 50 mb ,

socket = /var/run/mysqld/mysqld.sock port = 3306 basedir     = /usr datadir = /var/lib/mysql tmpdir      = /tmp lc-messages-dir = /usr/share/mysql lower_case_table_names  = 1 skip-external-locking    bind-address = 0.0.0.0    key_buffer      = 16m max_allowed_packet = 50m thread_stack        = 192k thread_cache_size       = 8 group_concat_max_len=100000 innodb_lock_wait_timeout=300 innodb_buffer_pool_size=22g innodb_locks_unsafe_for_binlog = on innodb_additional_mem_pool_size=40m 

i have tried passing param part of connection string

jdbc:mysql://serverip:3306/dbname?maxallowedpacket=2048000 

to jdbc driver - still keep getting

packet query large 1080>1024

this keeps coming every few hours.

what should check?

mysql version 5.5

thanks help.

it looks isn't configured right... did restart mysql after making config changes? have configure size on both ends:

both client , server have own max_allowed_packet variable, if want handle big packets, must increase variable both in client , in server.

however, server's default size 1mb (1024 kb). given error says 1080>1024 i'm guessing configuration changes didn't take place (at least not on both client , server).

this happens because either query, row or binary log event greater 1mb:

a communication packet single sql statement sent mysql server, single row sent client, or binary log event sent master replication server slave.

i'd try bumping 5mb on client , server (including replication instance if have one). you'll have bounce mysql changes take effect.

https://dev.mysql.com/doc/refman/5.5/en/packet-too-large.html