Trying to Fix your LiF Server

Trying to Fix your LiF Server

Post Number:#1  Postby bigsteve » 20 Mar 2015, 07:31

Hi bigsteve here..

All u LiFYO plays may have noticed that your server sometimes will go offline and then come back up with a password.

Well, its all my fault, i am trying to find out why your claims are not expanding,

I think i may have found out why this is not happening - this is only a guess from the server logs i have looked at.
During the Object Decay Cycle - a procedure is called to delete some object in game. i have no idea what these objects are as no ID is ever displayed, Last night this procedure was called in 2 successive day cycles
first one
ECHO 2015-03-19 04:46:45.980 {00} <NOSCOPE> OBJ_DECAY: start
ECHO 2015-03-19 04:46:45.980 {00} <NOSCOPE> OBJ_DECAY: collectData start (ObjectDecayRate=0.000)
ECHO 2015-03-19 04:46:45.981 {00} <NOSCOPE> OBJ_DECAY: collectData end in 0.000 sec (6 for delete, 2 for change, 0 for calc)
ECHO 2015-03-19 04:46:45.986 {00} <NOSCOPE> _disableAccessToObjectInventory(mov, 12919)
ECHO 2015-03-19 04:46:45.987 {00} <NOSCOPE> _disableAccessToObjectInventory(mov, 12921)
ECHO 2015-03-19 04:46:45.987 {00} <NOSCOPE> _disableAccessToObjectInventory(mov, 12930)
ECHO 2015-03-19 04:46:45.987 {00} <NOSCOPE> _disableAccessToObjectInventory(mov, 12931)
ECHO 2015-03-19 04:46:45.988 {00} <NOSCOPE> _disableAccessToObjectInventory(mov, 12934)
ECHO 2015-03-19 04:46:45.988 {00} <NOSCOPE> _disableAccessToObjectInventory(mov, 12937)
ECHO 2015-03-19 04:46:45.988 {00} <NOSCOPE> OBJ_DECAY: 8 changes made in 0.002 sec
ECHO 2015-03-19 04:46:45.989 {00} <NOSCOPE> OBJ_DECAY: finished
ECHO 2015-03-19 04:46:45.989 {00} <NOSCOPE> # DB_TRAN_ADD: CALL p_deleteMovableObject(12919); [T:DBIPrimary:0x4AE4]
ECHO 2015-03-19 04:46:45.989 {00} <NOSCOPE> # DB_TRAN_ADD: CALL p_addObjectPatch(14656,450,2,1,12919,118048015,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/); [T:DBIPrimary:0x4AE4]
HACK 2015-03-19 04:46:45.990 {00} <NOSCOPE> # DB_TRANS start [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:45.990 {00} <NOSCOPE> # DB::noRS(0 ms) START TRANSACTION; [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.022 {00} <NOSCOPE> # DB::noRS(34 ms) CALL p_deleteMovableObject(12919); [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.072 {00} <NOSCOPE> # DB::noRS(50 ms) CALL p_addObjectPatch(14656,450,2,1,12919,118048015,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/); [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.072 {00} <NOSCOPE> # DB::noRS(0 ms) COMMIT; [T:DBIPrimary:0x4AE4]
HACK 2015-03-19 04:46:46.073 {00} <NOSCOPE> # DB_TRANS commit(84 ms) [T:DBIPrimary:0x4AE4]
ECHO 2015-03-19 04:46:46.074 {00} <NOSCOPE> # DB_TRAN_ADD: CALL p_deleteMovableObject(12921); [T:DBIPrimary:0x4AE4]
ECHO 2015-03-19 04:46:46.074 {00} <NOSCOPE> # DB_TRAN_ADD: CALL p_addObjectPatch(14657,450,2,1,12921,118048526,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/); [T:DBIPrimary:0x4AE4]
HACK 2015-03-19 04:46:46.074 {00} <NOSCOPE> # DB_TRANS start [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.075 {00} <NOSCOPE> # DB::noRS(0 ms) START TRANSACTION; [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.163 {00} <NOSCOPE> # DB::noRS(92 ms) CALL p_deleteMovableObject(12921); [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.213 {00} <NOSCOPE> # DB::noRS(50 ms) CALL p_addObjectPatch(14657,450,2,1,12921,118048526,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/); [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.213 {00} <NOSCOPE> # DB::noRS(0 ms) COMMIT; [T:DBIPrimary:0x4AE4]
HACK 2015-03-19 04:46:46.214 {00} <NOSCOPE> # DB_TRANS commit(142 ms) [T:DBIPrimary:0x4AE4]
ECHO 2015-03-19 04:46:46.215 {00} <NOSCOPE> # DB_TRAN_ADD: CALL p_deleteMovableObject(12930); [T:DBIPrimary:0x4AE4]
ECHO 2015-03-19 04:46:46.215 {00} <NOSCOPE> # DB_TRAN_ADD: CALL p_addObjectPatch(14658,450,2,1,12930,118070023,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/); [T:DBIPrimary:0x4AE4]
HACK 2015-03-19 04:46:46.215 {00} <NOSCOPE> # DB_TRANS start [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.216 {00} <NOSCOPE> # DB::noRS(0 ms) START TRANSACTION; [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.247 {00} <NOSCOPE> # DB::noRS(33 ms) CALL p_deleteMovableObject(12930); [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.299 {00} <NOSCOPE> # DB::noRS(50 ms) CALL p_addObjectPatch(14658,450,2,1,12930,118070023,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/); [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.299 {00} <NOSCOPE> # DB::noRS(0 ms) COMMIT; [T:DBIPrimary:0x4AE4]
HACK 2015-03-19 04:46:46.300 {00} <NOSCOPE> # DB_TRANS commit(83 ms) [T:DBIPrimary:0x4AE4]
ECHO 2015-03-19 04:46:46.301 {00} <NOSCOPE> # DB_TRAN_ADD: CALL p_deleteMovableObject(12931); [T:DBIPrimary:0x4AE4]
ECHO 2015-03-19 04:46:46.301 {00} <NOSCOPE> # DB_TRAN_ADD: CALL p_addObjectPatch(14659,450,2,1,12931,118069512,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/); [T:DBIPrimary:0x4AE4]
HACK 2015-03-19 04:46:46.302 {00} <NOSCOPE> # DB_TRANS start [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.302 {00} <NOSCOPE> # DB::noRS(0 ms) START TRANSACTION; [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.372 {00} <NOSCOPE> # DB::noRS(75 ms) CALL p_deleteMovableObject(12931); [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.422 {00} <NOSCOPE> # DB::noRS(50 ms) CALL p_addObjectPatch(14659,450,2,1,12931,118069512,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/); [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.422 {00} <NOSCOPE> # DB::noRS(0 ms) COMMIT; [T:DBIPrimary:0x4AE4]
HACK 2015-03-19 04:46:46.423 {00} <NOSCOPE> # DB_TRANS commit(125 ms) [T:DBIPrimary:0x4AE4]
ECHO 2015-03-19 04:46:46.424 {00} <NOSCOPE> # DB_TRAN_ADD: CALL p_deleteMovableObject(12934); [T:DBIPrimary:0x4AE4]
ECHO 2015-03-19 04:46:46.424 {00} <NOSCOPE> # DB_TRAN_ADD: CALL p_addObjectPatch(14660,450,2,1,12934,118076696,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/); [T:DBIPrimary:0x4AE4]
HACK 2015-03-19 04:46:46.424 {00} <NOSCOPE> # DB_TRANS start [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.425 {00} <NOSCOPE> # DB::noRS(0 ms) START TRANSACTION; [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.455 {00} <NOSCOPE> # DB::noRS(33 ms) CALL p_deleteMovableObject(12934); [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.554 {00} <NOSCOPE> # DB::noRS(100 ms) CALL p_addObjectPatch(14660,450,2,1,12934,118076696,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/); [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.555 {00} <NOSCOPE> # DB::noRS(1 ms) COMMIT; [T:DBIPrimary:0x4AE4]
HACK 2015-03-19 04:46:46.556 {00} <NOSCOPE> # DB_TRANS commit(134 ms) [T:DBIPrimary:0x4AE4]
ECHO 2015-03-19 04:46:46.557 {00} <NOSCOPE> # DB_TRAN_ADD: CALL p_deleteMovableObject(12937); [T:DBIPrimary:0x4AE4]
ECHO 2015-03-19 04:46:46.557 {00} <NOSCOPE> # DB_TRAN_ADD: CALL p_addObjectPatch(14661,450,2,1,12937,118077210,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/); [T:DBIPrimary:0x4AE4]
HACK 2015-03-19 04:46:46.558 {00} <NOSCOPE> # DB_TRANS start [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.558 {00} <NOSCOPE> # DB::noRS(0 ms) START TRANSACTION; [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.588 {00} <NOSCOPE> # DB::noRS(33 ms) CALL p_deleteMovableObject(12937); [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.638 {00} <NOSCOPE> # DB::noRS(50 ms) CALL p_addObjectPatch(14661,450,2,1,12937,118077210,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/); [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.638 {00} <NOSCOPE> # DB::noRS(0 ms) COMMIT; [T:DBIPrimary:0x4AE4]
HACK 2015-03-19 04:46:46.639 {00} <NOSCOPE> # DB_TRANS commit(83 ms) [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.663 {00} <NOSCOPE> # DB::noRS(25 ms) UPDATE `movable_objects` SET `Durability`=50 WHERE `ID`=12942; [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 04:46:46.688 {00} <NOSCOPE> # DB::noRS(25 ms) UPDATE `movable_objects` SET `Durability`=50 WHERE `ID`=12945; [T:DBIPrimary:0x4AE4]

