Step 15, Message of "No handlers could be found for logger "sqlalchemy.engine.base.Engine"

[Midori-ch]

Hi,
Follow the Readme.rst to set paddles server.
After step 15 when I execute command "$ pecan serve config.py" , server will display a message "No handlers could be found for logger "sqlalchemy.engine.base.Engine".
Is this because I set something wrong？

[alfredodeza]

that is odd, but it may be because your configuration file has not defined a logging handler for it. Mind pasting it so we can take a look?

[Midori-ch]

Hi,
Thank you so much. Here is the content of config.py and alembic.ini.
config.py.txt
alembic.txt

[alfredodeza]

is this just a warning or is there a traceback as well?

[zmc]

I've seen this as well, but haven't ever really looked into it as it doesn't seem to cause problems. I'm not sure if I'm missing out on any useful log messages from sqlalchemy...

[runsisi]

@Midori-ch you can use the already defined log handler console, e.g.

53         'sqlalchemy': {'level': 'WARN', 'handlers': ['console']},

or define a custom log handler, here i define a file handler named xxx, e.g.

 50     'loggers': {
 51         'root': {'level': 'INFO', 'handlers': ['console']},
 52         'paddles': {'level': 'DEBUG', 'handlers': ['console']},
 53         'sqlalchemy': {'level': 'WARN', 'handlers': ['xxx']},
 54         'py.warnings': {'handlers': ['console']},
 55         '__force_dict__': True
 56     },
 57     'handlers': {
 58         'console': {
 59             'level': 'DEBUG',
 60             'class': 'logging.StreamHandler',
 61             'formatter': 'simple'
 62         },  
 63         'xxx': {
 64             'level': 'DEBUG',
 65             'class': 'logging.FileHandler',
 66             'formatter': 'simple',
 67             'filename': 'pecan.log'                                                                                                                                                     
 68         },
 69     },