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
Lazarus
Master
**

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

Hybris Ultima Online

Post: #31
RE: Problems with MySQL
(08-23-2012 02:16 AM)RanXerox Wrote:  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...

I don't know when... I have very problems with this Sad

anyone can see them? I can just send my custom script folder.

Thanks Sad

[Image: 2hy9q0y.png]
08-23-2012 11:54 AM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
darksun84
Sir Spamalot
****

Posts: 1,687
Likes Given: 245
Likes Received: 162 in 151 posts
Joined: Mar 2012
Reputation: 35



Post: #32
RE: Problems with MySQL
have you enabled the flag for activating script profiler Big Grin ?

EF_Script_Profiler = 00000400


it's under experimental flags
08-23-2012 12:26 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: #33
RE: Problems with MySQL
(08-23-2012 12:26 PM)darksun84 Wrote:  have you enabled the flag for activating script profiler Big Grin ?

EF_Script_Profiler = 00000400


it's under experimental flags


Experimental= 00000

:'(

[Image: 2hy9q0y.png]
08-23-2012 01:13 PM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
darksun84
Sir Spamalot
****

Posts: 1,687
Likes Given: 245
Likes Received: 162 in 151 posts
Joined: Mar 2012
Reputation: 35



Post: #34
RE: Problems with MySQL
yes, that's why the profiler showed you nothing
08-23-2012 01:14 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: #35
RE: Problems with MySQL
(08-23-2012 01:14 PM)darksun84 Wrote:  yes, that's why the profiler showed you nothing

I should put that experimental, and then, use p# when the server freezes?


Thanks.


I need to restart the server when I change that flag? or I can resync?

[Image: 2hy9q0y.png]
08-23-2012 01:22 PM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
darksun84
Sir Spamalot
****

Posts: 1,687
Likes Given: 245
Likes Received: 162 in 151 posts
Joined: Mar 2012
Reputation: 35



Post: #36
RE: Problems with MySQL
i suggest to restart the server!
08-23-2012 01:29 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: #37
RE: Problems with MySQL
(08-23-2012 01:29 PM)darksun84 Wrote:  i suggest to restart the server!

