Got the same issue as well.
Apparently the problem has to do with the "UseDatabaseStoredFile" class
inherited by the "HerokuPostgresAdapter".
It is designed to store the filesystem ("databases" folder and files) in a
table instead, and was created for GAE but doesn't seem to work on Heroku.
That's about as far as I can go, being a novice and all...
Should I issue a ticket ?
On Thursday, March 13, 2014 4:11:54 PM UTC+1, Chris DeGroot wrote:
>
> That's unfortunate to hear that you haven't resolved it. I am having the
> exact same problem. Locally everything is fine, on Heroku, nothing.
>
> On Thursday, March 13, 2014 11:06:51 AM UTC-4, Ismael Serratos wrote:
>>
>> Nope, in fact I switched to ror :S because I needed to run on heroku ASAP.
>>
>> But I still getting the error on every web2py application I try to deploy
>> on heroku. If I use postgres locally everything works just fine.
>>
>> On 12/03/2014, at 18:31, Chris DeGroot <[email protected]> wrote:
>>
>> Did you solve this problem? I have the same issue and the links at then
>> end don't help.
>>
>> On Friday, December 27, 2013 11:45:24 PM UTC-5, 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 a topic in the
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/web2py/w2RJBqKIwRE/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> [email protected].
>> For more options, visit https://groups.google.com/d/optout.
>>
>>
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
