Possible database issues, not entirely sure.

[thedude4555 0]

Hi there, I am relatively new to this, so bare with with me please. I recently setup an Exile server. I installed several addons, Infistar, CUP Vehicles, Weapons and Units, as well as DMS, Occupation, Zupa's Capture Points, Extended base mod, Advanced Towing and Kuplion's status bar.  Ive been over this several times, diagnosing, tweaking, starting fresh from scratch. Nothing seems to have an effect. Ive even attempted wiping the database clean and starting fresh, with no improvement.  Essentially what happens is, I install all addons, the server works perfectly for a few restarts and then it slowly goes to hell, usually after around the 6th restart. I may be misdiagnosing this but, It appears anything database related, mainly Purchasing from traders and crafting, sometimes entering and exiting vehicles. It starts as just a few seconds of time to purchase/spawn vehicles, equipment or craft, escalating to usually around 5ish minutes before anything purchased will spawn. This even effects spawning things with Infistar. It gradually gets worse by server restart. I feel ive exhausted my search efforts to find a similar problem with a fix, to the point of spending more time researching the issue than actually setting up the server. I may also not be asking the right questions research wise. If someone could provide me with a fix or at least point me in the right direction so I can fix it myself I would greatly appreciate it. I'm happy to provide any additional info. Thanks for your time guys and gals. Also, sorry for the long winded explanation.

Edited May 29 by thedude4555

[Brenner 114]

anything in the rpt?

[thedude4555 0]

Nothing that I can see, but I'm also new to looking at these. If you don't mind having a look.

https://pastebin.com/vV5j9HgP

Edited May 29 by thedude4555

[Pattoh 44]

13 hours ago, thedude4555 said:

Nothing that I can see, but I'm also new to looking at these. If you don't mind having a look.

https://pastebin.com/vV5j9HgP

23:41:57 CallExtension 'extDB3' could not be found

You have overwrites of extDB3 in your mission file or exile_server\code folder when you should be running extDB2.

One or more of these overwrites will be the culprit.

ExileServer_system_database_connect
ExileServer_system_simulationMonitor_initialize
ExileServer_system_process_noobFilter 
ExileServer_world_initialize 
ExileServer_util_time_uptime
ExileServer_util_time_currentTime
ExileServer_util_time_addTime
ExileServer_system_trading_network_wasteDumpRequest 
ExileServer_system_trading_network_sellItemRequest 
ExileServer_system_trading_network_purchaseVehicleSkinRequest 
ExileServer_system_trading_network_purchaseVehicleRequest 
ExileServer_system_trading_network_purchaseItemRequest 
ExileServer_system_territory_network_territoryUpgradeRequest
ExileServer_system_territory_network_restoreFlagRequest 
ExileServer_system_territory_network_purchaseTerritory 
ExileServer_system_territory_network_payTerritoryProtectionMoneyRequest 
ExileServer_system_territory_network_payFlagRansomRequest
ExileServer_system_territory_network_flagStolenRequest 
ExileServer_system_territory_maintenance_recalculateDueDate
ExileServer_system_territory_database_insert
ExileServer_system_database_query_selectSingleField 
ExileServer_system_database_query_selectSingle 
ExileServer_system_database_query_selectFull 
ExileServer_system_database_query_insertSingle 
ExileServer_system_database_query_fireAndForget 
ExileServer_system_database_handleBig 
ExileServer_object_vehicle_database_load 
ExileServer_object_vehicle_createPersistentVehicle 
ExileServer_object_vehicle_createNonPersistentVehicle 
ExileServer_object_player_event_onMpKilled 
ExileServer_object_player_database_load
ExileServer_object_player_createBambi 
ExileServer_object_container_database_update 
ExileServer_object_container_database_load 
ExileServer_object_container_database_insert 
ExileServer_object_container_createContainer
ExileServer_object_construction_database_load
ExileServer_object_construction_database_insert 
ExileServer_object_vehicle_network_retrieveVehicleRequest 

Easy way to find it, would be to use Notepad ++ and use the "find in files" search in your mission folder and type in "extDB3" then it should show itself.

[thedude4555 0]

18 hours ago, Brenner said:

anything in the rpt?

Nothing that I can see, but I'm also new to looking at these. If you don't mind having a look.

https://pastebin.com/vV5j9HgP

[thedude4555 0]

2 hours ago, Pattoh said:

23:41:57 CallExtension 'extDB3' could not be found

You have overwrites of extDB3 in your mission file or exile_server\code folder when you should be running extDB2.

One or more of these overwrites will be the culprit.

ExileServer_system_database_connect
ExileServer_system_simulationMonitor_initialize
ExileServer_system_process_noobFilter 
ExileServer_world_initialize 
ExileServer_util_time_uptime
ExileServer_util_time_currentTime
ExileServer_util_time_addTime
ExileServer_system_trading_network_wasteDumpRequest 
ExileServer_system_trading_network_sellItemRequest 
ExileServer_system_trading_network_purchaseVehicleSkinRequest 
ExileServer_system_trading_network_purchaseVehicleRequest 
ExileServer_system_trading_network_purchaseItemRequest 
ExileServer_system_territory_network_territoryUpgradeRequest
ExileServer_system_territory_network_restoreFlagRequest 
ExileServer_system_territory_network_purchaseTerritory 
ExileServer_system_territory_network_payTerritoryProtectionMoneyRequest 
ExileServer_system_territory_network_payFlagRansomRequest
ExileServer_system_territory_network_flagStolenRequest 
ExileServer_system_territory_maintenance_recalculateDueDate
ExileServer_system_territory_database_insert
ExileServer_system_database_query_selectSingleField 
ExileServer_system_database_query_selectSingle 
ExileServer_system_database_query_selectFull 
ExileServer_system_database_query_insertSingle 
ExileServer_system_database_query_fireAndForget 
ExileServer_system_database_handleBig 
ExileServer_object_vehicle_database_load 
ExileServer_object_vehicle_createPersistentVehicle 
ExileServer_object_vehicle_createNonPersistentVehicle 
ExileServer_object_player_event_onMpKilled 
ExileServer_object_player_database_load
ExileServer_object_player_createBambi 
ExileServer_object_container_database_update 
ExileServer_object_container_database_load 
ExileServer_object_container_database_insert 
ExileServer_object_container_createContainer
ExileServer_object_construction_database_load
ExileServer_object_construction_database_insert 
ExileServer_object_vehicle_network_retrieveVehicleRequest 

