Home > Archive > SQL Anywhere Mobile > May 2005 > Socket Closed Error, Sybase Network Connection has terminated









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Socket Closed Error, Sybase Network Connection has terminated
9394

2005-05-11, 3:24 am

Sorry that, due to the server is in Chinese code page, so the log is in
chinese. I already force to use the EN via dblang. Anywhere I have
another question, it is the socket closed problem.

I try to download the data from server and the ASE server terminate the
connection.

select @@version

-

Adaptive Server Enterprise/12.5.0.3/EBF 11448 ESD#4/P/Compaq Tru64/OSF1
V5.0A/rel12503/1939/64-bit/FBO/Sun Sep 21 04:22:40 2003

Do anyone know how to prevent the problem below? Any server or mobilink
server settings to prevent it?

Mobilink server startup parameters
-
dbmlsrv9 -c " DSN=whse;uid=testing
;pwd=password;hostna
me=mldev;" -zu+ -zp
-us -xtcpip(port=2537) -v+ -dl


I. 05/11 10:42:15. Adaptive Server Anywhere MobiLink 版本 9.0.1.1922
I. 05/11 10:42:15.
I. 05/11 10:42:15. 版权所有 (c) 1989-2004 Sybase, Inc.
部分版权所有 (c) 2002-2004, iAnywhere Solutions, Inc.
I. 05/11 10:42:15. 保留所有权利。保留所
有未公开的权利。
I. 05/11 10:42:15.
I. 05/11 10:42:15. This software contains confidential and trade secret
information of
I. 05/11 10:42:15. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software and
documentation
I. 05/11 10:42:15. by the U.S. Government is subject to restrictions set
forth in a license
I. 05/11 10:42:15. agreement between the Government and iAnywhere
Solutions, Inc. or
I. 05/11 10:42:15. other written agreement specifying the Government's
rights to use the
I. 05/11 10:42:15. software and any applicable FAR provisions, for
example, FAR 52.227-19.
I. 05/11 10:42:15.
I. 05/11 10:42:15. iAnywhere Solutions, Inc., One Sybase Drive, Dublin,
CA 94568, USA
I. 05/11 10:42:15.
I. 05/11 10:42:15. 网络席位（逐席位）模
型。仅限 1 个席位访问服务器。
该服务器授权给:
I. 05/11 10:42:15. ky
I. 05/11 10:42:15.
I. 05/11 10:42:15. <主>: MobiLink 服务器已启动
I. 05/11 10:42:15. <主>: 选项 1: -c
I. 05/11 10:42:15. <主>: 选项 2: ****************
I. 05/11 10:42:15. <主>: 选项 3: -zu+
I. 05/11 10:42:15. <主>: 选项 4: -zp
I. 05/11 10:42:15. <主>: 选项 5: -us
I. 05/11 10:42:15. <主>: 选项 6: -xtcpip(port=2537)
I. 05/11 10:42:15. <主>: 选项 7: -v+
I. 05/11 10:42:15. <主>: 详细记录: 显示行值
I. 05/11 10:42:15. <主>: 详细记录: 调用时显示脚本名
I. 05/11 10:42:15. <主>: 详细记录: 调用时显示脚本内容
I. 05/11 10:42:15. <主>: 详细记录: 显示每个表的模式
I. 05/11 10:42:15. <主>: 详细记录: 第一次同步读取失败时
显示错误
I. 05/11 10:42:15. <主>: 详细记录: 为准备语句显示已转换
的 SQL
I. 05/11 10:42:15. <主>: 详细记录: 显示行计数值
I. 05/11 10:42:15. <主>: 同步出错后将关闭各个
数据库连接。
I. 05/11 10:42:15. <主>: BLOB 高速缓存大小: 524288
I. 05/11 10:42:15. <主>: 要比较的最大 BLOB 字节数: 4294967295
I. 05/11 10:42:15. <主>: 最大数据库连接数: 6
I. 05/11 10:42:15. <主>: 死锁重试的最大次数: 10
I. 05/11 10:42:15. <主>: 不活动数据库连接的超
时时间: 60 分钟
I. 05/11 10:42:15. <主>: 死锁后重试之间的最大
延迟: 30 秒
I. 05/11 10:42:15. <主>: 行集大小: 10
I. 05/11 10:42:15. <主>: 上载高速缓存大小: 524288 字节
I. 05/11 10:42:15. <主>: 下载高速缓存内存大小
: 1048576 字节
I. 05/11 10:42:15. <主>: 下载高速缓存目录大小
: 10485760 字节
I. 05/11 10:42:15. <主>: 工作线程数: 5
I. 05/11 10:42:15. <主>: 最大并发上载线程数: 5
W. 05/11 10:42:15. <主>: 警告: 将自动添加未知用户（
当没有
authenticate_user 脚本时）。
I. 05/11 10:42:15. <主>: 对于未知版本，不会自
动生成示例脚本。
I. 05/11 10:42:15. <主>: 远程同步日志的本地文
件: 'dbmlsrv.mle'
I. 05/11 10:42:15. <主>: 流分类符 1: tcpip(port=2537)
I. 05/11 10:42:16. <主>: ODBC DBMS 名: SQL Server
I. 05/11 10:42:16. <主>: ODBC DBMS 版本: 12.50.0000
I. 05/11 10:42:16. <主>: ODBC DBMS 驱动程序版本: 04.20.0067 (B0063,
U0059)
W. 05/11 10:42:16. <主>: 警告: [10051] 无法识别的 ODBC 驱动I. 05/11
10:42:24. <主>: 已转换 SQL:
SELECT COUNT(*) FROM ml_scripts_modified
I. 05/11 10:42:24. <线程 1.1>: 处理请求就绪
I. 05/11 10:42:24. <线程 1.2>: 处理请求就绪
I. 05/11 10:42:24. <线程 1.3>: 处理请求就绪
I. 05/11 10:42:24. <线程 1.4>: 处理请求就绪
I. 05/11 10:42:24. <线程 1.5>: 处理请求就绪
....
E. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: [-
10002] ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]Socket
closed.（ODBC 状态 = 08S01，本地错误代码 = 7503）
E. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: [-
10002] ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]Sybase
Network Connection has terminated. If a transaction was in progress it
has been aborted.（ODBC 状态 = 08S01，本地错误代码 = 0）
E. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: [-
10002] ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]Sybase
Network Connection has terminated. If a transaction was in progress it
has been aborted.（ODBC 状态 = 08S01，本地错误代码 = 0）
E. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: [-
10002] ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]Sybase
Network Connection has terminated. If a transaction was in progress it
has been aborted.（ODBC 状态 = 08S01，本地错误代码 = 0）
E. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: [-
10002] ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]Sybase
Network Connection has terminated. If a transaction was in progress it
has been aborted.（ODBC 状态 = 08S01，本地错误代码 = 0）
E. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: [-
10002] ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]Sybase
Network Connection has terminated. If a transaction was in progress it
has been aborted.（ODBC 状态 = 08S01，本地错误代码 = 0）
E. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: [-
10002] ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]Sybase
Network Connection has terminated. If a transaction was in progress it
has been aborted.（ODBC 状态 = 08S01，本地错误代码 = 0）
E. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: [-
10002] ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]Sybase
Network Connection has terminated. If a transaction was in progress it
has been aborted.（ODBC 状态 = 08S01，本地错误代码 = 0）
E. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: [-
10002] ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]Sybase
Network Connection has terminated. If a transaction was in progress it
has been aborted.（ODBC 状态 = 08S01，本地错误代码 = 0）
E. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: [-
10002] ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]Sybase
Network Connection has terminated. If a transaction was in progress it
has been aborted.（ODBC 状态 = 08S01，本地错误代码 = 0）
I. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误环境:
I. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 用户名:
999:1.0.0@2b688:1.0.0:12b25f04
I. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 綺修改的用户
名: 999
I. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 事务:
download
I. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 表名:
supplier
I. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 脚本版本:
default
I. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 脚本: exec
pda_get_supplier ?,?
I. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误环境结尾
I. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: report_error
<连接>
insert pda_ml_errorlog
(log_date,action_cod
e,error_code,
err_message,ml_usern
ame,tablename)
select getdate(), ?, ?, ?, ?, ?
I. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已缓存 ODBC 语
句:
insert pda_ml_errorlog
(log_date,action_cod
e,error_code,
err_message,ml_usern
ame,tablename)
select getdate(), ?, ?, ?, ?, ?
I. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: report_error
<连接>
insert pda_ml_errorlog
(log_date,action_cod
e,error_code,
err_message,ml_usern
ame,tablename)
select getdate(), ?, ?, ?, ?, ?
I. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已缓存 ODBC 语
句:
insert pda_ml_errorlog
(log_date,action_cod
e,error_code,
err_message,ml_usern
ame,tablename)
select getdate(), ?, ?, ?, ?, ?
I. 05/11 10:49:25. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: report_error
<连接>
insert pda_ml_errorlog
(log_date,action_cod
e,error_code,
err_message,ml_usern
ame,tablename)
select getdate(), ?, ?, ?, ?, ?
I. 05/11 10:49:25. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已缓存 ODBC 语
句:
insert pda_ml_errorlog
(log_date,action_cod
e,error_code,
err_message,ml_usern
ame,tablename)
select getdate(), ?, ?, ?, ?, ?
I. 05/11 10:49:25. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: report_error
<连接>
insert pda_ml_errorlog
(log_date,action_cod
e,error_code,
err_message,ml_usern
ame,tablename)
select getdate(), ?, ?, ?, ?, ?
I. 05/11 10:49:25. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已缓存 ODBC 语
句:
insert pda_ml_errorlog
(log_date,action_cod
e,error_code,
err_message,ml_usern
ame,tablename)
select getdate(), ?, ?, ?, ?, ?
I. 05/11 10:49:25. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: report_error
<连接>
insert pda_ml_errorlog
(log_date,action_cod
e,error_code,
err_message,ml_usern
ame,tablename)
select getdate(), ?, ?, ?, ?, ?
I. 05/11 10:49:25. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已缓存 ODBC 语
句:
insert pda_ml_errorlog
(log_date,action_cod
e,error_code,
err_message,ml_usern
ame,tablename)
select getdate(), ?, ?, ?, ?, ?
I. 05/11 10:49:25. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: report_error
<连接>
insert pda_ml_errorlog
(log_date,action_cod
e,error_code,
err_message,ml_usern
ame,tablename)
select getdate(), ?, ?, ?, ?, ?
I. 05/11 10:49:25. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已缓存 ODBC 语
句:
insert pda_ml_errorlog
(log_date,action_cod
e,error_code,
err_message,ml_usern
ame,tablename)
select getdate(), ?, ?, ?, ?, ?
I. 05/11 10:49:25. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: report_error
<连接>
insert pda_ml_errorlog
(log_date,action_cod
e,error_code,
err_message,ml_usern
ame,tablename)
select getdate(), ?, ?, ?, ?, ?
I. 05/11 10:49:25. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已缓存 ODBC 语
句:
insert pda_ml_errorlog
(log_date,action_cod
e,error_code,
err_message,ml_usern
ame,tablename)
select getdate(), ?, ?, ?, ?, ?
I. 05/11 10:49:25. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: report_error
<连接>
insert pda_ml_errorlog
(log_date,action_cod
e,error_code,
err_message,ml_usern
ame,tablename)
select getdate(), ?, ?, ?, ?, ?
I. 05/11 10:49:25. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已缓存 ODBC 语
句:
insert pda_ml_errorlog
(log_date,action_cod
e,error_code,
err_message,ml_usern
ame,tablename)
select getdate(), ?, ?, ?, ?, ?
I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: report_error
<连接>
insert pda_ml_errorlog
(log_date,action_cod
e,error_code,
err_message,ml_usern
ame,tablename)
select getdate(), ?, ?, ?, ?, ?
I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已缓存 ODBC 语
句:
insert pda_ml_errorlog
(log_date,action_cod
e,error_code,
err_message,ml_usern
ame,tablename)
select getdate(), ?, ?, ?, ?, ?
I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: report_error
<连接>
insert pda_ml_errorlog
(log_date,action_cod
e,error_code,
err_message,ml_usern
ame,tablename)
select getdate(), ?, ?, ?, ?, ?
I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已缓存 ODBC 语
句:
insert pda_ml_errorlog
(log_date,action_cod
e,error_code,
err_message,ml_usern
ame,tablename)
select getdate(), ?, ?, ?, ?, ?
W. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 警告: [10010]
未定义任何 handle_error 脚本。缺省的动作代码
(3000) 将决定错误行为
I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]:
download_cursor supplier（关闭）
I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: end_download
supplier（无脚本）
I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: end_download
<连接>（无脚本）
I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 从表 supplier
中下载以进行删除的行
数: 0
I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 从表 supplier
中下载以进行插入/更新的行数: 850
I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 表 supplier
中过滤出来要下载的行
数: 0
I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 从表 supplier
中下载以进行远程处理
的行数: 850
E. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: [-
10002] ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]Sybase
Network Connection has terminated. If a transaction was in progress it
has been aborted.（ODBC 状态 = 08S01，本地错误代码 = 0）
E. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: 无法回退
(ROLLBACK) 事务: end_download
I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误环境:
I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 用户名:
999:1.0.0@2b688:1.0.0:12b25f04
I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 綺修改的用户
名: 999
I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 事务:
download
I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 表名: NULL
I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 脚本版本:
default
I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 脚本: exec
pda_get_supplier ?,?
I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误环境结尾
I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: report_error
<连接>
insert pda_ml_errorlog
(log_date,action_cod
e,error_code,
err_message,ml_usern
ame,tablename)
select getdate(), ?, ?, ?, ?, ?
I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已缓存 ODBC 语
句:
insert pda_ml_errorlog
(log_date,action_cod
e,error_code,
err_message,ml_usern
ame,tablename)
select getdate(), ?, ?, ?, ?, ?
W. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 警告: [10010]
未定义任何 handle_error 脚本。缺省的动作代码
(3000) 将决定错误行为
I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]:
end_publication <连接>（无脚本）
I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]:
end_synchronization supplier（无脚本）
I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]:
end_synchronization <连接>
exec pda_ml_end_sync ?, ?
E. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: [-
10002] ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]Sybase
Network Connection has terminated. If a transaction was in progress it
has been aborted.（ODBC 状态 = 08S01，本地错误代码 = 0）
E. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: 无法回退
(ROLLBACK) 事务: end_synchronization
I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误环境:
I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 用户名:
999:1.0.0@2b688:1.0.0:12b25f04
I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 綺修改的用户
名: 999
I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 事务:
end_synchronization
I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 表名: NULL
I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 脚本版本:
default
I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 脚本: exec
pda_ml_end_sync ?, ?
I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误环境结尾
I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: report_error
<连接>
insert pda_ml_errorlog
(log_date,action_cod
e,error_code,
err_message,ml_usern
ame,tablename)
select getdate(), ?, ?, ?, ?, ?
I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已缓存 ODBC 语
句:
insert pda_ml_errorlog
(log_date,action_cod
e,error_code,
err_message,ml_usern
ame,tablename)
select getdate(), ?, ?, ?, ?, ?
W. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 警告: [10010]
未定义任何 handle_error 脚本。缺省的动作代码
(3000) 将决定错误行为
I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已与统一数据库
断开连接
I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 同步失败

