After creating the schema, verification of the "db_version" table by the catalog has failed. Probably that database is configured incorrectly.

I installed latest version of Teamcity on a Windows 7 machine and when I navigate to web interface, I get the following error when I push the proceed button first time:

After creating the schema, verification of the "db_version" table by the catalog has failed. Probably that database is configured incorrectly.

jetbrains.buildServer.serverSide.db.UnexpectedDBException: After creating the schema, verification of the "db_version" table by the catalog has failed. Probably that database is configured incorrectly.
   at jetbrains.buildServer.serverSide.db.DBSchema.doubleCheckThatTableCreatedSuccessfully(DBSchema.java:163)
   at jetbrains.buildServer.serverSide.db.DBSchema.createSchemaTablesAndIndices(DBSchema.java:141)
   at jetbrains.buildServer.serverSide.db.DBSchema.createSchema(DBSchema.java:188)
   at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager$3.run(TeamCityDatabaseManager.java:497)
   at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager.withMaintenanceDBF(TeamCityDatabaseManager.java:473)
   at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager.createNewSchemaWithInitialData(TeamCityDatabaseManager.java:495)
   at jetbrains.buildServer.serverSide.versioning.VersionManager.ensureActualDatabase(VersionManager.java:434)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.processStartupServerInternal(TeamCityDispatcherServlet.java:174)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.processStartupServerSafe(TeamCityDispatcherServlet.java:382)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.access$400(TeamCityDispatcherServlet.java:24)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet$6.run(TeamCityDispatcherServlet.java:1)
   at java.lang.Thread.run(Unknown Source)


Any idea what causes this?
thanks!
12 comments
Comment actions Permalink

Here is the teamcity-server.log file:

[2012-04-19 17:57:25,444]   INFO -   jetbrains.buildServer.SERVER -






[2012-04-19 17:57:25,445]   INFO -   jetbrains.buildServer.SERVER - ===========================================================
[2012-04-19 17:57:25,445]   INFO -   jetbrains.buildServer.SERVER - Starting TeamCity server
[2012-04-19 17:57:25,473]   INFO -   jetbrains.buildServer.SERVER - TeamCity version: 7.0.2 (build 21349), data format version 514
[2012-04-19 17:57:25,477]   INFO -   jetbrains.buildServer.SERVER - TeamCity data directory: C:\Users\Tugberk\.BuildServer
[2012-04-19 17:57:25,832]   INFO -   jetbrains.buildServer.SERVER - Data directory format version: no configuration found
[2012-04-19 17:57:25,832]   INFO -   jetbrains.buildServer.SERVER - Database format version: neither internal database nor 'database.properties' file found
[2012-04-19 17:57:25,834]   INFO -   jetbrains.buildServer.SERVER - First TeamCity start detected (empty data directory). Please review settings shown on the web UI.
[2012-04-19 18:01:06,924]   INFO -   jetbrains.buildServer.SERVER - Initializing working state...
[2012-04-19 18:01:07,100]   INFO -   jetbrains.buildServer.SERVER - Creating Data Directory: C:\Users\Tugberk\.BuildServer
[2012-04-19 18:01:07,651]   INFO -   jetbrains.buildServer.SERVER - Database type: HSQL
[2012-04-19 18:01:07,651]   INFO -   jetbrains.buildServer.SERVER - Database connection URL: default (using internal database)
[2012-04-19 18:01:08,567]  ERROR -   jetbrains.buildServer.SERVER - Server startup exception: jetbrains.buildServer.serverSide.db.UnexpectedDBException: After creating the schema, verification of the "db_version" table by the catalog has failed. Probably that database is configured incorrectly.

jetbrains.buildServer.serverSide.db.UnexpectedDBException: After creating the schema, verification of the "db_version" table by the catalog has failed. Probably that database is configured incorrectly.

 at jetbrains.buildServer.serverSide.db.DBSchema.doubleCheckThatTableCreatedSuccessfully(DBSchema.java:163)
 at jetbrains.buildServer.serverSide.db.DBSchema.createSchemaTablesAndIndices(DBSchema.java:141)
 at jetbrains.buildServer.serverSide.db.DBSchema.createSchema(DBSchema.java:188)
 at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager$3.run(TeamCityDatabaseManager.java:497)
 at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager.withMaintenanceDBF(TeamCityDatabaseManager.java:473)
 at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager.createNewSchemaWithInitialData(TeamCityDatabaseManager.java:495)
 at jetbrains.buildServer.serverSide.versioning.VersionManager.ensureActualDatabase(VersionManager.java:434)
 at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.processStartupServerInternal(TeamCityDispatcherServlet.java:174)
 at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.processStartupServerSafe(TeamCityDispatcherServlet.java:382)
 at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.access$400(TeamCityDispatcherServlet.java:24)
 at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet$6.run(TeamCityDispatcherServlet.java:1)
 at java.lang.Thread.run(Unknown Source)
[2012-04-19 18:07:16,358]   INFO -   jetbrains.buildServer.SERVER - Performing SHUTDOWN on HSQL database...
[2012-04-19 18:07:16,621]   INFO -   jetbrains.buildServer.SERVER - HSQL database SHUTDOWN performed successfully.
[2012-04-19 18:07:19,749]   INFO -   jetbrains.buildServer.SERVER -






