Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Converting SQLite to MYSQL doesn't work [Redesign the move to use smaller chunks] #3675

Open
bobhenl opened this issue Jun 22, 2024 · 0 comments
Open

Converting SQLite to MYSQL doesn't work [Redesign the move to use smaller chunks] #3675

bobhenl opened this issue Jun 22, 2024 · 0 comments
Labels
Bug Issues that contain unintended behavior

Comments

@bobhenl
Copy link

bobhenl commented Jun 22, 2024 •
edited
Loading

Describe the issue

Hi, I tried to convert from SQL to MYSQL, but everytime I get this message:

[20:39:14 ERROR]: [Plan] Database failed to open, com.djrapitops.plan.storage.database.transactions.BackupCopyTransaction failed to be executed.
[20:39:14 ERROR]: [Plan] Error msg: com.djrapitops.plan.storage.database.transactions.BackupCopyTransaction failed to execute and database could not be opened: SQL Failure: Lock wait timeout exceeded; try restarting transaction
[20:39:14 ERROR]: [Plan] Ran into CompletionException - logged to plugins/Plan/logs/CompletionException-da2e8bad8f.txt
[20:39:14 ERROR]: [Plan] (INCLUDE CONTENTS OF THE FILE IN ANY REPORTS)
[20:39:14 ERROR]: [Plan] Error msg: "com.djrapitops.plan.exceptions.database.FatalDBException: com.djrapitops.plan.storage.database.transactions.BackupCopyTransaction failed to execute and database could not be opened: SQL Failure: Lock wait timeout exceeded; try restarting transaction"
[20:39:14 ERROR]: [Plan] CRITICAL error triggered a plugin shutdown.

Exceptions & Other Logs

1f6fd0288a - Last occurred: 2024-06-21 Occurrences: 4
---- Context 4 ----
Plan v5.6 build 2883
Purpur git-Purpur-2165 (MC: 1.20.4)
Server v1.20.4-R0.1-SNAPSHOT

Transaction: class com.djrapitops.plan.storage.database.transactions.StoreServerInformationTransaction
DB State: CLOSED - fatal: false
Error code: 0
UPDATE plan_servers SET uuid=?,name=?,web_address=?,is_installed=?,is_proxy=?,plan_version=? WHERE (uuid=?)
Unknown SQL Error code

---- Context 3 ----
Plan v5.6 build 2883
Purpur git-Purpur-2165 (MC: 1.20.4)
Server v1.20.4-R0.1-SNAPSHOT

Transaction: class com.djrapitops.plan.storage.database.transactions.StoreServerInformationTransaction
DB State: CLOSED - fatal: false
Error code: 0
UPDATE plan_servers SET uuid=?,name=?,web_address=?,is_installed=?,is_proxy=?,plan_version=? WHERE (uuid=?)
Unknown SQL Error code

---- Context 2 ----
Plan v5.6 build 2883
Purpur git-Purpur-2165 (MC: 1.20.4)
Server v1.20.4-R0.1-SNAPSHOT

Transaction: class com.djrapitops.plan.storage.database.transactions.StoreServerInformationTransaction
DB State: CLOSED - fatal: false
Error code: 0
UPDATE plan_servers SET uuid=?,name=?,web_address=?,is_installed=?,is_proxy=?,plan_version=? WHERE (uuid=?)
Unknown SQL Error code

---- Context 1 ----
Plan v5.6 build 2883
Purpur git-Purpur-2165 (MC: 1.20.4)
Server v1.20.4-R0.1-SNAPSHOT

Transaction: class com.djrapitops.plan.storage.database.transactions.StoreServerInformationTransaction
DB State: CLOSED - fatal: false
Error code: 0
UPDATE plan_servers SET uuid=?,name=?,web_address=?,is_installed=?,is_proxy=?,plan_version=? WHERE (uuid=?)
Unknown SQL Error code

---- Stacktrace ----
java.util.concurrent.CompletionException: com.djrapitops.plan.exceptions.database.DBOpException: SQL Failure: Communications link failure

The last packet successfully received from the server was 39,148 milliseconds ago. The last packet sent successfully to the server was 39,148 milliseconds ago.
   java.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:315)
   java.base/java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:320)
   java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1770)
   java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
   java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
   java.base/java.lang.Thread.run(Thread.java:1583)
