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

0
1 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

0

Please sign in to leave a comment.