I've been getting this on my Pylons site. sqlalchemy.exceptions.SQLError: (ReferenceError) weakly-referenced object no longer exists
It's trying to execute an ORM .select() call. The first time was after a "MySQL server has gone away" error, so I assumed some mapped instances had been orphaned. But now I'm still getting it even though I've set .pool_recycle to 1 hour and restarted the application several times. I've got SQLAlchemy 0.3.7 on the server, which is where the error is occuring. My workstation has the trunk version, but I probably don't keep the app running long enough to give this a chance to happen. The full traceback follows. File '/mnt/data/www/apps/inews2/inews/controllers/main.py', line 14 in index c.top = model.list_incidents(top_only=True) File '/mnt/data/www/apps/inews2/inews/models/__init__.py', line 60 in list_incidents return q.select(order_by=order_by, offset=offset, limit=limit) File '/mnt/data/www/apps/inews2/wenv-inews/lib/python2.4/SQLAlchemy-0.3.7-py2.4.egg/sqlalchemy/orm/query.py', line 319 in select return self.select_whereclause(whereclause=arg, **kwargs) File '/mnt/data/www/apps/inews2/wenv-inews/lib/python2.4/SQLAlchemy-0.3.7-py2.4.egg/sqlalchemy/orm/query.py', line 326 in select_whereclause return self._select_statement(statement, params=params) File '/mnt/data/www/apps/inews2/wenv-inews/lib/python2.4/SQLAlchemy-0.3.7-py2.4.egg/sqlalchemy/orm/query.py', line 927 in _select_statement return self.execute(statement, params=params, **kwargs) File '/mnt/data/www/apps/inews2/wenv-inews/lib/python2.4/SQLAlchemy-0.3.7-py2.4.egg/sqlalchemy/orm/query.py', line 831 in execute result = self.session.execute(self.mapper, clauseelement, params=params) File '/mnt/data/www/apps/inews2/wenv-inews/lib/python2.4/SQLAlchemy-0.3.7-py2.4.egg/sqlalchemy/orm/session.py', line 183 in execute return self.connection(mapper, close_with_result=True).execute(clause, params, **kwargs) File '/mnt/data/www/apps/inews2/wenv-inews/lib/python2.4/SQLAlchemy-0.3.7-py2.4.egg/sqlalchemy/engine/base.py', line 509 in execute return Connection.executors[c](self, object, *multiparams, **params) File '/mnt/data/www/apps/inews2/wenv-inews/lib/python2.4/SQLAlchemy-0.3.7-py2.4.egg/sqlalchemy/engine/base.py', line 549 in execute_clauseelement return self.execute_compiled(elem.compile(dialect=self.dialect, parameters=param), *multiparams, **params) File '/mnt/data/www/apps/inews2/wenv-inews/lib/python2.4/SQLAlchemy-0.3.7-py2.4.egg/sqlalchemy/engine/base.py', line 560 in execute_compiled self._execute_raw(context) File '/mnt/data/www/apps/inews2/wenv-inews/lib/python2.4/SQLAlchemy-0.3.7-py2.4.egg/sqlalchemy/engine/base.py', line 573 in _execute_raw self._execute(context) File '/mnt/data/www/apps/inews2/wenv-inews/lib/python2.4/SQLAlchemy-0.3.7-py2.4.egg/sqlalchemy/engine/base.py', line 591 in _execute raise exceptions.SQLError(context.statement, context.parameters, e) SQLError: (ReferenceError) weakly-referenced object no longer exists u'SELECT `IN_Incident`.is_type_other AS `IN_Incident_is_type_other`, `IN_Incident`.measure_shore AS `IN_Incident_measure_shore`, `IN_Incident`.ptl_search_min AS `IN_Incident_ptl_search_min`, `IN_Incident`.measure_burn AS `IN_Incident_measure_burn`, `IN_Incident`.actl_entered_max AS `IN_Incident_actl_entered_max`, `IN_Incident`.actl_search_min AS `IN_Incident_actl_search_min`, `IN_Incident`.is_type_drill AS `IN_Incident_is_type_drill`, `IN_Incident`.lead_ssc AS `IN_Incident_lead_ssc`, `IN_Incident`.measure_skim AS `IN_Incident_measure_skim`, `IN_Incident`.orr_id AS `IN_Incident_orr_id`, `IN_Incident`.jic AS `IN_Incident_jic`, `IN_Incident`.ptl_is_mass AS `IN_Incident_ptl_is_mass`, `IN_Incident`.actl_search_max AS `IN_Incident_actl_search_max`, `IN_Incident`.lon AS `IN_Incident_lon`, `IN_Incident`.notified_by AS `IN_Incident_notified_by`, `IN_Incident`.actl_entered_min AS `IN_Incident_actl_entered_min`, `IN_Incident`.location AS `IN_Incident_location`, `IN_Incident`.inews_date AS `IN_Incident_inews_date`, `IN_Incident`.ptl_search_max AS `IN_Incident_ptl_search_max`, `IN_Incident`.public_affairs_html AS `IN_Incident_public_affairs_html`, `IN_Incident`.cause AS `IN_Incident_cause`, `IN_Incident`.ptl_unit AS `IN_Incident_ptl_unit`, `IN_Incident`.noaa_divisions_involved AS `IN_Incident_noaa_divisions_involved`, `IN_Incident`.ptl_entered_max AS `IN_Incident_ptl_entered_max`, `IN_Incident`.description AS `IN_Incident_description`, `IN_Incident`.measure_bio AS `IN_Incident_measure_bio`, `IN_Incident`.is_type_oil AS `IN_Incident_is_type_oil`, `IN_Incident`.is_top AS `IN_Incident_is_top`, `IN_Incident`.actl_unit AS `IN_Incident_actl_unit`, `IN_Incident`.lat AS `IN_Incident_lat`, `IN_Incident`.is_type_ptl_bio AS `IN_Incident_is_type_ptl_bio`, `IN_Incident`.effort AS `IN_Incident_effort`, `IN_Incident`.measure_disperse AS `IN_Incident_measure_disperse`, `IN_Incident`.name AS `IN_Incident_name`, `IN_Incident`.commodity AS `IN_Incident_commodity`, `IN_Incident`.other_cause AS `IN_Incident_other_cause`, `IN_Incident`.is_type_ptl_oil AS `IN_Incident_is_type_ptl_oil`, `IN_Incident`.is_type_bio AS `IN_Incident_is_type_bio`, `IN_Incident`.actl_is_mass AS `IN_Incident_actl_is_mass`, `IN_Incident`.is_involve_dac AS `IN_Incident_is_involve_dac`, `IN_Incident`.ptl_entered_min AS `IN_Incident_ptl_entered_min` \nFROM `IN_Incident` \nWHERE `IN_Incident`.is_top ORDER BY inews_date DESC \n LIMIT 99 OFFSET 0' [] -- Mike Orr <[EMAIL PROTECTED]> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---