Caused by:
com.djrapitops.plan.exceptions.database.DBOpException: SQL Failure: Communications link failure

The last packet successfully received from the server was 39,148 milliseconds ago. The last packet sent successfully to the server was 39,148 milliseconds ago.
   Plan-5.6-build-2883.jar//com.djrapitops.plan.exceptions.database.DBOpException.forCause(DBOpException.java:153)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:57)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.Transaction.execute(Transaction.java:223)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.StoreServerInformationTransaction.performOperations(StoreServerInformationTransaction.java:42)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:89)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:373)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:78)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$5(SQLDB.java:372)
   java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
   java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
   java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
   java.base/java.lang.Thread.run(Thread.java:1583)
Caused by:
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet successfully received from the server was 39,148 milliseconds ago. The last packet sent successfully to the server was 39,148 milliseconds ago.
   com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
   com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:912)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1054)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1003)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1312)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:988)
   Plan-5.6-build-2883.jar//plan.com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
   Plan-5.6-build-2883.jar//plan.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.callExecute(ExecStatement.java:70)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:64)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:55)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.Transaction.execute(Transaction.java:223)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.StoreServerInformationTransaction.performOperations(StoreServerInformationTransaction.java:42)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:89)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:373)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:78)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$5(SQLDB.java:372)
   java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
   java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
   java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
   java.base/java.lang.Thread.run(Thread.java:1583)
Caused by:
com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

The last packet successfully received from the server was 39,148 milliseconds ago. The last packet sent successfully to the server was 39,148 milliseconds ago.
   java.base/jdk.internal.reflect.DirectConstructorHandleAccessor.newInstance(DirectConstructorHandleAccessor.java:62)
   java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:502)
   java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:486)
   com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
   com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:104)
   com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:149)
   com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:165)
   com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:582)
   com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:762)
   com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:701)
   com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:1050)
   com.mysql.cj.NativeSession.execSQL(NativeSession.java:660)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:889)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1054)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1003)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1312)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:988)
   Plan-5.6-build-2883.jar//plan.com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
   Plan-5.6-build-2883.jar//plan.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.callExecute(ExecStatement.java:70)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:64)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:55)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.Transaction.execute(Transaction.java:223)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.StoreServerInformationTransaction.performOperations(StoreServerInformationTransaction.java:42)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:89)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:373)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:78)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$5(SQLDB.java:372)
   java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
   java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
   java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
   java.base/java.lang.Thread.run(Thread.java:1583)
Caused by:
java.net.SocketException: Socket closed
   java.base/sun.nio.ch.NioSocketImpl.endRead(NioSocketImpl.java:243)
   java.base/sun.nio.ch.NioSocketImpl.implRead(NioSocketImpl.java:323)
   java.base/sun.nio.ch.NioSocketImpl.read(NioSocketImpl.java:346)
   java.base/sun.nio.ch.NioSocketImpl$1.read(NioSocketImpl.java:796)
   java.base/java.net.Socket$SocketInputStream.read(Socket.java:1099)
   com.mysql.cj.protocol.ReadAheadInputStream.fill(ReadAheadInputStream.java:107)
   com.mysql.cj.protocol.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:150)
   com.mysql.cj.protocol.ReadAheadInputStream.read(ReadAheadInputStream.java:180)
   java.base/java.io.FilterInputStream.read(FilterInputStream.java:119)
   com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64)
   com.mysql.cj.protocol.a.SimplePacketReader.readHeaderLocal(SimplePacketReader.java:81)
   com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63)
   com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45)
   com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52)
   com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41)
   com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54)
   com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44)
   com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:576)
   com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:762)
   com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:701)
   com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:1050)
   com.mysql.cj.NativeSession.execSQL(NativeSession.java:660)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:889)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1054)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1003)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1312)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:988)
   Plan-5.6-build-2883.jar//plan.com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
   Plan-5.6-build-2883.jar//plan.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.callExecute(ExecStatement.java:70)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:64)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:55)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.Transaction.execute(Transaction.java:223)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.StoreServerInformationTransaction.performOperations(StoreServerInformationTransaction.java:42)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:89)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:373)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:78)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$5(SQLDB.java:372)
   java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
   java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
   java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
   java.base/java.lang.Thread.run(Thread.java:1583)
   java.base/java.lang.Thread.getStackTrace(Thread.java:2450)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.SQLDB.executeTransaction(SQLDB.java:359)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.identification.storage.ServerDBLoader.save(ServerDBLoader.java:63)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.identification.storage.AtomicServerLoader.save(AtomicServerLoader.java:49)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.identification.ServerServerInfo.updateStorage(ServerServerInfo.java:99)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.processing.Processing.lambda$submitNonCritical$1(Processing.java:85)
   java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
   java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
   java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
   java.base/java.lang.Thread.run(Thread.java:1583)

