Try running SQLAlchemy version 0.7.9
Still have the same issue. Removed and installed SQLAlchemy 0.79
pip uninstall SQLAlchemy -y
pip install SQLAlchemy==0.7.9
Broker and Server info:
(px)root@relay-3:/home/baruwa# paster celeryd /etc/baruwa/production.ini
-f /var/log/baruwa/celeryd.log &
[3] 2562
(px)root@relay-3:/home/baruwa#
/home/baruwa/px/local/lib/python2.7/site-packages/celery/utils/__init__.py:72:
CPendingDeprecationWarning:
The 'BROKER_VHOST' setting is scheduled for deprecation in version
2.5 and removal in version v4.0. Use BROKER_URL instead
warnings.warn(w)
/home/baruwa/px/local/lib/python2.7/site-packages/celery/utils/__init__.py:72:
CPendingDeprecationWarning:
The 'BROKER_HOST' setting is scheduled for deprecation in version
2.5 and removal in version v4.0. Use BROKER_URL instead
warnings.warn(w)
/home/baruwa/px/local/lib/python2.7/site-packages/celery/utils/__init__.py:72:
CPendingDeprecationWarning:
The 'BROKER_USER' setting is scheduled for deprecation in version
2.5 and removal in version v4.0. Use BROKER_URL instead
warnings.warn(w)
/home/baruwa/px/local/lib/python2.7/site-packages/celery/utils/__init__.py:72:
CPendingDeprecationWarning:
The 'BROKER_PASSWORD' setting is scheduled for deprecation in
version 2.5 and removal in version v4.0. Use BROKER_URL instead
warnings.warn(w)
/home/baruwa/px/local/lib/python2.7/site-packages/celery/utils/__init__.py:72:
CPendingDeprecationWarning:
The 'BROKER_PORT' setting is scheduled for deprecation in version
2.5 and removal in version v4.0. Use BROKER_URL instead
warnings.warn(w)
/home/baruwa/px/local/lib/python2.7/site-packages/celery/apps/worker.py:171:
RuntimeWarning: Running celeryd with superuser privileges is discouraged!
'Running celeryd with superuser privileges is discouraged!'))
-------------- celery@relay-3 v3.0.24 (Chiastic Slide)
---- **** -----
--- * *** * -- Linux-3.2.0-29-generic-x86_64-with-Ubuntu-12.04-precise
-- * - **** ---
- ** ---------- [config]
- ** ---------- .> broker: amqp://[email protected]:5672/baruwa
- ** ---------- .> app: default:0x1375750
(baruwa.lib.mq.loader.PylonsLoader)
- ** ---------- .> concurrency: 100 (eventlet)
- *** --- * --- .> events: OFF (enable -E to monitor this worker)
-- ******* ----
--- ***** ----- [queues]
-------------- .> default: exchange:default(direct) binding:default
.> msbackend: exchange:ms(fanout) binding:mstasks
.> relay-3: exchange:host(direct) binding:relay-3
------------------------------------------------------------------------------------------------------------
(px)root@relay-3:/home/baruwa# paster serve --reload
/etc/baruwa/production.ini
Starting subprocess with file monitor
Starting server in PID 2573.
serving on 0.0.0.0:5000 view at http://127.0.0.1:5000
Error - <type 'exceptions.AttributeError'>: 'NoneType' object has no
attribute 'twophase'
Error - <type 'exceptions.AttributeError'>: 'NoneType' object has no
attribute 'twophase'
----------------------------------------
Exception happened during processing of request from ('10.10.1.15', 57076)
Traceback (most recent call last):
File
"/home/baruwa/px/local/lib/python2.7/site-packages/paste/httpserver.py",
line 1068, in process_request_in_thread
self.finish_request(request, client_address)
File "/usr/lib/python2.7/SocketServer.py", line 323, in finish_request
self.RequestHandlerClass(request, client_address, self)
File "/usr/lib/python2.7/SocketServer.py", line 638, in __init__
self.handle()
File
"/home/baruwa/px/local/lib/python2.7/site-packages/paste/httpserver.py",
line 442, in handle
BaseHTTPRequestHandler.handle(self)
File "/usr/lib/python2.7/BaseHTTPServer.py", line 340, in handle
self.handle_one_request()
File
"/home/baruwa/px/local/lib/python2.7/site-packages/paste/httpserver.py",
line 437, in handle_one_request
self.wsgi_execute()
File
"/home/baruwa/px/local/lib/python2.7/site-packages/paste/httpserver.py",
line 287, in wsgi_execute
self.wsgi_start_response)
File
"/home/baruwa/px/local/lib/python2.7/site-packages/paste/registry.py",
line 379, in __call__
app_iter = self.application(environ, start_response)
File
"/home/baruwa/px/local/lib/python2.7/site-packages/pylons/middleware.py", line
177, in __call__
self.app, new_environ, catch_exc_info=True)
File
"/home/baruwa/px/local/lib/python2.7/site-packages/pylons/util.py", line
50, in call_wsgi_application
app_iter = application(environ, start_response)
File
"/home/baruwa/px/local/lib/python2.7/site-packages/weberror/errormiddleware.py",
line 156, in __call__
return self.application(environ, start_response)
File
"/home/baruwa/px/local/lib/python2.7/site-packages/repoze/who/middleware.py",
line 85, in __call__
self.add_metadata(environ, classification, identity)
File
"/home/baruwa/px/local/lib/python2.7/site-packages/repoze/who/middleware.py",
line 179, in add_metadata
plugin.add_metadata(environ, identity)
File
"/home/baruwa/px/local/lib/python2.7/site-packages/repoze/who/plugins/sa.py",
line 210, in add_metadata
identity['user'] = self.get_user(identity['repoze.who.userid'])
File
"/home/baruwa/px/local/lib/python2.7/site-packages/repoze/who/plugins/sa.py",
line 64, in get_user
return query.one()
File
"/home/baruwa/px/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py",
line 2184, in one
ret = list(self)
File
"/home/baruwa/px/local/lib/python2.7/site-packages/baruwa/lib/caching_query.py",
line 77, in __iter__
return Query.__iter__(self)
File
"/home/baruwa/px/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py",
line 2227, in __iter__
return self._execute_and_instances(context)
File
"/home/baruwa/px/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py",
line 2240, in _execute_and_instances
close_with_result=True)
File
"/home/baruwa/px/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py",
line 2231, in _connection_from_session
**kw)
File
"/home/baruwa/px/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py",
line 777, in connection
close_with_result=close_with_result)
File
"/home/baruwa/px/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py",
line 781, in _connection_for_bind
return self.transaction._connection_for_bind(engine)
File
"/home/baruwa/px/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py",
line 308, in _connection_for_bind
if self.session.twophase and self._parent is None:
AttributeError: 'NoneType' object has no attribute 'twophase'
----------------------------------------
Error - <type 'exceptions.AttributeError'>: 'NoneType' object has no
attribute 'twophase'
Error - <type 'exceptions.AttributeError'>: 'NoneType' object has no
attribute 'twophase'
Error - <type 'exceptions.AttributeError'>: 'NoneType' object has no
attribute 'twophase'
Error - <type 'exceptions.AttributeError'>: 'NoneType' object has no
attribute 'twophase'
_______________________________________________
http://pledgie.com/campaigns/12056