Server restarts once certain missions start

Server restarts once certain missions start

« posted: Apr 12, 2015, 10:33 AM »
My server has the latest commit of Development_main.

I will crash once certain missions (town invasion, weapon smugglers) started. And when this happens, the syslog shows:

Code: [Select]
[68494.020854] arma3server[23347]: segfault at 0 ip 00000000f75c6151 sp 00000000ffe9dea0 error 6 in libc-2.19.so[f7492000+1    a8000]

Re: Server restarts once certain missions start

« Reply #1 posted: Apr 12, 2015, 12:40 PM »
I completely reset the database. It still happens. And I get following error in extDB2 log:

Code: [Select]
extDB2: Version: 50
extDB2: Linux Version
Message: Donated to extDB2 Develeopment ?
Message: All development for extDB2 is done on a Linux Dedicated Server
Message: Donate Link https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2
Message: Leave a message if there is a 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


[17:24:00 +08:00] [Thread 3975125740] extDB2: Database Type: MySQL
[17:24:00 +08:00] [Thread 3975125740] extDB2: Database Session Pool Started
[17:24:00 +08:00] [Thread 3975125740] extDB2: SQL_CUSTOM: Loading Template Filename: /home/server/arma3/a3_server0/@extDB2/extDB/sql_custom/a3wasteland.ini
[18:05:53 +08:00] [Thread 754495262] extDB2: SQL_CUSTOM: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error [mysql_stmt_error]: Cannot add or update a child row: a foreign key constraint fails (`a3wasteland`.`PlayerSave`, CONSTRAINT `fk_PlayerSave_PlayerInfo` FOREIGN KEY (`PlayerUID`) REFERENCES `PlayerInfo` (`UID`) ON DELETE NO ACTION ON UPDATE NO ACTION) [mysql_stmt_errno]: 1452 [mysql_stmt_sqlstate]: 23000 [statemnt]: INSERT INTO PlayerSave SET PlayerUID = ?, MapID = ?, CreationDate = NOW(), Damage=0,HitPoints='[["HitHead",0],["HitBody",0],["HitHands",0],["HitLegs",0]]',Money=0,Uniform='"U_I_GhillieSuit"',Vest='"V_Chestrig_oli"',Backpack='""',Goggles='""',Headgear='""',PrimaryWeapon='"srifle_GM6_LRPS_F"',SecondaryWeapon='""',HandgunWeapon='"hgun_ACPC2_snds_F"',PrimaryWeaponItems='["","","optic_LRPS",""]',SecondaryWeaponItems='["","","",""]',HandgunItems='["muzzle_snds_acp","","",""]',AssignedItems='["ItemMap","ItemCompass","ItemWatch","ItemRadio","ItemGPS","NVGoggles_INDEP","Rangefinder"]',UniformWeapons='[]',UniformItems='[["FirstAidKit",1]]',UniformMagazines='[["5Rnd_127x108_Mag",2],["SmokeShell",1]]',VestWeapons='[]',VestItems='[]',VestMagazines='[["5Rnd_127x108_Mag",3],["9Rnd_45ACP_Mag",2],["APERSTripMine_Wire_Mag",1],["ClaymoreDirectionalMine_Remote_Mag",1],["SmokeShellGreen",1],["SmokeShellOrange",1],["SmokeShellPurple",1],["Chemlight_green",2]]',BackpackWeapons='[]',BackpackItems='[]',BackpackMagazines='[]',LoadedMagazines='[["5Rnd_127x108_Mag",5],["9Rnd_45ACP_Mag",9]]' ON DUPLICATE KEY UPDATE Damage=VALUES(Damage),HitPoints=VALUES(HitPoints),Money=VALUES(Money),Uniform=VALUES(Uniform),Vest=VALUES(Vest),Backpack=VALUES(Backpack),Goggles=VALUES(Goggles),Headgear=VALUES(Headgear),PrimaryWeapon=VALUES(PrimaryWeapon),SecondaryWeapon=VALUES(SecondaryWeapon),HandgunWeapon=VALUES(HandgunWeapon),PrimaryWeaponItems=VALUES(PrimaryWeaponItems),SecondaryWeaponItems=VALUES(SecondaryWeaponItems),HandgunItems=VALUES(HandgunItems),AssignedItems=VALUES(AssignedItems),UniformWeapons=VALUES(UniformWeapons),UniformItems=VALUES(UniformItems),UniformMagazines=VALUES(UniformMagazines),VestWeapons=VALUES(VestWeapons),VestItems=VALUES(VestItems),VestMagazines=VALUES(VestMagazines),BackpackWeapons=VALUES(BackpackWeapons),BackpackItems=VALUES(BackpackItems),BackpackMagazines=VALUES(BackpackMagazines),LoadedMagazines=VALUES(LoadedMagazines);
[18:05:53 +08:00] [Thread 754495262] extDB2: SQL_CUSTOM: Clearing Any Cached Statements
[18:05:53 +08:00] [Thread 754495262] extDB2: SQL_CUSTOM: Error Exception: UniqueID: 0 SQL: insertOrUpdatePlayerSave:76561198124251907:1:Damage=0,HitPoints='[["HitHead",0],["HitBody",0],["HitHands",0],["HitLegs",0]]',Money=0,Uniform='"U_I_GhillieSuit"',Vest='"V_Chestrig_oli"',Backpack='""',Goggles='""',Headgear='""',PrimaryWeapon='"srifle_GM6_LRPS_F"',SecondaryWeapon='""',HandgunWeapon='"hgun_ACPC2_snds_F"',PrimaryWeaponItems='["","","optic_LRPS",""]',SecondaryWeaponItems='["","","",""]',HandgunItems='["muzzle_snds_acp","","",""]',AssignedItems='["ItemMap","ItemCompass","ItemWatch","ItemRadio","ItemGPS","NVGoggles_INDEP","Rangefinder"]',UniformWeapons='[]',UniformItems='[["FirstAidKit",1]]',UniformMagazines='[["5Rnd_127x108_Mag",2],["SmokeShell",1]]',VestWeapons='[]',VestItems='[]',VestMagazines='[["5

