Page MenuHomeMiraheze

DB error when accessing Special:Contributions on horriblemusicwiki
Closed, ResolvedPublic

Description

This link: http://horriblemusic.miraheze.org/wiki/Special:Contributions/FatBurn0000 isn't working. When I write the link myself, it takes too long to load. On the other hand, if I go here: https://horriblemusic.miraheze.org/wiki/Horrible_Music_Wiki and click on the contributions link here:

Capture (2).PNG (470×535 px, 28 KB)

it either again takes too long or says this:
"Database error - A database error has occurred. This may indicate a bug in the software." and various things I don't understand. See a Snip here:
image.png (211×1 px, 32 KB)

Event Timeline

FatBurn0000 triaged this task as Normal priority.Jul 9 2022, 06:39
FatBurn0000 created this task.
Reception123 renamed this task from Issue on HMSW to DB error when accessing Special:Contributions on horriblemusicwiki.Jul 9 2022, 09:58

for SRE:

Error 1969: Query execution was interrupted (max_statement_time exceeded) (db111)
Function: IndexPager::buildQueryInfo (contributions page unfiltered)
Query: SET STATEMENT max_statement_time=20 FOR SELECT  rev_id,rev_page,rev_timestamp,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,comment_rev_comment.comment_text AS `rev_comment_text`,comment_rev_comment.comment_data AS `rev_comment_data`,comment_rev_comment.comment_id AS `rev_comment_cid`,actor_rev_user.actor_user AS `rev_user`,actor_rev_user.actor_name AS `rev_user_text`,temp_rev_user.revactor_actor AS `rev_actor`,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name,page_is_new,revactor_timestamp,(SELECT  GROUP_CONCAT(ctd_name SEPARATOR ',')  FROM `change_tag` JOIN `change_tag_def` ON ((ct_tag_id=ctd_id))   WHERE ct_rev_id=rev_id  ) AS `ts_tags`  FROM `revision` JOIN `revision_comment_temp` `temp_rev_comment` ON ((temp_rev_comment.revcomment_rev = rev_id)) JOIN `comment` `comment_rev_comment` ON ((comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id)) JOIN `revision_actor_temp` `temp_rev_user` FORCE INDEX (actor_timestamp) ON ((temp_rev_user.revactor_rev = rev_id)) JOIN `actor` `actor_rev_user` ON ((actor_rev_user.actor_id = temp_rev_user.revactor_actor)) JOIN `page` ON ((page_id = rev_page)) LEFT JOIN `user` ON ((actor_rev_user.actor_user != 0) AND (user_id = actor_rev_user.actor_user))   WHERE ((temp_rev_user.revactor_actor = 478)) AND ((rev_deleted & 12) != 12)  ORDER BY revactor_timestamp DESC,revactor_rev DESC LIMIT 51

We're sorry for this.

An upgrade to 1.38.2 was tried but it looks like MariaDB isn't being sensible still.

This will have to wait until an upstream DBA can help us make it less stupid.

@FatBurn0000 Is this still an issue? I was able to load it without issue.

Unknown Object (User) added a comment.Jul 11 2022, 04:52

@FatBurn0000 Is this still an issue? I was able to load it without issue.

It just happened for me.

Unknown Object (User) added a comment.Jul 11 2022, 04:53

Oh, it does work now after clearing cache.

Unknown Object (User) closed this task as Resolved.Jul 11 2022, 04:54

Per above. Please reopen if it is still an issue. Thanks!

Unknown Object (User) claimed this task.Jul 11 2022, 04:55

This might have actually been fixed by upgrade yesterday, but cache made it so I did not realise it.

It's still not working for me.

Unknown Object (User) added a comment.Jul 29 2022, 06:45

It's still not working for me.

Yeah, it was working for a day, now does not anymore. Sorry about that.

Unknown Object (User) removed Unknown Object (User) as the assignee of this task.Jul 30 2022, 02:32
Unknown Object (User) closed this task as Resolved.Aug 5 2022, 00:10
Unknown Object (User) claimed this task.

This should be fixed now.

Unknown Object (User) added a comment.Aug 5 2022, 16:06

Indeed, it is working.

Yes, I raised the db query timeout from 20 seconds to 30 seconds to get it to work. The page does indeed take a while to load, but it should not work properly.