請(qǐng)教怎么數(shù)據(jù)庫(kù)一會(huì)兒就出錯(cuò)了？

sccjh

我在AS3上裝12.5.3，每次啟動(dòng)幾分鐘后就報(bào)錯(cuò)了：
00:00000:00000:2005/09/08 17:37:49.90 kernel  Address 0x0x0000000e (), siginfo (code, address) = (2, 0x0x400afcf0)
00:00000:00000:2005/09/08 17:37:49.90 kernel  current process (0x40a0bcc0) infected with 11
00:00000:00000:2005/09/08 17:37:49.90 kernel  Address 0x0x0000000e (), siginfo (code, address) = (2, 0x0x400afcf0)
ASE-12_5/install/RUN_CENTER: line 16:  3864 段錯(cuò)誤                  /opt/sybase/ASE-12_5/bin/dataserver -d/opt/sybase/data/master.dat -e/opt/sybase/ASE-12_5/install/CENTER.log -c/opt/sybase/ASE-12_5/CENTER.cfg -M/opt/sybase/ASE-12_5 -sCENTER

請(qǐng)教請(qǐng)教請(qǐng)教，謝謝謝謝謝謝�。。�！

1017of

多貼點(diǎn)errorlog吧，另請(qǐng)貼出詳細(xì)sybase版本

sccjh

