1

Topic: Online check with the help fbsvcmgr

Good morning.
There was a suspicion on breakage tables/indexes
fbsvcmgr.... action_validate dbname.... val_tab_incl <table_name>

 03:09:10.72 Validation started
03:09:10.74 Relation 162 (<table_name>)
03:09:10.74 process pointer page 0 of 598
....
05:15:30.26 process pointer page 596 of 598
05:16:00.91 process pointer page 597 of 598
05:16:17.38 Index 1 (PK _ <table_name>)
05:21:35.92 Index 2 (<table_name> _EXP)
05:31:47.19 Index 3 (<table_name> _IDX1)
05:39:44.89 Index 4 (<table_name> _IDX2)
05:59:40.13 Index 4 misses node on page 12569401 level 1
06:10:34.03 Index 5 (<table_name> _OLD_ID)
06:19:43.60 Index 5 misses node on page 12685832 level 1
06:25:32.63 Index 6 (<table_name> _TABLE_NAME)
06:34:15.92 Index 7 (<table_name> _NEW_ID)
06:54:08.12 Index 7 misses node on page 16143028 level 1
07:03:08.63 Relation 162 (<table_name>): 3 ERRORS found
07:03:09.30 Validation finished 

In firebird.log appeared  messages

 <host> Thu Sep 14 5:59:40 AM 2017 Database: <BASE>.gdb Index 4 misses node on page 12569401 level 1 in table <table_name> (162)
<host> Thu Sep 14 5:59:40 AM 2017 Database: <BASE>.gdb Index 5 misses node on page 12685832 level 1 in table <table_name> (162)
<host> Thu Sep 14 5:59:40 AM 2017 Database: <BASE>.gdb Index 7 misses node on page 16143028 level 1 in table <table_name> (162)

FB 2.5.6_27020x32 in a DB of all of pages 19704960 (16k)
In the description it is specified:
"Database validation allows to run low-level checks of consistency of on-disk
structures and even to fix some minor corruptions. "

Question: whether  these errors or there there should be an additional report?

2

Re: Online check with the help fbsvcmgr

zigorzn;
online check not  errors but only diagnoses

3

Re: Online check with the help fbsvcmgr

And how " even to fix some minor corruptions "? On it in any way it is not informed?

4

Re: Online check with the help fbsvcmgr

zigorzn;
It is necessary to wait for Vlad. Only it can explain that for minor corruptions
The second time  make, if errors are not present means was corrected

5

Re: Online check with the help fbsvcmgr

zigorzn wrote:

in firebird.log appeared  messages

 <host> Thu Sep 14 5:59:40 AM 2017 Database: <BASE>.gdb Index 4 misses node on page 12569401 level 1 in table <table_name> (162)
<host> Thu Sep 14 5:59:40 AM 2017 Database: <BASE>.gdb Index 5 misses node on page 12685832 level 1 in table <table_name> (162)
<host> Thu Sep 14 5:59:40 AM 2017 Database: <BASE>.gdb Index 7 misses node on page 16143028 level 1 in table <table_name> (162)

It not critical errors, do not influence integrity of an index.
Unless search in certain cases can be decelerated.

zigorzn wrote:

a question: whether  these errors or there there should be an additional report?

Is not present. But it is treated by reorganization . Indexes.
Additional diagnostics is in FB3. In the same place all cases are broken on errors and warnings.