CI 3 DB LOCKING ISSUE ON SET SESSION sql_mode = REPLACE(REPLACE(REPLACE(REPLACE

hello guys, it's been a rough week since suddenly this error appear causing a havoc on my production web, this query ( that obviously wasn't created by me ) seems to locking my enitire DB causing delay to all the process that running on my system

SET SESSION sql_mode = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( @@sql_mode, "STRICT_ALL_TABLES,", ""), ",STRICT_ALL_TABLES", ""), "STRICT_ALL_TABLES", ""), "STRICT_TRANS_TABLES,", ""), ",STRICT_TRANS_TABLES", ""), "STRICT_TRANS_TABLES", "")

i read many posts on the internet that related to his issue but still can't find a clue to solve this while my clients keep ranting day and night

i found one particular solution that suggest me to change my database striction setting  from FALSE to TRUE to this 




reference :

https://stackoverflow.com/questions/5749...st-website
https://www.000webhost.com/forum/t/datab...1/173568/8

to confirm that solution i digged deep into ci 3 core function and i found this 



but when i set that to TRUE some of my site function become unable to run 

so do you guys have any solutuion to tacke this issue ? and can you guys feed me with some information on why even this error appear in the first place ? cause this issue just appear recently after 2 years straight running smoothly ( without this kind of error )

thank you