This issue is part of #2157455: [Meta] Make Drupal 8 work with PostgreSQL or remove support from core before release.

Currently there is one or more fail or exception in the options test group identified by the new docker based testbot that need to be fixed to make PostgreSQL finally passing all tests. Command in use:

sudo DCI_DBTYPE='pgsql' \
DCI_DBVER='9.1' \
DCI_PHPVERSION='5.5' \
DCI_CONCURRENCY='4' \
DCI_TESTGROUPS='options' \
DCI_DRUPALBRANCH='8.0.x' \
DCI_VERBOSE='true' \
DCI_UPDATEREPO='true' \
./containers/web/run.sh
CommentFileSizeAuthor
#1 options_group_tests.txt96.24 KBbzrudi71

Comments

bzrudi71’s picture

bzrudi71 commented
Issue summary: View changes
StatusFileSize
new options_group_tests.txt96.24 KB

Duplicate index/table (already exists) :-(

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42P07]: Duplicate
    table: 7 ERROR:  relation
    "drupal_6JLN__8isFnEJKssnrqPghSFQbMMZA2M7tOEqWOWoRU_idx" already
    exists: CREATE INDEX
    "drupal_6JLN__8isFnEJKssnrqPghSFQbMMZA2M7tOEqWOWoRU_idx" ON
jaredsmith’s picture

jaredsmith commented

I have tested this locally using the PostgreSQL support in drupalci. I was using PHP 5.5 and PostgreSQL 9.1

Before applying the patch from #2425127: Prevent PostgreSQL from creating duplicated index names within schema, got an exception in the OptionsFloatFieldImportTest test.

Test summary
------------
Drupal\options\Tests\OptionsFieldTest 18 passes 1 exceptions
Drupal\options\Tests\OptionsDynamicValuesApiTest 3 passes
Drupal\options\Tests\OptionsDynamicValuesValidationTest 9 passes
Drupal\options\Tests\OptionsFormattersTest 10 passes
Drupal\options\Tests\OptionsSelectDynamicValuesTest 16 passes
Fatal error: Call to a member function getSetting() on a non-object in /var/www/core/modules/options/src/Tests/OptionsFloatFieldImportTest.php on line 74
FATAL Drupal\options\Tests\OptionsFloatFieldImportTest: test runner returned a non-zero error code (255).
Drupal\options\Tests\OptionsWidgetsTest 211 passes
Drupal\options\Tests\OptionsFieldUITest 295 passes
Test run duration: 2 min 32 sec

After applying the patch from #2425127: Prevent PostgreSQL from creating duplicated index names within schema, the exception goes away and all the tests pass:

Test summary
------------
Drupal\options\Tests\OptionsFieldTest 21 passes
Drupal\options\Tests\OptionsDynamicValuesApiTest 3 passes
Drupal\options\Tests\OptionsDynamicValuesValidationTest 9 passes
Drupal\options\Tests\OptionsFormattersTest 10 passes
Drupal\options\Tests\OptionsSelectDynamicValuesTest 16 passes
Drupal\options\Tests\OptionsFloatFieldImportTest 33 passes
Drupal\options\Tests\OptionsWidgetsTest 211 passes
Drupal\options\Tests\OptionsFieldUITest 295 passes
Test run duration: 2 min 28 sec

I've also reviewed the code from that patch, and it's clear to me that this fixes this failing test.

jaredsmith’s picture

jaredsmith commented
Status: Active » Fixed

Now that the patch from #2425127: Prevent PostgreSQL from creating duplicated index names within schema has been committed, all test in the 'options' test group pass. Closing as fixed.

Test run started:
Monday, February 23, 2015 - 14:38

Test summary
------------
Drupal\options\Tests\OptionsFieldTest 21 passes
Drupal\options\Tests\OptionsDynamicValuesApiTest 3 passes
Drupal\options\Tests\OptionsDynamicValuesValidationTest 9 passes
Drupal\options\Tests\OptionsFormattersTest 10 passes
Drupal\options\Tests\OptionsSelectDynamicValuesTest 16 passes
Drupal\options\Tests\OptionsFloatFieldImportTest 33 passes
Drupal\options\Tests\OptionsWidgetsTest 211 passes
Drupal\options\Tests\OptionsFieldUITest 295 passes

Test run duration: 3 min

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.