Database issues?

[BetterDeadThanZed]

Running Epoch 1.0.4.1 with Napf. I spent time building a base before server restart. I had walls, a workbench, shed and an LAV. When the server restarted, I logged in and it was all gone. My character was the same as before the restart - all same gear. I logged out and checked the database and sure enough it's all still there in the database. Is there an issue where the database doesn't load everything correctly?

[Richie]

It seems to be yes, I've had players report random walls or floors fail to load, then next restart they come back.

There's a few other posts about it and most replies say use vanilla files, even them using vanilla files get told that.

[Mr.Pig]

I have recently had the same issue. Had reports that all objects (vehicles, building items, safes etc.) Were not visible in the game, but after a server restart the objects all came back. Seems like it had an issue loading the object_data table maybe??

[BetterDeadThanZed]

I restarted my server and everything showed up. I can't imagine that any of the scripts I'm running would prevent the objects_data table from loading, but that's indeed what seems to happen, since my character is in the right place with all the right gear.

[Richie]

Now all you have to do is get AWOL or another dev to notice this and get it added to the list of issues, hopefully they'll address and fix it next patch.

[Aristoi]

We've got the same issue, and have brought our server back to practically vanilla to try and figure out what is up.

 

The most recent time it happened it appears from the logs that it tried to load the hive twice:

 

HiveExt.log

2014-02-12 10:11:25 HiveExt: [Information] HiveExt
2014-02-12 10:11:25 Database: [Information] Connected to MySQL database 199.116.118.7:2353/epoch client ver: 5.5.28 server ver: 5.5.25a
2014-02-12 10:11:25 Database: [Information] Connected to MySQL database 199.116.118.7:2353/epoch client ver: 5.5.28 server ver: 5.5.25a
2014-02-12 10:11:25 HiveExt: [Information] Method: 302 Params: 11:
2014-02-12 10:11:26 HiveExt: [Information] Result: ["ObjectStreamStart",1337,"da3c092f7794111fc0830dec0bf6027b"]
2014-02-12 10:11:26 HiveExt: [Information] Method: 302 Params: 11:
...snip...
2014-02-12 10:11:26 HiveExt: [Information] Method: 302 Params: 11:
2014-02-12 10:11:26 HiveExt: [Information] Result: ["OBJ","4282","MMT_Civ","0",[27,[10683.5,7926.23,0.026]],[],[],0.0,0.0]
2014-02-12 10:12:10 HiveExt: [Information] Method: 302 Params: 11:
2014-02-12 10:12:10 HiveExt: [Information] Result: ["ERROR","Instance already initialized"]
2014-02-12 10:12:10 HiveExt: [Information] Method: 302 Params: 11:
2014-02-12 10:12:10 HiveExt: [Information] Result: ["ERROR","Instance already initialized"]
2014-02-12 10:12:10 HiveExt: [Information] Method: 302 Params: 11:
2014-02-12 10:12:10 HiveExt: [Information] Result: ["ERROR","Instance already initialized"]
2014-02-12 10:12:10 HiveExt: [Information] Method: 302 Params: 11:
2014-02-12 10:12:10 HiveExt: [Information] Result: ["ERROR","Instance already initialized"]
2014-02-12 10:12:10 HiveExt: [Information] Method: 302 Params: 11:
2014-02-12 10:12:10 HiveExt: [Information] Result: ["ERROR","Instance already initialized"]
2014-02-12 10:12:10 HiveExt: [Information] Method: 399 Params: 478:
2014-02-12 10:12:11 HiveExt: [Information] Result: ["ObjectStreamStart",5]

There was also an apparent duplication in the log itself for Epoch loading:

 

ARMA2OASERVER.RPT

2014/02/12, 10:10:10 "DayZ Epoch: PRELOAD Functions\init [[<No group>:0 (FunctionsManager)],any]"
2014/02/12, 10:10:10 "DayZ Epoch: MPframework inited"

2014/02/12, 10:11:25 "HIVE: Starting"
2014/02/12, 10:11:25 "HIVE: trying to get objects"
2014/02/12, 10:11:26 "HIVE: found 1337 objects"
2014/02/12, 10:11:26 "HIVE: Commence Object Streaming..."
2014/02/12, 10:11:26 "HIVE: got 472 Epoch Objects and 865 Vehicles"

2014/02/12, 10:12:08 "DayZ Epoch: PRELOAD Functions\init [[<No group>:0 (FunctionsManager)],any]"
2014/02/12, 10:12:08 "DayZ Epoch: MPframework inited"

