Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Location
    SA
    Posts
    9

    Unanswered: What could be the cause of these errors

    Our server was unavailable due to some errors whilst running Reorg Rebuild over the weekend. On recovery the databases went through a redo and undo pass.
    This is the error log




    01:00000:00865:2007/08/19 07:17:54.15 server Error: 823, Severity: 24, State: 1
    01:00000:00865:2007/08/19 07:17:54.15 server I/O error detected during read for BUF pointer = '0xf6ef55e0', MASS pointer = '0xf6ef55e0', (Buf#: '0'), page ptr = '0x9e388000', dbid = '6', Mass virtpage = '88751432', Buffer page = '21249352', Mass status = '0x100', Buffer status = '0x1', size = '16384', cache (id: 0) = 'default data cache', Pinning Xdes = '0x0', spid = '0'.

    03:00000:00865:2007/08/19 07:30:30.17 server Error: 823, Severity: 24, State: 1
    03:00000:00865:2007/08/19 07:30:30.17 server I/O error detected during read for BUF pointer = '0xfa74b7b4', MASS pointer = '0xfa74b7b4', (Buf#: '0'), page ptr = '0xd85fd800', dbid = '6', Mass virtpage = '98222336', Buffer page = '30720256', Mass status = '0x4000100', Buffer status = '0x1', size = '2048', cache (id: 0) = 'default data cache', Pinning Xdes = '0x0', spid = '0'.
    02:00000:00865:2007/08/19 07:30:30.22 server REORG REBUILD of 'ClmPmtLine' terminated due to error or user interrupt.
    00:00000:00000:2007/08/19 07:32:36.18 kernel sddone: write error on virtual disk 19 block 2281796:
    00:00000:00000:2007/08/19 07:32:36.18 kernel sddone: I/O error
    00:00000:00411:2007/08/19 07:32:36.18 server Error: 823, Severity: 24, State: 2
    00:00000:00411:2007/08/19 07:32:36.18 server I/O error detected during wait for BUF pointer = '0xfbc69974', MASS pointer = '0xfbc69974', (Buf#: '0'), page ptr = '0xee2c5800', dbid = '8', Mass virtpage = '321048900', Buffer page = '43241796', Mass status = '0x91108', Buffer status = '0x1', size = '2048', cache (id: 0) = 'default data cache', Pinning Xdes = '0x0', spid = '0'.


    01:00000:00865:2007/08/19 07:33:39.49 server Error: 1251, Severity: 26, State: 1
    01:00000:00865:2007/08/19 07:33:39.49 server Error while undoing log row in database 'iMed_PROD'. Rid pageid = 0x0; row num = 0x0.
    01:00000:00865:2007/08/19 07:33:39.49 Server WARNING: Pss found with open sdes. pspid 8, psuid -2032327376, pcurdb 865, system table entry 1, sdesp 0x0000, objid 8
    01:00000:00865:2007/08/19 07:33:39.49 server WARNING: Pss found with open sdes. pspid 8, psuid -2032327376, pcurdb 865, system table entry 1, sdesp 0x0003, objid 8
    01:00000:00865:2007/08/19 07:33:39.49 server Error: 6103, Severity: 17, State: 1
    01:00000:00865:2007/08/19 07:33:39.49 server Unable to do cleanup for the killed process; received Msg 3300.
    01:00000:00865:2007/08/19 07:33:39.49 server WARNING: spid 865, with suid 1 and curdbid 4 has active XDES #1 with xactid (30673851, 17).
    03:00000:00000:2007/08/19 07:34:42.19 kernel sddone: write error on virtual disk 15 block 15436420:
    03:00000:00000:2007/08/19 07:34:42.19 kernel sddone: I/O error

    00:00000:00000:2007/08/20 07:45:52.68 kernel sddone: I/O error
    00:00000:00040:2007/08/20 07:45:52.68 server Error: 823, Severity: 24, State: 1
    00:00000:00040:2007/08/20 07:45:52.68 server I/O error detected during read for BUF pointer = '0xfa73a038', MASS pointer = '0xfa73a038', (Buf#: '0'), page ptr = '0xd84dd000', dbid = '2', Mass virtpage = '289762304', Buffer page = '4551168', Mass status = '0x4000100', Buffer status = '0x1', size = '2048', cache (id: 0) = 'default data cache', Pinning Xdes = '0x0', spid = '0'.
    00:00000:00040:2007/08/20 07:45:52.68 kernel current processes (0x3b8b0885) infected with 10
    00:00000:00040:2007/08/20 07:45:52.68 kernel SQL causing error: SELECT C.description FROM master.dbo.syscharsets C, master.dbo.syscurconfigs F WHERE C.id = F.value AND F.config=131
    00:00000:00040:2007/08/20 07:45:52.68 kernel curdb = 6 pstat = 0x14000 lasterror = 823
    00:00000:00040:2007/08/20 07:45:52.68 kernel preverror = 0 transtate = 1
    00:00000:00000:2007/08/20 07:46:55.68 kernel sddone: read error on virtual disk 17 block 5024512:
    00:00000:00000:2007/08/20 07:46:55.68 kernel sddone: I/O error
    02:00000:00027:2007/08/20 07:46:55.69 server Error: 823, Severity: 24, State: 1
    02:00000:00027:2007/08/20 07:46:55.69 server I/O error detected during read for BUF pointer = '0xfb269180', MASS pointer = '0xfb269180', (Buf#: '0'), page ptr = '0xe3d94000', dbid = '2', Mass virtpage = '290237184', Buffer page = '5026048', Mass status = '0x4000100', Buffer status = '0x1', size = '2048', cache (id: 0) = 'default data cache', Pinning Xdes = '0x0', spid = '0'.

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Looks like a problem with access to your disk sub system as several disk report an error. Check you O/S logs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •