MediaWiki-l September 2016

mediawiki-l@lists.wikimedia.org

45 participants
39 discussions

Re: [MediaWiki-l] Mediawiki MySQL user-related database [dead]locks?
by Jan Steinman 18 Sep '16

18 Sep '16

Are you using InnoDB? This sounds like a MyISAM issue. MyISAM does table level locking. InnoDB does row locking. So a transaction should not hang in InnoDB unless two processes are attempting to modify the same record, whereas it can happen in MyISAM if two processes are trying to modify the same table. Jan Steinman EcoReality Co-op, http://www.EcoReality.org 2152 Fulford-Ganges Road Salt Spring Island, BC V8K 1Z7 CANADA +1 250.653.2024

1 0

Mediawiki MySQL user-related database [dead]locks?
by Andrew Smith 18 Sep '16

18 Sep '16

Hello I administer a relatively busy wiki for our school, at https://wiki.cdot.senecacollege.ca In august I migrated the wiki from an older server where it had as far as I can tell 1.15.4 on. The new server had the latest mediawiki verison available, as far as I can tell now 1.27 The database server didn't change, only the web server. After updating the mediawiki files (I started from 1.27 and added in missing stuff as described here https://www.mediawiki.org/wiki/Manual:Moving_a_wiki ) I ran update.php I can't remember if it printed any errors the first time I ran it. There was a lot of output and I don't understand half of it. I think it ran without errors. Also I ran it multiple times since then and haven't noticed any errors. Everything seemed to work. But now that the new semester started and we have a lot of new students - we discovered a very serious problem: the wiki won't allow new user registrations. You can go and try yourself. Usually the interface just hangs there, never coming back with a response. Sometimes I get an error like this: MySQL [cdotwiki_db]> SELECT user_id FROM `mw_user` WHERE user_name = 'Asmith20' LIMIT 1 LOCK IN SHARE MODE ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction Just now I finished migrating the database to a brand new MySQL 5.7.15 server, thinking that maybe I would see some change. But nothing changed. Because it's 1AM I got some debugging going, and almost certainly this was the first Mediawiki request to the database that failed (from SHOW ENGINE INNODB STATUS;): ---TRANSACTION 4748, ACTIVE 62 sec 8 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 8 MySQL thread id 1345, OS thread handle 140329361524480, query id 20771 web-cdot1.sparc 10.7.0.45 cdotwiki_usr cleaning up Trx read view will not see trx with id >= 4742, sees < 4742 TABLE LOCK table `cdotwiki_db`.`mw_user` trx id 4748 lock mode IS RECORD LOCKS space id 70 page no 157 n bits 624 index user_name of table `cdotwiki_db`.`mw_user` trx id 4748 lock mode S locks gap before rec Record lock, heap no 244 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 6; hex 41736f583139; asc AsoX19;; 1: len 4; hex 000001ac; asc ;; Record lock, heap no 558 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 8; hex 41736d6974683230; asc Asmith20;; 1: len 4; hex 000036c2; asc 6 ;; TABLE LOCK table `cdotwiki_db`.`mw_user` trx id 4748 lock mode IX RECORD LOCKS space id 70 page no 436 n bits 112 index PRIMARY of table `cdotwiki_db`.`mw_user` trx id 4748 lock_mode X locks rec but not gap Record lock, heap no 42 PHYSICAL RECORD: n_fields 17; compact format; info bits 0 0: len 4; hex 000036c2; asc 6 ;; 1: len 6; hex 00000000128c; asc ;; 2: len 7; hex 21000001362118; asc ! 6! ;; 3: len 8; hex 41736d6974683230; asc Asmith20;; 4: len 0; hex ; asc ;; 5: len 30; hex 3a70626b6466323a7368613235363a31303030303a3132383a2f66545962; asc :pbkdf2:sha256:10000:128:/fTYb; (total 222 bytes); 6: len 0; hex ; asc ;; 7: len 21; hex 61736d6974683230406c6974746c657376722e6361; asc asmith20(a)littlesvr.ca;; 8: len 14; hex 3230313630393135303530303137; asc 20160915050017;; 9: len 30; hex 623061346535323762613365336462656133323035633666343564663163; asc b0a4e527ba3e3dbea3205c6f45df1c; (total 32 bytes); 10: SQL NULL; 11: len 30; hex 396561386335613365663263623666353062303736646165393934393331; asc 9ea8c5a3ef2cb6f50b076dae994931; (total 32 bytes); 12: len 14; hex 3230313630393232303530303130; asc 20160922050010;; 13: len 14; hex 3230313630393135303530303130; asc 20160915050010;; 14: SQL NULL; 15: len 4; hex 80000000; asc ;; 16: SQL NULL; TABLE LOCK table `cdotwiki_db`.`mw_watchlist` trx id 4748 lock mode IX RECORD LOCKS space id 70 page no 157 n bits 624 index user_name of table `cdotwiki_db`.`mw_user` trx id 4748 lock_mode X locks rec but not gap Record lock, heap no 558 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 8; hex 41736d6974683230; asc Asmith20;; 1: len 4; hex 000036c2; asc 6 ;; TABLE LOCK table `cdotwiki_db`.`mw_logging` trx id 4748 lock mode IX TABLE LOCK table `cdotwiki_db`.`mw_recentchanges` trx id 4748 lock mode IX If I kill this transaction (thread id 1345) via phpmyadmin - strangely nothing will appear to happen. My browser will keep spinning, as if it's waiting for a response. I am starting to become desperate. With every day that passes the problem grows. And I don't have a lot of ideas left. It's not the MySQL server. I disabled nearly all extensions. I can't really read the output from innodb status (example above). What should I do? My best guess now is that the upgrade didn't work 100%. But what do I do now? Is it an option to downgrade? If yes - how far back? Will that even help or is the database corrupt? How can I check whether it's corrupt? If I have to roll back the the backup from before the upgrade (shiver) - will it be possible to apply the changes made to the new database to the restored old version? Probably not? Please help! I thought I got this upgrade to work and I really hope I didn't screw hundreds of users over :( Cheers, Andrew

