TeamCity setup stuck at - is starting - "Creating a new database" with MySQL
Hi,
in the initial setup we stuck at the step "Creating a new database". The process never finishes. There is no error in the logs (I checked every teamcity-xxx.log).
Last log entry of teamcity-server.log:
INFO - jetbrains.buildServer.STARTUP - userServerPrepStmts=true [defaults]
In the previous step I have downloaded the mysql jdbc driver and entered the database connection details - obviously the connection works, otherwise I would not be able to proceed to the next step.
Versioin: TeamCity 2024.12 (build 174331)
PS: If I choose the internal database it works.
Update: After 20 minutes I received a timeout error. But I do not understand why this happens, because the external database is accessible from every host (temporary without any firewall limitations for testing purposes).
ERROR [:23.503), node id: MAIN_SERVER] - jetbrains.buildServer.STARTUP - Could not connect to MySQL server: SQL error when doing 'Taking a connection from the data source': com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
Please sign in to leave a comment.
Hi Jua,
The issue you're experiencing seems to stem from a communication problem between TeamCity and the MySQL database.
Have you followed the official documentation to set up the external database? Please ensure the following steps are completed:
1. General Steps: Set up external database
2. On MySQL Server Side: MySQL-specific setup instructions.
3. On TeamCity Server Side (with MySQL): Configuration on the TeamCity side
For any questions or concerns, please do not hesitate to reach out.
Best Regards,
Tom