Sign in to follow this  
Followers 0
Timmay

Remote Database Issues, Poor Connnectivity?

5 posts in this topic

Posted (edited)

Lately we have had some players complaining about missing objects (vehicles, safes, etc) with no rhyme or reason. There has been no clear line that divides when things were functional and when communication broke down, let me explain. One player can do a series of 4 actions over a period of an hour right after a restart and log off. When that player logs back in action 1, 3 and 4 (buy a vehicle, sell gear, place an object) are how he left it but action 2 (lets sell a vehicle) has been reverted. Now lets say player 2 jumps in with an hour left and does 5 actions, he logs off before a restart and logs back in. Player 2's actions 2-5 are how he left it but that helo he moved, action 1 has been reverted.

In my mind I felt like connection to the database was spotty. I don't know how exile functions with the database (like if it fails to update the database does it keep trying, etc.) but another indication of this is that my intermittent ability to log into the database itself via PHPmyadmin. I get connections refused errors throughout the day. Sometimes on a server restart, it will give me this error and not start :[mysql_stmt_error]: Lost connection to MySQL server during query

If I restart the process everything seems fine, no changes and it restarts fine. I also get some occasional warnings about objects taking too long to load in the RPT then on next restart, nothing of the sort. Restarts already take too long and that helped me figure out their database is remote to the game servers but the host thinks its us and as SQL is a new beast to me, I don't know.

I run CUP V/U/W, DMS/Occupation/VEMFr/ZCP I have a few addons scripts which all create non-persistent objects and that is about it. A few overrides that do basic stuff like allow players to buy a RL direct to their person and that is about it.

Here are some of the extDB logs:

Spoiler

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


