求救,sybase core dump的问题，需要调整哪些参数

rudolfyan

Hi，
我需要调整了一些参数，解决coredown的问题

我查了资料，说是sybase bug，也可以调整 cache, stack size,io pool,有谁帮我一下呢。
log如下



00:00000:00000:2005/06/30 15:29:03.76 kernel  Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2005/06/30 15:29:03.88 kernel  Using config area from primary master device.
00:00000:00000:2005/06/30 15:29:03.93 kernel  Using 2000 file descriptors.
00:00000:00000:2005/06/30 15:29:03.95 kernel  Adaptive Server Enterprise/12.5/SWR 9611 GA/P/RS6000/AIX 4.3.3/main/1647/32-bit/FBO/Sat Jun  2 00:41:53 2001
00:00000:00000:2005/06/30 15:29:03.95 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2005/06/30 15:29:03.95 kernel  Copyright 1987, 2001
00:00000:00000:2005/06/30 15:29:03.95 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2005/06/30 15:29:03.95 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2005/06/30 15:29:03.95 kernel  
00:00000:00000:2005/06/30 15:29:03.95 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2005/06/30 15:29:03.95 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2005/06/30 15:29:03.95 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2005/06/30 15:29:03.95 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2005/06/30 15:29:03.95 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2005/06/30 15:29:03.95 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2005/06/30 15:29:03.95 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2005/06/30 15:29:03.95 kernel  Using '/sybase/ASE-12_5/SYBASE.cfg' for configuration information.
00:00000:00000:2005/06/30 15:29:03.95 kernel  Logging ASE messages in file '/sybase/ASE-12_5/install/SYBASE.log'.
00:00000:00000:2005/06/30 15:29:03.99 kernel  kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2005/06/30 15:29:04.00 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2005/06/30 15:29:04.01 kernel  SSL Plus security modules loaded successfully.
00:00000:00000:2005/06/30 15:29:04.01 kernel  Network and device connection limit is 1990.
00:00000:00000:2005/06/30 15:29:04.21 server  Number of blocks left for proc headers: 10200.
00:00000:00000:2005/06/30 15:29:04.22 server  Proc header memory allocated 5100 pages for each per engine cache
00:00000:00000:2005/06/30 15:29:04.24 server  Memory allocated for the default data cache cachelet 1: 8192 Kb
00:00000:00000:2005/06/30 15:29:04.24 server  Size of the 2K memory pool: 8192 Kb
00:00000:00000:2005/06/30 15:29:04.24 kernel  Initializing virtual device 0, '/dev/rmasterdblv_01' with dsync 'on'.
00:00000:00000:2005/06/30 15:29:04.24 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2005/06/30 15:29:04.24 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2005/06/30 15:29:04.25 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/06/30 15:29:04.25 kernel  engine 0, os pid 28818  online
00:00000:00000:2005/06/30 15:29:04.25 server  No active traceflags
00:00000:00001:2005/06/30 15:29:04.27 kernel  libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5/SWR 9611 GA/P/RS6000/AIX 4.3.3/main/1647/32-bit/INST/Fri Jun  1 18:26:08 2001'.
00:00000:00001:2005/06/30 15:29:04.27 kernel  libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5/P/rs6000/AIX 4.3.3/1/OPT/Fri Mar 23 19:32:53 2001'
00:00000:00001:2005/06/30 15:29:04.27 server  Opening Master Database ...
00:00000:00001:2005/06/30 15:29:04.41 server  Loading SQL Server's default sort order and character set
00:00000:00001:2005/06/30 15:29:04.41 server  Loaded default Unilib conversion handle.
00:00000:00001:2005/06/30 15:29:04.43 server  Recovering database 'master'.
00:00000:00001:2005/06/30 15:29:04.46 server  Redo pass of recovery has processed 2 committed and 0 aborted transactions.
00:00000:00001:2005/06/30 15:29:04.58 server  Checking external objects.
00:00000:00001:2005/06/30 15:29:04.60 server  Database 'master' is now online.
00:00000:00001:2005/06/30 15:29:04.60 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2005/06/30 15:29:04.60 server  Warning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2005/06/30 15:29:04.62 server  server name is 'SYBASE'
00:00000:00001:2005/06/30 15:29:04.64 server  Activating disk 'SAFEPRDDATA'.
00:00000:00001:2005/06/30 15:29:04.64 kernel  Initializing virtual device 4, '/dev/rsafeprddatalv01' with dsync 'on'.
00:00000:00001:2005/06/30 15:29:04.64 kernel  Virtual device 4 started using asynchronous i/o.
00:00000:00001:2005/06/30 15:29:04.64 server  Activating disk 'SAFEPRDLOG'.
00:00000:00001:2005/06/30 15:29:04.64 kernel  Initializing virtual device 5, '/dev/rsafeprdloglv01' with dsync 'on'.
00:00000:00001:2005/06/30 15:29:04.64 kernel  Virtual device 5 started using asynchronous i/o.
00:00000:00001:2005/06/30 15:29:04.64 server  Activating disk 'SAFEUATDATA'.
00:00000:00001:2005/06/30 15:29:04.64 kernel  Initializing virtual device 6, '/dev/rsafeuatdatalv01' with dsync 'on'.
00:00000:00001:2005/06/30 15:29:04.64 kernel  Virtual device 6 started using asynchronous i/o.
00:00000:00001:2005/06/30 15:29:04.64 server  Activating disk 'SAFEUATLOG'.
00:00000:00001:2005/06/30 15:29:04.64 kernel  Initializing virtual device 7, '/dev/rsafeuatloglv01' with dsync 'on'.
00:00000:00001:2005/06/30 15:29:04.64 kernel  Virtual device 7 started using asynchronous i/o.
00:00000:00001:2005/06/30 15:29:04.64 server  Activating disk 'safesit'.
00:00000:00001:2005/06/30 15:29:04.64 kernel  Initializing virtual device 12, '/sybase/data/safesit.dat' with dsync 'off'.
00:00000:00001:2005/06/30 15:29:04.64 kernel  Virtual device 12 started using asynchronous i/o.
00:00000:00001:2005/06/30 15:29:04.64 server  Activating disk 'safesit_log'.
00:00000:00001:2005/06/30 15:29:04.64 kernel  Initializing virtual device 13, '/sybase/data/safesit.log' with dsync 'off'.
00:00000:00001:2005/06/30 15:29:04.64 kernel  Virtual device 13 started using asynchronous i/o.
00:00000:00001:2005/06/30 15:29:04.64 server  Activating disk 'sybtempdbdev'.
00:00000:00001:2005/06/30 15:29:04.64 kernel  Initializing virtual device 3, '/dev/rsybtmpdblv_01' with dsync 'on'.
00:00000:00001:2005/06/30 15:29:04.64 kernel  Virtual device 3 started using asynchronous i/o.
00:00000:00001:2005/06/30 15:29:04.64 server  Activating disk 'sysprocsdev'.
00:00000:00001:2005/06/30 15:29:04.64 kernel  Initializing virtual device 1, '/dev/rsysprocsdblv_01' with dsync 'on'.
00:00000:00001:2005/06/30 15:29:04.64 kernel  Virtual device 1 started using asynchronous i/o.
00:00000:00001:2005/06/30 15:29:04.64 server  Activating disk 'systemdbdev'.
00:00000:00001:2005/06/30 15:29:04.64 kernel  Initializing virtual device 2, '/dev/rsystemdblv_01' with dsync 'on'.
00:00000:00001:2005/06/30 15:29:04.64 kernel  Virtual device 2 started using asynchronous i/o.
00:00000:00001:2005/06/30 15:29:04.74 server  Recovering database 'sybsystemdb'.
00:00000:00001:2005/06/30 15:29:05.30 server  Boot Count: 57
00:00000:00001:2005/06/30 15:29:05.32 server  Checking external objects.
00:00000:00001:2005/06/30 15:29:05.33 server  The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2005/06/30 15:29:05.34 server  Database 'sybsystemdb' is now online.
00:00000:00001:2005/06/30 15:29:05.41 server  Recovering database 'model'.
00:00000:00001:2005/06/30 15:29:05.44 server  Checking external objects.
00:00000:00001:2005/06/30 15:29:05.45 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2005/06/30 15:29:05.46 server  Database 'model' is now online.
00:00000:00001:2005/06/30 15:29:05.46 server  The logical pagesize of the server is 2 Kb.
00:00000:00001:2005/06/30 15:29:05.46 server  0 dump conditions detected at boot time
00:00000:00001:2005/06/30 15:29:05.46 server  Resident Node id: f5667c9be031
00:00000:00001:2005/06/30 15:29:05.46 server  Transaction coordinator initialized.
00:00000:00001:2005/06/30 15:29:05.46 server  Clearing temp db
00:00000:00001:2005/06/30 15:29:06.46 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2005/06/30 15:29:06.46 server  Database 'tempdb' is now online.
00:00000:00001:2005/06/30 15:29:06.52 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2005/06/30 15:29:06.96 server  Checking external objects.
00:00000:00001:2005/06/30 15:29:06.97 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2005/06/30 15:29:06.99 server  Database 'sybsystemprocs' is now online.
00:00000:00002:2005/06/30 15:29:06.99 kernel  network name safe, type ether, port 4100, filter NONE
00:00000:00001:2005/06/30 15:29:07.05 server  Recovering database 'SAFEUAT'.
00:00000:00001:2005/06/30 15:29:07.93 server  Checking external objects.
00:00000:00001:2005/06/30 15:29:07.93 server  The transaction log in the database 'SAFEUAT' will use I/O size of 2 Kb.
00:00000:00001:2005/06/30 15:29:07.95 server  Database 'SAFEUAT' is now online.
00:00000:00001:2005/06/30 15:29:08.01 server  Recovering database 'SAFEPRD'.
00:00000:00001:2005/06/30 15:29:08.89 server  Checking external objects.
00:00000:00001:2005/06/30 15:29:08.89 server  The transaction log in the database 'SAFEPRD' will use I/O size of 2 Kb.
00:00000:00001:2005/06/30 15:29:08.91 server  Database 'SAFEPRD' is now online.
00:00000:00001:2005/06/30 15:29:08.92 server  Error: 926, Severity: 14, State: 1
00:00000:00001:2005/06/30 15:29:08.92 server  Database 'SAFESIT' cannot be opened. An earlier attempt at recovery marked it 'suspect'. Check the SQL Server errorlog for information as to the cause.
00:00000:00001:2005/06/30 15:29:08.95 server  Unable to proceed with the recovery of dbid <6> because of previous errors.  Continuing with the next database.
00:00000:00001:2005/06/30 15:29:08.96 server  Recovery complete.
00:00000:00001:2005/06/30 15:29:08.96 server  SQL Server's default unicode sort order is 'binary'.
00:00000:00001:2005/06/30 15:29:08.96 server  SQL Server's default sort order is:
00:00000:00001:2005/06/30 15:29:08.96 server          'bin_iso_1' (ID = 50)
00:00000:00001:2005/06/30 15:29:08.96 server  on top of default character set:
00:00000:00001:2005/06/30 15:29:08.96 server          'iso_1' (ID = 1).
00:00000:00001:2005/06/30 15:29:08.96 server  Master device size: 120 megabytes, or 61440 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00018:2005/06/30 15:36:45.03 server  WARNING: ***************************
00:00000:00018:2005/06/30 15:36:45.03 server  Attempt by user 1 to dump xact on db tempdb with NO_LOG
00:00000:00018:2005/06/30 15:36:45.05 server  Attempt by user 1 to dump xact on db tempdb with NO_LOG was successful
00:00000:00018:2005/06/30 15:36:45.05 server  WARNING: ***************************
00:00000:00042:2005/06/30 16:53:53.54 kernel  current process (0x200003e) infected with 11
00:00000:00042:2005/06/30 16:53:53.58 kernel  Error at address 0x100022f0 (.aix_get_lock+0x24)
00:00000:00042:2005/06/30 16:53:53.59 kernel  ************************************
00:00000:00042:2005/06/30 16:53:53.59 kernel  SQL causing error : shutdown SYB_BACKUP with nowait

