291 words

ObjectDB 2.7.2_x Doctor Yields "Index Requires Rebuild" Always

#1
2017-11-02 20:33

Take a .odb created with ObjectDB 2.7.2 or later OR EARLIER.  Run ObjectDB 2.7.2 Doctor on it.  See indexing errors reported.

Run ObjectDB 2.7.1 on same .odb and you will not see indexing errors.

Run ObjectDB 2.7.2 (or later or earlier) Doctor with repair and create repaired.odb.  repaired.odb will still show indexing errors when ObjectDB 2.7.2 (or later) Doctor is run on the "repaired" database.

Automatic index rebuilding ("<index-update enabled="true" priority="40" />") does not correct the database.

So, in summary, I think ObjectDB 2.7.2 (and later) Doctor is incorrectly stating that indexing errors are present.

(I am running this test with a java.exe that is Java 9, though I don't think that matters since ObjectDB 2.7.1 Doctor does not show any indexing errors.)

Here is an example output from my .odb:

C:\Users\BoydE\Desktop>java -cp 2.7.2_03\bin\objectdb.jar com.objectdb.Doctor C:\Users\BoydE\MoxyDox\ObjectDb\Test.odb
ObjectDB Doctor [version 2.7.2_03]
Copyright (c) 2017, ObjectDB Software. All rights reserved.
 
Scanning the database file...
2MB (total)
Analyzing database structure...
10% 20% 30% 40% 50% 60% 70% 80% 90% 100%
 
Index Errors
------------
[1] Index com.unilogical.moxydox.protocol.server.jdo.JdoEntityId[id] requires rebuild.
  - missing entries: 7
  - extra entries: 7
[2] Index com.unilogical.moxydox.protocol.server.jdo.JdoEntity[idLowercase] requires rebuild.
  - missing entries: 16
  - extra entries: 16
[3] Index com.unilogical.moxydox.protocol.server.jdo.JdoImagePageBackground[checksum] requires rebuild.
  - missing entries: 1
  - extra entries: 1
[4] Index com.unilogical.moxydox.protocol.server.jdo.JdoImagePageBackground[location] requires rebuild.
  - missing entries: 1
  - extra entries: 1
BoydEdmondson
BoydEdmondson's picture
Joined on 2016-07-08
User Post #62
#2
2017-11-03 13:10

You are right. This is a false alarm.

The Doctor in 2.7.2 tries to diagnose index issues that have not been handled by previous versions but introduces this false alarm. Could you please try build 2.7.2_04?

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)
support
support's picture
Joined on 2010-05-03
User Post #2,875
#3
2017-11-03 15:47

ObjectDB 2.7.2_04 works as expected.  (No more false indexing issue reports.)

BoydEdmondson
BoydEdmondson's picture
Joined on 2016-07-08
User Post #64
#4
2017-11-11 17:53

In case it helps you (because 2.7.2_05 release notes state "Fixed a bug in schema evolution of indexes.") ...

I can confirm that ObjectDB 2.7.2_05 also works as expected.

BoydEdmondson
BoydEdmondson's picture
Joined on 2016-07-08
User Post #70
#5
2017-11-13 11:16

Thanks for the update.

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)
support
support's picture
Joined on 2010-05-03
User Post #2,891

Post Reply

Please read carefully the posting instructions - before posting to the ObjectDB website.

  • You may have to disable pop up blocking in order to use the toolbar (e.g. in Chrome).
  • Use ctrl + right click to open the browser context menu in the editing area (e.g. for using a browser spell checker).
  • To insert formatted lines (e.g. Java code, stack trace) - select a style in the toolbar and then insert the text in the new created block.
  • Avoid overflow of published source code examples by breaking long lines.
  • You may mark in paragraph code words (e.g. class names) with the code style (can be applied by ctrl + D).
  • Long stack traces (> 50 lines) and complex source examples (> 100 lines) should be posted as attachments.
Attachments:
Maximum file size: 32 MB
Cancel