Comments (4)
Please send a copy of this file
from plan.
You can copy data from one database to another with mysqldump or mariadbdump (depending on your database)
from plan.
8ca6519994 - Last occurred: 2024-03-22 Occurrences: 1
---- Context 1 ----
Plan v5.6 build 2825
Velocity 3.3.0-SNAPSHOT (git-62c6ec04-b367)
Server v3.3.0-SNAPSHOT (git-62c6ec04-b367)
Report this, there is an SQL Constraint Violation.
Transaction: class com.djrapitops.plan.storage.database.transactions.init.CreateTablesTransaction
DB State: CLOSED - fatal: true
Error code: 1215
CREATE TABLE IF NOT EXISTS plan_allowlist_bounce (id integer NOT NULL AUTO_INCREMENT,uuid varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL UNIQUE,name varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,server_id integer NOT NULL,times integer NOT NULL DEFAULT 0,last_bounce bigint NOT NULL,PRIMARY KEY (id),FOREIGN KEY(server_id) REFERENCES plan_servers(id))
Constraint Violation
---- Stacktrace ----
java.util.concurrent.CompletionException: com.djrapitops.plan.exceptions.database.FatalDBException: com.djrapitops.plan.storage.database.transactions.init.CreateTablesTransaction failed to execute and database could not be opened: SQL Failure: Cannot add foreign key constraint
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.init.CreateTablesTransaction failed to execute and database could not be opened: SQL Failure: Cannot add foreign key constraint
com.djrapitops.plan.storage.database.transactions.init.OperationCriticalTransaction.executeTransaction(OperationCriticalTransaction.java:41)
com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:373)
com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:61)
com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56)
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.sql.SQLException: Cannot add foreign key constraint
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130)
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:912)
com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
plan.com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
plan.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
com.djrapitops.plan.storage.database.transactions.ExecStatement.callExecute(ExecStatement.java:72)
com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:64)
com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:55)
com.djrapitops.plan.storage.database.transactions.Transaction.execute(Transaction.java:223)
com.djrapitops.plan.storage.database.transactions.Transaction.execute(Transaction.java:231)
com.djrapitops.plan.storage.database.transactions.init.CreateTablesTransaction.performOperations(CreateTablesTransaction.java:62)
com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:89)
com.djrapitops.plan.storage.database.transactions.init.OperationCriticalTransaction.executeTransaction(OperationCriticalTransaction.java:36)
com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:373)
com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:61)
com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56)
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)
com.djrapitops.plan.storage.database.SQLDB.executeTransaction(SQLDB.java:359)
com.djrapitops.plan.storage.database.SQLDB.setupDatabase(SQLDB.java:262)
com.djrapitops.plan.storage.database.SQLDB.init(SQLDB.java:162)
com.djrapitops.plan.storage.database.DBSystem.enable(DBSystem.java:103)
com.djrapitops.plan.PlanSystem.enableSystems(PlanSystem.java:181)
com.djrapitops.plan.PlanSystem.enableOtherThanCommands(PlanSystem.java:138)
com.djrapitops.plan.PlanSystem.enable(PlanSystem.java:176)
com.djrapitops.plan.PlanVelocity.onEnable(PlanVelocity.java:112)
com.djrapitops.plan.PlanVelocity.onProxyStart(PlanVelocity.java:94)
com.djrapitops.plan.Lmbda$118.execute(Unknown Source)
com.velocitypowered.proxy.event.UntargetedEventHandler$VoidHandler.lambda$buildHandler$0(UntargetedEventHandler.java:56)
com.velocitypowered.proxy.event.VelocityEventManager.fire(VelocityEventManager.java:597)
java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
java.base/java.lang.reflect.Method.invoke(Method.java:580)
net.frankheijden.serverutils.dependencies.minecraftreflection.Reflection.invoke(Reflection.java:90)
net.frankheijden.serverutils.velocity.reflection.RVelocityEventManager.lambda$fireForPlugins$1(RVelocityEventManager.java:69)
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)
from plan.
Related Issues (20)
- Join address placeholder
- TPS Count Task Disabled due to error Fabric version HOT 1
- FastLogin integration plugin didn't report the correct client status in Plan HOT 9
- Suspected Memory Leak [Potentially caused by DDoS] HOT 9
- NOT NULL constraint violation occurred
- Providers don't get updated / removed if the condition changes to false HOT 4
- Add a tunnel proxy (cloudflare) HOT 2
- Console error HOT 2
- Possible bug with user ping graph - No data available HOT 8
- Ability to set the data gathering of player/server values (low priority)
- Exception when storing extension boolean value on MySQL [DEV release]
- %plan_join_address% seems not working :( Even in /plan ingame HOT 2
- Minor bug in extension boolean value storage
- Configure PlaceholderAPI playtime format separately
- Permissions for standard commands
- CompletionException with Litebans (SQL error) HOT 1
- ERR_NETWORK_CHANGED fails pipelines 50% of the time
- MBedwars added support
- Database server not even recognized? HOT 10
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from plan.