Other ones were a bit smaller, but still the same error type

da2e8bad8f - Last occurred: 2024-06-21 Occurrences: 3
---- Context 3 ----
Plan v5.6 build 2883
Purpur git-Purpur-2165 (MC: 1.20.4)
Server v1.20.4-R0.1-SNAPSHOT

Transaction: class com.djrapitops.plan.storage.database.transactions.BackupCopyTransaction
DB State: CLOSED - fatal: true
Error code: 1205
DELETE FROM plan_settings
Unknown SQL Error code

---- Context 2 ----
Plan v5.6 build 2883
Purpur git-Purpur-2165 (MC: 1.20.4)
Server v1.20.4-R0.1-SNAPSHOT

Transaction: class com.djrapitops.plan.storage.database.transactions.BackupCopyTransaction
DB State: CLOSED - fatal: true
Error code: 1205
DELETE FROM plan_settings
Unknown SQL Error code

---- Context 1 ----
Plan v5.6 build 2883
Purpur git-Purpur-2165 (MC: 1.20.4)
Server v1.20.4-R0.1-SNAPSHOT

Transaction: class com.djrapitops.plan.storage.database.transactions.BackupCopyTransaction
DB State: CLOSED - fatal: true
Error code: 1205
DELETE FROM plan_settings
Unknown SQL Error code

---- Stacktrace ----
java.util.concurrent.CompletionException: com.djrapitops.plan.exceptions.database.FatalDBException: com.djrapitops.plan.storage.database.transactions.BackupCopyTransaction failed to execute and database could not be opened: SQL Failure: Lock wait timeout exceeded; try restarting transaction
   java.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:315)
   java.base/java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:320)
   java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1770)
   java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
   java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
   java.base/java.lang.Thread.run(Thread.java:1583)
Caused by:
com.djrapitops.plan.exceptions.database.FatalDBException: com.djrapitops.plan.storage.database.transactions.BackupCopyTransaction failed to execute and database could not be opened: SQL Failure: Lock wait timeout exceeded; try restarting transaction
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.init.OperationCriticalTransaction.executeTransaction(OperationCriticalTransaction.java:41)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:373)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:61)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$5(SQLDB.java:372)
   java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
   java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
   java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
   java.base/java.lang.Thread.run(Thread.java:1583)
Caused by:
com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
   com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:124)
   com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:912)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1054)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1003)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1312)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:988)
   Plan-5.6-build-2883.jar//plan.com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
   Plan-5.6-build-2883.jar//plan.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.callExecute(ExecStatement.java:70)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:64)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:55)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.Transaction.execute(Transaction.java:223)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.Transaction.execute(Transaction.java:231)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.commands.RemoveEverythingTransaction.clearTable(RemoveEverythingTransaction.java:74)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.commands.RemoveEverythingTransaction.applyPatch(RemoveEverythingTransaction.java:39)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.patches.Patch.performOperations(Patch.java:62)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.BackupCopyTransaction.performOperations(BackupCopyTransaction.java:51)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:89)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.init.OperationCriticalTransaction.executeTransaction(OperationCriticalTransaction.java:36)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:373)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:61)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$5(SQLDB.java:372)
   java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
   java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
   java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
   java.base/java.lang.Thread.run(Thread.java:1583)
   java.base/java.lang.Thread.getStackTrace(Thread.java:2450)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.SQLDB.executeTransaction(SQLDB.java:359)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.commands.subcommands.DatabaseCommands.performMove(DatabaseCommands.java:245)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.commands.subcommands.DatabaseCommands.lambda$onMove$4(DatabaseCommands.java:229)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.commands.subcommands.Confirmation.onConfirm(Confirmation.java:95)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.commands.subcommands.Confirmation.onAcceptCommand(Confirmation.java:118)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.commands.use.SubcommandBuilder.lambda$onCommand$0(SubcommandBuilder.java:54)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.commands.use.CommandWithSubcommands.executeCommand(CommandWithSubcommands.java:122)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.commands.use.CommandWithSubcommands.onCommand(CommandWithSubcommands.java:99)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.commands.use.BukkitCommand.lambda$onCommand$0(BukkitCommand.java:60)
   Plan-5.6-build-2883.jar//net.playeranalytics.plugin.scheduling.UnscheduledBukkitTask.run(UnscheduledBukkitTask.java:22)
   org.bukkit.craftbukkit.v1_20_R3.scheduler.CraftTask.run(CraftTask.java:101)
   org.bukkit.craftbukkit.v1_20_R3.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:57)
   com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22)
   java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
   java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
   java.base/java.lang.Thread.run(Thread.java:1583)

