Indeed master + Jeff's Gerrit change #170395 fails (cf. https://travis-ci.org/scfc/mediawiki-core/jobs/40611418).

Marcin, IIRC you fixed a lot of transaction-related PostgreSQL bugs many moons ago; do you have a grasp of the current design?

do we know which test is causing this?

With current master (and a change to nuke INSERT IGNORE in the updater) I am running

php tests/phpunit/phpunit.php --configuration tests/phpunit/suite.xml --exclude-group Broken,Stub,Dump,ParserFuzz

and I get 5 errors:

ImportTest::testHandlePageContainsRedirect with data set #0 ('<mediawiki ...

MWException: Cannot create InputStreamSource.

ImportTest::testHandlePageContainsRedirect with data set #1

MWException: Cannot create InputStreamSource.

TestORMRowTest::testSaveAndRemove

which is T75139

SiteSQLStoreTest::testGetSites

DBQueryError: A database error has occurred. Did you forget to run maintenance/update.php after upgrading?  See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
Query: INSERT INTO "unittest_sites" (site_id,site_global_key,site_type,site_group,site_source,site_language,site_protocol,site_domain,site_data,site_forward,site_config) VALUES (NULL,'foobar','unknown','none','local','','','.','a:0:{}',0,'a:0:{}')
Function: SiteSQLStore::saveSites
Error: 23502 ERROR:  null value in column "site_id" violates not-null constraint

which is probably what we are getting here?

SiteSQLStoreTest::testSaveSites

DBQueryError: A database error has occurred. Did you forget to run maintenance/update.php after upgrading?  See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
Query: INSERT INTO "unittest_sites" (site_id,site_global_key,site_type,site_group,site_source,site_language,site_protocol,site_domain,site_data,site_forward,site_config) VALUES (NULL,'ertrywuutr','unknown','none','local','en','','.','a:0:{}',0,'a:0:{}')
Function: SiteSQLStore::saveSites
Error: 23502 ERROR:  null value in column "site_id" violates not-null constraint

and then 18 test failures:

1. PrefixSearchTest::testSearch
2. SpecialPageTest::testInvalidGetTitleFor Failed asserting that exception of type "PHPUnit_Framework_Error_Notice" is thrown.
3. SpecialPageTest::testGetTitleForWithWarning with data set #0 (Special:UserLogin, 'UserLogin') Failed asserting that exception of type "PHPUnit_Framework_Error_Notice" is thrown.
4. WikiPageTest::testDoDeleteArticle (known issue)
5. WikiPageTest::testDoDeleteUpdates (known issue)
6. SiteSQLStoreTest::testReset (probably related to the error above)

and some TextPassDumperTest and FetchTextTest failures

15 tests were skipped

The test that fails is:

php tests/phpunit/phpunit.php tests/phpunit/includes/site/SiteSQLStoreTest.php

Only it presents differently for me, taking down the test framework rather than just failing in the ordinary way.

I wonder if the behavior depends on the version of the php library used to talk to pgsql. I don't know how to figure that out. I'm using CentOS 6.6 and PHP 5.3.3 (cli) (built: Oct 30 2014 20:12:53).

First I have you run into the issue (which got fixed in the meantime) that the transaction error overshadowed any real database error during testing - this was I think bug 58095.

on my installation it seems that the problem is with SiteSQLStoreTest -
after applying by hand my fix in gerrit change 100183.

Actually those problems were already mentioned in bug 43475

Can we check if teaching "ORM" to use sequences fixes the problem?

Please try gerrit change 100183 - it should fix this (and some other "ORM" tests as well).

Gerrit change #100183 fixes the distal problem, but not the proximal problem that the test suite should not fall over when one test in it fails.

Bug 58095 is marked closed, should that be reopened?

Can we double check if fix for bug 58095 (gerrit change 136287 - it's yours) is included in our build on travis?

I wonder why it works for me...

Migrating from the old tracking task to a tag for PostgreSQL-related tasks.