Hi Srikanth, Are you using PostgreSQL? Does the transaction fail because of concurrent transactions reading or writing same data?
Usually there should be something like this written in the logs: sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (psycopg2.extensions.TransactionRollbackError) could not serialize access due to read/write dependencies among transactions -Mikko On 6 October 2017 at 08:02, Srikanth Bemineni <[email protected]> wrote: > Hi, > > Whenever a sqlalchemy commit fails, the transaction will be automatically > rolled back. When this does happen the pyramid_tm which commits the > transaction should print the message with the reason for rollback. > > We get one simple message from sqlalchemy. Most of the times we need to > guess the reason for the rollback. > > 2017-10-05 23:56:29,072 INFO > [sqlalchemy.engine.base.Engine:699][b'uWSGIWorker1Core0'] > ROLLBACK > > Is there way I can see the error , with the reason for roll back ? > > Srikanth B. > > -- > You received this message because you are subscribed to the Google Groups > "pylons-discuss" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/pylons-discuss/2fc1209f-f677-4fbe-a572-05517c9e5462% > 40googlegroups.com > <https://groups.google.com/d/msgid/pylons-discuss/2fc1209f-f677-4fbe-a572-05517c9e5462%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Mikko Ohtamaa http://opensourcehacker.com http://twitter.com/moo9000 -- You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/pylons-discuss/CAK8RCUs_BzGhe5%2B21nJORpqvUeBUHV6AbFwp%2B92%3DxAaJLdRtnA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
