Hi everyone,
We are running: * MediaWiki: 1.5.5 * PHP: 4.4.2-0.dotdeb.1 (apache) * MySQL: 4.1.11-Debian_4sarge2-log
Planning to upgrade to MySQL 5.0.
Any issues/problems that we should be aware of?
(yes, we plan to do a full back up first)
Paul
-- Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica
The upgraded to MySQL 5.0 has caused some problems. When we save an article we get this error - though the changes do get saved:
=== A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
REPLACE INTO `yw_searchindex` (si_page,si_title,si_text) VALUES ('5329','fish',' fish and fishing ')
from within function "SearchMySQL4::update". MySQL returned error "1062: Duplicate entry ' ' for key 3 (brane-int)". ===
Previously we had a corruped table: === A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "SearchMySQL4::update". MySQL returned error "145: Table './payo/yw_searchindex' is marked as crashed and should be repaired (brane-int)". === which was repaired and hasn't given any further problems.
We've also run myisamchk against all the tables in the database.
A couple of Wikimedias running 1.4.x are working without any problems on the upgraded system.
Any suggestions?
Paul
On 2/27/06, admin Yellowikis yellowikis@gmail.com wrote:
Hi everyone,
We are running: * MediaWiki: 1.5.5 * PHP: 4.4.2-0.dotdeb.1 (apache) * MySQL: 4.1.11-Debian_4sarge2-log
Planning to upgrade to MySQL 5.0.
Any issues/problems that we should be aware of?
(yes, we plan to do a full back up first)
Paul
-- Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica
-- Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica
Hmmm...
Now we have crashing tables again.
===== A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
SELECT page_id, page_namespace, page_title FROM `yw_page`,`yw_searchindex` WHERE page_id=si_page AND MATCH(si_title) AGAINST('+test' IN BOOLEAN MODE) AND page_is_redirect=0 AND page_namespace IN (0) LIMIT 0,20
from within function "". MySQL returned error "145: Table './payo/yw_searchindex' is marked as crashed and should be repaired (brane-int)".
====
I'll try a re-install/upgrade - maybe that will fix it.
Paul
On 3/9/06, admin Yellowikis yellowikis@gmail.com wrote:
The upgraded to MySQL 5.0 has caused some problems. When we save an article we get this error - though the changes do get saved:
=== A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
REPLACE INTO `yw_searchindex` (si_page,si_title,si_text) VALUES
('5329','fish',' fish and fishing ')
from within function "SearchMySQL4::update". MySQL returned error "1062: Duplicate entry ' ' for key 3 (brane-int)". ===
Previously we had a corruped table:
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "SearchMySQL4::update". MySQL returned error "145: Table './payo/yw_searchindex' is marked as crashed and should be repaired (brane-int)". === which was repaired and hasn't given any further problems.
We've also run myisamchk against all the tables in the database.
A couple of Wikimedias running 1.4.x are working without any problems on the upgraded system.
Any suggestions?
Paul
On 2/27/06, admin Yellowikis yellowikis@gmail.com wrote:
Hi everyone,
We are running: * MediaWiki: 1.5.5 * PHP: 4.4.2-0.dotdeb.1 (apache) * MySQL: 4.1.11-Debian_4sarge2-log
Planning to upgrade to MySQL 5.0.
Any issues/problems that we should be aware of?
(yes, we plan to do a full back up first)
Paul
-- Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica
-- Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica
-- Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica
A second MyISAM check seems to have solved the problem.
You can all stop worrying about it now ;-)
Paul
On 3/10/06, admin Yellowikis yellowikis@gmail.com wrote:
Hmmm...
Now we have crashing tables again.
===== A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
SELECT page_id, page_namespace, page_title FROM
`yw_page`,`yw_searchindex` WHERE page_id=si_page AND MATCH(si_title) AGAINST('+test' IN BOOLEAN MODE) AND page_is_redirect=0 AND page_namespace IN (0) LIMIT 0,20
from within function "". MySQL returned error "145: Table './payo/yw_searchindex' is marked as crashed and should be repaired (brane-int)".
====
I'll try a re-install/upgrade - maybe that will fix it.
Paul
On 3/9/06, admin Yellowikis yellowikis@gmail.com wrote:
The upgraded to MySQL 5.0 has caused some problems. When we save an article we get this error - though the changes do get saved:
=== A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
REPLACE INTO `yw_searchindex` (si_page,si_title,si_text) VALUES
('5329','fish',' fish and fishing ')
from within function "SearchMySQL4::update". MySQL returned error "1062: Duplicate entry ' ' for key 3 (brane-int)". ===
Previously we had a corruped table:
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "SearchMySQL4::update". MySQL returned error "145: Table './payo/yw_searchindex' is marked as crashed and should be repaired (brane-int)". === which was repaired and hasn't given any further problems.
We've also run myisamchk against all the tables in the database.
A couple of Wikimedias running 1.4.x are working without any problems on the upgraded system.
Any suggestions?
Paul
On 2/27/06, admin Yellowikis yellowikis@gmail.com wrote:
Hi everyone,
We are running: * MediaWiki: 1.5.5 * PHP: 4.4.2-0.dotdeb.1 (apache) * MySQL: 4.1.11-Debian_4sarge2-log
Planning to upgrade to MySQL 5.0.
Any issues/problems that we should be aware of?
(yes, we plan to do a full back up first)
Paul
-- Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica
-- Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica
-- Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica
-- Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica
Spoke too soon - problem has returned.
Will try re-installing.
Paul
On 3/10/06, admin Yellowikis yellowikis@gmail.com wrote:
A second MyISAM check seems to have solved the problem.
You can all stop worrying about it now ;-)
Paul
On 3/10/06, admin Yellowikis yellowikis@gmail.com wrote:
Hmmm...
Now we have crashing tables again.
===== A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
SELECT page_id, page_namespace, page_title FROM
`yw_page`,`yw_searchindex` WHERE page_id=si_page AND MATCH(si_title) AGAINST('+test' IN BOOLEAN MODE) AND page_is_redirect=0 AND page_namespace IN (0) LIMIT 0,20
from within function "". MySQL returned error "145: Table './payo/yw_searchindex' is marked as crashed and should be repaired (brane-int)".
====
I'll try a re-install/upgrade - maybe that will fix it.
Paul
On 3/9/06, admin Yellowikis yellowikis@gmail.com wrote:
The upgraded to MySQL 5.0 has caused some problems. When we save an article we get this error - though the changes do get saved:
=== A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
REPLACE INTO `yw_searchindex` (si_page,si_title,si_text) VALUES
('5329','fish',' fish and fishing ')
from within function "SearchMySQL4::update". MySQL returned error "1062: Duplicate entry ' ' for key 3 (brane-int)". ===
Previously we had a corruped table:
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "SearchMySQL4::update". MySQL returned error "145: Table './payo/yw_searchindex' is marked as crashed and should be repaired (brane-int)". === which was repaired and hasn't given any further problems.
We've also run myisamchk against all the tables in the database.
A couple of Wikimedias running 1.4.x are working without any problems on the upgraded system.
Any suggestions?
Paul
On 2/27/06, admin Yellowikis yellowikis@gmail.com wrote:
Hi everyone,
We are running: * MediaWiki: 1.5.5 * PHP: 4.4.2-0.dotdeb.1 (apache) * MySQL: 4.1.11-Debian_4sarge2-log
Planning to upgrade to MySQL 5.0.
Any issues/problems that we should be aware of?
(yes, we plan to do a full back up first)
Paul
-- Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica
-- Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica
-- Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica
-- Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica
-- Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica
* MediaWiki: 1.5.7 * PHP: 4.4.2-0.dotdeb.1 (apache) * MySQL: 5.0.18-Debian_3.dotdeb.1-log
MySQL re-started.
still having problems with search.
Any MySQL gurus out there?
On 3/10/06, admin Yellowikis yellowikis@gmail.com wrote:
Spoke too soon - problem has returned.
Will try re-installing.
Paul
On 3/10/06, admin Yellowikis yellowikis@gmail.com wrote:
A second MyISAM check seems to have solved the problem.
You can all stop worrying about it now ;-)
Paul
On 3/10/06, admin Yellowikis yellowikis@gmail.com wrote:
Hmmm...
Now we have crashing tables again.
===== A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
SELECT page_id, page_namespace, page_title FROM
`yw_page`,`yw_searchindex` WHERE page_id=si_page AND MATCH(si_title) AGAINST('+test' IN BOOLEAN MODE) AND page_is_redirect=0 AND page_namespace IN (0) LIMIT 0,20
from within function "". MySQL returned error "145: Table './payo/yw_searchindex' is marked as crashed and should be repaired (brane-int)".
====
I'll try a re-install/upgrade - maybe that will fix it.
Paul
On 3/9/06, admin Yellowikis yellowikis@gmail.com wrote:
The upgraded to MySQL 5.0 has caused some problems. When we save an article we get this error - though the changes do get saved:
=== A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
REPLACE INTO `yw_searchindex` (si_page,si_title,si_text) VALUES
('5329','fish',' fish and fishing ')
from within function "SearchMySQL4::update". MySQL returned error "1062: Duplicate entry ' ' for key 3 (brane-int)". ===
Previously we had a corruped table:
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "SearchMySQL4::update". MySQL returned error "145: Table './payo/yw_searchindex' is marked as crashed and should be repaired (brane-int)". === which was repaired and hasn't given any further problems.
We've also run myisamchk against all the tables in the database.
A couple of Wikimedias running 1.4.x are working without any problems on the upgraded system.
Any suggestions?
Paul
On 2/27/06, admin Yellowikis yellowikis@gmail.com wrote:
Hi everyone,
We are running: * MediaWiki: 1.5.5 * PHP: 4.4.2-0.dotdeb.1 (apache) * MySQL: 4.1.11-Debian_4sarge2-log
Planning to upgrade to MySQL 5.0.
Any issues/problems that we should be aware of?
(yes, we plan to do a full back up first)
Paul
-- Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica
-- Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica
-- Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica
-- Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica
-- Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica
-- Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica
wikitech-l@lists.wikimedia.org