Page MenuHomeSchine - Phabricator

Starmade | /import_sector fails due to SQL error: "integrity constraint violation: foreign key no action; EFKC table: FLEET_MEMBERS"
Closed, FinishedPublic

Description

Importing sectors fails due to SQL exception.

[2016-07-12 11:46:44] [IMPORTSECTOR] PARSED SECTOR FILE: Pos (7, 8, 3); Type 2; SubType: 0
[2016-07-12 11:46:44] [SQL] SECTOR QUERY TOOK 2ms
[2016-07-12 11:46:44] java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: foreign key no action; EFKC table: FLEET_MEMBERS
[2016-07-12 11:46:44] 	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
[2016-07-12 11:46:44] 	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
[2016-07-12 11:46:44] 	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
[2016-07-12 11:46:44] 	at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source)
[2016-07-12 11:46:44] 	at org.schema.game.common.controller.database.DatabaseIndex.a(SourceFile:3579)
[2016-07-12 11:46:44] 	at obfuscated.apK.a(SourceFile:226)
[2016-07-12 11:46:44] 	at obfuscated.apK.a(SourceFile:478)
[2016-07-12 11:46:44] 	at obfuscated.apK.a(SourceFile:604)
[2016-07-12 11:46:44] 	at obfuscated.asd.a(SourceFile:28)
[2016-07-12 11:46:44] 	at org.schema.game.server.controller.GameServerController.update(SourceFile:974)
[2016-07-12 11:46:44] 	at org.schema.schine.network.server.ServerController.run(SourceFile:270)
[2016-07-12 11:46:44] 	at java.lang.Thread.run(Thread.java:744)
[2016-07-12 11:46:44] Caused by: org.hsqldb.HsqlException: integrity constraint violation: foreign key no action; EFKC table: FLEET_MEMBERS
[2016-07-12 11:46:44] 	at org.hsqldb.error.Error.error(Unknown Source)
[2016-07-12 11:46:44] 	at org.hsqldb.StatementDML.performReferentialActions(Unknown Source)
[2016-07-12 11:46:44] 	at org.hsqldb.StatementDML.delete(Unknown Source)
[2016-07-12 11:46:44] 	at org.hsqldb.StatementDML.executeDeleteStatement(Unknown Source)
[2016-07-12 11:46:44] 	at org.hsqldb.StatementDML.getResult(Unknown Source)
[2016-07-12 11:46:44] 	at org.hsqldb.StatementDMQL.execute(Unknown Source)
[2016-07-12 11:46:44] 	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
[2016-07-12 11:46:44] 	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
[2016-07-12 11:46:44] 	at org.hsqldb.Session.execute(Unknown Source)
[2016-07-12 11:46:44] 	... 10 more
[2016-07-12 11:46:44] EXCEPTION OCCURRED: REMOVING TMP FILES
[2016-07-12 11:46:44] [SEND][SERVERMESSAGE] sector importing failed: IOException: SQLIntegrityConstraintViolationException: integrity constraint violation: foreign key no action; EFKC table: FLEET_MEMBERS to RegisteredClient: AndyP (1) [AndyP]connected: true
[2016-07-12 11:46:44] java.io.IOException: SQLIntegrityConstraintViolationException: integrity constraint violation: foreign key no action; EFKC table: FLEET_MEMBERS
[2016-07-12 11:46:44] 	at obfuscated.apK.a(SourceFile:599)
[2016-07-12 11:46:44] 	at obfuscated.apK.a(SourceFile:604)
[2016-07-12 11:46:44] 	at obfuscated.asd.a(SourceFile:28)
[2016-07-12 11:46:44] 	at org.schema.game.server.controller.GameServerController.update(SourceFile:974)
[2016-07-12 11:46:44] 	at org.schema.schine.network.server.ServerController.run(SourceFile:270)
[2016-07-12 11:46:44] 	at java.lang.Thread.run(Thread.java:744)
[2016-07-12 11:46:58] [ADMIN COMMAND] IMPORT_SECTOR from RegisteredClient: AndyP (1) [AndyP]connected: true params: [7, 8, 3, Empty]
[2016-07-12 11:46:58] Extracting file: sector/sector.cfg exists: true, is Dir: true. /home/starmade/starmade/StarMade/./sector-export/tmp
[2016-07-12 11:46:58] [IMPORTSECTOR] PARSED SECTOR FILE: Pos (7, 8, 3); Type 1; SubType: 0
[2016-07-12 11:46:58] [SQL] SECTOR QUERY TOOK 1ms
[2016-07-12 11:46:58] java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: foreign key no action; EFKC table: FLEET_MEMBERS
[2016-07-12 11:46:58] 	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
[2016-07-12 11:46:58] 	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
[2016-07-12 11:46:58] 	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
[2016-07-12 11:46:58] 	at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source)
[2016-07-12 11:46:58] 	at org.schema.game.common.controller.database.DatabaseIndex.a(SourceFile:3579)
[2016-07-12 11:46:58] 	at obfuscated.apK.a(SourceFile:226)
[2016-07-12 11:46:58] 	at obfuscated.apK.a(SourceFile:478)
[2016-07-12 11:46:58] 	at obfuscated.apK.a(SourceFile:604)
[2016-07-12 11:46:58] 	at obfuscated.asd.a(SourceFile:28)
[2016-07-12 11:46:58] 	at org.schema.game.server.controller.GameServerController.update(SourceFile:974)
[2016-07-12 11:46:58] 	at org.schema.schine.network.server.ServerController.run(SourceFile:270)
[2016-07-12 11:46:58] 	at java.lang.Thread.run(Thread.java:744)
[2016-07-12 11:46:58] Caused by: org.hsqldb.HsqlException: integrity constraint violation: foreign key no action; EFKC table: FLEET_MEMBERS
[2016-07-12 11:46:58] 	at org.hsqldb.error.Error.error(Unknown Source)
[2016-07-12 11:46:58] 	at org.hsqldb.StatementDML.performReferentialActions(Unknown Source)
[2016-07-12 11:46:58] 	at org.hsqldb.StatementDML.delete(Unknown Source)
[2016-07-12 11:46:58] 	at org.hsqldb.StatementDML.executeDeleteStatement(Unknown Source)
[2016-07-12 11:46:58] 	at org.hsqldb.StatementDML.getResult(Unknown Source)
[2016-07-12 11:46:58] 	at org.hsqldb.StatementDMQL.execute(Unknown Source)
[2016-07-12 11:46:58] 	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
[2016-07-12 11:46:58] 	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
[2016-07-12 11:46:58] 	at org.hsqldb.Session.execute(Unknown Source)
[2016-07-12 11:46:58] 	... 10 more
[2016-07-12 11:46:58] EXCEPTION OCCURRED: REMOVING TMP FILES
[2016-07-12 11:46:58] [SEND][SERVERMESSAGE] sector importing failed: IOException: SQLIntegrityConstraintViolationException: integrity constraint violation: foreign key no action; EFKC table: FLEET_MEMBERS to RegisteredClient: AndyP (1) [AndyP]connected: true
[2016-07-12 11:46:58] java.io.IOException: SQLIntegrityConstraintViolationException: integrity constraint violation: foreign key no action; EFKC table: FLEET_MEMBERS
[2016-07-12 11:46:58] 	at obfuscated.apK.a(SourceFile:599)
[2016-07-12 11:46:58] 	at obfuscated.apK.a(SourceFile:604)
[2016-07-12 11:46:58] 	at obfuscated.asd.a(SourceFile:28)
[2016-07-12 11:46:58] 	at org.schema.game.server.controller.GameServerController.update(SourceFile:974)
[2016-07-12 11:46:58] 	at org.schema.schine.network.server.ServerController.run(SourceFile:270)
[2016-07-12 11:46:58] 	at java.lang.Thread.run(Thread.java:744)
[2016-07-12 11:47:20] [SERVERSOCKET] Connection made. starting new processor 56114, /144.76.8.142; local: 4242, /144.76.174.130, keepalive false
[2016-07-12 11:47:20] [SERVER] ListenerId[0] connection registered (TRunning: 1/1/1) 52
[2016-07-12 11:47:20] [SERVER][PROCESSOR] client setup completed for PID: 52. listening for input
[2016-07-12 11:47:20] [SERVER] This client is an info ping (server-lists): /144.76.8.142; PID: 52
[2016-07-12 11:47:20] [SERVER] SCHEDULED DISCONNECT EXECUTING
[2016-07-12 11:47:20] [SERVER] Executing scheduled disconnect!; ProcessorID: 52
[2016-07-12 11:47:20] [SERVER][DISCONNECT] Client 'Info-Pinger (server-lists)' HAS BEEN DISCONNECTED . PROBE: true; ProcessorID: 52
[2016-07-12 11:47:20] [SERVER] PROBE SUCCESSFULLY EXECUTED. STOPPING PROCESSOR. (Ping of a Starter to start server): PID 52

