Packet is larger than max_allowed_packet

is larger than max_allowed_packet from server configuration of 65536 bytes --- I m using Redhat 7.3, mysql-3.23.51-max with custom kernel. The same thing works on my other machine with the same OS and same mysql version but default RH 7.3 kernel

Re: Packet is Larger than max_allowed_packet from server configuration of 65536 bytes

or client. I have a very large query that I need to send to MySQL from Java. The query has approximately 5000 individual items in the where clause. (i.e. WHERE i!='AP' AND i != 'J3' AND...to 5000). When I try to execute the Query I get the error: "Packet is Larger than max_allowed_packet

Packet is Larger than max_allowed_packet from server configuration of 65536 bytes

the Query I get the error: Packet is Larger than max_allowed_packet from server configuration of 65536 bytes I read the MySQL documentation and increased my max_allowed_packet to 24M on both the client and the Server in the my.cnf, but I still get the same errorIs there another variable I need