Last modified: 2014-01-21 03:23:44 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T62274, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 60274 - "{{#ask:" fails with database error when querying categories with subcategories
"{{#ask:" fails with database error when querying categories with subcategories
Status: RESOLVED WORKSFORME
Product: MediaWiki extensions
Classification: Unclassified
Semantic MediaWiki (Other open bugs)
unspecified
All All
: Unprioritized normal (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2014-01-21 03:00 UTC by Tim Landscheidt
Modified: 2014-01-21 03:23 UTC (History)
6 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Tim Landscheidt 2014-01-21 03:00:29 UTC
https://wikitech.wikimedia.org/w/index.php?title=Incident_documentation&oldid=89337 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 4104".

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 1.8.0.5.

"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 t0.o_id=t1.id ORDER BY t2.smw_sortkey ASC LIMIT 51 OFFSET 0;
| Auxilliary Tables Used
| Temporary table t1
|   Recursively computed hierarchy for element(s) ('3544').
| Errors and Warnings
| None
Comment 1 Tim Landscheidt 2014-01-21 03:06:01 UTC
I have absolutely no clue how, but now it works again.  Can "format=debug" clean up some internal SMW confusion?

Anyhow, closing this bug.
Comment 2 Jeroen De Dauw 2014-01-21 03:23:44 UTC
> Can "format=debug" clean up some internal SMW confusion?

Unlikely this has anything to do with it in this case.

Looks like some kind of race condition. Hard to say more without a full stack trace.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links