players timeout on bambi request

[Timber 17]

I am having an issue with some players not being able to join. It is a fresh server and there have been 3 of us in the database for a week now, but tonight a couple f new players tried to join and they got a time out on requesting bambi character. I searched through the logs and found this.

rpt file

 

0:03:24 "ExileServer - Starting session for '[=UWS=]DJNPHOTO' with ID 'QhRhKqdp'..."
 0:03:25 Error in expression <llExtension _query);
(_result select 1) select 0>
 0:03:25   Error position: <select 0>
 0:03:25   Error Generic error in expression
 0:03:25 File exile_server\code\ExileServer_system_database_query_insertSingle.sqf, line 16
 0:03:25 Error in expression <llExtension _query);
(_result select 1) select 0>
 0:03:25   Error position: <select 0>
 0:03:25   Error Generic error in expression
 0:03:25 File exile_server\code\ExileServer_system_database_query_insertSingle.sqf, line 16

 

MySQL database logs

[23:36:53:237732 --3:00] [Thread 7560] extDB2: Database Type: MySQL
[23:36:53:241732 --3:00] [Thread 7560] extDB2: Database Session Pool Started
[23:36:53:243732 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\ExileServ2\@exileServer\extDB\sql_custom_v2\exile.ini
[23:36:53:244732 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[23:37:50:841026 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error	[mysql_stmt_error]: Cannot add or update a child row: a foreign key constraint fails (`exilenam`.`player`, CONSTRAINT `player_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE)	[mysql_stmt_errno]: 1452	[mysql_stmt_sqlstate]: 23000	[statemnt]: INSERT INTO player SET account_uid = ?, name = ?
[23:37:50:841026 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[23:37:50:841026 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198015699207:[=UWS=]DJNPHOTO
[23:41:57:282122 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error	[mysql_stmt_error]: Cannot add or update a child row: a foreign key constraint fails (`exilenam`.`player`, CONSTRAINT `player_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE)	[mysql_stmt_errno]: 1452	[mysql_stmt_sqlstate]: 23000	[statemnt]: INSERT INTO player SET account_uid = ?, name = ?
[23:41:57:282122 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[23:41:57:282122 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561197961975287:Wysper
[23:42:30:288010 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error	[mysql_stmt_error]: Cannot add or update a child row: a foreign key constraint fails (`exilenam`.`player`, CONSTRAINT `player_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE)	[mysql_stmt_errno]: 1452	[mysql_stmt_sqlstate]: 23000	[statemnt]: INSERT INTO player SET account_uid = ?, name = ?
[23:42:30:288010 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[23:42:30:288010 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198015699207:[=UWS=]DJNPHOTO
[23:50:51:127656 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error	[mysql_stmt_error]: Cannot add or update a child row: a foreign key constraint fails (`exilenam`.`player`, CONSTRAINT `player_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE)	[mysql_stmt_errno]: 1452	[mysql_stmt_sqlstate]: 23000	[statemnt]: INSERT INTO player SET account_uid = ?, name = ?
[23:50:51:127656 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[23:50:51:127656 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561197961975287:Wysper
[23:52:52:314588 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error	[mysql_stmt_error]: Cannot add or update a child row: a foreign key constraint fails (`exilenam`.`player`, CONSTRAINT `player_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE)	[mysql_stmt_errno]: 1452	[mysql_stmt_sqlstate]: 23000	[statemnt]: INSERT INTO player SET account_uid = ?, name = ?
[23:52:52:314588 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[23:52:52:314588 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198015699207:[=UWS=]DJNPHOTO
[23:55:43:179361 --3:00] [Thread 7560] extDB2: Stopping ...

My guess is that the dbase cannot create the new entries, but I have no idea why not...Can anyone help?

Edited April 30, 2016 by Timber

[-= TGM =- 1]

Hello!

I have the same problem on my server.

But only some of the players get this, some can join!

Anyone have a solution for this?

 

[Harper9690 0]

^{Getting the same message with a single player, all others can join. Any help? Started randomly today.}

[Timber 17]

I can confirm removing CBA solved my issue. I am running Joint Rails server side. You get an error with CUP crying about requiring CBA on server boot, but hit ok and  everything seems to work fine with JR

Seems that me and a couple of others had joined prior to adding CBA to the server. After the addition, no new players could be added to the database, however, players that existed in the dbase prior to, could still join and their progress was saved. I cant explain why..thats just what happened...

Edited May 2, 2016 by Timber

[StokesMagee 871]

48 minutes ago, Timber said:

I can confirm removing CBA solved my issue. I am running Joint Rails server side. You get an error with CUP crying about requiring CBA on server boot, but hit ok and  everything seems to work fine with JR

Seems that me and a couple of others had joined prior to adding CBA to the server. After the addition, no new players could be added to the database, however, players that existed in the dbase prior to, could still join and their progress was saved. I cant explain why..thats just what happened...

FYI, joint rails and CBA are the exact same thing, CBA just has more functions.

[[OMG]Slim 62]

Lol, if you guys would use search function you would find a fix to CBA problems. And yeah you can overcome CBA isssues with GUN MODS using JR but CBA is needed for a lot more than just guns.