00:00000:00042:2005/06/30 16:53:53.59 kernel  ************************************
00:00000:00042:2005/06/30 16:53:53.60 server  SQL Text: shutdown SYB_BACKUP with nowait
00:00000:00042:2005/06/30 16:53:53.60 kernel  curdb = 1 pstat = 0x10000 lasterror = 0
00:00000:00042:2005/06/30 16:53:53.60 kernel  preverror = 0 transtate = 3
00:00000:00042:2005/06/30 16:53:53.60 kernel  curcmd = 292 program = isql                          
00:00000:00042:2005/06/30 16:53:53.61 kernel  pc: 0x1025e6a4 .pcstkwalk+0x3c()
00:00000:00042:2005/06/30 16:53:53.61 kernel  pc: 0x1025ece8 .ucstkgentrace+0x14c()
00:00000:00042:2005/06/30 16:53:53.61 kernel  pc: 0x1025d93c .ucbacktrace+0x6c()
00:00000:00042:2005/06/30 16:53:53.61 kernel  pc: 0x10213c34 .terminate_process[3]+0x760()
00:00000:00042:2005/06/30 16:53:53.62 kernel  pc: 0x10800338 .kisignal+0xe4()
00:00000:00042:2005/06/30 16:53:53.62 kernel  pc: 0x106bba8c .closeremote+0xb8()
00:00000:00042:2005/06/30 16:53:53.62 kernel  pc: 0x106bba8c .closeremote+0xb8()
00:00000:00042:2005/06/30 16:53:53.62 kernel  pc: 0x10216e2c .clean_process[2]+0xbc()
00:00000:00042:2005/06/30 16:53:53.62 kernel  pc: 0x10217d48 .conn_hdlr_err_cleanup+0x144()
00:00000:00042:2005/06/30 16:53:53.62 kernel  [Handler pc: 0x102143f8 .hdl_backout installed by the following function:-]
00:00000:00042:2005/06/30 16:53:53.62 kernel  [Handler pc: 0x104d1cbc .ut_handle installed by the following function:-]
00:00000:00042:2005/06/30 16:53:53.62 kernel  [Handler pc: 0x104d1cbc .ut_handle installed by the following function:-]
00:00000:00042:2005/06/30 16:53:53.62 kernel  pc: 0x102155dc .conn_hdlr[9]+0x188()
00:00000:00042:2005/06/30 16:53:53.62 kernel  pc: 0x100105d4 .kpcoldstart+0x1c()
00:00000:00042:2005/06/30 16:53:53.62 kernel  end of stack trace, spid 42, kpid 33554494, suid 1
00:00000:00042:2005/06/30 16:53:53.64 kernel  current process (0x200003e) infected with 11
00:00000:00042:2005/06/30 16:53:53.64 kernel  Error at address 0x100022f0 (.aix_get_lock+0x24)
00:00000:00042:2005/06/30 16:53:53.64 kernel  ************************************
00:00000:00042:2005/06/30 16:53:53.64 kernel  pc: 0x1025e6a4 .pcstkwalk+0x3c()
00:00000:00042:2005/06/30 16:53:53.64 kernel  pc: 0x1025ece8 .ucstkgentrace+0x14c()
00:00000:00042:2005/06/30 16:53:53.64 kernel  pc: 0x1025d93c .ucbacktrace+0x6c()
00:00000:00042:2005/06/30 16:53:53.64 kernel  pc: 0x102135d0 .terminate_process[3]+0xfc()
00:00000:00042:2005/06/30 16:53:53.64 kernel  pc: 0x10800338 .kisignal+0xe4()
00:00000:00042:2005/06/30 16:53:53.64 kernel  pc: 0x106bba8c .closeremote+0xb8()
00:00000:00042:2005/06/30 16:53:53.64 kernel  pc: 0x106bba8c .closeremote+0xb8()
00:00000:00042:2005/06/30 16:53:53.64 kernel  pc: 0x10216e2c .clean_process[2]+0xbc()
00:00000:00042:2005/06/30 16:53:53.64 kernel  [Handler pc: 0x10216ef8 .cleanerr installed by the following function:-]
00:00000:00042:2005/06/30 16:53:53.64 kernel  [Handler pc: 0x102143f8 .hdl_backout installed by the following function:-]
00:00000:00042:2005/06/30 16:53:53.65 kernel  pc: 0x10128e10 .kill_proc+0x158()
00:00000:00042:2005/06/30 16:53:53.65 kernel  pc: 0x10112a38 .terminate_process[1]+0x304()
00:00000:00042:2005/06/30 16:53:53.65 kernel  pc: 0x10800338 .kisignal+0xe4()
00:00000:00042:2005/06/30 16:53:53.65 kernel  pc: 0x106bba8c .closeremote+0xb8()
00:00000:00042:2005/06/30 16:53:53.65 kernel  pc: 0x106bba8c .closeremote+0xb8()
00:00000:00042:2005/06/30 16:53:53.65 kernel  pc: 0x10216e2c .clean_process[2]+0xbc()
00:00000:00042:2005/06/30 16:53:53.65 kernel  pc: 0x10217d48 .conn_hdlr_err_cleanup+0x144()
00:00000:00042:2005/06/30 16:53:53.65 kernel  [Handler pc: 0x102143f8 .hdl_backout installed by the following function:-]
00:00000:00042:2005/06/30 16:53:53.65 kernel  [Handler pc: 0x104d1cbc .ut_handle installed by the following function:-]
00:00000:00042:2005/06/30 16:53:53.65 kernel  [Handler pc: 0x104d1cbc .ut_handle installed by the following function:-]
00:00000:00042:2005/06/30 16:53:53.65 kernel  pc: 0x102155dc .conn_hdlr[9]+0x188()
00:00000:00042:2005/06/30 16:53:53.65 kernel  pc: 0x100105d4 .kpcoldstart+0x1c()
00:00000:00042:2005/06/30 16:53:53.65 kernel  end of stack trace, spid 42, kpid 33554494, suid 1
00:00000:00036:2005/06/30 17:33:02.53 server  Shutdown with nowait detected - SQL Server process level execution bindings will be cleared on startup.
00:00000:00036:2005/06/30 17:33:02.53 server  SQL Server shutdown by request.
00:00000:00036:2005/06/30 17:33:02.53 kernel  ueshutdown: exiting
00:00000:00000:2005/06/30 17:35:17.16 kernel  Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2005/06/30 17:35:17.16 kernel  Using config area from primary master device.
00:00000:00000:2005/06/30 17:35:17.18 kernel  Using 2000 file descriptors.
00:00000:00000:2005/06/30 17:35:17.18 kernel  Adaptive Server Enterprise/12.5/SWR 9611 GA/P/RS6000/AIX 4.3.3/main/1647/32-bit/FBO/Sat Jun  2 00:41:53 2001
00:00000:00000:2005/06/30 17:35:17.18 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2005/06/30 17:35:17.18 kernel  Copyright 1987, 2001
00:00000:00000:2005/06/30 17:35:17.18 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2005/06/30 17:35:17.18 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2005/06/30 17:35:17.18 kernel  
00:00000:00000:2005/06/30 17:35:17.18 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2005/06/30 17:35:17.18 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2005/06/30 17:35:17.18 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2005/06/30 17:35:17.18 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2005/06/30 17:35:17.18 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2005/06/30 17:35:17.19 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2005/06/30 17:35:17.19 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2005/06/30 17:35:17.19 kernel  Using '/sybase/ASE-12_5/SYBASE.cfg' for configuration information.
00:00000:00000:2005/06/30 17:35:17.19 kernel  Logging ASE messages in file '/sybase/ASE-12_5/install/SYBASE.log'.
00:00000:00000:2005/06/30 17:35:17.20 kernel  kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2005/06/30 17:35:17.20 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2005/06/30 17:35:17.20 kernel  SSL Plus security modules loaded successfully.
00:00000:00000:2005/06/30 17:35:17.20 kernel  Network and device connection limit is 1990.
00:00000:00000:2005/06/30 17:35:17.37 server  Number of blocks left for proc headers: 10200.

