|
mackshot
|
 |
« on: August 22, 2010, 10:54:54 PM » |
|
Hi,
i have a problem with griffith. I try to connect to my (mysql) database after a year of not using it and now i got this error all the time:
2010-08-22T23:47:34: DEBUG: Griffith(sql:262): SELECT movies.movie_id, movies.number, movies.collection_id, movies.volume_id, movies.medium_id, movies.ratio_id, movies.vcodec_id, movies.poster_md5, movies.loaned, movies.seen, movies.rating, movies.color, movies.cond, movies.layers, movies.region, movies.media_num, movies.runtime, movies.year, movies.width, movies.height, movies.barcode, movies.o_title, movies.title, movies.director, movies.screenplay, movies.cameraman, movies.o_site, movies.site, movies.trailer, movies.country, movies.genre, movies.studio, movies.classification, movies.cast, movies.plot, movies.notes, movies.image
FROM movies ORDER BY movies.number ASC
Traceback (most recent call last):
File "griffith", line 272, in save_preferences
File "C:\Program Files (x86)\Griffith\lib\preferences.py", line 481, in save_preferences
self.filter_txt(None)
File "griffith", line 1129, in filter_txt
File "C:\Program Files (x86)\Griffith\lib\quick_filter.py", line 46, in change_filter
self.populate_treeview(statement)
File "griffith", line 976, in populate_treeview
File "C:\Program Files (x86)\Griffith\lib\main_treeview.py", line 489, in populate
filename = gutils.get_image_fname(movie.poster_md5, self.db, "s")
File "C:\Program Files (x86)\Griffith\lib\gutils.py", line 736, in get_image_fname
if not os.path.isfile(file_name) and not create_image_cache(md5sum, gsql):
File "C:\Program Files (x86)\Griffith\lib\gutils.py", line 666, in create_image_cache
poster = session.query(db.Poster).filter_by(md5sum=md5sum).first()
File "sqlalchemy\orm\query.pyo", line 1300, in first
File "sqlalchemy\orm\query.pyo", line 1221, in __getitem__
File "sqlalchemy\orm\query.pyo", line 1361, in __iter__
File "sqlalchemy\orm\query.pyo", line 1364, in _execute_and_instances
File "sqlalchemy\orm\session.pyo", line 754, in execute
File "sqlalchemy\orm\session.pyo", line 719, in __connection
File "sqlalchemy\orm\session.pyo", line 329, in _connection_for_bind
File "sqlalchemy\engine\base.pyo", line 1229, in contextual_connect
File "sqlalchemy\pool.pyo", line 142, in connect
File "sqlalchemy\pool.pyo", line 304, in __init__
File "sqlalchemy\pool.pyo", line 161, in get
File "sqlalchemy\pool.pyo", line 628, in do_get
sqlalchemy.exc.TimeoutError: QueuePool limit of size 5 overflow 10 reached, connection timed out, timeout 30
2010-08-22T23:48:15: DEBUG: Griffith(sql:262): SELECT movies.movie_id, movies.number, movies.collection_id, movies.volume_id, movies.medium_id, movies.ratio_id, movies.vcodec_id, movies.poster_md5, movies.loaned, movies.seen, movies.rating, movies.color, movies.cond, movies.layers, movies.region, movies.media_num, movies.runtime, movies.year, movies.width, movies.height, movies.barcode, movies.o_title, movies.title, movies.director, movies.screenplay, movies.cameraman, movies.o_site, movies.site, movies.trailer, movies.country, movies.genre, movies.studio, movies.classification, movies.cast, movies.plot, movies.notes, movies.image
FROM movies ORDER BY movies.number ASC
Do you have any idea what i can do? It is maybe an old version of the database which has to migrate? I am running mysql 5.1.41-3ubuntu12.6 and win7 on client side.
Thank you,
Markus
|
