Failure creating MySQL database in 1438
I decided to start from scratch with 1438 (standalone version) and wiped out my MySQL database from the previous build. I modified buildServerSpring.xml as I had previously, removed ~/.BuildServer and started TeamCity with:
% bin/startup.sh
I end up with a partial database (5 tables - agent_sources_verion, deleted_build_types, history, running, vcs_support_info) but fail to complete the database creation.
I'm using MySQL 4.1.x. I'll put the key part of the log at the end.
On a somewhat related note, the mysql JDBC connector is GPL. I believe they would consider use of the jar as you do without release source for the product as in violation of the GPL. If you have a commercial license from them, ignore my message. If not, you might want to run it by your legal team. Or you could pull the jar and direct endusers where to get it.
--Tim
INFO - erver.serverSide.impl.DBFacade - Connection pool configu
red (com.mysql.jdbc.Driver, maximum number of connections: 50)
ERROR - r.serverSide.impl.DatabaseUtil -
java.sql.SQLException: BLOB/TEXT column 'VCS_ROOT' used in key specification wit
hout a key length
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2998)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2927)
at com.mysql.jdbc.Statement.execute(Statement.java:535)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.j
ava:261)
at jetbrains.buildServer.serverSide.impl.DBFacade.createVcsConnectionStatusT
able(DBFacade.java:361)
at jetbrains.buildServer.serverSide.impl.DBFacade.initDB(DBFacade.java:206)
at jetbrains.buildServer.serverSide.impl.DBFacade.createDatabase(DBFacade.ja
va:150)
at jetbrains.buildServer.serverSide.impl.DBFacade.(DBFacade.java:96)
at jetbrains.buildServer.serverSide.impl.BuildServerImpl.initServer(BuildSer
verImpl.java:160)
at jetbrains.buildServer.serverSide.impl.BuildServerImpl.]]>(BuildServerI
mpl.java:145)
Please sign in to leave a comment.
http://www.jetbrains.net/jira/browse/TW-554
Encountering issues creating a MySQL database with error code 1438? This error typically occurs when attempting to set a database to read-only mode during an active transaction. To resolve, ensure no active transactions are ongoing and retry the database creation process. Double-check your SQL statements for any errors and consult MySQL documentation or seek assistance from a database administrator if needed.