Problem/Motivation

Random test failure - Table 'sequences' already exists.

https://www.drupal.org/pift-ci-job/1704722

Testing Drupal\FunctionalTests\Installer\InstallerExistingConfigDirectoryTest
E                                                                   1 / 1 (100%)

Time: 4.66 seconds, Memory: 4.00 MB

There was 1 error:

1) Drupal\FunctionalTests\Installer\InstallerExistingConfigDirectoryTest::testInstaller
Exception: Drupal\Core\Database\SchemaObjectExistsException: Table 'sequences' already exists.
Drupal\Core\Database\Schema->createTable()() (Line: 614)

https://www.drupal.org/pift-ci-job/1705699

Testing Drupal\Tests\jsonapi\Functional\EntityViewModeTest
...SE...                                                            8 / 8 (100%)

Time: 1.29 minutes, Memory: 6.00 MB

There was 1 error:

1) Drupal\Tests\jsonapi\Functional\EntityViewModeTest::testPostIndividual
Drupal\Core\Database\SchemaObjectExistsException: Table 'sequences' already exists.

Proposed resolution

CommentFileSizeAuthor
#12 3143812-12-1000x-fail.patch1.75 KBquietone
#11 3143812-11-1000x-fail.patch1.72 KBquietone
#10 3143812-10-1000x-fail.patch525 bytesquietone
#9 3143812-9-1000x-fail.patch1.74 KBquietone

Comments

Krzysztof Domański created an issue. See original summary.

krzysztof domański’s picture

krzysztof domański
Location Poland
commented
Issue summary: View changes
krzysztof domański’s picture

krzysztof domański
Location Poland
commented
Related issues: +#2665216: Deprecate Drupal\Core\Database\Connection::nextId() and the {sequences} table and schema
krzysztof domański’s picture

krzysztof domański
Location Poland
commented

https://www.drupal.org/pift-ci-job/1841152

Testing Drupal\Tests\image\Functional\Rest\ImageStyleXmlCookieTest
ESS.                                                                4 / 4 (100%)

Time: 30.1 seconds, Memory: 6.00 MB

There was 1 error:

1) Drupal\Tests\image\Functional\Rest\ImageStyleXmlCookieTest::testGet
Drupal\Core\Database\SchemaObjectExistsException: Table 'sequences' already exists.

Version: 9.1.x-dev » 9.2.x-dev

Drupal 9.1.0-alpha1 will be released the week of October 19, 2020, which means new developments and disruptive changes should now be targeted for the 9.2.x-dev branch. For more information see the Drupal 9 minor version schedule and the Allowed changes during the Drupal 9 release cycle.

Version: 9.2.x-dev » 9.3.x-dev

Drupal 9.2.0-alpha1 will be released the week of May 3, 2021, which means new developments and disruptive changes should now be targeted for the 9.3.x-dev branch. For more information see the Drupal core minor version schedule and the Allowed changes during the Drupal core release cycle.

Version: 9.3.x-dev » 9.4.x-dev

Drupal 9.3.0-rc1 was released on November 26, 2021, which means new developments and disruptive changes should now be targeted for the 9.4.x-dev branch. For more information see the Drupal core minor version schedule and the Allowed changes during the Drupal core release cycle.

Version: 9.4.x-dev » 9.5.x-dev

Drupal 9.4.0-alpha1 was released on May 6, 2022, which means new developments and disruptive changes should now be targeted for the 9.5.x-dev branch. For more information see the Drupal core minor version schedule and the Allowed changes during the Drupal core release cycle.

quietone’s picture

quietone commented
Version: 9.5.x-dev » 9.4.x-dev
Issue tags: +Bug Smash Initiative
StatusFileSize
new 3143812-9-1000x-fail.patch1.74 KB

random test failures are bugs, changing status.

The reports for this failure are all on 9.1
9.1.x-dev test with PHP 7.3.x-dev & MySQL 5.7 - HEAD
3143618-10.patch test with PHP 7.4 & MySQL 5.7 - #3143618: Replace space (U+0020) with No-Break Space (U+00A0) to minimize false positives
2716019-95.patch test with PHP 7.3 & MySQL 8 - #2716019: View titles in breadcrumb and metatag title don't get properly translated

There have been no other mentions of this failing on #2829040: [meta] Known intermittent, random, and environment-specific test failures.

Making a patch to run this test 1,000 times and see it it will fail.

quietone’s picture

quietone commented
StatusFileSize
new 3143812-10-1000x-fail.patch525 bytes

Try again

quietone’s picture

quietone commented
StatusFileSize
new 3143812-11-1000x-fail.patch1.72 KB

Maybe third time lucky.

quietone’s picture

quietone commented
StatusFileSize
new 3143812-12-1000x-fail.patch1.75 KB

Darn. I lost the repeat: 1000

quietone’s picture

quietone commented
Category: Task » Bug report
Status: Active » Needs review

I forgot to change the status

quietone’s picture

quietone commented

Discussed in #bugsmash with borisson_ and longwave. longwave thought that this test fails when run concurrently, so 1000 repeats (as done in the patch) does not prove anything. They also thought that there is supposed to be a lock that prevents the problem. borisson_ pointed out that if this issue is before the lock was added, then it can probably be closed.

When was the lock added?

quietone’s picture

quietone commented
Status: Needs review » Active

Yes, this still occurs,
https://www.drupal.org/pift-ci-job/2423331

Version: 9.4.x-dev » 9.5.x-dev

Drupal 9.4.9 was released on December 7, 2022 and is the final full bugfix release for the Drupal 9.4.x series. Drupal 9.4.x will not receive any further development aside from security fixes. Drupal 9 bug reports should be targeted for the 9.5.x-dev branch from now on, and new development or disruptive changes should be targeted for the 10.1.x-dev branch. For more information see the Drupal core minor version schedule and the Allowed changes during the Drupal core release cycle.

Version: 9.5.x-dev » 11.x-dev

Drupal core is moving towards using a “main” branch. As an interim step, a new 11.x branch has been opened, as Drupal.org infrastructure cannot currently fully support a branch named main. New developments and disruptive changes should now be targeted for the 11.x branch. For more information, see the Drupal core minor version schedule and the Allowed changes during the Drupal core release cycle.

quietone’s picture

quietone commented
Title: Random test failure Table 'sequences' already exists. » [random test failure] Table 'sequences' already exists.

Updating the title per Special issue titles.

Version: 11.x-dev » main

Drupal core is now using the main branch as the primary development branch. New developments and disruptive changes should now be targeted to the main branch.

Read more in the announcement.

dcam’s picture

dcam commented
Status: Active » Postponed (maintainer needs more info)

This issue has to be outdated for the main branch (Drupal 12) because the sequences table has been removed. See #3335756: Drop sequences table in Drupal 12. But I'm not going to close it right now since Drupal 11 will be supported until Drupal 13 is released. I don't know if it still occurs on that branch or not.

mstrelan’s picture

mstrelan commented

It might still be an issue because sequences used to be the first table created when installing the site. We might just see another table instead, I think keyvalue.

smustgrave’s picture

smustgrave commented

Any objections to closing this one? Haven't see any errors and we aren't skipping any tests in this file. Can always re-open.

mstrelan’s picture

mstrelan commented
Status: Postponed (maintainer needs more info) » Closed (outdated)

Fine with me. I think outdated makes sense as the table no longer exists.

Now that this issue is closed, review the contribution record.

As a contributor, attribute any organization that helped you, or if you volunteered your own time.

Maintainers, credit people who helped resolve this issue.