Player Housing and Server Crashes
#26
I first want to start and say that there has not been a server crash that has wiped out all furniture. However, the debug lines have helped determine the cause of *some* lost furniture, as well as LooseWilly's nicely detailed report. I'm not going to go into the real complicated details here, but to sum it up, the database export from the running module to the database itself was/is stopping. I don't know the reason why, however. But in yesterday's example, the last time it ran was at 1:15 AM Central Time (last line below):
Code:
[Mon Dec 22 01:14:29] DEBUG: Saving hh_property in hh_include line 139 in 60 seconds.
[Mon Dec 22 01:14:32] Wyren Caul-of-Amber(Wids)[Talk] !undo
[Mon Dec 22 01:14:33] DEBUG: Saving hh_property in hh_include line 139 in 60 seconds.
[Mon Dec 22 01:14:35] Wyren Caul-of-Amber(Wids)[Talk] !move 0 1
[Mon Dec 22 01:15:01] Wyren Caul-of-Amber(Wids)[Talk] !move 0 0.01
[Mon Dec 22 01:15:02] DEBUG: Saving hh_property in hh_include line 139 in 60 seconds.
[Mon Dec 22 01:15:06] Wyren Caul-of-Amber(Wids)[Talk] !move 0 0.1
[Mon Dec 22 01:15:28] DEBUG: Saving hh_property in hh_include SaveHousingDatabase().

So anything after that was lost, once the server reset. Like in all the furniture debug lines for Veybold, the SaveHousingDatabase function was not firing:
Code:
[Mon Dec 22 14:19:20] DEBUG: Saving hh_property in hh_include line 139 in 60 seconds.
[Mon Dec 22 14:19:26] DEBUG: Saving hh_property in hh_place_pickup in 60 seconds.
[Mon Dec 22 14:19:26] Veybold Von Zipper has picked up Furniture - Table, Illithid . (Building - Medium House)/Furniture - Table, Illithid /403gp/
[Mon Dec 22 14:20:17] DEBUG: Saving hh_property in hh_include line 139 in 60 seconds.
[Mon Dec 22 14:20:51] DEBUG: Saving hh_property in hh_include line 206 in 60 seconds.

I don't know why the SaveHousingDatabase function crapped out, but I am re-writing it to use what is hopefully a more reliable method of checking the last time the database was saved (exported to file) and make sure that it occurs every minute once again. I do want to mention that I cannot/will not allow players to specify when a database saves because that is a very CPU intensive process which will generate lag, or even cause crashes, if it is overused and/or especially if multiple people are using it at the same time. That is also why, no matter how many times the SaveHousingDatabase may be called within 60 seconds, it is supposed to only export the database item in the module for furniture once every 60 seconds.
Reply


Messages In This Thread
Player Housing and Server Crashes - by Miscr3ant - 11-30-2014, 12:20 AM
RE: Player Housing and Server Crashes - by Bela - 12-14-2014, 03:56 PM
RE: Player Housing and Server Crashes - by NOITCA - 12-14-2014, 11:35 PM
RE: Player Housing and Server Crashes - by Wids - 12-16-2014, 12:52 AM
RE: Player Housing and Server Crashes - by Wids - 12-16-2014, 02:00 PM
RE: Player Housing and Server Crashes - by Wids - 12-16-2014, 03:25 PM
RE: Player Housing and Server Crashes - by Bela - 12-19-2014, 02:42 PM
RE: Player Housing and Server Crashes - by Bela - 12-19-2014, 03:10 PM
RE: Player Housing and Server Crashes - by Wids - 12-23-2014, 03:20 AM
RE: Player Housing and Server Crashes - by Balanor - 12-23-2014, 12:26 PM

Forum Jump:


Users browsing this thread: 33 Guest(s)