Server locks and kicks all players repeatedly

[bbg 0]

I have been trying to set up an Exile Mod server over the weekend, and have run into mixed results. The server was running correctly initially, then after a restart, it is displaying some strange behavior.

The first time I connect, the server will initialize the database and then kick me and lock the server to finish the initialization:

16:21:53 "ExileServer - Server is loading..."
16:21:53 "ExileServer - ServerPassword MATCH! server locked for init"
16:21:53 "ExileServer - Installed extDB2 version: 65"
16:21:53 "ExileServer - Connected to database!"
16:21:53 "ExileServer - Database protocol initialized!"
...
16:22:02 Successfull attempt to execute serverCommand '#lock' by server.
16:22:02 Successfull attempt to execute serverCommand '#lock' by server.
16:22:02 Successfull attempt to execute serverCommand '#kick 0' by server.

After initialization, though, I attempt to reconnect, get kicked again, and the following is output to the log:

16:22:37 "ExileServer - Server is loading..."
16:22:37 "ExileServer - ServerPassword MATCH! server locked for init"
16:22:37 "ExileServer - Installed extDB2 version: 65"
16:22:37 "ExileServer - Connected to database!"
16:22:37 "ExileServer - MySQL connection error!"
16:22:37 "ExileServer - MySQL Error: Failed to initialize database protocol: [0,"Error Invalid Format"]"
16:22:37 "ExileServer - Server will shutdown now :("
...
16:22:37 Successfull attempt to execute serverCommand '#lock' by server.
16:22:37 Successfull attempt to execute serverCommand '#lock' by server.
16:22:37 Successfull attempt to execute serverCommand '#kick 0' by server.

The extDB2 logs of this event are below:

extDB2: Version: 65
extDB2: https://github.com/Torndeco/extDB2
extDB2: Linux Version

extDB2: Found extdb-conf.ini
extDB2: Detected 4 Cores, Setting up 4 Worker Threads


[15:08:33 --4:00] [Thread 23221] extDB2: Database Type: MySQL
[15:08:33 --4:00] [Thread 23221] extDB2: Database Session Pool Started
[15:08:33 --4:00] [Thread 23221] extDB2: SQL_CUSTOM_V2: Loading Template Filename: extDB/sql_custom_v2/exile.ini
[15:08:33 --4:00] [Thread 23221] extDB2: SQL_CUSTOM_V2: Version 8 Detected, Latest Version 12 Available
[15:09:56 --4:00] [Thread 23221] extDB2: Error Invalid Format: 9:ADD_DATABASE_PROTOCOL:exile:SQL_CUSTOM_V2:643737:exile
[15:09:56 --4:00] [Thread 23221] extDB2: Error Invalid Format: 9:SHUTDOWN
[16:11:33 --4:00] [Thread 23221] extDB2: Stopping ...

I am running a Linux dedicated server, if this helps. I am also sorry if this has been solved before, but after the forums were migrated, all of the old posts are inaccessible.

[Shepster 17]

We have this same issue, and we havent made any changes for a day or so now and had many restarts inbetween, dont understand why the issue, we have not applied the new update and the server was running fine, until the scheduled reboot this morning

[Flow 252]

Did you update extDB\sql_custom_v2\exile.ini and are you sure all database settings are okay?

[Shepster 17]

We have made no changes in the last 48 hours, we have not updated to the 0.9.20, server was working fine last night, and i was notified this morning the server is looping at reboot, our hosts state they have not made any changes either, but someone somewherre must have,its  been running sweet

 

 

Edited September 14, 2015 by Shepster

[Flow 252]

... state they have not made any changes either, but someone somewherre must have..

Think so

[Shepster 17]

Could it be a database value ?

"ExileServer - Server is loading..."
13:35:27 "ExileServer - ServerPassword MATCH! server locked for init"
13:35:27 Client: Nonnetwork object 3b58a500.
13:35:27 "ExileServer - Installed extDB2 version: 65"
13:35:27 "ExileServer - Connected to database!"
13:35:27 "ExileServer - MySQL connection error!"
13:35:27 "ExileServer - MySQL Error: Failed to initialize database protocol: [0,"Error Invalid Format"]"
13:35:27 "ExileServer - Server will shutdown now :("

the reply i received from our host support

I dont know the answer, weve not changed anything, i see on the Excile forums a few others with the problem but no fix is mentioned. You could try recompiling the PBO see if that helps.

The bit that i see is :

Output to Server: [0,"Error Invalid Format"]

Which is telling me the SQL is poorly formatted and rejected.


What is trying to do is:

Input from Server: 9:ADD_DATABASE_PROTOCOL:exile:SQL_CUSTOM_V2:278184:exile

But that command is not in the exile.ini, so i dont know i would ask the devs.

[☢klinGiii☢ 10]

Same Problem here ... No Solution found ...  Changed nothing , i really mean NOTHING ... And after a restart, Server gave me the same Shitty Message  

[bbg 0]

Did you update extDB\sql_custom_v2\exile.ini and are you sure all database settings are okay?

Yes, I have tried with both 0.9.19 and 0.9.20 and updated the exile.ini file. 

And as you can see by the first connection, extDB is able to connect to the database fine. It is only after it kicks the user, locks the server, and tries the exact same thing that it fails. 

I also enabled full extDB2 logging, and this is the entire output to the logs:

extDB2: Version: 65
extDB2: https://github.com/Torndeco/extDB2
extDB2: Linux Version
extDB2: Found extdb-conf.ini
extDB2: Detected 4 Cores, Setting up 4 Worker Threads

