gistfile1.txt

[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107] mod_wsgi (pid=29272): Exception occurred processing WSGI script '/home/gastosabertos/gastos_abertos/wsgi.py'.
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107] Traceback (most recent call last):
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/Flask-0.10.1-py2.7.egg/flask/app.py", line 1836, in __call__
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     return self.wsgi_app(environ, start_response)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/Flask-0.10.1-py2.7.egg/flask/app.py", line 1820, in wsgi_app
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     response = self.make_response(self.handle_exception(e))
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/Flask_RESTful-0.3.1-py2.7.egg/flask_restful/__init__.py", line 263, in error_router
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     return original_handler(e)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/Flask-0.10.1-py2.7.egg/flask/app.py", line 1403, in handle_exception
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     reraise(exc_type, exc_value, tb)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/Flask_RESTful-0.3.1-py2.7.egg/flask_restful/__init__.py", line 260, in error_router
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     return self.handle_error(e)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/Flask-0.10.1-py2.7.egg/flask/app.py", line 1817, in wsgi_app
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     response = self.full_dispatch_request()
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/Flask-0.10.1-py2.7.egg/flask/app.py", line 1477, in full_dispatch_request
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     rv = self.handle_user_exception(e)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/Flask_RESTful-0.3.1-py2.7.egg/flask_restful/__init__.py", line 263, in error_router
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     return original_handler(e)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/Flask-0.10.1-py2.7.egg/flask/app.py", line 1381, in handle_user_exception
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     reraise(exc_type, exc_value, tb)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/Flask_RESTful-0.3.1-py2.7.egg/flask_restful/__init__.py", line 260, in error_router
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     return self.handle_error(e)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/Flask-0.10.1-py2.7.egg/flask/app.py", line 1475, in full_dispatch_request
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     rv = self.dispatch_request()
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/Flask-0.10.1-py2.7.egg/flask/app.py", line 1461, in dispatch_request
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     return self.view_functions[rule.endpoint](**req.view_args)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/Flask_RESTful-0.3.1-py2.7.egg/flask_restful/utils/cors.py", line 33, in wrapped_function
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     resp = make_response(f(*args, **kwargs))
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/Flask_RESTful-0.3.1-py2.7.egg/flask_restful/__init__.py", line 431, in wrapper
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     resp = resource(*args, **kwargs)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/Flask-0.10.1-py2.7.egg/flask/views.py", line 84, in view
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     return self.dispatch_request(*args, **kwargs)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/Flask_RESTful-0.3.1-py2.7.egg/flask_restful/__init__.py", line 521, in dispatch_request
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     resp = meth(*args, **kwargs)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/Flask_RESTful-0.3.1-py2.7.egg/flask_restful/__init__.py", line 613, in wrapper
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     resp = f(*args, **kwargs)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/gastosabertos-0.0.1-py2.7.egg/gastosabertos/receita/views.py", line 83, in get
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     'X-Total-Count': revenue_data.count()
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/SQLAlchemy-0.9.8-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2640, in count
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     return self.from_self(col).scalar()
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/SQLAlchemy-0.9.8-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2426, in scalar
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     ret = self.one()
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/SQLAlchemy-0.9.8-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2395, in one
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     ret = list(self)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/SQLAlchemy-0.9.8-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2438, in __iter__
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     return self._execute_and_instances(context)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/SQLAlchemy-0.9.8-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2453, in _execute_and_instances
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     result = conn.execute(querycontext.statement, self._params)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/SQLAlchemy-0.9.8-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 729, in execute
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     return meth(self, multiparams, params)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/SQLAlchemy-0.9.8-py2.7-linux-x86_64.egg/sqlalchemy/sql/elements.py", line 322, in _execute_on_connection
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     return connection._execute_clauseelement(self, multiparams, params)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/SQLAlchemy-0.9.8-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 826, in _execute_clauseelement
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     compiled_sql, distilled_params
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/SQLAlchemy-0.9.8-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 958, in _execute_context
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     context)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/SQLAlchemy-0.9.8-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1159, in _handle_dbapi_exception
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     exc_info
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/SQLAlchemy-0.9.8-py2.7-linux-x86_64.egg/sqlalchemy/util/compat.py", line 199, in raise_from_cause
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     reraise(type(exception), exception, tb=exc_tb)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/SQLAlchemy-0.9.8-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 951, in _execute_context
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     context)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/SQLAlchemy-0.9.8-py2.7-linux-x86_64.egg/sqlalchemy/engine/default.py", line 436, in do_execute
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     cursor.execute(statement, parameters)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/pymysql/cursors.py", line 135, in execute
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     result = self._query(query)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/pymysql/cursors.py", line 274, in _query
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     conn.query(q)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/pymysql/connections.py", line 714, in query
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/pymysql/connections.py", line 865, in _read_query_result
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     result.read()
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/pymysql/connections.py", line 1062, in read
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     first_packet = self.connection._read_packet()
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/pymysql/connections.py", line 814, in _read_packet
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     packet_header = self._read_bytes(4)
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]   File "/home/gastosabertos/.virtualenvs/ga/lib/python2.7/site-packages/pymysql/connections.py", line 845, in _read_bytes
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107]     "Lost connection to MySQL server during query")
[Fri Mar 06 13:45:30 2015] [error] [client 177.81.26.107] OperationalError: (OperationalError) (2013, 'Lost connection to MySQL server during query') 'SELECT count(*) AS count_1 \\nFROM (SELECT revenue.id AS revenue_id, revenue.original_code AS revenue_original_code, revenue.code_id AS revenue_code_id, revenue.description AS revenue_description, revenue.date AS revenue_date, revenue.monthly_predicted AS revenue_monthly_predicted, revenue.monthly_outcome AS revenue_monthly_outcome, revenue.economical_category AS revenue_economical_category, revenue.economical_subcategory AS revenue_economical_subcategory, revenue.source AS revenue_source, revenue.rubric AS revenue_rubric, revenue.paragraph AS revenue_paragraph, revenue.subparagraph AS revenue_subparagraph \\nFROM revenue \\nWHERE revenue.economical_category = %s AND EXTRACT(year FROM revenue.date) = %s) AS anon_1' ('1', '2014')