2014/02/12, 10:12:10 "HIVE: Starting"
2014/02/12, 10:12:10 "HIVE: trying to get objects"
2014/02/12, 10:12:10 "HIVE: connection problem... HiveExt response:["ERROR","Instance already initialized"]"
2014/02/12, 10:12:10 "HIVE: trying to get objects"
2014/02/12, 10:12:10 "HIVE: connection problem... HiveExt response:["ERROR","Instance already initialized"]"
2014/02/12, 10:12:10 "HIVE: trying to get objects"
2014/02/12, 10:12:10 "HIVE: connection problem... HiveExt response:["ERROR","Instance already initialized"]"
2014/02/12, 10:12:10 "HIVE: trying to get objects"
2014/02/12, 10:12:10 "HIVE: connection problem... HiveExt response:["ERROR","Instance already initialized"]"
2014/02/12, 10:12:10 "HIVE: trying to get objects"
2014/02/12, 10:12:10 "HIVE: connection problem... HiveExt response:["ERROR","Instance already initialized"]"
2014/02/12, 10:12:11 "HIVE: Spawning # of Vehicles: 300"

[bsmaff]

I have been getting the same issues with or without Vanilla files.

 

I originally thought it was a script I was running but tried for a day on a test server with Vanilla files and was getting exactly the same issues.

It seems nothing from the object_data table is being loaded on server restarts, but it is clearly a bug and not something that is server specific.

[BetterDeadThanZed]

All of my hive logs show that double database connection. I wonder if that's normal? In any case, please! DEVS! Check this out!

 

Submitted an issue on GitHub for this: https://github.com/vbawol/DayZ-Epoch/issues/1116

[Aristoi]

All of my hive logs show that double database connection. I wonder if that's normal? In any case, please! DEVS! Check this out!

 

It's defiantly not normal in my logs.  Most of the time, things work right on the server, and there is no doubling up of hive connections in the log.

[BetterDeadThanZed]

It's defiantly not normal in my logs.  Most of the time, things work right on the server, and there is no doubling up of hive connections in the log.

 

Just to be sure we're talking about the same thing, in my hiveext.log, I see this:

 

2014-02-12 09:07:34 Database: [Information] Connected to MySQL database 199.116.118.205:2503/epoch client ver: 5.5.28 server ver: 5.5.25a
2014-02-12 09:07:34 Database: [Information] Connected to MySQL database 199.116.118.205:2503/epoch client ver: 5.5.28 server ver: 5.5.25a

[Aristoi]

As a followup, what host is everyone using?  We're using Vilayer.

[Richie]

As a followup, what host is everyone using?  We're using Vilayer.

Dedicated server with Online.net

[BetterDeadThanZed]

As a followup, what host is everyone using?  We're using Vilayer.

 

Also on Vilayer, with their community package 64. Servers were installed after 1.0.4.1 was released. When they were installed, they were on 1.0.4b and I had to update them to 1.0.4.1.

 

I had an older server with Vilayer that had been on 1.0.3.1 and when I tried updating it, the hive log indicated it couldn't even connect to the database. I had already purchased the community 32 package so I could run a Napf server anyway and my old server was coming due in a few days, so I upgraded to the community 64 package and cancelled my old server.

 

If this is a Vilayer issue, I'd really hope the devs could contact them because they were non-responsive to my ticket regarding my old server and the update to 1.0.4.1 from 1.0.3.1. I closed that ticket without a response from them. I have another unrelated ticket that I've been waiting 24 hours on.

[Aristoi]

 

Just to be sure we're talking about the same thing, in my hiveext.log, I see this:

2014-02-12 09:07:34 Database: [Information] Connected to MySQL database 199.116.118.205:2503/epoch client ver: 5.5.28 server ver: 5.5.25a
2014-02-12 09:07:34 Database: [Information] Connected to MySQL database 199.116.118.205:2503/epoch client ver: 5.5.28 server ver: 5.5.25a

 

I do see that in all logs I have looked at since 1.0.4.1, but I do not see the actual double loading with resultant errors in them normally (only occasionally, maybe 1 out of 3?).

[Richie]

I'm not with Vilayer and it happens to me, odd thing is it doesn't happen all the time or if it does then players don't know it's happened without checking.

[vbawol]

Looking into it need more information as we have yet to reproduce this on our server.

 

Are you running a default server pbo? and what does your init.sqf look like?

[Aristoi]

Thanks vbawol! 

 

We have Infistar and some custom buildings running.  Otherwise should be vanilla Epoch.  I've attached our init.sqf for reference.

init.sqf.txt

[BetterDeadThanZed]

Looking into it need more information as we have yet to reproduce this on our server.

 

