Hi Massimo, This application worked until I switched to the Postgresql database, so it is definitely a database problem. Originally I was using the default database, which I guess is file-based, so the data would be lost about once a day when Heroku cleaned out its files. That was fine for testing, but obviously I need a persistent database for production.
Right now, I don't care about the data in the database; in fact it should be empty since it has not worked since I changed the database. I have already tried deleting the database by removing the add-on from Heroku and adding a new one. According to the Heroku admin panel there are no tables existing in the new database. I also tried deleting the app from Heroku and deploying it all over again, which also did not work. Can you elaborate or point to some information on how web2py treats the metadata? There is no web2py_filesystem in my database. Can you think of a reason why it would not have been created? Chris On Thursday, March 13, 2014 10:14:32 AM UTC-4, Massimo Di Pierro wrote: > > Is this is a problem that worked before and then stopped working? Have you > changed anything on the database side? Do you have data that you need to > recovered. > > If at all an option, try delete the database and make a new one. > > Somehow there is a problem with the web2py_filesystem table where web2py > stores metadata on platforms that lack a persistent filesystem. This an be > recovered but it is complicated to explain without direct access to the > system. It really depends on how it got there and what is in there. > > Massimo > > > On Wednesday, 12 March 2014 17:53:08 UTC-5, Chris DeGroot wrote: >> >> Hello; >> >> I have tried everything I could think of to solve this problem, but I >> just can't find a solution. I am trying to deploy my application to >> Heroku, following the instructions in the web2py manual. The welcome app >> works fine, so I think generally I have deployed the app properly. The >> application works on my local machine. The error I am getting looks like >> this: >> >> Traceback (most recent call last): >> File "/app/web2py/gluon/restricted.py", line 217, in restricted >> exec ccode in environment >> File "/app/web2py/applications/CaeSuite/models/db.py" >> <https://warm-basin-8163.herokuapp.com/admin/default/edit/CaeSuite/models/db.py>, >> line 16, in <module> >> db = get_db(name=None, pool_size=10) >> File "/app/web2py/gluon/contrib/heroku.py", line 26, in get_db >> current.session.connect(current.request, current.response, db=db) >> File "/app/web2py/gluon/globals.py", line 869, in connect >> migrate=table_migrate, >> File "/app/web2py/gluon/dal.py", line 8223, in define_table >> table = self.lazy_define_table(tablename,*fields,**args) >> File "/app/web2py/gluon/dal.py", line 8260, in lazy_define_table >> polymodel=polymodel) >> File "/app/web2py/gluon/dal.py", line 1102, in create_table >> query), table) >> File "/app/web2py/gluon/dal.py", line 850, in log >> logfile = self.file_open(table._loggername, 'a') >> File "/app/web2py/gluon/dal.py", line 4578, in file_open >> return DatabaseStoredFile(self.db,filename,mode) >> File "/app/web2py/gluon/dal.py", line 4506, in __init__ >> self.db.executesql(sql) >> File "/app/web2py/gluon/dal.py", line 8433, in executesql >> adapter.execute(query) >> File "/app/web2py/gluon/dal.py", line 1969, in execute >> return self.log_execute(*a, **b) >> File "/app/web2py/gluon/dal.py", line 1963, in log_execute >> ret = self.cursor.execute(command, *a[1:], **b) >> InternalError: current transaction is aborted, commands ignored until end of >> transaction block >> >> Variablesself.cursor.execute<built-in method execute of >> psycopg2._psycopg.cursor >> object>self<gluon.contrib.heroku.HerokuPostgresAdapter >> object>self.cursor<cursor object at 0x287a338; closed: 0>b{}a('CREATE TABLE >> IF NOT EXISTS web2py_filesystem (path VARCHAR(255), content TEXT, PRIMARY >> KEY(path));',)retundefinedcommand'CREATE TABLE IF NOT EXISTS >> web2py_filesystem (path VARCHAR(255), content TEXT, PRIMARY KEY(path));' >> >> >> I would really appreciate any help!! Thanks, >> >> >> Chris >> >> -- 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/d/optout.
