Too many "Failed" with my synchronization

  • 69Views
  • Last Post 06 April 2021
0
votes
Alexis ROMEZIN posted this 29 March 2021

Hi,

With one day i have many error in my synchronization between Zoho CRM and mySQL Database.

The text of failed is this : 

Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.

Please, do you have any explanation or fix ?

Best regards,

Order By: Standard | Newest | Votes
0
votes
Dmitriy Muzurov posted this 29 March 2021

Hello Alexis,

Thank you for submitting a ticket with us.

It seems the issue is related to connections that can't be managed correctly by your server.

Please check this article.

We are looking forward to hearing from you, should you have any questions.

0
votes
Alexis ROMEZIN posted this 30 March 2021

 Hi,

I don't work with C#, it's a synchronization between ZOHO CRM and AMAZON RDS MYSQL 5.6.

I put the max_connection to 100 and doesn't work.

I feel like it's still our fault, unfortunately the backward compatibility of your actions is the main cause of our timing issues with your tool.

Would it be possible to be more precise? If you want more information, do not hesitate to ask us because we will be fighting with you for 2 months to restore your system because you have carried out new development without thinking about the old users of your solution.

I have been using and paying for your service for 2 years. I believe I have the right to more precision to unlock the situation than a link to Stackoverflow.

 

Thank you.

0
votes
Dmitriy Muzurov posted this 06 April 2021

Dear Alexis,

Thank you for getting back to us.

Please increase the values of the following parameters in the configuration of your MySQL Server:

- max_allowed_packet

- net_read_timeout

- net_write_timeout

- wait_timeout

For more information, please refer to this link.

Close