[2012-04-19 18:07:19,750]   INFO -   jetbrains.buildServer.SERVER - ===========================================================
[2012-04-19 18:07:19,751]   INFO -   jetbrains.buildServer.SERVER - Starting TeamCity server
[2012-04-19 18:07:19,778]   INFO -   jetbrains.buildServer.SERVER - TeamCity version: 7.0.2 (build 21349), data format version 514
[2012-04-19 18:07:19,782]   INFO -   jetbrains.buildServer.SERVER - TeamCity data directory: C:\Users\Tugberk\.BuildServer
[2012-04-19 18:07:20,137]   INFO -   jetbrains.buildServer.SERVER - Data directory format version: no configuration found
[2012-04-19 18:07:20,137]   INFO -   jetbrains.buildServer.SERVER - Database format version: neither internal database nor 'database.properties' file found
[2012-04-19 18:07:20,138]   INFO -   jetbrains.buildServer.SERVER - First TeamCity start detected (empty data directory). Please review settings shown on the web UI.
[2012-04-19 18:09:20,744]   INFO -   jetbrains.buildServer.SERVER -






[2012-04-19 18:09:20,745]   INFO -   jetbrains.buildServer.SERVER - ===========================================================
[2012-04-19 18:09:20,745]   INFO -   jetbrains.buildServer.SERVER - Starting TeamCity server
[2012-04-19 18:09:20,774]   INFO -   jetbrains.buildServer.SERVER - TeamCity version: 7.0.2 (build 21349), data format version 514
[2012-04-19 18:09:20,778]   INFO -   jetbrains.buildServer.SERVER - TeamCity data directory: C:\Users\Tugberk\.BuildServer
[2012-04-19 18:09:21,083]   INFO -   jetbrains.buildServer.SERVER - Data directory format version: no configuration found
[2012-04-19 18:09:21,083]   INFO -   jetbrains.buildServer.SERVER - Database format version: neither internal database nor 'database.properties' file found
[2012-04-19 18:09:21,084]   INFO -   jetbrains.buildServer.SERVER - First TeamCity start detected (empty data directory). Please review settings shown on the web UI.
[2012-04-19 18:09:23,609]   INFO -   jetbrains.buildServer.SERVER - Initializing working state...
[2012-04-19 18:09:24,075]   INFO -   jetbrains.buildServer.SERVER - Database type: HSQL
[2012-04-19 18:09:24,076]   INFO -   jetbrains.buildServer.SERVER - Database connection URL: default (using internal database)
[2012-04-19 18:09:24,470]  ERROR -   jetbrains.buildServer.SERVER - Server startup exception: jetbrains.buildServer.serverSide.db.UnexpectedDBException: After creating the schema, verification of the "db_version" table by the catalog has failed. Probably that database is configured incorrectly.

jetbrains.buildServer.serverSide.db.UnexpectedDBException: After creating the schema, verification of the "db_version" table by the catalog has failed. Probably that database is configured incorrectly.

 at jetbrains.buildServer.serverSide.db.DBSchema.doubleCheckThatTableCreatedSuccessfully(DBSchema.java:163)
 at jetbrains.buildServer.serverSide.db.DBSchema.createSchemaTablesAndIndices(DBSchema.java:141)
 at jetbrains.buildServer.serverSide.db.DBSchema.createSchema(DBSchema.java:188)
 at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager$3.run(TeamCityDatabaseManager.java:497)
 at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager.withMaintenanceDBF(TeamCityDatabaseManager.java:473)
 at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager.createNewSchemaWithInitialData(TeamCityDatabaseManager.java:495)
 at jetbrains.buildServer.serverSide.versioning.VersionManager.ensureActualDatabase(VersionManager.java:434)
 at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.processStartupServerInternal(TeamCityDispatcherServlet.java:174)
 at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.processStartupServerSafe(TeamCityDispatcherServlet.java:382)
 at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.access$400(TeamCityDispatcherServlet.java:24)
 at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet$6.run(TeamCityDispatcherServlet.java:1)
 at java.lang.Thread.run(Unknown Source)
[2012-04-19 18:11:02,415]   INFO -   jetbrains.buildServer.SERVER - Performing SHUTDOWN on HSQL database...
[2012-04-19 18:11:02,832]   INFO -   jetbrains.buildServer.SERVER - HSQL database SHUTDOWN performed successfully.
[2012-04-19 18:11:10,970]   INFO -   jetbrains.buildServer.SERVER -