Details

Task Type
Bug
Testing Results
Affected Gamemode(s)
Serverside
Reproducible
Yes
Last tested (version)
0.198.468
Category
Engine
Hardware/Software/System
OS-Specific
No
Hardware-Specific
No
Video Card Vendor
uncertain
Steps to reproduce
  • import a sector

(No difference between old and new exports, seems to always fail on import.)

Event Timeline

AndyP created this task.Jul 12 2016, 9:42 AM
AndyP updated the task description. (Show Details)
AndyP changed Affected Gamemode(s) from Single and Multi to Serverside.
AndyP set Last tested (version) to 0.198.468.
AndyP changed Category from none/unspecified to Engine.
AndyP edited Serverconfig (server.cfg). (Show Details)
AndyP edited Clientconfig (settings.cfg). (Show Details)
schema changed the task status from In Queue (Game) to Resolved.Jul 18 2016, 5:01 PM
Restricted Application edited projects, added Quality Assurance; removed Game Development. · View Herald TranscriptJul 18 2016, 5:01 PM

Looks like it is fixed, could import 2 sectors and all of it was intact.

AndyP closed this task as Closed.Jul 18 2016, 8:58 PM

-QA Testing-

Fix confirmed.
Exporting, and also importing of new exports, or older exports does work.

Restricted Application removed a project: Quality Assurance. · View Herald TranscriptJul 18 2016, 8:58 PM
AndyP removed a subscriber: AndyP.Dec 13 2016, 8:37 PM
Restricted Application added a project: Engine. · View Herald TranscriptMar 10 2017, 6:10 PM