the --verbose flag is only used for a command like "alembic history" to provide
more detail. to see Alembic doing its work you want to enable logging. in the
ini file (see
https://alembic.sqlalchemy.org/en/latest/tutorial.html#editing-the-ini-file)
you want to set [logger_sqlalchemy] level to INFO or DEBUG. this will show you
every SQL statement emitted which should give you an idea of the one that is
hanging. DROP TABLE is a likely culprit as many databases won't allow this if
there are open transactions accessing that table.
On Thu, Feb 27, 2020, at 8:10 AM, doi zece wrote:
> n one of the python projects I'm working on we are using alembic to handle
> the DB migration scripts. Lately he had an incident when container ,in which
> alembic upgrade head is running, got stucked ( by some locks on the DB set
> the the runtime app) and eventually timed out without giving any details of
> what was going on. Finally we managed to get access to prod DB (which under
> normal circumstances we are not allow to access. this is something imposed by
> our cloudops team, for security reasons). So in order to eas our debugging
> process, i would like to enable verbose mode when calling "alembic upgrade
> head", this without having to add a tone of logs on top of the migration
> scripts.
> I found that --verbose flag is accepted for some alembic operations, but for
> some reasons "alembic upgrade head" doesn't allow it.
> **
> *usage: alembic [-h] [-c CONFIG] [-n NAME] [-x X] [--raiseerr]
> {branches,current,downgrade,edit,heads,history,init,list_templates,merge,revision,show,stamp,upgrade}
> ... alembic: error: unrecognized arguments: --verbose*
>
> This is the call generating the error above: *alembic upgrade head --verbose*
>
> Any idea on how I can enable verbosity on upgrade?
> Thanks
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy-alembic" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to sqlalchemy-alembic+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/sqlalchemy-alembic/64462a6a-2d12-491d-b613-e9b4ba9b7ffb%40googlegroups.com
>
> <https://groups.google.com/d/msgid/sqlalchemy-alembic/64462a6a-2d12-491d-b613-e9b4ba9b7ffb%40googlegroups.com?utm_medium=email&utm_source=footer>.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy-alembic" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy-alembic+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy-alembic/85f196b7-25cd-4418-9469-1ea32a3f2411%40www.fastmail.com.
