The following warnings occurred:
Warning [2] Use of undefined constant SAPI_NAME - assumed 'SAPI_NAME' (this will throw an Error in a future version of PHP) - Line: 3388 - File: inc/functions.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/inc/functions.php 3388 errorHandler->error
/showthread.php 116 build_archive_link
Warning [2] Use of undefined constant IN_ARCHIVE - assumed 'IN_ARCHIVE' (this will throw an Error in a future version of PHP) - Line: 3331 - File: inc/functions.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/inc/functions.php 3331 errorHandler->error
/inc/functions.php 3324 build_forum_breadcrumb
/showthread.php 195 build_forum_breadcrumb
Warning [2] Use of undefined constant IN_ARCHIVE - assumed 'IN_ARCHIVE' (this will throw an Error in a future version of PHP) - Line: 3331 - File: inc/functions.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/inc/functions.php 3331 errorHandler->error
/showthread.php 195 build_forum_breadcrumb






Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Problems with MAIN THREAD
Author Message
Shaklaban
Master
**

Posts: 378
Likes Given: 0
Likes Received: 1 in 1 posts
Joined: Mar 2012
Reputation: 8

DOT

Post: #21
RE: Problems with MySQL
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.
(This post was last modified: 08-21-2012 02:50 PM by Shaklaban.)
08-21-2012 02:50 PM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
RanXerox
Master
**

Posts: 550
Likes Given: 1
Likes Received: 12 in 9 posts
Joined: Dec 2010
Reputation: 19



Post: #22
RE: Problems with MySQL
What are your sphere.ini settings for:

SaveBackground
Experimental
OptionFlags
UseAsyncNetwork
NetworkThreads
NetworkThreadPriority
08-21-2012 02:56 PM
Find all posts by this user Like Post Quote this message in a reply
Lazarus
Master
**

Posts: 352
Likes Given: 11
Likes Received: 7 in 6 posts
Joined: Jun 2012
Reputation: 1

Hybris Ultima Online

Post: #23
RE: Problems with MySQL
(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.

[Image: 2hy9q0y.png]
(This post was last modified: 08-21-2012 03:39 PM by Lazarus.)
08-21-2012 03:20 PM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
Shaklaban
Master
**

Posts: 378
Likes Given: 0
Likes Received: 1 in 1 posts
Joined: Mar 2012
Reputation: 8

DOT

Post: #24
RE: Problems with MySQL
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.
08-21-2012 03:48 PM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
Lazarus
Master
**

Posts: 352
Likes Given: 11
Likes Received: 7 in 6 posts
Joined: Jun 2012
Reputation: 1

Hybris Ultima Online

Post: #25
RE: Problems with MySQL
(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...

[Image: 2hy9q0y.png]
(This post was last modified: 08-22-2012 03:27 PM by Lazarus.)
08-22-2012 03:26 PM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
Shaklaban
Master
**

Posts: 378
Likes Given: 0
Likes Received: 1 in 1 posts
Joined: Mar 2012
Reputation: 8

DOT

Post: #26
RE: Problems with MySQL
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.
08-22-2012 03:33 PM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
Lazarus
Master
**

Posts: 352
Likes Given: 11
Likes Received: 7 in 6 posts
Joined: Jun 2012
Reputation: 1

Hybris Ultima Online

Post: #27
RE: Problems with MySQL
(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 ='(

[Image: 2hy9q0y.png]
08-22-2012 03:58 PM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
Shaklaban
Master
**

Posts: 378
Likes Given: 0
Likes Received: 1 in 1 posts
Joined: Mar 2012
Reputation: 8

DOT

Post: #28
RE: Problems with MySQL
hmm maybe when main thread restarted, all values are restarted too.
08-22-2012 03:59 PM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
Lazarus
Master
**

Posts: 352
Likes Given: 11
Likes Received: 7 in 6 posts
Joined: Jun 2012
Reputation: 1

Hybris Ultima Online

Post: #29
RE: Problems with MySQL
(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

[Image: 2hy9q0y.png]
(This post was last modified: 08-22-2012 04:07 PM by Lazarus.)
08-22-2012 04:05 PM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
RanXerox
Master
**

Posts: 550
Likes Given: 1
Likes Received: 12 in 9 posts
Joined: Dec 2010
Reputation: 19



Post: #30
RE: Problems with MySQL
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...
08-23-2012 02:16 AM
Find all posts by this user Like Post Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 17 Guest(s)