Reg Domaratzki \(iAnywhere Solutions\)

2005-05-12, 8:24 pm

Does the ASE errorlog provide any insight as to why the connection was
terminated?

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"9394" <9394@pip.no-ip.org> wrote in message
news:Xns96536EC6C9C4
29394pipnoipinfo@192
.138.151.106...
> Sorry that, due to the server is in Chinese code page, so the log is in
> chinese. I already force to use the EN via dblang. Anywhere I have
> another question, it is the socket closed problem.
>
> I try to download the data from server and the ASE server terminate the
> connection.
>
> select @@version
> -
> Adaptive Server Enterprise/12.5.0.3/EBF 11448 ESD#4/P/Compaq Tru64/OSF1
> V5.0A/rel12503/1939/64-bit/FBO/Sun Sep 21 04:22:40 2003
>
> Do anyone know how to prevent the problem below? Any server or mobilink
> server settings to prevent it?
>
> Mobilink server startup parameters
> -
> dbmlsrv9 -c " DSN=whse;uid=testing
;pwd=password;hostna
me=mldev;" -zu+ -zp
> -us -xtcpip(port=2537) -v+ -dl
>
>
> I. 05/11 10:42:15. Adaptive Server Anywhere MobiLink 版本 9.0.1.1922
> I. 05/11 10:42:15.
> I. 05/11 10:42:15. 版权所有 (c) 1989-2004 Sybase, Inc.
> 部分版权所有 (c) 2002-2004, iAnywhere Solutions, Inc.
> I. 05/11 10:42:15. 保留所有权利。保留所
有未公开的权利。
> I. 05/11 10:42:15.
> I. 05/11 10:42:15. This software contains confidential and trade secret
> information of
> I. 05/11 10:42:15. iAnywhere Solutions, Inc.
> Use, duplication or disclosure of the software and
> documentation
> I. 05/11 10:42:15. by the U.S. Government is subject to restrictions set
> forth in a license
> I. 05/11 10:42:15. agreement between the Government and iAnywhere
> Solutions, Inc. or
> I. 05/11 10:42:15. other written agreement specifying the Government's
> rights to use the
> I. 05/11 10:42:15. software and any applicable FAR provisions, for
> example, FAR 52.227-19.
> I. 05/11 10:42:15.
> I. 05/11 10:42:15. iAnywhere Solutions, Inc., One Sybase Drive, Dublin,
> CA 94568, USA
> I. 05/11 10:42:15.
> I. 05/11 10:42:15. 网络席位（逐席位）模
型。仅限 1 个席位访问服务器。
> 该服务器授权给:
> I. 05/11 10:42:15. ky
> I. 05/11 10:42:15.
> I. 05/11 10:42:15. <主>: MobiLink 服务器已启动
> I. 05/11 10:42:15. <主>: 选项 1: -c
> I. 05/11 10:42:15. <主>: 选项 2: ****************
> I. 05/11 10:42:15. <主>: 选项 3: -zu+
> I. 05/11 10:42:15. <主>: 选项 4: -zp
> I. 05/11 10:42:15. <主>: 选项 5: -us
> I. 05/11 10:42:15. <主>: 选项 6: -xtcpip(port=2537)
> I. 05/11 10:42:15. <主>: 选项 7: -v+
> I. 05/11 10:42:15. <主>: 详细记录: 显示行值
> I. 05/11 10:42:15. <主>: 详细记录: 调用时显示脚本名
> I. 05/11 10:42:15. <主>: 详细记录: 调用时显示脚本内容
> I. 05/11 10:42:15. <主>: 详细记录: 显示每个表的模式
> I. 05/11 10:42:15. <主>: 详细记录: 第一次同步读取失败时
显示错误
> I. 05/11 10:42:15. <主>: 详细记录: 为准备语句显示已转换
的 SQL
> I. 05/11 10:42:15. <主>: 详细记录: 显示行计数值
> I. 05/11 10:42:15. <主>: 同步出错后将关闭各个
数据库连接。
> I. 05/11 10:42:15. <主>: BLOB 高速缓存大小: 524288
> I. 05/11 10:42:15. <主>: 要比较的最大 BLOB 字节数: 4294967295
> I. 05/11 10:42:15. <主>: 最大数据库连接数: 6
> I. 05/11 10:42:15. <主>: 死锁重试的最大次数: 10
> I. 05/11 10:42:15. <主>: 不活动数据库连接的超
时时间: 60 分钟
> I. 05/11 10:42:15. <主>: 死锁后重试之间的最大
延迟: 30 秒
> I. 05/11 10:42:15. <主>: 行集大小: 10
> I. 05/11 10:42:15. <主>: 上载高速缓存大小: 524288 字节
> I. 05/11 10:42:15. <主>: 下载高速缓存内存大小
: 1048576 字节
> I. 05/11 10:42:15. <主>: 下载高速缓存目录大小
: 10485760 字节
> I. 05/11 10:42:15. <主>: 工作线程数: 5
> I. 05/11 10:42:15. <主>: 最大并发上载线程数: 5
> W. 05/11 10:42:15. <主>: 警告: 将自动添加未知用户（
当没有
> authenticate_user 脚本时）。
> I. 05/11 10:42:15. <主>: 对于未知版本，不会自
动生成示例脚本。
> I. 05/11 10:42:15. <主>: 远程同步日志的本地文
件: 'dbmlsrv.mle'
> I. 05/11 10:42:15. <主>: 流分类符 1: tcpip(port=2537)
> I. 05/11 10:42:16. <主>: ODBC DBMS 名: SQL Server
> I. 05/11 10:42:16. <主>: ODBC DBMS 版本: 12.50.0000
> I. 05/11 10:42:16. <主>: ODBC DBMS 驱动程序版本: 04.20.0067 (B0063,
> U0059)
> W. 05/11 10:42:16. <主>: 警告: [10051] 无法识别的 ODBC 驱动I. 05/11
> 10:42:24. <主>: 已转换 SQL:
> SELECT COUNT(*) FROM ml_scripts_modified
> I. 05/11 10:42:24. <线程 1.1>: 处理请求就绪
> I. 05/11 10:42:24. <线程 1.2>: 处理请求就绪
> I. 05/11 10:42:24. <线程 1.3>: 处理请求就绪
> I. 05/11 10:42:24. <线程 1.4>: 处理请求就绪
> I. 05/11 10:42:24. <线程 1.5>: 处理请求就绪
> ...
> E. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: [-
> 10002] ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]Socket
> closed.（ODBC 状态 = 08S01，本地错误代码 = 7503）
> E. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: [-
> 10002] ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]Sybase
> Network Connection has terminated. If a transaction was in progress it
> has been aborted.（ODBC 状态 = 08S01，本地错误代码 = 0）
> E. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: [-
> 10002] ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]Sybase
> Network Connection has terminated. If a transaction was in progress it
> has been aborted.（ODBC 状态 = 08S01，本地错误代码 = 0）
> E. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: [-
> 10002] ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]Sybase
> Network Connection has terminated. If a transaction was in progress it
> has been aborted.（ODBC 状态 = 08S01，本地错误代码 = 0）
> E. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: [-
> 10002] ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]Sybase
> Network Connection has terminated. If a transaction was in progress it
> has been aborted.（ODBC 状态 = 08S01，本地错误代码 = 0）
> E. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: [-
> 10002] ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]Sybase
> Network Connection has terminated. If a transaction was in progress it
> has been aborted.（ODBC 状态 = 08S01，本地错误代码 = 0）
> E. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: [-
> 10002] ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]Sybase
> Network Connection has terminated. If a transaction was in progress it
> has been aborted.（ODBC 状态 = 08S01，本地错误代码 = 0）
> E. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: [-
> 10002] ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]Sybase
> Network Connection has terminated. If a transaction was in progress it
> has been aborted.（ODBC 状态 = 08S01，本地错误代码 = 0）
> E. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: [-
> 10002] ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]Sybase
> Network Connection has terminated. If a transaction was in progress it
> has been aborted.（ODBC 状态 = 08S01，本地错误代码 = 0）
> E. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: [-
> 10002] ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]Sybase
> Network Connection has terminated. If a transaction was in progress it
> has been aborted.（ODBC 状态 = 08S01，本地错误代码 = 0）
> I. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误环境:
> I. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 用户名:
> 999:1.0.0@2b688:1.0.0:12b25f04
> I. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 綺修改的用户
> 名: 999
> I. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 事务:
> download
> I. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 表名:
> supplier
> I. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 脚本版本:
> default
> I. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 脚本: exec
> pda_get_supplier ?,?
> I. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误环境结尾
> I. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: report_error
> <连接>
> insert pda_ml_errorlog
> (log_date,action_cod
e,error_code,
> err_message,ml_usern
ame,tablename)
> select getdate(), ?, ?, ?, ?, ?
> I. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已缓存 ODBC 语
> 句:
> insert pda_ml_errorlog
> (log_date,action_cod
e,error_code,
> err_message,ml_usern
ame,tablename)
> select getdate(), ?, ?, ?, ?, ?
> I. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: report_error
> <连接>
> insert pda_ml_errorlog
> (log_date,action_cod
e,error_code,
> err_message,ml_usern
ame,tablename)
> select getdate(), ?, ?, ?, ?, ?
> I. 05/11 10:49:24. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已缓存 ODBC 语
> 句:
> insert pda_ml_errorlog
> (log_date,action_cod
e,error_code,
> err_message,ml_usern
ame,tablename)
> select getdate(), ?, ?, ?, ?, ?
> I. 05/11 10:49:25. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: report_error
> <连接>
> insert pda_ml_errorlog
> (log_date,action_cod
e,error_code,
> err_message,ml_usern
ame,tablename)
> select getdate(), ?, ?, ?, ?, ?
> I. 05/11 10:49:25. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已缓存 ODBC 语
> 句:
> insert pda_ml_errorlog
> (log_date,action_cod
e,error_code,
> err_message,ml_usern
ame,tablename)
> select getdate(), ?, ?, ?, ?, ?
> I. 05/11 10:49:25. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: report_error
> <连接>
> insert pda_ml_errorlog
> (log_date,action_cod
e,error_code,
> err_message,ml_usern
ame,tablename)
> select getdate(), ?, ?, ?, ?, ?
> I. 05/11 10:49:25. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已缓存 ODBC 语
> 句:
> insert pda_ml_errorlog
> (log_date,action_cod
e,error_code,
> err_message,ml_usern
ame,tablename)
> select getdate(), ?, ?, ?, ?, ?
> I. 05/11 10:49:25. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: report_error
> <连接>
> insert pda_ml_errorlog
> (log_date,action_cod
e,error_code,
> err_message,ml_usern
ame,tablename)
> select getdate(), ?, ?, ?, ?, ?
> I. 05/11 10:49:25. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已缓存 ODBC 语
> 句:
> insert pda_ml_errorlog
> (log_date,action_cod
e,error_code,
> err_message,ml_usern
ame,tablename)
> select getdate(), ?, ?, ?, ?, ?
> I. 05/11 10:49:25. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: report_error
> <连接>
> insert pda_ml_errorlog
> (log_date,action_cod
e,error_code,
> err_message,ml_usern
ame,tablename)
> select getdate(), ?, ?, ?, ?, ?
> I. 05/11 10:49:25. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已缓存 ODBC 语
> 句:
> insert pda_ml_errorlog
> (log_date,action_cod
e,error_code,
> err_message,ml_usern
ame,tablename)
> select getdate(), ?, ?, ?, ?, ?
> I. 05/11 10:49:25. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: report_error
> <连接>
> insert pda_ml_errorlog
> (log_date,action_cod
e,error_code,
> err_message,ml_usern
ame,tablename)
> select getdate(), ?, ?, ?, ?, ?
> I. 05/11 10:49:25. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已缓存 ODBC 语
> 句:
> insert pda_ml_errorlog
> (log_date,action_cod
e,error_code,
> err_message,ml_usern
ame,tablename)
> select getdate(), ?, ?, ?, ?, ?
> I. 05/11 10:49:25. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: report_error
> <连接>
> insert pda_ml_errorlog
> (log_date,action_cod
e,error_code,
> err_message,ml_usern
ame,tablename)
> select getdate(), ?, ?, ?, ?, ?
> I. 05/11 10:49:25. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已缓存 ODBC 语
> 句:
> insert pda_ml_errorlog
> (log_date,action_cod
e,error_code,
> err_message,ml_usern
ame,tablename)
> select getdate(), ?, ?, ?, ?, ?
> I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: report_error
> <连接>
> insert pda_ml_errorlog
> (log_date,action_cod
e,error_code,
> err_message,ml_usern
ame,tablename)
> select getdate(), ?, ?, ?, ?, ?
> I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已缓存 ODBC 语
> 句:
> insert pda_ml_errorlog
> (log_date,action_cod
e,error_code,
> err_message,ml_usern
ame,tablename)
> select getdate(), ?, ?, ?, ?, ?
> I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: report_error
> <连接>
> insert pda_ml_errorlog
> (log_date,action_cod
e,error_code,
> err_message,ml_usern
ame,tablename)
> select getdate(), ?, ?, ?, ?, ?
> I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已缓存 ODBC 语
> 句:
> insert pda_ml_errorlog
> (log_date,action_cod
e,error_code,
> err_message,ml_usern
ame,tablename)
> select getdate(), ?, ?, ?, ?, ?
> W. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 警告: [10010]
> 未定义任何 handle_error 脚本。缺省的动作代码
(3000) 将决定错误行为
> I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]:
> download_cursor supplier（关闭）
> I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: end_download
> supplier（无脚本）
> I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: end_download
> <连接>（无脚本）
> I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 从表 supplier
> 中下载以进行删除的行
数: 0
> I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 从表 supplier
> 中下载以进行插入/更新的行数: 850
> I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 表 supplier
> 中过滤出来要下载的行
数: 0
> I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 从表 supplier
> 中下载以进行远程处理
的行数: 850
> E. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: [-
> 10002] ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]Sybase
> Network Connection has terminated. If a transaction was in progress it
> has been aborted.（ODBC 状态 = 08S01，本地错误代码 = 0）
> E. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: 无法回退
> (ROLLBACK) 事务: end_download
> I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误环境:
> I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 用户名:
> 999:1.0.0@2b688:1.0.0:12b25f04
> I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 綺修改的用户
> 名: 999
> I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 事务:
> download
> I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 表名: NULL
> I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 脚本版本:
> default
> I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 脚本: exec
> pda_get_supplier ?,?
> I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误环境结尾
> I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: report_error
> <连接>
> insert pda_ml_errorlog
> (log_date,action_cod
e,error_code,
> err_message,ml_usern
ame,tablename)
> select getdate(), ?, ?, ?, ?, ?
> I. 05/11 10:49:26. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已缓存 ODBC 语
> 句:
> insert pda_ml_errorlog
> (log_date,action_cod
e,error_code,
> err_message,ml_usern
ame,tablename)
> select getdate(), ?, ?, ?, ?, ?
> W. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 警告: [10010]
> 未定义任何 handle_error 脚本。缺省的动作代码
(3000) 将决定错误行为
> I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]:
> end_publication <连接>（无脚本）
> I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]:
> end_synchronization supplier（无脚本）
> I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]:
> end_synchronization <连接>
> exec pda_ml_end_sync ?, ?
> E. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: [-
> 10002] ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]Sybase
> Network Connection has terminated. If a transaction was in progress it
> has been aborted.（ODBC 状态 = 08S01，本地错误代码 = 0）
> E. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误: 无法回退
> (ROLLBACK) 事务: end_synchronization
> I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误环境:
> I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 用户名:
> 999:1.0.0@2b688:1.0.0:12b25f04
> I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 綺修改的用户
> 名: 999
> I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 事务:
> end_synchronization
> I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 表名: NULL
> I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 脚本版本:
> default
> I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 脚本: exec
> pda_ml_end_sync ?, ?
> I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 错误环境结尾
> I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: report_error
> <连接>
> insert pda_ml_errorlog
> (log_date,action_cod
e,error_code,
> err_message,ml_usern
ame,tablename)
> select getdate(), ?, ?, ?, ?, ?
> I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已缓存 ODBC 语
> 句:
> insert pda_ml_errorlog
> (log_date,action_cod
e,error_code,
> err_message,ml_usern
ame,tablename)
> select getdate(), ?, ?, ?, ?, ?
> W. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 警告: [10010]
> 未定义任何 handle_error 脚本。缺省的动作代码
(3000) 将决定错误行为
> I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 已与统一数据库
> 断开连接
> I. 05/11 10:49:27. <1.5> [999:1.0.0@2b688:1.0.0:12b25f04]: 同步失败
>


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com