Problem mit Datenbank

[Eiki]

Moin Stefan,

beim durchsehen des Logs vom Bot ist mir dies aufgefallen was schon etwas gespamt wird.

Code Select Expand

2019-11-14 22:29:22 LOGGER_SQL_CONNECT Successfully connected to MySQL server for logging!
2019-11-14 22:29:22 LOGGER_SQL_ERROR Critical: Cannot write log entry to MySQL server!
2019-11-14 22:29:22 JTS3ServerMod 6.5.5 Hosting Edition (27.01.2019): EXCEPTION
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect string value: '\xF0\x9F\x90\x8D\xF0\x9F...' for column `tsbot`.`jts3servermod_log`.`message` at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2124)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2058)
at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5158)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2043)
at de.stefan1200.jts3servermod.t.a(Unknown Source)
at de.stefan1200.jts3servermod.t.a(Unknown Source)
at de.stefan1200.jts3servermod.t.a(Unknown Source)
at de.stefan1200.jts3servermod.JTS3ServerMod.teamspeakActionPerformed(Unknown Source)
at de.stefan1200.jts3serverquery.JTS3ServerQuery$2.run(Unknown Source)
at java.base/java.lang.Thread.run(Thread.java:834)

Gruß

Eiki

[Stefan1200]

Einmal die komplette Bot Log über das Webinterface löschen.

[Eiki]

Jo hab ich gemacht mal gucken wie sich das jetzt verhält.

[Eiki]

Hatte das ja alles gelöscht als ich jetzt wieder nachgeschaut habe ist es wieder drin.

Code Select Expand

2019-11-15 14:19:50 LOGGER_SQL_ERROR Critical: Cannot write log entry to MySQL server!
2019-11-15 14:19:50 JTS3ServerMod 6.5.5 Hosting Edition (27.01.2019): EXCEPTION
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect string value: '\xF0\x9F\x90\x8D\xF0\x9F...' for column `tsbot`.`jts3servermod_log`.`message` at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2124)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2058)
at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5158)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2043)
at de.stefan1200.jts3servermod.t.a(Unknown Source)
at de.stefan1200.jts3servermod.t.a(Unknown Source)
at de.stefan1200.jts3servermod.JTS3ServerMod.teamspeakActionPerformed(Unknown Source)
at de.stefan1200.jts3serverquery.JTS3ServerQuery$2.run(Unknown Source)
at java.base/java.lang.Thread.run(Thread.java:834)
2019-11-15 14:19:50 LOGGER_SQL_ERROR Try to reconnect to MySQL server...
2019-11-15 14:19:50 LOGGER_SQL_CONNECT Successfully connected to MySQL server for logging!
2019-11-15 14:19:50 LOGGER_SQL_ERROR Critical: Cannot write log entry to MySQL server!
2019-11-15 14:19:50 JTS3ServerMod 6.5.5 Hosting Edition (27.01.2019): EXCEPTION
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect string value: '\xF0\x9F\x90\x8D\xF0\x9F...' for column `tsbot`.`jts3servermod_log`.`message` at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2124)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2058)
at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5158)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2043)
at de.stefan1200.jts3servermod.t.a(Unknown Source)
at de.stefan1200.jts3servermod.t.a(Unknown Source)
at de.stefan1200.jts3servermod.t.a(Unknown Source)
at de.stefan1200.jts3servermod.JTS3ServerMod.teamspeakActionPerformed(Unknown Source)
at de.stefan1200.jts3serverquery.JTS3ServerQuery$2.run(Unknown Source)
at java.base/java.lang.Thread.run(Thread.java:834)
2019-11-15 15:19:38 LOGGER_SQL_CONNECT Successfully connected to MySQL server for logging!
2019-11-15 15:25:26 LOGGER_SQL_ERROR Critical: Cannot write log entry to MySQL server!
2019-11-15 15:25:26 JTS3ServerMod 6.5.5 Hosting Edition (27.01.2019): EXCEPTION

[Stefan1200]

Vermutlich ein Channel oder Client Namen, der ins Log geschrieben wird, dass die verwendete Tabellen Collation nicht unterstützt. Gerne mal eine andere UTF8 Collation für die Log Tabelle probieren.

[monster010]

Nutz die Collation utf8mb4_unicode_ci

Das Problem sind die Emoji's die man mittlerweile in Client oder Channel Namen verwenden kann, habs schon bei nem anderen Bot gehabt, dadurch ist mir das dann auch aufgefallen.