[ 本帖最后由 rudolfyan 于 2007-1-17 13:45 编辑 ]

rudolfyan

00:00000:00001:2005/06/30 15:29:08.96 server  SQL Server's default unicode sort order is 'binary'.
00:00000:00001:2005/06/30 15:29:08.96 server  SQL Server's default sort order is:
00:00000:00001:2005/06/30 15:29:08.96 server          'bin_iso_1' (ID = 50)
00:00000:00001:2005/06/30 15:29:08.96 server  on top of default character set:
00:00000:00001:2005/06/30 15:29:08.96 server          'iso_1' (ID = 1).
00:00000:00001:2005/06/30 15:29:08.96 server  Master device size: 120 megabytes, or 61440 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00018:2005/06/30 15:36:45.03 server  WARNING: ***************************
00:00000:00018:2005/06/30 15:36:45.03 server  Attempt by user 1 to dump xact on db tempdb with NO_LOG
00:00000:00018:2005/06/30 15:36:45.05 server  Attempt by user 1 to dump xact on db tempdb with NO_LOG was successful
00:00000:00018:2005/06/30 15:36:45.05 server  WARNING: ***************************
00:00000:00042:2005/06/30 16:53:53.54 kernel  current process (0x200003e) infected with 11
00:00000:00042:2005/06/30 16:53:53.58 kernel  Error at address 0x100022f0 (.aix_get_lock+0x24)
00:00000:00042:2005/06/30 16:53:53.59 kernel  ************************************
00:00000:00042:2005/06/30 16:53:53.59 kernel  SQL causing error : shutdown SYB_BACKUP with nowait