Re: Server restarts once certain missions start

« Reply #2 posted: Apr 12, 2015, 04:48 PM »
I disabled the smuggler mission and now it seems to be solved.
  • Offline LouD
  • Silent but deadly ;)
  • Moderator
  • Veteran
  • ******
  • Posts: 1415

Re: Server restarts once certain missions start

« Reply #3 posted: Apr 12, 2015, 05:47 PM »
I disabled the smuggler mission and now it seems to be solved.
I'm not having this problem with the smuggler mission?

Re: Server restarts once certain missions start

« Reply #4 posted: Apr 13, 2015, 04:58 AM »
It is still unfixed. Now the server restarts about every 7 minutes. Here's one rpt log:

http://pastebin.com/z0j7j9aj

Re: Server restarts once certain missions start

« Reply #5 posted: Apr 13, 2015, 10:27 AM »
This caused by mysql error.

Check your a3wasteland.ini or database (UID 76561198124251907).

Code: [Select]
[18:05:53 +08:00] [Thread 754495262] extDB2: SQL_CUSTOM: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error [mysql_stmt_error]: Cannot add or update a child row: a foreign key constraint fails (`a3wasteland`.`PlayerSave`, CONSTRAINT `fk_PlayerSave_PlayerInfo` FOREIGN KEY (`PlayerUID`) REFERENCES `PlayerInfo` (`UID`) ON DELETE NO ACTION ON UPDATE NO ACTION) [mysql_stmt_errno]: 1452 [mysql_stmt_sqlstate]: 23000 [statemnt]: INSERT INTO PlayerSave SET PlayerUID = ?, MapID = ?, CreationDate = NOW(), Damage=0,HitPoints='[["HitHead",0],["HitBody",0],["HitHands",0],["HitLegs",0]]',Money=0,Uniform='"U_I_GhillieSuit"',Vest='"V_Chestrig_oli"',Backpack='""',Goggles='""',Headgear='""',PrimaryWeapon='"srifle_GM6_LRPS_F"',SecondaryWeapon='""',HandgunWeapon='"hgun_ACPC2_snds_F"',PrimaryWeaponItems='["","","optic_LRPS",""]',SecondaryWeaponItems='["","","",""]',HandgunItems='["muzzle_snds_acp","","",""]',AssignedItems='["ItemMap","ItemCompass","ItemWatch","ItemRadio","ItemGPS","NVGoggles_INDEP","Rangefinder"]',UniformWeapons='[]',UniformItems='[["FirstAidKit",1]]',UniformMagazines='[["5Rnd_127x108_Mag",2],["SmokeShell",1]]',VestWeapons='[]',VestItems='[]',VestMagazines='[["5Rnd_127x108_Mag",3],["9Rnd_45ACP_Mag",2],["APERSTripMine_Wire_Mag",1],["ClaymoreDirectionalMine_Remote_Mag",1],["SmokeShellGreen",1],["SmokeShellOrange",1],["SmokeShellPurple",1],["Chemlight_green",2]]',BackpackWeapons='[]',BackpackItems='[]',BackpackMagazines='[]',LoadedMagazines='[["5Rnd_127x108_Mag",5],["9Rnd_45ACP_Mag",9]]' ON DUPLICATE KEY UPDATE Damage=VALUES(Damage),HitPoints=VALUES(HitPoints),Money=VALUES(Money),Uniform=VALUES(Uniform),Vest=VALUES(Vest),Backpack=VALUES(Backpack),Goggles=VALUES(Goggles),Headgear=VALUES(Headgear),PrimaryWeapon=VALUES(PrimaryWeapon),SecondaryWeapon=VALUES(SecondaryWeapon),HandgunWeapon=VALUES(HandgunWeapon),PrimaryWeaponItems=VALUES(PrimaryWeaponItems),SecondaryWeaponItems=VALUES(SecondaryWeaponItems),HandgunItems=VALUES(HandgunItems),AssignedItems=VALUES(AssignedItems),UniformWeapons=VALUES(UniformWeapons),UniformItems=VALUES(UniformItems),UniformMagazines=VALUES(UniformMagazines),VestWeapons=VALUES(VestWeapons),VestItems=VALUES(VestItems),VestMagazines=VALUES(VestMagazines),BackpackWeapons=VALUES(BackpackWeapons),BackpackItems=VALUES(BackpackItems),BackpackMagazines=VALUES(BackpackMagazines),LoadedMagazines=VALUES(LoadedMagazines);
[18:05:53 +08:00] [Thread 754495262] extDB2: SQL_CUSTOM: Clearing Any Cached Statements
[18:05:53 +08:00] [Thread 754495262] extDB2: SQL_CUSTOM: Error Exception: UniqueID: 0 SQL: insertOrUpdatePlayerSave:76561198124251907:1:Damage=0,HitPoints='[["HitHead",0],["HitBody",0],["HitHands",0],["HitLegs",0]]',Money=0,Uniform='"U_I_GhillieSuit"',Vest='"V_Chestrig_oli"',Backpack='""',Goggles='""',Headgear='""',PrimaryWeapon='"srifle_GM6_LRPS_F"',SecondaryWeapon='""',HandgunWeapon='"hgun_ACPC2_snds_F"',PrimaryWeaponItems='["","","optic_LRPS",""]',SecondaryWeaponItems='["","","",""]',HandgunItems='["muzzle_snds_acp","","",""]',AssignedItems='["ItemMap","ItemCompass","ItemWatch","ItemRadio","ItemGPS","NVGoggles_INDEP","Rangefinder"]',UniformWeapons='[]',UniformItems='[["FirstAidKit",1]]',UniformMagazines='[["5Rnd_127x108_Mag",2],["SmokeShell",1]]',VestWeapons='[]',VestItems='[]',VestMagazines='[["5