[21:45:46:064343 --7:00] [Thread 2460] extDB2: Database Type: MySQL
[21:45:47:522492 --7:00] [Thread 2460] extDB2: Database Session Pool Started
[21:45:47:527680 --7:00] [Thread 2460] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\TCAFiles\Users\ChrisG\13420\@ExileServer\extDB\sql_custom_v2\exile.ini
[21:45:47:528263 --7:00] [Thread 2460] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[02:27:01:711037 --7:00] [Thread 5904] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Lost connection to MySQL server during query    [mysql_stmt_errno]: 2013    [mysql_stmt_sqlstate]: HY000    [statemnt]: UPDATE vehicle SET is_locked = ?, fuel = ?, damage = ?, hitpoints = ?, position_x = ?, position_y = ?, position_z = ?, direction_x = ?, direction_y = ?, direction_z = ?, up_x = ?, up_y = ?, up_z = ?, cargo_items = ?, cargo_magazines = ?, cargo_weapons = ?, cargo_container = ? WHERE id = ?
[02:27:01:711210 --7:00] [Thread 5904] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[02:27:01:711241 --7:00] [Thread 5904] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updateVehicle:0:0.971741:0:[["HitLFWheel",0],["HitLF2Wheel",0],["HitRFWheel",0],["HitRF2Wheel",0],["HitFuel",0],["HitEngine",0],["HitBody",0],["HitGlass1",0],["HitGlass2",0],["HitGlass3",0],["HitGlass4",0],["HitGlass5",0],["HitRGlass",0],["HitLGlass",0],["HitGlass6",0],["HitLBWheel",0],["HitLMWheel",0],["HitRBWheel",0],["HitRMWheel",0],["",0],["",0],["",0],["",0],["HitTurret",0],["HitGun",0],["HitTurret",0],["HitGun",0]]:11562.00390625:14203.775391:-0.0655613:-0.0801392:-0.996342:-0.0296631:0.0752635:-0.0357222:0.996524:[[],[]]:[["Exile_Item_DuctTape",1],["Exile_Item_DuctTape",1],["Exile_Item_Rope",1],["7Rnd_408_Mag",7],["7Rnd_408_Mag",7],["7Rnd_408_Mag",7],["7Rnd_408_Mag",7],["7Rnd_408_Mag",7],["7Rnd_408_Mag",7],["7Rnd_408_Mag",7],["Exile_Item_EMRE",1],["Exile_Item_EnergyDrink",1]]:[["srifle_LRR_F","","","optic_LRPS",["7Rnd_408_Mag",1],""]]:[["Exile_Uniform_Woodland",[],[["7Rnd_408_Mag",2]],[[],[]]],["V_PlateCarrierSpec_rgr",[],[],[[],[]]],["B_Carryall_cbr",[],[],[[],[]]]]:871
[02:27:17:330531 --7:00] [Thread 3080] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Lost connection to MySQL server during query    [mysql_stmt_errno]: 2013    [mysql_stmt_sqlstate]: HY000    [statemnt]: UPDATE vehicle SET is_locked = ?, fuel = ?, damage = ?, hitpoints = ?, position_x = ?, position_y = ?, position_z = ?, direction_x = ?, direction_y = ?, direction_z = ?, up_x = ?, up_y = ?, up_z = ?, cargo_items = ?, cargo_magazines = ?, cargo_weapons = ?, cargo_container = ? WHERE id = ?
[02:27:17:330603 --7:00] [Thread 3080] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[02:27:17:330624 --7:00] [Thread 3080] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updateVehicle:0:0.971481:0:[["HitLFWheel",0],["HitLF2Wheel",0],["HitRFWheel",0],["HitRF2Wheel",0],["HitFuel",0],["HitEngine",0],["HitBody",0],["HitGlass1",0],["HitGlass2",0],["HitGlass3",0],["HitGlass4",0],["HitGlass5",0],["HitRGlass",0],["HitLGlass",0],["HitGlass6",0],["HitLBWheel",0],["HitLMWheel",0],["HitRBWheel",0],["HitRMWheel",0],["",0],["",0],["",0],["",0],["HitTurret",0],["HitGun",0],["HitTurret",0],["HitGun",0]]:11562.00390625:14203.775391:-0.0655613:-0.0801392:-0.996342:-0.0296631:0.0752635:-0.0357222:0.996524:[[],[]]:[["Exile_Item_DuctTape",1],["Exile_Item_DuctTape",1],["Exile_Item_Rope",1],["7Rnd_408_Mag",7],["7Rnd_408_Mag",7],["7Rnd_408_Mag",7],["7Rnd_408_Mag",7],["7Rnd_408_Mag",7],["7Rnd_408_Mag",7],["7Rnd_408_Mag",7],["Exile_Item_EMRE",1],["Exile_Item_EnergyDrink",1]]:[["srifle_LRR_F","","","optic_LRPS",["7Rnd_408_Mag",1],""],["launch_B_Titan_short_F","","","",["Titan_AT",1],""]]:[["Exile_Uniform_Woodland",[],[["7Rnd_408_Mag",2]],[[],[]]],["V_PlateCarrierSpec_rgr",[],[],[[],[]]],["B_Carryall_cbr",[],[],[[],[]]]]:871
[03:32:47:635435 --7:00] [Thread 5904] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Lost connection to MySQL server during query    [mysql_stmt_errno]: 2013    [mysql_stmt_sqlstate]: HY000    [statemnt]: UPDATE vehicle SET is_locked = ?, fuel = ?, damage = ?, hitpoints = ?, position_x = ?, position_y = ?, position_z = ?, direction_x = ?, direction_y = ?, direction_z = ?, up_x = ?, up_y = ?, up_z = ?, cargo_items = ?, cargo_magazines = ?, cargo_weapons = ?, cargo_container = ? WHERE id = ?
[03:32:47:635611 --7:00] [Thread 5904] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[03:32:47:635651 --7:00] [Thread 5904] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updateVehicle:-1:1:0:[]:2733.886475:9995.691406:0.0116682:-0.906525:0.421764:-0.0180921:-0.0275103:-0.0162553:0.999489:[[],[]]:[]:[]:[]:335
[03:32:49:649801 --7:00] [Thread 3080] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Lost connection to MySQL server during query    [mysql_stmt_errno]: 2013    [mysql_stmt_sqlstate]: HY000    [statemnt]: UPDATE vehicle SET is_locked = ?, fuel = ?, damage = ?, hitpoints = ?, position_x = ?, position_y = ?, position_z = ?, direction_x = ?, direction_y = ?, direction_z = ?, up_x = ?, up_y = ?, up_z = ?, cargo_items = ?, cargo_magazines = ?, cargo_weapons = ?, cargo_container = ? WHERE id = ?
[03:32:49:649886 --7:00] [Thread 3080] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[03:32:49:649922 --7:00] [Thread 3080] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updateVehicle:-1:1:0.0166329:[]:2729.711426:9990.414063:0.0479536:0.895665:-0.444216:0.0213673:-0.0320425:-0.0165368:0.99935:[[],[]]:[]:[]:[]:343
[03:52:43:007779 --7:00] [Thread 2460] extDB2: Stopping ...

 

