Hello
When trying to install the versions of Drupal 8.1.10, 8.5.9 and 8.6.3(I just tried these versions) it returns the following error.

I'm running under Ubuntu 16.04 on a Docker engine with php 7.0, apache 2.4.18, Microsoft ODBC Driver 17 for SQL Server, sqlsrv 2.13 module drupal, phpmssql with remote SQL Server database on azure.com.

Create some tables in the database and then return the following error on the screen:

Additional uncaught exception thrown while handling exception.
Original

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY010]: [unixODBC][Driver Manager]Function sequence error: DELETE FROM {cache_discovery} WHERE ([cid] IN (:db_condition_placeholder_0)) ; Array ( [:db_condition_placeholder_0] => typed_config_definitions ) in Drupal\Core\Plugin\DefaultPluginManager->clearCachedDefinitions() (line 190 of /var/www/html/web1/core/lib/Drupal/Core/Plugin/DefaultPluginManager.php).

Drupal\Core\Plugin\DefaultPluginManager->clearCachedDefinitions() (Line: 268)
Drupal\Core\TypedData\TypedDataManager->clearCachedDefinitions() (Line: 198)
Drupal\Core\Config\TypedConfigManager->clearCachedDefinitions() (Line: 31)
Drupal\Core\Plugin\CachedDiscoveryClearer->clearCachedDefinitions() (Line: 83)
Drupal\Core\ProxyClass\Plugin\CachedDiscoveryClearer->clearCachedDefinitions() (Line: 200)
Drupal\Core\Extension\ModuleInstaller->install(Array, ) (Line: 83)
Drupal\Core\ProxyClass\Extension\ModuleInstaller->install(Array, ) (Line: 625)
drupal_install_system(Array) (Line: 1037)
install_base_system(Array) (Line: 660)
install_run_task(Array, Array) (Line: 538)
install_run_tasks(Array) (Line: 115)
install_drupal(Object) (Line: 39)

Additional

Symfony\Component\Routing\Exception\RouteNotFoundException: Route "<none>" does not exist. in Drupal\Core\Routing\RouteProvider->getRouteByName() (line 187 of /var/www/html/web1/core/lib/Drupal/Core/Routing/RouteProvider.php).

Drupal\Core\Routing\RouteProvider->getRouteByName('') (Line: 425)
Drupal\Core\Routing\UrlGenerator->getRoute('') (Line: 121)
Drupal\Core\Routing\UrlGenerator->getPathFromRoute('', Array) (Line: 68)
Drupal\Core\Render\MetadataBubblingUrlGenerator->getPathFromRoute('', Array) (Line: 772)
Drupal\Core\Url->getInternalPath() (Line: 99)
Drupal\Core\Path\PathMatcher->isFrontPage() (Line: 254)
system_theme_suggestions_html(Array)
call_user_func_array('system_theme_suggestions_html', Array) (Line: 402)
Drupal\Core\Extension\ModuleHandler->invokeAll('theme_suggestions_html', Array) (Line: 230)
Drupal\Core\Theme\ThemeManager->render('html', Array) (Line: 435)
Drupal\Core\Render\Renderer->doRender(Array, 1) (Line: 195)
Drupal\Core\Render\Renderer->render(Array, 1) (Line: 139)
Drupal\Core\Render\Renderer->Drupal\Core\Render\{closure}() (Line: 574)
Drupal\Core\Render\Renderer->executeInRenderContext(Object, Object) (Line: 140)
Drupal\Core\Render\Renderer->renderRoot(Array) (Line: 66)
Drupal\Core\Render\BareHtmlPageRenderer->renderBarePage(Array, 'Error', 'install_page', Array) (Line: 76)
Drupal\Core\ProxyClass\Render\BareHtmlPageRenderer->renderBarePage(Array, 'Error', 'install_page', Array) (Line: 998)
install_display_output(Array, Array, Array) (Line: 263)
_drupal_log_error(Array, 1) (Line: 564)
_drupal_exception_handler(Object)

Any idea that can be?

Thank you very much for your time

Comments

dalesolucion created an issue. See original summary.

julianmancera’s picture

julianmancera commented

Hi dalesolucion,

Getting something similar situation here during instalation. Did you get to overcome this issue?

Please some advise is really appreciated, I'm stuck.

Julian

david_garcia’s picture

david_garcia commented

Try to upgrade all your stack, I have seen this error sometimes with outdated version of the PDO driver:

https://github.com/microsoft/msphpsql/releases

david_garcia’s picture

david_garcia commented

Closed a duplicate in https://www.drupal.org/project/sqlsrv/issues/2989395

david_garcia’s picture

david_garcia commented
Title: Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY010]: [unixODBC][Driver Manager]Function sequence error: DELETE FROM {cache_discovery} WHERE ([cid] IN (:db_condition_placeholder_0)) » SQLSTATE[HY010]: [unixODBC][Driver Manager]Function sequence error
avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Issue tags: -bug, -8.6.x
hexblot’s picture

hexblot commented

Same error during Drupal latest (via composer create-project drupal-composer/drupal-project:8.x-dev) installation.
Options to add SQL Server details are shown (so module installation is ok), then installation crashes after the first two-three tables are created.

OS is CentOS7.7, PHP7.3. Using branch 8.x-1.x (posting here since the duplicate that was closed was for that branch).

Version of PDO is latest:

[root@sandbox default]# php -r '$con=new PDO("sqlsrv:Server=1.2.3.4,1433;Database=sandbox", "sa","sa");print_r($con->getAttribute(PDO::ATTR_CLIENT_VERSION));'
Array
(
    [DriverName] => libmsodbcsql-17.4.so.1.1
    [DriverODBCVer] => 03.52
    [DriverVer] => 17.04.0001
    [ExtensionVer] => 5.6.1
)
david_garcia’s picture

david_garcia commented

Function Sequence Error is a bug in the PDO driver.

If you can make a repo script (isolated) post it to the SQLSRV PDO team:

https://github.com/microsoft/msphpsql

Thanks!

hexblot’s picture

hexblot commented

They have already replied to (your) error submission that this specific issue has to do with buffered queries and/or old versions.

As this error occurs specifically when installing Drupal, I do not think I can create a (small) repro script.
Can you (or someone else) normally install Drupal 8 with the 1.x branch, when not on the same server as the SQL server (ideally a Linux webserver)?

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Version: 8.x-2.13 » 8.x-2.x-dev
beakerboy’s picture

beakerboy
Primary language English
Location Kentucky
commented
Status: Active » Closed (won't fix)

This branch is no longer supported. The latest PDO driver has a bug fix that may have caused this issue. Currently supported branches pass the core install test suites.