can you try migrate=True, fake_migrate=True?
On Dec 5, 1:05 pm, "mr.freeze" <nat...@freezable.com> wrote: > I tried and the file modification times of the .table files do not > change. I deleted them (safely backed up) and they are not re-created. > > On Dec 5, 12:56 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > It is the same. try without delete them. > > > On Dec 5, 12:53 pm, "mr.freeze" <nat...@freezable.com> wrote: > > > > I reverted to the old DAL and did the steps you outlined. Same result. > > > Should I delete the .table files first? > > > > On Dec 5, 12:41 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > > for the troublesome table (auth_user) set migrate=False, > > > > fake_migrate=True reload, then migrate=True and remove fake_migrate. > > > > It should fix your broken .table. > > > > > Should work with old and with new dal. > > > > > On Dec 5, 11:47 am, "mr.freeze" <nat...@freezable.com> wrote: > > > > > > I seem to remember this failing before though. Something about > > > > > my .TABLE files being out of sync. What is the procedure to re-sync > > > > > them? > > > > > > On Dec 5, 10:45 am, "mr.freeze" <nat...@freezable.com> wrote: > > > > > > > I have a global variable migrate_db which is passed to all > > > > > > define_table functions. I switched it to false and get this: > > > > > > Traceback (most recent call last): > > > > > > File "C:\web2py\gluon\restricted.py", line 188, in restricted > > > > > > exec ccode in environment > > > > > > File "C:/web2py/applications/main/models/db.py", line 34, in > > > > > <module> > > > > > > readable=False, default=""),migrate=migrate_db) > > > > > > File "C:\web2py\gluon\sql.py", line 1406, in define_table > > > > > > obj = str(obj) > > > > > > File "C:\web2py\gluon\sql.py", line 1858, in _create > > > > > > 'boolean': 'CHAR(1)', > > > > > > File "C:\web2py\gluon\sql.py", line 1024, in <lambda> > > > > > > 'string': 'CHAR(%(length)s)', > > > > > > File "C:\Python26\lib\site-packages\MySQLdb\cursors.py", line 166, > > > > > > in execute > > > > > > self.errorhandler(self, exc, value) > > > > > > File "C:\Python26\lib\site-packages\MySQLdb\connections.py", line > > > > > > 35, in defaulterrorhandler > > > > > > raise errorclass, errorvalue > > > > > > OperationalError: (1050, "Table 'auth_user' already exists") > > > > > > > On Dec 5, 10:37 am, "mr.freeze" <nat...@freezable.com> wrote: > > > > > > > > Let me backup the web2pyslice.com database and I will try. > > > > > > > > On Dec 5, 10:36 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > > > > > > can you try migrate=True (add a dummy field and the remove it) > > > > > > > > with > > > > > > > > mysql? > > > > > > > > > On Dec 5, 10:20 am, "mr.freeze" <nat...@freezable.com> wrote: > > > > > > > > > > Working with mysql also. I tested with migrate=False. Nice > > > > > > > > > work! > > > > > > > > > > On Dec 5, 10:12 am, "mr.freeze" <nat...@freezable.com> wrote: > > > > > > > > > > > Okay, web2pyslices.com source runs against it with a sqlite > > > > > > > > > > database. > > > > > > > > > > I will test with mysql. > > > > > > > > > > > On Dec 4, 11:02 pm, mdipierro <mdipie...@cs.depaul.edu> > > > > > > > > > > wrote: > > > > > > > > > > > > One more test please. I do not have mysql installed here > > > > > > > > > > > so I did not > > > > > > > > > > > test pooling. This helps a lot. thanks. > > > > > > > > > > > > On Dec 4, 10:33 pm, "mr.freeze" <nat...@freezable.com> > > > > > > > > > > > wrote: > > > > > > > > > > > > > Looking closer, there is a syntax error on line 189: > > > > > > > > > > > > COnnectionPool > > > > > > > > > > > > After I fixed that, I get: > > > > > > > > > > > > Traceback (most recent call last): > > > > > > > > > > > > File "C:\web2py\gluon\main.py", line 488, in wsgibase > > > > > > > > > > > > > > > > > > > > > > > > BaseAdapter.close_all_instances(BaseAdapter.rollback) > > > > > > > > > > > > File "C:\web2py\gluon\sql.py", line 163, in > > > > > > > > > > > > close_all_instances > > > > > > > > > > > > pool = ConnectionPool._pools[instance._uri] > > > > > > > > > > > > AttributeError: 'SQLiteAdapter' object has no attribute > > > > > > > > > > > > '_uri' > > > > > > > > > > > > > On Dec 4, 10:26 pm, "mr.freeze" <nat...@freezable.com> > > > > > > > > > > > > wrote: > > > > > > > > > > > > > > I get this now: > > > > > > > > > > > > > Traceback (most recent call last): > > > > > > > > > > > > > File "C:\web2py\gluon\restricted.py", line 188, in > > > > > > > > > > > > > restricted > > > > > > > > > > > > > exec ccode in environment > > > > > > > > > > > > > File "C:/web2py/applications/main/models/db.py", > > > > > > > > > > > > > line 22, in > > > > > > > > > > > > > <module> > > > > > > > > > > > > > db = SQLDB(dal_connection,pool_size=10) > > > > > > > > > > > > > File "C:\web2py\gluon\sql.py", line 2405, in > > > > > > > > > > > > > __init__ > > > > > > > > > > > > > raise RuntimeError, "Failure to connect, tried 5 > > > > > > > > > > > > > times" > > > > > > > > > > > > > RuntimeError: Failure to connect, tried 5 times > > > > > > > > > > > > > > On Dec 4, 9:57 pm, mdipierro > > > > > > > > > > > > > <mdipie...@cs.depaul.edu> wrote: > > > > > > > > > > > > > > > Can you try delete everything in app/cache/ > > > > > > > > > > > > > > > The error seems in opening the cache file. > > > > > > > > > > > > > > > On Dec 4, 8:30 pm, "mr.freeze" > > > > > > > > > > > > > > <nat...@freezable.com> wrote: > > > > > > > > > > > > > > > > I was getting that error. After updating it goes > > > > > > > > > > > > > > > away but now I get > > > > > > > > > > > > > > > the below. I am running it against > > > > > > > > > > > > > > > web2pyslices.com source on a sqlite > > > > > > > > > > > > > > > db with Python 2.5: > > > > > > > > > > > > > > > > Traceback (most recent call last): > > > > > > > > > > > > > > > File > > > > > > > > > > > > > > > "C:\Users\nathan\workspace\web2py\gluon\restricted.py", > > > > > > > > > > > > > > > line > > > > > > > > > > > > > > > 188, in restricted > > > > > > > > > > > > > > > exec ccode in environment > > > > > > > > > > > > > > > File > > > > > > > > > > > > > > > "C:/Users/nathan/workspace/web2py/applications/main/models/ > > > > > > > > > > > > > > > menu.py", line 115, in <module> > > > > > > > > > > > > > > > response.tagcloud = > > > > > > > > > > > > > > > db().select(db.tags.ALL,orderby=~db.tags.count,limitby=(0,15),cache=(cache.disk, > > > > > > > > > > > > > > > 600)) > > > > > > > > > > > > > > > File > > > > > > > > > > > > > > > "C:\Users\nathan\workspace\web2py\gluon\sql.py", > > > > > > > > > > > > > > > line 3319, in > > > > > > > > > > > > > > > select > > > > > > > > > > > > > > > shutil.copyfileobj(file, dest_file) > > > > > > > > > > > > > > > File > > > > > > > > > > > > > > > "C:\Users\nathan\workspace\web2py\gluon\cache.py", > > > > > > > > > > > > > > > line 282, in > > > > > > > > > > > > > > > __call__ > > > > > > > > > > > > > > > storage = shelve.open(self.shelve_name) > > > > > > > > > > > > > > > File "C:\Python25\lib\shelve.py", line 225, in > > > > > > > > > > > > > > > open > > > > > > > > > > > > > > > return DbfilenameShelf(filename, flag, > > > > > > > > > > > > > > > protocol, writeback) > > > > > > > > > > > > > > > File "C:\Python25\lib\shelve.py", line 209, in > > > > > > > > > > > > > > > __init__ > > > > > > > > > > > > > > > Shelf.__init__(self, anydbm.open(filename, > > > > > > > > > > > > > > > flag), protocol, > > > > > > > > > > > > > > > writeback) > > > > > > > > > > > > > > > File "C:\Python25\lib\anydbm.py", line 83, in > > > > > > > > > > > > > > > open > > > > > > > > > > > > > > > return mod.open(file, flag, mode) > > > > > > > > > > > > > > > File "C:\Python25\lib\dbhash.py", line 16, in > > > > > > > > > > > > > > > open > > > > > > > > > > > > > > > return bsddb.hashopen(file, flag, mode) > > > > > > > > > > > > > > > File "C:\Python25\lib\bsddb\__init__.py", line > > > > > > > > > > > > > > > 310, in hashopen > > > > > > > > > > > > > > > d.open(file, db.DB_HASH, flags, mode) > > > > > > > > > > > > > > > DBPermissionsError: (1, 'Operation not permitted') > > > > > > > > > > > > > > > > On Dec 4, 4:00 pm, mdipierro > > > > > > > > > > > > > > > <mdipie...@cs.depaul.edu> wrote: > > > > > > > > > > > > > > > > > can you please try again? > > > > > > > > > > > > > > > > > Massimo > > > > > > > > > > > > > > > > > On Dec 4, 12:31 pm, ron_m > > > > > > > > > > > > > > > > <ron.mco...@gmail.com> wrote: > > > > > > > > > > > > > > > > > > Describe what I did > > > > > > > > > > > > > > > > > > Copied the trunk hg area to a work area > > > > > > > > > > > > > > > > > Renamed sql.py to sql-save.py > > > > > > > > > > > > > > > > > Copied dal.py to sql.py in order to replace > > > > > > > > > > > > > > > > > sql.py with dal.py > > > > > > > > > > > > > > > > > Copied application I am working on to > > > > > > > > > > > > > > > > > applications directory > > > > > > > > > > > > > > > > > Backed up the database > > > > > > > > > > > > > > > > > Ran the server as python web2py.py > > > > > > > > > > > > > > > > > > Got this stack trace > > > > > > > > > > > > > > > > > Traceback (most recent call last): > > > > > > > > > > > > > > > > > File > > > > > > > > > > > > > > > > > "/home/camcentral/Dev/web2py_hg/gluon/main.py", > > > > > > > > > > > > > > > > > line 446, in > > > > > > > > > > > > > > > > > wsgibase > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > BaseAdapter.close_all_instances(BaseAdapter.commit) > > > > > > > > > > > > > > > > > File > > > > > > > > > > > > > > > > > "/home/camcentral/Dev/web2py_hg/gluon/sql.py", > > > > > > > > > > > > > > > > > line 161, in > > > > > > > > > > > > > > > > > close_all_instances > > > > > > > > > > > > > > > > > if instance._pool_size: > > > > > > > > > > > > > > > > > AttributeError: 'SQLiteAdapter' object has no > > > > > > > > > > > > > > > > > attribute '_pool_size' > > > > > > > > > > > > > > > > > I don't use SQLite as a database but the > > > > > > > > > > > > > > > > > driver exists through default > > > > > > > > > > > > > > > > > install, the db line invoking SQLite is > > > > > > > > > > > > > > > > > commented out. > >
