org.h2.jdbc.JdbcSQLException: Value too long for column "ID VARCHAR(36)": "'nation-0821d04a-e64c-437c-8a6a-1a8635e9175e' (43)"; SQL statement: INSERT INTO economylitevirts (`id`, `balance`, `currency`) VALUES (?, ?, ?) [22001-192]

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

Samebug tips

,
Expert tip

Check if you're not creating unused SQL entities, as it might cause this exception.

Solutions on the web

via GitHub by 5igm
, 1 year ago
Value too long for column "ID VARCHAR(36)": "'nation-0821d04a-e64c-437c-8a6a-1a8635e9175e' (43)"; SQL statement: INSERT INTO economylitevirts (`id`, `balance`, `currency`) VALUES (?, ?, ?) [22001-192]
via GitHub by victorjerlin
, 1 year ago
Value too long for column "TARGET_DESC VARCHAR(255) DEFAULT '-unkown-' SELECTIVITY 33": "table,region-name-that-is-very-loong... (358)"; SQL statement: INSERT INTO metric(target, name, last_value, last_update, target_desc) VALUES (?, ?, 0.0, 0, ?) [22001-158]
via GitHub by chuy08
, 1 year ago
Value too long for column "TARGET_DESC VARCHAR(255) DEFAULT '-unkown-' SELECTIVITY 25": "'tsdb,\x00\x00\x16Q\x12\x8C\x10\x00\x00\x01\x00\x19x\x00\x00\x02\x00\x00\x02\x00\x00\x03\x00\x19t\x00\x00\x04\x00\x00\x04\x00\x0... (261)"; SQL statement: INSERT INTO metric(target, name, last_value, last_update, target_desc) VALUES (?, ?, 0.0, 0, ?) [22001-158]
via Google Groups by Sunil Tantry, 1 year ago
Value too long for column "FILTER VARCHAR(255)": "'name: server1,server2... (414)"; SQL statement: insert into execution (id, version, abortedby, arg_string, cancelled, date_completed, date_started, do_nodedispatch, failed_node_list, filter
via GitHub by 20rostantino12
, 2 years ago
Value too long for column "FILTER VARCHAR(255)": "'name: server137-MAPI,server138-MAS,server139-MAPI,server140-MAS,server141-MAPI,server142-MAS,FRPA... (378)"; SQL statement: insert into execution (id, version, abortedby, arg_string, cancelled
via GitHub by GoogleCodeExporter
, 7 months ago
メモリが不足しています Out of memory.; SQL statement: insert into t2(id) select t1.id from t1 group by t1.id [90108-140]
org.h2.jdbc.JdbcSQLException: Value too long for column "ID VARCHAR(36)": "'nation-0821d04a-e64c-437c-8a6a-1a8635e9175e' (43)"; SQL statement: INSERT INTO economylitevirts (`id`, `balance`, `currency`) VALUES (?, ?, ?) [22001-192]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.table.Column.validateConvertUpdateSequence(Column.java:335)
at org.h2.table.Table.validateConvertUpdateSequence(Table.java:784)
at org.h2.command.dml.Insert.insertRows(Insert.java:151)
at org.h2.command.dml.Insert.update(Insert.java:114)
at org.h2.command.CommandContainer.update(CommandContainer.java:98)
at org.h2.command.Command.executeUpdate(Command.java:258)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:160)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:146)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
at io.github.flibio.economylite.utils.sql.SqlManager.executeUpdate(SqlManager.java:118)
at io.github.flibio.economylite.impl.VirtualServiceCommon.setBalance(VirtualServiceCommon.java:77)
at io.github.flibio.economylite.impl.economy.LiteEconomyService.getOrCreateAccount(LiteEconomyService.java:81)
at com.arckenver.nations.cmdexecutor.nation.NationCreateExecutor.execute(NationCreateExecutor.java:111)
at org.spongepowered.api.command.args.ChildCommandElementExecutor.execute(ChildCommandElementExecutor.java:179)
at org.spongepowered.api.command.spec.CommandSpec.process(CommandSpec.java:332)
at org.spongepowered.api.command.dispatcher.SimpleDispatcher.process(SimpleDispatcher.java:333)
at org.spongepowered.common.command.SpongeCommandManager.process(SpongeCommandManager.java:274)
at net.minecraft.command.ServerCommandManager.func_71556_a(SourceFile:82)
at net.minecraft.network.NetHandlerPlayServer.func_147361_d(NetHandlerPlayServer.java:913)
at net.minecraft.network.NetHandlerPlayServer.func_147354_a(NetHandlerPlayServer.java:892)
at net.minecraft.network.play.client.CPacketChatMessage.func_148833_a(SourceFile:37)
at org.spongepowered.common.network.PacketUtil.onProcessPacket(PacketUtil.java:118)
at net.minecraft.network.PacketThreadUtil$1.redirect$onProcessPacket$0(SourceFile:39)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at net.minecraft.util.Util.func_181617_a(SourceFile:45)
at net.minecraft.server.MinecraftServer.func_71190_q(MinecraftServer.java:668)
at net.minecraft.server.dedicated.DedicatedServer.func_71190_q(DedicatedServer.java:387)
at net.minecraft.server.MinecraftServer.func_71217_p(MinecraftServer.java:613)
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:471)
at java.lang.Thread.run(Unknown Source)

Users with the same issue

Once, 6 months ago
3 times, 6 months ago
4 times, 3 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Once, 10 months ago
150 more bugmates

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