Retour
-
Titre
The query processor ran out of stack space during query optimization" error is encountered when creating a backup of a database with many filegroups. -
Description
The query processor ran out of stack space during query optimization" error is encountered when creating a backup of a database with many filegroups.
Replication steps -
- Create a large number of file groups (the issue starts manifesting at above 2000-2200 on current dev machines, but it varies with available memory)
- Perform a backup of this database
- The backup “The query processor ran out of stack space during query optimization. Please simplify the query.” error is encountered
The error is visible in LiteSpeed logs.
Connexion requise
Vous devez être connecté et disposer d'un contrat de maintenance en cours pour afficher les articles de la base de connaissances avancés.