zikula:install:finish fails, missing table 'groups'

Question

zikula:install:finish fails, missing table 'groups'

tacman opened this issue 3 years ago · 4 comments

Expected behaviour - What did you expect to happen?

Fails during zikula:install:finish

Current behavior - What happened instead?

error-free installation

Possible solution

Confirm that the 'groups' table is created during :start.

Steps to reproduce

run install:start, then run install:finish
                                                                                                   

 Zikula Users Module
 Installing Zikula Users Module

In ToolsException.php line 34:
                                                                                                                                                                                                                                                     
  [Doctrine\ORM\Tools\ToolsException]                                                                                                                                                                                                                
  Schema-Tool failed with Error 'An exception occurred while executing 'ALTER TABLE group_membership ADD CONSTRAINT FK_5132B3374C397118 FOREIGN KEY (gid) REFERENCES "groups" (gid) NOT DEFERRABLE INITIALLY IMMEDIATE':                             
                                                                                                                                                                                                                                                     
  SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "groups" does not exist' while executing DDL: ALTER TABLE group_membership ADD CONSTRAINT FK_5132B3374C397118 FOREIGN KEY (gid) REFERENCES "groups" (gid) NOT DEFERRABLE INITIALLY IMMEDIATE  
                                                                                                                                                                                                                                                     

Exception trace:
  at /home/tac/survos/demos/core/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/ToolsException.php:34
 Doctrine\ORM\Tools\ToolsException::schemaToolFailure() at /home/tac/survos/demos/core/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/SchemaTool.php:99
 Doctrine\ORM\Tools\SchemaTool->createSchema() at /home/tac/survos/demos/core/src/Zikula/CoreBundle/Doctrine/Helper/SchemaHelper.php:49
 Zikula\Bundle\CoreBundle\Doctrine\Helper\SchemaHelper->create() at /home/tac/survos/demos/core/src/system/UsersModule/UsersModuleInstaller.php:34
 Zikula\UsersModule\UsersModuleInstaller->install() at /home/tac/survos/demos/core/src/Zikula/CoreInstallerBundle/Helper/CoreInstallerExtensionHelper.php:109
 Zikula\Bundle\CoreInstallerBundle\Helper\CoreInstallerExtensionHelper->install() at /home/tac/survos/demos/core/src/Zikula/CoreInstallerBundle/Helper/StageHelper.php:138
 Zikula\Bundle\CoreInstallerBundle\Helper\StageHelper->executeStage() at /home/tac/survos/demos/core/src/Zikula/CoreInstallerBundle/Helper/StageHelper.php:189
 Zikula\Bundle\CoreInstallerBundle\Helper\StageHelper->handleAjaxStage() at /home/tac/survos/demos/core/src/Zikula/CoreInstallerBundle/Command/Install/FinishCommand.php:89
 Zikula\Bundle\CoreInstallerBundle\Command\Install\FinishCommand->execute() at /home/tac/survos/demos/core/vendor/symfony/console/Command/Command.php:299
 Symfony\Component\Console\Command\Command->run() at /home/tac/survos/demos/core/vendor/symfony/console/Application.php:996
 Symfony\Component\Console\Application->doRunCommand() at /home/tac/survos/demos/core/vendor/symfony/framework-bundle/Console/Application.php:96
 Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand() at /home/tac/survos/demos/core/vendor/symfony/console/Application.php:295
 Symfony\Component\Console\Application->doRun() at /home/tac/survos/demos/core/vendor/symfony/framework-bundle/Console/Application.php:82
 Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /home/tac/survos/demos/core/vendor/symfony/console/Application.php:167
 Symfony\Component\Console\Application->run() at /home/tac/survos/demos/core/vendor/symfony/runtime/Runner/Symfony/ConsoleApplicationRunner.php:56
 Symfony\Component\Runtime\Runner\Symfony\ConsoleApplicationRunner->run() at /home/tac/survos/demos/core/vendor/autoload_runtime.php:35
 require_once() at /home/tac/survos/demos/core/src/Zikula/CoreBundle/bin/console:17

