Issue information

Issue ID
#2049
Status
Invalid
Severity
None
Started
Hercules Elf Bot
Aug 12, 2008 21:48
Last Post
Hercules Elf Bot
Apr 5, 2012 8:06
Confirmation
N/A

Hercules Elf Bot - Aug 12, 2008 21:48

Originally posted by [b]Cichy[/b]
http://www.eathena.ws/board/index.php?autocom=bugtracker&showbug=2049

hello ~

W have a problem with our Server~

Description

The following happens ( not always ) when the server crashes or after a restart:

The server starts in a normal way but some players lost their items from their inventory or
their equipped stuff. The opposite is that some people will twice their equipment, but only
their own one.

We have the proof that the items are in the database before the server crashes, but afterwards
they are gone due to the fact that we have unique items which only have not more than one player.

The items disappear without any interrelation but only from their inventory or the equipped things,
storage, cartinventory and so on are inviolate.

There are no errors or warnings which could help us to come to a conclusion.

The server gets restarted as follows:

- set min connection lvl to 30 in the llogin server and restart it
- all players are kicked (kickall)
- after several minutes the mapserver is closed with command @mapexit or other

Server-Versions:

with stable 6+++

Such problems never appeared with this stable versions.

with trunk 12666

This problems appeared the first time.
We tested some other revs but the same problems appeared.

with stable 13071

Now we are using the rev 13071 with all changes and updates in the database. But now the main problem
is, that a lot of people have twiced their own equippment. We make backups every 3 hours and tested several
backups but the problems are still there.

so far...


greetings


Edit:

Lol today i found very stupid things. many player dont have a inventory (that say the database) . look self


i search today a item that was destroyed and i'll look also in my inventory at our database.


(IMG:http://img523.imageshack.us/img523/1884/noinvent3sc4.jpg)
thats my char with char id
(IMG:http://u2ro.org/as1/noinvent2.jpg)
thats my char with the item
(IMG:http://u2ro.org/as1/noinvent.jpg)
database say "no result" o.ô (if i search with my char id in inventory)
(IMG:http://u2ro.org/as1/noinvent1.jpg)
if i search only the item id , i found my inventory with this item




This post has been edited by Cichy: Aug 13 2008, 09:55 AM

Hercules Elf Bot - Dec 17, 2011 5:09

Originally posted by [b]Ind[/b]
quoting umage from original bug report
[quote]Then you possibly have a corrupted index, or a bugged version of phpmyadmin, or mysql... since there's no way that query would fail like that.[/quote]