java.sql.BatchUpdateException: Packet for query is too large (4528379 > 4194304). You can change this value on the server by setting the max_allowed_packet' variable.

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via GitHub by Laurira
, 1 year ago
Packet for query is too large (4528379 > 4194304). You can change this value on the server by setting the max_allowed_packet' variable.
via GitHub by NovaBlastHD
, 2 months ago
Data truncation: Out of range value for column 'x' at row 2
via GitHub by hakumanatatu
, 1 year ago
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(1,'last_name',''),(1,'nickname','hakumanatatu'),(1,'description',''),(1,'rich_e' at line 1
via Stack Overflow by user3528272
, 1 year ago
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 're talking election 2016 with @ForbesOpinion's @Avik ' at line 1
via GitHub by sgdc3
, 2 months ago
Data truncation: Out of range value for column 'ping' at row 1
java.sql.BatchUpdateException: Packet for query is too large (4528379 > 4194304). You can change this value on the server by setting the max_allowed_packet' variable.
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3583)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2460)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009)
at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5094)
at com.mysql.jdbc.PreparedStatement.executeBatchedInserts(PreparedStatement.java:1528)
at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1248)
at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:959)
at com.databasepreservation.modules.jdbc.out.JDBCExportModule.handleDataRow(JDBCExportModule.java:480)
at com.databasepreservation.modules.siard.in.content.SIARD2ContentImportStrategy.endElement(SIARD2ContentImportStrategy.java:296)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.endElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)
at com.databasepreservation.modules.siard.in.content.SIARD2ContentImportStrategy.importContent(SIARD2ContentImportStrategy.java:141)
at com.databasepreservation.modules.siard.in.input.SIARDImportDefault.getDatabase(SIARDImportDefault.java:45)
at com.databasepreservation.Main.run(Main.java:126)
at com.databasepreservation.Main.internal_main(Main.java:80)
at com.databasepreservation.Main.main(Main.java:62)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago

Know the solutions? Share your knowledge to help other developers to debug faster.