Fwd: Migration crash

Mon Jun 19 10:34:22 BST 2017

Hi there,

Any clue on how to solve this problem?

Thanks.

d.

---------- Forwarded message ----------
From: daniel bip <daniel.mail.public at gmail.com>
Date: 17 June 2017 at 00:05
Subject: Migration crash
To: digiKam - Home Manage your photographs as a professional with the power
of open source <digikam-users at kde.org>

Hi there,

I'm trying to migrate from SQLite to Mysql External Server and after some
minutes Digikam crashes, with the following message in the terminal window.
Any idea on how to fix that?

DK 5.5.0 from Philip Johnsson's repository
Ubuntu: 16.04 running in a VirtualBox windows-host
DB: mariaDB 10.0.29
driver: libq5sql5-mysql:amd64 5.5.1

Thanks.

d.

digikam.coredb: Core database: column: [ "id" ] value [
QVariant(qlonglong, 373273) ]
digikam.coredb: Core database: column: [ "album" ] value [
QVariant(qlonglong, 1355) ]
digikam.coredb: Core database: column: [ "name" ] value [
QVariant(QString, "DSC09607.JPG") ]
digikam.coredb: Core database: column: [ "status" ] value [
QVariant(qlonglong, 1) ]
digikam.coredb: Core database: column: [ "category" ] value [
QVariant(qlonglong, 1) ]
digikam.coredb: Core database: column: [ "modificationDate" ] value [
QVariant(QString, "2017-06-16T15:39:36") ]
digikam.coredb: Core database: column: [ "fileSize" ] value [
QVariant(qlonglong, 14676897) ]
digikam.coredb: Core database: column: [ "uniqueHash" ] value [
QVariant(QString, "823486c254f9a776a253a8df68d41e5e") ]
digikam.coredb: Core database: trying to copy contents from DB with
ActionName: [ "Migrate_Read_AlbumsExtra" ] to DB with ActionName [
"Migrate_Write_AlbumsExtra" ]
digikam.coredb: Core database: driver doesn't support query size. We
try to go to the last row and back to the current.
digikam.coredb: Core database: result size: [ 0 ]
digikam.coredb: Core database: trying to copy contents from DB with
ActionName: [ "Migrate_Read_ImageHaarMatrix" ] to DB with ActionName [
"Migrate_Write_ImageHaarMatrix" ]
digikam.coredb: Core database: driver doesn't support query size. We
try to go to the last row and back to the current.
digikam.coredb: Core database: result size: [ 84512 ]
digikam.coredb: Core database: query isOnValidRow [ true ] isActive [
true ] result size: [ -1 ]
digikam.coredb: Core database: column: [ "imageid" ] value [
QVariant(qlonglong, 0) ]
digikam.coredb: Core database: column: [ "modificationDate" ] value [
QVariant(QString, "2006-09-03T13:47:52") ]
digikam.coredb: Core database: column: [ "uniqueHash" ] value [
QVariant(QString, "cda4ebc77881feaf5b6765037b50193f") ]
digikam.coredb: Core database: column: [ "matrix" ] value [
QVariant(QByteArray,
"\x00\x00\x00\x01?\xDD\xA3""A\xEE""Bq\xC3\xBF\x96\xA2\xDE\x92""b<\x1E?aGuC{\x93u\x00\x00\x02\x04\x00\x00\x03\x8B\xFF\xFF\xFE}\xFF\xFF\xFF\xF8\xFF\xFF\xFF\xB9\xFF\xFF\xFF\xEF\xFF\xFF\xFB|\xFF\xFF\xFF|\xFF\xFF\xFD\x7F\xFF\xFF\xFF\xDD\x00\x00\x02\x02\x00\x00\x00\x8A\xFF\xFF\xFE\xF7\x00\x00\x01\x89\x00\x00\x00\x86\xFF\xFF\xFA\xFF\x00\x00\x04\x81\xFF\xFF\xFCv\xFF\xFF\xFFu\xFF\xFF\xFE\xFE\x00\x00\x00%\xFF\xFF\xFF\x7F\xFF\xFF\xFEv\x00\x00\x03\x81\x00\x00\x00\x12\xFF\xFF\xFF\xFD\x00\x00\x00\x0B\x00\x00\x04\x80\x00\x00\x00\x83\xFF\xFF\xFF\xFF\x00\x00\x02\x01\xFF\xFF\xFF\xF6\x00\x00\x05\x00\x00\x00\x02\x00\x00\x00\x02\x80\xFF\xFF\xFF\xFC\x00\x00\x00\t\xFF\xFF\xFF\xFE\x00\x00\x00\x80\x00\x00\x01\x00\xFF\xFF\xFF\xFD\xFF\xFF\xFD\x80\x00\x00\x01\xAA\xFF\xFF\xF8\xFE\x00\x00\x01\x81\x00\x00\x07\x03\x00\x00\x03\x0B\xFF\xFF\xFE\x00\x00\x00\x01\x01\xFF\xFF\xFB\x00\x00\x00\x02\x07\x00\x00\x00\x87\x00\x00\x00\f\x00\x00\x00\x81\x00\x00\x00\x8D\x00\x00\x00\x07\x00\x00\x00\x86\x00\x00\x03\x8D\x00\x00\x03\x8B\x00\x00\x00\x8C\xFF\xFF\xFF\xF3\xFF\xFF\xFE\xF4\xFF\xFF\xFC\xFB\xFF\xFF\xFF\xF7\x00\x00\x01\x07\xFF\xFF\xFDu\x00\x00\x03\x83\x00\x00\x03\x01\x00\x00\x02\x03\xFF\xFF\xFF~\x00\x00\x01\x8D\x00\x00\x03\x80\xFF\xFF\xFF\xFB\xFF\xFF\xFC~\x00\x00\x00\x83\x00\x00\x01\x8B\x00\x00\x01\x83\xFF\xFF\xFE~\x00\x00\x01\x80\xFF\xFF\xFF\x00\xFF\xFF\xFCu\xFF\xFF\xF4\xE2\xFF\xFF\xFEs\xFF\xFF\xE8\x00\x00\x00\x02\x8C\x00\x00\x01\x82\xFF\xFF\xFE\x7F\xFF\xFF\xFEu\xFF\xFF\xF4\xF9\xFF\xFF\xFFy\x00\x00\x00\x8C\xFF\xFF\xFF\xEF\xFF\xFF\xFE\xF4\xFF\xFF\xFA}\x00\x00\x05\x8C\x00\x00\x02\x82\xFF\xFF\xFDi\xFF\xFF\xFA\xFA\x00\x00\x03\x82\xFF\xFF\xFF\xDD\xFF\xFF\xFDs\xFF\xFF\xFF}\x00\x00\x00\x86\xFF\xFF\xFF\xFE\xFF\xFF\xFD\x7F\x00\x00\x00\x82\xFF\xFF\xFA\xFD\xFF\xFF\xFD}\x00\x00\x00\r\x00\x00\x00\x01\xFF\xFF\xFAs\xFF\xFF\xFA\xFF\x00\x00\x05\x00\xFF\xFF\xFE\xFD\x00\x00\x00\x06\xFF\xFF\xFF\x80\xFF\xFF\xFE\xFA\x00\x00\x00\x03\xFF\xFF\xFE\xFF\x00\x00\x01\x00")
]
digikam.dbengine: Failure executing query:
 "\n                INSERT INTO ImageHaarMatrix (imageid,