Btw I got also dboexception, not sure if it's related, but it was prob created after this, as this is only one of the occurrences of the error.

857b17631c - Last occurred: 2024-06-21 Occurrences: 1
---- Context 1 ----
Plan v5.6 build 2883
Purpur git-Purpur-2165 (MC: 1.20.4)
Server v1.20.4-R0.1-SNAPSHOT

Report this, there is an SQL grammar error.
Error code: 1146
SELECT uuid,name FROM plan_users
SQL Grammar error

---- Stacktrace ----
com.djrapitops.plan.exceptions.database.DBOpException: SQL Failure: Table 's60291_global.plan_users' doesn't exist
   Plan-5.6-build-2883.jar//com.djrapitops.plan.exceptions.database.DBOpException.forCause(DBOpException.java:153)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.queries.QueryStatement.executeWithConnection(QueryStatement.java:64)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.queries.QueryStatement.executeQuery(QueryStatement.java:52)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$query$2(SQLDB.java:339)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:102)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:87)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.SQLDB.query(SQLDB.java:339)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.commands.TabCompleteCache.refreshPlayerIdentifiers(TabCompleteCache.java:99)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.commands.TabCompleteCache.lambda$enable$0(TabCompleteCache.java:77)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.processing.Processing.lambda$submitNonCritical$1(Processing.java:85)
   java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
   java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
   java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
   java.base/java.lang.Thread.run(Thread.java:1583)
Caused by:
java.sql.SQLSyntaxErrorException: Table 's60291_global.plan_users' doesn't exist
   com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
   com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:912)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:968)
   Plan-5.6-build-2883.jar//plan.com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
   Plan-5.6-build-2883.jar//plan.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.queries.QueryStatement.executeQuery(QueryStatement.java:72)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.queries.QueryStatement.executeWithConnection(QueryStatement.java:62)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.queries.QueryStatement.executeQuery(QueryStatement.java:52)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$query$2(SQLDB.java:339)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:102)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:87)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.SQLDB.query(SQLDB.java:339)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.commands.TabCompleteCache.refreshPlayerIdentifiers(TabCompleteCache.java:99)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.commands.TabCompleteCache.lambda$enable$0(TabCompleteCache.java:77)
   Plan-5.6-build-2883.jar//com.djrapitops.plan.processing.Processing.lambda$submitNonCritical$1(Processing.java:85)
   java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
   java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
   java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
   java.base/java.lang.Thread.run(Thread.java:1583)

And finally, the same type happened a few hours before, but I moved my server to another host, not sure if it's somehow related? But this time file is so big so I upload it as the whole file
DBOpException-e1a093fb5d.txt
Also regarding database.db it has 166868 KB size
image
And cached files are also a bit larger
image
image

It takes long time until it's some queries are loaded so I wanted to switch to mysql

Plugin versions

[13:25:10 INFO]: Plan version 5.6 build 2883
[13:25:10 INFO]: Author: AuroraLS3

Additional information

Already mentioned earlier
@bobhenl bobhenl added the Bug Issues that contain unintended behavior label Jun 22, 2024
@AuroraLS3 AuroraLS3 changed the title So much data while converting SQL to MYSQL doesn't work Converting SQLite to MYSQL doesn't work [Redesign the move to use smaller chunks] Jun 24, 2024
@github-project-automation github-project-automation bot moved this to INBOX in Backlog Jun 24, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Bug Issues that contain unintended behavior
Projects
Backlog
Status: INBOX
Milestone
No milestone
Development

No branches or pull requests
1 participant
@bobhenl