Errors after upgrade to MariaDB 10.2

ebizindia

Well-Known Member
Oct 13, 2005
100
4
168
Kolkata, India
cPanel Access Level
Root Administrator
We upgraded to MariaDB 10.2 recently and after that, we are encountering lots of DB errors. Most of the errors are related to SQL queries referencing fields which cannot be null but no value was supplied in the query during insert or update.

Can we see a list of the errors through some error log so that we can quickly identify and correct the problem without waiting for the client to complain?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,910
2,211
363
Hello,

The MySQL error log is located at /var/lib/mysql/$hostname.err, but you may also want to see if there are any individual error_log files within the document root of any PHP scripts that are producing error messages.

Thank you.