Timber

players timeout on bambi request

6 posts in this topic

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 by Timber

Share this post


Link to post
Share on other sites
Advertisement

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 by Timber

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

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.

 

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.