KMail tells: "Unable to create persistent search"

[Andreas Gungl]

Hi again,

just another question to get rid of this problem. After some digging I 
suppose, (":1", QVariant(qlonglong, 1)) means parentId should be 1 when 
inserting the collection with name ((":0", QVariant(QString, "Letzte
 Suche")).

Well, in my Akonadi DB there is no record with ID 1. The minimum ID is 6, and 
the lowest ID used as parent ID is 22.
I don't know how it could happen, if it is to be considered normal or not. 
Anyway, parentId = 1 looks pretty hardcoded, though.

Given that the contents of my DB might by somehow strange, is there an advice 
about how to start over with a fresh DB but without the need to configure any 
resources (calendars, accounts etc.) completely new? (And of course without 
loosing any data in the resources?)

Any help is welcome.
Best regards,
Andreas

Am Montag, 28. Januar 2019, 19:02:10 CET schrieb Andreas Gungl:
> Hi, is there really no idea how to fix the problem?
> If so, what would I have to do to clean up all existing data (except the
> mail messages, of course) and start over with a fresh installation in my
> Linux account?
> 
> Best regards,
> Andreas
> 
> Am Montag, 14. Januar 2019, 18:03:47 CET schrieb 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.
  ^ ' ^