Hi,
I get an error when executing the query
{{#ask:[[Category:MainArticle]][[Chromosome
Name::2L]][[Anopheles:+||Plasmodium:+]]|format=count}}
(by using just one of the two namespaces alone the query returns 3054 and
0 resp. as result without error;
using '[[Category:MainArticle]][[Chromosome Name::2L]] <q>[[Anopheles:+]]
OR [[Plasmodium:+]]</q>' gives, however, the same error)
The error message:
A database query syntax error has occurred. This may indicate a bug in the
software. The last attempted database query was:
INSERT IGNORE INTO `mbw_t5` SELECT t7.smw_id FROM `mbw_smw_ids` AS t7
WHERE t7.smw_namespace='206'
from within function "SMW::executeQueries". Database returned error "1114:
The table 'mbw_t5' is full (localhost:/mysql/mysql.sock)".
The DEBUG mode gives:
Debug Output by SMWSQLStore2
Generated Wiki-Query
[[Category:MainArticle]] [[Chromosome Name::2L]] <q>[[Anopheles:+]] OR
[[Plasmodium:+]]</q>
Query Metrics
Query-Size:5
Query-Depth:1
SQL Query
SELECT DISTINCT t8.smw_title AS t,t8.smw_namespace AS ns FROM
`mbw_smw_ids` AS t8 INNER JOIN `mbw_smw_inst2` AS t1 ON t8.smw_id=t1.s_id
INNER JOIN `mbw_smw_atts2` AS t3 ON t1.s_id=t3.s_id INNER JOIN `mbw_t5` AS
t5 ON t1.s_id=t5.id WHERE (t1.o_id='680' AND ((t3.value_xsd='2L') AND
t3.p_id='91')) ORDER BY t8.smw_sortkey ASC LIMIT 51 OFFSET 0;
Auxilliary Tables Used
* Temporary table t5
INSERT IGNORE INTO `mbw_t5` SELECT t6.smw_id FROM `mbw_smw_ids` AS
t6 WHERE t6.smw_namespace='206'
INSERT IGNORE INTO `mbw_t5` SELECT t7.smw_id FROM `mbw_smw_ids` AS
t7 WHERE t7.smw_namespace='208'
Errors and Warnings
None
There seems to be too many pages in both namespaces together for the temp
table (one namespace contains 3872175 smw_id entries and the other 96142
entries in the mbw_smw_ids table).
Are temp tables like mbw_t5 created as InnoDB tables or with
'ENGINE=MEMORY'?
As far as I can see SMW uses for its normal tables InnoDB. I don't have
any specific configuration for InnoDB so the data are stored in the default
/data/ibdata1 file which has a size of 6.7GB.
I don't have much MySQL config experience. Would something like
'innodb_data_file_path = ibdata1:10M:autoextend' or 'innodb_file_per_table'
solve the problem? Or changing other settings?
There is no limitation with the actual free disk space as far as I can
see.
Using:
MediaWiki 1.19.1
PHP 5.4.4 (apache2handler)
MySQL 5.5.0-m2-log
Semantic MediaWiki (Version 1.8 alpha) (r115105)
Thanks.
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Semediawiki-devel mailing list
Semediawiki-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
