Support Article
An I/O error occurred while sending to the backend
SA-75586
Summary
SQL queries time out for the database and error occurs. The database operation took more than the threshold of 500 ms: 90,055 ms.
Error Messages
An I/O error occurred while sending to the backend
Steps to Reproduce
Run the system.
Root Cause
A defect or configuration issue in the operating environment.
The work table was large and was not vacuumed.
Resolution
Make the following change to the operating environment:
- Update the indexes.
- Vacuum to improve the query performance.
Published March 20, 2019 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.