Re: Fwd: Migration crash

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Re: Fwd: Migration crash

Daniel-3
Hello all,

I have the same problem as "daniel bip" below. I already cleaned up the DB with the latest AppImage, but it still fails.

One hacky solution would be to disable the foreign_key_checks with

SET foreign_key_checks = 0;

But then you probably have an incosistent state. So is there any proper solution to this?

Greetings,

Daniel S.

digikam.dbengine: Failure executing query:
 "\n NSERT INTO ImageHaarMatrix (imageid, modificationDate, uniqueHash, matrix) VALUES (?, ?, ?, ?);\n " 
Error messages: "QMYSQL3: Der Befehl konnte nicht ausgeführt werden" "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, "2017-08-09T13:05:53"), QVariant(QString, "3d2ec82929509b7842754a68762cb33d"), QVariant(QByteArray, "BYTE STUFF HERE""AND HERE AS WELL"))
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: Der Befehl konnte nicht ausgeführt werden", "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)")




Fwd: Migration crash

daniel bip [hidden email]
Mon Jun 19 09:34:22 UTC 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>
Reply | Threaded
Open this post in threaded view
|

Re: Fwd: Migration crash

Richard Mortimer-2
Interesting. I think this is basically the same problem that I fixed in
https://bugs.kde.org/show_bug.cgi?id=382732

I was wondering why this did not fix your issue with the latest AppImage
but having re-read am I correct that you are migrating from SQLite to
MySQL? If so then my fix ignores that particular use case.

The good news is that it should be fairly easy to adapt the 382732 to
work migrating from SQLite too.

Are you able/willing to share your existing SQLite database with me
privately so that I can work on this using some real, problematic data?
If you can then please email a compressed version to me or send me a
link to somewhere that I can download it.

Best Regards

Richard

On 16/08/2017 15:13, Daniel S wrote:

> Hello all,
>
> I have the same problem as "daniel bip" below. I already cleaned up the
> DB with the latest AppImage, but it still fails.
>
> One hacky solution would be to disable the foreign_key_checks with
>
> |SETforeign_key_checks =0; |
>
> But then you probably have an incosistent state. So is there any proper
> solution to this?
>
> Greetings,
>
> Daniel S.
>
> digikam.dbengine: Failure executing query:
>
>  "\n NSERT INTO ImageHaarMatrix (imageid, modificationDate, uniqueHash, matrix) VALUES (?, ?, ?, ?);\n "
>
> Error messages: "QMYSQL3: Der Befehl konnte nicht ausgeführt werden" "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, "2017-08-09T13:05:53"), QVariant(QString, "3d2ec82929509b7842754a68762cb33d"), QVariant(QByteArray, "*BYTE STUFF HERE*""*AND HERE AS WELL*"))
>
> 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: Der Befehl konnte nicht ausgeführt werden", "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)")
>
>
>
> ||
> ------------------------------------------------------------------------
>
>
>   Fwd: Migration crash
>
> *daniel bip* daniel.mail.public at gmail.com
> <mailto:digikam-users%40kde.org?Subject=Re%3A%20Fwd%3A%20Migration%20crash&In-Reply-To=%3CCANq0ti6NV78d7QohnvP0%3DC6Udjk_hTPEEfKCoCMbGxD9miCQRg%40mail.gmail.com%3E>
> /Mon Jun 19 09:34:22 UTC 2017/
>
>
> Hi there,
>
> Any clue on how to solve this problem?
>
> Thanks.
>
>
> d.
>
>
> ---------- Forwarded message ----------
> From: daniel bip <daniel.mail.public at gmail.com
> <https://mail.kde.org/mailman/listinfo/digikam-users>>
> 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
> <https://mail.kde.org/mailman/listinfo/digikam-users>>
>
>
> 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>
>