Lightroom CC only shows spinning icon and does not show library anymore: Corrupt database

[_StefanM_]

I was synching my photos, when my Macbook ran out of battery.

It hibernated and started again with power attached.

Now Lightroom is stuck with the progress spinner and does not show my library anymore.

This really does not build confidence of being able to trust all my pictures with a new product in Version 1.0, when after the 3rd day of usage I'm unable to access any of my images!

Here are some logs from Console:

default
22:29:32.981702 -0700
Adobe Lightroom CC Helper
NmbVolumeAgent:ACF65E13-3F74-3135-BA36-EFC196185BD7
ERROR
NmbVolumeAgent:ACF65E13-3F74-3135-BA36-EFC196185BD7
ERROR
maybePurgeLeastRecentlyAccessed encountered an error: %s
 Database "/Users/stefan/Pictures/Lightroom Library.lrlibrary/79239ecf2a2a4438a6373609fc334137/Managed Catalog.mcat": library routine called out of sequence
  Statement: SELECT fullDocId AS selectIdCol, revId, sequence, content, annotation, hasConflicts,
docs.deleted AS deleted,
docs.mostRecentRevSequence AS mostRecentRevSequence
FROM revs
INNER JOIN docs ON docs.winningRevSequence = revs.sequence
WHERE
docs.localDocId = ? (error code 21)
default
22:29:32.983940 -0700
Adobe Lightroom CC Helper
Bad sqlite return code: 21. Info: library routine called out of sequence
    0: field    _bindByPositionMethod          - C
    1:          [unnamed]                      - 1753170016:1056+27
    2: upvalue  ?                              - 67365416:1079+82
    3:          [unnamed]                      - 67365416:1387+17
    4: global   pcall                          - C
    5:          [unnamed]                      - 1753170016:1339+39
    6:          [unnamed]                      - tail
    7: upvalue  ?                              - 67365416:1415+7
    8:          [unnamed]                      - 1151015846:106+6
    9: global   pcall                          - C
   10: upvalue  ?                              - 1875443985:839+14
   11:          [unnamed]                      - 1875443985:951+11
   12:          [unnamed]                      - tail
   13:          [unnamed]                      - C
---------------------------------
default
22:29:32.984258 -0700
Adobe Lightroom CC Helper
NmbVolumeAgent:ACF65E13-3F74-3135-BA36-EFC196185BD7
ERROR
NmbVolumeAgent:ACF65E13-3F74-3135-BA36-EFC196185BD7
ERROR
maybePurgeLeastRecentlyAccessed encountered an error: %s
 Database "/Users/stefan/Pictures/Lightroom Library.lrlibrary/79239ecf2a2a4438a6373609fc334137/Managed Catalog.mcat": library routine called out of sequence
  Statement: SELECT fullDocId AS selectIdCol, revId, sequence, content, annotation, hasConflicts,
docs.deleted AS deleted,
docs.mostRecentRevSequence AS mostRecentRevSequence
FROM revs
INNER JOIN docs ON docs.winningRevSequence = revs.sequence
WHERE
docs.localDocId = ? (error code 21)
default
22:29:32.986296 -0700
Adobe Lightroom CC Helper
Bad sqlite return code: 21. Info: library routine called out of sequence
    0: field    _bindByPositionMethod          - C
    1:          [unnamed]                      - 1753170016:1056+27
    2: upvalue  ?                              - 67365416:1079+82
    3:          [unnamed]                      - 67365416:1387+17
    4: global   pcall                          - C
    5:          [unnamed]                      - 1753170016:1339+39
    6:          [unnamed]                      - tail
    7: upvalue  ?                              - 67365416:1415+7
    8:          [unnamed]                      - 1151015846:106+6
    9: global   pcall                          - C
   10: upvalue  ?                              - 1875443985:839+14
   11:          [unnamed]                      - 1875443985:951+11
   12:          [unnamed]                      - tail
   13:          [unnamed]                      - C
---------------------------------
default
22:29:32.986622 -0700
Adobe Lightroom CC Helper
NmbVolumeAgent:ACF65E13-3F74-3135-BA36-EFC196185BD7
ERROR
NmbVolumeAgent:ACF65E13-3F74-3135-BA36-EFC196185BD7
ERROR
maybePurgeLeastRecentlyAccessed encountered an error: %s
 Database "/Users/stefan/Pictures/Lightroom Library.lrlibrary/79239ecf2a2a4438a6373609fc334137/Managed Catalog.mcat": library routine called out of sequence
  Statement: SELECT fullDocId AS selectIdCol, revId, sequence, content, annotation, hasConflicts,
docs.deleted AS deleted,
docs.mostRecentRevSequence AS mostRecentRevSequence
FROM revs
INNER JOIN docs ON docs.winningRevSequence = revs.sequence
WHERE
docs.localDocId = ? (error code 21)
default
22:29:54.033089 -0700
Adobe Lightroom CC Helper
WFRxContinuousTask
ERROR
Continuous task "WFCatIdleDownloader" sent onError: "<<<SQLite database corrupt>>>"
default
22:29:59.368950 -0700
Adobe Lightroom CC Helper
WFRxContinuousTask
ERROR
Continuous task "NmbVolumeAgent:Proactive" sent onError: "<<<SQLite database corrupt>>>"

Also, what is the proper way of filing a technical bug report for Adobe products?

[_StefanM_]

If I run an integrity check on the database, it also shows issues:

$ sqlite3 Managed\ Catalog.mcat "PRAGMA integrity_check"

*** in database main ***

Page 133920: btreeInitPage() returns error code 11

Page 137976: btreeInitPage() returns error code 11

Page 137961: btreeInitPage() returns error code 11

Page 137958: btreeInitPage() returns error code 11

Page 137947: btreeInitPage() returns error code 11

Page 137932: btreeInitPage() returns error code 11

Page 137930: btreeInitPage() returns error code 11

Page 137929: btreeInitPage() returns error code 11

Page 137928: btreeInitPage() returns error code 11

[freyherme]

I have the same issue.  Application just spins and spins and never loads.  I have tried every single trouble-shooting tip I can find and nothing works.  I've even tried installing Lightroom CC on another machine and got the same behavior.  I even setup a brand new Adobe ID to start with a completely fresh database, and still the same behavior!  I am using a Mac on High Sierra.  Maybe Lightroom CC is just not compatible with High Sierra?

[_StefanM_]

I'm not on High Sierra yet, but still had this issue.

Meanwhile I tried to restore a backup of my catalogue but could not get a revision that would work. So for now I ended up deleting my entire catalogue and migrating all photos again.

[kellyl70933555]

I am having the Same issue

[selondon]

kellyl70933555​ When I have had this before, I have had success by signing out of the app and then out of the 'red' Creative Cloud app, then signing back in and finally signing back into Lightroom CC.