Setup TeamCity with MySQL

Permanently deleted user

Created April 04, 2019 11:30

I'm currently trailing TeamCity and i'd like to connect to a MySQL database, but i'm having no luck with it at the moment.

I'm installing from an Admin account, and i've followed the guide

Any other suggestions?

When i try to connect to the database i get the error:

Unexpected exception: SQL error when doing 'DML query' while performing SQL query: SQL DML: insert into single_row values ('X'): java.sql.SQLException: The table does not comply with the requirements by an external plugin

Log file:

[2019-04-04 11:49:09,900] INFO - jetbrains.buildServer.STARTUP - Current stage: Setting up database connection (administrator login is required to proceed)
[2019-04-04 12:06:39,826] INFO - jetbrains.buildServer.STARTUP - Generated JDBC connection string: jdbc:mysql://localhost:3310/TeamCity_DB?user=TeamCity&password=********
[2019-04-04 12:06:39,826] INFO - jetbrains.buildServer.STARTUP - Current stage: Creating a new database
[2019-04-04 12:06:39,826] INFO - jetbrains.buildServer.STARTUP - Creating a new database
[2019-04-04 12:06:39,830] INFO - jetbrains.buildServer.STARTUP - Database server time zone: GMT Daylight Time
[2019-04-04 12:06:39,830] INFO - jetbrains.buildServer.STARTUP - Database server character set and collation: utf8mb4.utf8mb4_0900_ai_ci
[2019-04-04 12:06:39,830] INFO - jetbrains.buildServer.STARTUP - Database character set: utf8
[2019-04-04 12:06:39,830] INFO - jetbrains.buildServer.STARTUP - Database collation: utf8_bin
[2019-04-04 12:06:39,830] INFO - jetbrains.buildServer.STARTUP - Database connection character set and collation: utf8mb4.utf8mb4_0900_ai_ci
[2019-04-04 12:06:39,830] INFO - jetbrains.buildServer.STARTUP - Database client character set: utf8mb4
[2019-04-04 12:06:39,846] INFO - jetbrains.buildServer.STARTUP - JDBC driver version: 8.0 (MySQL Connector/J)
[2019-04-04 12:06:39,846] INFO - jetbrains.buildServer.STARTUP - Database system version: 8.0.15 (MySQL)
[2019-04-04 12:06:39,846] INFO - jetbrains.buildServer.STARTUP - Connected to the database successfully
[2019-04-04 12:06:39,877] INFO - jetbrains.buildServer.STARTUP - Database contains no tables.
[2019-04-04 12:06:39,877] INFO - jetbrains.buildServer.STARTUP - Creating database schema
[2019-04-04 12:06:44,686] ERROR - jetbrains.buildServer.STARTUP - Unexpected exception: SQL error when doing 'DML query' while performing SQL query: SQL DML: insert into single_row values ('X'): java.sql.SQLException: The table does not comply with the requirements by an external plugin.
[2019-04-04 12:06:44,686] INFO - jetbrains.buildServer.STARTUP - Current stage: Setting up database connection (administrator login is required to proceed)

3 comments

Anatoly Cherenkov

Created April 11, 2019 16:32

Hi Adam,

Please double check that you are using innoDB engine.
If that doesn't help, you can try to isolate the issue by trying to disable strict mode and seeing if that helps.
Also which version of TeamCity are you using?

Anatoly

Permanently deleted user

Created June 10, 2019 11:17

Hi Anatoly,

How do i disable strict mode?

I'm using innoDB, teamcity seems to be creating some of the tables but comes up with:

Unexpected exception: SQL error when doing 'DML query' while performing SQL query: SQL DML: insert into single_row values ('X'): java.sql.SQLException: The table does not comply with the requirements by an external plugin.

MySql version: 8.0.15

teamCity version: 2018.2.3 (build 61544)

Permanently deleted user

Created June 10, 2019 14:23

Ok, i've got it working now.

What i did was go into the 'my.ini' (located => c:\programdata\mysql\mysql server 8.0\my.ini ) and disabled strict mode.

Thanks for your help Anatoly!

Please sign in to leave a comment.