Error when creating a Currency #191
Description
Newest MedievalFactions & Currencies Version
Paper 1.21.3 newest Build
[21:09:27 INFO]: gmrrh issued server command: /currency create SantiagoReal
[21:09:29 INFO]: gmrrh issued server command: /currency create SantiagoReal --rename
[21:09:29 ERROR]: [Currencies] Failed to save currency: Service error: SQL [merge into "currencies_currency" using (select "t"."id", "t"."version", "t"."faction_id", "t"."name", "t"."description", "t"."item", "t"."amount", "t"."status", "t"."legacy_id" from (select cast(? as varchar(36)), cast(? as int), cast(? as varchar(36)), cast(? as varchar(256)), cast(? as varchar(4096)), cast(? as blob), cast(? as int), cast(? as varchar(8)), cast(? as int)) "t" ("id", "version", "faction_id", "name", "description", "item", "amount", "status", "legacy_id")) "t" on "currencies_currency"."id" = "t"."id" when matched and ("currencies_currency"."id" = cast(? as varchar(36)) and "currencies_currency"."version" = cast(? as int)) then update set "currencies_currency"."faction_id" = ?, "currencies_currency"."name" = ?, "currencies_currency"."description" = ?, "currencies_currency"."item" = ?, "currencies_currency"."amount" = ?, "currencies_currency"."status" = ?, "currencies_currency"."legacy_id" = ?, "currencies_currency"."version" = ? when not matched then insert ("id", "version", "faction_id", "name", "description", "item", "amount", "status", "legacy_id") values ("t"."id", "t"."version", "t"."faction_id", "t"."name", "t"."description", "t"."item", "t"."amount", "t"."status", "t"."legacy_id")]; (Message 23505 not found); SQL statement:
merge into "currencies_currency" using (select "t"."id", "t"."version", "t"."faction_id", "t"."name", "t"."description", "t"."item", "t"."amount", "t"."status", "t"."legacy_id" from (select cast(? as varchar(36)), cast(? as int), cast(? as varchar(36)), cast(? as varchar(256)), cast(? as varchar(4096)), cast(? as blob), cast(? as int), cast(? as varchar(8)), cast(? as int)) "t" ("id", "version", "faction_id", "name", "description", "item", "amount", "status", "legacy_id")) "t" on "currencies_currency"."id" = "t"."id" when matched and ("currencies_currency"."id" = cast(? as varchar(36)) and "currencies_currency"."version" = cast(? as int)) then update set "currencies_currency"."faction_id" = ?, "currencies_currency"."name" = ?, "currencies_currency"."description" = ?, "currencies_currency"."item" = ?, "currencies_currency"."amount" = ?, "currencies_currency"."status" = ?, "currencies_currency"."legacy_id" = ?, "currencies_currency"."version" = ? when not matched then insert ("id", "version", "faction_id", "name", "description", "item", "amount", "status", "legacy_id") values ("t"."id", "t"."version", "t"."faction_id", "t"."name", "t"."description", "t"."item", "t"."amount", "t"."status", "t"."legacy_id") [23505-214]
com.dansplugins.factionsystem.shadow.org.jooq.exception.DataAccessException: SQL [merge into "currencies_currency" using (select "t"."id", "t"."version", "t"."faction_id", "t"."name", "t"."description", "t"."item", "t"."amount", "t"."status", "t"."legacy_id" from (select cast(? as varchar(36)), cast(? as int), cast(? as varchar(36)), cast(? as varchar(256)), cast(? as varchar(4096)), cast(? as blob), cast(? as int), cast(? as varchar(8)), cast(? as int)) "t" ("id", "version", "faction_id", "name", "description", "item", "amount", "status", "legacy_id")) "t" on "currencies_currency"."id" = "t"."id" when matched and ("currencies_currency"."id" = cast(? as varchar(36)) and "currencies_currency"."version" = cast(? as int)) then update set "currencies_currency"."faction_id" = ?, "currencies_currency"."name" = ?, "currencies_currency"."description" = ?, "currencies_currency"."item" = ?, "currencies_currency"."amount" = ?, "currencies_currency"."status" = ?, "currencies_currency"."legacy_id" = ?, "currencies_currency"."version" = ? when not matched then insert ("id", "version", "faction_id", "name", "description", "item", "amount", "status", "legacy_id") values ("t"."id", "t"."version", "t"."faction_id", "t"."name", "t"."description", "t"."item", "t"."amount", "t"."status", "t"."legacy_id")]; (Message 23505 not found); SQL statement:
merge into "currencies_currency" using (select "t"."id", "t"."version", "t"."faction_id", "t"."name", "t"."description", "t"."item", "t"."amount", "t"."status", "t"."legacy_id" from (select cast(? as varchar(36)), cast(? as int), cast(? as varchar(36)), cast(? as varchar(256)), cast(? as varchar(4096)), cast(? as blob), cast(? as int), cast(? as varchar(8)), cast(? as int)) "t" ("id", "version", "faction_id", "name", "description", "item", "amount", "status", "legacy_id")) "t" on "currencies_currency"."id" = "t"."id" when matched and ("currencies_currency"."id" = cast(? as varchar(36)) and "currencies_currency"."version" = cast(? as int)) then update set "currencies_currency"."faction_id" = ?, "currencies_currency"."name" = ?, "currencies_currency"."description" = ?, "currencies_currency"."item" = ?, "currencies_currency"."amount" = ?, "currencies_currency"."status" = ?, "currencies_currency"."legacy_id" = ?, "currencies_currency"."version" = ? when not matched then insert ("id", "version", "faction_id", "name", "description", "item", "amount", "status", "legacy_id") values ("t"."id", "t"."version", "t"."faction_id", "t"."name", "t"."description", "t"."item", "t"."amount", "t"."status", "t"."legacy_id") [23505-214]
at com.dansplugins.factionsystem.shadow.org.jooq_3.16.4.H2.debug(Unknown Source) ~[?:?]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.org.jooq.impl.Tools.translate(Tools.java:3089) ~[medieval-factions-5.6.0-all.jar:?]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:670) ~[medieval-factions-5.6.0-all.jar:?]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:354) ~[medieval-factions-5.6.0-all.jar:?]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.org.jooq.impl.AbstractDelegatingQuery.execute(AbstractDelegatingQuery.java:115) ~[medieval-factions-5.6.0-all.jar:?]
at currencies-2.1.0-all.jar/com.dansplugins.currencies.currency.JooqCurrencyRepository.upsert(JooqCurrencyRepository.kt:45) ~[currencies-2.1.0-all.jar:?]
at currencies-2.1.0-all.jar/com.dansplugins.currencies.currency.CurrencyService.save(CurrencyService.kt:38) ~[currencies-2.1.0-all.jar:?]
at currencies-2.1.0-all.jar/com.dansplugins.currencies.command.currency.create.CurrencyCreateCommand.onCommand$lambda-7(CurrencyCreateCommand.kt:101) ~[currencies-2.1.0-all.jar:?]
at org.bukkit.craftbukkit.scheduler.CraftTask.run(CraftTask.java:78) ~[paper-1.21.3.jar:1.21.3-83-d6c81da]
at org.bukkit.craftbukkit.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:57) ~[paper-1.21.3.jar:1.21.3-83-d6c81da]
at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22) ~[paper-1.21.3.jar:?]
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[?:?]
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[?:?]
at java.base/java.lang.Thread.run(Thread.java:1583) ~[?:?]
Caused by: com.dansplugins.factionsystem.shadow.org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: (Message 23505 not found); SQL statement:
merge into "currencies_currency" using (select "t"."id", "t"."version", "t"."faction_id", "t"."name", "t"."description", "t"."item", "t"."amount", "t"."status", "t"."legacy_id" from (select cast(? as varchar(36)), cast(? as int), cast(? as varchar(36)), cast(? as varchar(256)), cast(? as varchar(4096)), cast(? as blob), cast(? as int), cast(? as varchar(8)), cast(? as int)) "t" ("id", "version", "faction_id", "name", "description", "item", "amount", "status", "legacy_id")) "t" on "currencies_currency"."id" = "t"."id" when matched and ("currencies_currency"."id" = cast(? as varchar(36)) and "currencies_currency"."version" = cast(? as int)) then update set "currencies_currency"."faction_id" = ?, "currencies_currency"."name" = ?, "currencies_currency"."description" = ?, "currencies_currency"."item" = ?, "currencies_currency"."amount" = ?, "currencies_currency"."status" = ?, "currencies_currency"."legacy_id" = ?, "currencies_currency"."version" = ? when not matched then insert ("id", "version", "faction_id", "name", "description", "item", "amount", "status", "legacy_id") values ("t"."id", "t"."version", "t"."faction_id", "t"."name", "t"."description", "t"."item", "t"."amount", "t"."status", "t"."legacy_id") [23505-214]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.org.h2.message.DbException.getJdbcSQLException(DbException.java:508) ~[medieval-factions-5.6.0-all.jar:?]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.org.h2.message.DbException.getJdbcSQLException(DbException.java:477) ~[medieval-factions-5.6.0-all.jar:?]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.org.h2.message.DbException.get(DbException.java:223) ~[medieval-factions-5.6.0-all.jar:?]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.org.h2.message.DbException.get(DbException.java:199) ~[medieval-factions-5.6.0-all.jar:?]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.org.h2.index.Index.getDuplicateKeyException(Index.java:525) ~[medieval-factions-5.6.0-all.jar:?]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.org.h2.mvstore.db.MVSecondaryIndex.checkUnique(MVSecondaryIndex.java:223) ~[medieval-factions-5.6.0-all.jar:?]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.org.h2.mvstore.db.MVSecondaryIndex.add(MVSecondaryIndex.java:184) ~[medieval-factions-5.6.0-all.jar:?]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.org.h2.mvstore.db.MVTable.addRow(MVTable.java:519) ~[medieval-factions-5.6.0-all.jar:?]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.org.h2.command.dml.MergeUsing$WhenNotMatched.merge(MergeUsing.java:509) ~[medieval-factions-5.6.0-all.jar:?]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.org.h2.command.dml.MergeUsing.merge(MergeUsing.java:154) ~[medieval-factions-5.6.0-all.jar:?]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.org.h2.command.dml.MergeUsing.update(MergeUsing.java:135) ~[medieval-factions-5.6.0-all.jar:?]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.org.h2.command.dml.DataChangeStatement.update(DataChangeStatement.java:74) ~[medieval-factions-5.6.0-all.jar:?]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.org.h2.command.CommandContainer.update(CommandContainer.java:169) ~[medieval-factions-5.6.0-all.jar:?]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.org.h2.command.Command.executeUpdate(Command.java:252) ~[medieval-factions-5.6.0-all.jar:?]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:254) ~[medieval-factions-5.6.0-all.jar:?]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) ~[medieval-factions-5.6.0-all.jar:?]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) ~[medieval-factions-5.6.0-all.jar:?]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:219) ~[medieval-factions-5.6.0-all.jar:?]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:419) ~[medieval-factions-5.6.0-all.jar:?]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.org.jooq.impl.AbstractDMLQuery.execute(AbstractDMLQuery.java:961) ~[medieval-factions-5.6.0-all.jar:?]
at medieval-factions-5.6.0-all.jar/com.dansplugins.factionsystem.shadow.org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:340) ~[medieval-factions-5.6.0-all.jar:?]
... 10 more