Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vig_2007
Starting Member
1 Post |
 Posted - 2007-10-19 : 10:04:59
|
| Hi,We have production db with SQL SERVER 2000 build 818, SP4. We are having issues due to which users are not able to access the application.The database is configured in cluster environment. Its has two nodes. We are getting i/o errors on active node due to which database becomes unavailable to application. Though i am able to loginto database from SQL Enterprise Manager and Query Analyzer. But i am not able to see all the databases. And few other nodes are missing in Query Analyzer.2007-10-18 20:47:21.78 spid54 Sort read failure ailure ailure ailure ailure ailure ail. pageid = (0x5:0xda8),2007-10-18 20:47:21.80 spid54 I/O error 170(The requested resource is in use.) detected during read at offset2007-10-18 20:47:21.80 spid54 Error: 823, Severity: 24, State: 72007-10-18 21:00:03.45 spid54 I/O error 170(The requested resource is in use.) detected during read at offset2007-10-18 21:00:03.45 spid54 Error: 823, Severity: 24, State: 22007-10-18 21:00:03.58 spid54 I/O error 170(The requested resource is in use.) detected during read at offset2007-10-18 21:00:03.58 spid54 Error: 823, Severity: 24, State: 2************************************************2007-10-17 10:46:32.45 spid55 Sort read failure ailure ailure ailure ailure ailure ail. pageid = (0x3:0x2f00)2007-10-17 10:46:32.45 spid55 Sort read failure ailure ailure ailure ailure ailure ail. pageid = (0x5:0x2ef0)2007-10-17 10:46:32.45 spid55 Sort read failure ailure ailure ailure ailure ailure ail. pageid = (0x3:0x2ef8)2007-10-17 10:46:32.45 spid55 Sort read failure ailure ailure ailure ailure ailure ail. pageid = (0x5:0x2ee8)2007-10-17 11:09:14.56 spid55 Sort read failure ailure ailure ailure ailure ailure ail. pageid = (0x3:0x2f38)2007-10-17 11:11:58.90 spid53 Sort read failure ailure ailure ailure ailure ailure ail. pageid = (0x5:0x2f50)2007-10-17 11:11:58.90 spid53 Sort read failure ailure ailure ailure ailure ailure ail. pageid = (0x3:0x2f60)2007-10-17 11:11:58.90 spid53 Sort read failure ailure ailure ailure ailure ailure ail. pageid = (0x3:0x2f58)2007-10-17 11:11:58.92 spid53 Sort read failure ailure ailure ailure ailure ailure ail. pageid = (0x5:0x2f48)2007-10-17 11:14:58.28 spid53 Sort read failure ailure ailure ailure ailure ailure ail. pageid = (0x3:0x2f98)2007-10-17 11:15:33.37 spid53 Sort read failure ailure ailure ailure ailure ailure ail. pageid = (0x1:0xe0), 2007-10-17 11:15:33.37 spid53 Sort read failure ailure ailure ailure ailure ailure ail. pageid = (0x5:0x2fa8)2007-10-17 11:15:33.37 spid53 Sort read failure ailure ailure ailure ailure ailure ail. pageid = (0x3:0x2fc0)2007-10-17 11:15:33.37 spid53 Sort read failure ailure ailure ailure ailure ailure ail. pageid = (0x3:0x2fb8)2007-10-17 11:19:40.07 spid55 Sort read failure ailure ailure ailure ailure ailure ail. pageid = (0x3:0x2ff8)2007-10-17 11:19:40.07 spid55 Sort read failure ailure ailure ailure ailure ailure ail. pageid = (0x5:0x2fe0)2007-10-17 11:19:40.07 spid55 Sort read failure ailure ailure ailure ailure ailure ail. pageid = (0x5:0x2fe8)2007-10-17 11:19:40.07 spid55 Sort read failure ailure ailure ailure ailure ailure ail. pageid = (0x3:0x3000)2007-10-17 11:20:49.37 spid55 Sort read failure ailure ailure ailure ailure ailure ail. pageid = (0x3:0x3048) |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
|
|
|
|
|
Sort read failure : I/O error 170