Skip to content

Running php app/console strange database error #12278

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
koemeet opened this issue Oct 21, 2014 · 21 comments
Closed

Running php app/console strange database error #12278

koemeet opened this issue Oct 21, 2014 · 21 comments

Comments

@koemeet
Copy link

koemeet commented Oct 21, 2014

I have a Symfony2 application (2.6.x-dev, problem only occurs on 2.6.x) and I am running into some strange problems. If I delete the database that my application connects to and the run the following:

php app/console

It should display only a list of the commands I could run, but instead, it will throw the following error:

[PDOException]                                      
  SQLSTATE[HY000] [1049] Unknown database 'mango_db' 

Why is this happening? This way I can't run the php app/console doctrine:database:create command, because it throws this exception.

If I switch to Symfony 2.5.x-dev, the problem goes away and I can run php app/console.

Here a detailed stacktrace when I access it through the browser (maybe some helpful information).

PDOException in PDOConnection.php line 40:
SQLSTATE[HY000] [1049] Unknown database 'mango_db'
in PDOConnection.php line 40
at PDO->__construct('mysql:host=127.0.0.1;dbname=mango_db;charset=UTF8;', 'root', null, array()) in PDOConnection.php line 40
at PDOConnection->__construct('mysql:host=127.0.0.1;dbname=mango_db;charset=UTF8;', 'root', null, array()) in Driver.php line 41
at Driver->connect(array('driver' => 'pdo_mysql', 'host' => '127.0.0.1', 'port' => null, 'dbname' => 'mango_db', 'user' => 'root', 'password' => null, 'charset' => 'UTF8', 'driverOptions' => array()), 'root', null, array()) in Connection.php line 356
at Connection->connect() in Connection.php line 680
at Connection->executeQuery('SELECT s0_.namespace AS namespace0, s0_.name AS name1, s0_.value AS value2, s0_.id AS id3 FROM sylius_settings_parameter s0_ WHERE s0_.namespace = ?', array('general'), array('2'), null) in SingleSelectExecutor.php line 50
at SingleSelectExecutor->execute(object(Connection), array('general'), array('2')) in Query.php line 286
at Query->_doExecute() in AbstractQuery.php line 794
at AbstractQuery->execute(null, '1') in AbstractQuery.php line 574
at AbstractQuery->getResult() in EntityRepository.php line 106
at EntityRepository->findBy(array('namespace' => 'general')) in SettingsManager.php line 190
at SettingsManager->getParameters('general') in SettingsManager.php line 103
at SettingsManager->loadSettings('general') in CurrencyContext.php line 41
at CurrencyContext->getDefaultCurrency() in CurrencyContext.php line 36
at CurrencyContext->__construct(object(Session), object(SecurityContext), object(SettingsManager), object(EntityManager)) in appDevDebugProjectContainer.php line 10918
at appDevDebugProjectContainer->getSylius_Context_CurrencyService() in bootstrap.php.cache line 2077
at Container->get('sylius.context.currency') in appDevDebugProjectContainer.php line 16331
at appDevDebugProjectContainer->getSylius_Templating_Helper_MoneyService() in bootstrap.php.cache line 2077
at Container->get('sylius.templating.helper.money') in appDevDebugProjectContainer.php line 18621
at appDevDebugProjectContainer->getTwigService() in bootstrap.php.cache line 2077
at Container->get('twig') in appDevDebugProjectContainer.php line 16526
at appDevDebugProjectContainer->getTemplatingService() in bootstrap.php.cache line 2077
at Container->get('templating') in appDevDebugProjectContainer.php line 9097
at appDevDebugProjectContainer->getNelmioApiDoc_Formatter_HtmlFormatterService() in bootstrap.php.cache line 2077
at Container->get('nelmio_api_doc.formatter.html_formatter') in appDevDebugProjectContainer.php line 9046
at appDevDebugProjectContainer->getNelmioApiDoc_EventListener_RequestService() in bootstrap.php.cache line 2077
at Container->get('nelmio_api_doc.event_listener.request') in classes.php line 4468
at ContainerAwareEventDispatcher->lazyLoad('kernel.request') in classes.php line 4436
at ContainerAwareEventDispatcher->getListeners('kernel.request') in TraceableEventDispatcher.php line 215
at TraceableEventDispatcher->preProcess('kernel.request') in TraceableEventDispatcher.php line 107
at TraceableEventDispatcher->dispatch('kernel.request', object(GetResponseEvent)) in bootstrap.php.cache line 2986
at HttpKernel->handleRaw(object(Request), '1') in bootstrap.php.cache line 2959
at HttpKernel->handle(object(Request), '1', true) in bootstrap.php.cache line 3108
at ContainerAwareHttpKernel->handle(object(Request), '1', true) in bootstrap.php.cache line 2353
at Kernel->handle(object(Request)) in app_dev.php line 31
@linaori
Copy link
Contributor

