最新一sybase頻繁自動(dòng)down掉問題

xietong007

sybase 的版本如下：

Adaptive Server Enterprise/15.0.3/EBF 17157 ESD#3/P/x86_64/Enterprise Linux/ase
         1503/2726/64-bit/FBO/Fri Feb  5 01:42:20 2010                     


查看了sybase的日志，幾乎每次sybase突然自動(dòng)停止都會(huì)打印類似如下信息：


00:00000:00014:2014/03/10 12:19:42.17 server  Checking external objects.
00:00000:00014:2014/03/10 12:19:43.00 server  The transaction log in the database 'zxuma' will use I/O size of 8 Kb.
00:00000:00014:2014/03/10 12:19:43.02 server  Database 'zxuma' is now online.
00:00000:00001:2014/03/10 12:19:43.03 server  Recovery has restored the value of 'local async prefetch limit' for '64K' pool in 'default data cache' from '80' to 'DEFAULT'.
00:00000:00001:2014/03/10 12:19:43.03 server  Recovery has restored the value of 'local async prefetch limit' for '8K' pool in 'default data cache' from '80' to 'DEFAULT'.
00:00000:00001:2014/03/10 12:19:43.09 server  Recovery has restored the original size for '64K' pool and '8K' pool in 'default data cache'.
00:00000:00001:2014/03/10 12:19:43.10 server  Recovery complete.
00:00000:00001:2014/03/10 12:19:43.10 server  ASE's default unicode sort order is 'binary'.
00:00000:00001:2014/03/10 12:19:43.10 server  ASE's default sort order is:
00:00000:00001:2014/03/10 12:19:43.10 server          'bin_utf8' (ID = 50)
00:00000:00001:2014/03/10 12:19:43.10 server  on top of default character set:
00:00000:00001:2014/03/10 12:19:43.10 server          'utf8' (ID = 190).
00:00000:00001:2014/03/10 12:19:43.10 server  Master device size: 4000 megabytes, or 2048000 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00001:2014/03/10 12:19:43.11 kernel  Warning: Cannot set console to nonblocking mode, switching to blocking mode.
02:00000:00338:2014/03/10 12:28:54.70 kernel  Current process (0x208020 infected with signal 11 (SIGSEGV)
02:00000:00338:2014/03/10 12:28:54.70 kernel  Address 0x0x0000000001974324 (kbfalloc+0x254), siginfo (code, address) = (1, 0x0x000000000000001
02:00000:00338:2014/03/10 12:28:54.70 kernel  Spinlocks held by  kpid 34079240
02:00000:00338:2014/03/10 12:28:54.70 kernel  Spinlock DATACHG_SPIN at address 0x0000000142bbc320 owned by 34079240
02:00000:00338:2014/03/10 12:28:54.70 kernel  End of spinlock display.
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x0000000001689015 pcstkwalk+0x30()
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x0000000001688e09 ucstkgentrace+0x199()
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x000000000164143e ucbacktrace+0x40()
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x000000000074fa90 terminate_process+0x1430()
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x0000000001669215 kisignal+0x2f5()
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x0000000001974324 kbfalloc+0x254()
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x0000000000b6fcab ptn__pdes_init_colupdcnt+0x5b()
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x0000000000b6d938 ptn_pdes_install+0x2a8()
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x0000000000b6d5e2 ptn__pdes_install+0xc2()
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x0000000000b6e338 ptn__pdes_init_fromrow+0x28()
02:00000:00338:2014/03/10 12:28:54.70 kernel  [Handler pc: 0x0x00000000013a2697 ptn_handler installed by the following function:-]
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x0000000000b6e106 ptn_pdes_init+0x286()
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x0000000000b64e98 ind__ides_init_fromrow+0x98()
02:00000:00338:2014/03/10 12:28:54.70 kernel  [Handler pc: 0x0x000000000139ec3c sysind_handler installed by the following function:-]
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x0000000000b649bd ind_ides_init+0x79d()
02:00000:00338:2014/03/10 12:28:54.70 kernel  [Handler pc: 0x0x0000000001363690 des__errhdl installed by the following function:-]
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x0000000000b2317c des__fill_common+0x27c()
02:00000:00338:2014/03/10 12:28:54.70 kernel  [Handler pc: 0x0x0000000001363690 des__errhdl installed by the following function:-]
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x0000000000b2013f des(float, int, long, long)+0x2df()
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x00000000018c0162 des_get+0x6c2()
02:00000:00338:2014/03/10 12:28:54.70 kernel  [Handler pc: 0x0x00000000014a8aed hdl_backout_msg installed by the following function:-]
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x0000000000c5fcdb get_name+0xcb()
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x0000000000bdfd6b rvm_bi_check_obj_access+0x7b()
02:00000:00338:2014/03/10 12:28:54.70 kernel  [Handler pc: 0x0x00000000014af943 lookup_handler installed by the following function:-]
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x0000000000c65a8e ptngetrowcount+0x29e()
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x0000000001842629 LeRun+0xb089()
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x0000000001836b85 LeEvals::LeEvRun(LeRunMode, LeRunStack*, short, LeDataRow*, unsigned char*, int*)+0x55()
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x0000000001983bd0 LeRestrictOp::_LeOpNext(ExeCtxt&+0x260()
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x0000000001835ef3 LeEmitSndOp::_LeOpNext(ExeCtxt&+0x123()
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x000000000182f77b LePlanNext+0x1bb()
02:00000:00338:2014/03/10 12:28:54.70 kernel  [Handler pc: 0x0x0000000000ba9700 le_execerr installed by the following function:-]
02:00000:00338:2014/03/10 12:28:54.70 kernel  [Handler pc: 0x0x0000000000bf6d40 aritherr installed by the following function:-]
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x000000000193605a exec_lava+0x20a()
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x0000000000c32633 s_execute+0x6573()
02:00000:00338:2014/03/10 12:28:54.70 kernel  [Handler pc: 0x0x0000000000c5f8a0 hdl_stack installed by the following function:-]
02:00000:00338:2014/03/10 12:28:54.70 kernel  [Handler pc: 0x0x0000000000c3e060 s_handle installed by the following function:-]
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x00000000019619da sequencer+0x69a()
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x00000000007602da tdsrecv_language+0xaa()
02:00000:00338:2014/03/10 12:28:54.70 kernel  [Handler pc: 0x0x0000000000ce7520 ut_handle installed by the following function:-]
02:00000:00338:2014/03/10 12:28:54.70 kernel  pc: 0x0000000001828946 conn_hdlr+0xa86()
02:00000:00338:2014/03/10 12:28:54.70 kernel  end of stack trace, spid 338, kpid 34079240, suid 1
02:00000:00338:2014/03/10 12:28:54.70 kernel  ueshutdown: exiting
00:00000:00000:2014/03/10 12:28:54.70 kernel  SySAM: Checked in license for 1 ASE_CORE (2013.03010/permanent/0C94 6187 B194 DF07).


還請(qǐng)哪位高手幫忙看看是什么原因?qū)е碌膕ybase自動(dòng)停止，萬(wàn)分感謝！

jp_1129

'default data cache'?

mission_g

貌似是一個(gè)軟件問題.
作為一個(gè)臨時(shí)的解決方案,請(qǐng)嘗試

use  zxuma
go

找出其中的table ( select name from sysobjects where type = 'U' )
, 執(zhí)行 update statistics 命令

hope this helps, good luck !

andkylee

stack trace中出現(xiàn)了Spinlock，ase基于保護(hù)機(jī)制自動(dòng)shutdown。
找原廠開case。

Eisen

15.0.3/EBF 17157 ESD#3啊，
這個(gè)version里面有問題，以前我也經(jīng)常碰上這個(gè)錯(cuò)，升級(jí)到ESD4.3后不見了

zhaopingzi

@xietong007
這個(gè)問題解決了嗎

xietong007

zhaopingzi 發(fā)表于 2014-03-19 13:11
@xietong007
這個(gè)問題解決了嗎

這個(gè)問題還未沒有解決，每天數(shù)據(jù)庫(kù)自動(dòng)down掉的時(shí)間都是在4：00-5:00之間，非常奇怪。

02:00000:00001:2014/03/18 07:04:59.14 server  Recovery has restored the original size for '64K' pool and '8K' pool in 'default data cache'.
02:00000:00001:2014/03/18 07:04:59.15 server  Recovery complete.
02:00000:00001:2014/03/18 07:04:59.15 server  ASE's default unicode sort order is 'binary'.
02:00000:00001:2014/03/18 07:04:59.15 server  ASE's default sort order is:
02:00000:00001:2014/03/18 07:04:59.15 server          'bin_utf8' (ID = 50)
02:00000:00001:2014/03/18 07:04:59.15 server  on top of default character set:
02:00000:00001:2014/03/18 07:04:59.15 server          'utf8' (ID = 190).
02:00000:00001:2014/03/18 07:04:59.15 server  Master device size: 4000 megabytes, or 2048000 virtual pages. (A virtual page is 2048 bytes.)
02:00000:00267:2014/03/19 04:02:30.92 kernel  Setting console to nonblocking mode.
02:00000:00267:2014/03/19 04:02:30.92 kernel  Current process (0xd900d9) infected with signal 11 (SIGSEGV)
02:00000:00267:2014/03/19 04:02:30.92 kernel  Address 0x0x0000000001974324 (kbfalloc+0x254), siginfo (code, address) = (1, 0x0x000000000000001
02:00000:00267:2014/03/19 04:02:30.92 kernel  Spinlocks held by  kpid 14221529
02:00000:00267:2014/03/19 04:02:30.92 kernel  Spinlock DATACHG_SPIN at address 0x0000000142bbb320 owned by 14221529
02:00000:00267:2014/03/19 04:02:30.92 kernel  End of spinlock display.
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x0000000001689015 pcstkwalk+0x30()
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x0000000001688e09 ucstkgentrace+0x199()
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x000000000164143e ucbacktrace+0x40()
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x000000000074fa90 terminate_process+0x1430()
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x0000000001669215 kisignal+0x2f5()
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x0000000001974324 kbfalloc+0x254()
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x0000000000b6fcab ptn__pdes_init_colupdcnt+0x5b()
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x0000000000b6d938 ptn_pdes_install+0x2a8()
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x0000000000b6d5e2 ptn__pdes_install+0xc2()
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x0000000000b6e338 ptn__pdes_init_fromrow+0x28()
02:00000:00267:2014/03/19 04:02:30.92 kernel  [Handler pc: 0x0x00000000013a2697 ptn_handler installed by the following function:-]
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x0000000000b6e106 ptn_pdes_init+0x286()
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x0000000000b64e98 ind__ides_init_fromrow+0x98()
02:00000:00267:2014/03/19 04:02:30.92 kernel  [Handler pc: 0x0x000000000139ec3c sysind_handler installed by the following function:-]
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x0000000000b649bd ind_ides_init+0x79d()
02:00000:00267:2014/03/19 04:02:30.92 kernel  [Handler pc: 0x0x0000000001363690 des__errhdl installed by the following function:-]
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x0000000000b2317c des__fill_common+0x27c()
02:00000:00267:2014/03/19 04:02:30.92 kernel  [Handler pc: 0x0x0000000001363690 des__errhdl installed by the following function:-]
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x0000000000b2013f des(float, int, long, long)+0x2df()
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x00000000018c0162 des_get+0x6c2()
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x0000000001871f77 open__lookup+0x47()
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x0000000001871aed open__byname+0xfd()
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x000000000187143d open_user_table+0xfd()
02:00000:00267:2014/03/19 04:02:30.92 kernel  [Handler pc: 0x0x00000000015c7674 trunctaberr installed by the following function:-]
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x0000000000ce53d1 trunctab+0x141()
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x0000000000c2f837 s_execute+0x3777()
02:00000:00267:2014/03/19 04:02:30.92 kernel  [Handler pc: 0x0x0000000000c5f8a0 hdl_stack installed by the following function:-]
02:00000:00267:2014/03/19 04:02:30.92 kernel  [Handler pc: 0x0x0000000000c3e060 s_handle installed by the following function:-]
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x0000000001961525 sequencer+0x1e5()
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x0000000000c29047 execproc+0x687()
02:00000:00267:2014/03/19 04:02:30.92 kernel  [Handler pc: 0x0x0000000000c5f880 hdl_backout installed by the following function:-]
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x0000000000c34754 s_execute+0x8694()
02:00000:00267:2014/03/19 04:02:30.92 kernel  [Handler pc: 0x0x0000000000c5f8a0 hdl_stack installed by the following function:-]
02:00000:00267:2014/03/19 04:02:30.92 kernel  [Handler pc: 0x0x0000000000c3e060 s_handle installed by the following function:-]
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x0000000001961525 sequencer+0x1e5()
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x0000000000c29047 execproc+0x687()
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x0000000000c34754 s_execute+0x8694()
02:00000:00267:2014/03/19 04:02:30.92 kernel  [Handler pc: 0x0x0000000000c5f8a0 hdl_stack installed by the following function:-]
02:00000:00267:2014/03/19 04:02:30.92 kernel  [Handler pc: 0x0x0000000000c3e060 s_handle installed by the following function:-]
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x00000000019619da sequencer+0x69a()
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x00000000007602da tdsrecv_language+0xaa()
02:00000:00267:2014/03/19 04:02:30.92 kernel  [Handler pc: 0x0x0000000000ce7520 ut_handle installed by the following function:-]
02:00000:00267:2014/03/19 04:02:30.92 kernel  pc: 0x0000000001828946 conn_hdlr+0xa86()
02:00000:00267:2014/03/19 04:02:30.92 kernel  end of stack trace, spid 267, kpid 14221529, suid 10
02:00000:00267:2014/03/19 04:02:30.92 kernel  ueshutdown: exiting
00:00000:00000:2014/03/19 04:02:30.94 kernel  SySAM: Checked in license for 1 ASE_CORE (2013.03010/permanent/0C94 6187 B194 DF07).

xietong007

Eisen 發(fā)表于 2014-03-12 19:46
15.0.3/EBF 17157 ESD#3啊，
這個(gè)version里面有問題，以前我也經(jīng)常碰上這個(gè)錯(cuò)，升級(jí)到ESD4.3后不見了

目前我們這臺(tái)服務(wù)器基本上是每天凌晨4點(diǎn)多點(diǎn)就會(huì)自己down掉。 確認(rèn)升級(jí)到ESD4.3就可以解決這個(gè)問題？   謝謝！

zhaopingzi

為什么這么有規(guī)律，在4-5點(diǎn)，在這個(gè)時(shí)間段里，數(shù)據(jù)庫(kù)有什么操作嗎？

xietong007

zhaopingzi 發(fā)表于 2014-03-19 14:26
為什么這么有規(guī)律，在4-5點(diǎn)，在這個(gè)時(shí)間段里，數(shù)據(jù)庫(kù)有什么操作嗎？

目前我們已經(jīng)停掉了已知的4點(diǎn)左右的所有定時(shí)任務(wù)，但是還是在這個(gè)時(shí)間點(diǎn)附件，Sybase會(huì)自動(dòng)down掉。

有沒有什么辦法捕捉或者跟蹤到什么原因?qū)е碌倪@個(gè)down掉？