- Joined
- Aug 21, 2015
- Messages
- 585
- Reaction score
- 327
Unfortunately, our server at Light vs Dark suffered a critical issue where our world file seems to have corrupted the next day, after the latest update.
The server was updated at 3am EST 06-20-16
The server underwent a restart at 5pm successfully.
At around 9:30pm the server suddenly started crashing. I use a loop to restart the server when it crashes, and this pushed out the original log file since the server was caught in a restart loop.
We had to load up the backup from 3am before the update to fix the issue, losing all progress for the day.
The server is running on a 6-core xeon processor, with 24gb of RAM assigned to the server, running Ubuntu Server 16.
Here's the log from when the crash happens upon startup of the server:
Here are the contents of the .script file, located in the index folder:
Edit: I went out on a limb and deleted line 93 from the .scripts file, located in the "index" folder. This seemed to allow me to run the world again, but I won't be using the world file since everyone has already moved on and I don't know how this change might affect the server down the road. This is the contents of that line which was deleted:
"SET TABLE PUBLIC.FLEET_MEMBERS INDEX '1072215 1072167 1072179 1072167 1072179 1072167 1072173 0 0 0 0 0 0 0 23'"
The server was updated at 3am EST 06-20-16
The server underwent a restart at 5pm successfully.
At around 9:30pm the server suddenly started crashing. I use a loop to restart the server when it crashes, and this pushed out the original log file since the server was caught in a restart loop.
We had to load up the backup from 3am before the update to fix the issue, losing all progress for the day.
The server is running on a 6-core xeon processor, with 24gb of RAM assigned to the server, running Ubuntu Server 16.
Here's the log from when the crash happens upon startup of the server:
[2016-06-21 18:49:46] [VERION] loading version from install dir: ./
[2016-06-21 18:49:46] [VERSION] VERSION: 0.198.221
[2016-06-21 18:49:46] [VERSION] BUILD: 20160620_165928
[2016-06-21 18:49:46] #################### StarMade #######################
[2016-06-21 18:49:46] # version 0.198.221 - build 20160620_165928 #
[2016-06-21 18:49:46] #####################################################
[2016-06-21 18:49:46] [SERIAL] "not retrieved"
[2016-06-21 18:49:46] [STARTER] template dir exists. overwriting template with current data
[2016-06-21 18:49:46] [IO][COPY] FILE FROM /home/starmade/starmade-testing/StarMade/./data/config/FactionConfig.xml to /home/starmade/starmade-testing/StarMade/./customFactionConfig/FactionConfigTemplate.xml
[2016-06-21 18:49:46] [IO][COPY] FILE FROM /home/starmade/starmade-testing/StarMade/./data/config/customFactionConfigHOWTO.txt to /home/starmade/starmade-testing/StarMade/./customFactionConfig/customFactionConfigHOWTO.txt
[2016-06-21 18:49:46] [IO][COPY] FILE FROM /home/starmade/starmade-testing/StarMade/./customFactionConfig/FactionConfig.xml to /home/starmade/starmade-testing/StarMade/./data/config/FactionConfig.xml
[2016-06-21 18:49:46] [STARTER] custom config file has been copied to config location/home/starmade/starmade-testing/StarMade/./data/config/FactionConfig.xml
[2016-06-21 18:49:46] [STARTER] template dir exists. overwriting template with current data
[2016-06-21 18:49:46] [IO][COPY] FILE FROM /home/starmade/starmade-testing/StarMade/./data/config/customBlockBehaviorConfigTemplate.xml to /home/starmade/starmade-testing/StarMade/./customBlockBehaviorConfig/customBlockBehaviorConfigTemplate.xml
[2016-06-21 18:49:46] [IO][COPY] FILE FROM /home/starmade/starmade-testing/StarMade/./data/config/customBlockBehaviorConfigHOWTO.txt to /home/starmade/starmade-testing/StarMade/./customBlockBehaviorConfig/customBlockBehaviorConfigHOWTO.txt
[2016-06-21 18:49:46] [IO][COPY] FILE FROM /home/starmade/starmade-testing/StarMade/./customBlockBehaviorConfig/customBlockBehaviorConfig.xml to /home/starmade/starmade-testing/StarMade/./data/config/customBlockBehaviorConfigTemplate.xml
[2016-06-21 18:49:46] [STARTER] custom config file has been copied to config location/home/starmade/starmade-testing/StarMade/./data/config/customBlockBehaviorConfigTemplate.xml
[2016-06-21 18:49:46] [RESOURCES][CustomTextures] No need to create pack.zip. Hash matches (as rewriting a zip changes the hash on it)
[2016-06-21 18:49:46] [TEXTURE-PACK] WARNING: ignoring shield_tex.png.zip: not a directory
[2016-06-21 18:49:46] [TEXTURE-PACK] WARNING: ignoring lava.png.zip: not a directory
[2016-06-21 18:49:46] [TEXTURE-PACK] WARNING: ignoring shield_tex.png.zip: not a directory
[2016-06-21 18:49:46] [TEXTURE-PACK] WARNING: ignoring lava.png.zip: not a directory
[2016-06-21 18:49:46] [LANGUAGE] detected language: en
[2016-06-21 18:49:46] [LANGUAGE] loading language: english; Resolved to english
[2016-06-21 18:49:46] java.io.FileNotFoundException: ./keyboard.cfg (No such file or directory)
[2016-06-21 18:49:46] at java.io.FileInputStream.open0(Native Method)
[2016-06-21 18:49:46] at java.io.FileInputStream.open(FileInputStream.java:195)
[2016-06-21 18:49:46] at java.io.FileInputStream.<init>(FileInputStream.java:138)
[2016-06-21 18:49:46] at java.io.FileReader.<init>(FileReader.java:72)
[2016-06-21 18:49:46] at org.schema.schine.input.KeyboardMappings.a(SourceFile:177)
[2016-06-21 18:49:46] at obfuscated.QF.b(SourceFile:94)
[2016-06-21 18:49:46] at obfuscated.QF.a(SourceFile:218)
[2016-06-21 18:49:46] at org.schema.game.common.Starter.main(SourceFile:812)
[2016-06-21 18:49:46] Could not read settings file: using defaults (./keyboard.cfg (No such file or directory))
[2016-06-21 18:49:46] [LANGUAGE] Loading English; Version: 0
[2016-06-21 18:49:47] [LANGUAGE] LOADED FONT PATH/NAME: font/Monda-Regular.ttf
[2016-06-21 18:49:47] [SERVER] using world: world1; ./server-database/world1/
[2016-06-21 18:49:47] [INIT] Segment Database Path: /home/starmade/starmade-testing/StarMade/./server-database/world1/DATA; exists? true; is Dir? true; creating dir sucessfull (gives false if exists)? false
[2016-06-21 18:49:47] [GUI] NO STARMADE-WINDOW CONFIG FOUND. Using defaults
[2016-06-21 18:49:47] [LIBLOADER] OS ARCHITECTURE amd64
[2016-06-21 18:49:47] [LIBLOADER] LOADED LINUX 64bit NATIVE LIBRARIES
[2016-06-21 18:49:47] [LIBLOADER] LOADED NATIVE LIBRARIES
[2016-06-21 18:49:47] [LIBLOADER] FastNoiseSIMD Seed: 101
[2016-06-21 18:49:47] [LIBLOADER] FastNoiseSIMD Level: 2
[2016-06-21 18:49:47] [MAIN] CHECKING IF MIGRATION NECESSARY
[2016-06-21 18:49:47] [MAIN] MIGRATION PROCESS DONE
[2016-06-21 18:49:47] [MAIN] STARTING WITH ARGUMENTS: [-server, -port:5252]
[2016-06-21 18:49:47] [MAIN] LOADED ENGINE SETTINGS
[2016-06-21 18:49:47] [INITIALIZE] REMOTE CLASSES REGISTERED
[2016-06-21 18:49:47] [INITIALIZE] RESOURCE MANAGER INITIALIZED
[2016-06-21 18:49:47] ERROR: no content in Resource: /home/starmade/starmade-testing/StarMade/file:/home/starmade/starmade-testing/StarMade/StarMade.jar!/org/schema/game/network/commands
[2016-06-21 18:49:47] ################# Loading from JAR #####################
[2016-06-21 18:49:47] ########################################################
[2016-06-21 18:49:47] [INITIALIZE] REMOTE COMMANDS REGISTERED
[2016-06-21 18:49:47] [INITIALIZE] SECURITY MANAGER SET
[2016-06-21 18:49:47] [INITIALIZE] COMMAND ID's ASSIGNED. NOW READING BLOCK CONFIG
[2016-06-21 18:49:47] [INITIALIZE] BLOCK CONFIGURATION READ
[2016-06-21 18:49:48] [BLUEPRINT][MIGRATION] NO CONVERSION NEEDED: no old bb file exists: /home/starmade/starmade-testing/StarMade/./blueprints/catalog.txt
[2016-06-21 18:49:48] [MAIN] INITIALIZATION COMPLETED
[2016-06-21 18:49:48] [SERVER] initializing
[2016-06-21 18:49:48] java.lang.Exception: Server Shutdown: false
[2016-06-21 18:49:48] at org.schema.schine.network.server.ServerState.setShutdown(SourceFile:253)
[2016-06-21 18:49:48] at obfuscated.QS.run(SourceFile:1178)
[2016-06-21 18:49:48] at java.lang.Thread.run(Thread.java:745)
[2016-06-21 18:49:48] java.lang.Exception: Server created: true
[2016-06-21 18:49:48] at org.schema.schine.network.server.ServerState.setCreated(SourceFile:261)
[2016-06-21 18:49:48] at org.schema.schine.network.server.ServerState.<init>(SourceFile:47)
[2016-06-21 18:49:48] at obfuscated.aoP.<init>(SourceFile:302)
[2016-06-21 18:49:48] at obfuscated.QS.run(SourceFile:1182)
[2016-06-21 18:49:48] at java.lang.Thread.run(Thread.java:745)
[2016-06-21 18:49:48] [SERVER] Server State Created!
[2016-06-21 18:49:48] [INIT] Seed File: /home/starmade/starmade-testing/StarMade/./server-database/world1/.seed
[2016-06-21 18:49:48] [SQL] Fetching connection (may take some if game crashed on the run before)
[2016-06-21 18:49:48] java.sql.SQLException: error in script file line: /home/starmade/starmade-testing/StarMade/server-database/world1/index 93
[2016-06-21 18:49:48] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
[2016-06-21 18:49:48] at java.sql.DriverManager.getConnection(DriverManager.java:664)
[2016-06-21 18:49:48] at java.sql.DriverManager.getConnection(DriverManager.java:247)
[2016-06-21 18:49:48] at org.schema.game.common.controller.database.DatabaseIndex.<init>(SourceFile:166)
[2016-06-21 18:49:48] at obfuscated.aoP.<init>(SourceFile:360)
[2016-06-21 18:49:48] at obfuscated.QS.run(SourceFile:1182)
[2016-06-21 18:49:48] at java.lang.Thread.run(Thread.java:745)
[2016-06-21 18:49:48] Caused by: org.hsqldb.HsqlException: error in script file line: /home/starmade/starmade-testing/StarMade/server-database/world1/index 93
[2016-06-21 18:49:48] at org.hsqldb.error.Error.error(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.scriptio.ScriptReaderText.readDDL(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.persist.Log.processScript(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.persist.Log.open(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.persist.Logger.open(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.Database.reopen(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.Database.open(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.DatabaseManager.newSession(Unknown Source)
[2016-06-21 18:49:48] ... 9 more
[2016-06-21 18:49:48] Caused by: org.hsqldb.HsqlException: org.hsqldb.HsqlException: java.io.UTFDataFormatException
[2016-06-21 18:49:48] at org.hsqldb.error.Error.error(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.persist.DataFileCache.getFromFile(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.persist.DataFileCache.get(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.persist.RowStoreAVLDisk.get(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.persist.RowStoreAVLDisk.setAccessor(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.Table.setIndexRoots(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.Table.setIndexRoots(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.StatementCommand.getResult(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.StatementCommand.execute(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
[2016-06-21 18:49:48] ... 18 more
[2016-06-21 18:49:48] Caused by: org.hsqldb.HsqlException: java.io.UTFDataFormatException
[2016-06-21 18:49:48] at org.hsqldb.error.Error.error(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.persist.RowStoreAVLDisk.get(Unknown Source)
[2016-06-21 18:49:48] ... 27 more
[2016-06-21 18:49:48] Caused by: java.io.UTFDataFormatException
[2016-06-21 18:49:48] at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.rowio.RowInputBinary.readString(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.rowio.RowInputBinary.readChar(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.rowio.RowInputBinaryDecode.readData(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.RowAVLDisk.<init>(Unknown Source)
[2016-06-21 18:49:48] ... 28 more
[2016-06-21 18:49:46] [VERSION] VERSION: 0.198.221
[2016-06-21 18:49:46] [VERSION] BUILD: 20160620_165928
[2016-06-21 18:49:46] #################### StarMade #######################
[2016-06-21 18:49:46] # version 0.198.221 - build 20160620_165928 #
[2016-06-21 18:49:46] #####################################################
[2016-06-21 18:49:46] [SERIAL] "not retrieved"
[2016-06-21 18:49:46] [STARTER] template dir exists. overwriting template with current data
[2016-06-21 18:49:46] [IO][COPY] FILE FROM /home/starmade/starmade-testing/StarMade/./data/config/FactionConfig.xml to /home/starmade/starmade-testing/StarMade/./customFactionConfig/FactionConfigTemplate.xml
[2016-06-21 18:49:46] [IO][COPY] FILE FROM /home/starmade/starmade-testing/StarMade/./data/config/customFactionConfigHOWTO.txt to /home/starmade/starmade-testing/StarMade/./customFactionConfig/customFactionConfigHOWTO.txt
[2016-06-21 18:49:46] [IO][COPY] FILE FROM /home/starmade/starmade-testing/StarMade/./customFactionConfig/FactionConfig.xml to /home/starmade/starmade-testing/StarMade/./data/config/FactionConfig.xml
[2016-06-21 18:49:46] [STARTER] custom config file has been copied to config location/home/starmade/starmade-testing/StarMade/./data/config/FactionConfig.xml
[2016-06-21 18:49:46] [STARTER] template dir exists. overwriting template with current data
[2016-06-21 18:49:46] [IO][COPY] FILE FROM /home/starmade/starmade-testing/StarMade/./data/config/customBlockBehaviorConfigTemplate.xml to /home/starmade/starmade-testing/StarMade/./customBlockBehaviorConfig/customBlockBehaviorConfigTemplate.xml
[2016-06-21 18:49:46] [IO][COPY] FILE FROM /home/starmade/starmade-testing/StarMade/./data/config/customBlockBehaviorConfigHOWTO.txt to /home/starmade/starmade-testing/StarMade/./customBlockBehaviorConfig/customBlockBehaviorConfigHOWTO.txt
[2016-06-21 18:49:46] [IO][COPY] FILE FROM /home/starmade/starmade-testing/StarMade/./customBlockBehaviorConfig/customBlockBehaviorConfig.xml to /home/starmade/starmade-testing/StarMade/./data/config/customBlockBehaviorConfigTemplate.xml
[2016-06-21 18:49:46] [STARTER] custom config file has been copied to config location/home/starmade/starmade-testing/StarMade/./data/config/customBlockBehaviorConfigTemplate.xml
[2016-06-21 18:49:46] [RESOURCES][CustomTextures] No need to create pack.zip. Hash matches (as rewriting a zip changes the hash on it)
[2016-06-21 18:49:46] [TEXTURE-PACK] WARNING: ignoring shield_tex.png.zip: not a directory
[2016-06-21 18:49:46] [TEXTURE-PACK] WARNING: ignoring lava.png.zip: not a directory
[2016-06-21 18:49:46] [TEXTURE-PACK] WARNING: ignoring shield_tex.png.zip: not a directory
[2016-06-21 18:49:46] [TEXTURE-PACK] WARNING: ignoring lava.png.zip: not a directory
[2016-06-21 18:49:46] [LANGUAGE] detected language: en
[2016-06-21 18:49:46] [LANGUAGE] loading language: english; Resolved to english
[2016-06-21 18:49:46] java.io.FileNotFoundException: ./keyboard.cfg (No such file or directory)
[2016-06-21 18:49:46] at java.io.FileInputStream.open0(Native Method)
[2016-06-21 18:49:46] at java.io.FileInputStream.open(FileInputStream.java:195)
[2016-06-21 18:49:46] at java.io.FileInputStream.<init>(FileInputStream.java:138)
[2016-06-21 18:49:46] at java.io.FileReader.<init>(FileReader.java:72)
[2016-06-21 18:49:46] at org.schema.schine.input.KeyboardMappings.a(SourceFile:177)
[2016-06-21 18:49:46] at obfuscated.QF.b(SourceFile:94)
[2016-06-21 18:49:46] at obfuscated.QF.a(SourceFile:218)
[2016-06-21 18:49:46] at org.schema.game.common.Starter.main(SourceFile:812)
[2016-06-21 18:49:46] Could not read settings file: using defaults (./keyboard.cfg (No such file or directory))
[2016-06-21 18:49:46] [LANGUAGE] Loading English; Version: 0
[2016-06-21 18:49:47] [LANGUAGE] LOADED FONT PATH/NAME: font/Monda-Regular.ttf
[2016-06-21 18:49:47] [SERVER] using world: world1; ./server-database/world1/
[2016-06-21 18:49:47] [INIT] Segment Database Path: /home/starmade/starmade-testing/StarMade/./server-database/world1/DATA; exists? true; is Dir? true; creating dir sucessfull (gives false if exists)? false
[2016-06-21 18:49:47] [GUI] NO STARMADE-WINDOW CONFIG FOUND. Using defaults
[2016-06-21 18:49:47] [LIBLOADER] OS ARCHITECTURE amd64
[2016-06-21 18:49:47] [LIBLOADER] LOADED LINUX 64bit NATIVE LIBRARIES
[2016-06-21 18:49:47] [LIBLOADER] LOADED NATIVE LIBRARIES
[2016-06-21 18:49:47] [LIBLOADER] FastNoiseSIMD Seed: 101
[2016-06-21 18:49:47] [LIBLOADER] FastNoiseSIMD Level: 2
[2016-06-21 18:49:47] [MAIN] CHECKING IF MIGRATION NECESSARY
[2016-06-21 18:49:47] [MAIN] MIGRATION PROCESS DONE
[2016-06-21 18:49:47] [MAIN] STARTING WITH ARGUMENTS: [-server, -port:5252]
[2016-06-21 18:49:47] [MAIN] LOADED ENGINE SETTINGS
[2016-06-21 18:49:47] [INITIALIZE] REMOTE CLASSES REGISTERED
[2016-06-21 18:49:47] [INITIALIZE] RESOURCE MANAGER INITIALIZED
[2016-06-21 18:49:47] ERROR: no content in Resource: /home/starmade/starmade-testing/StarMade/file:/home/starmade/starmade-testing/StarMade/StarMade.jar!/org/schema/game/network/commands
[2016-06-21 18:49:47] ################# Loading from JAR #####################
[2016-06-21 18:49:47] ########################################################
[2016-06-21 18:49:47] [INITIALIZE] REMOTE COMMANDS REGISTERED
[2016-06-21 18:49:47] [INITIALIZE] SECURITY MANAGER SET
[2016-06-21 18:49:47] [INITIALIZE] COMMAND ID's ASSIGNED. NOW READING BLOCK CONFIG
[2016-06-21 18:49:47] [INITIALIZE] BLOCK CONFIGURATION READ
[2016-06-21 18:49:48] [BLUEPRINT][MIGRATION] NO CONVERSION NEEDED: no old bb file exists: /home/starmade/starmade-testing/StarMade/./blueprints/catalog.txt
[2016-06-21 18:49:48] [MAIN] INITIALIZATION COMPLETED
[2016-06-21 18:49:48] [SERVER] initializing
[2016-06-21 18:49:48] java.lang.Exception: Server Shutdown: false
[2016-06-21 18:49:48] at org.schema.schine.network.server.ServerState.setShutdown(SourceFile:253)
[2016-06-21 18:49:48] at obfuscated.QS.run(SourceFile:1178)
[2016-06-21 18:49:48] at java.lang.Thread.run(Thread.java:745)
[2016-06-21 18:49:48] java.lang.Exception: Server created: true
[2016-06-21 18:49:48] at org.schema.schine.network.server.ServerState.setCreated(SourceFile:261)
[2016-06-21 18:49:48] at org.schema.schine.network.server.ServerState.<init>(SourceFile:47)
[2016-06-21 18:49:48] at obfuscated.aoP.<init>(SourceFile:302)
[2016-06-21 18:49:48] at obfuscated.QS.run(SourceFile:1182)
[2016-06-21 18:49:48] at java.lang.Thread.run(Thread.java:745)
[2016-06-21 18:49:48] [SERVER] Server State Created!
[2016-06-21 18:49:48] [INIT] Seed File: /home/starmade/starmade-testing/StarMade/./server-database/world1/.seed
[2016-06-21 18:49:48] [SQL] Fetching connection (may take some if game crashed on the run before)
[2016-06-21 18:49:48] java.sql.SQLException: error in script file line: /home/starmade/starmade-testing/StarMade/server-database/world1/index 93
[2016-06-21 18:49:48] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
[2016-06-21 18:49:48] at java.sql.DriverManager.getConnection(DriverManager.java:664)
[2016-06-21 18:49:48] at java.sql.DriverManager.getConnection(DriverManager.java:247)
[2016-06-21 18:49:48] at org.schema.game.common.controller.database.DatabaseIndex.<init>(SourceFile:166)
[2016-06-21 18:49:48] at obfuscated.aoP.<init>(SourceFile:360)
[2016-06-21 18:49:48] at obfuscated.QS.run(SourceFile:1182)
[2016-06-21 18:49:48] at java.lang.Thread.run(Thread.java:745)
[2016-06-21 18:49:48] Caused by: org.hsqldb.HsqlException: error in script file line: /home/starmade/starmade-testing/StarMade/server-database/world1/index 93
[2016-06-21 18:49:48] at org.hsqldb.error.Error.error(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.scriptio.ScriptReaderText.readDDL(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.persist.Log.processScript(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.persist.Log.open(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.persist.Logger.open(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.Database.reopen(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.Database.open(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.DatabaseManager.newSession(Unknown Source)
[2016-06-21 18:49:48] ... 9 more
[2016-06-21 18:49:48] Caused by: org.hsqldb.HsqlException: org.hsqldb.HsqlException: java.io.UTFDataFormatException
[2016-06-21 18:49:48] at org.hsqldb.error.Error.error(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.persist.DataFileCache.getFromFile(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.persist.DataFileCache.get(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.persist.RowStoreAVLDisk.get(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.persist.RowStoreAVLDisk.setAccessor(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.Table.setIndexRoots(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.Table.setIndexRoots(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.StatementCommand.getResult(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.StatementCommand.execute(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
[2016-06-21 18:49:48] ... 18 more
[2016-06-21 18:49:48] Caused by: org.hsqldb.HsqlException: java.io.UTFDataFormatException
[2016-06-21 18:49:48] at org.hsqldb.error.Error.error(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.persist.RowStoreAVLDisk.get(Unknown Source)
[2016-06-21 18:49:48] ... 27 more
[2016-06-21 18:49:48] Caused by: java.io.UTFDataFormatException
[2016-06-21 18:49:48] at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.rowio.RowInputBinary.readString(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.rowio.RowInputBinary.readChar(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.rowio.RowInputBinaryDecode.readData(Unknown Source)
[2016-06-21 18:49:48] at org.hsqldb.RowAVLDisk.<init>(Unknown Source)
[2016-06-21 18:49:48] ... 28 more
Here are the contents of the .script file, located in the index folder:
SET DATABASE UNIQUE NAME HSQLDB553C6DB41B
SET DATABASE GC 0
SET DATABASE DEFAULT RESULT MEMORY ROWS 0
SET DATABASE EVENT LOG LEVEL 0
SET DATABASE SQL NAMES FALSE
SET DATABASE SQL REFERENCES FALSE
SET DATABASE SQL SIZE TRUE
SET DATABASE SQL TYPES FALSE
SET DATABASE SQL TDC DELETE TRUE
SET DATABASE SQL TDC UPDATE TRUE
SET DATABASE SQL TRANSLATE TTI TYPES TRUE
SET DATABASE SQL CONCAT NULLS TRUE
SET DATABASE SQL UNIQUE NULLS TRUE
SET DATABASE SQL CONVERT TRUNCATE TRUE
SET DATABASE SQL AVG SCALE 0
SET DATABASE SQL DOUBLE NAN TRUE
SET DATABASE TRANSACTION CONTROL MVCC
SET DATABASE DEFAULT ISOLATION LEVEL READ COMMITTED
SET DATABASE TRANSACTION ROLLBACK ON CONFLICT TRUE
SET DATABASE TEXT TABLE DEFAULTS ''
SET FILES WRITE DELAY 500 MILLIS
SET FILES BACKUP INCREMENT TRUE
SET FILES CACHE SIZE 10000
SET FILES CACHE ROWS 50000
SET FILES SCALE 32
SET FILES LOB SCALE 32
SET FILES DEFRAG 0
SET FILES NIO TRUE
SET FILES NIO SIZE 256
SET FILES LOG TRUE
SET FILES LOG SIZE 50
CREATE USER SA PASSWORD DIGEST 'd41d8cd98f00b204e9800998ecf8427e'
ALTER USER SA SET LOCAL TRUE
CREATE SCHEMA PUBLIC AUTHORIZATION DBA
SET SCHEMA PUBLIC
CREATE CACHED TABLE PUBLIC.SYSTEMS(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,X INTEGER NOT NULL,Y INTEGER NOT NULL,Z INTEGER NOT NULL,TYPE INTEGER NOT NULL,STARTTIME BIGINT NOT NULL,NAME VARCHAR(64) NOT NULL,INFOS VARBINARY(8192) NOT NULL,OWNER_UID VARCHAR(128),OWNER_FACTION INTEGER DEFAULT 0 NOT NULL,OWNER_X INTEGER DEFAULT 0 NOT NULL,OWNER_Y INTEGER DEFAULT 0 NOT NULL,OWNER_Z INTEGER DEFAULT 0 NOT NULL)
ALTER TABLE PUBLIC.SYSTEMS ALTER COLUMN ID RESTART WITH 2367
CREATE UNIQUE INDEX SYSCOORDINDEX ON PUBLIC.SYSTEMS(X,Y,Z)
CREATE INDEX SYSOWNFACINDEX ON PUBLIC.SYSTEMS(OWNER_FACTION)
CREATE INDEX SYSOWNUIDINDEX ON PUBLIC.SYSTEMS(OWNER_UID)
CREATE CACHED TABLE PUBLIC.SECTORS(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,X INTEGER NOT NULL,Y INTEGER NOT NULL,Z INTEGER NOT NULL,TYPE INTEGER NOT NULL,NAME VARCHAR(64) NOT NULL,ITEMS BIGINT NOT NULL,PROTECTION INTEGER NOT NULL,STELLAR INTEGER NOT NULL,TRANSIENT BOOLEAN DEFAULT TRUE NOT NULL,LAST_REPLENISHED BIGINT DEFAULT 0 NOT NULL)
ALTER TABLE PUBLIC.SECTORS ALTER COLUMN ID RESTART WITH 66035
CREATE INDEX SECTYPEINDEX ON PUBLIC.SECTORS(TYPE)
CREATE INDEX SECSTELLARINDEX ON PUBLIC.SECTORS(STELLAR)
CREATE UNIQUE INDEX SECCOORDINDEX ON PUBLIC.SECTORS(X,Y,Z)
CREATE CACHED TABLE PUBLIC.SECTORS_ITEMS(ID BIGINT PRIMARY KEY,ITEMS VARBINARY(22528) NOT NULL)
CREATE CACHED TABLE PUBLIC.ENTITIES(UID VARCHAR(128) NOT NULL,X INTEGER NOT NULL,Y INTEGER NOT NULL,Z INTEGER NOT NULL,TYPE TINYINT NOT NULL,NAME CHARACTER(64),FACTION INTEGER DEFAULT 0,CREATOR VARCHAR(64),LAST_MOD VARCHAR(64),SEED BIGINT,TOUCHED BOOLEAN,LOCAL_POS DOUBLE ARRAY[3],DIM INTEGER ARRAY[6],GEN_ID INTEGER,DOCKED_TO BIGINT DEFAULT -1,DOCKED_ROOT BIGINT DEFAULT -1,ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY)
ALTER TABLE PUBLIC.ENTITIES ALTER COLUMN ID RESTART WITH 35042
CREATE INDEX ENTITIES_PK ON PUBLIC.ENTITIES(UID)
CREATE UNIQUE INDEX UIDTYPE ON PUBLIC.ENTITIES(UID,TYPE)
CREATE INDEX COORDINDEX ON PUBLIC.ENTITIES(X,Y,Z)
CREATE INDEX TYPEINDEX ON PUBLIC.ENTITIES(TYPE)
CREATE INDEX DOCKEDTOINDEX ON PUBLIC.ENTITIES(DOCKED_TO)
CREATE INDEX DOCKEDROOTINDEX ON PUBLIC.ENTITIES(DOCKED_ROOT)
CREATE CACHED TABLE PUBLIC.PLAYER_MESSAGES(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,SENDER VARCHAR(64) NOT NULL,RECEIVER VARCHAR(64) NOT NULL,TOPIC VARCHAR(128) NOT NULL,MESSAGE VARCHAR(1024) NOT NULL,SENT BIGINT NOT NULL,READ BOOLEAN DEFAULT FALSE,ATT_ID BIGINT)
ALTER TABLE PUBLIC.PLAYER_MESSAGES ALTER COLUMN ID RESTART WITH 45
CREATE INDEX I0 ON PUBLIC.PLAYER_MESSAGES(SENDER)
CREATE INDEX I1 ON PUBLIC.PLAYER_MESSAGES(RECEIVER)
CREATE INDEX I2 ON PUBLIC.PLAYER_MESSAGES(SENT)
CREATE INDEX I3 ON PUBLIC.PLAYER_MESSAGES(READ)
CREATE INDEX I4 ON PUBLIC.PLAYER_MESSAGES(SENDER,RECEIVER)
CREATE INDEX I5 ON PUBLIC.PLAYER_MESSAGES(SENDER,RECEIVER,SENT)
CREATE CACHED TABLE PUBLIC.FTL(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,FROM_X INTEGER NOT NULL,FROM_Y INTEGER NOT NULL,FROM_Z INTEGER NOT NULL,FROM_X_LOC INTEGER NOT NULL,FROM_Y_LOC INTEGER NOT NULL,FROM_Z_LOC INTEGER NOT NULL,FROM_UID VARCHAR(128) NOT NULL,TO_X INTEGER NOT NULL,TO_Y INTEGER NOT NULL,TO_Z INTEGER NOT NULL,TO_X_LOC INTEGER DEFAULT 0 NOT NULL,TO_Y_LOC INTEGER DEFAULT 0 NOT NULL,TO_Z_LOC INTEGER DEFAULT 0 NOT NULL,TO_UID VARCHAR(128) NOT NULL,TYPE INTEGER NOT NULL,PERMISSION INTEGER NOT NULL)
ALTER TABLE PUBLIC.FTL ALTER COLUMN ID RESTART WITH 37
CREATE UNIQUE INDEX FROMFTLINDLOC ON PUBLIC.FTL(FROM_UID,FROM_X_LOC,FROM_Y_LOC,FROM_Z_LOC)
CREATE INDEX FROMFTLIND ON PUBLIC.FTL(FROM_X,FROM_Y,FROM_Z)
CREATE INDEX FROMUIDFTLIND ON PUBLIC.FTL(FROM_UID,FROM_X,FROM_Y,FROM_Z)
CREATE INDEX TOFTLIND ON PUBLIC.FTL(TO_X,TO_Y,TO_Z)
CREATE INDEX FROMFTLUID ON PUBLIC.FTL(FROM_UID)
CREATE INDEX TOFTLUID ON PUBLIC.FTL(TO_UID)
CREATE INDEX TYPEFTL ON PUBLIC.FTL(TYPE)
CREATE INDEX PERMISSIONFTL ON PUBLIC.FTL(PERMISSION)
CREATE CACHED TABLE PUBLIC.FLEETS(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,FLAGSHIP_ID BIGINT NOT NULL,PARENT_FLEET BIGINT DEFAULT -1,NAME VARCHAR(128),OWNER VARCHAR(128),MISSION_STRING VARCHAR(1024))
ALTER TABLE PUBLIC.FLEETS ALTER COLUMN ID RESTART WITH 26
CREATE INDEX FIN ON PUBLIC.FLEETS(FLAGSHIP_ID)
CREATE INDEX OIN ON PUBLIC.FLEETS(OWNER)
CREATE INDEX FINP ON PUBLIC.FLEETS(PARENT_FLEET)
CREATE CACHED TABLE PUBLIC.FLEET_MEMBERS(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,FLEET_ID BIGINT NOT NULL,ENTITY_ID BIGINT NOT NULL,MISSION_STRING VARCHAR(1024),LIST_INDEX INTEGER NOT NULL,DOCKED_TO BIGINT NOT NULL,FACTION INTEGER DEFAULT 0,CONSTRAINT FFKC FOREIGN KEY(FLEET_ID) REFERENCES PUBLIC.FLEETS(ID),CONSTRAINT EFKC FOREIGN KEY(ENTITY_ID) REFERENCES PUBLIC.ENTITIES(ID))
ALTER TABLE PUBLIC.FLEET_MEMBERS ALTER COLUMN ID RESTART WITH 239
CREATE INDEX FFID ON PUBLIC.FLEET_MEMBERS(FLEET_ID)
CREATE UNIQUE INDEX EID ON PUBLIC.FLEET_MEMBERS(ENTITY_ID)
CREATE UNIQUE INDEX FFEID ON PUBLIC.FLEET_MEMBERS(FLEET_ID,ENTITY_ID)
CREATE INDEX DDEA ON PUBLIC.FLEET_MEMBERS(FACTION)
ALTER SEQUENCE SYSTEM_LOBS.LOB_ID RESTART WITH 1
SET DATABASE DEFAULT INITIAL SCHEMA PUBLIC
SET TABLE PUBLIC.SYSTEMS INDEX '267020 1 402221 404570 0 0 0 0 2366'
SET TABLE PUBLIC.SECTORS INDEX '781120 732765 626880 617570 0 0 0 0 66034'
SET TABLE PUBLIC.SECTORS_ITEMS INDEX '943872 0 113'
SET TABLE PUBLIC.ENTITIES INDEX '996133 946685 946685 944890 950024 944902 1009497 0 0 0 0 0 0 0 10258'
SET TABLE PUBLIC.PLAYER_MESSAGES INDEX '1071615 1071606 1071517 1071579 1071490 1071588 1071588 0 0 0 0 0 0 0 28'
SET TABLE PUBLIC.FTL INDEX '1071863 1071809 1071737 1071809 1071773 1071809 1071782 1071863 1071863 0 0 0 0 0 0 0 0 0 36'
SET TABLE PUBLIC.FLEETS INDEX '1072087 1072077 1072057 1072087 0 0 0 0 15'
SET TABLE PUBLIC.FLEET_MEMBERS INDEX '1072215 1072167 1072179 1072167 1072179 1072167 1072173 0 0 0 0 0 0 0 23'
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.SQL_IDENTIFIER TO PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.YES_OR_NO TO PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.TIME_STAMP TO PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CARDINAL_NUMBER TO PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CHARACTER_DATA TO PUBLIC
GRANT DBA TO SA
SET SCHEMA SYSTEM_LOBS
INSERT INTO BLOCKS VALUES(0,2147483647,0)
SET DATABASE GC 0
SET DATABASE DEFAULT RESULT MEMORY ROWS 0
SET DATABASE EVENT LOG LEVEL 0
SET DATABASE SQL NAMES FALSE
SET DATABASE SQL REFERENCES FALSE
SET DATABASE SQL SIZE TRUE
SET DATABASE SQL TYPES FALSE
SET DATABASE SQL TDC DELETE TRUE
SET DATABASE SQL TDC UPDATE TRUE
SET DATABASE SQL TRANSLATE TTI TYPES TRUE
SET DATABASE SQL CONCAT NULLS TRUE
SET DATABASE SQL UNIQUE NULLS TRUE
SET DATABASE SQL CONVERT TRUNCATE TRUE
SET DATABASE SQL AVG SCALE 0
SET DATABASE SQL DOUBLE NAN TRUE
SET DATABASE TRANSACTION CONTROL MVCC
SET DATABASE DEFAULT ISOLATION LEVEL READ COMMITTED
SET DATABASE TRANSACTION ROLLBACK ON CONFLICT TRUE
SET DATABASE TEXT TABLE DEFAULTS ''
SET FILES WRITE DELAY 500 MILLIS
SET FILES BACKUP INCREMENT TRUE
SET FILES CACHE SIZE 10000
SET FILES CACHE ROWS 50000
SET FILES SCALE 32
SET FILES LOB SCALE 32
SET FILES DEFRAG 0
SET FILES NIO TRUE
SET FILES NIO SIZE 256
SET FILES LOG TRUE
SET FILES LOG SIZE 50
CREATE USER SA PASSWORD DIGEST 'd41d8cd98f00b204e9800998ecf8427e'
ALTER USER SA SET LOCAL TRUE
CREATE SCHEMA PUBLIC AUTHORIZATION DBA
SET SCHEMA PUBLIC
CREATE CACHED TABLE PUBLIC.SYSTEMS(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,X INTEGER NOT NULL,Y INTEGER NOT NULL,Z INTEGER NOT NULL,TYPE INTEGER NOT NULL,STARTTIME BIGINT NOT NULL,NAME VARCHAR(64) NOT NULL,INFOS VARBINARY(8192) NOT NULL,OWNER_UID VARCHAR(128),OWNER_FACTION INTEGER DEFAULT 0 NOT NULL,OWNER_X INTEGER DEFAULT 0 NOT NULL,OWNER_Y INTEGER DEFAULT 0 NOT NULL,OWNER_Z INTEGER DEFAULT 0 NOT NULL)
ALTER TABLE PUBLIC.SYSTEMS ALTER COLUMN ID RESTART WITH 2367
CREATE UNIQUE INDEX SYSCOORDINDEX ON PUBLIC.SYSTEMS(X,Y,Z)
CREATE INDEX SYSOWNFACINDEX ON PUBLIC.SYSTEMS(OWNER_FACTION)
CREATE INDEX SYSOWNUIDINDEX ON PUBLIC.SYSTEMS(OWNER_UID)
CREATE CACHED TABLE PUBLIC.SECTORS(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,X INTEGER NOT NULL,Y INTEGER NOT NULL,Z INTEGER NOT NULL,TYPE INTEGER NOT NULL,NAME VARCHAR(64) NOT NULL,ITEMS BIGINT NOT NULL,PROTECTION INTEGER NOT NULL,STELLAR INTEGER NOT NULL,TRANSIENT BOOLEAN DEFAULT TRUE NOT NULL,LAST_REPLENISHED BIGINT DEFAULT 0 NOT NULL)
ALTER TABLE PUBLIC.SECTORS ALTER COLUMN ID RESTART WITH 66035
CREATE INDEX SECTYPEINDEX ON PUBLIC.SECTORS(TYPE)
CREATE INDEX SECSTELLARINDEX ON PUBLIC.SECTORS(STELLAR)
CREATE UNIQUE INDEX SECCOORDINDEX ON PUBLIC.SECTORS(X,Y,Z)
CREATE CACHED TABLE PUBLIC.SECTORS_ITEMS(ID BIGINT PRIMARY KEY,ITEMS VARBINARY(22528) NOT NULL)
CREATE CACHED TABLE PUBLIC.ENTITIES(UID VARCHAR(128) NOT NULL,X INTEGER NOT NULL,Y INTEGER NOT NULL,Z INTEGER NOT NULL,TYPE TINYINT NOT NULL,NAME CHARACTER(64),FACTION INTEGER DEFAULT 0,CREATOR VARCHAR(64),LAST_MOD VARCHAR(64),SEED BIGINT,TOUCHED BOOLEAN,LOCAL_POS DOUBLE ARRAY[3],DIM INTEGER ARRAY[6],GEN_ID INTEGER,DOCKED_TO BIGINT DEFAULT -1,DOCKED_ROOT BIGINT DEFAULT -1,ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY)
ALTER TABLE PUBLIC.ENTITIES ALTER COLUMN ID RESTART WITH 35042
CREATE INDEX ENTITIES_PK ON PUBLIC.ENTITIES(UID)
CREATE UNIQUE INDEX UIDTYPE ON PUBLIC.ENTITIES(UID,TYPE)
CREATE INDEX COORDINDEX ON PUBLIC.ENTITIES(X,Y,Z)
CREATE INDEX TYPEINDEX ON PUBLIC.ENTITIES(TYPE)
CREATE INDEX DOCKEDTOINDEX ON PUBLIC.ENTITIES(DOCKED_TO)
CREATE INDEX DOCKEDROOTINDEX ON PUBLIC.ENTITIES(DOCKED_ROOT)
CREATE CACHED TABLE PUBLIC.PLAYER_MESSAGES(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,SENDER VARCHAR(64) NOT NULL,RECEIVER VARCHAR(64) NOT NULL,TOPIC VARCHAR(128) NOT NULL,MESSAGE VARCHAR(1024) NOT NULL,SENT BIGINT NOT NULL,READ BOOLEAN DEFAULT FALSE,ATT_ID BIGINT)
ALTER TABLE PUBLIC.PLAYER_MESSAGES ALTER COLUMN ID RESTART WITH 45
CREATE INDEX I0 ON PUBLIC.PLAYER_MESSAGES(SENDER)
CREATE INDEX I1 ON PUBLIC.PLAYER_MESSAGES(RECEIVER)
CREATE INDEX I2 ON PUBLIC.PLAYER_MESSAGES(SENT)
CREATE INDEX I3 ON PUBLIC.PLAYER_MESSAGES(READ)
CREATE INDEX I4 ON PUBLIC.PLAYER_MESSAGES(SENDER,RECEIVER)
CREATE INDEX I5 ON PUBLIC.PLAYER_MESSAGES(SENDER,RECEIVER,SENT)
CREATE CACHED TABLE PUBLIC.FTL(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,FROM_X INTEGER NOT NULL,FROM_Y INTEGER NOT NULL,FROM_Z INTEGER NOT NULL,FROM_X_LOC INTEGER NOT NULL,FROM_Y_LOC INTEGER NOT NULL,FROM_Z_LOC INTEGER NOT NULL,FROM_UID VARCHAR(128) NOT NULL,TO_X INTEGER NOT NULL,TO_Y INTEGER NOT NULL,TO_Z INTEGER NOT NULL,TO_X_LOC INTEGER DEFAULT 0 NOT NULL,TO_Y_LOC INTEGER DEFAULT 0 NOT NULL,TO_Z_LOC INTEGER DEFAULT 0 NOT NULL,TO_UID VARCHAR(128) NOT NULL,TYPE INTEGER NOT NULL,PERMISSION INTEGER NOT NULL)
ALTER TABLE PUBLIC.FTL ALTER COLUMN ID RESTART WITH 37
CREATE UNIQUE INDEX FROMFTLINDLOC ON PUBLIC.FTL(FROM_UID,FROM_X_LOC,FROM_Y_LOC,FROM_Z_LOC)
CREATE INDEX FROMFTLIND ON PUBLIC.FTL(FROM_X,FROM_Y,FROM_Z)
CREATE INDEX FROMUIDFTLIND ON PUBLIC.FTL(FROM_UID,FROM_X,FROM_Y,FROM_Z)
CREATE INDEX TOFTLIND ON PUBLIC.FTL(TO_X,TO_Y,TO_Z)
CREATE INDEX FROMFTLUID ON PUBLIC.FTL(FROM_UID)
CREATE INDEX TOFTLUID ON PUBLIC.FTL(TO_UID)
CREATE INDEX TYPEFTL ON PUBLIC.FTL(TYPE)
CREATE INDEX PERMISSIONFTL ON PUBLIC.FTL(PERMISSION)
CREATE CACHED TABLE PUBLIC.FLEETS(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,FLAGSHIP_ID BIGINT NOT NULL,PARENT_FLEET BIGINT DEFAULT -1,NAME VARCHAR(128),OWNER VARCHAR(128),MISSION_STRING VARCHAR(1024))
ALTER TABLE PUBLIC.FLEETS ALTER COLUMN ID RESTART WITH 26
CREATE INDEX FIN ON PUBLIC.FLEETS(FLAGSHIP_ID)
CREATE INDEX OIN ON PUBLIC.FLEETS(OWNER)
CREATE INDEX FINP ON PUBLIC.FLEETS(PARENT_FLEET)
CREATE CACHED TABLE PUBLIC.FLEET_MEMBERS(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,FLEET_ID BIGINT NOT NULL,ENTITY_ID BIGINT NOT NULL,MISSION_STRING VARCHAR(1024),LIST_INDEX INTEGER NOT NULL,DOCKED_TO BIGINT NOT NULL,FACTION INTEGER DEFAULT 0,CONSTRAINT FFKC FOREIGN KEY(FLEET_ID) REFERENCES PUBLIC.FLEETS(ID),CONSTRAINT EFKC FOREIGN KEY(ENTITY_ID) REFERENCES PUBLIC.ENTITIES(ID))
ALTER TABLE PUBLIC.FLEET_MEMBERS ALTER COLUMN ID RESTART WITH 239
CREATE INDEX FFID ON PUBLIC.FLEET_MEMBERS(FLEET_ID)
CREATE UNIQUE INDEX EID ON PUBLIC.FLEET_MEMBERS(ENTITY_ID)
CREATE UNIQUE INDEX FFEID ON PUBLIC.FLEET_MEMBERS(FLEET_ID,ENTITY_ID)
CREATE INDEX DDEA ON PUBLIC.FLEET_MEMBERS(FACTION)
ALTER SEQUENCE SYSTEM_LOBS.LOB_ID RESTART WITH 1
SET DATABASE DEFAULT INITIAL SCHEMA PUBLIC
SET TABLE PUBLIC.SYSTEMS INDEX '267020 1 402221 404570 0 0 0 0 2366'
SET TABLE PUBLIC.SECTORS INDEX '781120 732765 626880 617570 0 0 0 0 66034'
SET TABLE PUBLIC.SECTORS_ITEMS INDEX '943872 0 113'
SET TABLE PUBLIC.ENTITIES INDEX '996133 946685 946685 944890 950024 944902 1009497 0 0 0 0 0 0 0 10258'
SET TABLE PUBLIC.PLAYER_MESSAGES INDEX '1071615 1071606 1071517 1071579 1071490 1071588 1071588 0 0 0 0 0 0 0 28'
SET TABLE PUBLIC.FTL INDEX '1071863 1071809 1071737 1071809 1071773 1071809 1071782 1071863 1071863 0 0 0 0 0 0 0 0 0 36'
SET TABLE PUBLIC.FLEETS INDEX '1072087 1072077 1072057 1072087 0 0 0 0 15'
SET TABLE PUBLIC.FLEET_MEMBERS INDEX '1072215 1072167 1072179 1072167 1072179 1072167 1072173 0 0 0 0 0 0 0 23'
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.SQL_IDENTIFIER TO PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.YES_OR_NO TO PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.TIME_STAMP TO PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CARDINAL_NUMBER TO PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CHARACTER_DATA TO PUBLIC
GRANT DBA TO SA
SET SCHEMA SYSTEM_LOBS
INSERT INTO BLOCKS VALUES(0,2147483647,0)
Edit: I went out on a limb and deleted line 93 from the .scripts file, located in the "index" folder. This seemed to allow me to run the world again, but I won't be using the world file since everyone has already moved on and I don't know how this change might affect the server down the road. This is the contents of that line which was deleted:
"SET TABLE PUBLIC.FLEET_MEMBERS INDEX '1072215 1072167 1072179 1072167 1072179 1072167 1072173 0 0 0 0 0 0 0 23'"
Last edited: