Web browser: ---
            Bug ID: 60274
           Summary: "{{#ask:" fails with database error when querying
                    categories with subcategories
           Product: MediaWiki extensions
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: Unprioritized
         Component: Semantic MediaWiki
    Classification: Unclassified
   Mobile Platform: ---
yields "Database error: A database query error has occurred. This may indicate
a bug in the software."  The error log says: "PHP Notice: Uncommitted DB writes
(transaction from DatabaseBase::query (WikiPage::pageData)). in
/srv/org/wikimedia/controller/wikis/slot0/includes/db/Database.php on line

Bisecting shows that this started with the addition of "{{#ask:
[[Category:Events reports]] | format=ul }}" to the page, but must have been
worked in the past.

Playing around with some queries shows that #ask'ing for categories with only
plain pages works (Category:Tools Access Requests), but for categories with
subcategories (Category:Events reports, Category:Linode) fails.

Currently, wikitech is running

"format=debug" says (not failing):

| Debug Output by SMWSQLStore3
| Generated Wiki-Query
| [[Category:Events reports]]
| Query Metrics
| Query-Size:1
| Query-Depth:0
| SQL Query
| SELECT DISTINCT t2.smw_title AS t,t2.smw_namespace AS ns FROM
`smw_object_ids` AS t2 INNER JOIN `smw_fpt_inst` AS t0 ON t2.smw_id=t0.s_id
INNER JOIN `t1` AS t1 ON ORDER BY t2.smw_sortkey ASC LIMIT 51
| Auxilliary Tables Used
| Temporary table t1
|   Recursively computed hierarchy for element(s) ('3544').
| Errors and Warnings
| None

You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
Wikibugs-l mailing list

Reply via email to