ECHO 2015-03-19 05:16:48.437 {00} <NOSCOPE> OBJ_DECAY: start
ECHO 2015-03-19 05:16:48.437 {00} <NOSCOPE> OBJ_DECAY: collectData start (ObjectDecayRate=0.000)
ECHO 2015-03-19 05:16:48.438 {00} <NOSCOPE> OBJ_DECAY: collectData end in 0.000 sec (2 for delete, 0 for change, 0 for calc)
ECHO 2015-03-19 05:16:48.443 {00} <NOSCOPE> _disableAccessToObjectInventory(mov, 12942)
ECHO 2015-03-19 05:16:48.443 {00} <NOSCOPE> _disableAccessToObjectInventory(mov, 12945)
ECHO 2015-03-19 05:16:48.444 {00} <NOSCOPE> OBJ_DECAY: 2 changes made in 0.001 sec
ECHO 2015-03-19 05:16:48.445 {00} <NOSCOPE> OBJ_DECAY: finished
ECHO 2015-03-19 05:16:48.445 {00} <NOSCOPE> # DB_TRAN_ADD: CALL p_deleteMovableObject(12942); [T:DBIPrimary:0x4AE4]
ECHO 2015-03-19 05:16:48.446 {00} <NOSCOPE> # DB_TRAN_ADD: CALL p_addObjectPatch(14662,450,2,1,12942,118049158,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/); [T:DBIPrimary:0x4AE4]
HACK 2015-03-19 05:16:48.446 {00} <NOSCOPE> # DB_TRANS start [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 05:16:48.446 {00} <NOSCOPE> # DB::noRS(0 ms) START TRANSACTION; [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 05:16:48.478 {00} <NOSCOPE> # DB::noRS(33 ms) CALL p_deleteMovableObject(12942); [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 05:16:48.612 {00} <NOSCOPE> # DB::noRS(133 ms) CALL p_addObjectPatch(14662,450,2,1,12942,118049158,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/); [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 05:16:48.613 {00} <NOSCOPE> # DB::noRS(1 ms) COMMIT; [T:DBIPrimary:0x4AE4]
HACK 2015-03-19 05:16:48.613 {00} <NOSCOPE> # DB_TRANS commit(167 ms) [T:DBIPrimary:0x4AE4]
ECHO 2015-03-19 05:16:48.614 {00} <NOSCOPE> # DB_TRAN_ADD: CALL p_deleteMovableObject(12945); [T:DBIPrimary:0x4AE4]
ECHO 2015-03-19 05:16:48.614 {00} <NOSCOPE> # DB_TRAN_ADD: CALL p_addObjectPatch(4061,447,2,1,12945,117279467,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/); [T:DBIPrimary:0x4AE4]
HACK 2015-03-19 05:16:48.615 {00} <NOSCOPE> # DB_TRANS start [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 05:16:48.615 {00} <NOSCOPE> # DB::noRS(0 ms) START TRANSACTION; [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 05:16:48.645 {00} <NOSCOPE> # DB::noRS(33 ms) CALL p_deleteMovableObject(12945); [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 05:16:48.695 {00} <NOSCOPE> # DB::noRS(50 ms) CALL p_addObjectPatch(4061,447,2,1,12945,117279467,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/,NULL/*0*/); [T:DBIPrimary:0x4AE4]
WARN 2015-03-19 05:16:48.695 {00} <NOSCOPE> # DB::noRS(0 ms) COMMIT; [T:DBIPrimary:0x4AE4]
HACK 2015-03-19 05:16:48.696 {00} <NOSCOPE> # DB_TRANS commit(83 ms) [T:DBIPrimary:0x4AE4]

