sybase load 数据报错:Datastream processing out of sync

adwnjt 2016-10-16 03:21:17
大家看到"DB-Library Process Dead - Connection Broken"的时候肯定都说网络问题,实际网络一切正常。
先说下具体情况
第1遍执行load命令,一切正常;再执行第2遍load命令就会有下面的报错。
再执行第3遍load命令,一切正常;第4遍,再报错。。。就是会这样循环

原因就是执行了下面的命令,更改了数据写入方式。
exec sp_deviceattr bhdata1, directio, false
再改回原来,执行
exec sp_deviceattr bhothlog, dsync, true
或者执行
exec sp_deviceattr bhothlog, directio, true
之后
load几遍都不会报错,请问,更改写入方式为什么会报这个错?
-------------------------------------------------------------------------------------------------------
load命令:
load database BF_APP from '/bakf/20161015/2bf_app.dump'
全部报错内容:
Backup Server session id is: 121. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Backup Server: 6.28.1.1: Dumpfile name 'BF_APP1628913118 ' section number 1 mounted on disk file '/bakf/20161015/2bf_app.dump'
Backup Server: 4.188.1.1: Database BF_APP: 3444 kilobytes (1%) LOADED.
DB-Library: Possible network error: Bad token from SQL Server: Datastream processing out of sync.
Net-Library error 0:
DB-Library: Possible network error: Bad token from SQL Server: Datastream processing out of sync. General network error. Check your documentation.
Net-Library error 10038: ConnectionClose (closesocket()).
DB-Library: Possible network error: Bad token from SQL Server: Datastream processing out of sync. General network error. Check your documentation.
Net-Library error 10038: ConnectionClose (closesocket()).
DB-Library: Possible network error: Bad token from SQL Server: Datastream processing out of sync. General network error. Check your documentation.
Net-Library error 10038: ConnectionClose (closesocket()).
DB-Library: Possible network error: Bad token from SQL Server: Datastream processing out of sync. General network error. Check your documentation.
Net-Library error 10038: ConnectionClose (closesocket()).
Backup Server: 4.188.1.1: Database BF_APP: 39430 kilobytes (19%) LOADED.

DB-Library Process Dead - Connection Broken
...全文
1934 回复 打赏 收藏 转发到动态 举报
写回复
用AI写文章
回复
切换为时间正序
请发表友善的回复…
发表回复

2,596

社区成员

发帖
与我相关
我的任务
社区描述
Sybase相关技术讨论区
社区管理员
  • Sybase社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