I got same error past by different issue.

By the way, why you use extDB2 ? latest commit of Development_main not yet use extDB2.
  • Offline LouD
  • Silent but deadly ;)
  • Moderator
  • Veteran
  • ******
  • Posts: 1415

Re: Server restarts once certain missions start

« Reply #6 posted: Apr 13, 2015, 10:43 AM »
This caused by mysql error.

Check your a3wasteland.ini or database (UID 76561198124251907).

Code: [Select]
[18:05:53 +08:00] [Thread 754495262] extDB2: SQL_CUSTOM: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error [mysql_stmt_error]: Cannot add or update a child row: a foreign key constraint fails (`a3wasteland`.`PlayerSave`, CONSTRAINT `fk_PlayerSave_PlayerInfo` FOREIGN KEY (`PlayerUID`) REFERENCES `PlayerInfo` (`UID`) ON DELETE NO ACTION ON UPDATE NO ACTION) [mysql_stmt_errno]: 1452 [mysql_stmt_sqlstate]: 23000 [statemnt]: INSERT INTO PlayerSave SET PlayerUID = ?, MapID = ?, CreationDate = NOW(), Damage=0,HitPoints='[["HitHead",0],["HitBody",0],["HitHands",0],["HitLegs",0]]',Money=0,Uniform='"U_I_GhillieSuit"',Vest='"V_Chestrig_oli"',Backpack='""',Goggles='""',Headgear='""',PrimaryWeapon='"srifle_GM6_LRPS_F"',SecondaryWeapon='""',HandgunWeapon='"hgun_ACPC2_snds_F"',PrimaryWeaponItems='["","","optic_LRPS",""]',SecondaryWeaponItems='["","","",""]',HandgunItems='["muzzle_snds_acp","","",""]',AssignedItems='["ItemMap","ItemCompass","ItemWatch","ItemRadio","ItemGPS","NVGoggles_INDEP","Rangefinder"]',UniformWeapons='[]',UniformItems='[["FirstAidKit",1]]',UniformMagazines='[["5Rnd_127x108_Mag",2],["SmokeShell",1]]',VestWeapons='[]',VestItems='[]',VestMagazines='[["5Rnd_127x108_Mag",3],["9Rnd_45ACP_Mag",2],["APERSTripMine_Wire_Mag",1],["ClaymoreDirectionalMine_Remote_Mag",1],["SmokeShellGreen",1],["SmokeShellOrange",1],["SmokeShellPurple",1],["Chemlight_green",2]]',BackpackWeapons='[]',BackpackItems='[]',BackpackMagazines='[]',LoadedMagazines='[["5Rnd_127x108_Mag",5],["9Rnd_45ACP_Mag",9]]' ON DUPLICATE KEY UPDATE Damage=VALUES(Damage),HitPoints=VALUES(HitPoints),Money=VALUES(Money),Uniform=VALUES(Uniform),Vest=VALUES(Vest),Backpack=VALUES(Backpack),Goggles=VALUES(Goggles),Headgear=VALUES(Headgear),PrimaryWeapon=VALUES(PrimaryWeapon),SecondaryWeapon=VALUES(SecondaryWeapon),HandgunWeapon=VALUES(HandgunWeapon),PrimaryWeaponItems=VALUES(PrimaryWeaponItems),SecondaryWeaponItems=VALUES(SecondaryWeaponItems),HandgunItems=VALUES(HandgunItems),AssignedItems=VALUES(AssignedItems),UniformWeapons=VALUES(UniformWeapons),UniformItems=VALUES(UniformItems),UniformMagazines=VALUES(UniformMagazines),VestWeapons=VALUES(VestWeapons),VestItems=VALUES(VestItems),VestMagazines=VALUES(VestMagazines),BackpackWeapons=VALUES(BackpackWeapons),BackpackItems=VALUES(BackpackItems),BackpackMagazines=VALUES(BackpackMagazines),LoadedMagazines=VALUES(LoadedMagazines);
[18:05:53 +08:00] [Thread 754495262] extDB2: SQL_CUSTOM: Clearing Any Cached Statements
[18:05:53 +08:00] [Thread 754495262] extDB2: SQL_CUSTOM: Error Exception: UniqueID: 0 SQL: insertOrUpdatePlayerSave:76561198124251907:1:Damage=0,HitPoints='[["HitHead",0],["HitBody",0],["HitHands",0],["HitLegs",0]]',Money=0,Uniform='"U_I_GhillieSuit"',Vest='"V_Chestrig_oli"',Backpack='""',Goggles='""',Headgear='""',PrimaryWeapon='"srifle_GM6_LRPS_F"',SecondaryWeapon='""',HandgunWeapon='"hgun_ACPC2_snds_F"',PrimaryWeaponItems='["","","optic_LRPS",""]',SecondaryWeaponItems='["","","",""]',HandgunItems='["muzzle_snds_acp","","",""]',AssignedItems='["ItemMap","ItemCompass","ItemWatch","ItemRadio","ItemGPS","NVGoggles_INDEP","Rangefinder"]',UniformWeapons='[]',UniformItems='[["FirstAidKit",1]]',UniformMagazines='[["5Rnd_127x108_Mag",2],["SmokeShell",1]]',VestWeapons='[]',VestItems='[]',VestMagazines='[["5