Now when the decay cycles have deleted these objects the Claims Maintenance Cycles kicks in on the next cycle and works fine.
ECHO 2015-03-19 05:46:47.444 {00} <NOSCOPE> OBJ_DECAY: start
ECHO 2015-03-19 05:46:47.444 {00} <NOSCOPE> OBJ_DECAY: collectData start (ObjectDecayRate=0.000)
ECHO 2015-03-19 05:46:47.445 {00} <NOSCOPE> OBJ_DECAY: collectData end in 0.000 sec (0 for delete, 0 for change, 0 for calc)
ECHO 2015-03-19 05:46:47.445 {00} <NOSCOPE> CLAIMS_MAINTENANCE: started
HACK 2015-03-19 05:46:47.445 {00} <NOSCOPE> =====================================> createdDurability=3000 durability=2000
WARN 2015-03-19 05:46:47.475 {00} <NOSCOPE> DB::noRS(30 ms) UPDATE `claims` SET SupportPoints=154468 WHERE ID=61;
HACK 2015-03-19 05:46:47.476 {00} <NOSCOPE> =====================================> supportPoints=154468
HACK 2015-03-19 05:46:47.476 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=2150
HACK 2015-03-19 05:46:47.477 {00} <NOSCOPE> =====================================> baseClaimRadius=30 newRadius=21
WARN 2015-03-19 05:46:47.584 {00} <NOSCOPE> DB::noRS(106 ms) UPDATE `guild_lands` SET Radius=21 WHERE ID=61;
HACK 2015-03-19 05:46:47.584 {00} <NOSCOPE> =====================================> createdDurability=3000 durability=2000
WARN 2015-03-19 05:46:47.617 {00} <NOSCOPE> DB::noRS(32 ms) UPDATE `claims` SET SupportPoints=59825 WHERE ID=69;
HACK 2015-03-19 05:46:47.618 {00} <NOSCOPE> =====================================> supportPoints=59825
HACK 2015-03-19 05:46:47.618 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=2150
HACK 2015-03-19 05:46:47.618 {00} <NOSCOPE> =====================================> baseClaimRadius=30 newRadius=21
WARN 2015-03-19 05:46:47.675 {00} <NOSCOPE> DB::noRS(57 ms) UPDATE `guild_lands` SET Radius=21 WHERE ID=69;
HACK 2015-03-19 05:46:47.676 {00} <NOSCOPE> =====================================> createdDurability=2000 durability=2000
WARN 2015-03-19 05:46:47.709 {00} <NOSCOPE> DB::noRS(32 ms) UPDATE `claims` SET SupportPoints=263 WHERE ID=63;
HACK 2015-03-19 05:46:47.709 {00} <NOSCOPE> =====================================> supportPoints=263
HACK 2015-03-19 05:46:47.710 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=1900
HACK 2015-03-19 05:46:47.710 {00} <NOSCOPE> =====================================> baseClaimRadius=20 newRadius=19
WARN 2015-03-19 05:46:47.834 {00} <NOSCOPE> DB::noRS(123 ms) UPDATE `guild_lands` SET Radius=19 WHERE ID=63;
HACK 2015-03-19 05:46:47.834 {00} <NOSCOPE> =====================================> createdDurability=2000 durability=2000
WARN 2015-03-19 05:46:47.867 {00} <NOSCOPE> DB::noRS(32 ms) UPDATE `claims` SET SupportPoints=24855 WHERE ID=64;
HACK 2015-03-19 05:46:47.868 {00} <NOSCOPE> =====================================> supportPoints=24855
HACK 2015-03-19 05:46:47.868 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=2100
HACK 2015-03-19 05:46:47.868 {00} <NOSCOPE> =====================================> baseClaimRadius=20 newRadius=21
WARN 2015-03-19 05:46:47.925 {00} <NOSCOPE> DB::noRS(57 ms) UPDATE `guild_lands` SET Radius=21 WHERE ID=64;
HACK 2015-03-19 05:46:47.926 {00} <NOSCOPE> =====================================> createdDurability=3000 durability=2000
WARN 2015-03-19 05:46:47.959 {00} <NOSCOPE> DB::noRS(32 ms) UPDATE `claims` SET SupportPoints=93014 WHERE ID=66;
HACK 2015-03-19 05:46:47.959 {00} <NOSCOPE> =====================================> supportPoints=93014
HACK 2015-03-19 05:46:47.960 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=2150
HACK 2015-03-19 05:46:47.960 {00} <NOSCOPE> =====================================> baseClaimRadius=30 newRadius=21
WARN 2015-03-19 05:46:48.059 {00} <NOSCOPE> DB::noRS(98 ms) UPDATE `guild_lands` SET Radius=21 WHERE ID=66;
HACK 2015-03-19 05:46:48.059 {00} <NOSCOPE> =====================================> createdDurability=3000 durability=2000
WARN 2015-03-19 05:46:48.092 {00} <NOSCOPE> DB::noRS(32 ms) UPDATE `claims` SET SupportPoints=272849 WHERE ID=67;
HACK 2015-03-19 05:46:48.093 {00} <NOSCOPE> =====================================> supportPoints=272849
HACK 2015-03-19 05:46:48.093 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=2150
HACK 2015-03-19 05:46:48.093 {00} <NOSCOPE> =====================================> baseClaimRadius=30 newRadius=21
WARN 2015-03-19 05:46:48.150 {00} <NOSCOPE> DB::noRS(57 ms) UPDATE `guild_lands` SET Radius=21 WHERE ID=67;
HACK 2015-03-19 05:46:48.151 {00} <NOSCOPE> =====================================> createdDurability=2000 durability=2000
WARN 2015-03-19 05:46:48.184 {00} <NOSCOPE> DB::noRS(32 ms) UPDATE `claims` SET SupportPoints=61582 WHERE ID=68;
HACK 2015-03-19 05:46:48.184 {00} <NOSCOPE> =====================================> supportPoints=61582
HACK 2015-03-19 05:46:48.185 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=2100
HACK 2015-03-19 05:46:48.185 {00} <NOSCOPE> =====================================> baseClaimRadius=20 newRadius=21
WARN 2015-03-19 05:46:48.294 {00} <NOSCOPE> DB::noRS(109 ms) UPDATE `guild_lands` SET Radius=21 WHERE ID=68;
HACK 2015-03-19 05:46:48.295 {00} <NOSCOPE> =====================================> createdDurability=10000 durability=2000
WARN 2015-03-19 05:46:48.317 {00} <NOSCOPE> DB::noRS(21 ms) UPDATE `claims` SET SupportPoints=447754 WHERE ID=70;
HACK 2015-03-19 05:46:48.318 {00} <NOSCOPE> =====================================> supportPoints=447754
HACK 2015-03-19 05:46:48.318 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=2500
HACK 2015-03-19 05:46:48.319 {00} <NOSCOPE> =====================================> baseClaimRadius=100 newRadius=25
WARN 2015-03-19 05:46:48.375 {00} <NOSCOPE> DB::noRS(57 ms) UPDATE `guild_lands` SET Radius=25 WHERE ID=70;
HACK 2015-03-19 05:46:48.376 {00} <NOSCOPE> =====================================> createdDurability=10000 durability=2000
WARN 2015-03-19 05:46:48.450 {00} <NOSCOPE> DB::noRS(74 ms) UPDATE `claims` SET SupportPoints=298759 WHERE ID=73;
HACK 2015-03-19 05:46:48.451 {00} <NOSCOPE> =====================================> supportPoints=298759
HACK 2015-03-19 05:46:48.451 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=2500
HACK 2015-03-19 05:46:48.451 {00} <NOSCOPE> =====================================> baseClaimRadius=100 newRadius=25
WARN 2015-03-19 05:46:48.530 {00} <NOSCOPE> DB::noRS(78 ms) UPDATE `guild_lands` SET Radius=25 WHERE ID=73;
HACK 2015-03-19 05:46:48.530 {00} <NOSCOPE> =====================================> createdDurability=2000 durability=2000
WARN 2015-03-19 05:46:48.559 {00} <NOSCOPE> DB::noRS(28 ms) UPDATE `claims` SET SupportPoints=181 WHERE ID=74;
HACK 2015-03-19 05:46:48.559 {00} <NOSCOPE> =====================================> supportPoints=181
HACK 2015-03-19 05:46:48.559 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=1900
HACK 2015-03-19 05:46:48.560 {00} <NOSCOPE> =====================================> baseClaimRadius=20 newRadius=19
WARN 2015-03-19 05:46:48.658 {00} <NOSCOPE> DB::noRS(99 ms) UPDATE `guild_lands` SET Radius=19 WHERE ID=74;
HACK 2015-03-19 05:46:48.659 {00} <NOSCOPE> =====================================> createdDurability=2000 durability=2000
WARN 2015-03-19 05:46:48.692 {00} <NOSCOPE> DB::noRS(32 ms) UPDATE `claims` SET SupportPoints=23282 WHERE ID=75;
HACK 2015-03-19 05:46:48.692 {00} <NOSCOPE> =====================================> supportPoints=23282
HACK 2015-03-19 05:46:48.693 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=2100
HACK 2015-03-19 05:46:48.693 {00} <NOSCOPE> =====================================> baseClaimRadius=20 newRadius=21
WARN 2015-03-19 05:46:48.750 {00} <NOSCOPE> DB::noRS(57 ms) UPDATE `guild_lands` SET Radius=21 WHERE ID=75;
HACK 2015-03-19 05:46:48.751 {00} <NOSCOPE> =====================================> createdDurability=2000 durability=2000
WARN 2015-03-19 05:46:48.842 {00} <NOSCOPE> DB::noRS(90 ms) UPDATE `claims` SET SupportPoints=-317 WHERE ID=76;
HACK 2015-03-19 05:46:48.842 {00} <NOSCOPE> =====================================> supportPoints=-317
HACK 2015-03-19 05:46:48.843 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=1900
HACK 2015-03-19 05:46:48.843 {00} <NOSCOPE> =====================================> baseClaimRadius=20 newRadius=19
WARN 2015-03-19 05:46:48.900 {00} <NOSCOPE> DB::noRS(57 ms) UPDATE `guild_lands` SET Radius=19 WHERE ID=76;
HACK 2015-03-19 05:46:48.901 {00} <NOSCOPE> =====================================> createdDurability=2000 durability=2000
WARN 2015-03-19 05:46:48.933 {00} <NOSCOPE> DB::noRS(32 ms) UPDATE `claims` SET SupportPoints=-317 WHERE ID=77;
HACK 2015-03-19 05:46:48.934 {00} <NOSCOPE> =====================================> supportPoints=-317
HACK 2015-03-19 05:46:48.935 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=1900
HACK 2015-03-19 05:46:48.935 {00} <NOSCOPE> =====================================> baseClaimRadius=20 newRadius=19
WARN 2015-03-19 05:46:49.042 {00} <NOSCOPE> DB::noRS(106 ms) UPDATE `guild_lands` SET Radius=19 WHERE ID=77;
HACK 2015-03-19 05:46:49.043 {00} <NOSCOPE> =====================================> createdDurability=3000 durability=2000
WARN 2015-03-19 05:46:49.075 {00} <NOSCOPE> DB::noRS(32 ms) UPDATE `claims` SET SupportPoints=119765 WHERE ID=79;
HACK 2015-03-19 05:46:49.076 {00} <NOSCOPE> =====================================> supportPoints=119765
HACK 2015-03-19 05:46:49.077 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=2150
HACK 2015-03-19 05:46:49.077 {00} <NOSCOPE> =====================================> baseClaimRadius=30 newRadius=21
WARN 2015-03-19 05:46:49.133 {00} <NOSCOPE> DB::noRS(56 ms) UPDATE `guild_lands` SET Radius=21 WHERE ID=79;
HACK 2015-03-19 05:46:49.134 {00} <NOSCOPE> =====================================> createdDurability=2000 durability=2000
WARN 2015-03-19 05:46:49.167 {00} <NOSCOPE> DB::noRS(32 ms) UPDATE `claims` SET SupportPoints=-317 WHERE ID=80;
HACK 2015-03-19 05:46:49.167 {00} <NOSCOPE> =====================================> supportPoints=-317
HACK 2015-03-19 05:46:49.168 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=1900
HACK 2015-03-19 05:46:49.168 {00} <NOSCOPE> =====================================> baseClaimRadius=20 newRadius=19
WARN 2015-03-19 05:46:49.267 {00} <NOSCOPE> DB::noRS(98 ms) UPDATE `guild_lands` SET Radius=19 WHERE ID=80;
HACK 2015-03-19 05:46:49.267 {00} <NOSCOPE> =====================================> createdDurability=3000 durability=2000
WARN 2015-03-19 05:46:49.300 {00} <NOSCOPE> DB::noRS(33 ms) UPDATE `claims` SET SupportPoints=324531 WHERE ID=81;
HACK 2015-03-19 05:46:49.301 {00} <NOSCOPE> =====================================> supportPoints=324531
HACK 2015-03-19 05:46:49.301 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=2150
HACK 2015-03-19 05:46:49.302 {00} <NOSCOPE> =====================================> baseClaimRadius=30 newRadius=21
WARN 2015-03-19 05:46:49.358 {00} <NOSCOPE> DB::noRS(57 ms) UPDATE `guild_lands` SET Radius=21 WHERE ID=81;
HACK 2015-03-19 05:46:49.359 {00} <NOSCOPE> =====================================> createdDurability=2000 durability=2000
WARN 2015-03-19 05:46:49.392 {00} <NOSCOPE> DB::noRS(32 ms) UPDATE `claims` SET SupportPoints=79356 WHERE ID=82;
HACK 2015-03-19 05:46:49.392 {00} <NOSCOPE> =====================================> supportPoints=79356
HACK 2015-03-19 05:46:49.393 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=2100
HACK 2015-03-19 05:46:49.393 {00} <NOSCOPE> =====================================> baseClaimRadius=20 newRadius=21
WARN 2015-03-19 05:46:49.500 {00} <NOSCOPE> DB::noRS(107 ms) UPDATE `guild_lands` SET Radius=21 WHERE ID=82;
HACK 2015-03-19 05:46:49.501 {00} <NOSCOPE> =====================================> createdDurability=2000 durability=2000
WARN 2015-03-19 05:46:49.533 {00} <NOSCOPE> DB::noRS(32 ms) UPDATE `claims` SET SupportPoints=1179 WHERE ID=83;
HACK 2015-03-19 05:46:49.534 {00} <NOSCOPE> =====================================> supportPoints=1179
HACK 2015-03-19 05:46:49.535 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=2100
HACK 2015-03-19 05:46:49.535 {00} <NOSCOPE> =====================================> baseClaimRadius=20 newRadius=21
WARN 2015-03-19 05:46:49.592 {00} <NOSCOPE> DB::noRS(56 ms) UPDATE `guild_lands` SET Radius=21 WHERE ID=83;
HACK 2015-03-19 05:46:49.592 {00} <NOSCOPE> =====================================> createdDurability=2000 durability=2000
WARN 2015-03-19 05:46:49.667 {00} <NOSCOPE> DB::noRS(74 ms) UPDATE `claims` SET SupportPoints=-317 WHERE ID=84;
HACK 2015-03-19 05:46:49.667 {00} <NOSCOPE> =====================================> supportPoints=-317
HACK 2015-03-19 05:46:49.668 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=1900
HACK 2015-03-19 05:46:49.668 {00} <NOSCOPE> =====================================> baseClaimRadius=20 newRadius=19
WARN 2015-03-19 05:46:49.725 {00} <NOSCOPE> DB::noRS(57 ms) UPDATE `guild_lands` SET Radius=19 WHERE ID=84;
HACK 2015-03-19 05:46:49.726 {00} <NOSCOPE> =====================================> createdDurability=2000 durability=2000
WARN 2015-03-19 05:46:49.758 {00} <NOSCOPE> DB::noRS(32 ms) UPDATE `claims` SET SupportPoints=971 WHERE ID=86;
HACK 2015-03-19 05:46:49.759 {00} <NOSCOPE> =====================================> supportPoints=971
HACK 2015-03-19 05:46:49.759 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=2100
HACK 2015-03-19 05:46:49.760 {00} <NOSCOPE> =====================================> baseClaimRadius=20 newRadius=21
WARN 2015-03-19 05:46:49.867 {00} <NOSCOPE> DB::noRS(106 ms) UPDATE `guild_lands` SET Radius=21 WHERE ID=86;
HACK 2015-03-19 05:46:49.867 {00} <NOSCOPE> =====================================> createdDurability=2000 durability=2000
WARN 2015-03-19 05:46:49.900 {00} <NOSCOPE> DB::noRS(33 ms) UPDATE `claims` SET SupportPoints=55223 WHERE ID=87;
HACK 2015-03-19 05:46:49.901 {00} <NOSCOPE> =====================================> supportPoints=55223
HACK 2015-03-19 05:46:49.901 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=2100
HACK 2015-03-19 05:46:49.901 {00} <NOSCOPE> =====================================> baseClaimRadius=20 newRadius=21
WARN 2015-03-19 05:46:49.958 {00} <NOSCOPE> DB::noRS(57 ms) UPDATE `guild_lands` SET Radius=21 WHERE ID=87;
HACK 2015-03-19 05:46:49.959 {00} <NOSCOPE> =====================================> createdDurability=2000 durability=2000
WARN 2015-03-19 05:46:49.992 {00} <NOSCOPE> DB::noRS(32 ms) UPDATE `claims` SET SupportPoints=263 WHERE ID=88;
HACK 2015-03-19 05:46:49.992 {00} <NOSCOPE> =====================================> supportPoints=263
HACK 2015-03-19 05:46:49.993 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=1900
HACK 2015-03-19 05:46:49.993 {00} <NOSCOPE> =====================================> baseClaimRadius=20 newRadius=19
WARN 2015-03-19 05:46:50.092 {00} <NOSCOPE> DB::noRS(98 ms) UPDATE `guild_lands` SET Radius=19 WHERE ID=88;
HACK 2015-03-19 05:46:50.092 {00} <NOSCOPE> =====================================> createdDurability=3000 durability=2000
WARN 2015-03-19 05:46:50.125 {00} <NOSCOPE> DB::noRS(32 ms) UPDATE `claims` SET SupportPoints=83 WHERE ID=89;
HACK 2015-03-19 05:46:50.126 {00} <NOSCOPE> =====================================> supportPoints=83
HACK 2015-03-19 05:46:50.126 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=1850
HACK 2015-03-19 05:46:50.126 {00} <NOSCOPE> =====================================> baseClaimRadius=30 newRadius=18
WARN 2015-03-19 05:46:50.183 {00} <NOSCOPE> DB::noRS(57 ms) UPDATE `guild_lands` SET Radius=18 WHERE ID=89;
HACK 2015-03-19 05:46:50.184 {00} <NOSCOPE> =====================================> createdDurability=3000 durability=2000
WARN 2015-03-19 05:46:50.258 {00} <NOSCOPE> DB::noRS(74 ms) UPDATE `claims` SET SupportPoints=-317 WHERE ID=90;
HACK 2015-03-19 05:46:50.259 {00} <NOSCOPE> =====================================> supportPoints=-317
HACK 2015-03-19 05:46:50.259 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=1850
HACK 2015-03-19 05:46:50.260 {00} <NOSCOPE> =====================================> baseClaimRadius=30 newRadius=18
WARN 2015-03-19 05:46:50.317 {00} <NOSCOPE> DB::noRS(56 ms) UPDATE `guild_lands` SET Radius=18 WHERE ID=90;
HACK 2015-03-19 05:46:50.317 {00} <NOSCOPE> =====================================> createdDurability=2000 durability=2000
WARN 2015-03-19 05:46:50.350 {00} <NOSCOPE> DB::noRS(32 ms) UPDATE `claims` SET SupportPoints=-317 WHERE ID=94;
HACK 2015-03-19 05:46:50.351 {00} <NOSCOPE> =====================================> supportPoints=-317
HACK 2015-03-19 05:46:50.351 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=1900
HACK 2015-03-19 05:46:50.351 {00} <NOSCOPE> =====================================> baseClaimRadius=20 newRadius=19
WARN 2015-03-19 05:46:50.458 {00} <NOSCOPE> DB::noRS(107 ms) UPDATE `guild_lands` SET Radius=19 WHERE ID=94;
HACK 2015-03-19 05:46:50.459 {00} <NOSCOPE> =====================================> createdDurability=2000 durability=2000
WARN 2015-03-19 05:46:50.502 {00} <NOSCOPE> DB::noRS(43 ms) UPDATE `claims` SET SupportPoints=-317 WHERE ID=95;
HACK 2015-03-19 05:46:50.503 {00} <NOSCOPE> =====================================> supportPoints=-317
HACK 2015-03-19 05:46:50.504 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=1900
HACK 2015-03-19 05:46:50.504 {00} <NOSCOPE> =====================================> baseClaimRadius=20 newRadius=19
WARN 2015-03-19 05:46:50.550 {00} <NOSCOPE> DB::noRS(45 ms) UPDATE `guild_lands` SET Radius=19 WHERE ID=95;
HACK 2015-03-19 05:46:50.550 {00} <NOSCOPE> =====================================> createdDurability=2000 durability=2000
WARN 2015-03-19 05:46:50.633 {00} <NOSCOPE> DB::noRS(82 ms) UPDATE `claims` SET SupportPoints=224196 WHERE ID=97;
HACK 2015-03-19 05:46:50.634 {00} <NOSCOPE> =====================================> supportPoints=224196
HACK 2015-03-19 05:46:50.634 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=2100
HACK 2015-03-19 05:46:50.635 {00} <NOSCOPE> =====================================> baseClaimRadius=20 newRadius=21
WARN 2015-03-19 05:46:50.694 {00} <NOSCOPE> DB::noRS(59 ms) UPDATE `guild_lands` SET Radius=21 WHERE ID=97;
HACK 2015-03-19 05:46:50.695 {00} <NOSCOPE> =====================================> createdDurability=2000 durability=2000
WARN 2015-03-19 05:46:50.717 {00} <NOSCOPE> DB::noRS(21 ms) UPDATE `claims` SET SupportPoints=58439 WHERE ID=100;
HACK 2015-03-19 05:46:50.717 {00} <NOSCOPE> =====================================> supportPoints=58439
HACK 2015-03-19 05:46:50.717 {00} <NOSCOPE> =====================================> prevDurability=2000 durability=2100
HACK 2015-03-19 05:46:50.718 {00} <NOSCOPE> =====================================> baseClaimRadius=20 newRadius=21
WARN 2015-03-19 05:46:50.817 {00} <NOSCOPE> DB::noRS(99 ms) UPDATE `guild_lands` SET Radius=21 WHERE ID=100;


