常见异常处理

1.数据库连接超时

[ERROR 2018-05-29 01:47:05,010] module:exception process:460 thread:140388701890624 Internal Server Error: /report/filter
Traceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/Django-1.10.5-py2.7.egg/django/core/handlers/exception.py", line 39, in inner
    response = get_response(request)
  File "/usr/lib/python2.7/site-packages/Django-1.10.5-py2.7.egg/django/core/handlers/base.py", line 249, in _legacy_get_response
    response = self._get_response(request)
  File "/usr/lib/python2.7/site-packages/Django-1.10.5-py2.7.egg/django/core/handlers/base.py", line 187, in _get_response
    response = self.process_exception_by_middleware(e, request)
  File "/usr/lib/python2.7/site-packages/Django-1.10.5-py2.7.egg/django/core/handlers/base.py", line 185, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "./pspm_utils/db_decorators.py", line 148, in _wrapper
    conn.cursor().execute("SET CHARACTER SET utf8mb4")
  File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (2013, 'Lost connection to MySQL server during query')
[ERROR 2018-05-29 02:03:23,195] module:db_decorators process:460 thread:140388701890624 TypeError('not all arguments converted during string formatting',)

处理方法
1.查看数据库是否锁表，挂掉
2.是否有人重启服务

2.kindshard 遇到的问题

[ERROR 2018-05-28 11:14:06,025] module:db_decorators process:10657 thread:140196073379904 OperationalError(1105, 'plan have no criteria')
[ERROR 2018-05-28 11:14:06,039] module:db_decorators process:10657 thread:140196073379904 OperationalError(1105, 'plan have no criteria')
[ERROR 2018-05-28 11:14:06,051] module:exception process:10657 thread:140196073379904 Internal Server Error: /report/filter
Traceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/Django-1.10.5-py2.7.egg/django/core/handlers/exception.py", line 39, in inner
    response = get_response(request)
  File "/usr/lib/python2.7/site-packages/Django-1.10.5-py2.7.egg/django/core/handlers/base.py", line 249, in _legacy_get_response
    response = self._get_response(request)
  File "/usr/lib/python2.7/site-packages/Django-1.10.5-py2.7.egg/django/core/handlers/base.py", line 187, in _get_response
    response = self.process_exception_by_middleware(e, request)
  File "/usr/lib/python2.7/site-packages/Django-1.10.5-py2.7.egg/django/core/handlers/base.py", line 185, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "./pspm_utils/db_decorators.py", line 150, in _wrapper
    ret = fn(request, conn, *args, **kwargs)
  File "./app/report/filter_views.py", line 35, in report_table
    for item in data:
  File "./app/report/filter_views.py", line 394, in get_data
    for item in res:
  File "./pspm_utils/db_decorators.py", line 326, in db_yield
    cursor.execute(sql, params)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1105, 'plan have no criteria')

 

处理方法
1.查看数据库是否锁表，挂掉
2.是否能连接 kindshard
2.检查kindshard 是否需要重启