the pool might be trying to emit an info message, not really sure, there is some complex process by which Python logging either auto-configures itself, or doesnt. Since Alembic has the env.py call upon fileConfig(), that would be the logging config here. Add a logging config for it to your alembic.ini:
[logger_sqlalchemy_pool] level = INFO handlers = qualname = sqlalchemy.pool On Tue, Mar 3, 2020, at 11:12 PM, Ira Fuchs wrote: > Getting the message “ No handlers could be found for logger > "sqlalchemy.pool.impl.QueuePool" when I run this script to read from a MSSQL > dB > The code runs fine and delivers the data, but produces this error. > > from sqlalchemy import * > import pytds > import sqlalchemy_pytds > > engine = create_engine(params ) > from sqlalchemy import * > import pytds > import sqlalchemy_pytds > import getpass > p=getpass.getpass() > engine = create_engine('mssql+pytds://' + params) > > con = engine.connect() > > q = 'SELECT * from table' > rs= list(engine.execute(q)) > for a in rs: > print(a) > > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/fad17b62-5455-4de4-81ba-6d586e92a9ee%40googlegroups.com > > <https://groups.google.com/d/msgid/sqlalchemy/fad17b62-5455-4de4-81ba-6d586e92a9ee%40googlegroups.com?utm_medium=email&utm_source=footer>. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/5136895e-305b-415d-8e38-9da1c459d454%40www.fastmail.com.