sybase宕机问题，跪求各位大侠看看！！！

dyhlx

01:00000:00000:2006/06/01 00:37:52.66 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
01:00000:00000:2006/06/01 00:37:52.71 kernel  pc: 0x2039D3EB (can't find module)(0x00000001, 0x00000000, 0x00000000, 0x00000000)
01:00000:00000:2006/06/01 00:37:52.88 kernel  pc: 0x2039D3EB (can't find module)(0x00000001, 0x00088F28, 0x20203639, 0x696C6E6F)
01:00000:00000:2006/06/01 00:37:52.90 kernel  pc: 0x009D4E81 kpcheckio+ 0xc0 (0x00000000, 0x2000FFC0, 0x20029274, 0x2001A2C0)
01:00000:00000:2006/06/01 00:37:52.90 kernel  pc: 0x009D3338 kpsched+ 0xfb0 (0x00000000, 0x00088590, 0x00CE24AB, 0x85559CA0)
01:00000:00000:2006/06/01 00:37:52.90 kernel  pc: 0x009D2357 kpstartsched+ 0xe7 (0x00CE24AB, 0x00000000, 0x00088590, 0x00CE24AB)
01:00000:00000:2006/06/01 00:37:52.90 kernel  pc: 0x0099C55F kestartup+ 0x7e3 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
01:00000:00000:2006/06/01 00:37:52.90 kernel  end of stack trace, kernel service process: kpid 1507351
01:00000:00000:2006/06/01 00:37:52.90 kernel  engine 1, os pid 896  exited
01:00000:00000:2006/06/01 00:37:52.90 kernel  Could not replace infected engine.
01:00000:00000:2006/06/01 00:37:52.90 kernel  ueshutdown: exiting
01:00000:00000:2006/06/01 00:37:52.91 kernel  Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.

RS9000

以前能启动吗？你的配置文件是不是有问题。

1017of

why not provider the whole information of the event?a part of it is just like confirming one's age just by one's voice.

dyhlx

完整的日志如下，sybase不停重复宕机，异常退出，大概几小时一次！


00:00000:00000:2006/06/01 00:42:59.32 kernel  Use license file d:\SYBASE\SYSAM-1_0\licenses\license.dat.
00:00000:00000:2006/06/01 00:42:59.33 kernel  Using config area from primary master device.
00:00000:00000:2006/06/01 00:42:59.33 kernel  Warning: Using default file 'd:\SYBASE\syb.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2006/06/01 00:43:01.22 kernel  Kernel memory at 0x20000000, 425984 bytes
00:00000:00000:2006/06/01 00:43:01.22 kernel  Server part of first shared memory region at 0x20068000, 653885440 bytes.
00:00000:00000:2006/06/01 00:43:01.22 kernel  Highest valid address is 0x20068000
00:00000:00000:2006/06/01 00:43:01.22 kernel  Using 100000 file descriptors.
00:00000:00000:2006/06/01 00:43:01.22 kernel  Adaptive Server Enterprise/12.0/P/SWR 8776 ESD 1/NT (IX86)/OS 4.0/1580/32bit/OPT/Mon Dec 06 21:50:07 1999
00:00000:00000:2006/06/01 00:43:01.22 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2006/06/01 00:43:01.22 kernel  Copyright 1987, 1999
00:00000:00000:2006/06/01 00:43:01.22 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2006/06/01 00:43:01.22 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2006/06/01 00:43:01.22 kernel  
00:00000:00000:2006/06/01 00:43:01.22 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2006/06/01 00:43:01.22 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2006/06/01 00:43:01.22 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2006/06/01 00:43:01.22 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2006/06/01 00:43:01.22 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2006/06/01 00:43:01.22 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2006/06/01 00:43:01.22 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2006/06/01 00:43:01.22 kernel  Using 'd:\SYBASE\syb.cfg' for configuration information.
00:00000:00000:2006/06/01 00:43:01.22 kernel  Logging ASE messages in file 'd:\SYBASE\ASE-12_0\install\errorlog'.
00:00000:00000:2006/06/01 00:43:01.24 kernel  Initializing MSDTC Connection
00:00000:00000:2006/06/01 00:43:02.41 kernel  MSDTC Initialization succeeded
00:00000:00000:2006/06/01 00:43:02.41 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2006/06/01 00:43:02.41 kernel  SQL Server NT process id is 0xafc.
00:00000:00000:2006/06/01 00:43:02.41 kernel  SQL Server was started as a Service.
00:00000:00000:2006/06/01 00:43:02.41 kernel  Network and device connection limit is 99992.
00:00000:00000:2006/06/01 00:43:02.44 server  Number of proc buffers allocated: 62244.
00:00000:00000:2006/06/01 00:43:03.29 server  Number of blocks left for proc headers: 62200.
00:00000:00000:2006/06/01 00:43:03.32 server  Proc header memory allocated 7775 pages for each per engine cache
00:00000:00000:2006/06/01 00:43:03.32 server   Memory allocated for the default data cache cachelet 1: 468438 Kb
00:00000:00000:2006/06/01 00:43:03.37 server  Size of the 2K memory pool: 468438 Kb
00:00000:00000:2006/06/01 00:43:03.38 kernel  Initializing virtual device 0, 'd:\SYBASE\data\master.dat' with dsync 'on'.
00:00000:00000:2006/06/01 00:43:03.38 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2006/06/01 00:43:03.38 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2006/06/01 00:43:03.38 kernel  Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2006/06/01 00:43:03.38 kernel  engine 0, os pid 252  online
00:00000:00000:2006/06/01 00:43:03.38 server  No active traceflags
00:00000:00001:2006/06/01 00:43:03.38 kernel  Component Integration Services loaded; version 'Component Integration Services/12.0/P/SWR 8776 ESD 1/NT (IX86)/OS 4.0/1580/32bit/OPT/Mon Dec 06 20:31:23 1999'.
00:00000:00001:2006/06/01 00:43:03.38 kernel  Component Integration Services: using 'Sybase Client-Library/12.0/P/PC Intel/1/OPT/Mon Oct 04 15:42:12 1999'
00:00000:00001:2006/06/01 00:43:03.38 server  Opening Master Database ...
00:00000:00001:2006/06/01 00:43:03.44 server  Loading SQL Server's default sort order and character set
00:00000:00001:2006/06/01 00:43:03.44 server  Loaded default Unilib conversion handle.
00:00000:00002:2006/06/01 00:43:03.44 kernel  network name 192.168.10.54, type ether, port 5000
00:00000:00001:2006/06/01 00:43:03.47 server  Recovering database 'master'
00:00000:00001:2006/06/01 00:43:03.49 server  Redo pass of recovery has processed 1 committed and 0 aborted transactions.
00:00000:00001:2006/06/01 00:43:03.76 server  Checking external objects.
00:00000:00001:2006/06/01 00:43:03.79 server  Database 'master' is now online.
00:00000:00001:2006/06/01 00:43:03.79 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2006/06/01 00:43:03.83 server  This installation was created using a 12.0 or later version of bldmastr.
00:00000:00001:2006/06/01 00:43:03.83 server  0 dump conditions detected at boot time
00:00000:00001:2006/06/01 00:43:03.85 server  server is unnamed
00:00000:00001:2006/06/01 00:43:03.87 server  Activating disk 'log1'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Initializing virtual device 17, 'E:\sybase\data\log1.dat' with dsync 'on'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Virtual device 17 started using asynchronous i/o.
00:00000:00001:2006/06/01 00:43:03.87 server  Activating disk 'log2'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Initializing virtual device 18, 'E:\sybase\data\log2.dat' with dsync 'on'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Virtual device 18 started using asynchronous i/o.
00:00000:00001:2006/06/01 00:43:03.87 server  Activating disk 'mail1'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Initializing virtual device 4, 'E:\sybase\data\mail1.dat' with dsync 'on'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Virtual device 4 started using asynchronous i/o.
00:00000:00001:2006/06/01 00:43:03.87 server  Activating disk 'mail10'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Initializing virtual device 13, 'E:\sybase\data\mail10.dat' with dsync 'on'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Virtual device 13 started using asynchronous i/o.
00:00000:00001:2006/06/01 00:43:03.87 server  Activating disk 'mail11'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Initializing virtual device 14, 'E:\sybase\data\mail11.dat' with dsync 'on'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Virtual device 14 started using asynchronous i/o.
00:00000:00001:2006/06/01 00:43:03.87 server  Activating disk 'mail12'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Initializing virtual device 15, 'E:\sybase\data\mail12.dat' with dsync 'on'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Virtual device 15 started using asynchronous i/o.
00:00000:00001:2006/06/01 00:43:03.87 server  Activating disk 'mail13'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Initializing virtual device 16, 'E:\sybase\data\mail13.dat' with dsync 'on'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Virtual device 16 started using asynchronous i/o.
00:00000:00001:2006/06/01 00:43:03.87 server  Activating disk 'mail14'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Initializing virtual device 19, 'E:\sybase\data\mail14.dat' with dsync 'on'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Virtual device 19 started using asynchronous i/o.
00:00000:00001:2006/06/01 00:43:03.87 server  Activating disk 'mail2'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Initializing virtual device 5, 'E:\sybase\data\mail2.dat' with dsync 'on'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Virtual device 5 started using asynchronous i/o.
00:00000:00001:2006/06/01 00:43:03.87 server  Activating disk 'mail3'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Initializing virtual device 6, 'E:\sybase\data\mail3.dat' with dsync 'on'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Virtual device 6 started using asynchronous i/o.
00:00000:00001:2006/06/01 00:43:03.87 server  Activating disk 'mail4'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Initializing virtual device 7, 'E:\sybase\data\mail4.dat' with dsync 'on'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Virtual device 7 started using asynchronous i/o.
00:00000:00001:2006/06/01 00:43:03.87 server  Activating disk 'mail5'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Initializing virtual device 8, 'E:\sybase\data\mail5.dat' with dsync 'on'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Virtual device 8 started using asynchronous i/o.
00:00000:00001:2006/06/01 00:43:03.87 server  Activating disk 'mail6'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Initializing virtual device 9, 'E:\sybase\data\mail6.dat' with dsync 'on'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Virtual device 9 started using asynchronous i/o.
00:00000:00001:2006/06/01 00:43:03.87 server  Activating disk 'mail7'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Initializing virtual device 10, 'E:\sybase\data\mail7.dat' with dsync 'on'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Virtual device 10 started using asynchronous i/o.
00:00000:00001:2006/06/01 00:43:03.87 server  Activating disk 'mail8'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Initializing virtual device 11, 'E:\sybase\data\mail8.dat' with dsync 'on'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Virtual device 11 started using asynchronous i/o.
00:00000:00001:2006/06/01 00:43:03.87 server  Activating disk 'mail9'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Initializing virtual device 12, 'E:\sybase\data\mail9.dat' with dsync 'on'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Virtual device 12 started using asynchronous i/o.
00:00000:00001:2006/06/01 00:43:03.87 server  Activating disk 'sysprocsdev'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Initializing virtual device 1, 'd:\SYBASE\data\sybprocs.dat' with dsync 'on'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Virtual device 1 started using asynchronous i/o.
00:00000:00001:2006/06/01 00:43:03.87 server  Activating disk 'temp1'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Initializing virtual device 2, 'E:\sybase\data\temp1.dat' with dsync 'on'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Virtual device 2 started using asynchronous i/o.
00:00000:00001:2006/06/01 00:43:03.87 server  Activating disk 'temp2'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Initializing virtual device 3, 'E:\sybase\data\temp2.dat' with dsync 'on'.
00:00000:00001:2006/06/01 00:43:03.87 kernel  Virtual device 3 started using asynchronous i/o.
00:00000:00001:2006/06/01 00:43:03.96 server  Recovering database 'sybsystemdb'.
00:00000:00001:2006/06/01 00:43:03.97 server  Redo pass of recovery has processed 0 committed and 1 aborted transactions.
00:00000:00001:2006/06/01 00:43:04.12 server  Boot Count: 26
00:00000:00001:2006/06/01 00:43:04.16 server  Checking external objects.
00:00000:00001:2006/06/01 00:43:04.19 server  The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2006/06/01 00:43:04.24 server  Database 'sybsystemdb' is now online.
00:00000:00001:2006/06/01 00:43:04.27 server  Recovering database 'model'.
00:00000:00001:2006/06/01 00:43:04.40 server  Checking external objects.
00:00000:00001:2006/06/01 00:43:04.41 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2006/06/01 00:43:04.47 server  Database 'model' is now online.
00:00000:00001:2006/06/01 00:43:04.47 server  Resident Node id: 8d5bff14bae8
00:00000:00001:2006/06/01 00:43:04.47 server  Transaction coordinator initialized.
00:00000:00001:2006/06/01 00:43:04.49 server  Clearing temp db
00:00000:00001:2006/06/01 00:43:10.02 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/06/01 00:43:13.35 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/06/01 00:43:13.41 server  Database 'tempdb' is now online.
00:00000:00001:2006/06/01 00:43:13.41 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/06/01 00:43:13.49 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2006/06/01 00:43:18.79 server  Checking external objects.
00:00000:00001:2006/06/01 00:43:18.80 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2006/06/01 00:43:18.90 server  Database 'sybsystemprocs' is now online.
00:00000:00001:2006/06/01 00:43:18.93 server  Recovering database 'jslandmail'.
00:00000:00001:2006/06/01 00:43:18.97 server  Redo pass of recovery has processed 5 committed and 0 aborted transactions.
00:00000:00001:2006/06/01 00:43:19.08 server  Undo pass of recovery has processed 2 incomplete transactions.
00:00000:00001:2006/06/01 00:43:29.76 server  Checking external objects.
00:00000:00001:2006/06/01 00:43:29.76 server  The transaction log in the database 'jslandmail' will use I/O size of 2 Kb.
00:00000:00001:2006/06/01 00:43:29.82 server  Database 'jslandmail' is now online.
00:00000:00001:2006/06/01 00:43:29.83 server  Recovery complete.
00:00000:00001:2006/06/01 00:43:29.83 server  SQL Server's default sort order is:
00:00000:00001:2006/06/01 00:43:29.83 server          'altnocsp_cp850' (ID = 46)
00:00000:00001:2006/06/01 00:43:29.83 server  on top of default character set:
00:00000:00001:2006/06/01 00:43:29.83 server          'cp850' (ID = 2).
01:00000:00000:2006/06/01 00:43:29.83 kernel  Network and device connection limit is 99992.
01:00000:00000:2006/06/01 00:43:29.83 kernel  engine 1, os pid 896  online
02:00000:00000:2006/06/01 00:43:29.83 kernel  Network and device connection limit is 99992.
02:00000:00000:2006/06/01 00:43:29.83 kernel  engine 2, os pid 912  online
03:00000:00000:2006/06/01 00:43:29.83 kernel  Network and device connection limit is 99992.
03:00000:00000:2006/06/01 00:43:29.83 kernel  engine 3, os pid 928  online
02:00000:00012:2006/06/01 00:43:29.85 server  Error: 7214, Severity: 11, State: 1
02:00000:00012:2006/06/01 00:43:29.85 server  No site name received in server login packet.  Server login rejected.
03:00000:00001:2006/06/01 00:43:29.87 server  Error: 7221, Severity: 14, State: 1
03:00000:00001:2006/06/01 00:43:29.87 server  Login to site 'SYB_XP' failed.
03:00000:00000:2006/06/01 04:39:41.48 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
03:00000:00000:2006/06/01 04:39:41.54 kernel  pc: 0x20370C53 (can't find module)(0x00000000, 0x00000000, 0x00000000, 0x00000000)
03:00000:00000:2006/06/01 04:39:41.54 kernel  end of stack trace, kernel service process: kpid 1638425
03:00000:00000:2006/06/01 04:39:41.54 kernel  engine 3, os pid 928  exited
03:00000:00000:2006/06/01 04:39:41.54 kernel  Could not replace infected engine.
03:00000:00000:2006/06/01 04:39:41.54 kernel  ueshutdown: exiting
03:00000:00000:2006/06/01 04:39:41.54 kernel  Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.

echoaix

sybase配了几个cpu？
select @@servername
sp_addserver @@servername,local
用扩展存储过程，xpserver配好没有？
打补丁
重点怀疑还是引擎的问题。

RS9000

03:00000:00000:2006/06/01 04:39:41.48 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
03:00000:00000:2006/06/01 04:39:41.54 kernel  pc: 0x20370C53 (can't find module)(0x00000000, 0x00000000, 0x00000000, 0x00000000)
03:00000:00000:2006/06/01 04:39:41.54 kernel  end of stack trace, kernel service process: kpid 1638425
03:00000:00000:2006/06/01 04:39:41.54 kernel  engine 3, os pid 928  exited
03:00000:00000:2006/06/01 04:39:41.54 kernel  Could not replace infected engine.
03:00000:00000:2006/06/01 04:39:41.54 kernel  ueshutdown: exiting

有没有硬件问题呀？检查检查硬件。不太清楚是不是SYBASE的BUG，如果可能升到最新的补丁看看。

1017of

03:00000:00001:2006/06/01 00:43:29.87 server  Login to site 'SYB_XP' failed.
03:00000:00000:2006/06/01 04:39:41.48 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
03:00000:00000:2006/06/01 04:39:41.54 kernel  pc: 0x20370C53 (can't find module)(0x00000000, 0x00000000, 0x00000000, 0x00000000)
03:00000:00000:2006/06/01 04:39:41.54 kernel  end of stack trace, kernel service process: kpid 1638425
03:00000:00000:2006/06/01 04:39:41.54 kernel  engine 3, os pid 928  exited
03:00000:00000:2006/06/01 04:39:41.54 kernel  Could not replace infected engine.
03:00000:00000:2006/06/01 04:39:41.54 kernel  ueshutdown: exiting
-----------------------------------------------------------------------------------------------------------------
it seems to be similar between two events,though they are a bit of difference from each other.
is there some mechanism to monitor or control server to make it work well or shutdown automatically?

echoaix

SQL Server system exception (0xc0000005) generated by a storage access violation.
这个应该是bug
pc: 0x20370C53 (can't find module)(0x00000000, 0x00000000, 0x00000000, 0x00000000)
应该是invalid column name
03:00000:00000:2006/06/01 04:39:41.54 kernel  Could not replace infected engine.
好象是bug CR # 205929
建议打最新补丁。

dyhlx

我也怀疑是engie的问题，我现在已经修改engie配置，改为默认配置，目前运行正常；

是sybase的bug？？这个补丁有相关说明不？请各位大侠指点！！！

echoaix

注意看看以上提示和错误还有否？最好还是打上补丁