The World of Layonara
The NWN Persistent World => Layonara Server => Topic started by: Leanthar on September 25, 2006, 07:25:49 AM
-
Hello folks, this is a one month heads up and please spread the word, it is quite important.
We have a problem with the Bioware database for NwN. By default because they are using a Foxpro type database the FXP file can not be larger than 2GB or it can not be opened and compacted (packed). Sadly the popularity of the world and my inability to get to maintenance of this database every single month the database is now at 2.5GB and we can not compact it any longer. This causes a problem due to seek time and such. The only way to solve this problem is to wipe that database and start clean. Don't fear things will be okay but I need to explain how things work (when they work) and how this will help the problem.
Firstly, nothing will be lost if you guys follow the instructions in this post--pretty simple instructions over all. All you have to do is make sure you have NOTHING in your BANK VAULT (any BANK VAULT) or your housing chests/storage containers. You can have furniture in your house and all of that good stuff but you can not have anything stored in any container (other than oxen or a characters inventory) when I take the servers down on the 26th of October. Once the servers come back up just put your stuff back in to the containers and all will be fine. So, just remove everything from any/all containers except for your oxen or your character inventory the night of the 25th before the maintenance then when the servers come back up just put them back in to the containers in your house or bank vault, you do not have to remove your furniture etc--just empty the containers. Just please be aware that if you are logging in with a large inventory you are causing an server spike that can crash the server. So don’t do this until the night before, or until your last play time before the maintenance.
Why is this necessary you ask? 1) When you do a pack of the Bioware database it has to be opened exclusively (locked) so the worlds can not be online and that is why we have always taken the servers down. 2) When an item is removed from a chest they are just marked as deleted but the Bioware db (foxpro database) does not actually delete the item until the database is packed (see 1 above). 3) It has always been the case, because our world is busy, that the database will shrink in size by a huge amount after a pack. For instance the last time I did this the database was at 1.8GB but after pack it was at 55meg. Something like that, I don't remember the exact number. But clearly you can see that packing is important as it keeps the seek time in the database down, and thus the lag time for the servers when people are looking at storage containers. 4) Since the file is now over 2GB (it is at 2.8GB right now and will be at least 4GB when the maintenance happens) Foxpro can not open the fxp file. Stupid I know…but well that is how things go. The database is functioning perfectly fine as there are just seeks and it is not trying to be opened exclusively…nothing is being lost so don’t worry. 5) Since it can not be opened we have no choice but to delete the database entirely. That is why you need to have everything out of storage containers on that day, so that nothing will be lost. Once we delete the database and bring the world back up just put your stuff in there and all will be perfectly fine and we will try to keep control of the database size with our server maintenance procedures.
So, spread the word, make sure containers that are not in a characters inventory are empty on that day of maintenance. Housing containers and bank vaults are the only thing affected because they are the only thing that use the Bioware DB.
Why do we use the Bioware DB then you ask? Its simple, the Bioware functions save all of the variables and properties of items properly and storing them in the SQL DB does not. So that means that all of the rods, items special properties, charges and such are stored properly in the Bioware DB but not in the SQL DB.
There will be no reimbursement of items if things are lost on this date. I am giving a 30 day notice on this so please spread the word in game and on the forums. Make sure you speak to everybody. I will also be putting a message in the login text for all servers that request people to read the forums for this maintenance post.
-
Erm....Why I totally understand this needs doing it's not going to be physically possible to put everything from Ireth's bank vault and house storage chests into Ireth's ox and character inventory....they just aren't big enough to handle it all.
I'm sure I'm not going to be the only person in this situation
-
Buy storage boxes, a few gold from the general merchant, load down your inventory with boxes, and load everything into said-boxes, this IS technically a bit of an abuse of storage space capability, but I think it would be overlooked for one day or so.
1 box in inventory=4 blocks of space (2x2)
1 box interior=35 blocks of space (7x5)
And if you still have too much stuff to carry all that, ask friends to help you hold it, it's just overnight
-
Good point! :)
-
Leaving gold coin in the bank is okay?
-
Yes, leaving gold in the bank is fine.
-
DMOE you saw all the Cra.... erm... stuff Enzo has.
He put it all in his inventory in boxes when his house was remodeled!
He may have been about 900 pounds over weight... but he did it.
I dont think she has more stuff accumulated than him.
.... I'd like to add this seems like a very OOC thing we have to deal with... so If someone that trusted me needed the help I'd lend them an alternate character for storage... if of course the Layo Team felt it was acceptable for this situation.
-
I don't mind friends helping friends out. Just don't want mule characters created for the process. If people really have that much stuff...well perhaps it is time to widdle down the storage? :)
-
Is it correct that the Database Maintenance only affects West?
Bank chests are different on different servers and the fact that the server "locks" the database probably means that West/Central/East are using different Bioware databases...
Only a guess from me, of course. ;)
Edit: Ooh.... any bank vault? Hm... It's affecting all the server? *looks slightly confused*
-
You are correct Weeblie, but we are doing this for all servers.
-
Alright!
Complete wipe! Got it! :)
-
I hope everyone seriously considers this time to do cleanup to their homes and inventory. Right now some people lag the server a good 5 to 10 seconds due to the amount of stuff they carry in their inventory. This isn't fun for anyone and I seriously doubt that anyone would need to carry so much stuff on themselves. Yes I know there are pack rats out there that accumulate things over time, but exactly why so much is carried, I'm not sure.
So please consider this a good time for this, since in the end it will help everyone around, including yourselves.
Thank you.
-
I threw away like 4 chests full of things Enzo was sitting on for "someday".... when his house just got remodeled.
It will be a good time for everybody to take stock of what they have and what they really need. Heck... I
will probably have stuff to throw out aleady ;)
-
Having gone through the house remodeling shuffle recently myself, I can give this alternative list of suggestions to those who want to thin out their inventories a bit: 1) Make a list of the things you knwo your character Needs to keep, 2) Make a seperate list of everything else that isn't a CNR component item and try to sell those, 3) Try to use up your stores of CNR components and resist the urge to go gathering more unless you Really need them to use in using up other CNR component items (for example if you need alexandrite to go with the gold that you have stored to make rings then go get it and use it immediately, start a few days before the wipe), 4) Anything you can't sell or make into something that won't fit into your inventory on your character and ox, take to your character's temple and donate it to your character's god.
-
Yes, please do use this opportunity to get rid of the clutter. :) There really is no need to have 100's of items, or even dozens really. The less items one has on their person (in their character inventory) the less lag we have on the server due to login spikes--significant over all.
The less items a player has in the house for storage the less load spike we see.
Getting rid of things improves the performance of the servers and makes the game more fun for the players.
-
27 days. Please spread the word.
-
Bump!
-
Bump!
-
*Dates getting closer*
Bumping incase folks dissapear off on holiday or something and dont see it.
-
Two weeks until this happens. Please make sure everybody you see or know is informed of this.
Thank you.
-
This happens in 9 days folks. Please spread the word and if you know people that it may affect please speak to them and give them a heads up.
-
This happens in one week.
-
It's weekend, so eveyone who plays weekends, don't forget, because next weekend it's done!
-
This happens in 4 days, this coming Thursday.
-
Do you have a roughly idea what time this is going to happen?
-
If I were you, I wouldn't wait for the last day :)
-
Will this wipe out the treasure maps/buried chests? If so, I need to reschedule something and fast.
Thanks
-
SquareKnot - 10/22/2006 3:39 PM Will this wipe out the treasure maps/buried chests? If so, I need to reschedule something and fast. Thanks
Only if you store those maps in a housing or bank chest.
-
OK, thanks. I have about 20 chests buried right now and wanted to make sure their contents and location would last across the DB wipe. It must use something else for persistence. Thanks for the fast reply.
-
What time exactly are the servers coming down? Just found out about this a couple days ago and trying to get everything reinstalled and patched and downloaded (haks and such) ASAP.
-
I'm pretty sure what the answer is, but I'll ask just to be safe -- this doesn't affect gold stored in the bank, right? That is, we shouldn't have to withdraw our savings for this operation?
-
The gold in the bank will be fine as it is not affected.
-
Hope nobody mines but *bump* Just a little reminder.
-
This happens in two days folks. I want to stress again that if a player can not get their items cleared up (for whatever reason) those items will be lost and we will not be retrieving them in any way. We have given a full months notice so I think that is enough time for a player to get their items or at the very least get a friend to get it for them. Please clear out your items or they will be lost.
I want to encourage people to use this as an opportunity to get rid of stuff that does not really need to be stored--it just causes lag spikes when the database is hit. If you need it then by all means keep it, but if you can get rid of it please just let it get wiped.
-
oly crap! I better look my junk tonight. :) Hope no one gets caught by this.
-
This thread has been bumped for a month and the time for this is on October 26th. Spread the word, talk to your friends. On top of that there is a message for players to check this forum for this important post, the message is received at the time one logs in to the world. So they know they need to come and look at these forums.
-
Another thread bump, remember this is October 26th. When Leanthar spoke about the thread being bumped for a month he meant the thread he's been bumping, not the date of the db maintenance. We will be a lot more precise on the time this will occur late on the 25th or early 26th.
-
This happens tomorrow, see this thread for the time.
http://www.layonaraonline.com/forums/forums/thread-view.asp?tid=31327&posts=1#M201048
-
This happens in 14.5 hours (9am PDT on the 26th).
-
This happens in 30 minutes.
-
Can we get a couple IN GAME announcements (shouts) too please?
-
Done.
-
erh well... I guess this is my fault :o that I didnt see this but... I didnt. There is no way I can get all my stuff from chests and the bank replaced?
-
Nope, no chance. Sorry. I was really hoping everybody would have seen this as I even had messages for players when they logged in to the game world to come and read this post. Sorry Niles.
-
well *shrugs* I was never going to get any of it sold anyway, I still got my boots from the battle of Pranzis and all the important stuff Im using.
-
Good. I am glad you still have that stuff. Sorry Niles.