Spoiler

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


[03:54:24:220571 --7:00] [Thread 1228] extDB2: Database Type: MySQL
[03:54:33:460356 --7:00] [Thread 1228] extDB2: Database Session Pool Started
[03:54:33:466759 --7:00] [Thread 1228] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\TCAFiles\Users\ChrisG\13420\@ExileServer\extDB\sql_custom_v2\exile.ini
[03:54:33:467370 --7:00] [Thread 1228] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[04:42:15:090194 --7:00] [Thread 2964] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Lost connection to MySQL server during query    [mysql_stmt_errno]: 2013    [mysql_stmt_sqlstate]: HY000    [statemnt]: UPDATE vehicle SET is_locked = ?, fuel = ?, damage = ?, hitpoints = ?, position_x = ?, position_y = ?, position_z = ?, direction_x = ?, direction_y = ?, direction_z = ?, up_x = ?, up_y = ?, up_z = ?, cargo_items = ?, cargo_magazines = ?, cargo_weapons = ?, cargo_container = ? WHERE id = ?
[04:42:15:090336 --7:00] [Thread 2964] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[04:42:15:090368 --7:00] [Thread 2964] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updateVehicle:-1:1:0:[]:2733.853271:9995.671875:0.0129051:-0.906525:0.421764:-0.0180921:-0.0275103:-0.0162553:0.999489:[[],[]]:[]:[]:[]:335
[04:42:17:108633 --7:00] [Thread 6080] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Lost connection to MySQL server during query    [mysql_stmt_errno]: 2013    [mysql_stmt_sqlstate]: HY000    [statemnt]: UPDATE vehicle SET is_locked = ?, fuel = ?, damage = ?, hitpoints = ?, position_x = ?, position_y = ?, position_z = ?, direction_x = ?, direction_y = ?, direction_z = ?, up_x = ?, up_y = ?, up_z = ?, cargo_items = ?, cargo_magazines = ?, cargo_weapons = ?, cargo_container = ? WHERE id = ?
[04:42:17:108722 --7:00] [Thread 6080] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[04:42:17:108757 --7:00] [Thread 6080] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updateVehicle:-1:1:0.0166329:[]:2729.669189:9990.392578:0.0496397:0.895665:-0.444216:0.0213673:-0.0320425:-0.0165368:0.99935:[[],[]]:[]:[]:[]:343
[06:49:13:784616 --7:00] [Thread 1228] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Lost connection to MySQL server during query    [mysql_stmt_errno]: 2013    [mysql_stmt_sqlstate]: HY000    [statemnt]: SELECT CASE WHEN EXISTS(SELECT uid FROM account WHERE uid = ?) THEN 'true' ELSE 'false' END
[06:49:13:784794 --7:00] [Thread 1228] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[06:49:13:784836 --7:00] [Thread 1228] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: isKnownAccount:76561197969921004
[07:23:33:841575 --7:00] [Thread 2964] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Lost connection to MySQL server during query    [mysql_stmt_errno]: 2013    [mysql_stmt_sqlstate]: HY000    [statemnt]: UPDATE vehicle SET is_locked = ?, fuel = ?, damage = ?, hitpoints = ?, position_x = ?, position_y = ?, position_z = ?, direction_x = ?, direction_y = ?, direction_z = ?, up_x = ?, up_y = ?, up_z = ?, cargo_items = ?, cargo_magazines = ?, cargo_weapons = ?, cargo_container = ? WHERE id = ?
[07:23:33:841689 --7:00] [Thread 2964] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[07:23:33:841714 --7:00] [Thread 2964] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updateVehicle:-1:1:0:[]:2733.853271:9995.671875:0.0129051:-0.906525:0.421764:-0.0180921:-0.0275103:-0.0162553:0.999489:[[],[]]:[]:[]:[]:335
[07:23:35:840832 --7:00] [Thread 6080] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Lost connection to MySQL server during query    [mysql_stmt_errno]: 2013    [mysql_stmt_sqlstate]: HY000    [statemnt]: UPDATE vehicle SET is_locked = ?, fuel = ?, damage = ?, hitpoints = ?, position_x = ?, position_y = ?, position_z = ?, direction_x = ?, direction_y = ?, direction_z = ?, up_x = ?, up_y = ?, up_z = ?, cargo_items = ?, cargo_magazines = ?, cargo_weapons = ?, cargo_container = ? WHERE id = ?
[07:23:35:840895 --7:00] [Thread 6080] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[07:23:35:840917 --7:00] [Thread 6080] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updateVehicle:-1:1:0.0166329:[]:2729.669189:9990.392578:0.0496397:0.895665:-0.444216:0.0213673:-0.0320425:-0.0165368:0.99935:[[],[]]:[]:[]:[]:343
[07:49:40:226355 --7:00] [Thread 6080] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Lost connection to MySQL server during query    [mysql_stmt_errno]: 2013    [mysql_stmt_sqlstate]: HY000    [statemnt]: UPDATE vehicle SET is_locked = ?, fuel = ?, damage = ?, hitpoints = ?, position_x = ?, position_y = ?, position_z = ?, direction_x = ?, direction_y = ?, direction_z = ?, up_x = ?, up_y = ?, up_z = ?, cargo_items = ?, cargo_magazines = ?, cargo_weapons = ?, cargo_container = ? WHERE id = ?
[07:49:40:226522 --7:00] [Thread 6080] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[07:49:40:226558 --7:00] [Thread 6080] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updateVehicle:-1:1:0:[]:2733.853271:9995.671875:0.0129051:-0.906525:0.421764:-0.0180921:-0.0275103:-0.0162553:0.999489:[[],[]]:[]:[]:[]:335
[10:02:40:911797 --7:00] [Thread 2964] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Lost connection to MySQL server during query    [mysql_stmt_errno]: 2013    [mysql_stmt_sqlstate]: HY000    [statemnt]: UPDATE vehicle SET is_locked = ?, fuel = ?, damage = ?, hitpoints = ?, position_x = ?, position_y = ?, position_z = ?, direction_x = ?, direction_y = ?, direction_z = ?, up_x = ?, up_y = ?, up_z = ?, cargo_items = ?, cargo_magazines = ?, cargo_weapons = ?, cargo_container = ? WHERE id = ?
[10:02:40:911964 --7:00] [Thread 2964] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[10:02:40:911997 --7:00] [Thread 2964] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updateVehicle:-1:1:0:[]:2733.853271:9995.671875:0.0129051:-0.906525:0.421764:-0.0180921:-0.0275103:-0.0162553:0.999489:[[],[]]:[]:[]:[]:335
[10:02:42:925139 --7:00] [Thread 6080] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Lost connection to MySQL server during query    [mysql_stmt_errno]: 2013    [mysql_stmt_sqlstate]: HY000    [statemnt]: UPDATE vehicle SET is_locked = ?, fuel = ?, damage = ?, hitpoints = ?, position_x = ?, position_y = ?, position_z = ?, direction_x = ?, direction_y = ?, direction_z = ?, up_x = ?, up_y = ?, up_z = ?, cargo_items = ?, cargo_magazines = ?, cargo_weapons = ?, cargo_container = ? WHERE id = ?
[10:02:42:925204 --7:00] [Thread 6080] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[10:02:42:925228 --7:00] [Thread 6080] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updateVehicle:-1:1:0.0166329:[]:2729.669189:9990.392578:0.0496397:0.895665:-0.444216:0.0213673:-0.0320425:-0.0165368:0.99935:[[],[]]:[]:[]:[]:343
[10:03:16:025225 --7:00] [Thread 1228] extDB2: Stopping ...

 

