I/o Error Bad Page Id Detected During Read Of Buf
New? Advanced Search Forum Database Discussions MS SQL Server 7/MS SQL Server 2000 I/O(Bad page Error) If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 2 of 2 Thread: I/O(Bad page Error) Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 04-04-2002,08:04 AM #1 John Jayaseelan Guest I/O(Bad page Error) Hi, The following error message is found in the SQl server logs. I/O error (bad page ID) detected during read of BUF pointer = 0x14214040, page ptr = 0x413c2000, pageid = (0x1:0x59de6), dbid = 12, status = 0x801, file = D:MSSQL7dataPRIMUS_DK_Data.MDF Coukld you please tell why and what is its effect. Thanks John Jayaseelan Reply With Quote 04-04-2002,08:57 AM #2 dirk Guest I/O(Bad page Error) (reply) run DBCC checkalloc/checkdb on that database. ------------ John Jayaseelan at 4/4/2002 9:04:53 AM Hi, The following error message is found in the SQl server logs. I/O error (bad page ID) detected during read of BUF pointer = 0x14214040, page ptr = 0x413c2000, pageid = (0x1:0x59de6), dbid = 12, status = 0x801, file = D:MSSQL7dataPRIMUS_DK_Data.MDF Coukld you please tell why and what is its effect. Thanks John Jayaseelan Reply With Quote Quick Navigation MS SQL Server 7/MS SQL Server 2000 Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Database Discussions IBM DB2 Informix Microsoft Access Microsoft SQL Server 2008 Microsoft SQL Server 2005 MDX and Analysis Services Reporting Services MS SQL Server 7/MS SQL Server 2000 MySQL Oracle PostgreSQL Sybase Miscellaneous General Database Discussions Ask an Expert Database Design Database Programming Database News and Announcements Structured Query Language (SQL) SQL Scripts Database Lounge Feedback Related Sites SQL Course SqlCredit « Previous Thread | Next Thread » Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off [VIDEO] code is Off HTML code is Off Forum Rules -- New Theme
Query Analyser , show this error : Server: Msg 823, Level 24, State 1, Line 34 I/O error (bad page ID) detected during read of BUF pointer = 0x11bde680, page ptr = 0x21524000, pageid = (0x3:0x3), dbid = 2, status = 0x801, file = E:\Mssql7\Data\templog2_Log.LDF. Anybody, know any solution for this .... Thanks ... http://forums.databasejournal.com/showthread.php?11118-I-O(Bad-page-Error) Top 1. I/O error (bad page ID) detected during read of BUF pointer Hi, I'm running a BULK INSERT command and in return, SQL gives me a 'I/O error (bad page ID) detected during read of BUF pointer' I tried to find out http://www.verycomputer.com/156_317610d134bb677c_1.htm information on the probleme, to no avail. I know the syntax works because it's the same syntax used for other files. Can anyone help me on this???? Patrice Calve 2. Populating Time Table 3. I/O error (bad page ID) detected during read of BUF pointer = 0x11bde680 4. comma - dot error with ADO 5. Attaching a damaged database - I/O error (bad page ID) detected during read 6. SQL Server constantly utilising 100% CPU time 7. I/O error (bad page ID) detected during read 8. How to recover from I/O error (bad page ID) detected 9. I/O error (bad page ID) detected 10. I/O error (torn page) detected during read at offset 11. I/O error (torn page) detected during read at offset 0x000000000ee000 12. Error 823 I/O error (bad page ID).... 1 post • Page:1 of 1 All times are UTC Board index Spam Report
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54211 over! We've restricted the ability to create new threads on these forums. http://dba.stackexchange.com/questions/104366/keep-getting-i-o-error-reading-sybase-tables SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2000 Forums SQL Server Administration (2000) Error Reply to Topic Printer Friendly Author Topic ssrikrish Yak Posting Veteran 69 i/o error Posts Posted-08/23/2005: 14:17:02 This error message was thrown in a SQL server 7.0 database. Please let me know the cause and fix. I/O error (bad page ID) detected during read of BUF pointer = 0x14682100, page ptr = 0x64ac8000, pageid = (0x1:0x33b0), dbid = 51, status = 0x801, file = E:\xxx\abcd.mdf eyechart Flowing Fount of Yak Knowledge USA 3575 Posts Posted-08/23/2005: i/o error bad 14:34:46 sounds like corruption to me. Have you run DBCC CHECKDB on your database?Might be worthwhile to re-post this in the Data Corruption Issues forum here. http://www.sqlteam.com/forums/forum.asp?FORUM_ID=22Run the DBCC CHECKDB and paste the results in a new post in that forum. Don't use any of the options to try and fix the data yet, just get the report.-ec eyechart Flowing Fount of Yak Knowledge USA 3575 Posts Posted-08/23/2005: 14:36:09 or just change the title of you original post to 'SQL 7 Data Corruption' or something similar.-ec ssrikrish Yak Posting Veteran 69 Posts Posted-08/23/2005: 20:49:57 I ran CHECKDB as soon as I received the error. No corruption errors. eyechart Flowing Fount of Yak Knowledge USA 3575 Posts Posted-08/23/2005: 21:19:54 do you have any disk errors in your system event log?-ec ssrikrish Yak Posting Veteran 69 Posts Posted-08/27/2005: 09:43:06 Thanks for the input guys. Apparently, the disk had bad blocks. We have replaced the disks. Things are running smoothly after that. I believe it will save some sleepless nights for me. It seems like hardware life is a k
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Keep Getting I/O Error Reading Sybase Tables up vote 4 down vote favorite I keep getting the following error message from my Sybase server: I/O error detected during read for BUF pointer = '0xed318720', MASS pointer = '0xed318720', (Buf#: '0'), page ptr = '0xecdbe000', dbid = '5', <-- This is our production database Mass virtpage = '50372477', Buffer page = '40829', Mass status = '0x4000100', Buffer status = '0x1', size = '2048', cache (id: 0) = 'default data cache'. The problem started from last week. I got around the problem by dropping the database, rebuilding it from a backup in a backup-server. This was OK for a week or so. Now the same problem comes right back. I have just attempted to apply the same workaround (drop-db and rebuild-from-backup). But this time the problem doesn't go away. The error message is slightly changed into this: An attempt was made to read logical page '41175' for object '899820055' in database '5' from disk. Wrong logical page '41303' was brought into cache 'default data cache'. Seem like the workaround doesn't really fix the underlying problem. I would like to know what the problem is. I have a feeling that some areas in the file-system may be corrupted. I am trying to use fsck command to fix the problem. That is the exact command that I use: fsck /dev/rdsk/c0t0d0s1 <-- It is the device of the database file But I get this err