Code:
Profiles OFF: (0 sec total)
Thread 2652, 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
Scripts: called 2965162 times and took 323523.9449 msec (0.1089 msec average). Reporting with highest average.
FUNCTION 'f_chequeo_dex' called 19217 times, took 0.2732 msec average (0.2240 min, 7.0880 max), total: 5251.3632 msec
FUNCTION 'check_account_typedef' called 9 times, took 1.2064 msec average (0.5970 min, 1.3959 max), total: 10.8588 msec
FUNCTION 'f_check_typedefs' called 24 times, took 0.3744 msec average (0.1967 min, 0.8840 max), total: 8.9918 msec
FUNCTION 'f_fix_house_chars' called 7 times, took 1.0016 msec average (0.5526 min, 2.8949 max), total: 7.0134 msec
FUNCTION 'f_check_house_chars' called 7 times, took 0.7974 msec average (0.4003 min, 2.7130 max), total: 5.5836 msec
FUNCTION 'area' called 3 times, took 0.1570 msec average (0.1514 min, 0.1656 max), total: 0.4710 msec
FUNCTION 'f_remove_keys' called 3 times, took 1.7219 msec average (1.3769 min, 1.9089 max), total: 5.1665 msec
FUNCTION 'isfriend' called 183 times, took 0.8242 msec average (0.0377 min, 2.0597 max), total: 150.8597 msec
FUNCTION 'house_find_guild' called 4 times, took 0.5417 msec average (0.1536 min, 1.0310 max), total: 2.1676 msec
FUNCTION 'addgold_bank' called 2 times, took 0.3123 msec average (0.3020 min, 0.3229 max), total: 0.6250 msec
FUNCTION 'f_add_gold' called 2 times, took 0.1620 msec average (0.1609 min, 0.1634 max), total: 0.3243 msec
FUNCTION 'f_house_demolish' called 2 times, took 1.8594 msec average (0.4875 min, 3.2316 max), total: 3.7191 msec
FUNCTION 'f_autotele' called 7461 times, took 0.2014 msec average (0.0860 min, 6.5012 max), total: 1504.6725 msec
FUNCTION 'isbanned' called 85 times, took 1.4205 msec average (1.2914 min, 2.4040 max), total: 120.7510 msec
FUNCTION 'f_terminada2' called 2 times, took 0.4252 msec average (0.4252 min, 0.4255 max), total: 0.8507 msec
FUNCTION 'f_terminada' called 2 times, took 0.3755 msec average (0.3643 min, 0.3869 max), total: 0.7513 msec
FUNCTION 'f_terminada3' called 2 times, took 0.4101 msec average (0.4001 min, 0.4202 max), total: 0.8203 msec
FUNCTION 'estado' called 13 times, took 2.5020 msec average (2.0254 min, 2.8955 max), total: 32.5283 msec
FUNCTION 'f_onserver_save_ok' called 43 times, took 0.2497 msec average (0.1905 min, 0.5227 max), total: 10.7468 msec
FUNCTION 'f_lower_stat' called 14 times, took 1.2517 msec average (1.0874 min, 1.9569 max), total: 17.5244 msec
FUNCTION 'list' called 17 times, took 6.5853 msec average (5.6602 min, 8.2425 max), total: 111.9547 msec
FUNCTION 'list_renderdialog' called 42 times, took 1.7915 msec average (0.4202 min, 2.6510 max), total: 75.2495 msec
FUNCTION 'admin' called 102 times, took 9.8094 msec average (8.5644 min, 17.4504 max), total: 1000.5867 msec
FUNCTION 'admin_renderdialog' called 178 times, took 4.3062 msec average (0.3484 min, 9.7454 max), total: 766.5540 msec
FUNCTION 'f_check_armor' called 37 times, took 0.1282 msec average (0.0670 min, 0.3657 max), total: 4.7499 msec
FUNCTION 'helppage' called 12 times, took 0.1804 msec average (0.0975 min, 0.6574 max), total: 2.1673 msec
FUNCTION 'telenextchar' called 155 times, took 0.5101 msec average (0.1438 min, 2.4054 max), total: 79.1025 msec
FUNCTION 'follow' called 2 times, took 0.2718 msec average (0.2707 min, 0.2729 max), total: 0.5437 msec
FUNCTION 'g' called 15 times, took 1.8913 msec average (1.6088 min, 2.9770 max), total: 28.3710 msec
FUNCTION 'stuck' called 6 times, took 0.3025 msec average (0.2740 min, 0.3542 max), total: 1.8158 msec
FUNCTION 'f_house_lock' called 4 times, took 0.3783 msec average (0.0885 min, 0.7845 max), total: 1.5132 msec
FUNCTION 'f_unfreeze' called 3 times, took 0.5722 msec average (0.5370 min, 0.6068 max), total: 1.7169 msec
FUNCTION 'accadd' called 5 times, took 1.5828 msec average (1.4492 min, 1.7896 max), total: 7.9145 msec
FUNCTION 'static' called 1 times, took 4.5143 msec average (4.5143 min, 4.5143 max), total: 4.5143 msec
FUNCTION 'static_' called 1 times, took 0.2263 msec average (0.2263 min, 0.2263 max), total: 0.2263 msec
FUNCTION 'f_house_add_coowner' called 3 times, took 1.7175 msec average (1.5864 min, 1.9362 max), total: 5.1528 msec
FUNCTION 'f_house_release' called 1 times, took 0.5663 msec average (0.5663 min, 0.5663 max), total: 0.5663 msec
TRIGGER '@itemdclick' called 715294 times, took 0.1637 msec average (0.1005 min, 55.8438 max), total: 117179.8597 msec
TRIGGER '@targon_char' called 365207 times, took 0.2654 msec average (0.0447 min, 54.7588 max), total: 96983.7929 msec
TRIGGER '@start' called 56444 times, took 0.1427 msec average (0.0181 min, 13.8393 max), total: 8062.5361 msec
TRIGGER '@equip' called 19375 times, took 0.2914 msec average (0.0393 min, 7.1084 max), total: 5648.9633 msec
TRIGGER '@spellsuccess' called 27815 times, took 0.1394 msec average (0.1092 min, 4.7594 max), total: 3881.7588 msec
TRIGGER '@spelleffect' called 27210 times, took 0.1184 msec average (0.0480 min, 12.0326 max), total: 3228.8658 msec
TRIGGER '@dropon_self' called 4455 times, took 0.2106 msec average (0.1715 min, 2.0002 max), total: 939.2757 msec
TRIGGER '@death' called 205 times, took 0.1385 msec average (0.0491 min, 6.4738 max), total: 28.4355 msec
TRIGGER '@targon_ground' called 8 times, took 0.1120 msec average (0.0611 min, 0.3330 max), total: 0.8971 msec
TRIGGER '@personalspace' called 74 times, took 0.3607 msec average (0.2855 min, 0.5104 max), total: 26.6948 msec
TRIGGER '@npcheargreeting' called 303 times, took 0.3526 msec average (0.2905 min, 1.5733 max), total: 106.9189 msec
TRIGGER '@userwarmode' called 7 times, took 0.1411 msec average (0.1072 min, 0.1821 max), total: 0.9893 msec
TRIGGER '@npchearunknown' called 188 times, took 0.7982 msec average (0.6518 min, 4.2478 max), total: 150.1098 msec
TRIGGER '@targon_item' called 1 times, took 0.1754 msec average (0.1754 min, 0.1754 max), total: 0.1754 msec
TRIGGER '@logout' called 1 times, took 0.1626 msec average (0.1626 min, 0.1626 max), total: 0.1626 msec