3 5

Semantic MediaWiki Conference Fall 2016: Call for Participation
by kghbln 18 Sep '16

18 Sep '16

Dear users, developers and all people interested in semantic wikis, We are very happy to announce the program of the 13th Semantic MediaWiki Conference in Frankfurt am Main, Germany! People from business, academia and non-profit organizations will give a variety of very interesting talks and presentations about applying semantic wikis as well as about newest developments in the field. We would also like to remind you of the upcoming end to the early bird registration registration period on September 14, 2016. Please register via Tito [0] if you have not done so already. Important facts reminder: * Dates: September 28th to 30th 2016 (Wednesday to Friday) * Location: German Institute for International Educational Research (DIPF), Schloßstraße 29, Frankfurt am Main, Germany. * Conference page: https://www.semantic-mediawiki.org/wiki/SMWCon_Fall_2016 * Participants: Everybody interested in semantic wikis, especially in Semantic MediaWiki, e.g. users, developers, consultants, business representatives and researchers. News on the program: * The tutorial program has been announced and made available [1] * The conference program has now also been announced and made available [2]. We are very happy that the keynote will be held by Prof. Dr. Sören Auer of Fraunhofer Institute for Intelligent Analysis and Information Systems IAIS, Enterprise Information Systems. * A social program is also being prepared [3]. * We encourage contributions for poster sessions about semantic wikis; for a list of topics, see [4]. Please add your proposals by e-mail to one of the program chairs. (CC) * Presentations will generally be video and audio recorded and made available for others after the conference. Organization: * Deutsches Institut für Internationale Pädagogische Forschung (DIPF) [5] and Open Semantic Data Association e. V. [6] have become the official organisers of SMWCon Fall 2016. * Very special thanks go to Wikimedia Deutschland [7] for being our platinum as well as ArchiXL [8] for being our gold supporter. If you have questions you can contact Sabine Melnicki, Kendra Sticht and Christoph Schindler (Program Chairs), Karsten Hoffmeyer (General Chair) or Lia Veja (Local Chair) by e-mail (CC). We will be happy to see you in Frankfurt! Sabine Melnicki, Kendra Sticht and Christoph Schindler (Program Board) [0] <https://ti.to/smwconfall2016/frankfurt> [1] <https://www.semantic-mediawiki.org/wiki/SMWCon_Fall_2016/Tutorial_Day> [2] <https://www.semantic-mediawiki.org/wiki/SMWCon_Fall_2016/Conference_Days> [3] <https://www.semantic-mediawiki.org/wiki/SMWCon_Fall_2016#Social_program> [4] <https://www.semantic-mediawiki.org/wiki/SMWCon_Fall_2016/Announcement> [5] <http://www.dipf.de/en/about-us/contact> [6] <http://www.opensemanticdata.org/> [7] <http://www.wikimedia.de/> [8] <http://www.archixl.nl/>

3 3

Re: [MediaWiki-l] trucs drôles
by goldy2010 16 Sep '16

16 Sep '16

Hey, Jetez un coup œil à ces choses, c’est tellement drôle! Je ne pouvais pas arrêter de rire, lisez le ici <http://permit.ghostridetheweb.com/xowjf> Je t'embrasse, goldy2010