linaori commented Oct 21, 2014

Looks like a configuration issue. You should check if you connection information is set properly in config.yml/parameters.yml.

@koemeet
Copy link
Author

koemeet commented Oct 21, 2014

@iltar The configuration is correct, if I switch to Symfony 2.5.x-dev everything works fine. Also I can run php app/console as expected. But when I switch to 2.6.x-dev I get the exception. Somehow it triggers a DB connection when only bootstrapping the console application.

@koemeet
Copy link
Author

koemeet commented Oct 21, 2014

Also if I create the database (php app/console doctrine:database:create) while using Symfony 2.5.x and then switch to 2.6.x I can use the command again. But this seems like a bug somewhere in Symfony.

@linaori
Copy link
Contributor

linaori commented Oct 21, 2014

Have you cleared the cache in between?

@koemeet
Copy link
Author

koemeet commented Oct 21, 2014

Cache clear isnt working either. The whole php app/console is broken by that exception. I did clear the cache folders manually, but still the same.

@linaori
Copy link
Contributor

linaori commented Oct 21, 2014

Can you run app/console with debug and verbosity to see if it gives more info? It seems like your connection parameters are incorrect in 2.6. I'm not sure if there was a PR that might have broken this as mine worked fine.

@koemeet
Copy link
Author

koemeet commented Oct 21, 2014

This is my configuration for doctrine:

parameters:
    sylius.database.driver: pdo_mysql
    sylius.database.host: 127.0.0.1
    sylius.database.port: null
    sylius.database.name: mango_db
    sylius.database.path: null
    sylius.database.user: root
    sylius.database.password: null
doctrine:
    dbal:
        driver:   %sylius.database.driver%
        host:     %sylius.database.host%
        port:     %sylius.database.port%
        dbname:   %sylius.database.name%
        user:     %sylius.database.user%
        password: %sylius.database.password%
        charset:  UTF8
    orm:
        auto_generate_proxy_classes: %kernel.debug%
        entity_managers:
            default:
                auto_mapping: true
                mappings:
                    gedmo_loggable:
                        type: annotation
                        prefix: Gedmo\Loggable\Entity
                        dir: "%kernel.root_dir%/../vendor/gedmo/doctrine-extensions/lib/Gedmo/Loggable/Entity"
                        is_bundle: false
                filters:
                    softdeleteable:
                        class: Gedmo\SoftDeleteable\Filter\SoftDeleteableFilter
                        enabled: true

Stacktrace from php app/console --debug --verbose

  [PDOException]                                      
  SQLSTATE[HY000] [1049] Unknown database 'mango_db'  



