KMail tells: "Unable to create persistent search"

[Andreas Gungl]

Hi Dan,

Thanks for offering your help. I'd already asked on kdepim-users and didn't 
get a response for weeks. That's why I wrote to this list.

The output from the akonadiconsole, if the search error occurs, ist like this:

org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver:   Error code: "1452"
org.kde.pim.akonadiserver:   DB error:  "Cannot add or update a child row: a 
foreign key constraint fails (`akonadi`.`collectiontable`, CONSTRAINT 
`collectiontable_ibfk_1` FOREIGN KEY (`parentId`) REFERENCES `collectiontable` 
(`id`) ON DELETE CASCADE ON UPDATE CASCADE)"
org.kde.pim.akonadiserver:   Error text: "Cannot add or update a child row: a 
foreign key constraint fails (`akonadi`.`collectiontable`, CONSTRAINT 
`collectiontable_ibfk_1` FOREIGN KEY (`parentId`) REFERENCES `collectiontable` 
(`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to execute 
statement"
org.kde.pim.akonadiserver:   Values: QMap((":0", QVariant(QString, "Letzte 
Suche"))(":1", QVariant(qlonglong, 1))(":2", QVariant(qlonglong, 1))(":3", 
QVariant(QString, "{\n    \"limit\": -1,\n    \"negated\": false,\n    
\"rel\": 0,\n    \"subTerms\": [\n        {\n            \"negated\": false,\n            
\"rel\": 1,\n            \"subTerms\": [\n                {\n                    
\"cond\": 5,\n                    \"key\": \"from\",\n                    
\"negated\": false,\n                    \"value\": \"gungl\"\n                
}\n            ]\n        }\n    ]\n}\n"))(":4", QVariant(QString, 
"RECURSIVE"))(":5", QVariant(QString, "166"))(":6", QVariant(bool, true)))
org.kde.pim.akonadiserver:   Query: "INSERT INTO CollectionTable (name, 
parentId, resourceId, queryString, queryAttributes, queryCollections, 
isVirtual) VALUES (:0, :1, :2, :3, :4, :5, :6)"
org.kde.pim.akonadiserver: Error during insertion into table "CollectionTable" 
"Cannot add or update a child row: a foreign key constraint fails 
(`akonadi`.`collectiontable`, CONSTRAINT `collectiontable_ibfk_1` FOREIGN KEY 
(`parentId`) REFERENCES `collectiontable` (`id`) ON DELETE CASCADE ON UPDATE 
CASCADE) QMYSQL3: Unable to execute statement"

It looks like a DB integrity problem KMail can't recover from by itself. But 
apart from that I've no clue about how to fix that.

Best regards,
Andreas


Am Montag, 14. Januar 2019, 10:53:40 CET schrieb Daniel Vrátil:
> Hi Andreas,
> 
> could you please start Akonadi from terminal (open "Konsole" and run
> "akonadictl restart"), then try to create the search in KMail again - you
> should see some more detailed errors in the Konsole window that might help
> us figure out what's wrong.
> 
> Thanks,
> Daniel
> 
> PS: kdepim-users is a better list for this kind of questions.
> 
> On Saturday, 12 January 2019 16:13:10 CET Andreas Gungl wrote:
> > Hi,
> > 
> > did a search in the web but didn't find a solution for how to solve the
> > problem: When I search for messages, I end up with the error message:
> > "Unable to create persistent search"
> > 
> > I have no search folder around, maybe that's the problem. Should I need to
> > create one manually? Any other hints like restarting akonadi etc. didn't
> > help. How can I make the search working again?
> > 
> > Best regards,
> > Andreas


-- 
    ~
  ' v '
 //   \\
/(     )\  Powered by Penguin.
  ^ ' ^