It does not look like they would be deleting rows from this table. That is where a bad index would cause problems.
The kind of corruption you are seeing is cause by a computer failing to complete updates to the #1 file after inserting a row in the #2 file. Easiest thing to do is replace the NIC card in that machine and see if the problem stops happening. Dennis ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of MDRD Sent: Thursday, August 19, 2010 2:58 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Corrupt DB Dennis I checked the indexes and here they are --- ------------------ ------------------------------------------------------ 1 custnum Type : INTEGER NOT NULL Consrnt: FOREIGN KEY REFERENCES PTINFO Consrnt: UNIQUE 2 Date_con Type : DATE 3 TxDate Type : DATE NOT NULL Consrnt: UNIQUE 4 Treat_dr Type : TEXT 2 Consrnt: FOREIGN KEY REFERENCES DRINFO This is the error Examining data in TravCard Rows: Active 7541, Deleted 0 Actual rows counted: 7543, expected count: 7541 -ERROR- The number of rows counted was not expected. (1254) Thanks Marc From: Dennis McGrath<mailto:[email protected]> Sent: Thursday, August 19, 2010 2:43 PM To: RBASE-L Mailing List<mailto:[email protected]> Subject: [RBASE-L] - Re: Corrupt DB It could be that is that is the only table that user hits frequently. Network connection is high on the list of causes, card or cable. One other issue to check, the indexes on that table. Are there any indexes that are highly inefficient, i.e. one value predominates, like NULL? If so get rid of the bad index(es) I had one client that required a rebuild of the db on a regular basis because it kept getting corrupted. Eliminated a bad index and I haven't had to fix it for years!!!! Dennis McGrath ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, August 19, 2010 1:17 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Corrupt DB Is the corruption always happening in the same table? If it is, then it is hard to make a case that it's something hardware or network related... Karen
