Subject | Re: is Firebird the good or wrong choice ? |
---|---|
Author | svanderclock |
Post date | 2010-04-28T18:03:58Z |
dear vlad,
i don't know if it's can help you, but find below the content of the firebird.log file AFTER i run a gfix -v -f on the database.
notice than even with the index corrupted the database seam to work (ie in FB2.5 snapshot), but in fb 2.1, if i don't fix the error it's crash again imediatly after i try to reopen the service...
Wed Apr 28 08:21:39 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 2 is corrupt on page 3078003 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table PROPERTY_PICTURE (167)
Wed Apr 28 08:21:39 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 2 is corrupt on page 3078003 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table PROPERTY_PICTURE (167)
Wed Apr 28 08:22:18 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 1 is corrupt on page 3615589 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:22:18 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 1 is corrupt on page 3615589 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:22:19 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 2 is corrupt on page 3234187 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:22:19 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 2 is corrupt on page 3234187 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:22:19 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 2 is corrupt on page 3538442 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:22:19 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 2 is corrupt on page 3538442 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:22:26 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 6 is corrupt on page 3283951 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:22:26 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 6 is corrupt on page 3283951 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:22:28 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 7 is corrupt on page 2825101 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:22:28 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 7 is corrupt on page 2825101 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:22:56 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 12 is corrupt on page 2825721 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:22:56 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 12 is corrupt on page 2829584 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:22:56 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 12 is corrupt on page 2829584 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:23:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 13 is corrupt on page 2837975 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:23:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 13 is corrupt on page 2837975 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:23:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 13 is corrupt on page 2585478 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:23:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 13 is corrupt on page 2585478 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:23:20 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 16 is corrupt on page 2962248 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:23:20 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 16 is corrupt on page 2962248 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:23:41 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 7 is corrupt on page 3198481 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_A_4 (276)
Wed Apr 28 08:23:41 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 7 is corrupt on page 3198481 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FS_A_4 (276)
Wed Apr 28 08:23:52 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 1 is corrupt on page 3539930 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FR_A_2 (302)
Wed Apr 28 08:23:52 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 1 is corrupt on page 3539930 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FR_A_2 (302)
Wed Apr 28 08:23:53 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 2 is corrupt on page 3541425 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FR_A_2 (302)
Wed Apr 28 08:23:53 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 2 is corrupt on page 3541425 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FR_A_2 (302)
Wed Apr 28 08:23:53 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 3 is corrupt on page 3030852 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FR_A_2 (302)
Wed Apr 28 08:23:53 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 3 is corrupt on page 3030852 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FR_A_2 (302)
Wed Apr 28 08:23:56 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 12 is corrupt on page 2962365 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FR_A_2 (302)
Wed Apr 28 08:23:57 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 13 is corrupt on page 3202774 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FR_A_2 (302)
Wed Apr 28 08:23:57 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 13 is corrupt on page 3202774 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FR_A_2 (302)
Wed Apr 28 08:23:57 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 14 is corrupt on page 2273614 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FR_A_2 (302)
Wed Apr 28 08:23:57 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 14 is corrupt on page 2273614 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FR_A_2 (302)
Wed Apr 28 08:24:04 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 10 is corrupt on page 2232271 level 0. File: ..\..\..\src\jrd\validation.cpp, line: 1542
in table TRANSAC_SEARCH_VAC_1 (307)
Wed Apr 28 08:24:06 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 1 is corrupt on page 1342081 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_1 (309)
Wed Apr 28 08:24:06 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 1 is corrupt on page 1342081 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FS_1 (309)
Wed Apr 28 08:24:09 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 7 is corrupt on page 3557529 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_1 (309)
Wed Apr 28 08:24:10 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 8 is corrupt on page 3787423 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_1 (309)
Wed Apr 28 08:24:10 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 8 is corrupt on page 3787423 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FS_1 (309)
Wed Apr 28 08:24:21 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 8 is corrupt on page 2164470 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FR_1 (310)
Wed Apr 28 08:24:21 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 8 is corrupt on page 2164470 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FR_1 (310)
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560946 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560948 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560951 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560952 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560955 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560956 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560958 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560959 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560963 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560964 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560967 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560969 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560970 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560972 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560973 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560975 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560976 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560978 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560979 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560980 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560983 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560985 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560987 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560990 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560993 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560995 is an orphan
thanks for all !
stephane
i don't know if it's can help you, but find below the content of the firebird.log file AFTER i run a gfix -v -f on the database.
notice than even with the index corrupted the database seam to work (ie in FB2.5 snapshot), but in fb 2.1, if i don't fix the error it's crash again imediatly after i try to reopen the service...
Wed Apr 28 08:21:39 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 2 is corrupt on page 3078003 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table PROPERTY_PICTURE (167)
Wed Apr 28 08:21:39 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 2 is corrupt on page 3078003 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table PROPERTY_PICTURE (167)
Wed Apr 28 08:22:18 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 1 is corrupt on page 3615589 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:22:18 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 1 is corrupt on page 3615589 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:22:19 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 2 is corrupt on page 3234187 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:22:19 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 2 is corrupt on page 3234187 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:22:19 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 2 is corrupt on page 3538442 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:22:19 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 2 is corrupt on page 3538442 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:22:26 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 6 is corrupt on page 3283951 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:22:26 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 6 is corrupt on page 3283951 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:22:28 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 7 is corrupt on page 2825101 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:22:28 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 7 is corrupt on page 2825101 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:22:56 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 12 is corrupt on page 2825721 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:22:56 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 12 is corrupt on page 2829584 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:22:56 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 12 is corrupt on page 2829584 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:23:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 13 is corrupt on page 2837975 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:23:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 13 is corrupt on page 2837975 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:23:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 13 is corrupt on page 2585478 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:23:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 13 is corrupt on page 2585478 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:23:20 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 16 is corrupt on page 2962248 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:23:20 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 16 is corrupt on page 2962248 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FS_A_2 (262)
Wed Apr 28 08:23:41 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 7 is corrupt on page 3198481 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_A_4 (276)
Wed Apr 28 08:23:41 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 7 is corrupt on page 3198481 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FS_A_4 (276)
Wed Apr 28 08:23:52 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 1 is corrupt on page 3539930 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FR_A_2 (302)
Wed Apr 28 08:23:52 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 1 is corrupt on page 3539930 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FR_A_2 (302)
Wed Apr 28 08:23:53 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 2 is corrupt on page 3541425 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FR_A_2 (302)
Wed Apr 28 08:23:53 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 2 is corrupt on page 3541425 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FR_A_2 (302)
Wed Apr 28 08:23:53 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 3 is corrupt on page 3030852 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FR_A_2 (302)
Wed Apr 28 08:23:53 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 3 is corrupt on page 3030852 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FR_A_2 (302)
Wed Apr 28 08:23:56 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 12 is corrupt on page 2962365 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FR_A_2 (302)
Wed Apr 28 08:23:57 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 13 is corrupt on page 3202774 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FR_A_2 (302)
Wed Apr 28 08:23:57 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 13 is corrupt on page 3202774 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FR_A_2 (302)
Wed Apr 28 08:23:57 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 14 is corrupt on page 2273614 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FR_A_2 (302)
Wed Apr 28 08:23:57 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 14 is corrupt on page 2273614 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FR_A_2 (302)
Wed Apr 28 08:24:04 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 10 is corrupt on page 2232271 level 0. File: ..\..\..\src\jrd\validation.cpp, line: 1542
in table TRANSAC_SEARCH_VAC_1 (307)
Wed Apr 28 08:24:06 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 1 is corrupt on page 1342081 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_1 (309)
Wed Apr 28 08:24:06 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 1 is corrupt on page 1342081 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FS_1 (309)
Wed Apr 28 08:24:09 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 7 is corrupt on page 3557529 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_1 (309)
Wed Apr 28 08:24:10 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 8 is corrupt on page 3787423 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FS_1 (309)
Wed Apr 28 08:24:10 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 8 is corrupt on page 3787423 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FS_1 (309)
Wed Apr 28 08:24:21 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 8 is corrupt on page 2164470 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1667
in table TRANSAC_SEARCH_RES_FR_1 (310)
Wed Apr 28 08:24:21 2010
Database: C:\DATA\DATA_SAVE.FDB
Index 8 is corrupt on page 2164470 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1657
in table TRANSAC_SEARCH_RES_FR_1 (310)
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560946 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560948 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560951 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560952 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560955 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560956 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560958 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560959 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560963 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560964 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560967 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560969 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560970 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560972 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560973 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560975 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560976 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560978 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560979 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560980 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560983 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560985 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560987 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560990 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560993 is an orphan
Wed Apr 28 08:34:03 2010
Database: C:\DATA\DATA_SAVE.FDB
Page 3560995 is an orphan
thanks for all !
stephane
--- In firebird-support@yahoogroups.com, "hvlad" <hvlad@...> wrote:
>
> > > I looking into index corruptions for a few past days and currently my machine is busy with your test :) Bug with monitoring will be fixed soon, we have few possible solutions for it and we are looking for the best one.
> > >
> >
> > Monitoring tables bug ....
>
> If you don't seen "invalid lock id" error, you could forget about this *very rare* monitoring bug
>
> Regards,
> Vlad
>