[2012-04-19 18:11:10,971]   INFO -   jetbrains.buildServer.SERVER - ===========================================================
[2012-04-19 18:11:10,971]   INFO -   jetbrains.buildServer.SERVER - Starting TeamCity server
[2012-04-19 18:11:10,995]   INFO -   jetbrains.buildServer.SERVER - TeamCity version: 7.0.2 (build 21349), data format version 514
[2012-04-19 18:11:10,997]   INFO -   jetbrains.buildServer.SERVER - TeamCity data directory: C:\Users\Tugberk\.BuildServer
[2012-04-19 18:11:11,304]   INFO -   jetbrains.buildServer.SERVER - Data directory format version: no configuration found
[2012-04-19 18:11:11,304]   INFO -   jetbrains.buildServer.SERVER - Database format version: neither internal database nor 'database.properties' file found
[2012-04-19 18:11:11,305]   INFO -   jetbrains.buildServer.SERVER - First TeamCity start detected (empty data directory). Please review settings shown on the web UI.
[2012-04-19 18:11:53,746]   INFO -   jetbrains.buildServer.SERVER - Initializing working state...
[2012-04-19 18:11:54,216]   INFO -   jetbrains.buildServer.SERVER - Database type: HSQL
[2012-04-19 18:11:54,216]   INFO -   jetbrains.buildServer.SERVER - Database connection URL: default (using internal database)
[2012-04-19 18:11:54,627]  ERROR -   jetbrains.buildServer.SERVER - Server startup exception: jetbrains.buildServer.serverSide.db.UnexpectedDBException: After creating the schema, verification of the "db_version" table by the catalog has failed. Probably that database is configured incorrectly.

jetbrains.buildServer.serverSide.db.UnexpectedDBException: After creating the schema, verification of the "db_version" table by the catalog has failed. Probably that database is configured incorrectly.

 at jetbrains.buildServer.serverSide.db.DBSchema.doubleCheckThatTableCreatedSuccessfully(DBSchema.java:163)
 at jetbrains.buildServer.serverSide.db.DBSchema.createSchemaTablesAndIndices(DBSchema.java:141)
 at jetbrains.buildServer.serverSide.db.DBSchema.createSchema(DBSchema.java:188)
 at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager$3.run(TeamCityDatabaseManager.java:497)
 at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager.withMaintenanceDBF(TeamCityDatabaseManager.java:473)
 at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager.createNewSchemaWithInitialData(TeamCityDatabaseManager.java:495)
 at jetbrains.buildServer.serverSide.versioning.VersionManager.ensureActualDatabase(VersionManager.java:434)
 at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.processStartupServerInternal(TeamCityDispatcherServlet.java:174)
 at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.processStartupServerSafe(TeamCityDispatcherServlet.java:382)
 at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.access$400(TeamCityDispatcherServlet.java:24)
 at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet$6.run(TeamCityDispatcherServlet.java:1)
 at java.lang.Thread.run(Unknown Source)
[2012-04-19 18:49:21,511]   INFO -   jetbrains.buildServer.SERVER - Performing SHUTDOWN on HSQL database...
[2012-04-19 18:49:21,720]   INFO -   jetbrains.buildServer.SERVER - HSQL database SHUTDOWN performed successfully.
[2012-04-20 03:02:17,792]   INFO -   jetbrains.buildServer.SERVER -






[2012-04-20 03:02:17,816]   INFO -   jetbrains.buildServer.SERVER - ===========================================================
[2012-04-20 03:02:17,816]   INFO -   jetbrains.buildServer.SERVER - Starting TeamCity server
[2012-04-20 03:02:17,907]   INFO -   jetbrains.buildServer.SERVER - TeamCity version: 7.0.2 (build 21349), data format version 514
[2012-04-20 03:02:17,921]   INFO -   jetbrains.buildServer.SERVER - TeamCity data directory: C:\Users\Tugberk\.BuildServer
[2012-04-20 03:02:18,510]   INFO -   jetbrains.buildServer.SERVER - Data directory format version: no configuration found
[2012-04-20 03:02:18,511]   INFO -   jetbrains.buildServer.SERVER - Database format version: neither internal database nor 'database.properties' file found
[2012-04-20 03:02:18,512]   INFO -   jetbrains.buildServer.SERVER - First TeamCity start detected (empty data directory). Please review settings shown on the web UI.

0
Comment actions Permalink

And this is the buildserver.log under .BuildServer/system/buildserver.log:

