Is there any database log to help you? What are the queries being executed or failing?
On Friday, 27 December 2013 22:45:24 UTC-6, Ismael Serratos wrote: > > Hello everybody, today I tried to push my application to Heroku by using > the setup-web2py-heroku.sh script. It works fine, but when opening my app I > get a ticket with this content: > > web2py™Version 2.8.2-stable+timestamp.2013.11.28.13.54.07PythonPython > 2.7.4: /app/.heroku/python/bin/python (prefix: /app/.heroku/python) > Traceback > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > 8. > 9. > 10. > 11. > 12. > 13. > 14. > 15. > 16. > 17. > 18. > 19. > 20. > 21. > 22. > 23. > 24. > 25. > 26. > 27. > 28. > 29. > 30. > > Traceback (most recent call last): > File "/app/gluon/restricted.py", line 217, in restricted > exec ccode in environment > File "/app/applications/init/models/db.py" > <https://frozen-sea-3926.herokuapp.com/admin/default/edit/init/models/db.py>, > line 16, in <module> > db = get_db(name="HEROKU_POSTGRESQL_RED_URL", pool_size=10) > File "/app/gluon/contrib/heroku.py", line 26, in get_db > current.session.connect(current.request, current.response, db=db) > File "/app/gluon/globals.py", line 833, in connect > migrate=table_migrate, > File "/app/gluon/dal.py", line 8139, in define_table > table = self.lazy_define_table(tablename,*fields,**args) > File "/app/gluon/dal.py", line 8176, in lazy_define_table > polymodel=polymodel) > File "/app/gluon/dal.py", line 1056, in create_table > query), table) > File "/app/gluon/dal.py", line 815, in log > logfile = self.file_open(table._loggername, 'a') > File "/app/gluon/dal.py", line 4488, in file_open > return DatabaseStoredFile(self.db,filename,mode) > File "/app/gluon/dal.py", line 4416, in __init__ > self.db.executesql(sql) > File "/app/gluon/dal.py", line 8349, in executesql > adapter.execute(query) > File "/app/gluon/dal.py", line 1916, in execute > return self.log_execute(*a, **b) > File "/app/gluon/dal.py", line 1910, in log_execute > ret = self.cursor.execute(command, *a[1:], **b) > InternalError: current transaction is aborted, commands ignored until end of > transaction block > > I'm getting this ticket with my app and even with a blank copy of web2py and > the default apps. The admin interface works just fine. What can be the cause > of this issue? > > *Note: In the traceback I pasted here I did replace the get_db connection > name to the generated one, but the traceback is basically the same if I use > the default (none). > > Best regards, > > Ismael Serratos. > > > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.