0 Replies Latest reply on Sep 21, 2014 7:26 PM by zBernie

    Synchronizing some folders in LR 5.6 hangs

    zBernie Level 1

      When I synchronize certain folders in LR 5.6, the process hangs, and I have to cancel the import and exit LR.  The folder in question only has 366 photos and videos.  This is occurring on my Macbook running Mavericks 10.9.4.  So, I monitored the log file during the import, and got the errors below.  The critical part of the error is:

       

         Bad sqlite return code: 19. Info: columns lc_idx_filename, folder are not unique

       

      I believe the error is caused by LR trying to import photos and or videos that already exist in the catalog.  I can see that some of the photos already exist in the catalog when I check the "Show import dialog before import".   Knowing the error is caused by non unique file names, I deleted all 366 photos from the catalog (But left them on disk, then the folder sync worked.  This workaround works, but can anyone tell me if there is a way to rebuild the LR indexes, or correct the problem via some other means?

       

       

      Marker - Sep 21, 2014, 10:09:09 PM

      Sep 21 22:09:31 --- last message repeated 1 time ---

      Sep 21 22:09:32 macbook.home Adobe Photoshop Lightroom 5[1387]:

          Bad sqlite return code: 19. Info: columns lc_idx_filename, folder are not unique

              0: method   runToCompletion                - C

              1: method   exec                           - 59600407:493+29

              2: method   exec                           - 1098400342:832+5

              3: method   new                            - 1100780495:39+13

              4: upvalue  ?                              - 219380148:280+8

              5: upvalue  ?                              - 219380148:451+16

              6: method   save                           - 219380148:1349+7

              7: method   sqlQuery                       - 219380148:735+12

              8: upvalue  ?                              - 1626841921:187+40

              9:          [unnamed]                      - 1626841921:306+56

             10:          [unnamed]                      - tail

             11: method   createMetadata                 - 1216069304:338+41

             12: field    initializeMetadataForImage     - 1597059609:283+20

             13: upvalue  ?                              - 209166131:556+44

             14:          [unnamed]                      - 209166131:980+43

             15:          [unnamed]                      - tail

             16:          [unnamed]                      - 219380148:965+5

             17: global   pcall                          - C

             18:          [unnamed]                      - 219380148:843+53

             19:          [unnamed]                      - tail

             20: global   pcall                          - C

             21:          [unnamed]                      - 1098400342:526+44

             22:          [unnamed]                      - tail

             23: upvalue  ?                              - 209166131:173+7

             24:          [unnamed]                      - 209166131:950+26

             25: global   pcall                          - C

             26:          [unnamed]                      - 1002929302:1193+34

             27:          [unnamed]                      - tail

             28:          [unnamed]                      - tail

             29:          [unnamed]                      - tail

             30: method   dispatch                       - 1002929302:971+75

             31:          [unnamed]                      - 1002929302:1679+77

             32: global   AgCallWithAutoreleasePool      - C

             33: method   run                            - 1002929302:1642+28

             34:          [unnamed]                      - 435542093:0+6

          ---------------------------------

      Sep 21 22:09:32 macbook.home Adobe Photoshop Lightroom 5[1387]:

          Bad sqlite return code: 19. Info: columns lc_idx_filename, folder are not unique

              0: method   reset                          - C

              1: method   reviveReusableCachedStatement  - 944881066:368+10

              2: method   prepareRunToCompletionStatement - 59600407:1041+4

              3: method   exec                           - 59600407:493+23

              4: method   exec                           - 1098400342:832+5

              5: method   new                            - 1100780495:39+13

              6: upvalue  ?                              - 219380148:280+8

              7: upvalue  ?                              - 219380148:451+16

              8: method   save                           - 219380148:1349+7

              9: method   sqlQuery                       - 219380148:735+12

             10: upvalue  ?                              - 1626841921:187+40

             11:          [unnamed]                      - 1626841921:306+56

             12:          [unnamed]                      - tail

             13: method   createMetadata                 - 1216069304:338+41

             14: field    initializeMetadataForImage     - 1597059609:283+20

             15: upvalue  ?                              - 209166131:556+44

             16:          [unnamed]                      - 209166131:980+43

             17:          [unnamed]                      - tail

             18:          [unnamed]                      - 219380148:965+5

             19: global   pcall                          - C

             20:          [unnamed]                      - 219380148:843+53

             21:          [unnamed]                      - tail

             22: global   pcall                          - C

             23:          [unnamed]                      - 1098400342:526+44

             24:          [unnamed]                      - tail

             25: upvalue  ?                              - 209166131:173+7

             26:          [unnamed]                      - 209166131:950+26

             27: global   pcall                          - C

             28:          [unnamed]                      - 1002929302:1193+34

             29:          [unnamed]                      - tail

             30:          [unnamed]                      - tail

             31:          [unnamed]                      - tail

             32: method   dispatch                       - 1002929302:971+75

             33:          [unnamed]                      - 1002929302:1679+77

             34: global   AgCallWithAutoreleasePool      - C

             35: method   run                            - 1002929302:1642+28

             36:          [unnamed]                      - 435542093:0+6

          ---------------------------------

      Sep 21 22:09:32 macbook.home Adobe Photoshop Lightroom 5[1387]: assertion failed!