baiynije 发表于 2011-12-27 09:11

sybase 用戶數據庫無法啟動,錯誤信息如下,請幫忙,謝謝

00:00000:00001:2011/12/27 09:01:17.99 serverThe transaction log in the database 'sybsystemprocs' will use I/O size of 4 Kb.
00:00000:00001:2011/12/27 09:01:18.04 serverDatabase 'sybsystemprocs' is now online.
00:00000:00010:2011/12/27 09:01:18.04 kernelnetwork name erpdatabase, interface IPv4, address 10.103.1.9, type nlwnsck, port 5000, filter NONE
00:00000:00012:2011/12/27 09:01:18.04 kernelhbc_ninit: No sockets available for HBC
00:00000:00012:2011/12/27 09:01:18.04 kernelEnable boot traceflag 1642 to allocate required HBC sockets at next boot
00:00000:00001:2011/12/27 09:01:18.04 server
*** Bypassing recovery of database id 11

00:00000:00001:2011/12/27 09:01:19.06 serverInvalid DOL data row pointer: row 2 with status 0x1 must be the forwarded row location instead of the home row location.
00:00000:00001:2011/12/27 09:01:19.26 kernelSymbolic stack trace information is successfully loaded
00:00000:00001:2011/12/27 09:01:19.28 kernelpc: 0x00000000012D7895 os_get_cur_stk_desc+ 0x1b5 (0x0000000000000000, 0x0000000000350035, 0x0000000000000002, 0x0000000006F590D0)
00:00000:00001:2011/12/27 09:01:19.29 kernelpc: 0x00000000012B1E3F pcstkwalk+ 0x53f (0x0000000000000001, 0x0000000000000000, 0x0000000000000000, 0x0000000001242E6B)
00:00000:00001:2011/12/27 09:01:19.31 kernelpc: 0x00000000012B293D ucstkgentrace+ 0x33d (0x0000C3F107B23677, 0x006344206465572F, 0x532070756B636142, 0x000000006CD6689A)
00:00000:00001:2011/12/27 09:01:19.31 kernelpc: 0x0000000001267F43 ucbacktrace+ 0x63 (0x7265532000000005, 0x0000000000000000, 0x0000000000000000, 0x000000006CD6689A)
00:00000:00001:2011/12/27 09:01:19.31 kernelpc: 0x00000000004D9356 collocate+ 0x1c6 (0x0000000000000000, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000)
00:00000:00001:2011/12/27 09:01:19.32 kernelpc: 0x000000000075E8C0 ptrcopyrow+ 0x1d0 (0x000000002C858270, 0x0000000000000000, 0x000000002C858270, 0x00000000012AC189)
00:00000:00001:2011/12/27 09:01:19.32 kernelpc: 0x000000000075EB01 copyrow+ 0x31 (0x00000000299481F0, 0x000000002AC7A028, 0x00000000299EBE60, 0x000000006CD6689A)
00:00000:00001:2011/12/27 09:01:19.32 kernelpc: 0x00000000004FEC40 des__fillcache+ 0x30 (0x0000000000000003, 0x000000002AC7A028, 0x0000000000000003, 0x0000000000000001)
00:00000:00001:2011/12/27 09:01:19.32 kernelpc: 0x0000000000506318 des__instantiate_sysdes+ 0x128 (0x00000000299EBE60, 0x00000000299EBE60, 0x0000000006F5D720, 0x0000000000000000)
00:00000:00001:2011/12/27 09:01:19.32 kernelpc: 0x0000000000508725 des__init_base_tables+ 0x355 (0x0000000000000000, 0x0000000000000001, 0x0000000000000000, 0x0000000000000006)
00:00000:00001:2011/12/27 09:01:19.32 kernelpc: 0x0000000000509760 des__bootsystables+ 0x1e0 (0x00000000299EBE60, 0x000000002AC79270, 0x00000000299EBE60, 0x0000000000000000)
00:00000:00001:2011/12/27 09:01:19.32 kernelpc: 0x000000000050CBAD des_sysbuild+ 0x7d (0x0000000000000000, 0x00000000299C79E0, 0x00000000299EBFC0, 0x000000002AC79270)
00:00000:00001:2011/12/27 09:01:19.32 kernelpc: 0x00000000005D4951 db_fill+ 0x521 (0x00000000299EBE60, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000)
00:00000:00001:2011/12/27 09:01:19.32 kernelpc: 0x0000000000547922 dbt__fill+ 0x392 (0x00000000299EBE60, 0x0000000000000000, 0x00000000299EBE60, 0x000000002AC79270)
00:00000:00001:2011/12/27 09:01:19.32 kernelpc: 0x000000000054B97F dbt_get+ 0x90f (0x0000000000000001, 0x000000002AC79270, 0x000000002AC79270, 0x0000000000000000)
00:00000:00001:2011/12/27 09:01:19.32 kernelpc: 0x00000000004F5088 usedb+ 0xa8 (0x0000000000000000, 0x0000000000000000, 0x2020202000000000, 0x000000000000000B)
00:00000:00001:2011/12/27 09:01:19.32 kernelpc: 0x000000000072F592 make_log_consistent+ 0x42 (0x0000000000000005, 0x0000000000000003, 0x0000000000000009, 0x0000000000008440)
00:00000:00001:2011/12/27 09:01:19.32 kernelpc: 0x000000000073023A rec_build_recovery_info+ 0xb3a (0x0000000000001000, 0x0000000000000001, 0x000000002F6D9800, 0x0000000000000001)
00:00000:00001:2011/12/27 09:01:19.32 kernelpc: 0x000000000073D777 dorecover+ 0x1c7 (0x0000000000000001, 0x00000000299D6260, 0x0000000006F5FBB8, 0x0000000000000000)
00:00000:00001:2011/12/27 09:01:19.34 kernelpc: 0x000000000041E81A ds__recoverdbs+ 0xa5a (0x000000000000000E, 0x0000000000000000, 0x000000002004BC40, 0x0000000000003A98)
00:00000:00001:2011/12/27 09:01:19.34 kernelpc: 0x0000000000421B80 dsinit+ 0x13b0 (0x000000002C82B7D0, 0x0000000000000000, 0x0000000000000000, 0x0000000001242E90)
00:00000:00001:2011/12/27 09:01:19.34 kernelpc: 0x0000000001242EE4 kpntwrapper+ 0x54 (0x0000000000000000, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000)
00:00000:00001:2011/12/27 09:01:19.34 kernelpc: 0x0000000078D6B66A BaseThreadStart+ 0x3a (0x0000000000000000, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000)
00:00000:00001:2011/12/27 09:01:19.35 kernelend of stack trace, spid 1, kpid 3473461, suid 0
00:00000:00001:2011/12/27 09:01:19.35 serverInvalid DOL data row pointer: row 2 with status 0x1 must be the forwarded row location instead of the home row location.
00:00000:00001:2011/12/27 09:01:19.35 kernelpc: 0x00000000012D7895 os_get_cur_stk_desc+ 0x1b5 (0x0000000000000001, 0x0000000000350035, 0x0000000000000002, 0x0000000006F590D0)
00:00000:00001:2011/12/27 09:01:19.37 kernelpc: 0x00000000012B1E3F pcstkwalk+ 0x53f (0x0000000000000001, 0x0000000000000000, 0x0000000000000000, 0x0000000001242E6B)
00:00000:00001:2011/12/27 09:01:19.37 kernelpc: 0x00000000012B293D ucstkgentrace+ 0x33d (0x0000C3F107B23677, 0x006344206465572F, 0x0000C3F107B23647, 0x000000006CD6689A)
00:00000:00001:2011/12/27 09:01:19.38 kernelpc: 0x0000000001267F43 ucbacktrace+ 0x63 (0x7265532000000005, 0x0000000000000000, 0x0000000000000000, 0x000000006CD6689A)
00:00000:00001:2011/12/27 09:01:19.38 kernelpc: 0x00000000004D9356 collocate+ 0x1c6 (0x0000000000000000, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000)
00:00000:00001:2011/12/27 09:01:19.38 kernelpc: 0x000000000075E8C0 ptrcopyrow+ 0x1d0 (0x000000002C858270, 0x0000000000000000, 0x000000002C858270, 0x00000000012AC189)
00:00000:00001:2011/12/27 09:01:19.38 kernelpc: 0x000000000075EB01 copyrow+ 0x31 (0x00000000299481F0, 0x000000002AC7A028, 0x00000000299EBE60, 0x000000006CD6689A)
00:00000:00001:2011/12/27 09:01:19.38 kernelpc: 0x00000000004FEC40 des__fillcache+ 0x30 (0x0000000000000003, 0x000000002AC7A028, 0x0000000000000003, 0x0000000000000001)
00:00000:00001:2011/12/27 09:01:19.38 kernelpc: 0x0000000000506318 des__instantiate_sysdes+ 0x128 (0x00000000299EBE60, 0x00000000299EBE60, 0x0000000006F5D720, 0x0000000000000000)
00:00000:00001:2011/12/27 09:01:19.40 kernelpc: 0x0000000000508725 des__init_base_tables+ 0x355 (0x0000000000000000, 0x0000000000000001, 0x0000000000000000, 0x0000000000000006)
00:00000:00001:2011/12/27 09:01:19.40 kernelpc: 0x0000000000509760 des__bootsystables+ 0x1e0 (0x00000000299EBE60, 0x000000002AC79270, 0x00000000299EBE60, 0x0000000000000000)
00:00000:00001:2011/12/27 09:01:19.40 kernelpc: 0x000000000050CBAD des_sysbuild+ 0x7d (0x0000000000000000, 0x00000000299C79E0, 0x00000000299EBFC0, 0x000000002AC79270)
00:00000:00001:2011/12/27 09:01:19.40 kernelpc: 0x00000000005D4951 db_fill+ 0x521 (0x00000000299EBE60, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000)
00:00000:00001:2011/12/27 09:01:19.40 kernelpc: 0x0000000000547922 dbt__fill+ 0x392 (0x00000000299EBE60, 0x0000000000000000, 0x00000000299EBE60, 0x000000002AC79270)
00:00000:00001:2011/12/27 09:01:19.40 kernelpc: 0x000000000054B97F dbt_get+ 0x90f (0x0000000000000001, 0x000000002AC79270, 0x000000002AC79270, 0x0000000000000000)
00:00000:00001:2011/12/27 09:01:19.40 kernelpc: 0x00000000004F5088 usedb+ 0xa8 (0x0000000000000000, 0x0000000000000000, 0x2020202000000000, 0x000000000000000B)
00:00000:00001:2011/12/27 09:01:19.40 kernelpc: 0x000000000072F592 make_log_consistent+ 0x42 (0x0000000000000005, 0x0000000000000003, 0x0000000000000009, 0x0000000000008440)
00:00000:00001:2011/12/27 09:01:19.40 kernelpc: 0x000000000073023A rec_build_recovery_info+ 0xb3a (0x0000000000001000, 0x0000000000000001, 0x000000002F6D9800, 0x0000000000000001)
00:00000:00001:2011/12/27 09:01:19.40 kernelpc: 0x000000000073D777 dorecover+ 0x1c7 (0x0000000000000001, 0x00000000299D6260, 0x0000000006F5FBB8, 0x0000000000000000)
00:00000:00001:2011/12/27 09:01:19.40 kernelpc: 0x000000000041E81A ds__recoverdbs+ 0xa5a (0x000000000000000E, 0x0000000000000000, 0x000000002004BC40, 0x0000000000003A98)
00:00000:00001:2011/12/27 09:01:19.40 kernelpc: 0x0000000000421B80 dsinit+ 0x13b0 (0x000000002C82B7D0, 0x0000000000000000, 0x0000000000000000, 0x0000000001242E90)
00:00000:00001:2011/12/27 09:01:19.42 kernelpc: 0x0000000001242EE4 kpntwrapper+ 0x54 (0x0000000000000000, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000)
00:00000:00001:2011/12/27 09:01:19.42 kernelpc: 0x0000000078D6B66A BaseThreadStart+ 0x3a (0x0000000000000000, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000)
00:00000:00001:2011/12/27 09:01:19.42 kernelend of stack trace, spid 1, kpid 3473461, suid 0
00:00000:00001:2011/12/27 09:01:19.42 serverInvalid DOL data row pointer: row 2 with status 0x1 must be the forwarded row location instead of the home row location.
00:00000:00001:2011/12/27 09:01:19.43 kernelpc: 0x00000000012D7895 os_get_cur_stk_desc+ 0x1b5 (0x0000000000000001, 0x0000000000350035, 0x0000000000000002, 0x0000000006F590D0)
00:00000:00001:2011/12/27 09:01:19.43 kernelpc: 0x00000000012B1E3F pcstkwalk+ 0x53f (0x0000000000000001, 0x0000000000000000, 0x0000000000000000, 0x0000000001242E6B)
00:00000:00001:2011/12/27 09:01:19.45 kernelpc: 0x00000000012B293D ucstkgentrace+ 0x33d (0x0000C3F107B23677, 0x006344206465572F, 0x0000C3F107B23647, 0x000000006CD6689A)
00:00000:00001:2011/12/27 09:01:19.45 kernelpc: 0x0000000001267F43 ucbacktrace+ 0x63 (0x7265532000000005, 0x0000000000000000, 0x0000000000000000, 0x000000006CD6689A)
00:00000:00001:2011/12/27 09:01:19.45 kernelpc: 0x00000000004D9356 collocate+ 0x1c6 (0x0000000000000000, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000)
00:00000:00001:2011/12/27 09:01:19.46 kernelpc: 0x000000000075E8C0 ptrcopyrow+ 0x1d0 (0x000000002C858270, 0x0000000000000000, 0x000000002C858270, 0x00000000012AC189)
00:00000:00001:2011/12/27 09:01:19.46 kernelpc: 0x000000000075EB01 copyrow+ 0x31 (0x00000000299481F0, 0x000000002AC7A028, 0x00000000299EBE60, 0x000000006CD6689A)
00:00000:00001:2011/12/27 09:01:19.46 kernelpc: 0x00000000004FEC40 des__fillcache+ 0x30 (0x0000000000000003, 0x000000002AC7A028, 0x0000000000000003, 0x0000000000000001)
00:00000:00001:2011/12/27 09:01:19.46 kernelpc: 0x0000000000506318 des__instantiate_sysdes+ 0x128 (0x00000000299EBE60, 0x00000000299EBE60, 0x0000000006F5D720, 0x0000000000000000)
00:00000:00001:2011/12/27 09:01:19.46 kernelpc: 0x0000000000508725 des__init_base_tables+ 0x355 (0x0000000000000000, 0x0000000000000001, 0x0000000000000000, 0x0000000000000006)
00:00000:00001:2011/12/27 09:01:19.46 kernelpc: 0x0000000000509760 des__bootsystables+ 0x1e0 (0x00000000299EBE60, 0x000000002AC79270, 0x00000000299EBE60, 0x0000000000000000)
00:00000:00001:2011/12/27 09:01:19.46 kernelpc: 0x000000000050CBAD des_sysbuild+ 0x7d (0x0000000000000000, 0x00000000299C79E0, 0x00000000299EBFC0, 0x000000002AC79270)
00:00000:00001:2011/12/27 09:01:19.46 kernelpc: 0x00000000005D4951 db_fill+ 0x521 (0x00000000299EBE60, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000)
00:00000:00001:2011/12/27 09:01:19.46 kernelpc: 0x0000000000547922 dbt__fill+ 0x392 (0x00000000299EBE60, 0x0000000000000000, 0x00000000299EBE60, 0x000000002AC79270)
00:00000:00001:2011/12/27 09:01:19.46 kernelpc: 0x000000000054B97F dbt_get+ 0x90f (0x0000000000000001, 0x000000002AC79270, 0x000000002AC79270, 0x0000000000000000)
00:00000:00001:2011/12/27 09:01:19.46 kernelpc: 0x00000000004F5088 usedb+ 0xa8 (0x0000000000000000, 0x0000000000000000, 0x2020202000000000, 0x000000000000000B)
00:00000:00001:2011/12/27 09:01:19.46 kernelpc: 0x000000000072F592 make_log_consistent+ 0x42 (0x0000000000000005, 0x0000000000000003, 0x0000000000000009, 0x0000000000008440)
00:00000:00001:2011/12/27 09:01:19.46 kernelpc: 0x000000000073023A rec_build_recovery_info+ 0xb3a (0x0000000000001000, 0x0000000000000001, 0x000000002F6D9800, 0x0000000000000001)
00:00000:00001:2011/12/27 09:01:19.48 kernelpc: 0x000000000073D777 dorecover+ 0x1c7 (0x0000000000000001, 0x00000000299D6260, 0x0000000006F5FBB8, 0x0000000000000000)
00:00000:00001:2011/12/27 09:01:19.48 kernelpc: 0x000000000041E81A ds__recoverdbs+ 0xa5a (0x000000000000000E, 0x0000000000000000, 0x000000002004BC40, 0x0000000000003A98)
00:00000:00001:2011/12/27 09:01:19.48 kernelpc: 0x0000000000421B80 dsinit+ 0x13b0 (0x000000002C82B7D0, 0x0000000000000000, 0x0000000000000000, 0x0000000001242E90)
00:00000:00001:2011/12/27 09:01:19.48 kernelpc: 0x0000000001242EE4 kpntwrapper+ 0x54 (0x0000000000000000, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000)
00:00000:00001:2011/12/27 09:01:19.48 kernelpc: 0x0000000078D6B66A BaseThreadStart+ 0x3a (0x0000000000000000, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000)