Spoiler

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


[10:04:46:244315 --7:00] [Thread 4420] extDB2: Database Type: MySQL
[10:04:55:502303 --7:00] [Thread 4420] extDB2: Database Session Pool Started
[10:04:55:506577 --7:00] [Thread 4420] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\TCAFiles\Users\ChrisG\13420\@ExileServer\extDB\sql_custom_v2\exile.ini
[10:04:55:507000 --7:00] [Thread 4420] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[10:52:02:995509 --7:00] [Thread 2476] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Lost connection to MySQL server during query    [mysql_stmt_errno]: 2013    [mysql_stmt_sqlstate]: HY000    [statemnt]: UPDATE vehicle SET is_locked = ?, fuel = ?, damage = ?, hitpoints = ?, position_x = ?, position_y = ?, position_z = ?, direction_x = ?, direction_y = ?, direction_z = ?, up_x = ?, up_y = ?, up_z = ?, cargo_items = ?, cargo_magazines = ?, cargo_weapons = ?, cargo_container = ? WHERE id = ?
[10:52:02:995633 --7:00] [Thread 2476] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[10:52:02:995660 --7:00] [Thread 2476] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updateVehicle:-1:1:0:[]:2733.820068:9995.652344:0.0141554:-0.906525:0.421764:-0.0180921:-0.0275103:-0.0162553:0.999489:[[],[]]:[]:[]:[]:335
[10:52:04:995895 --7:00] [Thread 3768] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Lost connection to MySQL server during query    [mysql_stmt_errno]: 2013    [mysql_stmt_sqlstate]: HY000    [statemnt]: UPDATE vehicle SET is_locked = ?, fuel = ?, damage = ?, hitpoints = ?, position_x = ?, position_y = ?, position_z = ?, direction_x = ?, direction_y = ?, direction_z = ?, up_x = ?, up_y = ?, up_z = ?, cargo_items = ?, cargo_magazines = ?, cargo_weapons = ?, cargo_container = ? WHERE id = ?
[10:52:04:995967 --7:00] [Thread 3768] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[10:52:04:995993 --7:00] [Thread 3768] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updateVehicle:-1:1:0.0166329:[]:2729.626953:9990.371094:0.0513039:0.895665:-0.444216:0.0213673:-0.0320425:-0.0165368:0.99935:[[],[]]:[]:[]:[]:343
[11:18:27:345097 --7:00] [Thread 3768] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Lost connection to MySQL server during query    [mysql_stmt_errno]: 2013    [mysql_stmt_sqlstate]: HY000    [statemnt]: UPDATE vehicle SET is_locked = ?, fuel = ?, damage = ?, hitpoints = ?, position_x = ?, position_y = ?, position_z = ?, direction_x = ?, direction_y = ?, direction_z = ?, up_x = ?, up_y = ?, up_z = ?, cargo_items = ?, cargo_magazines = ?, cargo_weapons = ?, cargo_container = ? WHERE id = ?
[11:18:27:345239 --7:00] [Thread 3768] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[11:18:27:345267 --7:00] [Thread 3768] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updateVehicle:-1:1:0:[]:2733.820068:9995.652344:0.0141554:-0.906525:0.421764:-0.0180921:-0.0275103:-0.0162553:0.999489:[[],[]]:[]:[]:[]:335

 

