java.sql.SQLException: Can't create table 'signshoptest.cc34_balance' (errno: 121)

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

MySQL doesn't support some types of characters (such as emojis) with the utf8 encoding. You need to be on MySQL 5.5+ and force utf8mb4 (everywhere, client and server). You can do this sending the query "SET NAMES utf8mb4". Check this https://goo.gl/3E2qzg

Solutions on the web

via GitHub by dddeeefff
, 1 year ago
Can't create table 'signshoptest.cc34_balance' (errno: 121)
via GitHub by ojhunt
, 2 years ago
Can't create table 'commafeed.#sql-3e1_87a6' (errno: 150)
via GitHub by Murreey
, 2 years ago
Cannot load from mysql.proc. The table is probably corrupted
via Stack Overflow by Kerati Naveen
, 2 years ago
Can't create table 'Sensors_db.one' (errno: 121)
via knowcoding.com by Unknown author, 2 years ago
Can't create table 'university.student' (errno: 150)
java.sql.SQLException: Can't create table 'signshoptest.cc34_balance' (errno: 121)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
at com.greatmancode.com.zaxxer.libs.hikari.proxy.PreparedStatementProxy.executeUpdate(PreparedStatementProxy.java:61)
at com.greatmancode.com.zaxxer.libs.hikari.proxy.PreparedStatementJavassistProxy.executeUpdate(PreparedStatementJavassistProxy.java)
at com.greatmancode.craftconomy3.storage.sql.MySQLEngine.(MySQLEngine.java:75)
at com.greatmancode.craftconomy3.storage.StorageHandler.(StorageHandler.java:40)
at com.greatmancode.craftconomy3.Common.initialiseDatabase(Common.java:393)
at com.greatmancode.craftconomy3.commands.setup.NewSetupDatabaseCommand.mysql(NewSetupDatabaseCommand.java:140)
at com.greatmancode.craftconomy3.commands.setup.NewSetupDatabaseCommand.execute(NewSetupDatabaseCommand.java:48)
at com.greatmancode.craftconomy3.tools.commands.SubCommand.execute(SubCommand.java:69)
at com.greatmancode.craftconomy3.tools.commands.bukkit.BukkitCommandReceiver.onCommand(BukkitCommandReceiver.java:51)
at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)
at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141)
at org.bukkit.craftbukkit.v1_8_R3.CraftServer.dispatchCommand(CraftServer.java:642)
at net.minecraft.server.v1_8_R3.PlayerConnection.handleCommand(PlayerConnection.java:1135)
at net.minecraft.server.v1_8_R3.PlayerConnection.a(PlayerConnection.java:970)
at net.minecraft.server.v1_8_R3.PacketPlayInChat.a(PacketPlayInChat.java:45)
at net.minecraft.server.v1_8_R3.PacketPlayInChat.a(PacketPlayInChat.java:1)
at net.minecraft.server.v1_8_R3.PlayerConnectionUtils$1.run(SourceFile:13)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at net.minecraft.server.v1_8_R3.SystemUtils.a(SystemUtils.java:19)
at net.minecraft.server.v1_8_R3.MinecraftServer.B(MinecraftServer.java:714)
at net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java:367)
at net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:653)
at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:556)
at java.lang.Thread.run(Thread.java:745)

Users with the same issue

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

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