00:00000:00042:2005/06/30 16:53:53.59 kernel  ************************************
00:00000:00042:2005/06/30 16:53:53.60 server  SQL Text: shutdown SYB_BACKUP with nowait
00:00000:00042:2005/06/30 16:53:53.60 kernel  curdb = 1 pstat = 0x10000 lasterror = 0
00:00000:00042:2005/06/30 16:53:53.60 kernel  preverror = 0 transtate = 3
00:00000:00042:2005/06/30 16:53:53.60 kernel  curcmd = 292 program = isql                          
00:00000:00042:2005/06/30 16:53:53.61 kernel  pc: 0x1025e6a4 .pcstkwalk+0x3c()
00:00000:00042:2005/06/30 16:53:53.61 kernel  pc: 0x1025ece8 .ucstkgentrace+0x14c()
00:00000:00042:2005/06/30 16:53:53.61 kernel  pc: 0x1025d93c .ucbacktrace+0x6c()
00:00000:00042:2005/06/30 16:53:53.61 kernel  pc: 0x10213c34 .terminate_process[3]+0x760()
00:00000:00042:2005/06/30 16:53:53.62 kernel  pc: 0x10800338 .kisignal+0xe4()
00:00000:00042:2005/06/30 16:53:53.62 kernel  pc: 0x106bba8c .closeremote+0xb8()
00:00000:00042:2005/06/30 16:53:53.62 kernel  pc: 0x106bba8c .closeremote+0xb8()
00:00000:00042:2005/06/30 16:53:53.62 kernel  pc: 0x10216e2c .clean_process[2]+0xbc()
00:00000:00042:2005/06/30 16:53:53.62 kernel  pc: 0x10217d48 .conn_hdlr_err_cleanup+0x144()
00:00000:00042:2005/06/30 16:53:53.62 kernel  [Handler pc: 0x102143f8 .hdl_backout installed by the

rudolfyan

在线等待

chuxu

This is a variation of a problem addressed by CR 419974. It is caused by having a trigger on a table that has been renamed without updating the table name in the trigger and recompiling or dropping and recreating it. (Problems could also occur for other unadjusted dependent objects such as views and stored procedures.)
是这个原因吗？

rudolfyan

we have no trigger

rudolfyan

Hi,根据下面2个连接的说明，似乎需要改stack size, io pool. stack guard size 参数。

http://www.dbtalk.net/sybase-pub ... l-11-a-271284.html;
http://www.sybase.com/detail?id=1032749

目前我机器 AIX 2cpu, 2G,大概我能调整这些参数到最优？

情况非常紧急，等待中。

斑竹还能提供些帮助,谢先了.

rudolfyan

在线等待啊

rudolfyan

是不是要打补丁啊？ 12.5.4 管用吗？

chenfeng825

先打上ebf再说！
Adaptive Server Enterprise/12.5/SWR 9611 GA/P/RS6000/AIX是初始版本，问题可能会比较多！
直接上1254是不行的！

rudolfyan

那么先打12.5.2 ,然后再打12.5.4?

sybase的人说可以从12.5 直接打 12.5.4的，郁闷。

能不能贴点打补丁的步骤给我啊？