Spoiler

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


[15:38:20:160820 --7:00] [Thread 3000] extDB2: Database Type: MySQL
[15:38:20:431964 --7:00] [Thread 3000] extDB2: Database Session Pool Started
[15:38:20:458053 --7:00] [Thread 3000] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\TCAFiles\Users\ChrisG\13420\@ExileServer\extDB\sql_custom_v2\exile.ini
[15:38:20:458633 --7:00] [Thread 3000] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[16:54:10:313878 --7:00] [Thread 568] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Lost connection to MySQL server during query    [mysql_stmt_errno]: 2013    [mysql_stmt_sqlstate]: HY000    [statemnt]: UPDATE vehicle SET is_locked = ?, fuel = ?, damage = ?, hitpoints = ?, position_x = ?, position_y = ?, position_z = ?, direction_x = ?, direction_y = ?, direction_z = ?, up_x = ?, up_y = ?, up_z = ?, cargo_items = ?, cargo_magazines = ?, cargo_weapons = ?, cargo_container = ? WHERE id = ?
[16:54:10:314093 --7:00] [Thread 568] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[16:54:17:299655 --7:00] [Thread 3388] extDB2: SQL_CUSTOM_V2: Error ConnectionFailedException: Connection attempt failed: Can't connect to MySQL server on '158.69.120.198' (10060)
[16:54:17:299691 --7:00] [Thread 568] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updateVehicle:-1:1:0:[]:2733.919678:9995.710938:0.0104303:-0.906525:0.421764:-0.0180921:-0.0275103:-0.0162553:0.999489:[[],[]]:[]:[]:[]:335
[16:54:17:299738 --7:00] [Thread 3388] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updateVehicle:0:0.916182:0.00393701:[["HitHull",0],["HitFuel",0],["HitEngine",0],["HitEngine1",0],["HitEngine2",0],["HitHRotor",0],["HitVRotor",0],["HitTransmission",0],["Glass_1_hitpoint",0],["Glass_2_hitpoint",0],["Glass_3_hitpoint",0],["Glass_4_hitpoint",0],["Glass_5_hitpoint",0],["Glass_6_hitpoint",0],["Glass_7_hitpoint",0],["Glass_8_hitpoint",0],["Glass_9_hitpoint",0],["Glass_10_hitpoint",0],["Glass_11_hitpoint",0],["Glass_12_hitpoint",0],["Glass_13_hitpoint",0],["Glass_14_hitpoint",0],["Glass_15_hitpoint",0],["Glass_16_hitpoint",0],["Glass_17_hitpoint",0],["Glass_18_hitpoint",0],["Glass_19_hitpoint",0],["Glass_20_hitpoint",0],["HitAvionics",0],["HitMissiles",0],["HitRGlass",0],["HitLGlass",0],["HitEngine3",0],["HitWinch",0],["HitGlass1",0],["HitGlass2",0],["HitGlass3",0],["HitGlass4",0],["HitGlass5",0],["HitGlass6",0],["HitLight",0],["HitHydraulics",0],["HitGear",0],["HitHStabilizerL1",0],["HitHStabilizerR1",0],["HitVStabilizer1",0],["HitTail",0],["HitPitotTube",0],["HitStaticPort",0],["HitStarter1",0],["HitStarter2",0],["HitStarter3",0],["",0],["HitTurret",0],["HitGun",0],["HitTurret",0],["HitGun",0]]:3610.873047:10926.601563:6.290297:0.68158:0.731742:-0.00170898:0.00224329:0.000245992:0.999997:[[],[]]:[["Exile_Item_FuelCanisterEmpty",1],["Exile_Item_FuelCanisterEmpty",1]]:[]:[]:837
[17:09:14:803166 --7:00] [Thread 568] extDB2: SQL_CUSTOM_V2: Error ConnectionFailedException: Connection attempt failed: Lost connection to MySQL server at 'reading authorization packet', system error: 0
[17:09:14:803232 --7:00] [Thread 568] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:DeWynter:0:88.527107:88.418869:0:1:0:[["face_hub",0],["neck",0],["head",0],["pelvis",0],["spine1",0],["spine2",0],["spine3",0],["body",0],["arms",0],["hands",0],["legs",0]]:226.451599:14569.52832:16765.332031:0.126438:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio","NVGoggles_INDEP","Laserdesignator_02"]:B_Carryall_ocamo:[["bipod_02_F_blk",1]]:[["APERSTripMine_Wire_Mag",1],["30Rnd_556x45_Stanag_red",30],["30Rnd_556x45_Stanag_red",30]]:[["arifle_MXC_F",1],["arifle_Mk20_GL_F",1]]:srifle_DMR_05_hex_F::["","","",""]:hgun_P07_F:H_HelmetB_desert:Laserdesignator_02:[["srifle_DMR_05_hex_F","10Rnd_93x64_DMR_05_Mag",10,"srifle_DMR_05_hex_F"],["hgun_P07_F","30Rnd_9x21_Mag",30,"hgun_P07_F"]]:srifle_DMR_05_hex_F:["","","CUP_optic_ElcanM145",""]::["","","",""]:U_I_CombatUniform_shortsleeve:[["optic_AMS_snd",1]]:[["30Rnd_556x45_Stanag_red",30]]:[]:V_PlateCarrierGL_rgr:[["bipod_02_F_hex",1],["optic_LRPS",1],["optic_KHS_hex",1]]:[["Exile_Item_PlasticBottleFreshWater",1],["Exile_Item_InstaDoc",1],["30Rnd_65x39_caseless_mag_Tracer",30],["1Rnd_HE_Grenade_shell",1],["UGL_FlareRed_F",1],["10Rnd_93x64_DMR_05_Mag",10],["10Rnd_93x64_DMR_05_Mag",10],["10Rnd_93x64_DMR_05_Mag",10],["30Rnd_556x45_Stanag_red",30]]:[]:37:0:1926
[17:09:35:815044 --7:00] [Thread 3204] extDB2: SQL_CUSTOM_V2: Error ConnectionFailedException: Connection attempt failed: Can't connect to MySQL server on '158.69.120.198' (10060)
[17:09:35:815122 --7:00] [Thread 3204] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:DeWynter:0:88.527107:88.418869:0:1:0:[["face_hub",0],["neck",0],["head",0],["pelvis",0],["spine1",0],["spine2",0],["spine3",0],["body",0],["arms",0],["hands",0],["legs",0]]:226.451599:14569.52832:16765.332031:0.126438:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio","NVGoggles_INDEP","Laserdesignator_02"]:B_Carryall_ocamo:[["bipod_02_F_blk",1]]:[["APERSTripMine_Wire_Mag",1],["30Rnd_556x45_Stanag_red",30],["30Rnd_556x45_Stanag_red",30]]:[["arifle_MXC_F",1],["arifle_Mk20_GL_F",1]]:srifle_DMR_05_hex_F::["","","",""]:hgun_P07_F:H_HelmetB_desert:Laserdesignator_02:[["srifle_DMR_05_hex_F","10Rnd_93x64_DMR_05_Mag",10,"srifle_DMR_05_hex_F"],["hgun_P07_F","30Rnd_9x21_Mag",30,"hgun_P07_F"]]:srifle_DMR_05_hex_F:["","","CUP_optic_ElcanM145",""]::["","","",""]:U_I_CombatUniform_shortsleeve:[]:[["30Rnd_556x45_Stanag_red",30]]:[]:V_PlateCarrierGL_rgr:[["bipod_02_F_hex",1],["optic_LRPS",1],["optic_KHS_hex",1]]:[["Exile_Item_PlasticBottleFreshWater",1],["Exile_Item_InstaDoc",1],["30Rnd_65x39_caseless_mag_Tracer",30],["1Rnd_HE_Grenade_shell",1],["UGL_FlareRed_F",1],["10Rnd_93x64_DMR_05_Mag",10],["10Rnd_93x64_DMR_05_Mag",10],["10Rnd_93x64_DMR_05_Mag",10],["30Rnd_556x45_Stanag_red",30]]:[]:37:0:1926
[17:22:16:165176 --7:00] [Thread 568] extDB2: SQL_CUSTOM_V2: Error ConnectionFailedException: Connection attempt failed: Can't connect to MySQL server on '158.69.120.198' (10060)
[17:22:16:165222 --7:00] [Thread 568] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updateLock:-1:1153
[17:44:23:633428 --7:00] [Thread 3204] extDB2: SQL_CUSTOM_V2: Error ConnectionFailedException: Connection attempt failed: Can't connect to MySQL server on '158.69.120.198' (10060)
[17:44:23:633541 --7:00] [Thread 3204] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updateVehicle:0:0.997024:0:[["HitGlass1",0],["HitGlass2",0],["HitGlass3",0],["HitGlass4",0],["HitGlass5",0],["HitHull",0],["HitEngine",0],["HitEngine1",0],["HitEngine2",0],["HitAvionics",0],["HitMissiles",0],["HitFuel",0],["HitHRotor",0],["HitVRotor",0],["HitRGlass",0],["HitLGlass",0],["HitEngine3",0],["HitWinch",0],["HitTransmission",0],["HitGlass6",0],["HitLight",0],["HitHydraulics",0],["HitGear",0],["HitHStabilizerL1",0],["HitHStabilizerR1",0],["HitVStabilizer1",0],["HitTail",0],["HitPitotTube",0],["HitStaticPort",0],["HitStarter1",0],["HitStarter2",0],["HitStarter3",0],["",0],["HitTurret",0],["HitGun",0],["HitTurret",0],["HitGun",0],["HitTurret",0],["HitGun",0],["HitTurret",0],["HitGun",0],["HitTurret",0],["HitGun",0],["HitTurret",0],["HitGun",0],["HitTurret",0],["HitGun",0]]:12506.408203:15196.0507813:-0.0146942:-0.765808:-0.632448:0.116394:0.0963473:0.0661133:0.99315:[[],[]]:[]:[]:[]:834
[21:44:13:273624 --7:00] [Thread 3000] extDB2: Stopping ...

