Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Invalid transaction blocks DB #10

Open
jaykayone opened this issue May 13, 2016 · 1 comment
Open

Invalid transaction blocks DB #10

jaykayone opened this issue May 13, 2016 · 1 comment

Comments

@jaykayone
Copy link
Owner 

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
Copy link
Owner Author

maybe solved by closing session at the end

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@jaykayone