In AbstractPostgreSQLDriver.php line 82:
                                                                                                                                                                                           
  [Doctrine\DBAL\Exception\TableNotFoundException]                                                                                                                                         
  An exception occurred while executing 'ALTER TABLE group_membership ADD CONSTRAINT FK_5132B3374C397118 FOREIGN KEY (gid) REFERENCES "groups" (gid) NOT DEFERRABLE INITIALLY IMMEDIATE':  
                                                                                                                                                                                           
  SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "groups" does not exist                                                                                                             
                                                                                                                                                                                           

Exception trace:
  at /home/tac/survos/demos/core/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php:82
 Doctrine\DBAL\Driver\AbstractPostgreSQLDriver->convertException() at /home/tac/survos/demos/core/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:182
 Doctrine\DBAL\DBALException::wrapException() at /home/tac/survos/demos/core/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:159
 Doctrine\DBAL\DBALException::driverExceptionDuringQuery() at /home/tac/survos/demos/core/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:2225
 Doctrine\DBAL\Connection->handleExceptionDuringQuery() at /home/tac/survos/demos/core/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1312
 Doctrine\DBAL\Connection->executeQuery() at /home/tac/survos/demos/core/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/SchemaTool.php:97
 Doctrine\ORM\Tools\SchemaTool->createSchema() at /home/tac/survos/demos/core/src/Zikula/CoreBundle/Doctrine/Helper/SchemaHelper.php:49
 Zikula\Bundle\CoreBundle\Doctrine\Helper\SchemaHelper->create() at /home/tac/survos/demos/core/src/system/UsersModule/UsersModuleInstaller.php:34
 Zikula\UsersModule\UsersModuleInstaller->install() at /home/tac/survos/demos/core/src/Zikula/CoreInstallerBundle/Helper/CoreInstallerExtensionHelper.php:109
 Zikula\Bundle\CoreInstallerBundle\Helper\CoreInstallerExtensionHelper->install() at /home/tac/survos/demos/core/src/Zikula/CoreInstallerBundle/Helper/StageHelper.php:138
 Zikula\Bundle\CoreInstallerBundle\Helper\StageHelper->executeStage() at /home/tac/survos/demos/core/src/Zikula/CoreInstallerBundle/Helper/StageHelper.php:189
 Zikula\Bundle\CoreInstallerBundle\Helper\StageHelper->handleAjaxStage() at /home/tac/survos/demos/core/src/Zikula/CoreInstallerBundle/Command/Install/FinishCommand.php:89
 Zikula\Bundle\CoreInstallerBundle\Command\Install\FinishCommand->execute() at /home/tac/survos/demos/core/vendor/symfony/console/Command/Command.php:299
 Symfony\Component\Console\Command\Command->run() at /home/tac/survos/demos/core/vendor/symfony/console/Application.php:996
 Symfony\Component\Console\Application->doRunCommand() at /home/tac/survos/demos/core/vendor/symfony/framework-bundle/Console/Application.php:96
 Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand() at /home/tac/survos/demos/core/vendor/symfony/console/Application.php:295
 Symfony\Component\Console\Application->doRun() at /home/tac/survos/demos/core/vendor/symfony/framework-bundle/Console/Application.php:82
 Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /home/tac/survos/demos/core/vendor/symfony/console/Application.php:167
 Symfony\Component\Console\Application->run() at /home/tac/survos/demos/core/vendor/symfony/runtime/Runner/Symfony/ConsoleApplicationRunner.php:56
 Symfony\Component\Runtime\Runner\Symfony\ConsoleApplicationRunner->run() at /home/tac/survos/demos/core/vendor/autoload_runtime.php:35
 require_once() at /home/tac/survos/demos/core/src/Zikula/CoreBundle/bin/console:17

In Exception.php line 18:
                                                                                
  [Doctrine\DBAL\Driver\PDO\Exception (42P01)]                                  
  SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "groups" does not exist  
                                                                                

