Hi, I am using Mysql. This is one single insert into a table and its failing for some reason. I am not able to predict the reason for the failure. sqlalchemy just prints ROLLBACK.
INSERT INTO group_message_22f9b36c (group_id, group_topic_id, score, user_id, uname, msg, created_at, updated_at) VALUES (%s, %s, %s, %s, %s, %s, %s, %s) 2017-10-06 00:44:40,883 INFO [sqlalchemy.engine.base.Engine:1143][b'uWSGIWorker2Core0'] (11, 1, 0, 6, 'sammy', 'sdfsdf', datetime.datetime(2017, 10, 6, 5, 44, 40, 880935), datetime.datetime(2017, 10, 6, 5, 44, 40, 880935)) 2017-10-06 00:44:40,897 INFO [sqlalchemy.engine.base.Engine:699][b'uWSGIWorker2Core0'] ROLLBACK On Friday, October 6, 2017 at 3:07:47 AM UTC-5, Mikko Ohtamaa wrote: > > 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] > <javascript:>> 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] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> 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/6d62ae3a-ee7f-42ec-b88a-2610d47d9164%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
