William Are you regularly packing indexes on the database? I recommend to my clients that this be done daily as part of a backup routine.
David Blocker ----- Original Message ----- From: "Tom Grimshaw" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 29, 2002 1:29 PM Subject: Re: Corrupt Indexes > G'day William, > > Feeling your pain at this end. > > I am running R:BASE Win 6.5++ on a W2K HP OmniBook 6000 and have > only rarely experienced losing data, and nearly always after a > crash. > > Best clue I can think of, "What change occurred immediately prior > to the problem manifesting?" > > At 17:46 28/05/02 -0700, you wrote: > >Hoping for help and providing a warning: > > > >We have begun to encounter REPEATED index corruptions, resulting in a > >scenario in which rows seem to both exist and not exist at the same > >time. The usual tell-tale clue is if one were to compare the row counts > >returned by the LIST TABLE and SELECT COUNT(*) FROM they are > >different. And the data is NOT retrievable. > > > >The only common link seems, at this time, to be that the tables in > >question have UNIQUE indexes declared. We have begun to remove these > >indexes in an effort to contain this problem. Maybe a bit late, as it has > >already cost us substantial amount of money due to invoices not being > >calculated correctly because the details of the charges got "lost". > > > >Has anyone else experienced such behavior? Is this a noted issue? This > >issue has moved from table to table, so I am not considering it a coding > >issue, and I have way too many projects to debug index issues, so any help > >would be appreciated. > > > >Windows 2000 & NT 4.0; RBWin 6.5++ > > > >Also, this behavior has happened on databases that do not share hardware, > >so I have discounted the possibility of NIC or other hardware failures. > > Warmest regards, > > > Tom Grimshaw > coy: Just For You Software > tel: 612 9552 3311 > fax: 612 9566 2164 > mobile: 0414 675 903 > > post: PO Box 470 Glebe NSW 2037 Australia > street: 3/66 Wentworth Park Rd Glebe NSW 2037 > > email: [EMAIL PROTECTED] > web: www.just4usoftware.com.au > > "... the control of impulse -- is the first principle of civilization."-- > Will Durant, > Pulitzer Prize winning philosopher, writer and historian > > the most needed product in the world can be found at > www.thewaytohappiness.org > > This email and any files transmitted with it are confidential to the > intended recipient and may be privileged. If you have received this email > inadvertently or you are not the intended recipient, you may not > disseminate, distribute, copy or in any way rely on it. Further, you should > notify the sender immediately and delete the email from your computer. > Whilst we have taken precautions to alert us to the presence of computer > viruses, we cannot guarantee that this email and any files transmitted with > it are free from such viruses. > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
