首页 文章

Symfony 2.7 cache：clear命令检查每个数据库连接

提问于
浏览 次
29

我刚刚升级到symfony 2.7，并且有令人讨厌的行为 .

我的config.yml中的某些连接是可选项，并描述了不打算在每个prod实例中使用的外部数据库 .

在执行缓存时：清除，现在似乎检查了每个连接，即使我不希望它们在特定服务器上处于活动状态 .

设置--no-warmup选项时，问题发生的时间是一半

php app/console cache:clear --env=prod --no-warmup --verbose

[Doctrine \ DBAL \ Exception \ ConnectionException]驱动程序中发生异常：SQLSTATE [42000] [1049]未知数据库'bal_syncrho_database'异常跟踪:(）at / var / www / ror3 / vendor / doctrine / dbal / lib / Doctrine /DBAL/Driver/AbstractMySQLDriver.php:103 Doctrine \ DBAL \ Driver \ AbstractMySQLDriver-> convertException（）at /var/www/ror3/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:133 Doctrine \ DBAL \ DBALException :: driverException（）at /var/www/ror3/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php:47 Doctrine \ DBAL \ Driver \ PDOMySql \ Driver-> connect（） at /var/www/ror3/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:360 Doctrine \ DBAL \ Connection-> connect（）at / var / www / ror3 / vendor / doctrine / dbal / lib /Doctrine/DBAL/Connection.php:429 Doctrine \ DBAL \ Connection-> getDatabasePlatformVersion（）at /var/www/ror3/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:389 Doctrine \ DBAL \ Connection - >在/ var / www / ror3 / vendor / doctrine / dbal / lib / Doctrine / DBAL / Con中的detectDatabasePlatform（） nection.php：328 Doctrine \ DBAL \ Connection-> getDatabasePlatform（）at /var/www/ror3/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ClassMetadataFactory.php:763 Doctrine \ ORM \ Mapping \ ClassMetadataFactory- > getTargetPlatform（）位于/ var / www / ror3 /var/www/ror3/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ClassMetadataFactory.php:616 Doctrine \ ORM \ Mapping \ ClassMetadataFactory-> completeIdGeneratorMapping（）在/ var / www / ror3 / vendor / doctrine / common / lib / Doctrine / / / / / / / / / / / / / / Common / Persistence / Mapping / AbstractClassMetadataFactory.php：332 Doctrine \ Common \ Persistence \ Mapping \ AbstractClassMetadataFactory-> loadMetadata（）at /var/www/ror3/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ClassMetadataFactory.php ：78 Doctrine \ ORM \ Mapping \ ClassMetadataFactory-> loadMetadata（）at /var/www/ror3/vendor/doctrine/common/lib/Doctrine/Common/Persistence/Mapping/AbstractClassMetadataFactory.php:216 Doctr ine \ Common \ Persistence \ Mapping \ AbstractClassMetadataFactory-> getMetadataFor（）at /var/www/ror3/vendor/doctrine/common/lib/Doctrine/Common/Persistence/Mapping/AbstractClassMetadataFactory.php:115 Doctrine \ Common \ Persistence \ Mapping \ AbstractClassMetadataFactory-> getAllMetadata（）at /var/www/ror3/vendor/symfony/symfony/src/Symfony/Bridge/Doctrine/CacheWarmer/ProxyCacheWarmer.php:69 Symfony \ Bridge \ Doctrine \ CacheWarmer \ ProxyCacheWarmer-> warmUp（） at /var/www/ror3/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/CacheWarmer/CacheWarmerAggregate.php:48 / var / www / ror3中的Symfony \ Component \ HttpKernel \ CacheWarmer \ CacheWarmerAggregate-> warmUp（） /app/bootstrap.php.cache:2641 Symfony \ Component \ HttpKernel \ Kernel-> initializeContainer（）at /var/www/ror3/app/bootstrap.php.cache:2411 Symfony \ Component \ HttpKernel \ Kernel-> boot（ ）/ var / www / ry3/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Console/Application.php:70 Symfony \ Bundle \ FrameworkBundle \ Console \ Application-> doRun（）at / var / www / [R or3 / vendor / symfony / symfony / src / Symfony / Component / Console / Application.php：120 / Symfony \ Component \ Console \ Application-> run（）at / var / www / ror3 / app / console：27

php symfony doctrine2

1 回答

  • 67

    Doctrine正试图确定数据库平台版本 .

    您可以避免在Doctrine DBAL Configuration服务器版本中添加此行为 . 来自doc：

    在DoctrineBundle 1.3中使用的Doctrine DBAL 2.5中添加了server_version选项 . 此选项的值应与您的数据库服务器版本匹配（使用postgres -V或psql -V命令查找PostgreSQL版本，使用mysql -V获取MySQL版本） . 如果您没有定义此选项但尚未创建数据库，则可能会出现PDOException错误，因为Doctrine会尝试自动猜测数据库服务器版本，但没有可用的版本 .

    例如：

    #config.yml

doctrine:
    dbal:
    ...
        server_version:       5.6

    希望这有帮助

    回复于

相关问题