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.

Reply via email to