Checking txorder Msg 692, Level 16, State 1: Line 1: Uninitialized logical page '13066' was read while accessing object '64003259' in database '5'. Please contact Sybase Technical Support. Checking store_text The total number of data pages in this table is 1. Checking txorder_work ---- Checking invoice_item The total number of data pages in this table is 7185. Table has 45721 data rows. Msg 823, Level 16, State 1: Line 1: I/O error detected during read for BUF pointer = '0xdd186680', MASS pointer = '0xdd186680', (Buf#: '0'), page ptr = '0xdcdea000', dbid = '5', Mass virtpage = '67118695', Buffer page = '9831', Mass status = '0x4000100', Buffer status = '0x1', size = '2048', cache (id: 0) = 'default data cache'. Checking pmt_error_log ---- (7413 10) 00:00000:00006:2002/03/25 21:24:37.88 server 5 task(s) are sleeping waiting for space to become available in the log segment for database txdb1. http://manuals.sybase.com/onlinebooks/group-as/asg1250e/svrtsg/@Generic__BookTextView/105763 --- http://manuals.sybase.com/onlinebooks/group-as/asg1250e/svrtsg --- 1> dump transaction txdb1 with no_log 2> go 00:00000:00011:2002/03/25 21:43:15.51 server WARNING: *************************** 00:00000:00011:2002/03/25 21:43:15.51 server Attempt by user 1 to dump xact on db txdb1 with NO_LOG 00:00000:00020:2002/03/25 21:43:21.83 server Error: 692, Severity: 20, State: 1 00:00000:00020:2002/03/25 21:43:21.84 server Uninitialized logical page '13066' was read while accessing object '64003259' in database '5'. Please contact Sybase Technical Support. 00:00000:00020:2002/03/25 21:43:21.84 kernel ************************************ 00:00000:00020:2002/03/25 21:43:21.84 kernel SQL causing error : SELECT t0.txorder_id FROM txorder t0 WHERE t0.order_date <= 1017105902 AND t0.order_status = 1 ORDER BY t0.store_id ASC, t0.order_number ASC 00:00000:00020:2002/03/25 21:43:21.84 kernel curdb = 5 pstat = 0x10000 lasterror = 692 00:00000:00020:2002/03/25 21:43:21.84 kernel preverror = 0 transtate = 0 00:00000:00020:2002/03/25 21:43:21.84 kernel curcmd = 193 program = 00:00000:00020:2002/03/25 21:43:21.84 kernel pc: 0x39b570 pcstkwalk+0x20(0xdc1655f8, 0x0, 0x270f, 0x2, 0x0) 00:00000:00020:2002/03/25 21:43:21.84 kernel pc: 0x39b484 ucstkgentrace+0x178(0x240024, 0x2, 0x270f, 0x0, 0x0) 00:00000:00020:2002/03/25 21:43:21.84 kernel pc: 0x37cc5c ucbacktrace+0xa4(0xdc1f0ee8, 0x1, 0x240024, 0xdc597230, 0x0) 00:00000:00020:2002/03/25 21:43:21.84 kernel pc: 0x6a5d4 terminate_process+0x7f4(0x0, 0x6195bc, 0x2c00, 0x2d94, 0x2d90) 00:00000:00020:2002/03/25 21:43:21.87 kernel pc: 0x85880 hdl_default+0x48(0x6, 0x5c, 0x14, 0x1, 0xdc165938) 00:00000:00020:2002/03/25 21:43:21.87 kernel pc: 0x16bc64 s_handle+0xdb0(0x3c00, 0x2c4c, 0x14, 0x1, 0x2c00) 00:00000:00020:2002/03/25 21:43:21.87 kernel pc: 0x856f0 ex_raise+0x1ac(0x3c00, 0x5c, 0xdc3fb988, 0x1, 0xdc3fba14) 00:00000:00020:2002/03/25 21:43:21.87 kernel pc: 0x951ac wrongpage+0x22c(0xdd180620, 0xdc5cf4c5, 0x0, 0x0, 0x0) 00:00000:00020:2002/03/25 21:43:21.87 kernel pc: 0x93398 getpage+0x1ec(0xdc315c90, 0x3ee4, 0x60c400, 0xffffffff, 0x0) 00:00000:00020:2002/03/25 21:43:21.87 kernel pc: 0x9575c getrow+0x10(0xdc315c90, 0x0, 0x330a, 0xdc315cf8, 0xdc315c90) 00:00000:00020:2002/03/25 21:43:21.87 kernel pc: 0x8fffc getnext+0x680(0xdc315c90, 0x0, 0xdc315d00, 0xdc315cf8, 0xdc315d10) 00:00000:00020:2002/03/25 21:43:21.88 kernel pc: 0x29bc70 exec_eop+0x37c(0x4400, 0xdc709b68, 0x4538, 0x0, 0x0) 00:00000:00020:2002/03/25 21:43:21.88 kernel pc: 0x29bfa4 exec_eop+0x6b0(0x0, 0xdc709838, 0x4538, 0x0, 0x0) 00:00000:00020:2002/03/25 21:43:21.88 kernel [Handler pc: 0x29fcb0 execerr installed by the following function:-] 00:00000:00020:2002/03/25 21:43:21.88 kernel [Handler pc: 0x18b8e8 sortmerr installed by the following function:-] 00:00000:00020:2002/03/25 21:43:21.88 kernel [Handler pc: 0x29fcb0 execerr installed by the following function:-] 00:00000:00020:2002/03/25 21:43:21.88 kernel [Handler pc: 0x217e00 aritherr installed by the following function:-] 00:00000:00020:2002/03/25 21:43:21.89 kernel pc: 0x29b254 execute+0x960(0xdc707490, 0x4538, 0xdc3f8b9c, 0xdc166214, 0x0) 00:00000:00020:2002/03/25 21:43:21.89 kernel pc: 0x151b78 s_execute+0x678(0xc1, 0x0, 0x4d1e44, 0xffffffff, 0x3) 00:00000:00020:2002/03/25 21:43:21.90 kernel [Handler pc: 0x16aeb4 s_handle installed by the following function:-] 00:00000:00020:2002/03/25 21:43:21.90 kernel pc: 0x168d3c sequencer+0xe9c(0xdc00e480, 0x2c54, 0xdc3f8b9c, 0x0, 0x619400) 00:00000:00020:2002/03/25 21:43:21.90 kernel [Handler pc: 0x857dc hdl_backout installed by the following function:-] 00:00000:00020:2002/03/25 21:43:21.90 kernel [Handler pc: 0x1d192c ut_handle installed by the following function:-] 00:00000:00020:2002/03/25 21:43:21.91 kernel pc: 0x23f980 conn_hdlr+0x1ad4(0x3c00, 0x619400, 0x0, 0x60c400, 0x619400) 00:00000:00020:2002/03/25 21:43:21.91 kernel pc: 0x3ab288 _coldstart+0x4(0xf, 0x23deac, 0x0, 0x0, 0x0) 00:00000:00020:2002/03/25 21:43:21.91 kernel end of stack trace, spid 20, kpid 2359332, suid 3 --- http://paul.rutgers.edu/sybase.html ftp://ftp.midsomer.org/pub/ASE.txt http://manuals.sybase.com/onlinebooks/group-as/asg1250e/svrtsg http://paul.rutgers.edu/sybase.html