Skip to content

Getting Occasional Repeated Error in Console after moving to MySQL #863

@UPSOKen

Description

@UPSOKen

I moved my CoreProtect database to MySQL, and ever since then, I am getting a repeating error in console randomly.

[14:22:13 WARN]: java.sql.BatchUpdateException: Data truncation: Data too long for column 'art' at row 1
[14:22:13 WARN]: 	at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:214)
[14:22:13 WARN]: 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchWithMultiValuesClause(ClientPreparedStatement.java:782)
[14:22:13 WARN]: 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:456)
[14:22:13 WARN]: 	at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:858)
[14:22:13 WARN]: 	at CoreProtect.jar//net.coreprotect.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:127)
[14:22:13 WARN]: 	at CoreProtect.jar//net.coreprotect.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
[14:22:13 WARN]: 	at CoreProtect.jar//net.coreprotect.consumer.process.Process.commit(Process.java:303)
[14:22:13 WARN]: 	at CoreProtect.jar//net.coreprotect.consumer.process.Process.processConsumer(Process.java:258)
[14:22:13 WARN]: 	at CoreProtect.jar//net.coreprotect.consumer.Consumer.run(Consumer.java:133)
[14:22:13 WARN]: 	at java.base/java.lang.Thread.run(Unknown Source)
[14:22:13 WARN]: Caused by: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'art' at row 1
[14:22:13 WARN]: 	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:96)
[14:22:13 WARN]: 	at com.mysql.cj.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:613)
[14:22:13 WARN]: 	at com.mysql.cj.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:320)
[14:22:13 WARN]: 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1166)
[14:22:13 WARN]: 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1101)
[14:22:13 WARN]: 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1448)
[14:22:13 WARN]: 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchWithMultiValuesClause(ClientPreparedStatement.java:743)
[14:22:13 WARN]: 	... 8 more
[14:22:16 WARN]: java.sql.BatchUpdateException: Data truncation: Data too long for column 'art' at row 1
[14:22:16 WARN]: 	at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:214)
[14:22:16 WARN]: 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchWithMultiValuesClause(ClientPreparedStatement.java:782)
[14:22:16 WARN]: 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:456)
[14:22:16 WARN]: 	at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:858)
[14:22:16 WARN]: 	at CoreProtect.jar//net.coreprotect.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:127)
[14:22:16 WARN]: 	at CoreProtect.jar//net.coreprotect.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
[14:22:16 WARN]: 	at CoreProtect.jar//net.coreprotect.consumer.process.Process.commit(Process.java:303)
[14:22:16 WARN]: 	at CoreProtect.jar//net.coreprotect.consumer.process.Process.processConsumer(Process.java:258)
[14:22:16 WARN]: 	at CoreProtect.jar//net.coreprotect.consumer.Consumer.run(Consumer.java:133)
[14:22:16 WARN]: 	at java.base/java.lang.Thread.run(Unknown Source)
[14:22:16 WARN]: Caused by: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'art' at row 1
[14:22:16 WARN]: 	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:96)
[14:22:16 WARN]: 	at com.mysql.cj.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:613)
[14:22:16 WARN]: 	at com.mysql.cj.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:320)
[14:22:16 WARN]: 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1166)
[14:22:16 WARN]: 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1101)
[14:22:16 WARN]: 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1448)
[14:22:16 WARN]: 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchWithMultiValuesClause(ClientPreparedStatement.java:743)
[14:22:16 WARN]: 	... 8 more

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions