>>> [!note] Migrated issue <!-- Drupal.org comment --> <!-- Migrated from issue #697220. --> Reported by: [hass](https://www.drupal.org/user/85918) >>> <p><em>Updated: Comment <a href="https://www.drupal.org#comment-6713406">#45</a></em></p> <h3 id="summary-problem-motivation">Problem/Motivation</h3> <p>HEAD is often broken on MySQL/MyISAM, SQLite and PostgreSQL as the testbot does not test under these environments.</p> <h3 id="summary-proposed-resolution">Proposed resolution</h3> <p>Test on all major DBs instead of just MySQL.</p> <h3 id="summary-remaining-tasks">Remaining tasks</h3> <p>A patch for PostgreSQL already exists, but does not seem to apply.</p> <ul> <li><del>Find servers to do the testing on (<a href="https://www.drupal.org#comment-2527440">#1</a> - <a href="https://www.drupal.org#comment-2551138">#12</a>)</del> Complete</li> <li><del>Consider only testing on commit and and not testing patches on "secondary" databases (<a href="https://www.drupal.org#comment-2549406">#11</a> - <a href="https://www.drupal.org#comment-2551138">#12 and </a><a href="https://www.drupal.org#comment-5650802">#37</a>)</del> Alternate environment tests can be run on-demand via qa.d.o</li> <li><del>Consider generalizing the PostgreSQL code for SQLite, or just create separate SQLite code. (<a href="https://www.drupal.org#comment-3098466">#24</a> - <a href="https://www.drupal.org#comment-3102104">#27</a></del> Dedicated core sqlite and postgres bots are now set up</li> <li><del>Eliminate the dependency on all environments completing before results returning (<a href="https://www.drupal.org#comment-5651240">#39</a>)</del> Hacky, but we're getting around this by tricking qa.d.o into thinking these tests are for a different project client.</li> <li><span class="drupalorg-gitlab-issue-link project-issue-status-info project-issue-status-13"><a href="https://www.drupal.org/project/drupal/issues/2152443" title="Status: Needs work">#2152443: Allow settings.php to specify the table engine</a></span> is blocking creation of a dedicated MyISAM testbot</li> <li>Concerns in <a href="https://www.drupal.org#comment-3649738">#32</a> <ul> <li><del>1. Multiple PIFR Environments was tried out when Coder reviews were deployed, but contributed to instability of the testing infrastructure. The system currently does not scale up well with multiple environments, as all environments need to complete testing before a final test result is passed back to drupal.org. We do have advisory tests working for 'Coder' tests, which should apply across to different environments instead of plugins. (See <span class="drupalorg-gitlab-issue-link project-issue-status-info project-issue-status-7"><a href="https://www.drupal.org/project/project_issue_file_review/issues/830838" title="Status: Closed (fixed)">#830838: Allow configurable "Advisory" reviews</a></span>)</del> Hacky, but we're getting around this by tricking qa.d.o into thinking these tests are for a different project client. </li> <li>2. The non-mysql databases don't pass cleanly yet. See <a href="https://drupal.org/comment/8252251#comment-8252251">https://drupal.org/comment/8252251#comment-8252251</a></li> </ul></li> </ul> <h3 id="summary-related-issues">Related Issues</h3> <p><span class="drupalorg-gitlab-issue-link project-issue-status-info project-issue-status-7"><a href="https://www.drupal.org/project/project_issue_file_review/issues/830838" title="Status: Closed (fixed)">#830838: Allow configurable "Advisory" reviews</a></span><br> <span class="drupalorg-gitlab-issue-link project-issue-status-info project-issue-status-3"><a href="https://www.drupal.org/project/testbot/issues/1371054" title="Status: Closed (duplicate)">#1371054: Create testbots for pgsql, sqlite</a></span></p> <h4>Would have been caught by this</h4> <p><span class="drupalorg-gitlab-issue-link project-issue-status-info project-issue-status-7"><a href="https://www.drupal.org/project/drupal/issues/1998366" title="Status: Closed (fixed)">#1998366: [meta] SQLite is broken</a></span><br> <span class="drupalorg-gitlab-issue-link project-issue-status-info project-issue-status-7"><a href="https://www.drupal.org/project/drupal/issues/1987262" title="Status: Closed (fixed)">#1987262: [Installation Error] Symfony: "The service definition 'request' does not exist."</a></span></p> <h3 id="summary-original-report">Original report by hass in the d.o Infrastructure Queue</h3> <p>Is there any chance that patches are tested against all supported databases and not only mysql with innodb?</p> > Related issue: [Issue #2152443](https://www.drupal.org/node/2152443) > Related issue: [Issue #2275535](https://www.drupal.org/node/2275535)