Exception trace:
 () at /Users/Steffen/Development/mango/mango-api/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:40
 PDO->__construct() at /Users/Steffen/Development/mango/mango-api/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:40
 Doctrine\DBAL\Driver\PDOConnection->__construct() at /Users/Steffen/Development/mango/mango-api/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php:41
 Doctrine\DBAL\Driver\PDOMySql\Driver->connect() at /Users/Steffen/Development/mango/mango-api/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:356
 Doctrine\DBAL\Connection->connect() at /Users/Steffen/Development/mango/mango-api/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:680
 Doctrine\DBAL\Connection->executeQuery() at /Users/Steffen/Development/mango/mango-api/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:50
 Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute() at /Users/Steffen/Development/mango/mango-api/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:286
 Doctrine\ORM\Query->_doExecute() at /Users/Steffen/Development/mango/mango-api/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:794
 Doctrine\ORM\AbstractQuery->execute() at /Users/Steffen/Development/mango/mango-api/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:574
 Doctrine\ORM\AbstractQuery->getResult() at /Users/Steffen/Development/mango/mango-api/vendor/sylius/sylius/src/Sylius/Bundle/ResourceBundle/Doctrine/ORM/EntityRepository.php:106
 Sylius\Bundle\ResourceBundle\Doctrine\ORM\EntityRepository->findBy() at /Users/Steffen/Development/mango/mango-api/vendor/sylius/sylius/src/Sylius/Bundle/SettingsBundle/Manager/SettingsManager.php:190
 Sylius\Bundle\SettingsBundle\Manager\SettingsManager->getParameters() at /Users/Steffen/Development/mango/mango-api/vendor/sylius/sylius/src/Sylius/Bundle/SettingsBundle/Manager/SettingsManager.php:103
 Sylius\Bundle\SettingsBundle\Manager\SettingsManager->loadSettings() at /Users/Steffen/Development/mango/mango-api/vendor/sylius/sylius/src/Sylius/Bundle/CoreBundle/Context/CurrencyContext.php:41
 Sylius\Bundle\CoreBundle\Context\CurrencyContext->getDefaultCurrency() at /Users/Steffen/Development/mango/mango-api/vendor/sylius/sylius/src/Sylius/Bundle/CoreBundle/Context/CurrencyContext.php:36
 Sylius\Bundle\CoreBundle\Context\CurrencyContext->__construct() at /Users/Steffen/Development/mango/mango-api/app/cache/dev/appDevDebugProjectContainer.php:10918
 appDevDebugProjectContainer->getSylius_Context_CurrencyService() at /Users/Steffen/Development/mango/mango-api/app/bootstrap.php.cache:2077
 Symfony\Component\DependencyInjection\Container->get() at /Users/Steffen/Development/mango/mango-api/app/cache/dev/appDevDebugProjectContainer.php:16331
 appDevDebugProjectContainer->getSylius_Templating_Helper_MoneyService() at /Users/Steffen/Development/mango/mango-api/app/bootstrap.php.cache:2077
 Symfony\Component\DependencyInjection\Container->get() at /Users/Steffen/Development/mango/mango-api/app/cache/dev/appDevDebugProjectContainer.php:18621
 appDevDebugProjectContainer->getTwigService() at /Users/Steffen/Development/mango/mango-api/app/bootstrap.php.cache:2077
 Symfony\Component\DependencyInjection\Container->get() at /Users/Steffen/Development/mango/mango-api/app/cache/dev/appDevDebugProjectContainer.php:16526
 appDevDebugProjectContainer->getTemplatingService() at /Users/Steffen/Development/mango/mango-api/app/bootstrap.php.cache:2077
 Symfony\Component\DependencyInjection\Container->get() at /Users/Steffen/Development/mango/mango-api/app/cache/dev/appDevDebugProjectContainer.php:9097
 appDevDebugProjectContainer->getNelmioApiDoc_Formatter_HtmlFormatterService() at /Users/Steffen/Development/mango/mango-api/app/bootstrap.php.cache:2077
 Symfony\Component\DependencyInjection\Container->get() at /Users/Steffen/Development/mango/mango-api/app/cache/dev/appDevDebugProjectContainer.php:9046
 appDevDebugProjectContainer->getNelmioApiDoc_EventListener_RequestService() at /Users/Steffen/Development/mango/mango-api/app/bootstrap.php.cache:2077
 Symfony\Component\DependencyInjection\Container->get() at /Users/Steffen/Development/mango/mango-api/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/ContainerAwareEventDispatcher.php:188
 Symfony\Component\EventDispatcher\ContainerAwareEventDispatcher->lazyLoad() at /Users/Steffen/Development/mango/mango-api/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/ContainerAwareEventDispatcher.php:77
 Symfony\Component\EventDispatcher\ContainerAwareEventDispatcher->removeListener() at /Users/Steffen/Development/mango/mango-api/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/EventListener/DebugHandlersListener.php:69
 Symfony\Component\HttpKernel\EventListener\DebugHandlersListener->configure() at n/a:n/a
 call_user_func() at /Users/Steffen/Development/mango/mango-api/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/Debug/WrappedListener.php:59
 Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke() at n/a:n/a
 call_user_func() at /Users/Steffen/Development/mango/mango-api/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcher.php:164
 Symfony\Component\EventDispatcher\EventDispatcher->doDispatch() at /Users/Steffen/Development/mango/mango-api/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcher.php:53
 Symfony\Component\EventDispatcher\EventDispatcher->dispatch() at /Users/Steffen/Development/mango/mango-api/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/ContainerAwareEventDispatcher.php:167
 Symfony\Component\EventDispatcher\ContainerAwareEventDispatcher->dispatch() at /Users/Steffen/Development/mango/mango-api/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/Debug/TraceableEventDispatcher.php:112
 Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch() at /Users/Steffen/Development/mango/mango-api/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:878
 Symfony\Component\Console\Application->doRunCommand() at /Users/Steffen/Development/mango/mango-api/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:195
 Symfony\Component\Console\Application->doRun() at /Users/Steffen/Development/mango/mango-api/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Console/Application.php:96
 Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /Users/Steffen/Development/mango/mango-api/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:126
 Symfony\Component\Console\Application->run() at /Users/Steffen/Development/mango/mango-api/app/console:27

