Occasional locks on SQLite

This happened in #3312733-19: SQL migrations cannot be instantiated if database is not available and Node, Migrate Drupal modules are enabled → , twice in March 2023.

Testing Drupal\Tests\layout_builder\FunctionalJavascript\InlineBlockPrivateFilesTest
E                                                                   1 / 1 (100%)

Time: 00:23.517, Memory: 4.00 MB

There was 1 error:

1) Drupal\Tests\layout_builder\FunctionalJavascript\InlineBlockPrivateFilesTest::testPrivateFiles
Behat\Mink\Exception\ElementNotFoundException: Form field with id|name|label|value "files[settings_block_form_field_file_0]" not found.

/var/www/html/vendor/behat/mink/src/Element/TraversableElement.php:292
/var/www/html/core/modules/layout_builder/tests/src/FunctionalJavascript/InlineBlockPrivateFilesTest.php:273
/var/www/html/core/modules/layout_builder/tests/src/FunctionalJavascript/InlineBlockPrivateFilesTest.php:177
/var/www/html/core/modules/layout_builder/tests/src/FunctionalJavascript/InlineBlockPrivateFilesTest.php:120
/var/www/html/vendor/phpunit/phpunit/src/Framework/TestResult.php:728

This just happened in HEAD
https://www.drupal.org/pift-ci-job/2631320 →

May be infrequent but it's still relevant

Seeing similar in other tests too, see 📌 Random test failure in Drupal\Tests\demo_umami\FunctionalJavascript\PerformanceTest RTBC .

1) Drupal\Tests\demo_umami\FunctionalJavascript\PerformanceTest::testPagesAnonymous
Drupal\Core\Installer\Exception\InstallerException: Resolve all issues below to continue the installation. For help configuring your database server, see the installation handbook, or contact your hosting provider.Failed to connect to database. The database engine reports the following message: SQLSTATE[HY000]: General error: 5 database is locked.Does the database file exist?Does web server have permission to write to the database file?Does the web server have permission to write to the directory the database file should be created in?

Can we set a higher default value for PDO::ATTR_TIMEOUT in the sqlite driver? (unless it's already very high)?

AFAIK, the default timeout is 60 seconds - \Drupal::database()->query('PRAGMA busy_timeout')->fetchField(); should show 60000 milliseconds.