Page 1 of 1

MARP partially broken

Posted: Mon Jun 13, 2016 6:25 pm
by giro-X
I believe I'm not alone in seeing a crash into some areas of the site.
This is happening when loading "Loads".

Code: Select all

exception! Please copy and paste the text from this page into a mail message to Zwaxy, telling him what you were doing when this happened. And what drugs/medication you were on:
type:
value: (145, "Table './mamereplay/allscores' is marked as crashed and should be repaired")
traceback:
  File "/home/dooglus/replay.marpirc.net/main.py", line 400, in main
    search.do_search(cmd_line)
  File "/home/dooglus/replay.marpirc.net/search.py", line 1012, in do_search
    data = database.select_allscores(where_clauses, joins, sort, maxlines, ignore_string)
  File "/home/dooglus/replay.marpirc.net/database.py", line 246, in select_allscores
    ret = run_query(query, debug)
  File "/home/dooglus/replay.marpirc.net/database.py", line 86, in run_query
    cursor.execute(query)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
The same error message appears when doing any research with any criteria.
"Up" is working (very useful to know there have been 5 new easy first places to catch because nobody played those games, that I missed from my last visit).
Didn't test Submit yet with a real submission.
"Leaders" is a blank page.
No problem with other pages such as Index, 1st, Top3, Confirms, etc.
Experts in IT will laugh at me probably if I say I confirm it doesn't depend on user logged in or visitor, or browser used.

Of course somebody would have noticed it anyway (always if it's not a trouble affecting only me), so making a topic to report what's happening is sort of silly.
I'd like to understand what's happening, and if there's anything that can be done. Considering the visits frequency of Zwaxy lately in the years, dunno how useful is to send him a mail with this error messages.

Re: MARP partially broken

Posted: Mon Jun 13, 2016 7:35 pm
by Zhorik
giro-X wrote:I believe I'm not alone in seeing a crash into some areas of the site.
This is happening when loading "Loads".

Code: Select all

exception! Please copy and paste the text from this page into a mail message to Zwaxy, telling him what you were doing when this happened. And what drugs/medication you were on:
type:
value: (145, "Table './mamereplay/allscores' is marked as crashed and should be repaired")
traceback:
  File "/home/dooglus/replay.marpirc.net/main.py", line 400, in main
    search.do_search(cmd_line)
  File "/home/dooglus/replay.marpirc.net/search.py", line 1012, in do_search
    data = database.select_allscores(where_clauses, joins, sort, maxlines, ignore_string)
  File "/home/dooglus/replay.marpirc.net/database.py", line 246, in select_allscores
    ret = run_query(query, debug)
  File "/home/dooglus/replay.marpirc.net/database.py", line 86, in run_query
    cursor.execute(query)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
The same error message appears when doing any research with any criteria.
"Up" is working (very useful to know there have been 5 new easy first places to catch because nobody played those games, that I missed from my last visit).
Didn't test Submit yet with a real submission.
"Leaders" is a blank page.
No problem with other pages such as Index, 1st, Top3, Confirms, etc.
Experts in IT will laugh at me probably if I say I confirm it doesn't depend on user logged in or visitor, or browser used.

Of course somebody would have noticed it anyway (always if it's not a trouble affecting only me), so making a topic to report what's happening is sort of silly.
I'd like to understand what's happening, and if there's anything that can be done. Considering the visits frequency of Zwaxy lately in the years, dunno how useful is to send him a mail with this error messages.
I'm seeing the same errors. I've sent Zwaxy a PM about the issue and am also trying to get mahlemiut engaged to see if he can help.

Re: MARP partially broken

Posted: Mon Jun 13, 2016 7:52 pm
by giro-X
Working properly again. Thank you for the fix, "person" or "entity" that did the thing. :D
Now, I would like to know how I have to behave if this should happen again in the future.

Re: MARP partially broken

Posted: Mon Jun 13, 2016 9:36 pm
by Zwaxy
Thanks for the PM.

I logged in to look at the error but it was already fixed.

I also got the email alerts working again.

Re: MARP partially broken

Posted: Mon Jun 13, 2016 9:57 pm
by giro-X
Zwaxy wrote:Thanks for the PM.

I logged in to look at the error but it was already fixed.

I also got the email alerts working again.
Good to know, thanks :)

Re: MARP partially broken

Posted: Tue Jun 14, 2016 5:28 am
by Cicca
Zwaxy wrote:Thanks for the PM.
......
I also got the email alerts working again.
Do you mean....those when one of your scores is beaten...?! That's great !!! :)

Re: MARP partially broken

Posted: Tue Jun 14, 2016 11:14 am
by diabolik
Zwaxy wrote: I also got the email alerts working again.
A big thank you for fixing this!

Re: MARP partially broken

Posted: Sat Jul 16, 2016 11:56 pm
by giro-X
It's up again, the error reported on main post of this thread.

Re: MARP partially broken

Posted: Sun Jul 17, 2016 1:20 am
by simpsons99
yes i am getting that message now on everything .. I clicked on the leader board because of the other topic .. Leader Board is completely gone.

Re: MARP partially broken

Posted: Sun Jul 17, 2016 9:00 am
by mahlemiut
Appears to be working again.