On SLES10SP2, I was trying to run yast online update, and kept getting a bunch of errors, including this one....
"rpmdb: fatal region error detected; run recovery"
To resolve the problem I first had to do the following...
Change to the rpm directory..
Remove file locks from rpm directory..
#rm -f __db*
Rebuild the rpm database. This will take a few minutes.
After that completed, I was able to apply updates without incident.
Source info for post......