The same thing happened again today. when i stopped added a password and started the server again, decay cycle deleted these object, and the next one when there was no object to delete, the claims maintenance cycle kicks in and the claims expand....

Now where to go from here......
B4 i go to bed i will stop the server and remove the password, and start it up again, u all play on it for the next day and tomorrow when i get home from work i will back up the 'MovableObject' table in the database, and ill do my "thing" to the server and cross check the server logs and database to se what objects are causing the problem....
  • Рандомная аватара. Подставляется автоматически при отсутствии установленной пользователем аватары. Рекомендуется менять на свою в Центре пользователя.
  • bigsteve
    Clans:
      Not involved in the clans.
M&B Status:
Offline
Reputation point: 3

Re: Trying to Fix your LiF Server

Post Number:#2  Postby bigsteve » 21 Mar 2015, 07:57

Tonights Objects that are OBJ_DECAY procedure that are being deleted, there are 17 of them in the first cycle.
Movable IDItem IDName
14504911Bear Corpse
14505922Grouse Corpse
145101071Dropped objects
145361071Dropped objects
145371071Dropped objects
145381071Dropped objects
145391071Dropped objects
145401071Dropped objects
145411071Dropped objects
145421071Dropped objects
145441071Dropped objects
145461071Dropped objects
145471071Dropped objects
14549915Wolf Corpse
14550915Wolf Corpse