Are you running a default server pbo? and what does your init.sqf look like?

 

I am not running a default server pbo, but others that have reported this are. I have only had this happen once so far. My init.sqf: https://www.dropbox.com/s/0nk87lqv7p7fph4/init.sqf

[icomrade]

Try logging how many times server_monitor is run using the below code. Post your .rpt if you get more than one line saying "server_monitor.sqf execution count = ". the count should only ever = 1 and never more.

 

Put this code at the line below waituntil{isNil "sm_done"}

 

if (isNil "server_initCount") then {
server_initCount = 1;
} else {
server_initCount = server_initCount + 1;
};
diag_log format["server_monitor.sqf execution count = %1", server_initCount];

[Sukkaed]

I'm also getting these on both servers every restart. I don't think that it's causing any issues.

Database: [Information] Connected to MySQL database localhost:3306/dayz_epoch_napf client ver: 5.5.28 server ver: 5.6.14
Database: [Information] Connected to MySQL database localhost:3306/dayz_epoch_napf client ver: 5.5.28 server ver: 5.6.14

Database: [Information] Connected to MySQL database localhost:3306/dayz_epoch client ver: 5.5.28 server ver: 5.6.14
Database: [Information] Connected to MySQL database localhost:3306/dayz_epoch client ver: 5.5.28 server ver: 5.6.14

[Aristoi]

Try logging how many times server_monitor is run using the below code. Post your .rpt if you get more than one line saying "server_monitor.sqf execution count = ". the count should only ever = 1 and never more.

 

Put this code at the line below waituntil{isNil "sm_done"}

 

I've added this code, I'll let you know how it goes.

[vbawol]

This is the 1.0.4.2 server pbo with logging for this issue enabled: https://github.com/vbawol/DayZ-Epoch/raw/master/Server%20Files/%40DayZ_Epoch_Server/addons/dayz_server.pbo

server log should show:

server_monitor.sqf execution count = #

please report your findings here.

[Proofer]

hive.ini

Add

[Objects]
Table = Object_DATA

[Richie]

This is the 1.0.4.2 server pbo with logging for this issue enabled: https://github.com/vbawol/DayZ-Epoch/raw/master/Server%20Files/%40DayZ_Epoch_Server/addons/dayz_server.pbo

server log should show:

server_monitor.sqf execution count = #

please report your findings here.

Where do i add this to the normal server files ? I've already done my custom changes, don't really fancy redoing them.

[Aristoi]

I'm not sure if it is related, though I suspect it is at least possible, but one of the side effects seems to be tons of vehicles past the limit set.

 

Ours is 300 and the most recent load:

2014/02/13, 10:04:01 "HIVE: got 494 Epoch Objects and 1054 Vehicles"
2014/02/13, 10:05:01 "HIVE: Vehicle Spawn limit reached!"

A little more detail on this one.  On one of the hive duplicate loads, it did this:

2014/02/12, 10:11:25 "HIVE: Starting"
2014/02/12, 10:11:25 "HIVE: trying to get objects"
2014/02/12, 10:11:26 "HIVE: found 1337 objects"
2014/02/12, 10:11:26 "HIVE: Commence Object Streaming..."
2014/02/12, 10:11:26 "HIVE: got 472 Epoch Objects and 865 Vehicles"

2014/02/12, 10:12:10 "HIVE: Starting"
2014/02/12, 10:12:10 "HIVE: trying to get objects"
2014/02/12, 10:12:10 "HIVE: connection problem... HiveExt response:["ERROR","Instance already initialized"]"
2014/02/12, 10:12:11 "HIVE: Spawning # of Vehicles: 300"
2014/02/12, 10:12:11 "HIVE: Spawning # of Debris: 200"
2014/02/12, 10:12:11 "HIVE: Spawning # of Ammo Boxes: 3"
2014/02/12, 10:12:11 "HIVE: Spawning # of Veins: 50"

I think that extra 300 vehicles took us to that most recent log message with over 1,000.

[icomrade]

Where do i add this to the normal server files ? I've already done my custom changes, don't really fancy redoing them.

 

The only changes to that pbo are the changes outlined in my post (just packed and put into the server.pbo).

 

 

 

Try logging how many times server_monitor is run using the below code. Post your .rpt if you get more than one line saying "server_monitor.sqf execution count = ". the count should only ever = 1 and never more.

 

Put this code at the line below waituntil{isNil "sm_done"}

 

if (isNil "server_initCount") then {

server_initCount = 1;

} else {

server_initCount = server_initCount + 1;

};

diag_log format["server_monitor.sqf execution count = %1", server_initCount];