謝謝大天使，詳細(xì)版本是：se1253esd1xe
也就是這兒下的免費(fèi)版本：
http://www.yesky.com/422/1928422.shtml
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
00:00000:00000:2005/09/08 17:41:51.85 kernel  Adaptive Server Enterprise Express Edition (Limits: 1 Engine, 2GB Memory, 5GB Disk space).
00:00000:00000:2005/09/08 17:41:51.85 kernel  Using config area from primary master device.
00:00000:00000:2005/09/08 17:41:51.87 kernel  os_create_keyfile: Removed old segment /opt/sybase/ASE-12_5/CENTER.krg
00:00000:00000:2005/09/08 17:41:51.87 kernel  Internal run-time model set for Linux  - Native
00:00000:00000:2005/09/08 17:41:51.87 kernel  Using 1024 file descriptors.
00:00000:00000:2005/09/08 17:41:51.87 kernel  Adaptive Server Enterprise/12.5.3/EBF 12406 ESD#1/P/Linux Intel/Enterprise Linux/ase1253/1900/32-bit/OPT-Express-Edition/Mon Jan 24 22:11:33 2005
00:00000:00000:2005/09/08 17:41:51.87 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2005/09/08 17:41:51.87 kernel  Copyright 1987, 2005
00:00000:00000:2005/09/08 17:41:51.87 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2005/09/08 17:41:51.87 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2005/09/08 17:41:51.87 kernel
00:00000:00000:2005/09/08 17:41:51.87 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2005/09/08 17:41:51.87 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2005/09/08 17:41:51.87 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2005/09/08 17:41:51.87 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2005/09/08 17:41:51.87 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2005/09/08 17:41:51.87 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2005/09/08 17:41:51.87 kernel  Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
00:00000:00000:2005/09/08 17:41:51.87 kernel  ASE booted on Linux release 2.4.20-8 version #1 Thu Mar 13 17:54:28 EST 2003.
00:00000:00000:2005/09/08 17:41:51.88 kernel  Using '/opt/sybase/ASE-12_5/CENTER.cfg' for configuration information.
00:00000:00000:2005/09/08 17:41:51.88 kernel  Logging ASE messages in file '/opt/sybase/ASE-12_5/install/CENTER.log'.
00:00000:00000:2005/09/08 17:41:51.92 kernel  Platform TCP network is forced to IPv4-only.
00:00000:00000:2005/09/08 17:41:51.92 kernel  SQL Server booted with TCP_NODELAY enabled.
00:00000:00000:2005/09/08 17:41:51.93 kernel  SSL Plus v3.1.10 security modules loaded successfully.
00:00000:00000:2005/09/08 17:41:51.93 kernel  Network and device connection limit is 1014.
00:00000:00000:2005/09/08 17:41:52.03 server  Number of blocks left for proc headers: 3232.
00:00000:00000:2005/09/08 17:41:52.03 server  Proc header memory allocated 1616 pages for each per engine cache
00:00000:00000:2005/09/08 17:41:52.06 server  Size of the 2K memory pool: 8192 Kb
00:00000:00000:2005/09/08 17:41:52.06 server  Memory allocated for the default data cache cachelet 1: 8192 Kb
00:00000:00000:2005/09/08 17:41:52.06 kernel  Enabling (RT) Posix asynchronous disk I/O strategy.
00:00000:00000:2005/09/08 17:41:52.06 kernel  Extended cache size '0' is invalid. Provide the appropriate size value.
00:00000:00000:2005/09/08 17:41:52.06 kernel  Initializing virtual device 0, '/opt/sybase/data/master.dat' with dsync 'on'.
00:00000:00000:2005/09/08 17:41:52.06 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2005/09/08 17:41:52.06 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2005/09/08 17:41:52.06 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:2005/09/08 17:41:52.06 kernel  Unix interval timer enabled for sysclk interrupts.
00:00000:00000:2005/09/08 17:41:52.07 kernel  engine 0, os pid 3916  online
00:00000:00000:2005/09/08 17:41:52.07 server  No active traceflags
00:00000:00001:2005/09/08 17:41:52.07 kernel  libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5.3/EBF 12339 ESD#1/P/Linux Intel/Enterprise Linux/ase1253/1900/32-bit/OPT/Mon Jan 24 21:41:32 2005'.
00:00000:00001:2005/09/08 17:41:52.07 kernel  libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5.1/P-EBF12107 ESD #5/DRV.12.5.1.2/Linux Intel/Linux 2.4.18-18.7.xsmp i686/BUILD1251-038/OPT/Thu Aug 19 01:53:15 2004'
00:00000:00001:2005/09/08 17:41:52.07 server  Opening Master Database ...
00:00000:00001:2005/09/08 17:41:57.22 server  Loading SQL Server's default sort order and character set
00:00000:00001:2005/09/08 17:41:57.62 server  Loaded default Unilib conversion handle.
00:00000:00001:2005/09/08 17:41:57.82 server  Recovering database 'master'.
00:00000:00001:2005/09/08 17:41:58.02 server  Started estimating recovery log boundaries for database 'master'.
00:00000:00001:2005/09/08 17:41:58.12 server  Database 'master', checkpoint=(2505, 13), first=(2505, 13), last=(2505, 13).
00:00000:00001:2005/09/08 17:41:58.12 server  Completed estimating recovery log boundaries for database 'master'.
00:00000:00001:2005/09/08 17:41:58.12 server  Started ANALYSIS pass for database 'master'.
00:00000:00001:2005/09/08 17:41:58.12 server  Completed ANALYSIS pass for database 'master'.
00:00000:00001:2005/09/08 17:41:58.12 server  Started REDO pass for database 'master'. The total number of log records to process is 1.
00:00000:00001:2005/09/08 17:41:58.22 server  Completed REDO pass for database 'master'.
00:00000:00001:2005/09/08 17:41:58.22 server  Recovery of database 'master' will undo incomplete nested top actions.
00:00000:00001:2005/09/08 17:41:58.22 server  Started recovery checkpoint for database 'master'.
00:00000:00001:2005/09/08 17:41:58.92 server  Completed recovery checkpoint for database 'master'.
00:00000:00001:2005/09/08 17:41:59.32 server  Started filling free space info for database 'master'.
00:00000:00001:2005/09/08 17:41:59.52 server  Completed filling free space info for database 'master'.
00:00000:00001:2005/09/08 17:41:59.92 server  Started cleaning up the default data cache for database 'master'.
00:00000:00001:2005/09/08 17:41:59.92 server  Completed cleaning up the default data cache for database 'master'.
00:00000:00001:2005/09/08 17:42:00.52 server  Checking external objects.
00:00000:00001:2005/09/08 17:42:01.82 server  Database 'master' is now online.
00:00000:00001:2005/09/08 17:42:01.92 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2005/09/08 17:42:02.02 server  Warning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2005/09/08 17:42:02.21 server  server name is 'CENTER'
00:00000:00001:2005/09/08 17:42:02.72 server  Activating disk 'sysprocsdev' of size 122880 KB.
00:00000:00001:2005/09/08 17:42:02.72 kernel  Initializing virtual device 1, '/opt/sybase/data/sysprocs.dat' with dsync 'on'.
00:00000:00001:2005/09/08 17:42:02.72 kernel  Virtual device 1 started using asynchronous i/o.
00:00000:00001:2005/09/08 17:42:07.95 server  Recovering database 'sybsystemdb'.
00:00000:00001:2005/09/08 17:42:07.95 server  Started estimating recovery log boundaries for database 'sybsystemdb'.
00:00000:00001:2005/09/08 17:42:08.05 server  Database 'sybsystemdb', checkpoint=(645, 11), first=(645, 11), last=(645, 16).
00:00000:00001:2005/09/08 17:42:08.05 server  Completed estimating recovery log boundaries for database 'sybsystemdb'.
00:00000:00001:2005/09/08 17:42:08.05 server  Started ANALYSIS pass for database 'sybsystemdb'.
00:00000:00001:2005/09/08 17:42:08.05 server  Completed ANALYSIS pass for database 'sybsystemdb'.
00:00000:00001:2005/09/08 17:42:08.05 server  Started REDO pass for database 'sybsystemdb'. The total number of log records to process is 6.
00:00000:00001:2005/09/08 17:42:08.15 server  Redo pass of recovery has processed 1 committed and 1 aborted transactions.
00:00000:00001:2005/09/08 17:42:08.15 server  Completed REDO pass for database 'sybsystemdb'.
00:00000:00001:2005/09/08 17:42:08.25 server  Recovery of database 'sybsystemdb' will undo incomplete nested top actions.
00:00000:00001:2005/09/08 17:42:08.25 server  Started recovery checkpoint for database 'sybsystemdb'.
00:00000:00001:2005/09/08 17:42:09.24 server  Completed recovery checkpoint for database 'sybsystemdb'.
00:00000:00001:2005/09/08 17:42:09.64 server  Started filling free space info for database 'sybsystemdb'.
00:00000:00001:2005/09/08 17:42:09.85 server  Completed filling free space info for database 'sybsystemdb'.
00:00000:00001:2005/09/08 17:42:10.05 server  Started cleaning up the default data cache for database 'sybsystemdb'.
00:00000:00001:2005/09/08 17:42:10.05 server  Completed cleaning up the default data cache for database 'sybsystemdb'.
00:00000:00001:2005/09/08 17:42:10.14 server  Boot Count: 7
00:00000:00001:2005/09/08 17:42:11.44 server  Checking external objects.
00:00000:00001:2005/09/08 17:42:11.85 server  The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2005/09/08 17:42:12.54 server  Database 'sybsystemdb' is now online.
00:00000:00001:2005/09/08 17:42:14.95 server  Recovering database 'model'.
00:00000:00001:2005/09/08 17:42:14.95 server  Started estimating recovery log boundaries for database 'model'.
00:00000:00001:2005/09/08 17:42:15.05 server  Database 'model', checkpoint=(623, , first=(623, , last=(623, 11).
00:00000:00001:2005/09/08 17:42:15.05 server  Completed estimating recovery log boundaries for database 'model'.
00:00000:00001:2005/09/08 17:42:15.05 server  Started ANALYSIS pass for database 'model'.
00:00000:00001:2005/09/08 17:42:15.05 server  Completed ANALYSIS pass for database 'model'.
00:00000:00001:2005/09/08 17:42:15.05 server  Started REDO pass for database 'model'. The total number of log records to process is 4.
00:00000:00001:2005/09/08 17:42:15.15 server  Redo pass of recovery has processed 1 committed and 0 aborted transactions.
00:00000:00001:2005/09/08 17:42:15.15 server  Completed REDO pass for database 'model'.
00:00000:00001:2005/09/08 17:42:15.25 server  Recovery of database 'model' will undo incomplete nested top actions.
00:00000:00001:2005/09/08 17:42:15.25 server  Started recovery checkpoint for database 'model'.
00:00000:00001:2005/09/08 17:42:16.24 server  Completed recovery checkpoint for database 'model'.
00:00000:00001:2005/09/08 17:42:16.64 server  Started filling free space info for database 'model'.
00:00000:00001:2005/09/08 17:42:16.85 server  Completed filling free space info for database 'model'.
00:00000:00001:2005/09/08 17:42:17.05 server  Started cleaning up the default data cache for database 'model'.
00:00000:00001:2005/09/08 17:42:17.05 server  Completed cleaning up the default data cache for database 'model'.
00:00000:00001:2005/09/08 17:42:17.24 server  Checking external objects.
00:00000:00001:2005/09/08 17:42:17.65 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2005/09/08 17:42:18.34 server  Database 'model' is now online.
00:00000:00001:2005/09/08 17:42:18.35 server  The logical pagesize of the server is 2 Kb.
00:00000:00001:2005/09/08 17:42:18.35 server  0 dump conditions detected at boot time
00:00000:00001:2005/09/08 17:42:18.35 server  Resident Node id: c212ce648def
00:00000:00001:2005/09/08 17:42:18.45 server  Transaction coordinator initialized.
00:00000:00001:2005/09/08 17:42:18.45 server  Clearing temp db
00:00000:00001:2005/09/08 17:42:29.68 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2005/09/08 17:42:32.41 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2005/09/08 17:42:34.44 server  Database 'tempdb' is now online.
00:00000:00001:2005/09/08 17:42:39.65 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2005/09/08 17:42:39.65 server  Started estimating recovery log boundaries for database 'sybsystemprocs'.
00:00000:00001:2005/09/08 17:42:39.75 server  Database 'sybsystemprocs', checkpoint=(31277, 22), first=(31277, 22), last=(31277, 22).
00:00000:00001:2005/09/08 17:42:39.75 server  Completed estimating recovery log boundaries for database 'sybsystemprocs'.
00:00000:00001:2005/09/08 17:42:39.75 server  Started ANALYSIS pass for database 'sybsystemprocs'.
00:00000:00001:2005/09/08 17:42:39.75 server  Completed ANALYSIS pass for database 'sybsystemprocs'.
00:00000:00001:2005/09/08 17:42:39.75 server  Started REDO pass for database 'sybsystemprocs'. The total number of log records to process is 1.
00:00000:00001:2005/09/08 17:42:39.84 server  Completed REDO pass for database 'sybsystemprocs'.
00:00000:00001:2005/09/08 17:42:39.85 server  Recovery of database 'sybsystemprocs' will undo incomplete nested top actions.
00:00000:00001:2005/09/08 17:42:39.85 server  Started recovery checkpoint for database 'sybsystemprocs'.
00:00000:00001:2005/09/08 17:42:40.44 server  Completed recovery checkpoint for database 'sybsystemprocs'.
00:00000:00001:2005/09/08 17:42:40.84 server  Started filling free space info for database 'sybsystemprocs'.
00:00000:00001:2005/09/08 17:42:41.05 server  Completed filling free space info for database 'sybsystemprocs'.
00:00000:00001:2005/09/08 17:42:41.25 server  Started cleaning up the default data cache for database 'sybsystemprocs'.
00:00000:00001:2005/09/08 17:42:41.25 server  Completed cleaning up the default data cache for database 'sybsystemprocs'.
00:00000:00001:2005/09/08 17:42:41.44 server  Checking external objects.
00:00000:00001:2005/09/08 17:42:42.05 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2005/09/08 17:42:47.40 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2005/09/08 17:42:48.69 server  Database 'sybsystemprocs' is now online.
00:00000:00001:2005/09/08 17:42:52.72 server  Database 'model' is now online.
00:00000:00001:2005/09/08 17:42:56.75 server  Database 'sybsystemdb' is now online.
00:00000:00001:2005/09/08 17:43:00.76 server  Database 'tempdb' is now online.
00:00000:00008:2005/09/08 17:43:00.76 kernel  network name center, interface IPv4, address 127.0.0.1, type tcp, port 5000, filter NONE
00:00000:00001:2005/09/08 17:43:02.16 server  Recovery complete.
00:00000:00001:2005/09/08 17:43:02.16 server  SQL Server's default unicode sort order is 'binary'.
00:00000:00001:2005/09/08 17:43:02.46 server  SQL Server's default sort order is:
00:00000:00001:2005/09/08 17:43:02.46 server    'bin_iso_1' (ID = 50)
00:00000:00001:2005/09/08 17:43:02.46 server  on top of default character set:
00:00000:00001:2005/09/08 17:43:02.46 server    'iso_1' (ID = 1).
00:00000:00001:2005/09/08 17:43:02.46 server  Master device size: 30 megabytes, or 15360 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00000:2005/09/08 17:45:06.85 kernel  current process (0x40a0bcc0) infected with 11
00:00000:00000:2005/09/08 17:45:06.86 kernel  Address 0x0x0000000e (), siginfo (code, address) = (2, 0x0x400afcf0)
00:00000:00000:2005/09/08 17:45:06.86 kernel  current process (0x40a0bcc0) infected with 11
00:00000:00000:2005/09/08 17:45:06.86 kernel  Address 0x0x0000000e (), siginfo (code, address) = (2, 0x0x400afcf0)
00:00000:00000:2005/09/08 17:45:06.86 kernel  current process (0x40a0bcc0) infected with 11
。。。。。。。。下面的都一樣了

1017of

感覺(jué)是補(bǔ)丁的問(wèn)題

hehuomumu

是否是在對(duì)數(shù)據(jù)庫(kù)進(jìn)行優(yōu)化后出現(xiàn)的這種情況？如果這樣，可以sybase目錄下面的sybaseserver.001,sybaseserver.002...的上次的配置文件替換現(xiàn)有配置文件。然后，重啟sybase 服務(wù)，看sybase是否啟動(dòng)正常。

sccjh

是剛裝好了數(shù)據(jù)庫(kù)，第一次運(yùn)行就開(kāi)始是這樣了

flybean

貼出來(lái)的日志表明顯然不是第一次。

00:00000:00001:2005/09/08 17:42:10.14 server  Boot Count: 7

sccjh

是的，反復(fù)起了好多次，都是一會(huì)兒就報(bào)錯(cuò)了，showserver也看不到了

flybean

感覺(jué)是安裝包的問(wèn)題，安裝ESD2試試

sccjh

請(qǐng)問(wèn)ESD2可以免費(fèi)下么？