0

I have a problem with a job which manage import products and customers every night.

Randomly return an error when import products from SAP.

Error products

If u see the picture u can see the material "SB-FHA125A-F_ASLV" which was imported rightly but the product "SB-FBA125A-F_GLY" return an error when try to modify the attribute sap_model.

I mustn't modify the value of timeout in InnoDB.

Any idea about what is the problem?.

Thanks!

1
  • It could be helpful to log all deadlocks, see this post on DBA on how to do it. That could help identify the thread that does the locking and leads to the deadlock.
    – 0xCAFEBABE
    Jan 22, 2019 at 13:57

1 Answer 1

0

You need to increase the max_execution_time in php.ini file.

If you are using xampp you can find the php.ini file in location xampp\php\php.ini

after change in file save it and restart the server.

1
  • Sorry but i don't want increase the max_execution_time because this process is very slow now and don't like increase it
    – str_lml
    Jan 23, 2019 at 16:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.