CREATE USER SA PASSWORD "" ADMIN
/*C1*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C2*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C3*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C2*/create table db_version ( version_number integer not null, version_time datetime not null, constraint db_version_pk primary key (version_number) )
create table meta_file_line ( file_name varchar(15) not null, line_nr integer not null, line_text varchar(160), constraint meta_file_line_pk primary key (file_name, line_nr) )
create table single_row ( dummy_field char(1) )
create table agent ( id integer not null, name varchar(80) not null, host_addr varchar(80) not null, port integer not null, agent_type_id integer not null, status integer, authorized integer, registered integer, registration_timestamp bigint, last_binding_timestamp bigint, unregistered_reason varchar(256), authorization_token varchar(32), status_to_restore integer, status_restoring_timestamp bigint, constraint agent_pk primary key (id), constraint agent_name_ui unique (name) )
create index agent_host_address on agent (host_addr)
create index agent_authorization_token on agent (authorization_token)
create index agent_agent_type_id on agent (agent_type_id)
create table deleted_build_types ( build_type_id varchar(80) not null, delete_time bigint, constraint deleted_build_types_pk primary key (build_type_id) )
create table archived_projects ( project_id varchar(80) not null, user_id bigint, constraint archived_projects_pk primary key (project_id) )
create table build_data_storage ( build_id bigint not null, metric_id bigint not null, metric_value decimal(19) not null, constraint build_data_storage_pk primary key (build_id, metric_id) )
create table canceled_info ( build_id bigint not null, user_id bigint, description varchar(256), constraint canceled_info_pk primary key (build_id) )
create table running ( build_id bigint not null, agent_id integer, build_type_id varchar(80), build_start_time_agent bigint, build_start_time_server bigint, is_personal integer, build_number varchar(256), requestor varchar(1024), access_code varchar(60), queued_ag_restr_type_id integer, queued_ag_restr_id integer, queued_time bigint, remove_from_queue_time bigint, build_state_id bigint, agent_type_id integer, constraint running_pk primary key (build_id) )
create index running_state_id on running (build_state_id)
create table build_state ( id bigint not null, build_type_id varchar(80), modification_id bigint, is_personal integer default 0 not null, is_canceled integer default 0 not null, is_changes_detached integer default 0 not null, build_id bigint, constraint build_state_pk primary key (id) )
create index build_state_mod_id on build_state (modification_id)
create index build_state_build_type_id on build_state (build_type_id)
create index build_state_build_id on build_state (build_id)
create table build_dependency ( build_state_id bigint not null, depends_on bigint not null, dependency_options integer, constraint build_dependency_pk primary key (build_state_id, depends_on) )
create table build_attrs ( build_state_id bigint not null, attr_name varchar(200) not null, attr_value varchar(2000), constraint build_attrs_pk primary key (build_state_id, attr_name) )
create table build_artifact_dependency ( build_state_id bigint, source_build_type_id varchar(80), src_paths varchar(40960), revision_rule varchar(80) )
create index build_artif_dep_state_id on build_artifact_dependency (build_state_id)
create table final_artifact_dependency ( build_state_id bigint, source_build_type_id varchar(80), src_paths varchar(40960), revision_rule varchar(80) )
create index final_artif_dep_state_id on final_artifact_dependency (build_state_id)
create table agent_sources_version ( build_type_id varchar(80) not null, vcs_root_id integer not null, agent_id integer not null, vcs_settings_hash varchar(16) not null, checkout_dir varchar(2048), current_version varchar(80), constraint agent_sources_version_pk primary key (build_type_id, vcs_settings_hash, vcs_root_id, agent_id) )
create index agent_sources_version_hidx on agent_sources_version (vcs_settings_hash)
create table vcs_history ( modification_id bigint not null, user_name varchar(255), description varchar(4000), change_date bigint, register_date bigint, vcs_root_id integer, changes_count integer, version varchar(200) not null, display_version varchar(200), constraint vcs_history_pk primary key (modification_id) )
create index vcs_history_root on vcs_history (vcs_root_id)
create index vcs_history_user on vcs_history (user_name)
create index vcs_version_in_root_i on vcs_history (vcs_root_id, version)
create table build_type_vcs_change ( modification_id bigint not null, build_type_id varchar(80) not null, branch_id integer, constraint build_type_vcs_change_ui unique (modification_id, build_type_id) )
create index build_type_vcs_change_btid on build_type_vcs_change (build_type_id)
create index build_type_vcs_change_brcid on build_type_vcs_change (branch_id)
create table build_checkout_rules ( build_state_id bigint not null, build_type_id varchar(80) not null, vcs_root_id integer not null, checkout_rules varchar(2096), constraint build_checkout_rules_pk primary key (build_state_id, build_type_id, vcs_root_id) )
create table vcs_changes ( modification_id bigint, change_name varchar(64), vcs_file_name varchar(16000), relative_file_name varchar(16000), change_type integer, before_revision varchar(2048), after_revision varchar(2048) )
create index vcs_changes_index on vcs_changes (modification_id)
create table vcs_changes_graph ( child_modification_id bigint not null, child_revision varchar(200) not null, parent_num integer not null, parent_modification_id bigint, parent_revision varchar(200) not null, constraint vcs_changes_graph_pk primary key (child_modification_id, parent_num) )
create table personal_vcs_changes ( modification_id bigint, change_name varchar(64), vcs_file_name varchar(16000), relative_file_name varchar(16000), change_type integer, before_revision varchar(2048), after_revision varchar(2048) )
create index vcs_personal_changes_index on personal_vcs_changes (modification_id)
create table personal_vcs_history ( modification_id bigint not null, user_id bigint, description varchar(4096), change_date bigint, changes_count integer, commit_changes integer, scheduled_for_deletion integer, status integer, constraint personal_vcs_history_pk primary key (modification_id) )
create table test_names ( id bigint not null, test_name varchar(255) not null, constraint test_names_pk primary key (id) )
create table mute_info ( mute_id integer not null, muting_user_id bigint not null, muting_time datetime not null, muting_comment varchar(2000), scope char(1) not null, project_id varchar(80) not null, build_id bigint, unmute_when_fixed bit, unmute_by_time datetime, constraint mute_info_pk primary key (mute_id), constraint mute_info_ak unique (project_id, mute_id) )
create table mute_info_bt ( mute_id integer not null, build_type_id varchar(80) not null, constraint mute_info_bt_pk primary key (mute_id, build_type_id) )
create table mute_info_test ( mute_id integer not null, test_name_id bigint not null, constraint mute_info_test_pk primary key (mute_id, test_name_id) )
create table mute_test_in_proj ( mute_id integer not null, project_id varchar(80) not null, test_name_id bigint not null, constraint mute_test_in_proj_pk primary key (mute_id, project_id, test_name_id) )
create index mute_test_in_proj_ie on mute_test_in_proj (project_id, test_name_id, mute_id)
create table mute_test_in_bt ( mute_id integer not null, build_type_id varchar(80) not null, test_name_id bigint not null, constraint mute_test_in_bt_pk primary key (mute_id, build_type_id, test_name_id) )
create index mute_test_in_bt_ie on mute_test_in_bt (build_type_id, test_name_id, mute_id)
create table test_info ( build_id bigint not null, test_id integer not null, test_name_id bigint, status integer, duration integer default 0 not null, constraint test_info_pk primary key (build_id, test_id) )
create index test_name_id_idx on test_info (test_name_id)
create table test_info_trunk ( build_id bigint not null, test_id integer not null, test_name_id bigint, status integer, duration integer default 0 not null, constraint test_info_trunk_pk primary key (build_id, test_id) )
create index tit_name_id_idx on test_info_trunk (test_name_id)
create table test_muted ( build_id bigint not null, test_name_id bigint not null, mute_id integer not null, constraint test_muted_pk primary key (build_id, test_name_id, mute_id) )
create table test_failure_rate ( build_type_id varchar(80) not null, agent_id integer not null, test_name_id bigint not null, success_count integer, failure_count integer, last_failure_time bigint, constraint test_failure_rate_pk primary key (build_type_id, agent_id, test_name_id) )
create table paused_build_types ( build_type_id varchar(80) not null, who_user_id integer, commentary varchar(256), when_paused bigint, constraint paused_build_types_pk primary key (build_type_id) )
create table build_queue ( build_type_id varchar(80), agent_restrictor_type_id integer, agent_restrictor_id integer, requestor varchar(1024), when_queued bigint, pos integer, build_state_id bigint )
create index build_queue_build_state_id on build_queue (build_state_id)
create table remote_run_build_types ( source_type_id varchar(80), instance_id bigint, change_id bigint, id bigint not null, user_id bigint, constraint remote_run_build_types_pk primary key (id) )
create index remote_data_instance_id on remote_run_build_types (instance_id)
create index remote_data_instance_user_id on remote_run_build_types (user_id)
create index remote_data_instance_change_id on remote_run_build_types (change_id)
create index remote_data_instance_bt_id on remote_run_build_types (source_type_id)
create table stats ( build_id bigint not null, status integer, test_count integer, signature integer, status_text varchar(256), constraint stats_pk primary key (build_id) )
create table stats_publisher_state ( metric_id bigint not null, value bigint not null, constraint stats_publisher_state_pk primary key (metric_id) )
create table failed_tests_output ( build_id bigint not null, test_id integer not null, problem_description varchar(256), std_output varchar(40960), error_output varchar(40960), stacktrace varchar(40960), expected varchar(40960), actual varchar(40960), constraint failed_tests_output_pk primary key (build_id, test_id) )
create table compiler_output ( build_id bigint, message_order integer, message varchar(40960) )
create index co_build_id_index on compiler_output (build_id)
create table ignored_tests ( build_id bigint, test_id integer, test_name varchar(255), reason varchar(40960) )
create index ignored_tests_build_id on ignored_tests (build_id)
create table downloaded_artifacts ( target_build_id bigint, source_build_id bigint, artifact_path varchar(8192), download_timestamp bigint )
create index downloaded_artifacts_target_id on downloaded_artifacts (target_build_id)
create index downloaded_artifacts_source_id on downloaded_artifacts (source_build_id)
create table users ( id bigint not null, auth_type varchar(80) not null, realm varchar(60), username varchar(60) not null, name varchar(256), email varchar(256), last_login_timestamp bigint, password varchar(128), constraint users_pk primary key (id), constraint users_ak unique (auth_type, realm, username) )
create table user_property ( user_id bigint not null, key1 varchar(80) not null, value varchar(2048), constraint user_property_ui unique (user_id, key1) )
create table user_blocks ( user_id bigint not null, block_type varchar(80) not null, state varchar(2048), constraint user_blocks_ui unique (user_id, block_type) )
create table user_projects_visibility ( user_id bigint not null, project_id varchar(80) not null, visible integer not null, constraint user_projects_visibility_ui unique (user_id, project_id) )
create table user_projects_order ( user_id bigint not null, project_id varchar(80) not null, ordernum integer, constraint user_projects_order_ui unique (user_id, project_id) )
create table user_notification_events ( id bigint not null, user_id bigint not null, notificator_type varchar(20) not null, events_mask integer not null, constraint user_notification_events_pk primary key (id) )
create index notification_events_notifier on user_notification_events (notificator_type)
create index notification_events_user_id on user_notification_events (user_id)
create table user_watch_type ( rule_id bigint not null, user_id bigint not null, notificator_type varchar(20) not null, watch_type integer not null, watch_value varchar(80) not null, order_num bigint, constraint user_watch_type_ui unique (user_id, notificator_type, watch_type, watch_value) )
create index watch_type_rule_id on user_watch_type (rule_id)
create table user_roles ( user_id bigint not null, role_id varchar(80) not null, project_id varchar(80), constraint user_roles_ui unique (user_id, role_id, project_id) )
create table usergroups ( group_id varchar(16) not null, name varchar(255) not null, description varchar(2000), constraint usergroups_pk primary key (group_id), constraint usergroups_name unique (name) )
create table usergroup_users ( group_id varchar(16) not null, user_id bigint not null, constraint usergroup_users_ui unique (group_id, user_id) )
create table usergroup_subgroups ( hostgroup_id varchar(16) not null, subgroup_id varchar(16) not null, constraint usergroup_subgroups_ui unique (hostgroup_id, subgroup_id) )
create table usergroup_roles ( group_id varchar(16) not null, role_id varchar(80) not null, project_id varchar(80), constraint usergroup_roles_ui unique (group_id, role_id, project_id) )
create table usergroup_notification_events ( id bigint not null, group_id varchar(16) not null, notificator_type varchar(20) not null, events_mask integer not null, constraint usergroup_notific_evnts_pk primary key (id) )
create index usergroup_events_notifier on usergroup_notification_events (notificator_type)
create index usergroup_events_group_id on usergroup_notification_events (group_id)
create table usergroup_watch_type ( rule_id bigint not null, group_id varchar(16) not null, notificator_type varchar(20) not null, watch_type integer not null, watch_value varchar(80) not null, order_num bigint, constraint usergroup_watch_type_ui unique (group_id, notificator_type, watch_type, watch_value) )
create index group_watch_type_rule_id on usergroup_watch_type (rule_id)
create table server_property ( prop_name varchar(80) not null, prop_value varchar(256) not null, constraint server_property_ak unique (prop_name) )
create table build_revisions ( build_state_id bigint, vcs_root_id bigint, vcs_revision varchar(200), vcs_revision_display_name varchar(200) )
create index build_revisions_build on build_revisions (build_state_id)
create index build_revisions_vcs_root on build_revisions (vcs_root_id)
create table vcs_settings_hash ( vcs_root_id bigint not null, build_type_id varchar(80) not null, settings_hash bigint not null, vcs_revision varchar(200) not null, constraint vcs_settings_hash_pk primary key (vcs_root_id, build_type_id) )
create table user_build_parameters ( build_state_id bigint, param_name varchar(2000), param_value varchar(16000) )
create index user_build_params_state_id on user_build_parameters (build_state_id)
create table default_build_parameters ( build_state_id bigint, param_name varchar(2000), param_value varchar(16000) )
create index def_build_params_state_id on default_build_parameters (build_state_id)
create table build_labels ( build_id bigint, vcs_root_id bigint, label varchar(80), status integer default 0, error_message varchar(256) )
create index build_labels_build on build_labels (build_id)
create index build_labels_vcs_root on build_labels (vcs_root_id)
create table personal_build_relative_path ( build_id bigint, original_path_hash bigint, relative_path varchar(16000), constraint personal_build_relative_p_ak unique (build_id, original_path_hash) )
create table action_history ( object_id varchar(80), comment_id bigint, action integer, additional_data varchar(30) )
create index action_history_comment on action_history (comment_id)
create index action_history_object on action_history (object_id)
create index action_history_action_object_i on action_history (action, object_id)
create table audit_additional_object ( comment_id bigint, object_index integer, object_id varchar(80), object_name varchar(2500) )
create index audit_a_o_comment on audit_additional_object (comment_id)
create index audit_a_o_object_index on audit_additional_object (object_index)
create table remember_me ( user_key varchar(65) not null, secure bigint not null )
create table vcs_root_instance ( id integer not null, parent_id integer not null, settings_hash bigint not null, body varchar(16384), constraint vcs_root_instance_pk primary key (id) )
create index vcs_root_instance_parent_idx on vcs_root_instance (parent_id)
create index vcs_root_instance_hash_idx on vcs_root_instance (settings_hash)
create table vcs_root_state ( vcs_root_id integer not null, vcs_revision varchar(80), vcs_revision_display_name varchar(80), constraint vcs_root_id_pk primary key (vcs_root_id) )
create table comments ( id bigint not null, author_id bigint, when_changed bigint not null, commentary varchar(4096), constraint comments_pk primary key (id) )
create table build_runtime_info ( build_id bigint not null, rkey varchar(64) not null, value varchar(4000), constraint build_runtime_info_pk primary key (build_id, rkey) )
create table agent_pool ( agent_pool_id integer not null, agent_pool_name varchar(30) not null, constraint agent_pool_pk primary key (agent_pool_id), constraint agent_pool_ak unique (agent_pool_name) )
create table agent_pool_project ( agent_pool_id integer not null, project_id varchar(80) not null, constraint agent_pool_project_pk primary key (agent_pool_id, project_id) )
create table agent_type ( agent_type_id integer not null, agent_pool_id integer not null, cloud_code varchar(6) not null, profile_id varchar(30) not null, image_id varchar(60) not null, policy integer not null, constraint agent_type_pk primary key (agent_type_id), constraint agent_type_ak unique (cloud_code, profile_id, image_id) )
create index agent_type_pool_i on agent_type (agent_pool_id)
create table agent_type_bt_access ( agent_type_id integer not null, build_type_id varchar(80) not null, constraint agent_type_bt_access_pk primary key (agent_type_id, build_type_id) )
create index agent_type_bt_access_bt_i on agent_type_bt_access (build_type_id)
create table agent_type_info ( agent_type_id integer not null, os_name varchar(60) not null, cpu_rank integer, created_timestamp datetime, modified_timestamp datetime, constraint agent_type_info_pk primary key (agent_type_id) )
create table agent_type_runner ( agent_type_id integer not null, runner varchar(250) not null, constraint agent_type_runner_pk primary key (agent_type_id, runner) )
create table agent_type_vcs ( agent_type_id integer not null, vcs varchar(250) not null, constraint agent_type_vcs_pk primary key (agent_type_id, vcs) )
create table agent_type_param ( agent_type_id integer not null, param_kind char(1) not null, param_name varchar(160) not null, param_value varchar(2000), constraint agent_type_param_pk primary key (agent_type_id, param_kind, param_name) )
create table responsibilities ( problem_id varchar(40) not null, state integer not null, responsible_user_id bigint not null, reporter_user_id bigint, timestmp bigint, comments varchar(4096), constraint responsibilities_pk primary key (problem_id) )
create index responsibilities_reporter on responsibilities (reporter_user_id)
create index responsibilities_assignee on responsibilities (responsible_user_id)
create table cloud_started_instance ( profile_id varchar(30) not null, cloud_code varchar(6) not null, image_id varchar(80) not null, instance_id varchar(80) not null, last_update datetime not null, constraint cloud_started_instance_pk primary key (profile_id, cloud_code, image_id, instance_id) )
create table cloud_image_without_agent ( profile_id varchar(30) not null, cloud_code varchar(6) not null, image_id varchar(80) not null, last_update datetime not null, constraint cloud_image_without_agent_pk primary key (profile_id, cloud_code, image_id) )
create table inspection_results ( build_id bigint not null, hash bigint not null, line integer not null )
create index inspection_results_hash_index on inspection_results (hash)
create index inspection_results_buildhash_i on inspection_results (build_id, hash)
create table inspection_data ( hash bigint not null, result varchar(4000), severity integer, type_pattern integer, fqname varchar(4000), file_name varchar(255), parent_fqnames varchar(4000), parent_type_patterns varchar(20), module_name varchar(40), inspection_id bigint, is_local integer, constraint inspection_data_pk primary key (hash) )
create index inspection_data_file_index on inspection_data (file_name)
create index inspection_data_insp_index on inspection_data (inspection_id)
create table inspection_stats ( build_id bigint not null, total integer, new_total integer, old_total integer, errors integer, new_errors integer, old_errors integer, constraint inspection_stats_pk primary key (build_id) )
create table inspection_info ( id bigint not null, inspection_id varchar(255), inspection_name varchar(255), inspection_desc varchar(4000), group_name varchar(255), constraint inspection_info_pk primary key (id), constraint inspection_info_ak unique (inspection_id) )
create table inspection_fixes ( hash bigint not null, hint varchar(255) )
create index inspection_fixes_hash_index on inspection_fixes (hash)
create table inspection_diff ( build_id bigint not null, hash bigint not null, constraint inspection_diff_ak unique (build_id, hash) )
create index inspection_diff_hash_index on inspection_diff (hash)
create table duplicate_results ( id bigint not null, build_id bigint, hash integer, cost integer, constraint duplicate_results_pk primary key (id) )
create index duplicate_results_build_id on duplicate_results (build_id)
create table duplicate_fragments ( id bigint, file_id bigint, offset_info varchar(100), line integer )
create index duplicate_fragments_index on duplicate_fragments (id)
create index duplicate_fragments_file_index on duplicate_fragments (file_id)
create table fragments ( hash integer, file_id bigint, build_type_id varchar(80) )
create index duplicate_results_file_index on fragments (file_id)
create index fragments_hash_index on fragments (hash)
create table project_files ( file_id bigint not null, file_name varchar(255), constraint project_files_pk primary key (file_id) )
create index project_files_file_name_index on project_files (file_name)
create table duplicate_diff ( build_id bigint not null, hash bigint not null, constraint duplicate_diff_pk primary key (build_id, hash) )
create table duplicate_stats ( build_id bigint not null, total integer, new_total integer, old_total integer, constraint duplicate_stats_pk primary key (build_id) )
create table tc_build_tags ( tag varchar(255), build_id bigint )
create index tc_tags_id_index on tc_build_tags (build_id)
create index tc_tags_id_tag on tc_build_tags (tag)
create table build_set_tmp ( build_id bigint not null, constraint build_set_pk primary key (build_id) )
create table history ( build_id bigint not null, agent_name varchar(80), build_type_id varchar(80), build_start_time_server bigint, build_start_time_agent bigint, build_finish_time_server bigint, status integer, status_text varchar(256), user_status_text varchar(256), pin integer, is_personal integer, is_canceled integer, build_number varchar(256), requestor varchar(1024), queued_time bigint, remove_from_queue_time bigint, build_state_id bigint, agent_type_id integer, constraint history_pk primary key (build_id) )
create index start_time_index on history (build_start_time_server)
create index build_type_id_index on history (build_type_id)
create index pinned_index on history (pin)
create index status_index on history (status)
create index history_state_id on history (build_state_id)
create index history_agname_bfintimesrv_i on history (agent_name, build_finish_time_server)
create index history_finish_time_i on history (build_finish_time_server)
create index history_build_number on history (build_number)
create index history_agt_b_i on history (agent_type_id, build_id)
create table light_history ( build_id bigint not null, agent_name varchar(80), build_type_id varchar(80), build_start_time_server bigint, build_start_time_agent bigint, build_finish_time_server bigint, status integer, status_text varchar(256), user_status_text varchar(256), pin integer, is_personal integer, is_canceled integer, build_number varchar(256), requestor varchar(1024), queued_time bigint, remove_from_queue_time bigint, build_state_id bigint, agent_type_id integer, constraint light_history_pk primary key (build_id) )
create index start_time_index_light on light_history (build_start_time_server)
create index build_type_id_index_light on light_history (build_type_id)
create index pinned_index_light on light_history (pin)
create index status_index_light on light_history (status)
create index light_history_agname_bftime_i on light_history (agent_name, build_finish_time_server)
create index light_history_finish_time_i on light_history (build_finish_time_server)
create index light_history_agt_b_i on light_history (agent_type_id, build_id)
create table backup_info ( mproc_id integer not null, file_name varchar(1000), file_size bigint, started datetime not null, finished datetime, status char(1), constraint backup_info_pk primary key (mproc_id) )
create index backup_info_file_i on backup_info (file_name)
create table backup_builds ( build_id bigint not null, constraint backup_builds_ak unique (build_id) )
create table working_server ( starting_code bigint not null, starting_time datetime, ip_address varchar(15), application_info varchar(80) )
create table build_overriden_roots ( build_state_id bigint not null, original_vcs_root_id integer not null, substitution_vcs_root_id integer not null, constraint build_overriden_roots_pk primary key (build_state_id, original_vcs_root_id) )
create index build_subst_root_index on build_overriden_roots (substitution_vcs_root_id)
create global temporary table agent_pool$ ( agent_pool_id integer not null ) on commit preserve rows
create global temporary table agent_type$ ( agent_type_id integer not null ) on commit preserve rows
create global temporary table project$ ( project_id varchar(80) not null ) on commit preserve rows
create global temporary table build_type$ ( build_type_id varchar(80) not null ) on commit preserve rows
create global temporary table test$ ( test_name_id bigint not null ) on commit preserve rows
create table server ( server_id bigint )

