Errors after upgrade to MariaDB 10.2

ebizindia

• November 04, 2017 00:56

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?

• 

  kernow

  • November 04, 2017 12:07

  The MySQL log is in /var/lib/mysql and will be named something like: hostname.example.com.err

  0
• 

  cPanelMichael

  • November 06, 2017 15:55

  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.

  0

Please sign in to leave a comment.