Okay, so I searched every file in my server folder and mission folder for "extDB3" and came up with nothing. After that I decided to go wild and search all of my addons/mods, which yielded nothing until I came to my infistar files. I believe the RPT info you were referencing was just infistar doing a check for extDB3, failing to find it, then calling extDB2.

Spoiler

11:42:23 CallExtension 'extDB3' could not be found
11:42:23 "<infiSTAR.de> 0 - checking for EXILE_SERVER.."
11:42:23 "<infiSTAR.de> 0 - EXILE_SERVER has been found."
11:42:23 "<infiSTAR.de> 0 - checking for Cfg_infiSTAR_settings.."
11:42:23 "<infiSTAR.de> 0 - Cfg_infiSTAR_settings has been found."
11:42:23 CallExtension loaded: extDB2 (.\extDB2.dll)

After all the searching this was the only line of code in all of my files that referenced extDB3 at all. It was in the infistar fn_preInit.sqf file, and unfortunately I don't believe its the source of all my misfortune. It appears to just be infistar doing infistar things.

Spoiler

Line 186: FN_CALL_ExtDB = if (("extDB3" callExtension "9:VERSION") != "") then {{"extDB3" callExtension _this}} else {{"extDB2" callExtension _this}};

Unless you think otherwise? If so, how do you recommend I remedy? Any additional input you can give is greatly appreciated. Thank You.

[Pattoh 44]

I think you're right about the extDB3 issue, I just did a test on a extDB2 server and it came with the same thing. My bad. 

Show us your DB logs in your @ExileServer\extDB\logs folder, at the exact times the issues occur. 

[Pattoh 44]

Also another thing I noticed in your command line you have "-nolog" remove that; it's "-nologs" but you want to see errors always so don't use it.

[Brenner 114]

Spoiler

11:42:23 CallExtension 'extDB3' could not be found
11:42:23 "<infiSTAR.de> 0 - checking for EXILE_SERVER.."
11:42:23 "<infiSTAR.de> 0 - EXILE_SERVER has been found."
11:42:23 "<infiSTAR.de> 0 - checking for Cfg_infiSTAR_settings.."
11:42:23 "<infiSTAR.de> 0 - Cfg_infiSTAR_settings has been found."
11:42:23 CallExtension loaded: extDB2 (.\extDB2.dll)

This is just infistar looking for extdb3 (since it works both on extdb2 and extdb3) (arma.exe=extdb2, arma_x64=extdb3)

besides connection to db is fine, otherwise you wouldn't be able to start server and connect

Spoiler

23:41:59 "ExileServer - Installed extDB2 version: 70"
23:41:59 "ExileServer - Connected to database!"
23:41:59 "ExileServer - Database protocol initialized!"

this is what I found

Spoiler

Warning Message: Script x\addons\ZCP\functions\fn_createEdenConvertedCity.sqf not found

 

[thedude4555 0]

On 5/29/2019 at 11:22 PM, Pattoh said:

Also another thing I noticed in your command line you have "-nolog" remove that; it's "-nologs" but you want to see errors always so don't use it.

No worries about the extDB3/2 thing, I look at it as a learning experience. I'm trying to soak up all the knowledge I can and though it didn't solve the issue it did help me learn something. To be honest I'm not entirely sure where to change the "-nologs"? I've got my server through a hosting service, and normally for launch parameters I just set them in the server control panel, so i've never had a need to change them any where else. Assuming it is a launch parameter that is?

[thedude4555 0]

On 5/30/2019 at 3:16 AM, Brenner said:

  Reveal hidden contents

11:42:23 CallExtension 'extDB3' could not be found
11:42:23 "<infiSTAR.de> 0 - checking for EXILE_SERVER.."
11:42:23 "<infiSTAR.de> 0 - EXILE_SERVER has been found."
11:42:23 "<infiSTAR.de> 0 - checking for Cfg_infiSTAR_settings.."
11:42:23 "<infiSTAR.de> 0 - Cfg_infiSTAR_settings has been found."
11:42:23 CallExtension loaded: extDB2 (.\extDB2.dll)

This is just infistar looking for extdb3 (since it works both on extdb2 and extdb3) (arma.exe=extdb2, arma_x64=extdb3)

besides connection to db is fine, otherwise you wouldn't be able to start server and connect

  Hide contents

23:41:59 "ExileServer - Installed extDB2 version: 70"
23:41:59 "ExileServer - Connected to database!"
23:41:59 "ExileServer - Database protocol initialized!"

this is what I found

  Hide contents

Warning Message: Script x\addons\ZCP\functions\fn_createEdenConvertedCity.sqf not found

 

Well that seems to have fixed the issue. It was Zupa's Capture points messing with things. I just removed it for now until I could find a more permanent solution. The odd thing is it comes as a pre packaged PBO. Literally all one needs to do, unless you want to configure it, is drag and drop it into the server addons folder. I'm not sure why anything would be missing from it. I'm gonna run the server for a couple days to make sure it doesn't degenerate like it has been. I'll keep you guys posted. Thanks again.