Jump to content
  • 0

Database issues?


BetterDeadThanZed

Question

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?

Link to comment
Share on other sites

Recommended Posts

  • 0

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"
Link to comment
Share on other sites

  • 0

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.

Link to comment
Share on other sites

  • 0

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.

Link to comment
Share on other sites

  • 0

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
Link to comment
Share on other sites

  • 0

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.

Link to comment
Share on other sites

  • 0

 

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?).

Link to comment
Share on other sites

  • 0

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

Link to comment
Share on other sites

  • 0
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];
Link to comment
Share on other sites

  • 0

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
Link to comment
Share on other sites

  • 0
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.

Link to comment
Share on other sites

  • 0

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.

Link to comment
Share on other sites

  • 0

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.

Link to comment
Share on other sites

  • 0

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];

 

Link to comment
Share on other sites

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
  • Advertisement
×
×
  • Create New...