Subject Re: [firebird-python] fdb: Transaction object is not active
Author Pavel Cisar
Hi,

Dne 25.9.2012 19:07, Maximiliano Robaina napsal(a):
>
> I built a custom django project (django 1.5) to do some custom test.
> Running that test I get a ProgrammingError: Transaction object is not
> active.
>
> The strange thing here is this error happen after of execution of
> several DML statements, but more precisely when it try to reset a
> sequence (generator):
>
> SELECT gen_id("DJANGO_SITE_SQ", coalesce(max("ID"), 0) -
> gen_id("DJANGO_SITE_SQ", 0) ) FROM "DJANGO_SITE";
>
> I don't know if this is the problem because that statement is
> executed several times before without any problem.
>
> Where can I to start to research this problem?

A stack trace might help. However, this error may come only from from
three sources: transaction.savepoint, transaction.transaction_info and
transaction.prepare (2PC).

best regards
Pavel Cisar
IBPhoenix