[H-source-users] [bug #62574] something is wrong with the server

[Yuchen Pei]

Follow-up Comment #9, bug #62574 (project h-source):


[comment #8 comment #8:]
> I mean, how is sql_mode being set? If it's set with something like SET
sql_mode=... when the database server is running, this is not persistent, and
the server will revert back to STRICT_TRANS_TABLES on when it restarts, as
this is the default in MariaDB 10.3. This was changed in MariaDB 10.2, so
presumably the previous version of the server was 10.1 or below, when this
problem wouldn't have occurred.

Yes, that's more or less how it is done (SET GLOBAL sql_mode=...), now with by
a cron job.  I didn't know this difference between MariaDB versions, but that
does make sense, especially if automated package updates restarts the server.

Thanks for the info.

> 
> It would also make sense to identify the cause of this so as not to require
STRICT_TRANS_TABLES to be off. Things failing with it on imply that when it's
off and seemingly working, there are automatic adjustments to invalid values
happening.

That makes sense.  Do you by any chance have a suggestion where to look in the
codebase?


    _______________________________________________________

Reply to this item at:

  <https://savannah.nongnu.org/bugs/?62574>

_______________________________________________
Message sent via Savannah
https://savannah.nongnu.org/