Next decay cycle there was nothing to delete so the Claims Maintenance started and claims expanded again.
Now as we can see it is Corpses and Dropped Object Containers that are being deleted.....
So now it could be 1 of 3 things.
1. its the Corpse are causing the Claims Maintenance to be missed
2. its the Dropped Object container causing it
3. its both

now to do some more testing,
ill kill a bunch of animals and wait for a decay cycle, then drop a bunch of dropped object containers, then do both.

So now after spending 90mins zooming around trying ( and a lot of crashes to desktop) to find only 1 wolf, which i killed.
and guess what on the next maintenance cycle Obj_decay started to reduced the durability..... and no Claim maintenance occurred.
Don't have enough time to do a Drop obj container tonight.... will do it tomorrow....
Will do these tests on my server tomorrow too....
  • Рандомная аватара. Подставляется автоматически при отсутствии установленной пользователем аватары. Рекомендуется менять на свою в Центре пользователя.
  • bigsteve
    Clans:
      Not involved in the clans.
M&B Status:
Offline
Reputation point: 3

Re: Trying to Fix your LiF Server

Post Number:#3  Postby bigsteve » 22 Mar 2015, 05:22

Test completed on my server and i can reproduce, so i have submitted a bug report on LIF Mantis.

https://lifeisfeudal.com/mantis/view.php?id=3053

hopefully the dev's can fix it quick.
  • Рандомная аватара. Подставляется автоматически при отсутствии установленной пользователем аватары. Рекомендуется менять на свою в Центре пользователя.
  • bigsteve
    Clans:
      Not involved in the clans.
M&B Status:
Offline
Reputation point: 3




Return to Life is Feudal

Who is online

Users browsing this forum: No registered users and 0 guests