Re: [Wikitech-l] Help please! Database::close: mass commit/rollback... on Special Page
That means an implicit transaction [1] was started but not committed/cancelled. For special pages transaction handling is done by the framework and this should not happen unless you are doing something strange, like obtaining a connection in a non-standard way. Application errors (ie. something throwing a non-database-related exception) sometimes bring the database abstraction layer into an inconsistent state, so maybe this is a secondary error caused by something else - check your exception logs. [1] https://www.mediawiki.org/wiki/Database_transactions#Transaction_scope On Mon, Apr 22, 2019 at 9:31 AM Jim Hu wrote: > > For one of our custom wikis we have a Special Page that creates new pages > based on form input. This used to work in MW1.23 but in the long overdue > update to MW1.31 it stopped working. > > The Special Page is supposed to write a record to a shared external > database and then use the autoincremented row number to set the name of the > page that will be created. I’m using $dbw->insert to do this. In 1.31 the > autoincrement index gets bumped but the row doesn’t get written. If I do > the same insert from a maintenance script, it works, so I’m assuming it > doesn’t have anything to do with general configurations or other extensions > (which I’ve inactivated). > > After it gets a value for the lastInsertID it tries to make a page from a > template. That page is never created and I see this in the error logs: > > PHP Fatal error: Uncaught Wikimedia\\Rdbms\\DBUnexpectedError: > Wikimedia\\Rdbms\\Database::close: mass commit/rollback of peer > transaction required (DBO_TRX set). in > /Library/WebServer/Documents/omp/wiki/includes/libs/rdbms/database/Database.php:916\nStack > trace:\n#0 > /Library/WebServer/Documents/omp/wiki/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1217): > > Wikimedia\\Rdbms\\Database->close()\n#1 > [internal function]: > Wikimedia\\Rdbms\\LoadBalancer->Wikimedia\\Rdbms\\{closure}(Object(Wikimedia\\Rdbms\\DatabaseMysqli))\n#2 > /Library/WebServer/Documents/omp/wiki/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1640): > > call_user_func_array(Object(Closure), Array)\n#3 > /Library/WebServer/Documents/omp/wiki/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1218): > > Wikimedia\\Rdbms\\LoadBalancer->forEachOpenConnection(Object(Closure))\n#4 > /Library/WebServer/Documents/omp/wiki/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1208): > > Wikimedia\\Rdbms\\LoadBalancer->closeAll()\n#5 > /Library/WebServer/Documents/omp/wiki/includes/libs/rdbms/loadbalancer/LoadBal > in > /Library/WebServer/Documents/omp/wiki/includes/libs/rdbms/database/Database.php > on line 916, > referer: http://localhost/omp/wiki/index.php/Special:StrainNewPage > > This happens even if comment out the code that accesses the external > database completely and hard code the ID. > > Other Special Page extensions we have that create new pages seem to work > on 1.31.1. I’m wondering if this is related to the method that now fails > being a callback from HTMLforms for processing form submission. > > Any insight, help in debugging this would be much appreciated. Apologies > if I’m using some terminology incorrectly (I’m a biologist more than a > coder). > > Jim Hu > ___ > Wikitech-l mailing list > Wikitech-l@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikitech-l ___ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
Re: [Wikitech-l] Database schema diagram for MW 1.32
Hi Krinkle, This sounds like a very delicate area of MW but I guess it's not production code that will break things and I can always run the diagrams agains an experienced person for validation before it gets published. I'm interested and would like to work with you on this. Thanks a lot :) *--* *https://www.mediawiki.org/wiki/User:X-Savitar>>* On Mon, Apr 22, 2019 at 8:57 PM Krinkle wrote: > Hi all, > > Are you familiar with MediaWiki's database schema diagram? > > https://www.mediawiki.org/wiki/File:MediaWiki_database_schema_latest.svg > https://www.mediawiki.org/wiki/Manual:Database_layout > > I've updated it yearly, or every other year, since 2011. – hoping to have > it > updated for MediaWiki 1.32. But, I'm currently struggling to find the time. > > Are you interested in learning about and creating the next diagram? Let me > know :) > > -- Timo > > PS: I've made these since 2011, and wrote down my process at: > https://www.mediawiki.org/wiki/Manual:Database_layout/diagram > ___ > Wikitech-l mailing list > Wikitech-l@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikitech-l ___ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
[Wikitech-l] Database schema diagram for MW 1.32
Hi all, Are you familiar with MediaWiki's database schema diagram? https://www.mediawiki.org/wiki/File:MediaWiki_database_schema_latest.svg https://www.mediawiki.org/wiki/Manual:Database_layout I've updated it yearly, or every other year, since 2011. – hoping to have it updated for MediaWiki 1.32. But, I'm currently struggling to find the time. Are you interested in learning about and creating the next diagram? Let me know :) -- Timo PS: I've made these since 2011, and wrote down my process at: https://www.mediawiki.org/wiki/Manual:Database_layout/diagram ___ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
[Wikitech-l] Help please! Database::close: mass commit/rollback... on Special Page
For one of our custom wikis we have a Special Page that creates new pages based on form input. This used to work in MW1.23 but in the long overdue update to MW1.31 it stopped working. The Special Page is supposed to write a record to a shared external database and then use the autoincremented row number to set the name of the page that will be created. I’m using $dbw->insert to do this. In 1.31 the autoincrement index gets bumped but the row doesn’t get written. If I do the same insert from a maintenance script, it works, so I’m assuming it doesn’t have anything to do with general configurations or other extensions (which I’ve inactivated). After it gets a value for the lastInsertID it tries to make a page from a template. That page is never created and I see this in the error logs: PHP Fatal error: Uncaught Wikimedia\\Rdbms\\DBUnexpectedError: Wikimedia\\Rdbms\\Database::close: mass commit/rollback of peer transaction required (DBO_TRX set). in /Library/WebServer/Documents/omp/wiki/includes/libs/rdbms/database/Database.php:916\nStack trace:\n#0 /Library/WebServer/Documents/omp/wiki/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1217): Wikimedia\\Rdbms\\Database->close()\n#1 [internal function]: Wikimedia\\Rdbms\\LoadBalancer->Wikimedia\\Rdbms\\{closure}(Object(Wikimedia\\Rdbms\\DatabaseMysqli))\n#2 /Library/WebServer/Documents/omp/wiki/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1640): call_user_func_array(Object(Closure), Array)\n#3 /Library/WebServer/Documents/omp/wiki/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1218): Wikimedia\\Rdbms\\LoadBalancer->forEachOpenConnection(Object(Closure))\n#4 /Library/WebServer/Documents/omp/wiki/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1208): Wikimedia\\Rdbms\\LoadBalancer->closeAll()\n#5 /Library/WebServer/Documents/omp/wiki/includes/libs/rdbms/loadbalancer/LoadBal in /Library/WebServer/Documents/omp/wiki/includes/libs/rdbms/database/Database.php on line 916, referer: http://localhost/omp/wiki/index.php/Special:StrainNewPage This happens even if comment out the code that accesses the external database completely and hard code the ID. Other Special Page extensions we have that create new pages seem to work on 1.31.1. I’m wondering if this is related to the method that now fails being a callback from HTMLforms for processing form submission. Any insight, help in debugging this would be much appreciated. Apologies if I’m using some terminology incorrectly (I’m a biologist more than a coder). Jim Hu ___ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
Re: [Wikitech-l] Developer account creation
Hi Luca, On Mon, 2019-04-22 at 13:53 +0200, Luca Mauri wrote: > I would need to create a developer account for a modification I'd > like > to propose as per https://phabricator.wikimedia.org/T221149 > > I followed the documentation to this link > https://wikitech.wikimedia.org/wiki/Special:CreateAccount > I see the account creation is temporarily unavailable and I read why > this is happening. > What it is not clear to me is if there is any forecast for the > registration to be available again This is still work in progress. Please see https://lists.wikimedia.org/pipermail/wikitech-l/2019-March/091834.html and https://phabricator.wikimedia.org/T200184#5075876 I'm sorry for the inconvenience. Cheers, andre -- Andre Klapper | Bugwrangler / Developer Advocate https://blogs.gnome.org/aklapper/ ___ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
[Wikitech-l] Developer account creation
Dear All, I would need to create a developer account for a modification I'd like to propose as per https://phabricator.wikimedia.org/T221149 I followed the documentation to this link https://wikitech.wikimedia.org/wiki/Special:CreateAccount I see the account creation is temporarily unavailable and I read why this is happening. What it is not clear to me is if there is any forecast for the registration to be available again And, in the meantime, is there any other way to request an account? Thanks and have a nice day Luca --- Questa email è stata esaminata alla ricerca di virus da AVG. http://www.avg.com ___ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l