0
Comment actions Permalink

Please can anyone help? I ran the process monitor and captured the activities going on under .BuildServer folder after I push the proceed button. I have the PML file. If you need, I can send that as well.

0
Comment actions Permalink

Is this your first installation of TeamCity? If so, I suppose you do not have much data under .BuildServer, I would try to remove it and start server again. If it does not help please provide more details about your installation steps. What distribution did you use, did you change anything, etc.

0
Comment actions Permalink

Hi,

I installed it several times. All the same.
Can you provide your e-mail address or direcly e-mail me so that I can send the process monitor dump?

0
Comment actions Permalink

I do not think proocess monitor will help us understand the problem. It seems we have similar issue in our tracker, but we were not able to reproduce this problem locally: http://youtrack.jetbrains.com/issue/TW-18232. Probably some combination of environment triggers this bug. What version of OS do you use? How did you install TeamCity (.exe?) Did you change Java used to start TeamCity server?

0
Comment actions Permalink

I am on Windows 7.
I am not aware of which java instance my machine is running.
I donwloaded the exe file and double clicked. I didn't change the default settings.

0
Comment actions Permalink

If possible please attach your .BuildServer to the issue: http://youtrack.jetbrains.com/issue/TW-18232. For now, as a workaround I can only suggest to setup external database, see more on this here: http://confluence.jetbrains.net/display/TCD7/Setting+up+an+External+Database

0
Comment actions Permalink

I realized something else while installing it again.
After I choose the Run under SYSTEM acount option for "Select Service Account" section and press next, it gives me Not Responding and crashes the windows explorer.

0
Comment actions Permalink

here, I attached the .BuildServer folder to this reply.



Attachment(s):
.BuildServer.zip
0
Comment actions Permalink

Hello Tugberk,

thank you for the attached zip.

Which locale is configured on your computer?
Did you install TeamCity as a Windows service or you started it from the command line? In case of the Windows service, could you please ensure that the user the service started by, has full access to the TeamCity Data directory (.BuildServer)?

Thanks!

Leonid Bushuev

0
Comment actions Permalink

Ok, I gave up. it is too much hassle for a setup.
Thanks!

0

Please sign in to leave a comment.