@koemeet
Copy link
Author

koemeet commented Oct 21, 2014

@iltar I think I found it. When I removed the NelmioApiDocBundle the exception goes away. Somehow this bundle has an EventListener or something that is triggers even in the console? Don't know if this problem is related to Symfony or not.

@kingcrunch
Copy link
Contributor

@iltar Hi. I've the same issue, but I don't use the NelmioApiDocBundle. I have an idea, what happens, although I can't explain, why it works for @steffenbrem now 😉

DebugHandlersListener::configure()'](https://github.com/symfony/symfony/blob/3da6fc22c6c4533b2b63e9a711a19a807ec2bb1e/src/Symfony/Component/HttpKernel/EventListener/DebugHandlersListener.php#L69): Here the debug listener tries to remove itself from all subscribed events, which includes ([DebugHandlersListener::getSubscribedEvents()](https://github.com/symfony/symfony/blob/3da6fc22c6c4533b2b63e9a711a19a807ec2bb1e/src/Symfony/Component/HttpKernel/EventListener/DebugHandlersListener.php#L129)). Trying to remove a listener from the [ContainerAwareEventDispatcher` tries to load them.

Now, because it loads all listeners registered for the kernel-request-event it also loads something security related, which loads (in my case) the user manager from the FOSUserBundle, which loads its repository, which tries to fetch its metadata, which at the end tries to connect to the database.

I for myself have no idea how to solve this... There are some questions in my mind, like "why does the dispatcher actually instanciate the listeners, when he just wants to remove one?", or "why does it even touch the kernel-request-event on CLI?".
Somehow slightly related is, that even if this concrete issue is solved, there may be valid use-cases, where a command line listener wants to fetch some data from the database.

Update: I guess the commit 4d0ab7dd introduced the issue. It's not so long ago, that it was introduced.

@jakzal
Copy link
Contributor

jakzal commented Oct 21, 2014

Looks like the issue was introduced by #12081. ping @nicolas-grekas ;)

DebugHandlersListener now calls removeListeners(), which triggers loading listeners from the container. Some services in @steffenbrem's project depend on doctrine, which makes a db connection.

@jakzal
Copy link
Contributor

jakzal commented Oct 21, 2014

@kingcrunch looks like I was minute too late ;)

@koemeet
Copy link
Author

koemeet commented Oct 21, 2014

Good catch!

fabpot added a commit that referenced this issue Oct 26, 2014
This PR was merged into the 2.6-dev branch.

Discussion
----------

Various fixes

| Q             | A
| ------------- | ---
| Bug fix?      | yes
| New feature?  | no
| BC breaks?    | no
| Deprecations? | no
| Tests pass?   | yes
| Fixed tickets | #12278
| License       | MIT
| Doc PR        | -

