PRODUCT VERSION: MediaWiki 1.24.2 PHP 5.3.16 (cgi-fcgi) MySQL 5.1.63-cll SMW 2.1.3
Hi everyone. After 1.24 upgrade, I randomly get the error in the subject of this e-mail. A check in the database says that the following tables (but not only and not always the same tables) have some issue:
[tunearch_wikidb.job] warning: 2 clients are using or haven't closed the table properly [tunearch_wikidb.l10n_cache] warning: 2 clients are using or haven't closed the table properly [tunearch_wikidb.msg_resource] warning: 2 clients are using or haven't closed the table properly [tunearch_wikidb.msg_resource_links] warning: 2 clients are using or haven't closed the table properly [tunearch_wikidb.objectcache] warning: 2 clients are using or haven't closed the table properly [tunearch_wikidb.page] warning: 2 clients are using or haven't closed the table properly
The quick and dirty solution to the problem is to make a "*repair DB*" using a feature of the control panel provided by my ISP.
Following is a list of the MW and SMW extensions installed.
Any idea?
*Semantic Drilldown 2.0 * *Semantic Forms 2.8 GPL-2.0+ * *Semantic Forms Inputs 0.7 * *Semantic MediaWiki 2.1.3 * *Semantic Result Formats 1.8 * *SMWAskAPI 0.9 alpha *
*Confirm User Accounts – * *Flagged Revisions – (d32a612) 19:50, 14 April 2015 * *Replace Text 1.0.1 (d31924e) 14:56, 12 April 2015 * *User Merge and Delete 1.9.0 * *Parser hooks*
*Header Tabs 1.0.1 (4f57b96) 15:55, 23 March 2015 * *HTMLets – * *ParserFunctions 1.6.0 * *SidebarDonateBox 1.2.0 * *Spam prevention*
*ConfirmEdit 1.3 *
*DataValues 1.0 GPL-2.0+ * *DataValues Common 0.2.3 GPL-2.0+ * *DataValues Interfaces 0.1.5 GPL-2.0+ * *DataValues Validators 0.1.2 GPL-2.0+ *
*HidePrefix 0.0.1+ (cc7a1a7) 15:55, 23 March 2015 * *Lockdown – * *Mantle – * *MobileFrontend – * *News – * *Preloader 1.1.1 * *redirectAfterLogout 1.0 * *redirectOnLogin 1.1 * *Score 0.3.0 * *SphinxSearch 0.9.0 * *Validator 2.0.4 * *WikiEditor 0.3.0*
Thanks,
Valerio
Hi Valerio,
Those warnings you're seeing seem unrelated to the real error you're experiencing. I would add the following to LocalSettings.php, so you can see the actual error message the next time it happens:
$wgShowSQLErrors = true;
-Yaron
On Sun, Apr 26, 2015 at 1:42 AM, Valerio vmp@silkwood.it wrote:
PRODUCT VERSION: MediaWiki 1.24.2 PHP 5.3.16 (cgi-fcgi) MySQL 5.1.63-cll SMW 2.1.3
Hi everyone. After 1.24 upgrade, I randomly get the error in the subject of this e-mail. A check in the database says that the following tables (but not only and not always the same tables) have some issue:
[tunearch_wikidb.job] warning: 2 clients are using or haven't closed the table properly [tunearch_wikidb.l10n_cache] warning: 2 clients are using or haven't closed the table properly [tunearch_wikidb.msg_resource] warning: 2 clients are using or haven't closed the table properly [tunearch_wikidb.msg_resource_links] warning: 2 clients are using or haven't closed the table properly [tunearch_wikidb.objectcache] warning: 2 clients are using or haven't closed the table properly [tunearch_wikidb.page] warning: 2 clients are using or haven't closed the table properly
The quick and dirty solution to the problem is to make a "*repair DB*" using a feature of the control panel provided by my ISP.
Following is a list of the MW and SMW extensions installed.
Any idea?
*Semantic Drilldown 2.0 * *Semantic Forms 2.8 GPL-2.0+ * *Semantic Forms Inputs 0.7 * *Semantic MediaWiki 2.1.3 * *Semantic Result Formats 1.8 * *SMWAskAPI 0.9 alpha *
*Confirm User Accounts – * *Flagged Revisions – (d32a612) 19:50, 14 April 2015 * *Replace Text 1.0.1 (d31924e) 14:56, 12 April 2015 * *User Merge and Delete 1.9.0 * *Parser hooks*
*Header Tabs 1.0.1 (4f57b96) 15:55, 23 March 2015 * *HTMLets – * *ParserFunctions 1.6.0 * *SidebarDonateBox 1.2.0 * *Spam prevention*
*ConfirmEdit 1.3 *
*DataValues 1.0 GPL-2.0+ * *DataValues Common 0.2.3 GPL-2.0+ * *DataValues Interfaces 0.1.5 GPL-2.0+ * *DataValues Validators 0.1.2 GPL-2.0+ *
*HidePrefix 0.0.1+ (cc7a1a7) 15:55, 23 March 2015 * *Lockdown – * *Mantle – * *MobileFrontend – * *News – * *Preloader 1.1.1 * *redirectAfterLogout 1.0 * *redirectOnLogin 1.1 * *Score 0.3.0 * *SphinxSearch 0.9.0 * *Validator 2.0.4 * *WikiEditor 0.3.0*
Thanks,
Valerio _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
mediawiki-l@lists.wikimedia.org