I was away until 10pm, just did an hg update and recopied trunk to a
new work area plus copied dal.py to sql.py in gluon.
The welcome app gets this traceback on the index page after auto start
browser from TK interface.
web2py™ Version 1.89.5 (2010-11-21 16:03:13)
Python Python 2.6.5: /usr/bin/python
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 169, in
close_all_instances
instance._connection.close()
AttributeError: 'SQLiteAdapter' object has no attribute '_connection'
My own application gets
Traceback (most recent call last):
File "/home/camcentral/Dev/web2py_hg/gluon/restricted.py", line 188,
in restricted
exec ccode in environment
File "/home/camcentral/Dev/web2py_hg/applications/ccims/models/
A_db.py", line 19, in <module>
db = DAL('postgres://ccims:oss3...@localhost/cc_ims') # CamCentral
IMS configuration database
File "/home/camcentral/Dev/web2py_hg/gluon/sql.py", line 2402, in
__init__
raise RuntimeError, "Failure to connect, tried 5 times"
RuntimeError: Failure to connect, tried 5 times
Did I do something wrong in the test install copying dal.py over top
of sql.py to install the new dal?
The hg update was compared using meld to the work area from this
morning and I see quite a few changes to dal.py. Just re-ran meld
after I recopied the new trunk to the work area and I don't see the
differences so I am very sure I got the latest as of tonight.
On Dec 4, 9:02 pm, mdipierro <[email protected]> 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" <[email protected]> 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" <[email protected]> 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 <[email protected]> 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" <[email protected]> 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 <[email protected]> wrote:
>
> > > > > > can you please try again?
>
> > > > > > Massimo
>
> > > > > > On Dec 4, 12:31 pm, ron_m <[email protected]> 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.
>
>
