search

jaykayone / liveBusDelayHeatMap

1 stars 0 forks source link

Invalid transaction blocks DB #10

Open jaykayone opened 8 years ago

jaykayone commented 8 years ago 
busmap-1 | 2016-05-13T05:18:52.936052354Z [Fri May 13 07:18:52.925464 2016] [core:error] [pid 19:tid 140713815627520] [client 71.6.146.186:45944] AH00126: Invalid URI in request myversion|3.6 Public
busmap-1 | 2016-05-13T06:18:18.869357982Z [Fri May 13 08:18:18.864805 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152] mod_wsgi (pid=18): Exception occurred processing WSGI script '/tmp/mod_wsgi-localhost:80:0/htdocs/'.
busmap-1 | 2016-05-13T06:18:18.870385143Z [Fri May 13 08:18:18.868472 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152] Traceback (most recent call last):
busmap-1 | 2016-05-13T06:18:18.870426808Z [Fri May 13 08:18:18.868697 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]   File "/usr/local/python/lib/python2.7/site-packages/mod_wsgi/server/__init__.py", line 1357, in handle_request
busmap-1 | 2016-05-13T06:18:18.874627102Z [Fri May 13 08:18:18.874440 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]     return self.application(environ, start_response)
busmap-1 | 2016-05-13T06:18:18.874848678Z [Fri May 13 08:18:18.874576 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]   File "/app/env/lib/python2.7/site-packages/pyramid/router.py", line 223, in __call__
busmap-1 | 2016-05-13T06:18:18.876069329Z [Fri May 13 08:18:18.875929 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]     response = self.invoke_subrequest(request, use_tweens=True)
busmap-1 | 2016-05-13T06:18:18.876230559Z [Fri May 13 08:18:18.876023 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]   File "/app/env/lib/python2.7/site-packages/pyramid/router.py", line 198, in invoke_subrequest
busmap-1 | 2016-05-13T06:18:18.876438722Z [Fri May 13 08:18:18.876330 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]     response = handle_request(request)
busmap-1 | 2016-05-13T06:18:18.876620106Z [Fri May 13 08:18:18.876409 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]   File "/app/env/lib/python2.7/site-packages/pyramid/tweens.py", line 20, in excview_tween
busmap-1 | 2016-05-13T06:18:18.878091161Z [Fri May 13 08:18:18.878005 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]     response = handler(request)
busmap-1 | 2016-05-13T06:18:18.878263745Z [Fri May 13 08:18:18.878072 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]   File "/app/env/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 101, in tm_tween
busmap-1 | 2016-05-13T06:18:18.878472833Z [Fri May 13 08:18:18.878392 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]     reraise(*exc_info)
busmap-1 | 2016-05-13T06:18:18.878599934Z [Fri May 13 08:18:18.878454 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]   File "/app/env/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 83, in tm_tween
busmap-1 | 2016-05-13T06:18:18.878676094Z [Fri May 13 08:18:18.878567 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]     response = handler(request)
busmap-1 | 2016-05-13T06:18:18.878796867Z [Fri May 13 08:18:18.878657 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]   File "/app/env/lib/python2.7/site-packages/pyramid/router.py", line 145, in handle_request
busmap-1 | 2016-05-13T06:18:18.878867877Z [Fri May 13 08:18:18.878765 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]     view_name
busmap-1 | 2016-05-13T06:18:18.879015283Z [Fri May 13 08:18:18.878849 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]   File "/app/env/lib/python2.7/site-packages/pyramid/view.py", line 541, in _call_view
busmap-1 | 2016-05-13T06:18:18.879883035Z [Fri May 13 08:18:18.879790 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]     response = view_callable(context, request)
busmap-1 | 2016-05-13T06:18:18.880026921Z [Fri May 13 08:18:18.879857 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]   File "/app/env/lib/python2.7/site-packages/pyramid/config/views.py", line 353, in rendered_view
busmap-1 | 2016-05-13T06:18:18.880237236Z [Fri May 13 08:18:18.880159 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]     result = view(context, request)
busmap-1 | 2016-05-13T06:18:18.880370775Z [Fri May 13 08:18:18.880218 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]   File "/app/env/lib/python2.7/site-packages/pyramid/config/views.py", line 507, in _requestonly_view
busmap-1 | 2016-05-13T06:18:18.880442709Z [Fri May 13 08:18:18.880337 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]     response = view(request)
busmap-1 | 2016-05-13T06:18:18.880618690Z [Fri May 13 08:18:18.880423 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]   File "/app/env/lib/python2.7/site-packages/liveBusDelayHeatMap-0.0-py2.7.egg/livebusdelayheatmap/views.py", line 29, in home
busmap-1 | 2016-05-13T06:18:18.880868163Z [Fri May 13 08:18:18.880772 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]     'lines': lines_for_timestamp(None),
busmap-1 | 2016-05-13T06:18:18.881034277Z [Fri May 13 08:18:18.880843 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]   File "/app/env/lib/python2.7/site-packages/liveBusDelayHeatMap-0.0-py2.7.egg/livebusdelayheatmap/views.py", line 101, in lines_for_timestamp
busmap-1 | 2016-05-13T06:18:18.881219265Z [Fri May 13 08:18:18.881125 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]     d = DBSession.query(BusDelay).order_by(BusDelay.time.desc()).first().time
busmap-1 | 2016-05-13T06:18:18.881358216Z [Fri May 13 08:18:18.881199 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2634, in first
busmap-1 | 2016-05-13T06:18:18.885240996Z [Fri May 13 08:18:18.885082 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]     ret = list(self[0:1])
busmap-1 | 2016-05-13T06:18:18.885418396Z [Fri May 13 08:18:18.885191 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2457, in __getitem__
busmap-1 | 2016-05-13T06:18:18.885786057Z [Fri May 13 08:18:18.885625 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]     return list(res)
busmap-1 | 2016-05-13T06:18:18.886053921Z [Fri May 13 08:18:18.885891 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2736, in __iter__
busmap-1 | 2016-05-13T06:18:18.886267900Z [Fri May 13 08:18:18.886158 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]     return self._execute_and_instances(context)
busmap-1 | 2016-05-13T06:18:18.886447194Z [Fri May 13 08:18:18.886238 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2751, in _execute_and_instances
busmap-1 | 2016-05-13T06:18:18.886658901Z [Fri May 13 08:18:18.886548 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]     result = conn.execute(querycontext.statement, self._params)
busmap-1 | 2016-05-13T06:18:18.886840198Z [Fri May 13 08:18:18.886629 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
busmap-1 | 2016-05-13T06:18:18.889614392Z [Fri May 13 08:18:18.889444 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]     return meth(self, multiparams, params)
busmap-1 | 2016-05-13T06:18:18.889805469Z [Fri May 13 08:18:18.889561 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
busmap-1 | 2016-05-13T06:18:18.893227984Z [Fri May 13 08:18:18.893045 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]     return connection._execute_clauseelement(self, multiparams, params)
busmap-1 | 2016-05-13T06:18:18.893447408Z [Fri May 13 08:18:18.893166 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
busmap-1 | 2016-05-13T06:18:18.893673861Z [Fri May 13 08:18:18.893559 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]     compiled_sql, distilled_params
busmap-1 | 2016-05-13T06:18:18.893857617Z [Fri May 13 08:18:18.893644 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1078, in _execute_context
busmap-1 | 2016-05-13T06:18:18.894097372Z [Fri May 13 08:18:18.893964 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]     None, None)
busmap-1 | 2016-05-13T06:18:18.894261491Z [Fri May 13 08:18:18.894049 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
busmap-1 | 2016-05-13T06:18:18.894516093Z [Fri May 13 08:18:18.894367 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]     exc_info
busmap-1 | 2016-05-13T06:18:18.894679185Z [Fri May 13 08:18:18.894468 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
busmap-1 | 2016-05-13T06:18:18.895797089Z [Fri May 13 08:18:18.895651 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]     reraise(type(exception), exception, tb=exc_tb, cause=cause)
busmap-1 | 2016-05-13T06:18:18.895975172Z [Fri May 13 08:18:18.895742 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1071, in _execute_context
busmap-1 | 2016-05-13T06:18:18.896217813Z [Fri May 13 08:18:18.896083 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]     conn = self._revalidate_connection()
busmap-1 | 2016-05-13T06:18:18.896384409Z [Fri May 13 08:18:18.896169 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 391, in _revalidate_connection
busmap-1 | 2016-05-13T06:18:18.896630977Z [Fri May 13 08:18:18.896489 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152]     "Can't reconnect until invalid "
busmap-1 | 2016-05-13T06:18:18.897250811Z [Fri May 13 08:18:18.897058 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:2152] StatementError: (sqlalchemy.exc.InvalidRequestError) Can't reconnect until invalid transaction is rolled back [SQL: u'SELECT busdelays.gid AS busdelays_gid, busdelays.id AS busdelays_id, busdelays.name AS busdelays_name, busdelays.line AS busdelays_line, busdelays.delay AS busdelays_delay, ST_AsEWKB(busdelays.geom) AS busdelays_geom, busdelays.time AS busdelays_time, busdelays.number AS busdelays_number, busdelays.departure AS busdelays_departure, busdelays.destination AS busdelays_destination \\nFROM busdelays ORDER BY busdelays.time DESC \\n LIMIT %(param_1)s'] [parameters: [immutabledict({})]]
busmap-1 | 2016-05-13T06:18:20.697910451Z [Fri May 13 08:18:20.697641 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104] mod_wsgi (pid=18): Exception occurred processing WSGI script '/tmp/mod_wsgi-localhost:80:0/htdocs/'.
busmap-1 | 2016-05-13T06:18:20.698289891Z [Fri May 13 08:18:20.698074 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104] Traceback (most recent call last):
busmap-1 | 2016-05-13T06:18:20.698609734Z [Fri May 13 08:18:20.698419 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]   File "/usr/local/python/lib/python2.7/site-packages/mod_wsgi/server/__init__.py", line 1357, in handle_request
busmap-1 | 2016-05-13T06:18:20.699002211Z [Fri May 13 08:18:20.698825 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]     return self.application(environ, start_response)
busmap-1 | 2016-05-13T06:18:20.699187168Z [Fri May 13 08:18:20.698940 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/pyramid/router.py", line 223, in __call__
busmap-1 | 2016-05-13T06:18:20.699519299Z [Fri May 13 08:18:20.699348 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]     response = self.invoke_subrequest(request, use_tweens=True)
busmap-1 | 2016-05-13T06:18:20.699706962Z [Fri May 13 08:18:20.699457 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/pyramid/router.py", line 198, in invoke_subrequest
busmap-1 | 2016-05-13T06:18:20.700006555Z [Fri May 13 08:18:20.699843 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]     response = handle_request(request)
busmap-1 | 2016-05-13T06:18:20.700238152Z [Fri May 13 08:18:20.699948 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/pyramid/tweens.py", line 20, in excview_tween
busmap-1 | 2016-05-13T06:18:20.700546415Z [Fri May 13 08:18:20.700381 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]     response = handler(request)
busmap-1 | 2016-05-13T06:18:20.700762352Z [Fri May 13 08:18:20.700488 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 101, in tm_tween
busmap-1 | 2016-05-13T06:18:20.701103975Z [Fri May 13 08:18:20.700934 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]     reraise(*exc_info)
busmap-1 | 2016-05-13T06:18:20.701291290Z [Fri May 13 08:18:20.701045 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 83, in tm_tween
busmap-1 | 2016-05-13T06:18:20.701691380Z [Fri May 13 08:18:20.701532 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]     response = handler(request)
busmap-1 | 2016-05-13T06:18:20.701878330Z [Fri May 13 08:18:20.701635 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/pyramid/router.py", line 145, in handle_request
busmap-1 | 2016-05-13T06:18:20.702177426Z [Fri May 13 08:18:20.702012 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]     view_name
busmap-1 | 2016-05-13T06:18:20.702434363Z [Fri May 13 08:18:20.702116 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/pyramid/view.py", line 541, in _call_view
busmap-1 | 2016-05-13T06:18:20.702912250Z [Fri May 13 08:18:20.702665 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]     response = view_callable(context, request)
busmap-1 | 2016-05-13T06:18:20.703278124Z [Fri May 13 08:18:20.703036 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/pyramid/config/views.py", line 353, in rendered_view
busmap-1 | 2016-05-13T06:18:20.703775461Z [Fri May 13 08:18:20.703522 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]     result = view(context, request)
busmap-1 | 2016-05-13T06:18:20.704149817Z [Fri May 13 08:18:20.703912 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/pyramid/config/views.py", line 507, in _requestonly_view
busmap-1 | 2016-05-13T06:18:20.704646191Z [Fri May 13 08:18:20.704376 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]     response = view(request)
busmap-1 | 2016-05-13T06:18:20.705022084Z [Fri May 13 08:18:20.704757 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/liveBusDelayHeatMap-0.0-py2.7.egg/livebusdelayheatmap/views.py", line 29, in home
busmap-1 | 2016-05-13T06:18:20.705735192Z [Fri May 13 08:18:20.705484 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]     'lines': lines_for_timestamp(None),
busmap-1 | 2016-05-13T06:18:20.706137795Z [Fri May 13 08:18:20.705878 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/liveBusDelayHeatMap-0.0-py2.7.egg/livebusdelayheatmap/views.py", line 101, in lines_for_timestamp
busmap-1 | 2016-05-13T06:18:20.706674255Z [Fri May 13 08:18:20.706421 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]     d = DBSession.query(BusDelay).order_by(BusDelay.time.desc()).first().time
busmap-1 | 2016-05-13T06:18:20.707094605Z [Fri May 13 08:18:20.706836 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2634, in first
busmap-1 | 2016-05-13T06:18:20.707585579Z [Fri May 13 08:18:20.707335 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]     ret = list(self[0:1])
busmap-1 | 2016-05-13T06:18:20.708097046Z [Fri May 13 08:18:20.707736 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2457, in __getitem__
busmap-1 | 2016-05-13T06:18:20.708347559Z [Fri May 13 08:18:20.708038 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]     return list(res)
busmap-1 | 2016-05-13T06:18:20.711119034Z [Fri May 13 08:18:20.708483 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2736, in __iter__
busmap-1 | 2016-05-13T06:18:20.711187624Z [Fri May 13 08:18:20.708726 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]     return self._execute_and_instances(context)
busmap-1 | 2016-05-13T06:18:20.711225615Z [Fri May 13 08:18:20.708784 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2751, in _execute_and_instances
busmap-1 | 2016-05-13T06:18:20.711261045Z [Fri May 13 08:18:20.708960 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]     result = conn.execute(querycontext.statement, self._params)
busmap-1 | 2016-05-13T06:18:20.711290611Z [Fri May 13 08:18:20.709014 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
busmap-1 | 2016-05-13T06:18:20.711320801Z [Fri May 13 08:18:20.709164 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]     return meth(self, multiparams, params)
busmap-1 | 2016-05-13T06:18:20.711352371Z [Fri May 13 08:18:20.709216 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
busmap-1 | 2016-05-13T06:18:20.711391155Z [Fri May 13 08:18:20.709366 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]     return connection._execute_clauseelement(self, multiparams, params)
busmap-1 | 2016-05-13T06:18:20.711424801Z [Fri May 13 08:18:20.709417 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
busmap-1 | 2016-05-13T06:18:20.711461838Z [Fri May 13 08:18:20.709561 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]     compiled_sql, distilled_params
busmap-1 | 2016-05-13T06:18:20.711496988Z [Fri May 13 08:18:20.709614 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1078, in _execute_context
busmap-1 | 2016-05-13T06:18:20.711574675Z [Fri May 13 08:18:20.709760 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]     None, None)
busmap-1 | 2016-05-13T06:18:20.711616058Z [Fri May 13 08:18:20.709813 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
busmap-1 | 2016-05-13T06:18:20.711657881Z [Fri May 13 08:18:20.709952 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]     exc_info
busmap-1 | 2016-05-13T06:18:20.711691661Z [Fri May 13 08:18:20.710000 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
busmap-1 | 2016-05-13T06:18:20.711724561Z [Fri May 13 08:18:20.710144 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]     reraise(type(exception), exception, tb=exc_tb, cause=cause)
busmap-1 | 2016-05-13T06:18:20.711759785Z [Fri May 13 08:18:20.710193 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1071, in _execute_context
busmap-1 | 2016-05-13T06:18:20.711797951Z [Fri May 13 08:18:20.710337 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]     conn = self._revalidate_connection()
busmap-1 | 2016-05-13T06:18:20.711834855Z [Fri May 13 08:18:20.710387 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 391, in _revalidate_connection
busmap-1 | 2016-05-13T06:18:20.711869181Z [Fri May 13 08:18:20.710522 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104]     "Can't reconnect until invalid "
busmap-1 | 2016-05-13T06:18:20.711906131Z [Fri May 13 08:18:20.710806 2016] [wsgi:error] [pid 18:tid 140713629685504] [remote 87.240.235.167:104] StatementError: (sqlalchemy.exc.InvalidRequestError) Can't reconnect until invalid transaction is rolled back [SQL: u'SELECT busdelays.gid AS busdelays_gid, busdelays.id AS busdelays_id, busdelays.name AS busdelays_name, busdelays.line AS busdelays_line, busdelays.delay AS busdelays_delay, ST_AsEWKB(busdelays.geom) AS busdelays_geom, busdelays.time AS busdelays_time, busdelays.number AS busdelays_number, busdelays.departure AS busdelays_departure, busdelays.destination AS busdelays_destination \\nFROM busdelays ORDER BY busdelays.time DESC \\n LIMIT %(param_1)s'] [parameters: [immutabledict({})]]
busmap-1 | 2016-05-13T06:18:25.940797106Z [Fri May 13 08:18:25.940262 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104] mod_wsgi (pid=18): Exception occurred processing WSGI script '/tmp/mod_wsgi-localhost:80:0/htdocs/'.
busmap-1 | 2016-05-13T06:18:25.941265367Z [Fri May 13 08:18:25.941074 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104] Traceback (most recent call last):
busmap-1 | 2016-05-13T06:18:25.941506503Z [Fri May 13 08:18:25.941307 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]   File "/usr/local/python/lib/python2.7/site-packages/mod_wsgi/server/__init__.py", line 1357, in handle_request
busmap-1 | 2016-05-13T06:18:25.942009754Z [Fri May 13 08:18:25.941869 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]     return self.application(environ, start_response)
busmap-1 | 2016-05-13T06:18:25.942215150Z [Fri May 13 08:18:25.941980 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/pyramid/router.py", line 223, in __call__
busmap-1 | 2016-05-13T06:18:25.942596498Z [Fri May 13 08:18:25.942456 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]     response = self.invoke_subrequest(request, use_tweens=True)
busmap-1 | 2016-05-13T06:18:25.942750516Z [Fri May 13 08:18:25.942550 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/pyramid/router.py", line 198, in invoke_subrequest
busmap-1 | 2016-05-13T06:18:25.942943589Z [Fri May 13 08:18:25.942840 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]     response = handle_request(request)
busmap-1 | 2016-05-13T06:18:25.943120978Z [Fri May 13 08:18:25.942915 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/pyramid/tweens.py", line 20, in excview_tween
busmap-1 | 2016-05-13T06:18:25.943334632Z [Fri May 13 08:18:25.943227 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]     response = handler(request)
busmap-1 | 2016-05-13T06:18:25.943511648Z [Fri May 13 08:18:25.943306 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 101, in tm_tween
busmap-1 | 2016-05-13T06:18:25.943761447Z [Fri May 13 08:18:25.943634 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]     reraise(*exc_info)
busmap-1 | 2016-05-13T06:18:25.943880328Z [Fri May 13 08:18:25.943711 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 83, in tm_tween
busmap-1 | 2016-05-13T06:18:25.944196020Z [Fri May 13 08:18:25.944093 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]     response = handler(request)
busmap-1 | 2016-05-13T06:18:25.944378057Z [Fri May 13 08:18:25.944169 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/pyramid/router.py", line 145, in handle_request
busmap-1 | 2016-05-13T06:18:25.944554442Z [Fri May 13 08:18:25.944423 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]     view_name
busmap-1 | 2016-05-13T06:18:25.944818107Z [Fri May 13 08:18:25.944514 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/pyramid/view.py", line 541, in _call_view
busmap-1 | 2016-05-13T06:18:25.945129248Z [Fri May 13 08:18:25.944997 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]     response = view_callable(context, request)
busmap-1 | 2016-05-13T06:18:25.945297166Z [Fri May 13 08:18:25.945084 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/pyramid/config/views.py", line 353, in rendered_view
busmap-1 | 2016-05-13T06:18:25.945554725Z [Fri May 13 08:18:25.945423 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]     result = view(context, request)
busmap-1 | 2016-05-13T06:18:25.945718006Z [Fri May 13 08:18:25.945509 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/pyramid/config/views.py", line 507, in _requestonly_view
busmap-1 | 2016-05-13T06:18:25.945953574Z [Fri May 13 08:18:25.945823 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]     response = view(request)
busmap-1 | 2016-05-13T06:18:25.946154500Z [Fri May 13 08:18:25.945907 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/liveBusDelayHeatMap-0.0-py2.7.egg/livebusdelayheatmap/views.py", line 28, in home
busmap-1 | 2016-05-13T06:18:25.946456286Z [Fri May 13 08:18:25.946319 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]     return {'timestamps': timestamps(None),
busmap-1 | 2016-05-13T06:18:25.946612729Z [Fri May 13 08:18:25.946409 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/liveBusDelayHeatMap-0.0-py2.7.egg/livebusdelayheatmap/views.py", line 86, in timestamps
busmap-1 | 2016-05-13T06:18:25.946853731Z [Fri May 13 08:18:25.946725 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]     ts = DBSession.query(BusDelay.time).group_by(BusDelay.time).all()
busmap-1 | 2016-05-13T06:18:25.947019392Z [Fri May 13 08:18:25.946808 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2588, in all
busmap-1 | 2016-05-13T06:18:25.947264672Z [Fri May 13 08:18:25.947157 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]     return list(self)
busmap-1 | 2016-05-13T06:18:25.947436632Z [Fri May 13 08:18:25.947236 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2736, in __iter__
busmap-1 | 2016-05-13T06:18:25.947637386Z [Fri May 13 08:18:25.947536 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]     return self._execute_and_instances(context)
busmap-1 | 2016-05-13T06:18:25.947808418Z [Fri May 13 08:18:25.947609 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2751, in _execute_and_instances
busmap-1 | 2016-05-13T06:18:25.947996505Z [Fri May 13 08:18:25.947881 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]     result = conn.execute(querycontext.statement, self._params)
busmap-1 | 2016-05-13T06:18:25.948176207Z [Fri May 13 08:18:25.947969 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
busmap-1 | 2016-05-13T06:18:25.948408948Z [Fri May 13 08:18:25.948302 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]     return meth(self, multiparams, params)
busmap-1 | 2016-05-13T06:18:25.948604302Z [Fri May 13 08:18:25.948381 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
busmap-1 | 2016-05-13T06:18:25.948883239Z [Fri May 13 08:18:25.948747 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]     return connection._execute_clauseelement(self, multiparams, params)
busmap-1 | 2016-05-13T06:18:25.949039470Z [Fri May 13 08:18:25.948826 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
busmap-1 | 2016-05-13T06:18:25.949245553Z [Fri May 13 08:18:25.949142 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]     compiled_sql, distilled_params
busmap-1 | 2016-05-13T06:18:25.949431417Z [Fri May 13 08:18:25.949218 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1078, in _execute_context
busmap-1 | 2016-05-13T06:18:25.949618555Z [Fri May 13 08:18:25.949505 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]     None, None)
busmap-1 | 2016-05-13T06:18:25.949797650Z [Fri May 13 08:18:25.949592 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
busmap-1 | 2016-05-13T06:18:25.950049031Z [Fri May 13 08:18:25.949891 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]     exc_info
busmap-1 | 2016-05-13T06:18:25.950256820Z [Fri May 13 08:18:25.949995 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
busmap-1 | 2016-05-13T06:18:25.950481859Z [Fri May 13 08:18:25.950375 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]     reraise(type(exception), exception, tb=exc_tb, cause=cause)
busmap-1 | 2016-05-13T06:18:25.950654360Z [Fri May 13 08:18:25.950453 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1071, in _execute_context
busmap-1 | 2016-05-13T06:18:25.950842348Z [Fri May 13 08:18:25.950739 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]     conn = self._revalidate_connection()
busmap-1 | 2016-05-13T06:18:25.951014440Z [Fri May 13 08:18:25.950813 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]   File "/app/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 391, in _revalidate_connection
busmap-1 | 2016-05-13T06:18:25.951251409Z [Fri May 13 08:18:25.951099 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104]     "Can't reconnect until invalid "
busmap-1 | 2016-05-13T06:18:25.951652607Z [Fri May 13 08:18:25.951458 2016] [wsgi:error] [pid 18:tid 140713604507392] [remote 87.240.235.167:104] StatementError: (sqlalchemy.exc.InvalidRequestError) Can't reconnect until invalid transaction is rolled back [SQL: u'SELECT busdelays.time AS busdelays_time \\nFROM busdelays GROUP BY busdelays.time'] [parameters: [immutabledict({})]]
jaykayone commented 8 years ago

maybe solved by closing session at the end