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: #1
Problems with MAIN THREAD
Code:
22:27:CRITICAL:'Main' thread hang, restarting...
22:30:WARNING:Forcing thread 'Main' to terminate...

22:30:Sphere Version 0.56b-Nightly [WIN32] by www.sphereserver.com, compiled at Jul  2 2012 (00:04:39), internal build #1519
22:30:WARNING: --- WARNING ---

I had to erase the mysql because the server get freezed and somethings sends some like this...

What should I do?
A great scripter have tell's me that change the QUERY for AQUERY and something else that i don't remember ^_^

Any ideas?

Thanks!

Lazarus.

[Image: 2hy9q0y.png]
(This post was last modified: 08-26-2012 07:00 PM by Lazarus.)
08-16-2012 02:52 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: #2
RE: Problems with MySQL
its depended on your sql statements, how many rows you returned from mysql and for what purpose?
08-16-2012 03:02 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: #3
RE: Problems with MySQL
(08-16-2012 03:02 AM)Shaklaban Wrote:  its depended on your sql statements, how many rows you returned from mysql and for what purpose?

Code:
[function f_acc_update]
if !( <DB.connected> )
DB.CONNECT
ENDIF
    DB.QUERY "SELECT * FROM accounts WHERE status='0'"
    if (<DB.ROW.NUMROWS> > 0)
        for R 0 <eval <DB.ROW.NUMROWS>-1>
            serv.account add <DB.ROW.<eval <LOCAL.R>>.login> <DB.ROW.<eval <LOCAL.R>>.password>
            DB.EXECUTE "UPDATE accounts SET status='1' WHERE login='<DB.ROW.<eval <LOCAL.R>>.login>'"
            serv.log MySQL Debug: #<eval <LOCAL.R>> La cuenta "<DB.ROW.<eval <LOCAL.R>>.login>" ha sido creada
        end
    endif

that is the script

it's just create accounts by web.

[Image: 2hy9q0y.png]
08-16-2012 06:24 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: #4
RE: Problems with MySQL
how many accounts created for one instance? for the hang the main thread, thousands of accounts needs to be created.

also if your mysql server is not in the local network your server can always freeze due to slow connection between two servers.
08-16-2012 06:26 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: #5
RE: Problems with MySQL
(08-16-2012 06:26 AM)Shaklaban Wrote:  how many accounts created for one instance? for the hang the main thread, thousands of accounts needs to be created.

also if your mysql server is not in the local network your server can always freeze due to slow connection between two servers.

I guess that's the problem...
I have the mysql server in other server..
Any idea?

The script it's OK?

[Image: 2hy9q0y.png]
(This post was last modified: 08-16-2012 07:20 AM by Lazarus.)
08-16-2012 07:17 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: #6
RE: Problems with MySQL
scripts is ok.
08-16-2012 03:28 PM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
Extreme
Grandmaster Poster
***

Posts: 1,140
Likes Given: 217
Likes Received: 89 in 76 posts
Joined: May 2012
Reputation: 20

SphereCommunity

Post: #7
RE: Problems with MySQL
[function f_acc_update]
if !( <DB.connected> )
DB.CONNECT
ENDIF
DB.QUERY "SELECT * FROM accounts WHERE status='0'"
if (<DB.ROW.NUMROWS> > 0)
for R 0 <eval <DB.ROW.NUMROWS>-1>
serv.account add <DB.ROW.<eval <LOCAL.R>>.login> <DB.ROW.<eval <LOCAL.R>>.password>
DB.EXECUTE "UPDATE accounts SET status='1' WHERE login='<DB.ROW.<eval <LOCAL.R>>.login>'"
serv.log MySQL Debug: #<eval <LOCAL.R>> La cuenta "<DB.ROW.<eval <LOCAL.R>>.login>" ha sido creada
endfor
endif

STEPS BEFORE CREATE A THREAD
- Check the revisions log;
- Use the search button and use the keywords of your problem;
- Check the WIKI;
- Create a thread.
(This post was last modified: 08-16-2012 04:18 PM by Extreme.)
08-16-2012 04:18 PM
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: #8
RE: Problems with MySQL
haha epic Big Grin
08-16-2012 11:27 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: #9
RE: Problems with MySQL
(08-16-2012 04:18 PM)Extreme Wrote:  [function f_acc_update]
if !( <DB.connected> )
DB.CONNECT
ENDIF
DB.QUERY "SELECT * FROM accounts WHERE status='0'"
if (<DB.ROW.NUMROWS> > 0)
for R 0 <eval <DB.ROW.NUMROWS>-1>
serv.account add <DB.ROW.<eval <LOCAL.R>>.login> <DB.ROW.<eval <LOCAL.R>>.password>
DB.EXECUTE "UPDATE accounts SET status='1' WHERE login='<DB.ROW.<eval <LOCAL.R>>.login>'"
serv.log MySQL Debug: #<eval <LOCAL.R>> La cuenta "<DB.ROW.<eval <LOCAL.R>>.login>" ha sido creada
endfor
endif

that's all the problem! :||||||||
god why Sad
[I don't understand of MySQL, my spherescripting SUCKS very much, but... I have a staff with this, I only post in the forums and ask the problems ^_^]

That can be all?

[Image: 2hy9q0y.png]
08-16-2012 11:30 PM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
Extreme
Grandmaster Poster
***

Posts: 1,140
Likes Given: 217
Likes Received: 89 in 76 posts
Joined: May 2012
Reputation: 20

SphereCommunity

Post: #10
RE: Problems with MySQL
Rolleyes
Don't worry, where are there to help when someone need help.

STEPS BEFORE CREATE A THREAD
- Check the revisions log;
- Use the search button and use the keywords of your problem;
- Check the WIKI;
- Create a thread.
08-17-2012 01:05 AM
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)