1 0

Introducing mwbot, a Node.js library/bot for MediaWiki
by Simon Heimler 15 Sep '16

15 Sep '16

Hello! I'd like to introduce a project that I've been working on for a while: https://github.com/Fannon/mwbot MWBotis a Node.js module for interacting with the MediaWiki API. The library makes use of the Promise Pattern and behind the scene, the request library. The design goal is to be as flexible as possible, with the ability to overwrite options and behaviour at any point. The library also lets you freely choose the abstraction/convenience level on which you want to work. You can use convenience functions that bundles (with concurrency) of multiple API requests into one function, but you can also handcraft your own MediaWiki API and pure HTTP requests. The library has extensive test coverage and is written in modern ECMAScript 2015. Maybe it is useful to some people. Have a nice day! Simon

3 4

No-External-Page-Error
by Johannes Levermann 15 Sep '16

15 Sep '16

Hey guys, I am currently experiencing the same error on both backend and frontend of the wikibase i set up. Backend: When trying to create new items via pywikibot(newitem.py). Frontend: When trying to link an item to its respective page. ERROR: no-external-page: The external client site 'wiki_name' did not provide page information for page 'page_name'. Can anyone advise on how to fix this issue? Thanks in advance, Johannes

1 0

MediaWiki 1.27.1 upgrade unable to access edit page or admin tools
by Legault, Phillip [GTSUS] 14 Sep '16

14 Sep '16

After upgrading to 1.27.1 Unable to edit page I found this https://www.mediawiki.org/wiki/Topic:T75cloz7981b8i92 tried everything there and still encounter access issues.

1 0

Upgrading to MediaWiki 1.27.1
by Legault, Phillip [GTSUS] 14 Sep '16

14 Sep '16

I'm attempting to upgrade to 1.27.1 After getting through some extension issues the page appears to load then disappears and no errors other than this in the apache log 172.21.225.20 - - [13/Sep/2016:20:20:44 -0400] "GET /index.php/Main_Page HTTP/1.1" 304 - "-" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36" 172.21.225.20 - - [13/Sep/2016:20:20:45 -0400] "GET /images/7/78/Contribute.png HTTP/1.1" 404 224 "https://awsacrnva1040.jnj.com/load.php?debug=false&lang=en&modules=site&onl…" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36" 172.21.225.20 - - [13/Sep/2016:20:20:45 -0400] "GET /images/c/c0/Hiking.png HTTP/1.1" 404 220 "https://awsacrnva1040.jnj.com/load.php?debug=false&lang=en&modules=site&onl…" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36" 172.21.225.20 - - [13/Sep/2016:20:20:45 -0400] "GET /images/2/25/Magnifying-glass.png HTTP/1.1" 404 230 "https://awsacrnva1040.jnj.com/load.php?debug=false&lang=en&modules=site&onl…" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36" 172.21.225.20 - - [13/Sep/2016:20:20:45 -0400] "GET /images/0/0e/Help-icon-1.png HTTP/1.1" 404 225 "https://awsacrnva1040.jnj.com/load.php?debug=false&lang=en&modules=site&onl…" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36" 172.21.225.20 - - [13/Sep/2016:20:20:45 -0400] "GET /index.php/[object%20Object]?title=MediaWiki:Edittools.js&action=raw&ctype=text/javascript HTTP/1.1" 400 11224 "https://awsacrnva1040.jnj.com/index.php/Main_Page" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36" Thanks, Phil

2 6

After update 1.22 to 1.27 no links created to added new pages
by prochazka＠cortex.cz 14 Sep '16

14 Sep '16

Hello, i updated our local mediawiki (followed update method on mediawiki web) 1.22.2 to 1.27.1. Detected only one problem for now - after creating new page, page is created, accessible via "Recent Changes", but not accessible from Category page - missing link to page. If i update category in any page, changes not reflected too. There is some problem with modifiyng mysql table "categorylinks". Running maintenance script "updateLinks.php" from CLI solves all those issues, but for any future new/modified page issue persist, so i need it working without maintenance... MediaWiki 1.27.1 PHP 5.6.24-0+deb8u1 (fpm-fcgi) MySQL 5.5.50-0+deb7u2-log Any help? Thanks, MP

2 4

[SF] datepicker - select field for year with more years
by Dr. Hirn 14 Sep '16

14 Sep '16

Hi, I'm planning to use the datepicker-field for birth dates. Unfortunately, the list of selectable years reaches only to 2006. So you have to select the correct day and month and a random year and then change the date in the input-field again. This is not really straight forward. Is there a chance to add more years to the "select-field"? Thx Stefan

3 3

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

MediaWiki-l September 2016