Exception trace:
  at /home/tac/survos/demos/core/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
 Doctrine\DBAL\Driver\PDO\Exception::new() at /home/tac/survos/demos/core/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:139
 Doctrine\DBAL\Driver\PDOConnection->doQuery() at /home/tac/survos/demos/core/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php:24
 Doctrine\DBAL\Driver\PDOConnection->query() at /home/tac/survos/demos/core/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1308
 Doctrine\DBAL\Connection->executeQuery() at /home/tac/survos/demos/core/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/SchemaTool.php:97
 Doctrine\ORM\Tools\SchemaTool->createSchema() at /home/tac/survos/demos/core/src/Zikula/CoreBundle/Doctrine/Helper/SchemaHelper.php:49
 Zikula\Bundle\CoreBundle\Doctrine\Helper\SchemaHelper->create() at /home/tac/survos/demos/core/src/system/UsersModule/UsersModuleInstaller.php:34
 Zikula\UsersModule\UsersModuleInstaller->install() at /home/tac/survos/demos/core/src/Zikula/CoreInstallerBundle/Helper/CoreInstallerExtensionHelper.php:109
 Zikula\Bundle\CoreInstallerBundle\Helper\CoreInstallerExtensionHelper->install() at /home/tac/survos/demos/core/src/Zikula/CoreInstallerBundle/Helper/StageHelper.php:138
 Zikula\Bundle\CoreInstallerBundle\Helper\StageHelper->executeStage() at /home/tac/survos/demos/core/src/Zikula/CoreInstallerBundle/Helper/StageHelper.php:189
 Zikula\Bundle\CoreInstallerBundle\Helper\StageHelper->handleAjaxStage() at /home/tac/survos/demos/core/src/Zikula/CoreInstallerBundle/Command/Install/FinishCommand.php:89
 Zikula\Bundle\CoreInstallerBundle\Command\Install\FinishCommand->execute() at /home/tac/survos/demos/core/vendor/symfony/console/Command/Command.php:299
 Symfony\Component\Console\Command\Command->run() at /home/tac/survos/demos/core/vendor/symfony/console/Application.php:996
 Symfony\Component\Console\Application->doRunCommand() at /home/tac/survos/demos/core/vendor/symfony/framework-bundle/Console/Application.php:96
 Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand() at /home/tac/survos/demos/core/vendor/symfony/console/Application.php:295
 Symfony\Component\Console\Application->doRun() at /home/tac/survos/demos/core/vendor/symfony/framework-bundle/Console/Application.php:82
 Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /home/tac/survos/demos/core/vendor/symfony/console/Application.php:167
 Symfony\Component\Console\Application->run() at /home/tac/survos/demos/core/vendor/symfony/runtime/Runner/Symfony/ConsoleApplicationRunner.php:56
 Symfony\Component\Runtime\Runner\Symfony\ConsoleApplicationRunner->run() at /home/tac/survos/demos/core/vendor/autoload_runtime.php:35
 require_once() at /home/tac/survos/demos/core/src/Zikula/CoreBundle/bin/console:17

In PDOConnection.php line 137:
                                                                                
  [PDOException (42P01)]                                                        
  SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "groups" does not exist  
                                                                                

