sqlalchemy 经常报错：Can't reconnect until invalid transaction is rolled back

[E 190805 16:14:33 web:1524] Uncaught exception POST /dictinfo (127.0.0.1)

    HTTPServerRequest(protocol='http', host='127.0.0.1:8000', method='POST', uri='/dictinfo', version='HTTP/1.1', remote_ip='127.0.0.1', headers={'Host': '127.0.0.1:8000',

'User-Agent': 'python-requests/2.21.0', 'Accept-Encoding': 'gzip, deflate', 'Accept': '*/*', 'Connection': 'keep-alive', 'Content-Length': '59'})

    Traceback (most recent call last):

      File "C:\Python36-32\lib\site-packages\sqlalchemy\engine\base.py", line 1177, in _execute_context

        conn = self._revalidate_connection()

      File "C:\Python36-32\lib\site-packages\sqlalchemy\engine\base.py", line 463, in _revalidate_connection

        "Can't reconnect until invalid "

    sqlalchemy.exc.InvalidRequestError: Can't reconnect until invalid transaction is rolled back

 

    The above exception was the direct cause of the following exception:

 

    Traceback (most recent call last):

      File "C:\Python36-32\lib\site-packages\tornado\web.py", line 1443, in _execute

        result = method(*self.path_args, **self.path_kwargs)

      File "D:\Users\zhangzhendong\Desktop\tornadoproject\services\dictinfo_handler.py", line 121, in post

        if dictinfo_obj.by_dictinfo_value(is_all=True, rootid=0, dictinfo_value=post_data["dictinfo_value"]):

      File "D:\Users\zhangzhendong\Desktop\tornadoproject\orm\model\models.py", line 808, in by_dictinfo_value

        return dbSession.query(cls).filter_by(rootid=rootid, dictinfo_value=dictinfo_value).first()

      File "C:\Python36-32\lib\site-packages\sqlalchemy\orm\query.py", line 3215, in first

        ret = list(self[0:1])

      File "C:\Python36-32\lib\site-packages\sqlalchemy\orm\query.py", line 3007, in __getitem__

        return list(res)

      File "C:\Python36-32\lib\site-packages\sqlalchemy\orm\query.py", line 3317, in __iter__

        return self._execute_and_instances(context)

      File "C:\Python36-32\lib\site-packages\sqlalchemy\orm\query.py", line 3342, in _execute_and_instances

        result = conn.execute(querycontext.statement, self._params)

      File "C:\Python36-32\lib\site-packages\sqlalchemy\engine\base.py", line 988, in execute

        return meth(self, multiparams, params)

      File "C:\Python36-32\lib\site-packages\sqlalchemy\sql\elements.py", line 287, in _execute_on_connection

        return connection._execute_clauseelement(self, multiparams, params)

      File "C:\Python36-32\lib\site-packages\sqlalchemy\engine\base.py", line 1107, in _execute_clauseelement

        distilled_params,

      File "C:\Python36-32\lib\site-packages\sqlalchemy\engine\base.py", line 1182, in _execute_context

        e, util.text_type(statement), parameters, None, None

      File "C:\Python36-32\lib\site-packages\sqlalchemy\engine\base.py", line 1466, in _handle_dbapi_exception

        util.raise_from_cause(sqlalchemy_exception, exc_info)

      File "C:\Python36-32\lib\site-packages\sqlalchemy\util\compat.py", line 383, in raise_from_cause

        reraise(type(exception), exception, tb=exc_tb, cause=cause)

      File "C:\Python36-32\lib\site-packages\sqlalchemy\util\compat.py", line 128, in reraise

        raise value.with_traceback(tb)

      File "C:\Python36-32\lib\site-packages\sqlalchemy\engine\base.py", line 1177, in _execute_context

        conn = self._revalidate_connection()

      File "C:\Python36-32\lib\site-packages\sqlalchemy\engine\base.py", line 463, in _revalidate_connection

        "Can't reconnect until invalid "

    sqlalchemy.exc.StatementError: (sqlalchemy.exc.InvalidRequestError) Can't reconnect until invalid transaction is rolled back

    [SQL: SELECT ds_dictinfo.dictinfo_id AS ds_dictinfo_dictinfo_id, ds_dictinfo.rootid AS ds_dictinfo_rootid, ds_dictinfo.dictinfo_value AS ds_dictinfo_dictinfo_value, ds_

dictinfo.add_time AS ds_dictinfo_add_time, ds_dictinfo.update_time AS ds_dictinfo_update_time, ds_dictinfo.is_delete AS ds_dictinfo_is_delete

    FROM ds_dictinfo

    WHERE ds_dictinfo.rootid = %(rootid_1)s AND ds_dictinfo.dictinfo_value = %(dictinfo_value_1)s

     LIMIT %(param_1)s]

    [parameters: [{}]]