• 0
disto1978

Error: Bambi creation timeout - 0.9.6

Question

Posted (edited)

Hey Guys,

i set up a new server for Namalsk with Exile 0.9.6 and get a Bambi creation error.

Database Log...
 

extDB2: Version: 70
extDB2: https://github.com/Torndeco/extDB2
extDB2: Windows Version
Message: All development for extDB2 is done on a Linux Dedicated Server
Message: If you would like to Donate to extDB2 Development
Message: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2
Message: Also leave a message if there is any particular feature you would like to see added.
Message: Thanks for all the people that have donated.
Message: Torndeco: 20/02/15


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


[13:50:44:790737 +02:00] [Thread 127280] extDB2: Database Type: MySQL
[13:50:44:791755 +02:00] [Thread 127280] extDB2: Database Session Pool Started
[13:50:44:792636 +02:00] [Thread 127280] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\Gameserver\Arma3\server1\@ExileServer\extDB\sql_custom_v2\exile.ini
[13:50:44:792758 +02:00] [Thread 127280] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[13:52:41:322532 +02:00] [Thread 127280] 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 (`exile2`.`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 = ?
[13:52:41:322598 +02:00] [Thread 127280] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[13:52:41:322615 +02:00] [Thread 127280] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:765611979xxxxxxxx:Player
[13:56:20:228429 +02:00] [Thread 127280] extDB2: Stopping ...

 

Strict mode is disabled...

20160307030.png

...any idea whats going wrong?

Edited by disto1978

Share this post


Link to post
Share on other sites

4 answers to this question

  • 0

OK, after reading some google stuff solved it for the moment by disable CBA Mod. Maybe CBA is not compatible with Exile 0.9.6 or Namalsk map?

1 person likes this

Share this post


Link to post
Share on other sites
  • 0

i have the same for players who arent in the database already,everyone who has entries in the db can join and play just fine.

cba and all cup mods running with no problems,its only for the "new" players

Share this post


Link to post
Share on other sites
Advertisement
  • 0
Cannot add or update a child row: a foreign key constraint fails (`exile2`.`player`, CONSTRAINT `player_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE)

this error is basically saying that you are trying to add a row into exile2.player that does not exist in your account table. OR vice versa. How do you have your database structure set up? I'm assuming that you are trying to hive?

from what it looks like, you didn't run the query on the database that removes the original foreign key constraints and replaces them with the hive foreign key constraints.

Share this post


Link to post
Share on other sites
  • 0

Posted (edited)

I have the same problem, however mine is a bit different. If I run just standard Exile mod, and recreate the database with the @ExileServer .sql file that is provided, players are added to the database just fine, however when running essentially the same mods as the OP, I get this error. If I am already in the database however before loading mods, I am able to load in just fine.

Edit: After disabling @CBA_A3 from the -mod parameters everything works as expected, however there is a requirement error as the server starts. Is there a workaround for CBA and Exile that I am missing?

[11:25:23:852638 --7:00] [Thread 2292] extDB2: Database Type: MySQL
[11:25:23:854001 --7:00] [Thread 2292] extDB2: Database Session Pool Started
[11:25:23:855436 --7:00] [Thread 2292] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\Server_Root\Arma_3\@ExileServer\extDB\sql_custom_v2\exile.ini
[11:25:23:855562 --7:00] [Thread 2292] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[11:26:01:184399 --7:00] [Thread 2292] 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 (`exile`.`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 = ?
[11:26:01:184537 --7:00] [Thread 2292] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[11:26:01:184586 --7:00] [Thread 2292] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198012590096:fatguy1121

SOLUTION: Found in this thread, Ill give an abridged version though.

In @ExileServer\addons\exile_server.pbo\code\

MODIFY

ExileServer_system_process_preInit.sqf
LINE:
onPlayerConnected {[_uid, _name] call ExileServer_system_network_event_onPlayerConnected};
onPlayerDisconnected {[_uid, _name] call ExileServer_system_network_event_onPlayerDisconnected};

TO
["ExileOPC", "onPlayerConnected", {[_uid, _name] call ExileServer_system_network_event_onPlayerConnected}] call BIS_fnc_addStackedEventHandler;
["ExileOPD", "onPlayerDisconnected", {[_uid, _name] call ExileServer_system_network_event_onPlayerDisconnected}] call BIS_fnc_addStackedEventHandler;

Edited by fatguy1121
more info

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.