Wiki offline?

Jean-Pierre Münch

unread,

Dec 20, 2015, 8:01:04 AM12/20/15

to cryptop...@googlegroups.com

Hey everyone,

I was just about to look something up on our wiki and received an error message.
Is this me or is the wiki software down?

BR

JPM

Page code:

<!DOCTYPE html>
<html><head><title>Database error - Crypto++ Wiki</title><style>body { font-family: sans-serif; margin: 0; padding: 0.5em 2em; }</style></head><body>
<p>A database query error has occurred.
This may indicate a bug in the software.</p><ul><li>Query: <div class="mw-code" dir="ltr">SELECT  page_title,old_text,old_flags  FROM `wikicryptopp_page`,`wikicryptopp_revision`,`wikicryptopp_text`   WHERE page_is_redirect = '0' AND page_namespace = '8' AND (page_title NOT LIKE '%/%' ) AND (page_latest=rev_id) AND (rev_text_id=old_id) AND (page_len &lt;= 10000)  </div></li><li>Function: <code dir="ltr">MessageCache::loadFromDB(en)-small</code></li><li>Error: <samp dir="ltr">145 Table './my_wiki/wikicryptopp_revision' is marked as crashed and should be repaired (localhost)</samp></li></ul></body></html>

Jeffrey Walton

unread,

Dec 20, 2015, 4:05:24 PM12/20/15

to Crypto++ Users

I was just about to look something up on our wiki and received an error message.
Is this me or is the wiki software down?

Page code:

<!DOCTYPE html>
<html><head><title>Database error - Crypto++ Wiki</title><style>body { font-family: sans-serif; margin: 0; padding: 0.5em 2em; }</style></head><body>
<p>A database query error has occurred.
This may indicate a bug in the software.</p><ul><li>Query: <div class="mw-code" dir="ltr">SELECT  page_title,old_text,old_flags  FROM `wikicryptopp_page`,`wikicryptopp_revision`,`wikicryptopp_text`   WHERE page_is_redirect = '0' AND page_namespace = '8' AND (page_title NOT LIKE '%/%' ) AND (page_latest=rev_id) AND (rev_text_id=old_id) AND (page_len &lt;= 10000)  </div></li><li>Function: <code dir="ltr">MessageCache::loadFromDB(en)-small</code></li><li>Error: <samp dir="ltr">145 Table './my_wiki/wikicryptopp_revision' is marked as crashed and should be repaired (localhost)</samp></li></ul></body></html>

jh...@emocha.com

unread,

Dec 28, 2015, 5:00:41 PM12/28/15

to Crypto++ Users

Looks like it is down again

A database query error has occurred. This may indicate a bug in the software.

Query:
SELECT rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,rev_content_format,rev_content_model,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name FROM `wikicryptopp_revision` INNER JOIN `wikicryptopp_page` ON ((page_id = rev_page)) LEFT JOIN `wikicryptopp_user` ON ((rev_user != 0) AND (user_id = rev_user)) WHERE page_id = '2135' AND rev_id = '13037' LIMIT 1
Function: Revision::fetchFromConds
Error: 145 Table './my_wiki/wikicryptopp_revision' is marked as crashed and should be repaired (localhost)

Jeffrey Walton

unread,

Dec 28, 2015, 6:08:36 PM12/28/15

to Crypto++ Users

Fixed, thanks.

----------

MariaDB [my_wiki]>

Jeffrey Walton

unread,

Mar 30, 2016, 9:35:52 AM3/30/16

to Crypto++ Users

I was just about to look something up on our wiki and received an error message.
Is this me or is the wiki software down?

Sorry to dig up an old message. I recently added the mysqlcheck command to the daily backup script:

    # New
mysqlcheck my_wiki --auto-repair --user=<user> --password=<password>

    # Existing
    mysqldump --single-transaction --routines --events --triggers --add-drop-table --extended-insert ...

    # Duplicity
    ...

The mysqlcheck --auto-check should fix all the tables that have problems (I've seen it as high as 25 for our small wiki).

It should be an improvement over me playing whack-a-mole. I hope that squashes the wiki problems once and for all.

Jeff

Reply all

Reply to author

Forward