Again, SQL is a new beast to me but it would seem with the players experience, mine, the remote database aspect and the intermittent lack of any pattern would indicate connection issues between the server and database? Please correct me if I am wrong.

Here is one that fails to get the server up and running and is usually resolved with a force restart:

Spoiler

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


[01:07:14:119608 --7:00] [Thread 2448] extDB2: Database Type: MySQL
[01:07:23:351570 --7:00] [Thread 2448] extDB2: Database Session Pool Started
[01:07:23:354035 --7:00] [Thread 2448] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\TCAFiles\Users\JeffV\11721\@ExileServer\extDB\sql_custom_v2\exile.ini
[01:07:23:354302 --7:00] [Thread 2448] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[01:13:02:738643 --7:00] [Thread 2448] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Lost connection to MySQL server during query    [mysql_stmt_errno]: 2013    [mysql_stmt_sqlstate]: HY000    [statemnt]: SELECT id,class,account_uid,spawned_at,position_x,position_y,position_z,direction_x,direction_y,direction_z,up_x,up_y,up_z,is_locked,pin_code,territory_id FROM construction WHERE id = ?
[01:13:02:738696 --7:00] [Thread 2448] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[01:13:02:738711 --7:00] [Thread 2448] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: loadConstruction:856

 

 

Edited by Timmay

