How to stop Symfony from logging Doctrine's sql queries?

Question

I have a weird issue, when I checked my app/log/dev.log I can see almost all of my queries in my dev.log being logged in real time:

[2015-01-27 06:57:22] doctrine.DEBUG: SELECT t0.username A ....
[2015-01-27 06:57:23] doctrine.DEBUG: SELECT t0.username A ...
[2015-01-27 06:57:23] doctrine.DEBUG: SELECT s0_.id ......

I have no idea why this is happening, since I am running the site on production mode also when I check monolog in my config.yml, this is what I see:

monolog:
    handlers:
        pictures:
            type: stream
            path: %kernel.logs_dir%/pictures_%kernel.environment%.log
            level: info
        instagram:
            type: stream
            path: %kernel.logs_dir%/instagram_%kernel.environment%.log
            level: info

here's what my config_dev.yml looks like:

imports:
    - { resource: config.yml }

framework:
    router:   { resource: "%kernel.root_dir%/config/routing_dev.yml" }
    profiler: { only_exceptions: false }

web_profiler:
    toolbar: true
    intercept_redirects: false

monolog:
    handlers:
        main:
            type:  stream
            path:  %kernel.logs_dir%/%kernel.environment%.log
            level: debug
        firephp:
            type:  firephp
            level: info

assetic:
    use_controller: false

hip_mandrill:
    disable_delivery: true

any idea how this could be happening?

Marcin Harasim · Accepted Answer · 2020-01-28 10:20:29Z

18

You should use prod env on your production server. In the prod env doctrine's logging is disabled by default.

But if you want to disable logging at all (in all environments) you need to set up a config.yml like that:

doctrine:
    dbal:
        connections:
            conn1:
                driver: ...
                ...
                logging: false
                profiling: false

Reference: https://symfony.com/doc/current/bundles/DoctrineBundle/configuration.html

edited Jan 28, 2020 at 10:20

Marcin Harasim

757 bronze badges

answered Jan 28, 2015 at 12:27

Michael Sivolobov

13.9k5 gold badges48 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

adit Over a year ago

I think I am using the prod env on my production server.. I don't want to disable all loggings, just in the prod. If not how can I check that this is the case

Michael Sivolobov Over a year ago

In prod env you will have logs at app/logs/prod.log

adit Over a year ago

I understand that, however no one seems to be accessing the dev environment, yet the logs are always going there.. I am afraid the prod environment is not really using the prod flag...so how do I check it

Michael Sivolobov Over a year ago

As I wrote before. You are actually using prod env. You can rename or delete your config_dev.yml and your application will not work. To activate prod env you need to point your web-server to use app.php instead of app_dev.php

adit Over a year ago

I also have another environment, a custom one called app_mobile, but how do I make sure that this is production and not development

|

Dahomz · Accepted Answer · 2015-10-14 09:11:59Z

6

I encountered a similar issue with dev.log being generated on prod environment. I figured out from the log entries that what was causing my issue was a scheduled cron job calling a custom symfony command. Modifying the entry to app/console with --env=prod for my crontab since stopped dev.log being generated. i.e.

app/console --env=prod custom:command

Must have missed that section of the book :)

answered Oct 14, 2015 at 9:11

Dahomz

3,8411 gold badge13 silver badges2 bronze badges

1 Comment

Robert Saylor Over a year ago

Thank you! I discovered my log was 1.7 GB when I found this solution.

Dany Des · Accepted Answer · 2022-12-14 13:26:24Z

3

As I struggled with the same problem and my .log file was increasing its size the straight solution was when running the consumer use the flag --no-debug

php bin/console messenger:consume async_email_handler --no-debug

edited Dec 14, 2022 at 13:26

answered Dec 13, 2022 at 21:50

Dany Des

1015 bronze badges

Collectives™ on Stack Overflow

How to stop Symfony from logging Doctrine's sql queries?

3 Answers 3

8 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

8 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related