I have mediawiki 1.26.3 setup with VisualEditor and PostgreSQL, and find that VisualEditor won't load (the progressbar stops and after some time it asks me to retry). This request is waiting forever:
And I can see these PostgreSQL processes:
postgres: http http [local] INSERT waiting postgres: http http [local] INSERT waiting postgres: http http [local] idle in transaction
Two are waiting, one idle but not committed.
I find a workaround: edit /usr/share/webapps/mediawiki/includes/db/Database.php and make the following change:
--- includes/db/Database.php 2016-03-25 19:02:16.780660734 +0800 +++ includes/db/Database.php 2016-03-28 16:45:39.341782439 +0800 @@ -1597,7 +1597,9 @@ $options = array(), $join_conds = array() ) { $sql = $this->selectSQLText( $table, $vars, $conds, $fname, $options, $join_conds ); - return $this->query( $sql, $fname ); + $ret = $this->query( $sql, $fname ); + $this->commit(); + return $ret; } /**
But this will make some category pages to raise errors.