Kbase P25360: Problem adding data to a database after adding a variable extent.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/01/2009 |
|
Status: Verified
SYMPTOM(s):
Problem adding data to a database after adding a variable extent.
Ran prostrct create to add a variable extent and ended up with two variables rather than fixing the pre-existing one.
Database add extent: ERROR adding extent: . (6976)
Length of the <data extent> is one block which is too small to be fixed.
When adding data to the database, the database comes down.
bkioRead:Insufficient disk space during read, fd 97, len 8192
, offset <>, file <>. (9450)
FACT(s) (Environment):
Solaris SPARC 7
Progress 9.x
CAUSE:
There are two variable extents and the first one is 1K in size.
Database expects an extent size with a minimum of 32 K and will not write to the 1K extent.
FIX:
1. Backup the current database files.
2 Remove the empty variable extent.
3. Run prostrct remove d "Area where variable extent was initially added".
4. Run prostrct list dbname.
5. Place .st file in a new directory that has the space to house this database.
6. Modify this structure file to the new location with the desired structure.
7. Run prostrct create dbname with the same name, and the same blocksize.
8. Run prostrct list dbname to verify the expected structure.
9. Then run procopy <path to original db> <path to new db of the same name>.
10. Delete/remove/rename the old database files.
11. Then cp the new files into the location of the old files.
12. Modify the paths in the new structure file to agree with the original locations.
13 Run prostrct repair dbname.
14. Run prostrct list dbname to verify that the new db sees the correct structure.
15. Start database in single user mode to test.
Run pro dbname.