modificationDate, uniqueHash, matrix) VALUES (?, ?, ?, ?);\n
 "
Error messages: "QMYSQL3: Unable to execute statement" "Cannot add or
update a child row: a foreign key constraint fails
(`digikam`.`ImageHaarMatrix`, CONSTRAINT `ImageHaarMatrix_Images`
FOREIGN KEY (`imageid`) REFERENCES `Images` (`id`) ON DELETE CASCADE
ON UPDATE CASCADE)" 1452 2
Bound values:  (QVariant(qlonglong, 0), QVariant(QString,
"2006-09-03T13:47:52"), QVariant(QString,
"cda4ebc77881feaf5b6765037b50193f"), QVariant(QByteArray,
"\x00\x00\x00\x01?\xDD\xA3""A\xEE""Bq\xC3\xBF\x96\xA2\xDE\x92""b<\x1E?aGuC{\x93u\x00\x00\x02\x04\x00\x00\x03\x8B\xFF\xFF\xFE}\xFF\xFF\xFF\xF8\xFF\xFF\xFF\xB9\xFF\xFF\xFF\xEF\xFF\xFF\xFB|\xFF\xFF\xFF|\xFF\xFF\xFD\x7F\xFF\xFF\xFF\xDD\x00\x00\x02\x02\x00\x00\x00\x8A\xFF\xFF\xFE\xF7\x00\x00\x01\x89\x00\x00\x00\x86\xFF\xFF\xFA\xFF\x00\x00\x04\x81\xFF\xFF\xFCv\xFF\xFF\xFFu\xFF\xFF\xFE\xFE\x00\x00\x00%\xFF\xFF\xFF\x7F\xFF\xFF\xFEv\x00\x00\x03\x81\x00\x00\x00\x12\xFF\xFF\xFF\xFD\x00\x00\x00\x0B\x00\x00\x04\x80\x00\x00\x00\x83\xFF\xFF\xFF\xFF\x00\x00\x02\x01\xFF\xFF\xFF\xF6\x00\x00\x05\x00\x00\x00\x02\x00\x00\x00\x02\x80\xFF\xFF\xFF\xFC\x00\x00\x00\t\xFF\xFF\xFF\xFE\x00\x00\x00\x80\x00\x00\x01\x00\xFF\xFF\xFF\xFD\xFF\xFF\xFD\x80\x00\x00\x01\xAA\xFF\xFF\xF8\xFE\x00\x00\x01\x81\x00\x00\x07\x03\x00\x00\x03\x0B\xFF\xFF\xFE\x00\x00\x00\x01\x01\xFF\xFF\xFB\x00\x00\x00\x02\x07\x00\x00\x00\x87\x00\x00\x00\f\x00\x00\x00\x81\x00\x00\x00\x8D\x00\x00\x00\x07\x00\x00\x00\x86\x00\x00\x03\x8D\x00\x00\x03\x8B\x00\x00\x00\x8C\xFF\xFF\xFF\xF3\xFF\xFF\xFE\xF4\xFF\xFF\xFC\xFB\xFF\xFF\xFF\xF7\x00\x00\x01\x07\xFF\xFF\xFDu\x00\x00\x03\x83\x00\x00\x03\x01\x00\x00\x02\x03\xFF\xFF\xFF~\x00\x00\x01\x8D\x00\x00\x03\x80\xFF\xFF\xFF\xFB\xFF\xFF\xFC~\x00\x00\x00\x83\x00\x00\x01\x8B\x00\x00\x01\x83\xFF\xFF\xFE~\x00\x00\x01\x80\xFF\xFF\xFF\x00\xFF\xFF\xFCu\xFF\xFF\xF4\xE2\xFF\xFF\xFEs\xFF\xFF\xE8\x00\x00\x00\x02\x8C\x00\x00\x01\x82\xFF\xFF\xFE\x7F\xFF\xFF\xFEu\xFF\xFF\xF4\xF9\xFF\xFF\xFFy\x00\x00\x00\x8C\xFF\xFF\xFF\xEF\xFF\xFF\xFE\xF4\xFF\xFF\xFA}\x00\x00\x05\x8C\x00\x00\x02\x82\xFF\xFF\xFDi\xFF\xFF\xFA\xFA\x00\x00\x03\x82\xFF\xFF\xFF\xDD\xFF\xFF\xFDs\xFF\xFF\xFF}\x00\x00\x00\x86\xFF\xFF\xFF\xFE\xFF\xFF\xFD\x7F\x00\x00\x00\x82\xFF\xFF\xFA\xFD\xFF\xFF\xFD}\x00\x00\x00\r\x00\x00\x00\x01\xFF\xFF\xFAs\xFF\xFF\xFA\xFF\x00\x00\x05\x00\xFF\xFF\xFE\xFD\x00\x00\x00\x06\xFF\xFF\xFF\x80\xFF\xFF\xFE\xFA\x00\x00\x00\x03\xFF\xFF\xFE\xFF\x00\x00\x01\x00"))
digikam.dbengine: Error while executing DBAction [
"Migrate_Write_ImageHaarMatrix" ] Statement [ "\n
INSERT INTO ImageHaarMatrix (imageid, modificationDate, uniqueHash,
matrix) VALUES (:imageid, :modificationDate, :uniqueHash, :matrix);\n
          " ]
digikam.coredb: Core database: error while converting table data.
Details:  QSqlError("1452", "QMYSQL3: Unable to execute statement",
"Cannot add or update a child row: a foreign key constraint fails
(`digikam`.`ImageHaarMatrix`, CONSTRAINT `ImageHaarMatrix_Images`
FOREIGN KEY (`imageid`) REFERENCES `Images` (`id`) ON DELETE CASCADE
ON UPDATE CASCADE)")
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20170619/f499ccad/attachment.html>