[23:25:25 --4:00] [Thread 23835] extDB2: Input from Server: 9:VERSION
[23:25:25 --4:00] [Thread 23835] extDB2: Output to Server: 65
[23:25:25 --4:00] [Thread 23835] extDB2: Input from Server: 9:ADD_DATABASE:exile
[23:25:25 --4:00] [Thread 23835] extDB2: Database Type: MySQL
[23:25:25 --4:00] [Thread 23835] extDB2: Database Session Pool Started
[23:25:25 --4:00] [Thread 23835] extDB2: Output to Server: [1]
[23:25:25 --4:00] [Thread 23835] extDB2: Input from Server: 9:ADD_DATABASE_PROTOCOL:exile:SQL_CUSTOM_V2:944137:exile
[23:25:25 --4:00] [Thread 23835] extDB2: SQL_CUSTOM_V2: Loading Template Filename: /home/steam/steamcmd/arma3/@ExileServer/extDB/sql_custom_v2/exile.ini
[23:25:25 --4:00] [Thread 23835] extDB2: SQL_CUSTOM_V2: Version 8 Detected, Latest Version 12 Available
[23:25:25 --4:00] [Thread 23835] extDB2: Output to Server: [1]
[23:25:25 --4:00] [Thread 23835] extDB2: Input from Server: 9:TIME
[23:25:25 --4:00] [Thread 23835] extDB2: Output to Server: [1,[2015, 9, 14, 03, 25]]
[23:25:25 --4:00] [Thread 23835] extDB2: Input from Server: 9:LOCK
[23:25:25 --4:00] [Thread 23835] extDB2: Output to Server: [1]
[23:25:34 --4:00] [Thread 23835] extDB2: Input from Server: 0:944137:loadTerriotryIdPage:0:100
[23:25:34 --4:00] [Thread 23835] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: loadTerriotryIdPage:0:100
[23:25:34 --4:00] [Thread 23835] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[23:25:34 --4:00] [Thread 23835] extDB2: Output to Server: [1,[]]
[23:25:34 --4:00] [Thread 23835] extDB2: Input from Server: 0:944137:loadConstructionIdPage:0:100
[23:25:34 --4:00] [Thread 23835] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: loadConstructionIdPage:0:100
[23:25:34 --4:00] [Thread 23835] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[23:25:34 --4:00] [Thread 23835] extDB2: Output to Server: [1,[]]
[23:25:34 --4:00] [Thread 23835] extDB2: Input from Server: 0:944137:loadVehicleIdPage:0:100
[23:25:34 --4:00] [Thread 23835] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: loadVehicleIdPage:0:100
[23:25:34 --4:00] [Thread 23835] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[23:25:34 --4:00] [Thread 23835] extDB2: Output to Server: [1,[]]
[23:25:34 --4:00] [Thread 23835] extDB2: Input from Server: 0:944137:loadContainerIdPage:0:100
[23:25:34 --4:00] [Thread 23835] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: loadContainerIdPage:0:100
[23:25:34 --4:00] [Thread 23835] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[23:25:34 --4:00] [Thread 23835] extDB2: Output to Server: [1,[]]
[23:25:46 --4:00] [Thread 23835] extDB2: Input from Server: 9:TIME
[23:25:46 --4:00] [Thread 23835] extDB2: Output to Server: [1,[2015, 9, 14, 03, 25]]
[23:27:24 --4:00] [Thread 23835] extDB2: Input from Server: 9:VERSION
[23:27:24 --4:00] [Thread 23835] extDB2: Output to Server: 65
[23:27:24 --4:00] [Thread 23835] extDB2: Input from Server: 9:ADD_DATABASE:exile
[23:27:24 --4:00] [Thread 23835] extDB2: Output to Server: 
[23:27:24 --4:00] [Thread 23835] extDB2: Input from Server: 9:ADD_DATABASE_PROTOCOL:exile:SQL_CUSTOM_V2:163506:exile
[23:27:24 --4:00] [Thread 23835] extDB2: Error Invalid Format: 9:ADD_DATABASE_PROTOCOL:exile:SQL_CUSTOM_V2:163506:exile
[23:27:24 --4:00] [Thread 23835] extDB2: Output to Server: [0,"Error Invalid Format"]
[23:27:24 --4:00] [Thread 23835] extDB2: Input from Server: 9:SHUTDOWN
[23:27:24 --4:00] [Thread 23835] extDB2: Error Invalid Format: 9:SHUTDOWN
[23:27:24 --4:00] [Thread 23835] extDB2: Output to Server: [0,"Error Invalid Format"]
[23:27:24 --4:00] [Thread 23835] extDB2: Input from Server: 9:SHUTDOWN
[23:27:24 --4:00] [Thread 23835] extDB2: Error Invalid Format: 9:SHUTDOWN
[23:27:24 --4:00] [Thread 23835] extDB2: Output to Server: [0,"Error Invalid Format"]

[iVaper 13]

Any update on this? I'm getting this same issue when I add infistar to my startup.. if I load without it, server runs smooth and perfect. I add -servermod=@infistar_servermod\; into it, it loops and loops and loops. I've reached out to infistar, no reply yet. Shane did attempt to assist me, but his knowledge in linux is very little. 

WINE is not an option, there is no update to the vcrun2010 yet. Reloading to Windows Server is not an option, I chose linux because of it's stability and performance (and open source). 

I'm really hoping those of us on Linux Root servers will come together and figure this out (with some help from the devs of Exile, extDB2 and infistar)

[Inq 4]

I have this problem now; Database shutsdown and restarts infinitely when Infistar is added to the modline. is there a fix?