Intermittent issue "Unknown Database 'dbname'" when connecting to an Amazon Aurora database via Oracle MySQL Connector
Article ID: KB0081965
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | All Versions |
Description
When connecting to an Amazon Aurora database instance using the TIBCO Spotfire Oracle MySQL connector, the following error may get displayed intermittently:
External error:
Unknown database 'dbname'
Data connection:
Connection(number of connections open)
Issue/Introduction
When connecting to Aurora instance using Oracle Mysql connector, following error gets displayed intermittently
External error:
Unknown database 'dbname'
Data connection:
Connection(number of connections open)
This error is caused when you have maximum connections open or if Aurora instance CPU is at 100%
Resolution
This is a common issue with Oracle MySQL in general and may have many root causes. But when it comes to an Amazon Aurora database and when this error is seen only intermittently, then this error is most often caused when you have the maximum number of connections open or if the Aurora instance CPU is at 100%.
To resolve the issue close the active connections that are previously open or increase the size of the Amazon Aurora instance.
To resolve the issue close the active connections that are previously open or increase the size of the Amazon Aurora instance.
Feedback
Yes
No
Powered by