I got same error past by different issue.

By the way, why you use extDB2 ? latest commit of Development_main not yet use extDB2.
I run extDB2 aswell. Have been since Torndeco created a pull request for it ;)
Rev has a separate extDB2 beta branch btw.

Re: Server restarts once certain missions start

« Reply #7 posted: Apr 13, 2015, 11:06 AM »
I might know the reason now. I rolled back the extDB2_beta commits and pulled Development_main commits yesterday. I thought it merged the extDB2 branch.

Re: Server restarts once certain missions start

« Reply #8 posted: Apr 13, 2015, 01:53 PM »
Rolled back to Feb 11th commit and repulled the commits from extDB2_beta branch. Now extDB2 shows no error in logs, However, the server would still crash when a mission starts. Here's the rpt log:

http://pastebin.com/U9wwd8aA
  • Offline LouD
  • Silent but deadly ;)
  • Moderator
  • Veteran
  • ******
  • Posts: 1415

Re: Server restarts once certain missions start

« Reply #9 posted: Apr 13, 2015, 01:58 PM »
So as soon as a mission starts the server crashes?
It reads from disk at that point. Maybe a bad sector?

Re: Server restarts once certain missions start

« Reply #10 posted: Apr 13, 2015, 03:50 PM »
What's logged extDB log ?

