Graal Forums - UC Playerworld lag

Graal Forums (https://forums.graalonline.com/forums/index.php)

- Bug Report (https://forums.graalonline.com/forums/forumdisplay.php?f=193)

- - UC Playerworld lag (https://forums.graalonline.com/forums/showthread.php?t=134267994)

UC Playerworld lag

I'm experiencing some really bad serverside lag on my UC playerworld 'Serenity.' I've noticed that it is taking classes anywhere from 20-90+ seconds to load on login. I don't think it's any of my code as nothing has changed since last night when it was working fine. I've restarted the NPC-Server and that did not help. Is anyone else experiencing the same thing or have any suggestions on things to try? I have a limited amount of time each week to play around on it so when things like this happen it really hinders my ability to do anything. I just need to figure out if it's user error or an issue that others are experiencing.

edit: added /stats

PHP Code:


		
			
GServer statistics:
Server uptime: 679 hrs 14 mins
Max supported players: 16384
Sleeptime (secs/min): 59401
Connection tries (last min): 3
Players-in (byte/l.m.): 4723
Players-out (byte/l.m.): 6433
RCs-in (byte/last min): 123
RCs-out (byte/last min): 2505
NPCServer-in (byte/l.m.): 14569
NPCServer-out (byte/l.m.): 5448
ServerList-in (byte/l.m.): 4045
ServerList-out (byte/l.m.): 0
Player-avrg-in (bit/sec): 257
Player-avrg-out (bit/sec): 1472
TSockets-in (byte/l.m.): 0
TSockets-out (byte/l.m.): 0
Levels: 3
Players: 1
RCs: 2
NPCServers: 1
ServerListers: 1
Memory (bytes): 2668536
Players connecting: 0
Script engine: 0 event objects, 3 destroyed objects, 1 static objects, 6 global variables, 3 script machines
NPC-Server statistics:
Server uptime: 0 hrs 58 mins
Sleeptime (secs/min): 56515
Scriptime (last min): 56600
Connectiontries (last min): 0
NCs-in (byte/last min): 87
NCs-out (byte/last min): 0
GServer-in (byte/l.m.): 12744
GServer-out (byte/l.m.): 15007
TSockets-in (byte/l.m.): 0
TSockets-out (byte/l.m.): 0
Levels: 75
Active Levels: 13
NPCs: 195
Active Objects: 0
DB-NPCs: 5
NPC-Placeholder: 15
Projectiles: 0
Players: 3
NC count: 1
GServers: 1
Memory (bytes): 5313240
Top 10 of npcs taken most CPU time:
1. 13.443266948 % -*System/Inventory
2. 0.002356767 % -*System/Combat
3. 0.001707474 % -*System/Regeneration
4. 0.000168482 % Control-NPC
5. 0.000164906 % -*System/ImageUploader
6. 0.000023444 % npcs[200] (in level central_a-3.nw at pos (53, 10)) (object_tree)
7. 0.000016689 % npcs[180] (in level central_a-2.nw at pos (50, 0)) (object_sign)
8. 0.000008344 % npcs[181] (in level central_a-2.nw at pos (24, 10)) (object_tree)
9. 0.000006755 % npcs[202] (in level central_a-3.nw at pos (35, 23)) (object_tree)
10. 0.000006357 % npcs[208] (in level central_a-3.nw at pos (47, 61)) (object_tree)
Most used classes:
1. object_tree: 108 times
2. object_waterrock: 26 times
3. object_rock: 7 times
4. object_rock4: 7 times
5. functions_sql: 4 times
6. object_rock2: 4 times
7. object_rock3: 4 times
8. object_sign: 2 times
9. object_rock5: 2 times
10. : 1 times
Script engine: 0 event objects, 2 destroyed objects, 0 static objects, 36 global variables, 4 script machines

/memstats

PHP Code:


		
			
Memory taken by objects: 2053240

EDIT 2: I've determined it's an issue with the server by commenting out everything.

It would leave me to believe some other UC server is hogging all the resources.

Quote:

Originally Posted by fowlplay4 (Post 1714994)

It would leave me to believe some other UC server is hogging all the resources.

That is what I was assuming as well. It's currently making mine unusable. I thought there was a way on graal.us to view what servers are on the same machine but I looked and guess there isn't.

There was a DBNPC that I did not comment out and I determined that the following query was causing lag out of nowhere when it's been working for months so this is more of a coding question than a bug report now.

PHP Code:


		
			


temp.query = "UPDATE player_items SET equipped='1' WHERE playeraccount='" @ player.account @ "' AND itemid='" @ itemid @ "'";

Once again, I'm incorrect. I have now removed every piece of code from the server and I'm still experiencing the same issues. It turns out that whenever I do a query for ANYTHING in the SQLite database it locks up. Even dropping empty tables cause a 2+ minute freeze on the serverside.

Did you try deleting your SQLite db file?

Quote:

Originally Posted by fowlplay4 (Post 1715012)

Did you try deleting your SQLite db file?

No, it seems it only occurs when writing to the database but not requesting data from it. Also I feel like just deleting the databse isn't a very good resolution to the issue. It's just not practical if you have a live server not that it is a live classic server but I'd prefer to know whats causing it so I can take preventive measures to keep it from happening again. As a last resort I will delete the database but I just don't see it being practical.

Well make a backup of the database but starting from a fresh one should at least help you narrow down where the issue is.

There were some network problems which we are working on.

Quote:

Originally Posted by Stefan (Post 1715040)

There were some network problems which we are working on.

Also on RC on Era constantly getting disconnected now as well as a message spamming my RC saying "You don't have admin rights", so frustrating when scripting as I've got to exit RC.

Quote:

Originally Posted by Stefan (Post 1715040)

There were some network problems which we are working on.

Were they effecting just writing to a SQLite database?

Quote:

Originally Posted by DazJenova (Post 1715061)

Also on RC on Era constantly getting disconnected now as well as a message spamming my RC saying "You don't have admin rights", so frustrating when scripting as I've got to exit RC.

i remember that happening when i put in my email as account i think, try to enter your actual account or vice versa

Quote:

Originally Posted by callimuc (Post 1715074)

i remember that happening when i put in my email as account i think, try to enter your actual account or vice versa

I don't think old accounts can even log in using their mail.

Quote:

Originally Posted by Crow (Post 1715076)

I don't think old accounts can even log in using their mail.

It lets me log in via shrimps or my email, but I don't like that as it shows my email in history window. =/

Ok these network problems need to be fixed ASAP, I get DC'd every 10 mins, my IP gets reset to the server IP, my rights get wiped, I get the "You have no admin rights" spam... what's going on D;