State: Error -Test failed: Packet for query is too large (4739923 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.
I tried to change MAX_ALLOWED_PACKET variable to 126 MB (it was 16), but it doesn't resolve my problem.
The error says the value is LARGER THAN 1 MB.
So why do you think using 126 MB will solve the problem?
Is 126 MB larger than the 1 MB in the error?
Modify your packet size to be SMALLER than the value shown in the error.
i can't reduce my value of 4739923, it's generated by Sql Developer tool testing the connection (client).
I tryed to increase the max_allowed_packet variable values (server) with this statement:
set global max_allowed_packet=1024*1024*16;
But it doesn't work.
I hope to explain you the problem well.
Not sure if you have made any progress on this issue, but here are a couple of tips that may help.
First, the SQL Developer worksheet assumes you are using Oracle SQL and PL/SQL. If the syntax is specific to a third-party DB, then perhaps using the /*sqldev:query*/ and /*sqldev:stmt*/ hints as explained in the following discussion may help:
If the hints do not help, then the following non-Oracle forum discussion suggests coordinating the update of MAX_ALLOWED_PACKET on your MySQL server-side and client-side configuration files:
I hope this will be of help to you,
SQL Developer Team
Hi Gary Graham, thank you for the support.
I still have the problem and it's not generate by executing a statement in a worksheet because i'm not able to connect to my database.
The problem presents when i try to test the connection at my database with the "Test" button (but i'm really sure about connection details i'm using, because with others client like MySql Workbanch i can connect to my db).
I tried to increase the MAX_ALLOWED_PACKET (like the post that you suggest me recommended), server side, but it doesn't work.
My english is not very clear, this evening i will post a screenshot of the error.
You should reduce MAX_ALLOWED_PACKET on your server side. It should be less than 1048576 on your server side probably in /etc/my.cnf
My question is similar to yours, so I'll ask here:
The same issue, but I need to know how could I change MAX_ALLOWED_PACKET(or what variable should I set?) on client side?
I don’t have mysql server on client machine(windows 7). Only driver and sqldeveloper installed. And I don’t want to reduce max_allowed_packet size on my debian server. I’ve read this doc http://www.ccs.neu.edu/home/kathleen/classes/cs3200/connector-j.pdf But couldn’t understand how to edit this http://clip2net.com/s/jpjkq6
why i must reduce MAX_ALLOWED_PACKET on server side? I tried, setting it at 1048576, but it didn't resolve my problem.
I think the problem is client side, because Sql Developer produce a "test connection" packet too large for my DB (for this reason i tried, firt of all, to increase server side the MAX_ALLOWED_PACKET).
Not really my area, but according to
such properties can be passed directly in the JDBC URL. Unfortunately, users of SQL Developer do not have that level of control over the URL. Note, however, what that document says about the default value JDBC uses in the absence of it being passed
Maximum allowed packet size to send to server. If not set, the value of system variable 'max_allowed_packet' will be used to initialize this upon connecting. This value will not take effect if set larger than the value of 'max_allowed_packet'. Also, due to an internal dependency with the property "blobSendChunkSize", this setting has a minimum value of "8203" if "useServerPrepStmts" is set to "true".
Since version: 5.1.8
So if no MySQL client exists, try creating and setting a system variable 'max_allowed_packet'.
Hope this helps,