Re: Server restarts once certain missions start

« Reply #11 posted: Apr 13, 2015, 04:38 PM »
I've reset the database once again. The server crashed once again when the smuggler mission attempted to start.

Here's the rpt log: http://pastebin.com/RGpKqDLG

Here's the extDB2 log. Notice the last line:

Code: [Select]
extDB2: Version: 49
extDB2: Linux Version
Message: Donated to extDB2 Develeopment ?
Message: All development for extDB2 is done on a Linux Dedicated Server
Message: Donate Link https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2
Message: Leave a message if there is a 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:56:23 +08:00] [Thread 2675373329] extDB2: Database Type: MySQL
[21:56:23 +08:00] [Thread 2675373329] extDB2: Database Session Pool Started
[21:56:23 +08:00] [Thread 2675373329] extDB2: SQL_CUSTOM: Loading Template Filename: /home/server/arma3/a3_server0/@extDB2/extDB/sql_custom/a3wasteland.ini
[21:56:23 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:56:23 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:56:23 +08:00] [Thread 2675373329]
[21:56:23 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:56:23 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:56:23 +08:00] [Thread 2675373329]
[21:56:23 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:56:23 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:56:23 +08:00] [Thread 2675373329]
[21:56:23 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:56:23 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:56:23 +08:00] [Thread 2675373329]
[21:56:23 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:56:23 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:56:23 +08:00] [Thread 2675373329]
[21:56:23 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:56:23 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:56:23 +08:00] [Thread 2675373329]
[21:56:23 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:56:23 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:56:23 +08:00] [Thread 2675373329]
[21:56:23 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:56:23 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:56:23 +08:00] [Thread 2675373329]
[21:56:34 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:56:34 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:56:34 +08:00] [Thread 2675373329]
[21:56:36 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:56:36 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:56:36 +08:00] [Thread 2675373329]
[21:56:37 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:56:37 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:56:37 +08:00] [Thread 2675373329]
[21:56:37 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:56:37 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:56:37 +08:00] [Thread 2675373329]
[21:56:43 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:56:43 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:56:43 +08:00] [Thread 2675373329]
[21:56:45 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:56:45 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:56:45 +08:00] [Thread 2675373329]
[21:56:47 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:56:47 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:56:47 +08:00] [Thread 2675373329]
[21:56:47 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:56:47 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:56:47 +08:00] [Thread 2675373329]
[21:56:48 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:56:48 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:56:48 +08:00] [Thread 2675373329]
[21:56:48 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:56:48 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:56:48 +08:00] [Thread 2675373329]
[21:56:49 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:56:49 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:56:49 +08:00] [Thread 2675373329]
[21:56:49 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:56:49 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:56:49 +08:00] [Thread 2675373329]
[21:57:02 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:02 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:02 +08:00] [Thread 2675373329]
[21:57:17 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:17 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:17 +08:00] [Thread 2675373329]
[21:57:17 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:17 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:17 +08:00] [Thread 2675373329]
[21:57:17 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:17 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:17 +08:00] [Thread 2675373329]
[21:57:17 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:17 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:17 +08:00] [Thread 2675373329]
[21:57:25 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:25 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:25 +08:00] [Thread 2675373329]
[21:57:26 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:26 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:26 +08:00] [Thread 2675373329]
[21:57:26 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:26 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:26 +08:00] [Thread 2675373329]
[21:57:26 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:26 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:26 +08:00] [Thread 2675373329]
[21:57:29 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:29 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:29 +08:00] [Thread 2675373329]
[21:57:30 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:30 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:30 +08:00] [Thread 2675373329]
[21:57:30 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:30 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:30 +08:00] [Thread 2675373329]
[21:57:30 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:30 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:30 +08:00] [Thread 2675373329]
[21:57:30 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:30 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:30 +08:00] [Thread 2675373329]
[21:57:30 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:30 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:30 +08:00] [Thread 2675373329]
[21:57:30 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:30 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:30 +08:00] [Thread 2675373329]
[21:57:39 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:39 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:39 +08:00] [Thread 2675373329]
[21:57:41 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:41 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:41 +08:00] [Thread 2675373329]
[21:57:41 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:41 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:41 +08:00] [Thread 2675373329]
[21:57:43 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:43 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:43 +08:00] [Thread 2675373329]
[21:57:44 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:44 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:44 +08:00] [Thread 2675373329]
[21:57:44 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:44 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:44 +08:00] [Thread 2675373329]
[21:57:44 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:44 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:44 +08:00] [Thread 2675373329]
[21:57:46 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:46 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:46 +08:00] [Thread 2675373329]
[21:57:46 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:46 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:46 +08:00] [Thread 2675373329]
[21:57:48 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:48 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:48 +08:00] [Thread 2675373329]
[21:57:48 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:48 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:48 +08:00] [Thread 2675373329]
[21:57:48 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:48 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:48 +08:00] [Thread 2675373329]
[21:57:49 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:49 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:49 +08:00] [Thread 2675373329]
[21:57:49 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:49 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:49 +08:00] [Thread 2675373329]
[21:57:49 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:57:49 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:57:49 +08:00] [Thread 2675373329]
[21:58:16 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:58:16 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:58:16 +08:00] [Thread 2675373329]
[21:58:18 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:58:18 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:58:18 +08:00] [Thread 2675373329]
[21:58:18 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:58:18 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:58:18 +08:00] [Thread 2675373329]
[21:58:18 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:58:18 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:58:18 +08:00] [Thread 2675373329]
[21:58:50 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:58:50 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:58:50 +08:00] [Thread 2675373329]
[21:58:53 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:58:53 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:58:53 +08:00] [Thread 2675373329]
[21:58:53 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:58:53 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:58:53 +08:00] [Thread 2675373329]
[21:58:53 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:58:53 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:58:53 +08:00] [Thread 2675373329]
[21:59:45 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:59:45 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:59:45 +08:00] [Thread 2675373329]
[21:59:48 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:59:48 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:59:48 +08:00] [Thread 2675373329]
[21:59:48 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:59:48 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:59:48 +08:00] [Thread 2675373329]
[21:59:48 +08:00] [Thread 2675373329] extDB2: LOCK START
[21:59:48 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[21:59:48 +08:00] [Thread 2675373329]
[22:01:29 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:01:29 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:01:29 +08:00] [Thread 2675373329]
[22:01:35 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:01:35 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:01:35 +08:00] [Thread 2675373329]
[22:01:35 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:01:35 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:01:35 +08:00] [Thread 2675373329]
[22:01:35 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:01:35 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:01:35 +08:00] [Thread 2675373329]
[22:02:25 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:02:25 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:02:25 +08:00] [Thread 2675373329]
[22:02:33 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:02:33 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:02:33 +08:00] [Thread 2675373329]
[22:02:33 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:02:33 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:02:33 +08:00] [Thread 2675373329]
[22:03:02 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:03:02 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:03:02 +08:00] [Thread 2675373329]
[22:03:12 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:03:12 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:03:12 +08:00] [Thread 2675373329]
[22:03:12 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:03:12 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:03:12 +08:00] [Thread 2675373329]
[22:04:05 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:04:05 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:04:05 +08:00] [Thread 2675373329]
[22:04:05 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:04:05 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:04:05 +08:00] [Thread 2675373329]
[22:04:05 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:04:05 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:04:05 +08:00] [Thread 2675373329]
[22:04:05 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:04:05 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:04:05 +08:00] [Thread 2675373329]
[22:09:04 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:09:04 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:09:04 +08:00] [Thread 2675373329]
[22:12:34 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:12:34 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:12:34 +08:00] [Thread 2675373329]
[22:12:40 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:12:40 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:12:40 +08:00] [Thread 2675373329]
[22:12:40 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:12:40 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:12:40 +08:00] [Thread 2675373329]
[22:13:02 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:13:02 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:13:02 +08:00] [Thread 2675373329]
[22:13:06 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:13:06 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:13:06 +08:00] [Thread 2675373329]
[22:13:06 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:13:06 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:13:06 +08:00] [Thread 2675373329]
[22:16:12 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:16:12 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:16:12 +08:00] [Thread 2675373329]
[22:16:13 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:16:13 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:16:13 +08:00] [Thread 2675373329]
[22:16:13 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:16:13 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:16:13 +08:00] [Thread 2675373329]
[22:19:27 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:19:27 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:19:27 +08:00] [Thread 2675373329]
[22:19:35 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:19:35 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:19:35 +08:00] [Thread 2675373329]
[22:19:35 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:19:35 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:19:35 +08:00] [Thread 2675373329]
[22:20:26 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:20:26 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:20:26 +08:00] [Thread 2675373329]
[22:20:41 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:20:41 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:20:41 +08:00] [Thread 2675373329]
[22:20:41 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:20:41 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:20:41 +08:00] [Thread 2675373329]
[22:24:13 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:24:13 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:24:13 +08:00] [Thread 2675373329]
[22:24:31 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:24:31 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:24:31 +08:00] [Thread 2675373329]
[22:24:31 +08:00] [Thread 2675373329] extDB2: LOCK START
[22:24:31 +08:00] [Thread 2675373329] extDB2: LOCK STOP
[22:24:31 +08:00] [Thread 2675373329]
[22:24:50 +08:00] [Thread 4056765174] extDB2: SQL_CUSTOM: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error [mysql_stmt_error]: Cannot add or update a child row: a foreign key constraint fails (`a3wasteland`.`PlayerSave`, CONSTRAINT `fk_PlayerSave_PlayerInfo` FOREIGN KEY (`PlayerUID`) REFERENCES `PlayerInfo` (`UID`) ON DELETE NO ACTION ON UPDATE NO ACTION) [mysql_stmt_errno]: 1452 [mysql_stmt_sqlstate]: 23000 [statemnt]: INSERT INTO PlayerSave SET PlayerUID = ?, MapID = ?, CreationDate = NOW(), Damage=0,HitPoints='[["HitHead",0],["HitBody",0],["HitHands",0],["HitLegs",0]]',Money=1000,Uniform='"U_I_OfficerUniform"',Vest='"V_Rangemaster_belt"',Backpack='"B_AssaultPack_dgtl"',Goggles='""',Headgear='"H_Beret_blk"',PrimaryWeapon='""',SecondaryWeapon='""',HandgunWeapon='"hgun_Rook40_F"',PrimaryWeaponItems='["","","",""]',SecondaryWeaponItems='["","","",""]',HandgunItems='["","","",""]',AssignedItems='["ItemMap","ItemCompass","ItemWatch","ItemRadio"]',U

Re: Server restarts once certain missions start

« Reply #12 posted: Apr 13, 2015, 08:35 PM »
extDB2 log entry isn't about what is crashing your server.
All its complaining about is a failed SQL Statement.

If you change extdb-conf.ini
[Log]
Flush = true

That way if server crashes there is better chance of SQL Error being in the logfile.
Also v50 of extDB2 doesnt have the LOCK START/STOP Spam in the logfiles.

Also lastly use Revs branch for A3Wasteland + extDB2.

----------------

I would just nuke Armaserver + re-install if from scratch, or you could verify files via steamcmd.
Keep that database etc

Re: Server restarts once certain missions start

« Reply #13 posted: Apr 14, 2015, 05:09 PM »
Today the server still crashed for about 6 times. However, none of them was due to the missions. I guess it's the Linux binary. I saw crash reports from other Linux admins.