Exception trace:
  at /home/tac/survos/demos/core/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:137
 PDO->query() at /home/tac/survos/demos/core/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:137
 Doctrine\DBAL\Driver\PDOConnection->doQuery() at /home/tac/survos/demos/core/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php:24
 Doctrine\DBAL\Driver\PDOConnection->query() at /home/tac/survos/demos/core/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1308
 Doctrine\DBAL\Connection->executeQuery() at /home/tac/survos/demos/core/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/SchemaTool.php:97
 Doctrine\ORM\Tools\SchemaTool->createSchema() at /home/tac/survos/demos/core/src/Zikula/CoreBundle/Doctrine/Helper/SchemaHelper.php:49
 Zikula\Bundle\CoreBundle\Doctrine\Helper\SchemaHelper->create() at /home/tac/survos/demos/core/src/system/UsersModule/UsersModuleInstaller.php:34
 Zikula\UsersModule\UsersModuleInstaller->install() at /home/tac/survos/demos/core/src/Zikula/CoreInstallerBundle/Helper/CoreInstallerExtensionHelper.php:109
 Zikula\Bundle\CoreInstallerBundle\Helper\CoreInstallerExtensionHelper->install() at /home/tac/survos/demos/core/src/Zikula/CoreInstallerBundle/Helper/StageHelper.php:138
 Zikula\Bundle\CoreInstallerBundle\Helper\StageHelper->executeStage() at /home/tac/survos/demos/core/src/Zikula/CoreInstallerBundle/Helper/StageHelper.php:189
 Zikula\Bundle\CoreInstallerBundle\Helper\StageHelper->handleAjaxStage() at /home/tac/survos/demos/core/src/Zikula/CoreInstallerBundle/Command/Install/FinishCommand.php:89
 Zikula\Bundle\CoreInstallerBundle\Command\Install\FinishCommand->execute() at /home/tac/survos/demos/core/vendor/symfony/console/Command/Command.php:299
 Symfony\Component\Console\Command\Command->run() at /home/tac/survos/demos/core/vendor/symfony/console/Application.php:996
 Symfony\Component\Console\Application->doRunCommand() at /home/tac/survos/demos/core/vendor/symfony/framework-bundle/Console/Application.php:96
 Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand() at /home/tac/survos/demos/core/vendor/symfony/console/Application.php:295
 Symfony\Component\Console\Application->doRun() at /home/tac/survos/demos/core/vendor/symfony/framework-bundle/Console/Application.php:82
 Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /home/tac/survos/demos/core/vendor/symfony/console/Application.php:167
 Symfony\Component\Console\Application->run() at /home/tac/survos/demos/core/vendor/symfony/runtime/Runner/Symfony/ConsoleApplicationRunner.php:56
 Symfony\Component\Runtime\Runner\Symfony\ConsoleApplicationRunner->run() at /home/tac/survos/demos/core/vendor/autoload_runtime.php:35
 require_once() at /home/tac/survos/demos/core/src/Zikula/CoreBundle/bin/console:17

zikula:install:finish

Context

Using postgres 13

Zikula version

3.x-git

PHP version

8.0.x

Answer 1 · 2021-12-05T12:57:58.000Z

Hello @tacman

I suspect the issue is a result from this change.
Could you maybe try reverting this and see if this fixes the issue?

Not sure yet about what a better alternative would be, but I can think/research about it after we confirmed this is causing the Postgres problem.

Answer 2 · 2021-12-05T13:26:04.000Z

How about renaming the table instead? postgres has a different escaping strategy (double-quotes, I think). I had this same problem with the user table. There's probably some way to let the annotation property escape this table name, but I'm not sure what is it.

…

On Sun, Dec 5, 2021 at 7:58 AM Axel Guckelsberger ***@***.***> wrote: Hello @tacman <https://github.com/tacman> I suspect the issue is a result from this change <db162f6#diff-ab9d584961b297a11a8cf816d7e60c6ba1a494905ec1de0d72c1e22890877030> . Could you maybe try reverting this and see if this fixes the issue? Not sure yet about what a better alternative would be, but I can think/research about it after we confirmed this is causing the Postgres problem. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#4762 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAEXIQIEYEH2LMXAIW23XS3UPNOWBANCNFSM5F5F6LNA> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

Answer 3 · 2021-12-05T13:43:29.000Z

How about renaming the table instead?

Yes, this would be a possible solution indeed.
In our 3rd party extension generator we use a scheme <vendor>_<module>_<entity> for the table names, too.
So for example: zikula_groups_group.

Answer 4 · 2021-12-06T14:30:53.000Z

Hey @tacman,

I've proposed a patch at #4805 - fancy to give it a try?