Desync issues in GFaydark and Felwithe - Page 2

**Uleat** · #16 05-20-2016, 08:30 PM

I won't say that bots are definitely out of the question..but, if there were a problem with them, it would most likely crash the server - or at least show up with other players.

I am curious about the #race change, however.

Do your logs show any increase in 'unknown/unhandled opcode' packets with this account compared to accounts that are not experiencing this issue?

kartikeya200 · #17 05-20-2016, 08:50 PM

This pops up on occasion, but not reliably as to when I'm experience problems:

Code:

[MySQL Error] 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 
 REPLACE INTO `character_bind` (id, zone_id, instance_id, x, y, z, heading, slot) VALUES (12757996, 12757812, 12756388, 0.000000, 0.000000, 0.000000, 0.000000, 1074790400), (0, 1076887552, 0, 0.000000, 0.000000, 0.000000, 0.000000, 1074790400),

DanCanDo · #18 05-20-2016, 09:10 PM

Just my 2 cents on this from my own experience. I don't run a public server, but my home
server is on a win 7(64 bit) box with 24 GB ram. I was testing out load one day just to see
how much mem/cpu was being used. I started the server with 40 zone launchers and also
logged on 4 different copies of UF client all on the same puter as server. I had no issues
with lag or anything else, but no bots were spawned either.
I have an older computer with 4 GB ram, and that same scenario would be totally hopeless.

kartikeya200 · #19 05-20-2016, 10:20 PM

So far I've found nothing out of the ordinary with this character or account that I haven't already accounted for, except that, interestingly, the 'hacker' list in the database has flagged it multiple times. Almost every single one of those is in Felwithe, in which it seems to have flagged a number of my disconnects or desyncs as a possible use of macroquest instacamp. It's just a guess, but I assume this is likely the result of my desync-ing and then never re-syncing (and having to either /q out or use the task manager), but it's pretty funny.

**Uleat** · #20 05-20-2016, 10:28 PM

Any way you can #race change the affect character back to its original value and test the account?

(Manually changing the database value, in this case, will probably be required.)

kartikeya200 · #21 05-20-2016, 11:29 PM

I can pretty easily race change her back. Would that mess with her factions?

Also, still tinkering, I copied the character to another account. She appears to have everything but bots. Ran around to every affected area I know about and didn't experience any de-sync. So I flagged the account for GM. No change, things were still good. Then I logged in the affected account, which was camped right next to her. BOTH experienced de-sync after a minute or so. The moment I used task manager to close out the affected account window, the de-sync on the copied character ended.

Is there an easy way to copy over bot data to another character? I'm going to run her around a bit more, but it would be useful to at least thoroughly disprove that the bots are affecting it.

**Uleat** · #22 05-20-2016, 11:34 PM

Not real easily...

I made a 'clone' command for 'testing' purposes..but, that only allows the bot owner to clone their own bots.

It could be done with an sql script.

kartikeya200 · #23 05-20-2016, 11:55 PM

I race changed her (with #permarace, not a DB edit yet) back to the original race (wood elf). Sadly no difference. :(

cannon · #24 05-21-2016, 11:05 AM

Quote:

Originally Posted by kartikeya200

This pops up on occasion, but not reliably as to when I'm experience problems:

Code:

[MySQL Error] 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 
 REPLACE INTO `character_bind` (id, zone_id, instance_id, x, y, z, heading, slot) VALUES (12757996, 12757812, 12756388, 0.000000, 0.000000, 0.000000, 0.000000, 1074790400), (0, 1076887552, 0, 0.000000, 0.000000, 0.000000, 0.000000, 1074790400),

I get this every time a character is created, but it still creates the character and everything seems to be fine..

**Uleat** · #25 05-21-2016, 02:37 PM

Quote:

Originally Posted by Mine

id,slot,zone_id,instance_id,x,y,z,heading
1,0,394,0,-2164,-1217,-178,0

versus

Quote:

Originally Posted by Yours [transliterated]

id,slot,zone_id,instance_id,x,y,z,heading
12757996,12757812,1074790400,12756388,0,0,0,0

This looks like either there's a server query issue - not likely if only one character is affected..

..or, you sent info to the client and it didn't like it and is sending a 'status' packet back that, coincidentally, changed your bind point(s).

Try deleting that bind point entry and see if it corrects itself. (Maybe delete them all for that character..pretty sure there's a default that's set if
no info is found.)

EDIT:

Actually, that looks like the data is being parsed out-of-order.

Those big numbers are probably the float entries - x, y, z and heading - converted to integer.

cannon · #26 05-21-2016, 05:16 PM

I think out of order. would that be in the source sending the request to write to the database?

Also, in the character_bind table - any idea what the instance_id is for?

kartikeya200 · #27 05-21-2016, 08:43 PM

Today I moved over the bots to the copied but seemingly unaffected version of my character (it's on a separate account, this appears to be an account issue since another character on that same account also has the same problem).

Spent a number of hours hitting various raid targets and going to affected zones, and used origin (which takes me to Gfay and pretty much guaranteed a desync previously) at least four times. No issues whatsoever. I'm not exactly going to declare this solved just yet, but it's looking that way.

Now if only I had any idea what caused it. Maybe the account was somehow corrupted? The character and bot data seem to be fine (edit: with the exception of bots not zoning and occasionally getting stuck in bot groups, but that seems to be a separate issue and only showed up recently after an update.)

**Uleat** · #28 05-21-2016, 08:50 PM

Do you happen to know the acct id of the affected account?

EDIT:

If you want to start a thread on any particular bot issues, please start it here: http://www.eqemulator.org/forums/forumdisplay.php?f=676

kartikeya200 · #29 05-22-2016, 12:40 AM

76082

Not one that's ever gone through the official login server though.

Edit: what am I saying, yes it has. I need more sleep, clearly.

kartikeya200 · #30 05-30-2016, 07:58 PM

Hooboy. Here I am again.

The copied character has been working fine since my last post, no issues, no problems...until yesterday when I got a strange de-sync in Dreadlands. I've noticed a few more since then, and now trying Howling Stones again, it's especially frequent (although so far, the server is resyncing after a minute or so).

Still not a clue what's going on here.