断掉服务器与oracle的连接,不在同一服务器上的数据库连接起来久了会断开,大佬们有遇到过吗?...

服务器 A 是 tornado,去连服务器 B 上的 PostgreSQL 数据库,刚开始没啥问题。

可是时间久了服务器 A 和服务器 B 的数据库连接就断了。

大佬们有遇到过这种情况吗?

附个错误提示:

Traceback (most recent call last):

File "/home/xxx/.local/lib/python3.5/site-packages/peewee.py", line 3756, in execute_sql

cursor = self.get_cursor()

File "/home/xxx/.local/lib/python3.5/site-packages/peewee.py", line 3704, in get_cursor

return self.get_conn().cursor()

psycopg2.InterfaceError: connection already closed

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/home/xxx/.local/lib/python3.5/site-packages/tornado/web.py", line 1488, in _execute

result = self.prepare()

File "/home/xxx/cc_backend/view/__init__.py", line 217, in prepare

if not self.current_user():

File "/home/xxx/cc_backend/view/__init__.py", line 192, in current_user

return User.get_by_key(key)

File "/home/xxx/cc_backend/model/user.py", line 102, in get_by_key

return cls.get(cls.key == key)

File "/home/xxx/.local/lib/python3.5/site-packages/peewee.py", line 4916, in get

return sq.get()

File "/home/xxx/.local/lib/python3.5/site-packages/peewee.py", line 3171, in get

return next(clone.execute())

File "/home/xxx/.local/lib/python3.5/site-packages/peewee.py", line 3223, in execute

self._qr = ResultWrapper(model_class, self._execute(), query_meta)

File "/home/xxx/.local/lib/python3.5/site-packages/peewee.py", line 2902, in _execute

return self.database.execute_sql(sql, params, self.require_commit)

File "/home/xxx/.local/lib/python3.5/site-packages/peewee.py", line 3765, in execute_sql

self.commit()

File "/home/xxx/.local/lib/python3.5/site-packages/peewee.py", line 3588, in __exit__

reraise(new_type, new_type(*exc_args), traceback)

File "/home/xxx/.local/lib/python3.5/site-packages/peewee.py", line 135, in reraise

raise value.with_traceback(tb)

File "/home/xxx/.local/lib/python3.5/site-packages/peewee.py", line 3756, in execute_sql

cursor = self.get_cursor()

File "/home/xxx/.local/lib/python3.5/site-packages/peewee.py", line 3704, in get_cursor

return self.get_conn().cursor()

peewee.InterfaceError: connection already closed

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值