| Subject | Re: Corruption of firebird db |
|---|---|
| Author | jstahl80 |
| Post date | 2006-03-28T08:36Z |
--- In firebird-support@yahoogroups.com, BogusÅaw Brandys
<brandys@...> wrote:
27.03.2006 13:01:29 INFO: Open database files:
F:\P2_DB\firebird\DBA6190.defekt060324.FDB
27.03.2006 13:01:29 INFO: Analyzing database low-level structures...
27.03.2006 13:01:29 INFO: Process database file #1 of 1 files.
27.03.2006 15:37:00 INFO: Actual PageCount: 1442463 found in
database
27.03.2006 15:37:00 INFO: ====== DATABASE IS READY FOR DIAGNOSE AND
REPAIR. ====
27.03.2006 15:37:00 INFO: ====== Now choose "Diagnose"
or "Repair". ====
27.03.2006 15:41:36 INFO: ------------------- Starting diagnose
27.03.2006 15:41:36 INFO: Running procedure: Header page check
27.03.2006 15:41:36 INFO: ODS Major = 10
27.03.2006 15:41:36 INFO: ODS Minor = 1
27.03.2006 15:41:36 INFO: PageSize is Ok = 8192
27.03.2006 15:41:36 INFO: Header page check: Ok
27.03.2006 15:41:36 INFO: Running procedure: Checking of RDB$Pages
consistency
27.03.2006 15:41:52 ERROR: Page with #1442489 is over the end of
file.
27.03.2006 15:41:52 ERROR: Possible error in next TIP page
27.03.2006 15:41:52 ERROR: Page with #1442489 is over the end of
file.
27.03.2006 15:41:52 ERROR: Error in RDB$pages - wrong (missing?)
page #1442489 pageType = 3 pageSequence = 302 relationID = 0
27.03.2006 15:41:52 INFO: RDB$Pages checking: found 1 errors
27.03.2006 15:41:52 INFO: Running procedure: Low-level check of all
relations
27.03.2006 15:41:52 INFO: Relation RDB$PAGES (0) is OK
27.03.2006 15:41:52 INFO: Relation RDB$DATABASE (1) is OK
27.03.2006 15:41:52 INFO: Relation RDB$FILES (10) is OK
27.03.2006 15:41:52 INFO: Relation RDB$TYPES (11) is OK
27.03.2006 15:41:52 INFO: Relation RDB$TRIGGERS (12) is OK
27.03.2006 15:41:52 INFO: Relation SYS (128) is OK
27.03.2006 15:41:52 INFO: Relation WB_ARTEN (129) is OK
27.03.2006 15:41:52 INFO: Relation RDB$DEPENDENCIES (13) is OK
27.03.2006 15:41:52 INFO: Relation STATIONEN (130) is OK
27.03.2006 15:41:52 INFO: Relation WB_PRG (131) is OK
27.03.2006 15:41:52 INFO: Relation WB_SCHRITT (132) is OK
27.03.2006 15:41:57 INFO: Relation HMAG_OUTPUT (133) is OK
27.03.2006 15:41:57 INFO: Relation WB_SCHR_STAT (134) is OK
27.03.2006 15:42:34 INFO: Relation HMAG_OUTPUT_OBJECTS (135) is OK
27.03.2006 15:44:29 INFO: Relation CH_DATEN (136) is OK
27.03.2006 15:44:32 INFO: Relation CH_NR_POOL (137) is OK
27.03.2006 15:44:36 INFO: Relation OBJECTMAP (138) is OK
27.03.2006 15:46:02 INFO: Relation WB_PRG_RUN (139) is OK
27.03.2006 15:46:02 INFO: Relation RDB$FUNCTIONS (14) is OK
27.03.2006 15:53:03 INFO: Relation WB_SCHRITT_RUN (140) is OK
27.03.2006 15:58:39 INFO: Relation WB_SCHR_RUN_STAT (141) is OK
27.03.2006 16:01:34 INFO: Relation AUFTRAGS_DATEN_RUN (142) is OK
27.03.2006 16:01:34 INFO: Relation CONTAINER_RUN (143) is OK
27.03.2006 16:01:34 INFO: Relation PRUEFDATEN_RUN (144) is OK
27.03.2006 18:09:16 ERROR: Error on pointer page #1439392: wrong
data page link over the end of file 1442475
27.03.2006 18:09:16 ERROR: Error on pointer page #1439392: wrong
data page link over the end of file 1442478
27.03.2006 18:09:16 INFO: Pointer page #1439392 checking: found 2
errors.
27.03.2006 18:09:16 ERROR: Error in checking relation #145 Found 1
errors.
27.03.2006 18:09:18 INFO: Relation CMD (145) is CORRUPT
27.03.2006 18:09:19 INFO: Relation CH_POS (146) is OK
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442464
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442466
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442467
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442468
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442471
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442472
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442474
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442476
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442481
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442482
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442483
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442484
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442486
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442488
27.03.2006 18:09:34 INFO: Pointer page #196 checking: found 14
errors.
27.03.2006 18:09:34 ERROR: Error in checking relation #147 Found 1
errors.
27.03.2006 18:09:34 INFO: Relation CH_POS_CHARGE (147) is CORRUPT
27.03.2006 18:09:34 INFO: Relation CHP_GROUP (148) is OK
27.03.2006 18:09:34 INFO: Relation CHP_GROUP_MEMBER (149) is OK
27.03.2006 18:09:34 INFO: Relation RDB$FUNCTION_ARGUMENTS (15) is OK
27.03.2006 18:09:54 INFO: Relation JOBQUEUE (150) is OK
27.03.2006 18:09:54 INFO: Relation MESSGENQUEUE (151) is OK
27.03.2006 18:09:54 INFO: Relation PRODUKT_PLAN (152) is OK
27.03.2006 18:09:54 INFO: Relation TEILE (153) is OK
27.03.2006 18:09:54 INFO: Relation TEILE_WB_PRG (154) is OK
27.03.2006 18:09:54 INFO: Relation KUNDE (155) is OK
27.03.2006 18:09:54 INFO: Relation PROZESS (156) is OK
27.03.2006 18:09:54 INFO: Relation A_AUFTRAGS_DATEN (157) is OK
27.03.2006 18:09:55 INFO: Relation A_CONTAINER (158) is OK
27.03.2006 18:09:55 INFO: Relation R_ROST (159) is OK
27.03.2006 18:09:55 INFO: Relation RDB$FILTERS (16) is OK
27.03.2006 18:09:55 INFO: Relation R_AUFTRAGS_DATEN (160) is OK
27.03.2006 18:09:55 INFO: Relation R_CONTAINER (161) is OK
27.03.2006 18:09:55 INFO: Relation V_ROST (162) is OK
27.03.2006 18:09:55 INFO: Relation V_AUFTRAGS_DATEN (163) is OK
27.03.2006 18:09:55 INFO: Relation V_CONTAINER (164) is OK
27.03.2006 18:09:55 INFO: Relation VAXOUT (165) is OK
27.03.2006 18:09:55 INFO: Relation DATALOGBOOK (166) is OK
27.03.2006 18:09:55 INFO: Relation QWIN_DATALOGBOOK (167) is OK
27.03.2006 18:09:55 INFO: Relation QWIN_ROST (168) is OK
27.03.2006 18:09:55 INFO: Relation QWIN_AUFTRAGS_DATEN (169) is OK
27.03.2006 18:09:55 INFO: Relation RDB$TRIGGER_MESSAGES (17) is OK
27.03.2006 18:09:55 INFO: Relation HMAG_INPUT (170) is OK
27.03.2006 18:11:04 INFO: Relation MESSWERTE_HEADER (171) is OK
27.03.2006 18:40:27 INFO: Relation MESSWERTE (172) is OK
27.03.2006 18:41:30 INFO: Relation OBJECT_SUMMARY (174) is OK
27.03.2006 18:41:30 INFO: Relation KEY_NUM (179) is OK
27.03.2006 18:41:30 INFO: Relation RDB$USER_PRIVILEGES (18) is OK
27.03.2006 18:41:30 INFO: Relation TEST_SYS (184) is OK
27.03.2006 18:41:30 INFO: Relation TEST_KEY_NUM (185) is OK
27.03.2006 18:41:31 INFO: Relation TEST_XDATA (186) is OK
27.03.2006 18:41:31 INFO: Relation RDB$TRANSACTIONS (19) is OK
27.03.2006 18:41:31 INFO: Relation RDB$FIELDS (2) is OK
27.03.2006 18:41:31 INFO: Relation RDB$GENERATORS (20) is OK
27.03.2006 18:41:31 INFO: Relation RDB$FIELD_DIMENSIONS (21) is OK
27.03.2006 18:41:31 INFO: Relation RDB$RELATION_CONSTRAINTS (22) is
OK
27.03.2006 18:41:32 INFO: Relation RDB$REF_CONSTRAINTS (23) is OK
27.03.2006 18:41:32 INFO: Relation RDB$CHECK_CONSTRAINTS (24) is OK
27.03.2006 18:41:32 INFO: Relation RDB$LOG_FILES (25) is OK
27.03.2006 18:41:32 INFO: Relation RDB$PROCEDURES (26) is OK
27.03.2006 18:41:32 INFO: Relation RDB$PROCEDURE_PARAMETERS (27) is
OK
27.03.2006 18:41:32 INFO: Relation RDB$CHARACTER_SETS (28) is OK
27.03.2006 18:41:32 INFO: Relation RDB$COLLATIONS (29) is OK
27.03.2006 18:41:32 INFO: Relation RDB$INDEX_SEGMENTS (3) is OK
27.03.2006 18:41:32 INFO: Relation RDB$EXCEPTIONS (30) is OK
27.03.2006 18:41:32 INFO: Relation RDB$ROLES (31) is OK
27.03.2006 18:41:32 INFO: Relation RDB$INDICES (4) is OK
27.03.2006 18:41:32 INFO: Relation RDB$RELATION_FIELDS (5) is OK
27.03.2006 18:41:32 INFO: Relation RDB$RELATIONS (6) is OK
27.03.2006 18:41:32 INFO: Relation RDB$VIEW_RELATIONS (7) is OK
27.03.2006 18:41:32 INFO: Relation RDB$FORMATS (8) is OK
27.03.2006 18:41:32 INFO: Relation RDB$SECURITY_CLASSES (9) is OK
27.03.2006 18:41:32 ERROR: All relations checking found 2 errors.
27.03.2006 18:41:32 INFO: Running procedure: Low-level check of all
indices
27.03.2006 18:41:32 INFO: Indices check of RDB$PAGES (0): OK
27.03.2006 18:41:32 INFO: Indices check of RDB$DATABASE (1): OK
27.03.2006 18:41:32 INFO: Indices check of RDB$FILES (10): OK
27.03.2006 18:41:32 INFO: Indices check of RDB$TYPES (11): OK
27.03.2006 18:41:32 INFO: Indices check of RDB$TRIGGERS (12): OK
27.03.2006 18:41:32 INFO: Indices check of SYS (128): OK
27.03.2006 18:41:32 INFO: Indices check of WB_ARTEN (129): OK
27.03.2006 18:41:32 INFO: Indices check of RDB$DEPENDENCIES (13): OK
27.03.2006 18:41:33 INFO: Indices check of STATIONEN (130): OK
27.03.2006 18:41:33 INFO: Indices check of WB_PRG (131): OK
27.03.2006 18:41:33 INFO: Indices check of WB_SCHRITT (132): OK
27.03.2006 18:41:33 INFO: Indices check of HMAG_OUTPUT (133): OK
27.03.2006 18:41:33 INFO: Indices check of WB_SCHR_STAT (134): OK
27.03.2006 18:41:35 INFO: Indices check of HMAG_OUTPUT_OBJECTS
(135): OK
27.03.2006 18:41:56 INFO: Indices check of CH_DATEN (136): OK
27.03.2006 18:41:57 INFO: Indices check of CH_NR_POOL (137): OK
27.03.2006 18:41:58 INFO: Indices check of OBJECTMAP (138): OK
27.03.2006 18:42:20 INFO: Indices check of WB_PRG_RUN (139): OK
27.03.2006 18:42:20 INFO: Indices check of RDB$FUNCTIONS (14): OK
27.03.2006 18:43:19 INFO: Indices check of WB_SCHRITT_RUN (140): OK
27.03.2006 18:44:32 INFO: Indices check of WB_SCHR_RUN_STAT (141): OK
27.03.2006 18:45:02 INFO: Indices check of AUFTRAGS_DATEN_RUN (142):
OK
27.03.2006 18:45:02 INFO: Indices check of CONTAINER_RUN (143): OK
27.03.2006 18:45:02 INFO: Indices check of PRUEFDATEN_RUN (144): OK
27.03.2006 19:22:04 INFO: Indices check of CMD (145): OK
27.03.2006 19:22:04 INFO: Indices check of CH_POS (146): OK
27.03.2006 19:22:09 INFO: Indices check of CH_POS_CHARGE (147): OK
27.03.2006 19:22:09 INFO: Indices check of CHP_GROUP (148): OK
27.03.2006 19:22:09 INFO: Indices check of CHP_GROUP_MEMBER (149): OK
27.03.2006 19:22:09 INFO: Indices check of RDB$FUNCTION_ARGUMENTS
(15): OK
27.03.2006 19:22:09 INFO: Indices check of JOBQUEUE (150): OK
27.03.2006 19:22:09 INFO: Indices check of MESSGENQUEUE (151): OK
27.03.2006 19:22:09 INFO: Indices check of PRODUKT_PLAN (152): OK
27.03.2006 19:22:09 INFO: Indices check of TEILE (153): OK
27.03.2006 19:22:09 INFO: Indices check of TEILE_WB_PRG (154): OK
27.03.2006 19:22:09 INFO: Indices check of KUNDE (155): OK
27.03.2006 19:22:09 INFO: Indices check of PROZESS (156): OK
27.03.2006 19:22:09 INFO: Indices check of A_AUFTRAGS_DATEN (157): OK
27.03.2006 19:22:09 INFO: Indices check of A_CONTAINER (158): OK
27.03.2006 19:22:09 INFO: Indices check of R_ROST (159): OK
27.03.2006 19:22:09 INFO: Indices check of RDB$FILTERS (16): OK
27.03.2006 19:22:09 INFO: Indices check of R_AUFTRAGS_DATEN (160): OK
27.03.2006 19:22:09 INFO: Indices check of R_CONTAINER (161): OK
27.03.2006 19:22:09 INFO: Indices check of V_ROST (162): OK
27.03.2006 19:22:09 INFO: Indices check of V_AUFTRAGS_DATEN (163): OK
27.03.2006 19:22:09 INFO: Indices check of V_CONTAINER (164): OK
27.03.2006 19:22:09 INFO: Indices check of VAXOUT (165): OK
27.03.2006 19:22:09 INFO: Indices check of DATALOGBOOK (166): OK
27.03.2006 19:22:10 INFO: Indices check of QWIN_DATALOGBOOK (167): OK
27.03.2006 19:22:10 INFO: Indices check of QWIN_ROST (168): OK
27.03.2006 19:22:10 INFO: Indices check of QWIN_AUFTRAGS_DATEN
(169): OK
27.03.2006 19:22:10 INFO: Indices check of RDB$TRIGGER_MESSAGES
(17): OK
27.03.2006 19:22:10 INFO: Indices check of HMAG_INPUT (170): OK
27.03.2006 19:22:29 INFO: Indices check of MESSWERTE_HEADER (171): OK
27.03.2006 19:27:09 INFO: Indices check of MESSWERTE (172): OK
27.03.2006 19:27:33 INFO: Indices check of OBJECT_SUMMARY (174): OK
27.03.2006 19:27:33 INFO: Indices check of KEY_NUM (179): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$USER_PRIVILEGES (18):
OK
27.03.2006 19:27:33 INFO: Indices check of TEST_SYS (184): OK
27.03.2006 19:27:33 INFO: Indices check of TEST_KEY_NUM (185): OK
27.03.2006 19:27:33 INFO: Indices check of TEST_XDATA (186): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$TRANSACTIONS (19): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$FIELDS (2): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$GENERATORS (20): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$FIELD_DIMENSIONS
(21): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$RELATION_CONSTRAINTS
(22): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$REF_CONSTRAINTS (23):
OK
27.03.2006 19:27:33 INFO: Indices check of RDB$CHECK_CONSTRAINTS
(24): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$LOG_FILES (25): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$PROCEDURES (26): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$PROCEDURE_PARAMETERS
(27): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$CHARACTER_SETS (28):
OK
27.03.2006 19:27:33 INFO: Indices check of RDB$COLLATIONS (29): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$INDEX_SEGMENTS (3): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$EXCEPTIONS (30): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$ROLES (31): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$INDICES (4): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$RELATION_FIELDS (5):
OK
27.03.2006 19:27:33 INFO: Indices check of RDB$RELATIONS (6): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$VIEW_RELATIONS (7): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$FORMATS (8): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$SECURITY_CLASSES (9):
OK
27.03.2006 19:27:33 INFO: Low-level check of all indices: Ok
27.03.2006 19:27:33 INFO: ------------------- Finished diagnose-----
---
27.03.2006 19:27:33 INFO:
27.03.2006 19:27:33 INFO: =================== IMPORTANT!
===============
27.03.2006 19:27:33 INFO: == Please send this diagnostics log (zip
it, please) to support@...
27.03.2006 19:27:33 INFO: == if you intend to order IBFirstAID
Ambulance!
<brandys@...> wrote:
>out of
> jstahl80 wrote:
> > I have had 3 times now database corruption of an FB1.5 database
> > after these happenings:
> >
> > 1. The disk containing the DB is running low on free space.
> > 2. It seems to me, that as a result of this, the machine runs
> > RAM. Note however, that the swap file is on a different disk.I ran IBFirstAID diagnostic which tells this:
> > 3. After a normal shutdown of the machine, the database file is
> > corrupt having page pointers pointing behind the EOF.
> >
> > Is such corruption known problem?
> > ...
>
> And ? What is database corruption symptoms ? What gfix says ?
>
>
27.03.2006 13:01:29 INFO: Open database files:
F:\P2_DB\firebird\DBA6190.defekt060324.FDB
27.03.2006 13:01:29 INFO: Analyzing database low-level structures...
27.03.2006 13:01:29 INFO: Process database file #1 of 1 files.
27.03.2006 15:37:00 INFO: Actual PageCount: 1442463 found in
database
27.03.2006 15:37:00 INFO: ====== DATABASE IS READY FOR DIAGNOSE AND
REPAIR. ====
27.03.2006 15:37:00 INFO: ====== Now choose "Diagnose"
or "Repair". ====
27.03.2006 15:41:36 INFO: ------------------- Starting diagnose
27.03.2006 15:41:36 INFO: Running procedure: Header page check
27.03.2006 15:41:36 INFO: ODS Major = 10
27.03.2006 15:41:36 INFO: ODS Minor = 1
27.03.2006 15:41:36 INFO: PageSize is Ok = 8192
27.03.2006 15:41:36 INFO: Header page check: Ok
27.03.2006 15:41:36 INFO: Running procedure: Checking of RDB$Pages
consistency
27.03.2006 15:41:52 ERROR: Page with #1442489 is over the end of
file.
27.03.2006 15:41:52 ERROR: Possible error in next TIP page
27.03.2006 15:41:52 ERROR: Page with #1442489 is over the end of
file.
27.03.2006 15:41:52 ERROR: Error in RDB$pages - wrong (missing?)
page #1442489 pageType = 3 pageSequence = 302 relationID = 0
27.03.2006 15:41:52 INFO: RDB$Pages checking: found 1 errors
27.03.2006 15:41:52 INFO: Running procedure: Low-level check of all
relations
27.03.2006 15:41:52 INFO: Relation RDB$PAGES (0) is OK
27.03.2006 15:41:52 INFO: Relation RDB$DATABASE (1) is OK
27.03.2006 15:41:52 INFO: Relation RDB$FILES (10) is OK
27.03.2006 15:41:52 INFO: Relation RDB$TYPES (11) is OK
27.03.2006 15:41:52 INFO: Relation RDB$TRIGGERS (12) is OK
27.03.2006 15:41:52 INFO: Relation SYS (128) is OK
27.03.2006 15:41:52 INFO: Relation WB_ARTEN (129) is OK
27.03.2006 15:41:52 INFO: Relation RDB$DEPENDENCIES (13) is OK
27.03.2006 15:41:52 INFO: Relation STATIONEN (130) is OK
27.03.2006 15:41:52 INFO: Relation WB_PRG (131) is OK
27.03.2006 15:41:52 INFO: Relation WB_SCHRITT (132) is OK
27.03.2006 15:41:57 INFO: Relation HMAG_OUTPUT (133) is OK
27.03.2006 15:41:57 INFO: Relation WB_SCHR_STAT (134) is OK
27.03.2006 15:42:34 INFO: Relation HMAG_OUTPUT_OBJECTS (135) is OK
27.03.2006 15:44:29 INFO: Relation CH_DATEN (136) is OK
27.03.2006 15:44:32 INFO: Relation CH_NR_POOL (137) is OK
27.03.2006 15:44:36 INFO: Relation OBJECTMAP (138) is OK
27.03.2006 15:46:02 INFO: Relation WB_PRG_RUN (139) is OK
27.03.2006 15:46:02 INFO: Relation RDB$FUNCTIONS (14) is OK
27.03.2006 15:53:03 INFO: Relation WB_SCHRITT_RUN (140) is OK
27.03.2006 15:58:39 INFO: Relation WB_SCHR_RUN_STAT (141) is OK
27.03.2006 16:01:34 INFO: Relation AUFTRAGS_DATEN_RUN (142) is OK
27.03.2006 16:01:34 INFO: Relation CONTAINER_RUN (143) is OK
27.03.2006 16:01:34 INFO: Relation PRUEFDATEN_RUN (144) is OK
27.03.2006 18:09:16 ERROR: Error on pointer page #1439392: wrong
data page link over the end of file 1442475
27.03.2006 18:09:16 ERROR: Error on pointer page #1439392: wrong
data page link over the end of file 1442478
27.03.2006 18:09:16 INFO: Pointer page #1439392 checking: found 2
errors.
27.03.2006 18:09:16 ERROR: Error in checking relation #145 Found 1
errors.
27.03.2006 18:09:18 INFO: Relation CMD (145) is CORRUPT
27.03.2006 18:09:19 INFO: Relation CH_POS (146) is OK
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442464
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442466
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442467
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442468
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442471
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442472
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442474
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442476
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442481
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442482
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442483
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442484
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442486
27.03.2006 18:09:34 ERROR: Error on pointer page #196: wrong data
page link over the end of file 1442488
27.03.2006 18:09:34 INFO: Pointer page #196 checking: found 14
errors.
27.03.2006 18:09:34 ERROR: Error in checking relation #147 Found 1
errors.
27.03.2006 18:09:34 INFO: Relation CH_POS_CHARGE (147) is CORRUPT
27.03.2006 18:09:34 INFO: Relation CHP_GROUP (148) is OK
27.03.2006 18:09:34 INFO: Relation CHP_GROUP_MEMBER (149) is OK
27.03.2006 18:09:34 INFO: Relation RDB$FUNCTION_ARGUMENTS (15) is OK
27.03.2006 18:09:54 INFO: Relation JOBQUEUE (150) is OK
27.03.2006 18:09:54 INFO: Relation MESSGENQUEUE (151) is OK
27.03.2006 18:09:54 INFO: Relation PRODUKT_PLAN (152) is OK
27.03.2006 18:09:54 INFO: Relation TEILE (153) is OK
27.03.2006 18:09:54 INFO: Relation TEILE_WB_PRG (154) is OK
27.03.2006 18:09:54 INFO: Relation KUNDE (155) is OK
27.03.2006 18:09:54 INFO: Relation PROZESS (156) is OK
27.03.2006 18:09:54 INFO: Relation A_AUFTRAGS_DATEN (157) is OK
27.03.2006 18:09:55 INFO: Relation A_CONTAINER (158) is OK
27.03.2006 18:09:55 INFO: Relation R_ROST (159) is OK
27.03.2006 18:09:55 INFO: Relation RDB$FILTERS (16) is OK
27.03.2006 18:09:55 INFO: Relation R_AUFTRAGS_DATEN (160) is OK
27.03.2006 18:09:55 INFO: Relation R_CONTAINER (161) is OK
27.03.2006 18:09:55 INFO: Relation V_ROST (162) is OK
27.03.2006 18:09:55 INFO: Relation V_AUFTRAGS_DATEN (163) is OK
27.03.2006 18:09:55 INFO: Relation V_CONTAINER (164) is OK
27.03.2006 18:09:55 INFO: Relation VAXOUT (165) is OK
27.03.2006 18:09:55 INFO: Relation DATALOGBOOK (166) is OK
27.03.2006 18:09:55 INFO: Relation QWIN_DATALOGBOOK (167) is OK
27.03.2006 18:09:55 INFO: Relation QWIN_ROST (168) is OK
27.03.2006 18:09:55 INFO: Relation QWIN_AUFTRAGS_DATEN (169) is OK
27.03.2006 18:09:55 INFO: Relation RDB$TRIGGER_MESSAGES (17) is OK
27.03.2006 18:09:55 INFO: Relation HMAG_INPUT (170) is OK
27.03.2006 18:11:04 INFO: Relation MESSWERTE_HEADER (171) is OK
27.03.2006 18:40:27 INFO: Relation MESSWERTE (172) is OK
27.03.2006 18:41:30 INFO: Relation OBJECT_SUMMARY (174) is OK
27.03.2006 18:41:30 INFO: Relation KEY_NUM (179) is OK
27.03.2006 18:41:30 INFO: Relation RDB$USER_PRIVILEGES (18) is OK
27.03.2006 18:41:30 INFO: Relation TEST_SYS (184) is OK
27.03.2006 18:41:30 INFO: Relation TEST_KEY_NUM (185) is OK
27.03.2006 18:41:31 INFO: Relation TEST_XDATA (186) is OK
27.03.2006 18:41:31 INFO: Relation RDB$TRANSACTIONS (19) is OK
27.03.2006 18:41:31 INFO: Relation RDB$FIELDS (2) is OK
27.03.2006 18:41:31 INFO: Relation RDB$GENERATORS (20) is OK
27.03.2006 18:41:31 INFO: Relation RDB$FIELD_DIMENSIONS (21) is OK
27.03.2006 18:41:31 INFO: Relation RDB$RELATION_CONSTRAINTS (22) is
OK
27.03.2006 18:41:32 INFO: Relation RDB$REF_CONSTRAINTS (23) is OK
27.03.2006 18:41:32 INFO: Relation RDB$CHECK_CONSTRAINTS (24) is OK
27.03.2006 18:41:32 INFO: Relation RDB$LOG_FILES (25) is OK
27.03.2006 18:41:32 INFO: Relation RDB$PROCEDURES (26) is OK
27.03.2006 18:41:32 INFO: Relation RDB$PROCEDURE_PARAMETERS (27) is
OK
27.03.2006 18:41:32 INFO: Relation RDB$CHARACTER_SETS (28) is OK
27.03.2006 18:41:32 INFO: Relation RDB$COLLATIONS (29) is OK
27.03.2006 18:41:32 INFO: Relation RDB$INDEX_SEGMENTS (3) is OK
27.03.2006 18:41:32 INFO: Relation RDB$EXCEPTIONS (30) is OK
27.03.2006 18:41:32 INFO: Relation RDB$ROLES (31) is OK
27.03.2006 18:41:32 INFO: Relation RDB$INDICES (4) is OK
27.03.2006 18:41:32 INFO: Relation RDB$RELATION_FIELDS (5) is OK
27.03.2006 18:41:32 INFO: Relation RDB$RELATIONS (6) is OK
27.03.2006 18:41:32 INFO: Relation RDB$VIEW_RELATIONS (7) is OK
27.03.2006 18:41:32 INFO: Relation RDB$FORMATS (8) is OK
27.03.2006 18:41:32 INFO: Relation RDB$SECURITY_CLASSES (9) is OK
27.03.2006 18:41:32 ERROR: All relations checking found 2 errors.
27.03.2006 18:41:32 INFO: Running procedure: Low-level check of all
indices
27.03.2006 18:41:32 INFO: Indices check of RDB$PAGES (0): OK
27.03.2006 18:41:32 INFO: Indices check of RDB$DATABASE (1): OK
27.03.2006 18:41:32 INFO: Indices check of RDB$FILES (10): OK
27.03.2006 18:41:32 INFO: Indices check of RDB$TYPES (11): OK
27.03.2006 18:41:32 INFO: Indices check of RDB$TRIGGERS (12): OK
27.03.2006 18:41:32 INFO: Indices check of SYS (128): OK
27.03.2006 18:41:32 INFO: Indices check of WB_ARTEN (129): OK
27.03.2006 18:41:32 INFO: Indices check of RDB$DEPENDENCIES (13): OK
27.03.2006 18:41:33 INFO: Indices check of STATIONEN (130): OK
27.03.2006 18:41:33 INFO: Indices check of WB_PRG (131): OK
27.03.2006 18:41:33 INFO: Indices check of WB_SCHRITT (132): OK
27.03.2006 18:41:33 INFO: Indices check of HMAG_OUTPUT (133): OK
27.03.2006 18:41:33 INFO: Indices check of WB_SCHR_STAT (134): OK
27.03.2006 18:41:35 INFO: Indices check of HMAG_OUTPUT_OBJECTS
(135): OK
27.03.2006 18:41:56 INFO: Indices check of CH_DATEN (136): OK
27.03.2006 18:41:57 INFO: Indices check of CH_NR_POOL (137): OK
27.03.2006 18:41:58 INFO: Indices check of OBJECTMAP (138): OK
27.03.2006 18:42:20 INFO: Indices check of WB_PRG_RUN (139): OK
27.03.2006 18:42:20 INFO: Indices check of RDB$FUNCTIONS (14): OK
27.03.2006 18:43:19 INFO: Indices check of WB_SCHRITT_RUN (140): OK
27.03.2006 18:44:32 INFO: Indices check of WB_SCHR_RUN_STAT (141): OK
27.03.2006 18:45:02 INFO: Indices check of AUFTRAGS_DATEN_RUN (142):
OK
27.03.2006 18:45:02 INFO: Indices check of CONTAINER_RUN (143): OK
27.03.2006 18:45:02 INFO: Indices check of PRUEFDATEN_RUN (144): OK
27.03.2006 19:22:04 INFO: Indices check of CMD (145): OK
27.03.2006 19:22:04 INFO: Indices check of CH_POS (146): OK
27.03.2006 19:22:09 INFO: Indices check of CH_POS_CHARGE (147): OK
27.03.2006 19:22:09 INFO: Indices check of CHP_GROUP (148): OK
27.03.2006 19:22:09 INFO: Indices check of CHP_GROUP_MEMBER (149): OK
27.03.2006 19:22:09 INFO: Indices check of RDB$FUNCTION_ARGUMENTS
(15): OK
27.03.2006 19:22:09 INFO: Indices check of JOBQUEUE (150): OK
27.03.2006 19:22:09 INFO: Indices check of MESSGENQUEUE (151): OK
27.03.2006 19:22:09 INFO: Indices check of PRODUKT_PLAN (152): OK
27.03.2006 19:22:09 INFO: Indices check of TEILE (153): OK
27.03.2006 19:22:09 INFO: Indices check of TEILE_WB_PRG (154): OK
27.03.2006 19:22:09 INFO: Indices check of KUNDE (155): OK
27.03.2006 19:22:09 INFO: Indices check of PROZESS (156): OK
27.03.2006 19:22:09 INFO: Indices check of A_AUFTRAGS_DATEN (157): OK
27.03.2006 19:22:09 INFO: Indices check of A_CONTAINER (158): OK
27.03.2006 19:22:09 INFO: Indices check of R_ROST (159): OK
27.03.2006 19:22:09 INFO: Indices check of RDB$FILTERS (16): OK
27.03.2006 19:22:09 INFO: Indices check of R_AUFTRAGS_DATEN (160): OK
27.03.2006 19:22:09 INFO: Indices check of R_CONTAINER (161): OK
27.03.2006 19:22:09 INFO: Indices check of V_ROST (162): OK
27.03.2006 19:22:09 INFO: Indices check of V_AUFTRAGS_DATEN (163): OK
27.03.2006 19:22:09 INFO: Indices check of V_CONTAINER (164): OK
27.03.2006 19:22:09 INFO: Indices check of VAXOUT (165): OK
27.03.2006 19:22:09 INFO: Indices check of DATALOGBOOK (166): OK
27.03.2006 19:22:10 INFO: Indices check of QWIN_DATALOGBOOK (167): OK
27.03.2006 19:22:10 INFO: Indices check of QWIN_ROST (168): OK
27.03.2006 19:22:10 INFO: Indices check of QWIN_AUFTRAGS_DATEN
(169): OK
27.03.2006 19:22:10 INFO: Indices check of RDB$TRIGGER_MESSAGES
(17): OK
27.03.2006 19:22:10 INFO: Indices check of HMAG_INPUT (170): OK
27.03.2006 19:22:29 INFO: Indices check of MESSWERTE_HEADER (171): OK
27.03.2006 19:27:09 INFO: Indices check of MESSWERTE (172): OK
27.03.2006 19:27:33 INFO: Indices check of OBJECT_SUMMARY (174): OK
27.03.2006 19:27:33 INFO: Indices check of KEY_NUM (179): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$USER_PRIVILEGES (18):
OK
27.03.2006 19:27:33 INFO: Indices check of TEST_SYS (184): OK
27.03.2006 19:27:33 INFO: Indices check of TEST_KEY_NUM (185): OK
27.03.2006 19:27:33 INFO: Indices check of TEST_XDATA (186): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$TRANSACTIONS (19): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$FIELDS (2): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$GENERATORS (20): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$FIELD_DIMENSIONS
(21): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$RELATION_CONSTRAINTS
(22): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$REF_CONSTRAINTS (23):
OK
27.03.2006 19:27:33 INFO: Indices check of RDB$CHECK_CONSTRAINTS
(24): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$LOG_FILES (25): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$PROCEDURES (26): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$PROCEDURE_PARAMETERS
(27): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$CHARACTER_SETS (28):
OK
27.03.2006 19:27:33 INFO: Indices check of RDB$COLLATIONS (29): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$INDEX_SEGMENTS (3): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$EXCEPTIONS (30): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$ROLES (31): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$INDICES (4): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$RELATION_FIELDS (5):
OK
27.03.2006 19:27:33 INFO: Indices check of RDB$RELATIONS (6): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$VIEW_RELATIONS (7): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$FORMATS (8): OK
27.03.2006 19:27:33 INFO: Indices check of RDB$SECURITY_CLASSES (9):
OK
27.03.2006 19:27:33 INFO: Low-level check of all indices: Ok
27.03.2006 19:27:33 INFO: ------------------- Finished diagnose-----
---
27.03.2006 19:27:33 INFO:
27.03.2006 19:27:33 INFO: =================== IMPORTANT!
===============
27.03.2006 19:27:33 INFO: == Please send this diagnostics log (zip
it, please) to support@...
27.03.2006 19:27:33 INFO: == if you intend to order IBFirstAID
Ambulance!