Boat warps
Posted: Tue Sep 06, 2005 11:32 am
Like I promised yesterday, I took a look at the boat warping problem. Here's a report of my findings.
The problem seems to be related to the fact that for an unknown reason, there were more than one records in a table called "sailing" (storing current information on the location and speed of the boat), where there should be only one. The code assumed there was only one, and updated that as the ship sailed around. However, when it docked, the entry was deleted. But, only one of them... thus reactivating the "sleeping" record that had been around all that time. No problem while the boat was docked, no checks were done on this table while the boat was in port... bu when the ship undocked again, there was a new insertion into the table... but, with the ID number of the "sleeping" record (with age-old information)being lower than the record just inserted, that suddenly became the "active" record! (Apart from that, inserting a new "sleeping" record as well). The location was suddenly changed to the location of the false "active" record - and a warp was born.
The code has now been changed so that there's a DELETE of any existing records in the sailing table when undocking, just before the new record is inserted. Even though we still don't know what caused the original bug (the fact that there were multiple records in the first place), we hope we have fought the symptoms. Boat warping *should* not occur anymore.
However! This is not to say that this has solved the warping problem once and for all. The change to the code was in fact implemented about a week ago - so if there have been warps since then, we would like to hear about them.
Please accept an apology from us as well. It appears as if we didn't handle the warping problem reports appropriatly, not returning messsages to the players, etc, up to a stage where people simply decided to sail back the way they came. This has probably got to do with the fact that there are too many channels for reporting bugs (the Forum, Flyspray, bugs@cantr.net), plus the fact that several members of the Dept are involved in solving them. I hereby request you people to report urgent bugs like this to bugs@cantr.net - and please include your player ID, character name, and other relevant details in the report. We seriously hope that we can improve our performance in this respect, and that we'll appropriatly handle boat warps (or other bugs with serious IG consequences) within a matter of a few days max.
Jur.
The problem seems to be related to the fact that for an unknown reason, there were more than one records in a table called "sailing" (storing current information on the location and speed of the boat), where there should be only one. The code assumed there was only one, and updated that as the ship sailed around. However, when it docked, the entry was deleted. But, only one of them... thus reactivating the "sleeping" record that had been around all that time. No problem while the boat was docked, no checks were done on this table while the boat was in port... bu when the ship undocked again, there was a new insertion into the table... but, with the ID number of the "sleeping" record (with age-old information)being lower than the record just inserted, that suddenly became the "active" record! (Apart from that, inserting a new "sleeping" record as well). The location was suddenly changed to the location of the false "active" record - and a warp was born.
The code has now been changed so that there's a DELETE of any existing records in the sailing table when undocking, just before the new record is inserted. Even though we still don't know what caused the original bug (the fact that there were multiple records in the first place), we hope we have fought the symptoms. Boat warping *should* not occur anymore.
However! This is not to say that this has solved the warping problem once and for all. The change to the code was in fact implemented about a week ago - so if there have been warps since then, we would like to hear about them.
Please accept an apology from us as well. It appears as if we didn't handle the warping problem reports appropriatly, not returning messsages to the players, etc, up to a stage where people simply decided to sail back the way they came. This has probably got to do with the fact that there are too many channels for reporting bugs (the Forum, Flyspray, bugs@cantr.net), plus the fact that several members of the Dept are involved in solving them. I hereby request you people to report urgent bugs like this to bugs@cantr.net - and please include your player ID, character name, and other relevant details in the report. We seriously hope that we can improve our performance in this respect, and that we'll appropriatly handle boat warps (or other bugs with serious IG consequences) within a matter of a few days max.
Jur.