QSqlQuery, addBindValue, LargeBlob problem?

[SPlatten]

@artwaw , is there anyway I can find out? I'm using HeidiSQL to review the database and that looks ok.

[artwaw]

@SPlatten said in QSqlQuery, addBindValue, LargeBlob problem?:

is there anyway I can find out

Documentation to both, I suppose?

[SPlatten]

@artwaw, MariaDB certainly supports LARGEBLOB, no errors in HeidiSQL, so it could be the SQL driver I guess...

[artwaw]

@SPlatten How large is the blob in your case? I think I remember reading the advice about large blobs in MariaDB that one should be careful since it is easy to run of memory in the stack or something.
In other words: might be it is worth to change to QSqlQuery *queryBlock = new QSqlQuery() etc. Again, one of the possibilities, I am not certain what fails there.

[SPlatten]

@artwaw , it will vary, to begin with I'm using small examples, see the size in the post: 34390236

[SPlatten]

@artwaw , the message that appears in dialog:

Lost connection to MySQL server during query QMYSQL3: Unable to execute statement

And from the event viewer Application:

Aborted connection 3 to db: 'training' host: 'localhost' (Got a packet bigger than 'max_allowed_packet' bytes)

However in my code I check the array size for < ULONG_MAX which is 4GB before I try to submit it.

[Christian Ehrlicher]

@SPlatten said in QSqlQuery, addBindValue, LargeBlob problem?:

max_allowed_packet

So hard to search for HeideSQL max_allowed_packet? The first hit gives you the config option...

[artwaw]

@SPlatten said in QSqlQuery, addBindValue, LargeBlob problem?:

'max_allowed_packet' bytes

Configuration of the server doesn't permit the size you send.

[SPlatten]

@Christian-Ehrlicher , found this https://docs.oracle.com/cd/E19509-01/820-6323/gicxk/index.html, modified my.ini, your so pissy, where you abused as a child?

[SPlatten]

@artwaw , so I modified my.ini and restarted MariaDB service, now it appears to be ok, thank's for your help.

[Christian Ehrlicher]

@SPlatten said in QSqlQuery, addBindValue, LargeBlob problem?:

your so pissy

Because you're to lazy (or whatever) to search for the simplest things before you write a new question which every kid could resolve in less than a minute...

[SPlatten]

@Christian-Ehrlicher , this forum is a resource full of knowledgeable people, just like a Google search is also a resource, how and what I choose to do is my choice.