Share this post


Link to post
Share on other sites

Yeah that's all connection drops. Your best bet is to run the database on the same machine for reliability sake if you're connecting across the internet to a database. The internet isn't terribly reliable, and all that will certainly cause the problems you are seeing. 

Share this post


Link to post
Share on other sites
Advertisement
On 6/7/2016 at 1:51 PM, g0thic_ice_cre said:

Yeah that's all connection drops. Your best bet is to run the database on the same machine for reliability sake if you're connecting across the internet to a database. The internet isn't terribly reliable, and all that will certainly cause the problems you are seeing. 

That's what I figured was going on. 

The host and I have been going back and forth about the database being remote, etc. I get these [mysql_stmt_error]: Lost connection to MySQL server during query at restarts which is such a small sliver of time. I wonder what is going on during the servers up-time.

  @Torndeco If you have the time can you give me a gist of what triggers a database write/query? What happens when it fails to write, does it keep trying or what? What happens if a group of players are within a area of cars and the database connection drops and none of them can access the unlock option but when I come there I can? Does my using infiSTAR to shift - I the vehicle force the query? I am getting pretty confused with what to try and do to stop this madness. Also, would running the debug version of extDB help to show dropped connections and if so where can I get that?

Share this post


Link to post
Share on other sites

extDB2/3 will only retry once when it fails, after which it reports the error back to armaserver.
Exileserver code doesn't have any error handling for extDB2.
It assumes the database interactions worked perfect, so you will get script errors etc..

The reason you prob see it more at server startup, is because you have more queries when its fetching vehicles / objects.

Share this post


Link to post
Share on other sites
8 hours ago, Torndeco said:

extDB2/3 will only retry once when it fails, after which it reports the error back to armaserver.
Exileserver code doesn't have any error handling for extDB2.
It assumes the database interactions worked perfect, so you will get script errors etc..

The reason you prob see it more at server startup, is because you have more queries when its fetching vehicles / objects.

Thanks for the reply. We convinced our host to gives us a local database to our game server that I was able to set up from scratch and import our old database and things seemed to improve greatly. Our restart time went from 15-18 minutes down to well under 3 minutes. I also can see a more reactive database.

Is there a debug version of extDB?

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
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.