TinyMUSH/MySQL Crash Issue
Ok, I'm pretty sure this is the wrong group to ask, but I'm not getting
an answer from the TinyMUSH list.
I have my MUSH setup to connect with MySQL to record logins/outs and
announcements so that they can be seen from both inside the MUSH and
from the web. The problem that I'm having is after a time the
connection between MySQL and the MUSH dies and when the MUSH tries to
reconnect, it crashes. The only message I have is this:
070710.123403 The Promethean Project NET/CONN : [7/10.0.0.101]
Connection opened (remote port 49642)
070710.123403 The Promethean Project CON/LOGIN: [7/10.0.0.101]
Connected to Fox(#32) in Fox's Den(#35)
070710.123403 The Promethean Project SQL/GONE : Connection died to SQL
server
070710.123403 The Promethean Project SQL/DISC : Disconnected from SQL
server localhost, SQL database selected: mush
070710.123403 The Promethean Project SIG/CATCH: Caught signal SIGSEGV
070710.123403 The Promethean Project BUG/INFO : Command:
'[ifelse([haspower(%#,guest)],[trigger(GUEST,%#)],[setq(0,#[sql([SELECT
dbref FROM player WHERE
dbref=[last(%#,#)]])])][switch(%q0,#-1,[pemit(%=<STAFF>,[%xiGAME:%xn
MySQL is broken
again.])][trigger(emit,%#)],[switch(%q0,#,[setq(1,[sql([INSERT INTO
player SET dbref=[last(%#,#)], name='[capstr(name(%#))]',
last_conn='[convtime(time())]'])])][trigger(first,%#)],[setq(1,[sql([UPD
ATE player SET last_conn='[convtime(time())]' WHERE
dbref=[last(%#,#)]])])][trigger(emit,%#)])])])]'
070710.123403 The Promethean Project BUG/INFO : Player:
Anyone have any suggestions on what I can try to get more information
or fix this? I've sent this same quesion to the tinymush list and all
they told me was to read the log file and run ReportCrash (which did
nothing, just complained about not being able to find a 'non-zero byte
core file').
Sorry for the spam :/
Reply to: