QSqlTableModel insertRecord() returns true but nothing is saved in database

[snow45]

Fixed the memory leak, but didn't make a difference. QSqlRecord comes from:

@
bool MyStuffDb::addStuff(const MyObject& myobject)
{
QSqlTableModel table(NULL, myDatabase);
table.setTable("myobjects");
QSqlRecord record = myDatabase.record("myobjects");

// Call to code in first post
return addStuff(myobject, &record, &table);

}
@

[SGaist]

Did you check what edit strategy is used for the model ? If it's OnManualSubmit then you have to submit your changes

[snow45]

I've checked that and tried them all without success. After calling insertRecord() I can see the row was inserted in memory but just not saved to disk, ever. Is there anyway to flush it to disk?

I even switched over to QSqlQuery instead of using QSqlRecord and QSqlTableModel and had the same result. Could this be a linux issue somehow? As I mentioned before I only see this behavior on the first boot off a drive. Works like a charm after that.

[SGaist]

And if you remove the QSQLITE_ENABLE_SHARED_CACHE option ?

[snow45]

Problem exists with or without that option.

[SGaist]

Can you create a minimal compilable example that shows this behavior ?

[snow45]

I will try and put one together. Been super busy with other things that need done asap.

[snow45]

What's the best way to post this? Can't add attachments and it's a lot of code to post in a reply.

[SGaist]

You can use e.g. "pastebin":http://pastebin.com

[snow45]

In that case check "here":https://gist.github.com/snow45/61cea39423b79c61e10f

Remember I only see this behavior with the setup initially described.

[snow45]

I found the problem. I used the command lsattr to look at file attributes on my database files and found that when I opened App 2 for the first time I was deleting the shared database out from under App 1 and recreating it. Just had to fix that and everything works like I would expect.

[SGaist]

Out of curiosity, how was it doing it ?