Possible delete char bug

Old bugs stored here for reference.
Locked
User avatar
John Adams
Retired
Posts: 9684
Joined: Thu Jul 26, 2007 6:27 am
EQ2Emu Server: EQ2Emulator Test Center
Characters: John
Location: Arizona
Contact:

Possible delete char bug

Post by John Adams » Sat Aug 09, 2008 9:34 am

I haven't seen this before in testing, but someone just deleted their char from my server and immediately following looks like a DB Error trying to update the deleted records unix timestamp.

Code: Select all

Delete char request: 1445 746
[Error] Error in UpdateCharacterTimeStamp query 'update characters set unix_time
stamp=1218291913 where id=746 and account_id=1445': DBcore::RunQuery: No Result
Doesn't appear harmful, just reporting the news.

User avatar
John Adams
Retired
Posts: 9684
Joined: Thu Jul 26, 2007 6:27 am
EQ2Emu Server: EQ2Emulator Test Center
Characters: John
Location: Arizona
Contact:

Post by John Adams » Mon Oct 13, 2008 11:07 am

Got a few more of these errors today in the console, though I still do not believe they are critical. The character deletes are occurring, not sure why their unix_timestamp is trying to get updated after they have been deleted...

Code: Select all

Delete char request: 924 1042
[Error] Error in UpdateCharacterTimeStamp query 'update characters set unix_timestamp=1223890176 where id=1042 and account_id=924': DBcore::RunQuery: No Result
[Error] Error in UpdateCharacterTimeStamp query 'update characters set unix_timestamp=1223890236 where id=1042 and account_id=924': DBcore::RunQuery: No Result
[Error] Error in UpdateCharacterTimeStamp query 'update characters set unix_timestamp=1223890296 where id=1042 and account_id=924': DBcore::RunQuery: No Result
Timeout up!, state=0
Zone: Removing client from ip:xxx.xxx.xxx.xxx port:26357
Removing connection
.
.
.
Left Grid 924281492 and Entered Grid 819993724
OP_SatMsg Received 0x00ab
Delete char request: 3191 1043
[Error] Error in UpdateCharacterTimeStamp query 'update characters set unix_timestamp=1223910033 where id=1043 and account_id=3191': DBcore::RunQuery: No Result
Timeout up!, state=0
Zone: Removing client from ip:xxx.xxx.xxx.xxx port:2546
Removing connection
Both cases seemed to have that Timoutup!, state=0. Perhaps the character delete is occurring after a client gets booted but before the game server knows the player deleted the char?
Most of the time, char deletes do not generate this error.

LethalEncounter
Team: Zombie
Posts: 2717
Joined: Wed Jul 25, 2007 10:10 pm

Post by LethalEncounter » Mon Oct 13, 2008 1:35 pm

Heh, the player must have had two screens opened (one in-game and one on the server) and deleted the character while they were playing. I'm not sure why they would do this, unless they were trying to crash the server.

User avatar
John Adams
Retired
Posts: 9684
Joined: Thu Jul 26, 2007 6:27 am
EQ2Emu Server: EQ2Emulator Test Center
Characters: John
Location: Arizona
Contact:

Post by John Adams » Mon Oct 13, 2008 1:43 pm

Bring it on, nubs! I dare you to crash mah server! ;)

Locked

Who is online

Users browsing this forum: No registered users and 0 guests