Kbase P17430: Getting error 606 on schema area when trying to start databa
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/17/2003 |
|
Status: Unverified
FACT(s) (Environment):
Windows NT
FACT(s) (Environment):
Progress 9.0B
SYMPTOM(s):
Getting error 606 on schema area when trying to start database
Getting error 606 on .d1 extent when trying to start database
Extent <file-name> has a different last opened date. (606)
CHANGE:
A prostrct repair had been carried out on an operating system copy of the production database. The st file for the production database was used by mistake.
CAUSE:
What prostrct repair does is update the list of files in the .db file to reflect the new locations of database extents. So in this case, when trying to start a broker for the training database, Progress was looking in the .db file in the training environment and finding a list of files that were in the production environment. A broker can be started because there is no .lk file local to the .db file we were looking at. We can thus reach a situation where 2 brokers are running against the same database, giving timestamp errors.
An example, tested with 9.1D on WIndows 2000:
1. Create 2 new directories:
C:\prgswrk\test\proddb
C:\prgswrk\test\trgdb
2. Create a new sports in C:\prgswrk\test\proddb.
3. Ran prostrct list on this database.
3. Did an os copy of all the files in C:\prgswrk\test\proddb and put them all into C:\prgswrk\test\trgdb.
4. Set up both databases under ProControl. The sports in C:\prgswrk\test\trgdb has to be given a unique identifier.
5. Try to start C:\prgswrk\test\trgdb\sports, get the 598 message:
C:\prgswrk\test\trgdb\sports.db is a copy of C:\prgswrk\proddb\sports.db. Database cannot be opened. (598)
6. Run a prostrct repair on C:\prgswrk\test\trgdb\sports. The st used is that for the production db, C:\prgswrk\proddb\sports.
7. Start C:\prgsw\proddb\sports with ProControl.
8. Start C:\prgswrk\test\trgdb\sports with ProControl.
9. Stop C:\prgsw\proddb\sports
10. Stop C:\prgswrk\test\trgdb\sports.
11. Trying to start C:\prgswrk\proddb\sports again then results in the 606:
Extent C:\prgswrk\test\proddb\sports.d1 has a different last opened date. (606)
FIX:
1. Restore a good backup.
2. Always ensure that the correct st file is being used with prostrct repair.