Sorry... i have another one....
looks like it has generated a duplicate key, which seems... rare!
It seemed to continually try to re insert the image, without re-calculating the key. I'm not sure if it continued to index or not, as there is not a lot of stout logging.
pigallery | name: 'QueryFailedError',
pigallery | query:
pigallery | 'INSERT INTO `media_entity`(`id`, `name`, `type`, `directoryId`, `metadataCaption`, `metadataCreationdate`, `metadataFilesize`, `metadataKeywords`, `metadataOrientation`, `metadataBitrate`, `metadataDuration`, `metadataSizeWidth`, `metadataSizeHeight`, `metadataCameraDataIso`, `metadataCameraDataModel`, `metadataCameraDataMake`, `metadataCameraDataFstop`, `metadataCameraDataExposure`, `metadataCameraDataFocallength`, `metadataCameraDataLens`, `metadataPositionDataCountry`, `metadataPositionDataState`, `metadataPositionDataCity`, `metadataPositionDataGPSDataLatitude`, `metadataPositionDataGPSDataLongitude`, `metadataPositionDataGPSDataAltitude`) VALUES (DEFAULT, ?, ?, ?, DEFAULT, ?, ?, ?, ?, DEFAULT, DEFAULT, ?, ?, ?, ?, ?, ?, ?, ?, DEFAULT, DEFAULT, DEFAULT, DEFAULT, ?, ?, ?)',
pigallery | parameters:
pigallery | [ 'IMG_0995.jpg',
pigallery | 'PhotoEntity',
pigallery | 103,
pigallery | 1323184378000,
pigallery | 2198584,
pigallery | '',
pigallery | 1,
pigallery | 2592,
pigallery | 1936,
pigallery | 80,
pigallery | 'iPhone 4',
pigallery | 'Apple',
pigallery | 2.8,
pigallery | 0.058823529411764705,
pigallery | 3.85,
pigallery | -32.04533333333333,
pigallery | 115.81633333333333,
pigallery | 31.19884726224784 ] }
pigallery | { QueryFailedError: ER_DUP_ENTRY: Duplicate entry 'IMG_0995.jpg-103' for key 'IDX_332f316a46fcb158ac71210109'
pigallery | at new QueryFailedError (/pigallery2-release/node_modules/typeorm/error/QueryFailedError.js:11:28)
pigallery | at Query.<anonymous> (/pigallery2-release/node_modules/typeorm/driver/mysql/MysqlQueryRunner.js:167:45)
pigallery | at Query.<anonymous> (/pigallery2-release/node_modules/mysql/lib/Connection.js:502:10)
pigallery | at Query._callback (/pigallery2-release/node_modules/mysql/lib/Connection.js:468:16)
pigallery | at Query.Sequence.end (/pigallery2-release/node_modules/mysql/lib/protocol/sequences/Sequence.js:83:24)
pigallery | at Query.ErrorPacket (/pigallery2-release/node_modules/mysql/lib/protocol/sequences/Query.js:90:8)
pigallery | at Protocol._parsePacket (/pigallery2-release/node_modules/mysql/lib/protocol/Protocol.js:278:23)
pigallery | at Parser.write (/pigallery2-release/node_modules/mysql/lib/protocol/Parser.js:76:12)
pigallery | at Protocol.write (/pigallery2-release/node_modules/mysql/lib/protocol/Protocol.js:38:16)
pigallery | at Socket.<anonymous> (/pigallery2-release/node_modules/mysql/lib/Connection.js:91:28)
pigallery | message:
pigallery | 'ER_DUP_ENTRY: Duplicate entry \'IMG_0995.jpg-103\' for key \'IDX_332f316a46fcb158ac71210109\'',
pigallery | code: 'ER_DUP_ENTRY',
pigallery | errno: 1062,
pigallery | sqlMessage:
pigallery | 'Duplicate entry \'IMG_0995.jpg-103\' for key \'IDX_332f316a46fcb158ac71210109\'',
pigallery | sqlState: '23000',
pigallery | index: 0,
pigallery | sql:
pigallery | 'INSERT INTO `media_entity`(`id`, `name`, `type`, `directoryId`, `metadataCaption`, `metadataCreationdate`, `metadataFilesize`, `metadataKeywords`, `metadataOrientation`, `metadataBitrate`, `metadataDuration`, `metadataSizeWidth`, `metadataSizeHeight`, `metadataCameraDataIso`, `metadataCameraDataModel`, `metadataCameraDataMake`, `metadataCameraDataFstop`, `metadataCameraDataExposure`, `metadataCameraDataFocallength`, `metadataCameraDataLens`, `metadataPositionDataCountry`, `metadataPositionDataState`, `metadataPositionDataCity`, `metadataPositionDataGPSDataLatitude`, `metadataPositionDataGPSDataLongitude`, `metadataPositionDataGPSDataAltitude`) VALUES (DEFAULT, \'IMG_0995.jpg\', \'PhotoEntity\', 103, DEFAULT, 1323184378000, 2198584, \'\', 1, DEFAULT, DEFAULT, 2592, 1936, 80, \'iPhone 4\', \'Apple\', 2.8, 0.058823529411764705, 3.85, DEFAULT, DEFAULT, DEFAULT, DEFAULT, -32.04533333333333, 115.81633333333333, 31.19884726224784)',