Eisen 发表于 2011-12-27 09:17

本帖最后由 Eisen 于 2011-12-27 09:20 编辑

是否ASE15.0.3?
看上去很象ASE15.0.3里面的一个bug -- CR670582,如果真的是在执行update或delete时引用huge merge_join导致的话,得通过truncate log或不幸重起导致db 无法online时作rebuild_log,之后启动compatible mode来解决这个问题。

baiynije 发表于 2011-12-27 09:23

Eisen 哥,是ASE15.0.2的

baiynije 发表于 2011-12-27 09:25

有多個用戶數據庫,但一個都啟動不了

Eisen 发表于 2011-12-27 09:31

server能启动,db无法online?

baiynije 发表于 2011-12-27 09:36

是啊,系統數據庫可online,用戶數據庫都不行

baiynije 发表于 2011-12-27 10:25

有辦法一個一個數據庫啟動嗎?懷疑是某個數據庫問題

andkylee 发表于 2011-12-27 10:43

回复 7# baiynije


    ase15.0.2支持dbcc dbreboot命令

andkylee 发表于 2011-12-27 10:44

回复 4# baiynije


    什么原因造成的数据库无法启动?

所有的都启动不了,是不是因为共享存储出现故障的原因?

andkylee 发表于 2011-12-27 10:48

回复 2# Eisen


    很多时候用户升级到15.0.3也未必用到一些所谓很强的特性。为了省事起见,还得调回兼容模式。 15中的表分区很好用。
页: [1] 2 3
查看完整版本: sybase 用戶數據庫無法啟動,錯誤信息如下,請幫忙,謝謝