SphereCommunity
Problems with MAIN THREAD - Printable Version

+- SphereCommunity (https://forum.spherecommunity.net)
+-- Forum: Sphere 0.56d (/Forum-Sphere-0-56d)
+--- Forum: General Help (/Forum-General-Help)
+--- Thread: Problems with MAIN THREAD (/Thread-Problems-with-MAIN-THREAD)

Pages: 1 2 3 4 5 6

RE: Problems with MySQL - Shaklaban - 08-21-2012 02:50 PM

you can control all for loops (for, foritems forchars etc.). another thing is you can enable the ef_script_profiler in sphere.ini. then you can write to console "p#" after server freeze again. it will give you execution time of all functions triggers etc. in profiler_dump.txt. you can find the function which hangs the server from that file.

RE: Problems with MySQL - RanXerox - 08-21-2012 02:56 PM

What are your sphere.ini settings for:

SaveBackground
Experimental
OptionFlags
UseAsyncNetwork
NetworkThreads
NetworkThreadPriority

RE: Problems with MySQL - Lazarus - 08-21-2012 03:20 PM

(08-21-2012 02:56 PM)RanXerox Wrote:  What are your sphere.ini settings for:

SaveBackground
Experimental
OptionFlags
UseAsyncNetwork
NetworkThreads
NetworkThreadPriority

Code:
SaveBackground=0
Experimental=00000
OptionFlags=08|020|02000|010000
UseAsyncNetwork=0
NetworkThreads=0
NetworkThreadPriority=255

Thanks Sad
mbe, the others configs?

Code:
ClientMax=32000
ClientMaxIP=1600
ConnectingMax=32000
ConnectingMaxIp=1600
ClientLinger=15
WalkBuffer=75
DefaultCommandLevel=7
CommandTrigger=f_oncommand
UseAuthID=0
AutoResDisp=5
Secure=1
SectorSleep=10
ForceGarbageCollect=1
FreezeRestartTime=60  // // Time before restarting when server appears hung (in seconds) (this?)
MapCacheTime=120
MaxComplexity=32
MaxItemComplexity=25
MaxSectorComplexity=1024
MaxLoopTimes=0

DeadSocketTime=5
MaxPacketsPerTick=25
MaxPings=15
MaxQueueSize=50
MaxSizePerTick=12000
NetTTL=300
UsePacketPriority=0
UseExtraBuffer=1

any recomendations to this?

-------

(08-21-2012 02:50 PM)Shaklaban Wrote:  you can control all for loops (for, foritems forchars etc.). another thing is you can enable the ef_script_profiler in sphere.ini. then you can write to console "p#" after server freeze again. it will give you execution time of all functions triggers etc. in profiler_dump.txt. you can find the function which hangs the server from that file.


Just... I must wait the UNFREEZE of the server to send a command in the sphereserver. I'll do it the next time Sad.


Should i get the last Sphere Build?

This is the last revision:

24-04-2012, MrSugarCube
- Fixed: Unable to double click console in Windows to open scripts when forward slashes are used
in script paths.

I can't restart the server now, we have players IN.

RE: Problems with MySQL - Shaklaban - 08-21-2012 03:48 PM

your problem is probably caused by one of the scripts, just wait for next freeze and look into profiler dump. you can post your profiler dump to here.

meaning of your error is some of your scripts execution time > 60 seconds.

RE: Problems with MySQL - Lazarus - 08-22-2012 03:26 PM

(08-21-2012 03:48 PM)Shaklaban Wrote:  your problem is probably caused by one of the scripts, just wait for next freeze and look into profiler dump. you can post your profiler dump to here.

meaning of your error is some of your scripts execution time > 60 seconds.

Code:
Profiles OFF: (0 sec total)
Thread 6948, Name=Main
IDLE       =   0.0000s  avg:   0.0000s  [samples:     0  avg:     0 ]  runtime: 1s
OVERHEAD   =   0.0000s  avg:   0.0000s  [samples:     0  avg:     0 ]  runtime: 1s
NETWORK_RX =   0.0000s  avg:   0.0000s  [samples:     0  avg:     0 ]  runtime: 1s
CLIENTS    =   0.0000s  avg:   0.0000s  [samples:     0  avg:     0 ]  runtime: 1s
NETWORK_TX =   0.0000s  avg:   0.0000s  [samples:     0  avg:     0 ]  runtime: 1s
CHARS      =   0.0000s  avg:   0.0000s  [samples:     0  avg:     0 ]  runtime: 1s
ITEMS      =   0.0000s  avg:   0.0000s  [samples:     0  avg:     0 ]  runtime: 1s
MAP        =   0.0000s  avg:   0.0000s  [samples:     0  avg:     0 ]  runtime: 1s
NPC_AI     =   0.0000s  avg:   0.0000s  [samples:     0  avg:     0 ]  runtime: 1s
SCRIPTS    =   0.0000s  avg:   0.0000s  [samples:     0  avg:     0 ]  runtime: 1s
FAULTS     = 0 (total: 0) instances

Nothing..
2 main force in a row... I can't use p# while the MAIN FORCE ... and i use it after...

I can't belive it. I can't do nothing.

Any ideas? ...

I have errors like this:

Code:
02:09:WARNING:de:Unknown game packet (0x20) received.
02:09:WARNING:27f:Unknown game packet (0x30) received.
02:09:WARNING:2ff:Unknown game packet (0x40) received.
02:09:WARNING:30a:Unknown game packet (0x40) received.
02:09:WARNING:373:Unknown game packet (0xff) received.
02:09:WARNING:3a7:Unknown game packet (0x5c) received.
02:09:WARNING:3f8:Unknown game packet (0xd) received.
02:09:WARNING:3a:Unknown game packet (0x20) received.
02:09:WARNING:42:Unknown game packet (0xa) received.
02:09:WARNING:78:Unknown game packet (0xa) received.

When i do resync.

My players are playing....

Can be the wrong try passwords of the players?


that is what can i see before of the main closed...

any wants to see the logs?

Thanks Sad
Im very worried about this...

RE: Problems with MySQL - Shaklaban - 08-22-2012 03:33 PM

there must be list of functions in profiler dump like:

FUNCTION 'page_cevabi_yolla' called 514 times, took 0.8994 msec average (0.1595 min, 16.3308 max), total: 462.3320 msec
FUNCTION 'ikili_ana_cizim' called 43213 times, took 0.3565 msec average (0.0089 min, 36.6434 max), total: 15407.5506 msec

in that section if max of function equals 1000, this means server freeze for 1 second because of that function.

RE: Problems with MySQL - Lazarus - 08-22-2012 03:58 PM

(08-22-2012 03:33 PM)Shaklaban Wrote:  there must be list of functions in profiler dump like:

FUNCTION 'page_cevabi_yolla' called 514 times, took 0.8994 msec average (0.1595 min, 16.3308 max), total: 462.3320 msec
FUNCTION 'ikili_ana_cizim' called 43213 times, took 0.3565 msec average (0.0089 min, 36.6434 max), total: 15407.5506 msec

in that section if max of function equals 1000, this means server freeze for 1 second because of that function.

Code:
Profiles OFF: (0 sec total)
Thread 6948, Name=Main
IDLE       =   0.0000s  avg:   0.0000s  [samples:     0  avg:     0 ]  runtime: 1s
OVERHEAD   =   0.0000s  avg:   0.0000s  [samples:     0  avg:     0 ]  runtime: 1s
NETWORK_RX =   0.0000s  avg:   0.0000s  [samples:     0  avg:     0 ]  runtime: 1s
CLIENTS    =   0.0000s  avg:   0.0000s  [samples:     0  avg:     0 ]  runtime: 1s
NETWORK_TX =   0.0000s  avg:   0.0000s  [samples:     0  avg:     0 ]  runtime: 1s
CHARS      =   0.0000s  avg:   0.0000s  [samples:     0  avg:     0 ]  runtime: 1s
ITEMS      =   0.0000s  avg:   0.0000s  [samples:     0  avg:     0 ]  runtime: 1s
MAP        =   0.0000s  avg:   0.0000s  [samples:     0  avg:     0 ]  runtime: 1s
NPC_AI     =   0.0000s  avg:   0.0000s  [samples:     0  avg:     0 ]  runtime: 1s
SCRIPTS    =   0.0000s  avg:   0.0000s  [samples:     0  avg:     0 ]  runtime: 1s
FAULTS     = 0 (total: 0) instances

Nope Sad
I don't know what is happend ='(

RE: Problems with MySQL - Shaklaban - 08-22-2012 03:59 PM

hmm maybe when main thread restarted, all values are restarted too.

RE: Problems with MySQL - Lazarus - 08-22-2012 04:05 PM

(08-22-2012 03:59 PM)Shaklaban Wrote:  hmm maybe when main thread restarted, all values are restarted too.

Again! fuuuuufufufufufufu
I'd used yet the p#...

Let's see whats we get when the server UNFREEZES...

Can be this:

Code:
03:06:ERROR:dc:Bad Login 10 (Encryption error (packet length does not match what was expected))
03:06:ERROR:(sphere_admin.scp,249)Can't resolve <clientversion>
03:06:ERROR:(sphere_admin.scp,249)Can't resolve <reportedcliver>


// Set this to 0 to allow login to encrypted clients
UseCrypt=1

// Set this to 1 to allow login to unencrypted clients
UseNoCrypt=1

RE: Problems with MySQL - RanXerox - 08-23-2012 02:16 AM

When did this start happening? List all the script files on your shard by the last date/time that they were modified and look closely at the files where the last modfified date is after the date when this started...