[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::rdb_60

Title:	Oracle Rdb - Still a strategic database for DEC on Alpha AXP!
Notice:	RDB_60 is archived, please use RDB_70..
Moderator:	NOVA::SMITHISON

Created:	Fri Mar 18 1994
Last Modified:	Fri May 30 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	5118
Total number of notes:	28246

5051.0. "Checksum error NOT logged in CPT??" by M5::LWILCOX (Chocolate in January!!) Thu Feb 20 1997 09:01

Rdb 6.1-04 on Alpha 6.2 VMS.  Customer was running an RMU/BACKUP/ONLINE and
received a BADPTLARE error for a page.  He reran the same backup command,
and this time received a CHECKSUM error on the same area, (I'm not sure if
it was the same page).  He said he did NOT have any entry in the CPT after
this checksum error.  I even had him dump the CPT while I was on the phone
with him and there isn't any entry.  I have never seen this be the case
and wanted to find out if anyone else had?

He's trying the backup again and I'll know shortly if he has a problem
with it.  He is suspicious of his hardware because they have been having
some problems and had their vendor do some firmware upgrades and he's still
having problems.

Thanks.

Liz

T.R	Title	User	Personal Name	Date	Lines
5051.1		M5::LWILCOX	Chocolate in January!!	`Thu Feb 20 1997 09:32`	9
	Yuck, this area looks really sick. I also saw note 1788 and the customer now has a call into his fs rep. He is using MTI drives. I am still interested in knowing if anyone has seen an instance of a checksum error NOT being logged in the CPT. Thanks. Liz
5051.2		HOTRDB::LASTOVICA	Is it possible to be totally partial?	`Thu Feb 20 1997 09:43`	4
	since you indicated that the checksum error occured during the backup, can I assume that he explicitly specified /CHECKSUM (it isn't the default). Perhaps RMU/BACKUP doesn't update the CPT upon checksum errors. It'd be easy for you to test.
5051.3	please see bug 396737	AVMSV1::EKREISLE	Erich Kreisler	`Fri Feb 21 1997 03:49`	7
	I had the problem that pages with an incorrect page number were not inserted into the CPT. See also note 4438. Ciao, erich
5051.4	backup doesn't log it!	M5::LWILCOX	Chocolate in January!!	`Fri Feb 21 1997 09:16`	14
	<<< Note 5051.2 by HOTRDB::LASTOVICA "Is it possible to be totally partial?" >>> >> default). Perhaps RMU/BACKUP doesn't update the CPT upon checksum >> errors. It'd be easy for you to test. Hmmmmm, I tried backup with and without /CHECKSUM after I purposely corrupted a checksum via alter. It did NOT log the error in the CPT in either case! I was surprised that it didn't. It sure does return the checksum error. Is RMU/BACKUP suppossed to log the page in the CPT? Thanks, Liz
5051.5	that's about what I expected	HOTRDB::LASTOVICA	Is it possible to be totally partial?	`Fri Feb 21 1997 09:25`	11
	>It did NOT log the error in the CPT in either case With /NOCHECKSUM (the default), database page checksums are not calculated or compared, so it is no wonder that this didn't even notice and bad checksums. When you use /CHECKSUM, I believe that RMU signals the error and stops the backup. You've got the 6.1 listings on line (I believe that RMU is included), I imagine that you can look at the code to determine if it ever intended to update the CPT; My guess is that it doesn't even try. If you think that this is a problem, a suggestion BUG might be in order.