A 3 in one PR (diff is best viewed [with whitespaces ignored](https://github.com/symfony/symfony/pull/12285/files?w=1)):
- changed the way the DebugHandlerListeners desactivates itself
- reduced a N×N iteration to a N one in ContainerAwareEventListener::removeListener
- fixed an issue in VarDumper

Commits
-------

ac8efd9 [HttpKernel] fix DebugHandlersListener
5af0f89 [EventDispatcher] perf optim
c7cf6cf [VarDumper] fix control chars styling
@fabpot fabpot closed this as completed Oct 26, 2014
@cleentfaar
Copy link

It seems to me this issue isn't fixed; it's still occuring on my installation (2.6.1). Below is a dump of the output after running doctrine:database:create. At first glance it appears that unrelated services/listeners are being triggered and causing database-calls to be done when the database doesn't exist yet.

vagrant@myproject-dev:~/apps/myproject$ php app/console doctrine:database:create -v



  [Doctrine\DBAL\Exception\ConnectionException]                                    
  An exception occured in driver: SQLSTATE[42000] [1049] Unknown database 'myproject'  



Exception trace:
 () at /home/vagrant/apps/myproject/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:103
 Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException() at /home/vagrant/apps/myproject/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:133
 Doctrine\DBAL\DBALException::driverException() at /home/vagrant/apps/myproject/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php:47
 Doctrine\DBAL\Driver\PDOMySql\Driver->connect() at /home/vagrant/apps/myproject/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:360
 Doctrine\DBAL\Connection->connect() at /home/vagrant/apps/myproject/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:429
 Doctrine\DBAL\Connection->getDatabasePlatformVersion() at /home/vagrant/apps/myproject/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:389
 Doctrine\DBAL\Connection->detectDatabasePlatform() at /home/vagrant/apps/myproject/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:328
 Doctrine\DBAL\Connection->getDatabasePlatform() at /home/vagrant/apps/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ClassMetadataFactory.php:81
 Doctrine\ORM\Mapping\ClassMetadataFactory->initialize() at /home/vagrant/apps/myproject/vendor/doctrine/common/lib/Doctrine/Common/Persistence/Mapping/AbstractClassMetadataFactory.php:292
 Doctrine\Common\Persistence\Mapping\AbstractClassMetadataFactory->loadMetadata() at /home/vagrant/apps/myproject/vendor/doctrine/common/lib/Doctrine/Common/Persistence/Mapping/AbstractClassMetadataFactory.php:211
 Doctrine\Common\Persistence\Mapping\AbstractClassMetadataFactory->getMetadataFor() at /home/vagrant/apps/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php:295
 Doctrine\ORM\EntityManager->getClassMetadata() at /home/vagrant/apps/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Repository/DefaultRepositoryFactory.php:67
 Doctrine\ORM\Repository\DefaultRepositoryFactory->createRepository() at /home/vagrant/apps/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Repository/DefaultRepositoryFactory.php:50
 Doctrine\ORM\Repository\DefaultRepositoryFactory->getRepository() at /home/vagrant/apps/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php:759
 Doctrine\ORM\EntityManager->getRepository() at /home/vagrant/apps/myproject/app/cache/dev/jms_diextra/doctrine/EntityManager_54870b233dd19.php:207
 EntityManager54870b233dd19_546a8d27f194334ee012bfe64f629947b07e4919\__CG__\Doctrine\ORM\EntityManager->getRepository() at /home/vagrant/apps/myproject/vendor/friendsofsymfony/user-bundle/FOS/UserBundle/Doctrine/UserManager.php:40
 FOS\UserBundle\Doctrine\UserManager->__construct() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:6518
 appDevDebugProjectContainer->getFosUser_UserManagerService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:10638
 appDevDebugProjectContainer->getFosUser_UserProvider_UsernameEmailService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:10761
 appDevDebugProjectContainer->getSecurity_Authentication_ManagerService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:7901
 appDevDebugProjectContainer->getSecurity_AuthorizationCheckerService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:7914
 appDevDebugProjectContainer->getSecurity_ContextService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:10262
 appDevDebugProjectContainer->getTwigService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:8641
 appDevDebugProjectContainer->getTemplatingService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:4560
 appDevDebugProjectContainer->getFmIo_Export_FeedWriterService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:4543
 appDevDebugProjectContainer->getFmIo_Export_FeedExporterService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:4440
 appDevDebugProjectContainer->getFmIo_Command_Export_CreateService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Console/Application.php:111
 Symfony\Bundle\FrameworkBundle\Console\Application->registerCommands() at /home/vagrant/apps/myproject/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Console/Application.php:73
 Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /home/vagrant/apps/myproject/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:126
 Symfony\Component\Console\Application->run() at /home/vagrant/apps/myproject/app/console:27





  [Doctrine\DBAL\Driver\PDOException]              
  SQLSTATE[42000] [1049] Unknown database 'myproject'  



Exception trace:
 () at /home/vagrant/apps/myproject/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:47
 Doctrine\DBAL\Driver\PDOConnection::__construct() at /home/vagrant/apps/myproject/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php:45
 Doctrine\DBAL\Driver\PDOMySql\Driver->connect() at /home/vagrant/apps/myproject/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:360
 Doctrine\DBAL\Connection->connect() at /home/vagrant/apps/myproject/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:429
 Doctrine\DBAL\Connection->getDatabasePlatformVersion() at /home/vagrant/apps/myproject/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:389
 Doctrine\DBAL\Connection->detectDatabasePlatform() at /home/vagrant/apps/myproject/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:328
 Doctrine\DBAL\Connection->getDatabasePlatform() at /home/vagrant/apps/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ClassMetadataFactory.php:81
 Doctrine\ORM\Mapping\ClassMetadataFactory->initialize() at /home/vagrant/apps/myproject/vendor/doctrine/common/lib/Doctrine/Common/Persistence/Mapping/AbstractClassMetadataFactory.php:292
 Doctrine\Common\Persistence\Mapping\AbstractClassMetadataFactory->loadMetadata() at /home/vagrant/apps/myproject/vendor/doctrine/common/lib/Doctrine/Common/Persistence/Mapping/AbstractClassMetadataFactory.php:211
 Doctrine\Common\Persistence\Mapping\AbstractClassMetadataFactory->getMetadataFor() at /home/vagrant/apps/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php:295
 Doctrine\ORM\EntityManager->getClassMetadata() at /home/vagrant/apps/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Repository/DefaultRepositoryFactory.php:67
 Doctrine\ORM\Repository\DefaultRepositoryFactory->createRepository() at /home/vagrant/apps/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Repository/DefaultRepositoryFactory.php:50
 Doctrine\ORM\Repository\DefaultRepositoryFactory->getRepository() at /home/vagrant/apps/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php:759
 Doctrine\ORM\EntityManager->getRepository() at /home/vagrant/apps/myproject/app/cache/dev/jms_diextra/doctrine/EntityManager_54870b233dd19.php:207
 EntityManager54870b233dd19_546a8d27f194334ee012bfe64f629947b07e4919\__CG__\Doctrine\ORM\EntityManager->getRepository() at /home/vagrant/apps/myproject/vendor/friendsofsymfony/user-bundle/FOS/UserBundle/Doctrine/UserManager.php:40
 FOS\UserBundle\Doctrine\UserManager->__construct() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:6518
 appDevDebugProjectContainer->getFosUser_UserManagerService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:10638
 appDevDebugProjectContainer->getFosUser_UserProvider_UsernameEmailService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:10761
 appDevDebugProjectContainer->getSecurity_Authentication_ManagerService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:7901
 appDevDebugProjectContainer->getSecurity_AuthorizationCheckerService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:7914
 appDevDebugProjectContainer->getSecurity_ContextService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:10262
 appDevDebugProjectContainer->getTwigService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:8641
 appDevDebugProjectContainer->getTemplatingService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:4560
 appDevDebugProjectContainer->getFmIo_Export_FeedWriterService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:4543
 appDevDebugProjectContainer->getFmIo_Export_FeedExporterService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:4440
 appDevDebugProjectContainer->getFmIo_Command_Export_CreateService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Console/Application.php:111
 Symfony\Bundle\FrameworkBundle\Console\Application->registerCommands() at /home/vagrant/apps/myproject/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Console/Application.php:73
 Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /home/vagrant/apps/myproject/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:126
 Symfony\Component\Console\Application->run() at /home/vagrant/apps/myproject/app/console:27





  [PDOException]                                   
  SQLSTATE[42000] [1049] Unknown database 'myproject'  



Exception trace:
 () at /home/vagrant/apps/myproject/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43
 PDO->__construct() at /home/vagrant/apps/myproject/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43
 Doctrine\DBAL\Driver\PDOConnection->__construct() at /home/vagrant/apps/myproject/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php:45
 Doctrine\DBAL\Driver\PDOMySql\Driver->connect() at /home/vagrant/apps/myproject/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:360
 Doctrine\DBAL\Connection->connect() at /home/vagrant/apps/myproject/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:429
 Doctrine\DBAL\Connection->getDatabasePlatformVersion() at /home/vagrant/apps/myproject/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:389
 Doctrine\DBAL\Connection->detectDatabasePlatform() at /home/vagrant/apps/myproject/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:328
 Doctrine\DBAL\Connection->getDatabasePlatform() at /home/vagrant/apps/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ClassMetadataFactory.php:81
 Doctrine\ORM\Mapping\ClassMetadataFactory->initialize() at /home/vagrant/apps/myproject/vendor/doctrine/common/lib/Doctrine/Common/Persistence/Mapping/AbstractClassMetadataFactory.php:292
 Doctrine\Common\Persistence\Mapping\AbstractClassMetadataFactory->loadMetadata() at /home/vagrant/apps/myproject/vendor/doctrine/common/lib/Doctrine/Common/Persistence/Mapping/AbstractClassMetadataFactory.php:211
 Doctrine\Common\Persistence\Mapping\AbstractClassMetadataFactory->getMetadataFor() at /home/vagrant/apps/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php:295
 Doctrine\ORM\EntityManager->getClassMetadata() at /home/vagrant/apps/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Repository/DefaultRepositoryFactory.php:67
 Doctrine\ORM\Repository\DefaultRepositoryFactory->createRepository() at /home/vagrant/apps/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Repository/DefaultRepositoryFactory.php:50
 Doctrine\ORM\Repository\DefaultRepositoryFactory->getRepository() at /home/vagrant/apps/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php:759
 Doctrine\ORM\EntityManager->getRepository() at /home/vagrant/apps/myproject/app/cache/dev/jms_diextra/doctrine/EntityManager_54870b233dd19.php:207
 EntityManager54870b233dd19_546a8d27f194334ee012bfe64f629947b07e4919\__CG__\Doctrine\ORM\EntityManager->getRepository() at /home/vagrant/apps/myproject/vendor/friendsofsymfony/user-bundle/FOS/UserBundle/Doctrine/UserManager.php:40
 FOS\UserBundle\Doctrine\UserManager->__construct() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:6518
 appDevDebugProjectContainer->getFosUser_UserManagerService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:10638
 appDevDebugProjectContainer->getFosUser_UserProvider_UsernameEmailService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:10761
 appDevDebugProjectContainer->getSecurity_Authentication_ManagerService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:7901
 appDevDebugProjectContainer->getSecurity_AuthorizationCheckerService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:7914
 appDevDebugProjectContainer->getSecurity_ContextService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:10262
 appDevDebugProjectContainer->getTwigService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:8641
 appDevDebugProjectContainer->getTemplatingService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:4560
 appDevDebugProjectContainer->getFmIo_Export_FeedWriterService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:4543
 appDevDebugProjectContainer->getFmIo_Export_FeedExporterService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/app/cache/dev/appDevDebugProjectContainer.php:4440
 appDevDebugProjectContainer->getFmIo_Command_Export_CreateService() at /home/vagrant/apps/myproject/app/bootstrap.php.cache:2085
 Symfony\Component\DependencyInjection\Container->get() at /home/vagrant/apps/myproject/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Console/Application.php:111
 Symfony\Bundle\FrameworkBundle\Console\Application->registerCommands() at /home/vagrant/apps/myproject/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Console/Application.php:73
 Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /home/vagrant/apps/myproject/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:126
 Symfony\Component\Console\Application->run() at /home/vagrant/apps/myproject/app/console:27

@kingcrunch
Copy link
Contributor

It may be related to doctrine/DoctrineBundle#351

@cleentfaar
Copy link

Thanks @kingcrunch, I think you're right. I suppose I will just have to limit the dbal package's version to 2.4 in my projects until this gets fixed.

@jmontoyaa
Copy link

I confirm @cleentfaar solution using

"doctrine/dbal": "2.4.4",

"fixes" the problem.

@MadmanMonty
Copy link

To clarify further for others hitting this, the standard symfony framework composer.json file fixes this in v2.6.4, anyone using the standard composer.json < v2.6.4 would need to compare and update it as covered above to fix.

        "doctrine/orm": "~2.2,>=2.2.3,<2.5",
        "doctrine/dbal": "<2.5",

@kingcrunch
Copy link
Contributor

@MadmanMonty Or just add the server_version to your configuration

@koemeet
Copy link
Author

koemeet commented Feb 6, 2015

This issue is still related to >2.5 so we still need a good fix for this, right?

@k0pernikus
Copy link
Contributor

I am getting this even after upgrading symfony2 from 2.6.11 to 2.7.5. Was there a regression?

@xabbuh
Copy link
Member

xabbuh commented Oct 6, 2015

@k0pernikus Please create a new issue if you think that the bug persists.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

10 participants