This is a normal p#

[Image: 2hy9q0y.png]
(This post was last modified: 08-24-2012 12:14 AM by Lazarus.)
08-23-2012 01:37 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: #38
RE: Problems with MySQL
Mbe this in the sphere.ini ? Shock
Code:
FreezeRestartTime=60

up here is the new p#



AFter a freeze:

Code:
Scripts: called 3055525 times and took 332273.9712 msec (0.1086 msec average). Reporting with highest average.
FUNCTION 'f_chequeo_dex' called 19416 times, took 0.2732 msec average (0.2240 min, 7.0880 max), total: 5308.5322 msec
FUNCTION 'check_account_typedef' called 9 times, took 1.2064 msec average (0.5970 min, 1.3959 max), total: 10.8588 msec
FUNCTION 'f_check_typedefs' called 24 times, took 0.3744 msec average (0.1967 min, 0.8840 max), total: 8.9918 msec
FUNCTION 'f_fix_house_chars' called 7 times, took 1.0016 msec average (0.5526 min, 2.8949 max), total: 7.0134 msec
FUNCTION 'f_check_house_chars' called 7 times, took 0.7974 msec average (0.4003 min, 2.7130 max), total: 5.5836 msec
FUNCTION 'area' called 3 times, took 0.1570 msec average (0.1514 min, 0.1656 max), total: 0.4710 msec
FUNCTION 'f_remove_keys' called 3 times, took 1.7219 msec average (1.3769 min, 1.9089 max), total: 5.1665 msec
FUNCTION 'isfriend' called 192 times, took 0.8407 msec average (0.0377 min, 2.0597 max), total: 161.4221 msec
FUNCTION 'house_find_guild' called 4 times, took 0.5417 msec average (0.1536 min, 1.0310 max), total: 2.1676 msec
FUNCTION 'addgold_bank' called 2 times, took 0.3123 msec average (0.3020 min, 0.3229 max), total: 0.6250 msec
FUNCTION 'f_add_gold' called 2 times, took 0.1620 msec average (0.1609 min, 0.1634 max), total: 0.3243 msec
FUNCTION 'f_house_demolish' called 2 times, took 1.8594 msec average (0.4875 min, 3.2316 max), total: 3.7191 msec
FUNCTION 'f_autotele' called 7475 times, took 0.2014 msec average (0.0860 min, 6.5012 max), total: 1507.3777 msec
FUNCTION 'isbanned' called 101 times, took 1.4708 msec average (1.2914 min, 2.7675 max), total: 148.5593 msec
FUNCTION 'f_terminada2' called 2 times, took 0.4252 msec average (0.4252 min, 0.4255 max), total: 0.8507 msec
FUNCTION 'f_terminada' called 2 times, took 0.3755 msec average (0.3643 min, 0.3869 max), total: 0.7513 msec
FUNCTION 'f_terminada3' called 2 times, took 0.4101 msec average (0.4001 min, 0.4202 max), total: 0.8203 msec
FUNCTION 'estado' called 16 times, took 2.6705 msec average (2.0254 min, 3.9027 max), total: 42.7328 msec
FUNCTION 'f_onserver_save_ok' called 49 times, took 0.2360 msec average (0.0511 min, 0.5227 max), total: 11.5755 msec
FUNCTION 'f_lower_stat' called 14 times, took 1.2517 msec average (1.0874 min, 1.9569 max), total: 17.5244 msec
FUNCTION 'list' called 24 times, took 5.9633 msec average (2.1855 min, 9.8072 max), total: 143.1246 msec
FUNCTION 'list_renderdialog' called 49 times, took 1.6870 msec average (0.3400 min, 2.6510 max), total: 82.6714 msec
FUNCTION 'admin' called 102 times, took 9.8094 msec average (8.5644 min, 17.4504 max), total: 1000.5867 msec
FUNCTION 'admin_renderdialog' called 178 times, took 4.3062 msec average (0.3484 min, 9.7454 max), total: 766.5540 msec
FUNCTION 'f_check_armor' called 37 times, took 0.1282 msec average (0.0670 min, 0.3657 max), total: 4.7499 msec
FUNCTION 'helppage' called 13 times, took 0.1777 msec average (0.0975 min, 0.6574 max), total: 2.3115 msec
FUNCTION 'telenextchar' called 160 times, took 0.5054 msec average (0.1438 min, 2.4054 max), total: 80.9052 msec
FUNCTION 'follow' called 2 times, took 0.2718 msec average (0.2707 min, 0.2729 max), total: 0.5437 msec
FUNCTION 'g' called 15 times, took 1.8913 msec average (1.6088 min, 2.9770 max), total: 28.3710 msec
FUNCTION 'stuck' called 8 times, took 0.3039 msec average (0.2740 min, 0.3542 max), total: 2.4336 msec
FUNCTION 'f_house_lock' called 4 times, took 0.3783 msec average (0.0885 min, 0.7845 max), total: 1.5132 msec
FUNCTION 'f_unfreeze' called 5 times, took 0.5400 msec average (0.4101 min, 0.6068 max), total: 2.7015 msec
FUNCTION 'accadd' called 5 times, took 1.5828 msec average (1.4492 min, 1.7896 max), total: 7.9145 msec
FUNCTION 'static' called 1 times, took 4.5143 msec average (4.5143 min, 4.5143 max), total: 4.5143 msec
FUNCTION 'static_' called 1 times, took 0.2263 msec average (0.2263 min, 0.2263 max), total: 0.2263 msec
FUNCTION 'f_house_add_coowner' called 3 times, took 1.7175 msec average (1.5864 min, 1.9362 max), total: 5.1528 msec
FUNCTION 'f_house_release' called 1 times, took 0.5663 msec average (0.5663 min, 0.5663 max), total: 0.5663 msec
TRIGGER '@itemdclick' called 721681 times, took 0.1637 msec average (0.1005 min, 55.8438 max), total: 118300.8868 msec
TRIGGER '@targon_char' called 367016 times, took 0.2668 msec average (0.0447 min, 54.7588 max), total: 97941.8169 msec
TRIGGER '@start' called 65027 times, took 0.1436 msec average (0.0279 min, 13.8393 max), total: 9339.8281 msec
TRIGGER '@equip' called 19574 times, took 0.2917 msec average (0.0393 min, 7.1084 max), total: 5710.0008 msec
TRIGGER '@spellsuccess' called 29930 times, took 0.1405 msec average (0.1092 min, 4.7594 max), total: 4210.0416 msec
TRIGGER '@spelleffect' called 29315 times, took 0.1184 msec average (0.0349 min, 12.0326 max), total: 3473.1930 msec
TRIGGER '@dropon_self' called 4504 times, took 0.2112 msec average (0.1715 min, 2.0002 max), total: 951.7203 msec
TRIGGER '@death' called 210 times, took 0.1380 msec average (0.0491 min, 6.4738 max), total: 29.0245 msec
TRIGGER '@targon_ground' called 8 times, took 0.1120 msec average (0.0611 min, 0.3330 max), total: 0.8971 msec
TRIGGER '@personalspace' called 78 times, took 0.3615 msec average (0.2855 min, 0.5104 max), total: 28.2062 msec
TRIGGER '@npcheargreeting' called 319 times, took 0.3537 msec average (0.2905 min, 1.5733 max), total: 112.9097 msec
TRIGGER '@effect' called 25 times, took 0.1095 msec average (0.0469 min, 0.6851 max), total: 2.7429 msec
TRIGGER '@userwarmode' called 7 times, took 0.1411 msec average (0.1072 min, 0.1821 max), total: 0.9893 msec
TRIGGER '@npchearunknown' called 192 times, took 0.7977 msec average (0.6518 min, 4.2478 max), total: 153.2087 msec
TRIGGER '@targon_item' called 7 times, took 0.1978 msec average (0.1673 min, 0.2279 max), total: 1.3855 msec
TRIGGER '@logout' called 1 times, took 0.1626 msec average (0.1626 min, 0.1626 max), total: 0.1626 msec

[Image: 2hy9q0y.png]
(This post was last modified: 08-24-2012 02:15 AM by Lazarus.)
08-24-2012 12:27 AM
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: #39
RE: Problems with MySQL
lazarus i cant send you pm it says blocked so my answer:

none of them can freeze the server for 60 seconds, can you try the server with fresh sphere.ini after restart? maybe one of your settings cause this or not but you can be sure about that with changing the .ini
(This post was last modified: 08-25-2012 03:33 AM by Shaklaban.)
08-25-2012 03:33 AM
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: #40
RE: Problems with MySQL
(08-25-2012 03:33 AM)Shaklaban Wrote:  lazarus i cant send you pm it says blocked so my answer:

none of them can freeze the server for 60 seconds, can you try the server with fresh sphere.ini after restart? maybe one of your settings cause this or not but you can be sure about that with changing the .ini


yaya i will change the sphere.ini Sad

very thanks! rly.

[Image: 2hy9q0y.png]
08-25-2012 05:46 AM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
Post Reply 


Forum Jump:


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