Stitch periodically performs checks on the connection to your database to ensure the connection remains active and healthy. Below are some of the most common errors you might see if Stitch has trouble performing the connection check to your database and how to resolve them.
Common Errors
Stitch is unable to access the databases or tables in your database.
TroubleshootingVerify that the Stitch database user has the necessary permissions for the type of database you’re connecting.
You can find the permissions in the Creating a Stitch Database User section of the setup guide for your database.
If you’re using MySQL: Verify that the table is in InnoDB format. This error usually surfaces when the table is in MyISAM format, which is currently unsupported.
To successfully replicate your data, you’ll need to convert your tables to the InnoDB format. Performing the conversion requires tech expertise and familiarity with MySQL, so we recommend looping in a database admin or another member of your tech team to help out.
Stitch is unable to access the table or the table is in an unsupported format.
TroubleshootingVerify that the Stitch database user has the necessary permissions for the type of database you’re connecting.
You can find the permissions in the Creating a Stitch Database User section of the setup guide for your database.
If you’re using MySQL: Verify that the table is in InnoDB format. This error usually surfaces when the table is in MyISAM format, which is currently unsupported.
To successfully replicate your data, you’ll need to convert your tables to the InnoDB format. Performing the conversion requires tech expertise and familiarity with MySQL, so we recommend looping in a database admin or another member of your tech team to help out.
Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
Stitch encountered an error when attempting to ‘talk’ to your database.
TroubleshootingVerify that the hostname entered in the Integration Settings page is correct.
For Amazon-RDS: check that the port has been removed from the end of the hostname string.
Verify that the port setting entered in the Integration Settings page is correct.
Verify that Stitch’s IP addresses (see below) are whitelisted.
For Amazon-RDS: Check that the Security Group and VPC Subnet associated with the database allows access from all Stitch’s IP addresses.
- 52.23.137.21/32
- 52.204.223.208/32
- 52.204.228.32/32
- 52.204.230.227/32
We encountered an error while attempting to check the type or version for this [database]. Please select the correct database type and try again.
The database type doesn’t match the database you selected in Stitch.
For example: you select MySQL in Stitch, but we detect that it’s actually a PostgreSQL database.
TroubleshootingVerify that you’ve selected the correct database type. If the incorrect database type was chosen, select the correct database type and try completing the setup again.
Something went wrong during the communication with the database.
TroubleshootingThis is a transient error and should clear itself during the next re-sync.
The credentials that Stitch has for your database are incorrect.
TroubleshootingVerify that the correct password for the user Stitch is using to connect to the database is entered in the Integration Settings page of Stitch.
The connection timed out before Stitch could successfully establish a connection.
TroubleshootingThis error may be transient and resolve on its own, but if it persists, try the following before contacting support:
Verify that the port setting entered in the Integration Settings page is correct.
Verify that Stitch’s IP addresses (see below) are whitelisted.
For Amazon-RDS: Check that the Security Group and VPC Subnet associated with the database allows access from all Stitch’s IP addresses.
- 52.23.137.21/32
- 52.204.223.208/32
- 52.204.228.32/32
- 52.204.230.227/32
Stitch encountered an internal issue.
TroubleshootingThis error is usually transient and will resolve on its own, but if it persists, please check our Status Page for reported service outages.
Check Stitch’s Status
If the troubleshooting steps detailed above don’t resolve the issue or if the errors persist, we recommend checking Stitch’s Status Page for reported service issues.
Contact Support
If there’s no reported service issue on our Status Page or you don’t see the error you’re receiving here, please get in touch with us.
To help us troubleshoot the problem quickly, please provide us with the following:
- The exact error you’re receiving. Providing us with the text or a screenshot is ideal.
- The type of database. Ex: MySQL.
- The display name of the database integration. This is the name of the integration as it appears on your Stitch dashboard page.
- Verification that Stitch’s IP addresses are whitelisted.
- Verification that the Stitch database user has the correct permissions for the type of database you’re connecting.
Questions? Feedback?
Did this article help? If you have questions or feedback, please reach out to us.