We have run into a problem recently on our Magento 2.3.1 store.
When trying to save a product on the backend, the loading screen runs forever (or until the SQL sever gives up). It comes with a "false" validation when running the validation. But no errors popup. Not sure if this is a validation error or if it's a database error.
I need help to debug the validation function, and see if there is something there. I spent a few hours browsing the files, but I think it will take me a lot more to figure out how to properly debug all the attributes. I don't see where the validate function is being called as a whole. I need to see a list of all the errors it comes up with.
The SQL that gets stuck on the server and that runs forever even when I try to run manually on the server is:
status_global_attr ON status_global_attr.attribute_id = 97 AND status_global_attr.store_id = 0
status_attr ON status_attr.attribute_id = 97 AND status_attr.store_id = 2 WHERE (product_table.entity_id IN('101990')) AND (IFNULL(status_attr.value, status_global_attr.value) = 2)
We have a multistore setup, that amounts to about 700000 products. Full Indexing takes 1 hour and still works.
I'm stuck. :/