search

gocd / gocd-database-migrator

Migrating GoCD data between H2 / PostgreSQL / MySQL.
https://www.gocd.org
Apache License 2.0
2 stars 5 forks source link

org.postgresql.util.PSQLException: ERROR: relation "properties" does not exist #14

Closed sapnaswetha-s closed 2 years ago

sapnaswetha-s commented 2 years ago

Getting the following error while trying to migrate gocd server from H2 database to postgres 9.6: GoCD version : 20.4.0 Java version: 1.8.0_302

record copy progress 0% [=> ] 160000/16215439 record (0:00:07 / 0:11:44) 22857.1 record/s2021-11-23 10:10:33,834 ERROR [pool-2-thread-1] DbSync:87 - null org.postgresql.util.PSQLException: ERROR: relation "properties" does not exist Position: 13 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2578) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2313) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:331) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:310) at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:296) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:273) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:268) at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194) at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194) at com.thoughtworks.go.dbsync.Util.execute(Util.java:84) at com.thoughtworks.go.dbsync.Util.executeAndLog(Util.java:61) at com.thoughtworks.go.dbsync.DbSync.executAndLogInsertStatement(DbSync.java:373) at com.thoughtworks.go.dbsync.DbSync.dumpTableSQL(DbSync.java:356) at com.thoughtworks.go.dbsync.DbSync.lambda$doExport$13(DbSync.java:201) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) . . . . . record copy progress 40% [=================================================================> ] 6543237/16215439 record (0:11:20 / 0:16:46) 9622.4 record/s^[ 2021-11-23 10:21:47,001 INFO [main] DbSync:121 - Done copying database records. 2021-11-23 10:21:47,003 INFO [main] DbSync:126 - Setting sequences for all tables. 2021-11-23 10:21:47,017 ERROR [main] DbSync:87 - null org.postgresql.util.PSQLException: ERROR: relation "properties" does not exist Position: 57 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2578) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2313) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:331) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:310) at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:296) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:273) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:268) at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194) at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194) at com.thoughtworks.go.dbsync.Util.execute(Util.java:84) at com.thoughtworks.go.dbsync.Util.executeAndLog(Util.java:61) at com.thoughtworks.go.dbsync.DbSync.resetSequences(DbSync.java:310) at com.thoughtworks.go.dbsync.DbSync.lambda$export$7(DbSync.java:127) at com.thoughtworks.go.dbsync.Util.withDataSource(Util.java:97) at com.thoughtworks.go.dbsync.DbSync.lambda$export$11(DbSync.java:125) at com.thoughtworks.go.dbsync.DbSync.withWriter(DbSync.java:292) at com.thoughtworks.go.dbsync.DbSync.export(DbSync.java:101) at com.thoughtworks.go.dbsync.cli.Main.main(Main.java:46)

chadlwilson commented 2 years ago

Any idea on this one @arvindsv ?

It looks to me like the PROPERTIES table was dropped in GoCD 19.10 so I'm not quite sure I can explain why it might still be around on a working 20.4.0 H2 DB unless there are some cases that DbDeploy can skip applying migrations and continue.

arvindsv commented 2 years ago

I don't think that should be possible normally. Unless something has been tampered with.

Some of the line numbers don't match (at com.thoughtworks.go.dbsync.DbSync.export(DbSync.java:101) is an empty line). What version of the migrator is being used?

Are you positive that it's not an old database (from 19.x being used, by mistake)?

Can you show the full command-line you used?

Let us know, and if you're sure everything (asked above) looks right to you, I'll think of ways of digging deeper into the issue.

chadlwilson commented 2 years ago

Thanks @arvindsv - the "running against old/wrong H2 DB file" was my only thought (shared offline) too.

The relevant bit of another log (also shared offline by @sapnaswetha-s ) with redacted record numbers is below. Not sure if that points more in that direction but the line numbers seem correct at first glance, so possibly a re-run with the latest version.

2021-11-24 05:35:14,300 INFO  [main] DbSync:77 - Using dialect H2 for source database.
2021-11-24 05:35:14,380 INFO  [main] DbSync:78 - Using dialect POSTGRES for target database.
2021-11-24 05:35:14,382 DEBUG [main] DbSync:81 - Checking if source DB contains the changelog table from dbdeploy.
2021-11-24 05:35:14,393 DEBUG [main] DbSync:83 - Found changelog table, performing DB migrations using dbdeploy.
2021-11-24 05:35:14,433 DEBUG [main] DbSync:92 - Checking if target DB is empty.
2021-11-24 05:35:14,796 INFO  [main] DbSync:107 - Initializing database skeleton on target database.
2021-11-24 05:35:17,754 INFO  [main] DbSync:109 - Done initializing database skeleton on target database.
2021-11-24 05:35:17,755 INFO  [main] DbSync:113 - Initializing database views.
2021-11-24 05:35:17,992 INFO  [main] DbSync:115 - Done initializing database views.
2021-11-24 05:35:17,995 INFO  [main] DbSync:120 - Copying database records.
2021-11-24 05:35:18,025 INFO  [main] DbSync:190 - Found tables:
2021-11-24 05:35:18,028 INFO  [main] DbSync:193 -   MODIFIEDFILES: xyz records
2021-11-24 05:35:18,028 INFO  [main] DbSync:193 -   PROPERTIES: xyz records
2021-11-24 05:35:18,029 INFO  [main] DbSync:193 -   ACCESSTOKEN: 0 records
2021-11-24 05:35:18,029 INFO  [main] DbSync:193 -   DATASHARINGSETTINGS: xyz records
2021-11-24 05:35:18,030 INFO  [main] DbSync:193 -   PIPELINESTATES: xxx records
2021-11-24 05:35:18,030 INFO  [main] DbSync:193 -   PIPELINELABELCOUNTS: xxx records
2021-11-24 05:35:18,030 INFO  [main] DbSync:193 -   USAGEDATAREPORTING: xxx records
2021-11-24 05:35:18,031 INFO  [main] DbSync:193 -   ARTIFACTPLANS: xyz records
2021-11-24 05:35:18,032 INFO  [main] DbSync:193 -   STAGES: xyz records
2021-11-24 05:35:18,032 INFO  [main] DbSync:193 -   SERVERBACKUPS: xyz records
2021-11-24 05:35:18,032 INFO  [main] DbSync:193 -   VERSIONINFOS: xyz records
2021-11-24 05:35:18,032 INFO  [main] DbSync:193 -   RESOURCES: xyz records
2021-11-24 05:35:18,032 INFO  [main] DbSync:193 -   NOTIFICATIONFILTERS: xyz records
2021-11-24 05:35:18,032 INFO  [main] DbSync:193 -   BUILDS: xyz records
2021-11-24 05:35:18,033 INFO  [main] DbSync:193 -   PIPELINES: xyz records
2021-11-24 05:35:18,033 INFO  [main] DbSync:193 -   PIPELINEMATERIALREVISIONS: xyz records
2021-11-24 05:35:18,033 INFO  [main] DbSync:193 -   MODIFICATIONS: xyz records
2021-11-24 05:35:18,034 INFO  [main] DbSync:193 -   PIPELINESELECTIONS: xyz records
2021-11-24 05:35:18,039 INFO  [main] DbSync:193 -   PLUGINS: xyz records
2021-11-24 05:35:18,040 INFO  [main] DbSync:193 -   JOBAGENTMETADATA: 0 records
2021-11-24 05:35:18,040 INFO  [main] DbSync:193 -   BUILDSTATETRANSITIONS: xyz records
2021-11-24 05:35:18,040 INFO  [main] DbSync:193 -   ENVIRONMENTVARIABLES: xyz records
2021-11-24 05:35:18,040 INFO  [main] DbSync:193 -   AGENTS: xyz records
2021-11-24 05:35:18,040 INFO  [main] DbSync:193 -   STAGEARTIFACTCLEANUPPROHIBITED: xyz records
2021-11-24 05:35:18,041 INFO  [main] DbSync:193 -   USERS: xyz records
2021-11-24 05:35:18,041 INFO  [main] DbSync:193 -   MATERIALS: xyz records
2021-11-24 05:35:18,162 DEBUG [pool-2-thread-1] DbSync:329 - Copying xyz records in table MODIFIEDFILES
2021-11-24 05:35:18,171 DEBUG [pool-2-thread-2] DbSync:329 - Copying xyz records in table PROPERTIES
2021-11-24 05:35:19,004 DEBUG [pool-2-thread-2] DbSync:81 - Executing SQL: insert into PROPERTIES (ID, BUILDID, KEY, VALUE) values (1, 11, 'cruise_pipeline_label', '1'), (2, 1
2021-11-24 05:35:19,054 ERROR [pool-2-thread-2] DbSync:87 - null
org.postgresql.util.PSQLException: ERROR: relation "properties" does not exist
  Position: 13
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2578)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2313)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:331)
    at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448)
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369)
    at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:310)
    at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:296)
    at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:273)
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:268)
    at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194)
    at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194)
    at com.thoughtworks.go.dbsync.Util.execute(Util.java:84)
    at com.thoughtworks.go.dbsync.Util.executeAndLog(Util.java:61)
    at com.thoughtworks.go.dbsync.DbSync.executAndLogInsertStatement(DbSync.java:374)
    at com.thoughtworks.go.dbsync.DbSync.dumpTableSQL(DbSync.java:357)
    at com.thoughtworks.go.dbsync.DbSync.lambda$doExport$13(DbSync.java:202)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
2021-11-24 05:35:19,055 ERROR [pool-2-thread-2] DbSync:204 - null
java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: relation "properties" does not exist
  Position: 13
    at com.thoughtworks.go.dbsync.Util.execute(Util.java:88)
    at com.thoughtworks.go.dbsync.Util.executeAndLog(Util.java:61)
    at com.thoughtworks.go.dbsync.DbSync.executAndLogInsertStatement(DbSync.java:374)
    at com.thoughtworks.go.dbsync.DbSync.dumpTableSQL(DbSync.java:357)
    at com.thoughtworks.go.dbsync.DbSync.lambda$doExport$13(DbSync.java:202)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "properties" does not exist
  Position: 13
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2578)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2313)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:331)
    at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448)
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369)
    at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:310)
    at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:296)
    at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:273)
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:268)
    at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194)
    at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194)
    at com.thoughtworks.go.dbsync.Util.execute(Util.java:84)
    ... 7 common frames omitted

Nevertheless, would be good to confirm the specific migrator version being used, so we are not juggling too many variables.

sapnaswetha-s commented 2 years ago

@arvindsv Migrator version used : 1.0.0-39

arvindsv commented 2 years ago

Can you get a copy of the cruise.h2.db into the gocd-database-migrator directory and run the command below?

java -cp lib/h2-1.4.200.jar org.h2.tools.Shell -url jdbc:h2:./cruise -user sa -sql 'SELECT * FROM changelog'

Here's an example (run on a 20.4.0 database):

$ pwd
/tmp/gocd-database-migrator-1.0.0

$ ls
backup.sql  bin/  cruise.h2.db  h2deltas/  lib/  LICENSE  licenses/  pgdeltas/  README.md

# Notice cruise.h2.db above.

$ java -cp lib/h2-1.4.200.jar org.h2.tools.Shell -url jdbc:h2:./cruise -user sa -sql 'SELECT * FROM changelog'
CHANGE_NUMBER | DELTA_SET | START_DT                | COMPLETE_DT             | APPLIED_BY | DESCRIPTION
1             | DDL       | 2021-11-24 15:30:26.672 | 2021-11-24 15:30:26.838 | SA         | 1_create_initial_tables.sql
2             | DDL       | 2021-11-24 15:30:26.843 | 2021-11-24 15:30:26.868 | SA         | 2_create_indexes.sql
3             | DDL       | 2021-11-24 15:30:26.874 | 2021-11-24 15:30:26.906 | SA         | 3_add_build_ignored_column.sql
4             | DDL       | 2021-11-24 15:30:26.915 | 2021-11-24 15:30:26.936 | SA         | 4_add_check_externals_column.sql
5             | DDL       | 2021-11-24 15:30:26.944 | 2021-11-24 15:30:26.961 | SA         | 5_add_from_external_column.sql
6             | DDL       | 2021-11-24 15:30:26.967 | 2021-11-24 15:30:26.998 | SA         | 6_add_pipeline_label.sql
7             | DDL       | 2021-11-24 15:30:27.002 | 2021-11-24 15:30:27.013 | SA         | 7_add_pipeline_label_counters.sql
8             | DDL       | 2021-11-24 15:30:27.016 | 2021-11-24 15:30:27.054 | SA         | 8_add_build_cause_buffer.sql
9             | DDL       | 2021-11-24 15:30:27.062 | 2021-11-24 15:30:27.074 | SA         | 9_add_material_properties_table.sql
10            | DDL       | 2021-11-24 15:30:27.079 | 2021-11-24 15:30:27.09  | SA         | 10_add_stage_timestamp.sql
11            | DDL       | 2021-11-24 15:30:27.096 | 2021-11-24 15:30:27.114 | SA         | 11_add_stage_order.sql
12            | DDL       | 2021-11-24 15:30:27.119 | 2021-11-24 15:30:27.147 | SA         | 12_add_stage_result.sql
13            | DDL       | 2021-11-24 15:30:27.15  | 2021-11-24 15:30:27.16  | SA         | 13_add_stage_approvalType.sql
14            | DDL       | 2021-11-24 15:30:27.162 | 2021-11-24 15:30:27.166 | SA         | 14_add_name_pipelineId_index_for_stages.sql
15            | DDL       | 2021-11-24 15:30:27.169 | 2021-11-24 15:30:27.173 | SA         | 15_add_name_agentId_buildid_index_for_builds.sql
16            | DDL       | 2021-11-24 15:30:27.175 | 2021-11-24 15:30:27.181 | SA         | 16_add_folder_to_materials.sql
17            | DDL       | 2021-11-24 15:30:27.183 | 2021-11-24 15:30:27.197 | SA         | 17_correct_integrity_issues_in_stages.sql
18            | DDL       | 2021-11-24 15:30:27.199 | 2021-11-24 15:30:27.203 | SA         | 18_change_material_properties_value_to_nvarchar.sql
19            | DDL       | 2021-11-24 15:30:27.205 | 2021-11-24 15:30:27.209 | SA         | 19_change_material_url_to_nvarchar.sql
20            | DDL       | 2021-11-24 15:30:27.211 | 2021-11-24 15:30:27.217 | SA         | 20_add_artifact_properties_generator_table.sql
21            | DDL       | 2021-11-24 15:30:27.219 | 2021-11-24 15:30:27.233 | SA         | 21_add_materialId_to_modifications.sql
22            | DDL       | 2021-11-24 15:30:27.236 | 2021-11-24 15:30:27.242 | SA         | 22_remove_pipelineId_from_modifications.sql
23            | DDL       | 2021-11-24 15:30:27.244 | 2021-11-24 15:30:27.253 | SA         | 23_add_index_for_stages.sql
24            | DDL       | 2021-11-24 15:30:27.256 | 2021-11-24 15:30:27.263 | SA         | 24_add_columns_for_dependency_materials.sql
25            | DDL       | 2021-11-24 15:30:27.265 | 2021-11-24 15:30:27.269 | SA         | 25_change_length_of_revision_to_1024_for_modifications.sql
26            | DDL       | 2021-11-24 15:30:27.271 | 2021-11-24 15:30:27.275 | SA         | 26_add_table_fetch_artifact_plans.sql
27            | DDL       | 2021-11-24 15:30:27.278 | 2021-11-24 15:30:27.287 | SA         | 27_set_not_null_on_fetch_artifact_plans.sql
28            | DDL       | 2021-11-24 15:30:27.289 | 2021-11-24 15:30:27.292 | SA         | 28_drop_table_fetch_artifacts.sql
29            | DDL       | 2021-11-24 15:30:27.294 | 2021-11-24 15:30:27.344 | SA         | 29_fix_hsqldb_migration.sql
30            | DDL       | 2021-11-24 15:30:27.348 | 2021-11-24 15:30:27.36  | SA         | 30_add_buildcause_message_to_pipeline.sql
31            | DDL       | 2021-11-24 15:30:27.362 | 2021-11-24 15:30:27.366 | SA         | 31_add_user_setting.sql
32            | DDL       | 2021-11-24 15:30:27.368 | 2021-11-24 15:30:27.373 | SA         | 32_add_email_me_column.sql
33            | DDL       | 2021-11-24 15:30:27.376 | 2021-11-24 15:30:27.38  | SA         | 33_add_unique_constraint_to_name_column_on_usersettings.sql
34            | DDL       | 2021-11-24 15:30:27.382 | 2021-11-24 15:30:27.388 | SA         | 34_add_changed_column_to_modifications.sql
35            | DDL       | 2021-11-24 15:30:27.39  | 2021-11-24 15:30:27.394 | SA         | 35_rename_usersettings_table.sql
36            | DDL       | 2021-11-24 15:30:27.396 | 2021-11-24 15:30:27.401 | SA         | 36_add_notificationfilters_table.sql
37            | DDL       | 2021-11-24 15:30:27.403 | 2021-11-24 15:30:27.405 | SA         | 37_make_the_pipeline_name_case_insensitive.sql
38            | DDL       | 2021-11-24 15:30:27.407 | 2021-11-24 15:30:27.409 | SA         | 38_make_the_stage_name_case_insensitive.sql
39            | DDL       | 2021-11-24 15:30:27.411 | 2021-11-24 15:30:27.413 | SA         | 39_make_the_job_name_case_insensitive.sql
40            | DDL       | 2021-11-24 15:30:27.415 | 2021-11-24 15:30:27.417 | SA         | 40_undo_pipelines_case_insensitive_change.sql
41            | DDL       | 2021-11-24 15:30:27.419 | 2021-11-24 15:30:27.422 | SA         | 41_add_builds_index_on_name_state_and_stageid.sql
42            | DDL       | 2021-11-24 15:30:27.424 | 2021-11-24 15:30:27.43  | SA         | 42_add_counter_to_pipelines.sql
43            | DDL       | 2021-11-24 15:30:27.431 | 2021-11-24 15:30:27.434 | SA         | 43_alter_modifiedFiles_fileName.sql
44            | DDL       | 2021-11-24 15:30:27.436 | 2021-11-24 15:30:27.441 | SA         | 44_added_name_column_into_material.sql
45            | DDL       | 2021-11-24 15:30:27.443 | 2021-11-24 15:30:27.449 | SA         | 45_remove_matcher_from_builds.sql
46            | DDL       | 2021-11-24 15:30:27.451 | 2021-11-24 15:30:27.472 | SA         | 46_remove_material_properties.sql
47            | DDL       | 2021-11-24 15:30:27.474 | 2021-11-24 15:30:27.554 | SA         | 47_create_new_materials.sql
48            | DDL       | 2021-11-24 15:30:27.556 | 2021-11-24 15:30:27.575 | SA         | 48_add_name_to_material_instance.sql
49            | DDL       | 2021-11-24 15:30:27.577 | 2021-11-24 15:30:27.58  | SA         | 49_add_unique_constraint_to_revisions.sql
50            | DDL       | 2021-11-24 15:30:27.582 | 2021-11-24 15:30:27.588 | SA         | 50_add_run_on_all_agents_to_builds.sql
51            | DDL       | 2021-11-24 15:30:27.59  | 2021-11-24 15:30:27.593 | SA         | 51_add_environment_variable_properties.sql
52            | DDL       | 2021-11-24 15:30:27.595 | 2021-11-24 15:30:27.599 | SA         | 52_add_pipeline_lock.sql
53            | DDL       | 2021-11-24 15:30:27.601 | 2021-11-24 15:30:27.603 | SA         | 53_add_index_on_pipelines_locked.sql
54            | DDL       | 2021-11-24 15:30:27.605 | 2021-11-24 15:30:27.612 | SA         | 54_add_stage_id_to_build_transitions.sql
55            | DDL       | 2021-11-24 15:30:27.614 | 2021-11-24 15:30:27.623 | SA         | 55_add_completed_at_transition_id_to_stages.sql
56            | DDL       | 2021-11-24 15:30:27.625 | 2021-11-24 15:30:27.628 | SA         | 56_create_index_on_environment_variables_job_id.sql
57            | DDL       | 2021-11-24 15:30:27.63  | 2021-11-24 15:30:27.636 | SA         | 57_add_state_to_stage.sql
58            | DDL       | 2021-11-24 15:30:27.638 | 2021-11-24 15:30:27.643 | SA         | 58_add_natural_order_to_pipelines.sql
59            | DDL       | 2021-11-24 15:30:27.645 | 2021-11-24 15:30:27.647 | SA         | 59_create_index_on_stages_state.sql
60            | DDL       | 2021-11-24 15:30:27.648 | 2021-11-24 15:30:27.655 | SA         | 60_support_for_variables_at_different_levels.sql
61            | DDL       | 2021-11-24 15:30:27.657 | 2021-11-24 15:30:27.66  | SA         | 61_migrate_old_pipelines_to_have_counter.sql
62            | DDL       | 2021-11-24 15:30:27.662 | 2021-11-24 15:30:27.717 | SA         | 62_migrate_dependency_modifications_to_use_pipeline_counter_based_stage_locator.sql
63            | DDL       | 2021-11-24 15:30:27.718 | 2021-11-24 15:30:27.728 | SA         | 63_add_schedule_to_and_from_revisions.sql
64            | DDL       | 2021-11-24 15:30:27.729 | 2021-11-24 15:30:27.757 | SA         | 64_populate_missing_pipeline_label_in_modifications.sql
65            | DDL       | 2021-11-24 15:30:27.759 | 2021-11-24 15:30:27.775 | SA         | 65_repoint_FROM_to_TO_for_dependency_pmr.sql
66            | DDL       | 2021-11-24 15:30:27.777 | 2021-11-24 15:30:27.786 | SA         | 66_remove_schedule_to_and_from_revisions.sql
67            | DDL       | 2021-11-24 15:30:27.788 | 2021-11-24 15:30:27.791 | SA         | 67_create_pipeline_selections_table.sql
68            | DDL       | 2021-11-24 15:30:27.792 | 2021-11-24 15:30:27.795 | SA         | 68_add_foreign_key_from_pmr_to_pipeline.sql
69            | DDL       | 2021-11-24 15:30:27.797 | 2021-11-24 15:30:27.799 | SA         | 69_create_index_on_builds_name_and_stage_id.sql
70            | DDL       | 2021-11-24 15:30:27.8   | 2021-11-24 15:30:27.811 | SA         | 70_change_pipeline_stage_and_job_name_to_varchar_ignorecase.sql
71            | DDL       | 2021-11-24 15:30:27.812 | 2021-11-24 15:30:27.82  | SA         | 71_add_latest_run_flag_on_stage.sql
72            | DDL       | 2021-11-24 15:30:27.821 | 2021-11-24 15:30:27.825 | SA         | 72_create_builds_view.sql
73            | DDL       | 2021-11-24 15:30:27.826 | 2021-11-24 15:30:27.83  | SA         | 73_create_stages_view.sql
74            | DDL       | 2021-11-24 15:30:27.831 | 2021-11-24 15:30:27.834 | SA         | 74_add_unique_constraint_for_stages_on_pipelineId_name_counter.sql
75            | DDL       | 2021-11-24 15:30:27.836 | 2021-11-24 15:30:27.839 | SA         | 75_create_agent_cookie_mapping_table.sql
76            | DDL       | 2021-11-24 15:30:27.841 | 2021-11-24 15:30:27.848 | SA         | 76_create_oauth_tables.sql
77            | DDL       | 2021-11-24 15:30:27.85  | 2021-11-24 15:30:27.857 | SA         | 77_add_enabled_to_users.sql
78            | DDL       | 2021-11-24 15:30:27.86  | 2021-11-24 15:30:27.868 | SA         | 78_add_fetchMaterials_to_stages.sql
79            | DDL       | 2021-11-24 15:30:27.869 | 2021-11-24 15:30:27.878 | SA         | 79_recreate_build_and_stages_views.sql
80            | DDL       | 2021-11-24 15:30:27.88  | 2021-11-24 15:30:27.892 | SA         | 80_add_cleanWorkingDir_to_stages.sql
81            | DDL       | 2021-11-24 15:30:27.894 | 2021-11-24 15:30:27.901 | SA         | 81_recreate_build_and_stages_views.sql
82            | DDL       | 2021-11-24 15:30:27.903 | 2021-11-24 15:30:27.906 | SA         | 82_make_oauth_client_names_unique.sql
83            | DDL       | 2021-11-24 15:30:27.908 | 2021-11-24 15:30:27.917 | SA         | 83_create_gadget_oauth_tables.sql
84            | DDL       | 2021-11-24 15:30:27.918 | 2021-11-24 15:30:27.95  | SA         | 84_add_pipelineId_to_modifications.sql
85            | DDL       | 2021-11-24 15:30:27.951 | 2021-11-24 15:30:27.956 | SA         | 85_add_materialId_to_pipelineMaterialRevisions.sql
86            | DDL       | 2021-11-24 15:30:27.957 | 2021-11-24 15:30:27.976 | SA         | 86_add_actual_from_revision_to_pmr.sql
87            | DDL       | 2021-11-24 15:30:27.977 | 2021-11-24 15:30:27.978 | SA         | 87_create_index_modifications_materialId.sql
88            | DDL       | 2021-11-24 15:30:27.979 | 2021-11-24 15:30:27.998 | SA         | 88_rerun_to_actual_job_mapping.sql
89            | DDL       | 2021-11-24 15:30:27.999 | 2021-11-24 15:30:28.013 | SA         | 89_adding_rerun_of_counter_for_rerun_job_stages.sql
90            | DDL       | 2021-11-24 15:30:28.014 | 2021-11-24 15:30:28.036 | SA         | 90_populate_missing_completed_at_transition_id.sql
221001        | DDL       | 2021-11-24 15:30:28.037 | 2021-11-24 15:30:28.046 | SA         | 221001_fix_incomplete_stages_and_jobs.sql
230001        | DDL       | 2021-11-24 15:30:28.047 | 2021-11-24 15:30:28.066 | SA         | 230001_add_column_artifacts_deleted_to_stage.sql
230002        | DDL       | 2021-11-24 15:30:28.067 | 2021-11-24 15:30:28.078 | SA         | 230002_populate_missing_completed_by_transition_id.sql
230003        | DDL       | 2021-11-24 15:30:28.079 | 2021-11-24 15:30:28.084 | SA         | 230003_stop_persisting_material_password.sql
230004        | DDL       | 2021-11-24 15:30:28.085 | 2021-11-24 15:30:28.092 | SA         | 230004_add_config_version_to_stage.sql
230005        | DDL       | 2021-11-24 15:30:28.093 | 2021-11-24 15:30:28.095 | SA         | 230005_add_index_bst_buildid_currentstate.sql
230006        | DDL       | 2021-11-24 15:30:28.096 | 2021-11-24 15:30:28.109 | SA         | 230006_make_user_name_case_insensitive.sql
230007        | DDL       | 2021-11-24 15:30:28.11  | 2021-11-24 15:30:28.123 | SA         | 230007_add_completed_time_on_job_and_stage.sql
230008        | DDL       | 2021-11-24 15:30:28.124 | 2021-11-24 15:30:28.125 | SA         | 230008_drop_unique_revisions_for_material_constraint.sql
230009        | DDL       | 2021-11-24 15:30:28.126 | 2021-11-24 15:30:28.128 | SA         | 230009_update_git_material_with_null_branch_to_use_branch_master.sql
240001        | DDL       | 2021-11-24 15:30:28.129 | 2021-11-24 15:30:28.133 | SA         | 240001_add_userid_column_to_pipelineselections.sql
240002        | DDL       | 2021-11-24 15:30:28.134 | 2021-11-24 15:30:28.137 | SA         | 240002_add_disableLicenseExpiryWarning_to_users.sql
300001        | DDL       | 2021-11-24 15:30:28.138 | 2021-11-24 15:30:28.139 | SA         | 300001_add_serverBackup_table.sql
300002        | DDL       | 2021-11-24 15:30:28.14  | 2021-11-24 15:30:28.146 | SA         | 300002_add_pause_info_column.sql
300003        | DDL       | 2021-11-24 15:30:28.146 | 2021-11-24 15:30:28.15  | SA         | 300003_add_serveralias_column_to_material_instance.sql
300004        | DDL       | 2021-11-24 15:30:28.151 | 2021-11-24 15:30:28.153 | SA         | 300004_create_luau_state_table.sql
300005        | DDL       | 2021-11-24 15:30:28.154 | 2021-11-24 15:30:28.157 | SA         | 300005_drop_auth_state_column_from_luau_state.sql
300006        | DDL       | 2021-11-24 15:30:28.158 | 2021-11-24 15:30:28.168 | SA         | 300006_add_tfs_material_attributes.sql
300007        | DDL       | 2021-11-24 15:30:28.169 | 2021-11-24 15:30:28.172 | SA         | 300007_add_display_name_column_to_users.sql
300008        | DDL       | 2021-11-24 15:30:28.173 | 2021-11-24 15:30:28.177 | SA         | 300008_create_luau_groups.sql
300009        | DDL       | 2021-11-24 15:30:28.178 | 2021-11-24 15:30:28.182 | SA         | 300009_add_secure_column_to_environment_variables.sql
300010        | DDL       | 2021-11-24 15:30:28.183 | 2021-11-24 15:30:28.184 | SA         | 300010_add_column_to_store_last_successful_sync_time.sql
300011        | DDL       | 2021-11-24 15:30:28.185 | 2021-11-24 15:30:28.19  | SA         | 300011_remove_column_workspace_owner.sql
1202001       | DDL       | 2021-11-24 15:30:28.19  | 2021-11-24 15:30:28.192 | SA         | 1202001_fix_dependency_material_fingerprint_to_adjust_serveralias.sql
1202002       | DDL       | 2021-11-24 15:30:28.193 | 2021-11-24 15:30:28.198 | SA         | 1202002_add_domain_column_to_material_instance.sql
1202003       | DDL       | 2021-11-24 15:30:28.199 | 2021-11-24 15:30:28.202 | SA         | 1202003_remove_ignore_case_from_domain_column_to_material_instance.sql
1203002       | DDL       | 2021-11-24 15:30:28.203 | 2021-11-24 15:30:28.205 | SA         | 1203002_add_user_column_to_server_backup_table.sql
1203003       | DDL       | 2021-11-24 15:30:28.205 | 2021-11-24 15:30:28.206 | SA         | 1203003_zap_natural_order_values.sql
1203004       | DDL       | 2021-11-24 15:30:28.207 | 2021-11-24 15:30:28.211 | SA         | 1203004_kill_remote_dependency_material.sql
1203005       | DDL       | 2021-11-24 15:30:28.212 | 2021-11-24 15:30:28.213 | SA         | 1203005_add_index_on_modifications_revision.sql
1301001       | DDL       | 2021-11-24 15:30:28.214 | 2021-11-24 15:30:28.218 | SA         | 1301001_drop_build_event_column_from_builds.sql
1302001       | DDL       | 2021-11-24 15:30:28.219 | 2021-11-24 15:30:28.224 | SA         | 1302001_add_configuration_field_to_materials_table.sql
1303001       | DDL       | 2021-11-24 15:30:28.225 | 2021-11-24 15:30:28.228 | SA         | 1303001_add_additional_data_field_to_modifications_table.sql
1303002       | DDL       | 2021-11-24 15:30:28.229 | 2021-11-24 15:30:28.23  | SA         | 1303002_add_index_to_builds_on_stageId.sql
1303003       | DDL       | 2021-11-24 15:30:28.23  | 2021-11-24 15:30:28.232 | SA         | 1303003_add_index_to_stages_resources_tables.sql
1303004       | DDL       | 2021-11-24 15:30:28.232 | 2021-11-24 15:30:28.235 | SA         | 1303004_indexes_based_on_purge_tool.sql
1304001       | DDL       | 2021-11-24 15:30:28.236 | 2021-11-24 15:30:28.238 | SA         | 1304001_remove_luau_related_entries.sql
1401001       | DDL       | 2021-11-24 15:30:28.238 | 2021-11-24 15:30:28.239 | SA         | 1401001_recreating_trigger_because_of_cruise_to_go_change.sql
1403001       | DDL       | 2021-11-24 15:30:28.24  | 2021-11-24 15:30:28.241 | SA         | 1403001_fix_null_artifacttype_on_artifactplans_table.sql
1403002       | DDL       | 2021-11-24 15:30:28.242 | 2021-11-24 15:30:28.246 | SA         | 1403002_add_runMultipleInstance_column_on_builds_table_recreate_view.sql
1501001       | DDL       | 2021-11-24 15:30:28.247 | 2021-11-24 15:30:28.25  | SA         | 1501001_rename_pipeline_selections_unselected_pipelines_column_to_selections.sql
1501002       | DDL       | 2021-11-24 15:30:28.251 | 2021-11-24 15:30:28.255 | SA         | 1501002_add_comment_column_to_pipelines.sql
1501003       | DDL       | 2021-11-24 15:30:28.256 | 2021-11-24 15:30:28.259 | SA         | 1501003_add_additional_data_field_to_materials_table.sql
1502001       | DDL       | 2021-11-24 15:30:28.26  | 2021-11-24 15:30:28.261 | SA         | 1502001_create_plugins_table.sql
1503001       | DDL       | 2021-11-24 15:30:28.261 | 2021-11-24 15:30:28.264 | SA         | 1503001_remove_licensing_from_users.sql
1503002       | DDL       | 2021-11-24 15:30:28.265 | 2021-11-24 15:30:28.266 | SA         | 1503002_create_version_infos_table.sql
1606001       | DDL       | 2021-11-24 15:30:28.266 | 2021-11-24 15:30:28.267 | SA         | 1606001_add_index_to_buildstatetransitions.sql
1606002       | DDL       | 2021-11-24 15:30:28.267 | 2021-11-24 15:30:28.268 | SA         | 1606002_add_index_to_artifactplans.sql
1607001       | DDL       | 2021-11-24 15:30:28.268 | 2021-11-24 15:30:28.27  | SA         | 1607001_create_agent_metadata_job_table.sql
1610001       | DDL       | 2021-11-24 15:30:28.27  | 2021-11-24 15:30:28.273 | SA         | 1610001_add_index_to_modifiedfiles.sql
1701001       | DDL       | 2021-11-24 15:30:28.273 | 2021-11-24 15:30:28.277 | SA         | 1701001_remove_gadget_oauth_tables.sql
1702001       | DDL       | 2021-11-24 15:30:28.277 | 2021-11-24 15:30:28.278 | SA         | 1702001_remove_build_cause_buffer_table.sql
1704001       | DDL       | 2021-11-24 15:30:28.279 | 2021-11-24 15:30:28.28  | SA         | 1704001_widen_agents_uuid_column.sql
1704002       | DDL       | 2021-11-24 15:30:28.28  | 2021-11-24 15:30:28.281 | SA         | 1704002_widen_builds_agent_uuid_column.sql
1704003       | DDL       | 2021-11-24 15:30:28.281 | 2021-11-24 15:30:28.291 | SA         | 1704003_pipeline_state_table.sql
1708001       | DDL       | 2021-11-24 15:30:28.291 | 2021-11-24 15:30:28.294 | SA         | 1708001_add_hostname_and_ip_to_agents_table.sql
1801001       | DDL       | 2021-11-24 15:30:28.295 | 2021-11-24 15:30:28.298 | SA         | 1801001_remove_regex_generator_type_from_artifact_properties_generator.sql
1801002       | DDL       | 2021-11-24 15:30:28.298 | 2021-11-24 15:30:28.3   | SA         | 1801002_add_pluggable_artifactconfig_json_to_artifact_plans.sql
1801003       | DDL       | 2021-11-24 15:30:28.301 | 2021-11-24 15:30:28.301 | SA         | 1801003_remove_environment_variables_for_completed_jobs.sql
1801004       | DDL       | 2021-11-24 15:30:28.302 | 2021-11-24 15:30:28.302 | SA         | 1801004_remove_artifact_plans_for_completed_jobs.sql
1801005       | DDL       | 2021-11-24 15:30:28.303 | 2021-11-24 15:30:28.303 | SA         | 1801005_remove_artifact_properties_generator_for_completed_jobs.sql
1801006       | DDL       | 2021-11-24 15:30:28.303 | 2021-11-24 15:30:28.304 | SA         | 1801006_remove_resources_for_completed_jobs.sql
1801007       | DDL       | 2021-11-24 15:30:28.304 | 2021-11-24 15:30:28.304 | SA         | 1801007_remove_job_agent_metadata_for_completed_jobs.sql
1802001       | DDL       | 2021-11-24 15:30:28.305 | 2021-11-24 15:30:28.305 | SA         | 1802001_clear_username_and_comment_for_dependency_materials.sql
1802002       | DDL       | 2021-11-24 15:30:28.306 | 2021-11-24 15:30:28.306 | SA         | 1802002_add_index_on_pipelines_name_and_id_column.sql
1804001       | DDL       | 2021-11-24 15:30:28.307 | 2021-11-24 15:30:28.308 | SA         | 1804001_add_case_insensitive_pipelinename_column_to_pipelinelabelcounts.sql
1805001       | DDL       | 2021-11-24 15:30:28.309 | 2021-11-24 15:30:28.309 | SA         | 1805001_drop_preferred_table.sql
1807001       | DDL       | 2021-11-24 15:30:28.31  | 2021-11-24 15:30:28.31  | SA         | 1807001_data_sharing_settings_table.sql
1807002       | DDL       | 2021-11-24 15:30:28.311 | 2021-11-24 15:30:28.311 | SA         | 1807002_usage_data_reporting_table.sql
1808001       | DDL       | 2021-11-24 15:30:28.312 | 2021-11-24 15:30:28.315 | SA         | 1808001_remove_oauth_tables.sql
1808002       | DDL       | 2021-11-24 15:30:28.315 | 2021-11-24 15:30:28.319 | SA         | 1808002_add_filters_and_version_to_pipeline_selections.sql
1901001       | DDL       | 2021-11-24 15:30:28.32  | 2021-11-24 15:30:28.324 | SA         | 1901001_add_cancelled_by_to_stages_table.sql
1902001       | DDL       | 2021-11-24 15:30:28.324 | 2021-11-24 15:30:28.325 | SA         | 1902001_add_paused_at_to_pipeline_label_counts.sql
1902002       | DDL       | 2021-11-24 15:30:28.326 | 2021-11-24 15:30:28.326 | SA         | 1902002_add_access_token.sql
1902003       | DDL       | 2021-11-24 15:30:28.326 | 2021-11-24 15:30:28.33  | SA         | 1902003_add_revoke_cause_to_access_tokens.sql
1902004       | DDL       | 2021-11-24 15:30:28.33  | 2021-11-24 15:30:28.333 | SA         | 1902004_add_revoked_by_to_access_tokens.sql
1902005       | DDL       | 2021-11-24 15:30:28.334 | 2021-11-24 15:30:28.337 | SA         | 1902005_remove_name_from_access_tokens.sql
1902006       | DDL       | 2021-11-24 15:30:28.337 | 2021-11-24 15:30:28.341 | SA         | 1902006_access_token_description.sql
1902007       | DDL       | 2021-11-24 15:30:28.341 | 2021-11-24 15:30:28.344 | SA         | 1902007_add_soft_delete_to_access_token.sql
1902008       | DDL       | 2021-11-24 15:30:28.344 | 2021-11-24 15:30:28.345 | SA         | 1902008_rename_is_revoked_to_revoke_in_access_token.sql
1903001       | DDL       | 2021-11-24 15:30:28.345 | 2021-11-24 15:30:28.347 | SA         | 1903001_add_status_and_message_to_server_backup.sql
1903002       | DDL       | 2021-11-24 15:30:28.347 | 2021-11-24 15:30:28.35  | SA         | 1903002_add_cluster_profile_on_job_agent_metadata.sql
1903003       | DDL       | 2021-11-24 15:30:28.35  | 2021-11-24 15:30:28.352 | SA         | 1903003_add_progress_status_to_server_backup.sql
1909001       | DDL       | 2021-11-24 15:30:28.352 | 2021-11-24 15:30:28.362 | SA         | 1909001_update_agents_table.sql
1910001       | DDL       | 2021-11-24 15:30:28.363 | 2021-11-24 15:30:28.363 | SA         | 1910001_drop_properties_table.sql
1910002       | DDL       | 2021-11-24 15:30:28.363 | 2021-11-24 15:30:28.363 | SA         | 1910002_drop_artifact_properties_generator_table.sql
1910003       | DDL       | 2021-11-24 15:30:28.364 | 2021-11-24 15:30:28.364 | SA         | 1910003_remove_environment_variables_for_completed_jobs.sql
1910004       | DDL       | 2021-11-24 15:30:28.364 | 2021-11-24 15:30:28.364 | SA         | 1910004_remove_artifact_plans_for_completed_jobs.sql
1910005       | DDL       | 2021-11-24 15:30:28.364 | 2021-11-24 15:30:28.365 | SA         | 1910005_remove_resources_for_completed_jobs.sql
1910006       | DDL       | 2021-11-24 15:30:28.365 | 2021-11-24 15:30:28.365 | SA         | 1910006_remove_job_agent_metadata_for_completed_jobs.sql
(180 rows, 14 ms)
arvindsv commented 2 years ago

Might as well run this while you're at it, and share the output:

java -cp lib/h2-1.4.200.jar org.h2.tools.Shell -url jdbc:h2:./cruise -user sa -sql 'SELECT * FROM information_schema.tables'
java -cp lib/h2-1.4.200.jar org.h2.tools.Shell -url jdbc:h2:./cruise -user sa -sql 'SELECT * FROM information_schema.indexes'
java -cp lib/h2-1.4.200.jar org.h2.tools.Shell -url jdbc:h2:./cruise -user sa -sql 'SELECT * FROM information_schema.sequences'
maheshp commented 2 years ago

Yeah, I am curious to know what is in the changelog as well.

The db-migrator before copying over the data first applies any pending migrations to the old existing database. In GoCD-19.10.0 we have dropped the tables properties & artifactPropertiesGenerator. From the logs looks like onlyartifactPropertiesGenerator is deleted.

Ajoe-T commented 2 years ago

Thanks people, And @arvindsv , Here is the results of running the above commands:

java -cp lib/h2-1.4.200.jar org.h2.tools.Shell -url jdbc:h2:./cruise -user sa -sql 'SELECT * FROM changelog'

1             | DDL       | 2011-02-01 10:01:56.831 | 2011-02-01 10:01:56.906 | SA         | 1_create_initial_tables.sql
2             | DDL       | 2011-02-01 10:01:56.907 | 2011-02-01 10:01:56.913 | SA         | 2_create_indexes.sql
3             | DDL       | 2011-02-01 10:01:56.914 | 2011-02-01 10:01:56.942 | SA         | 3_add_build_ignored_column.sql
4             | DDL       | 2011-02-01 10:01:56.942 | 2011-02-01 10:01:56.951 | SA         | 4_add_check_externals_column.sql
5             | DDL       | 2011-02-01 10:01:56.952 | 2011-02-01 10:01:56.963 | SA         | 5_add_from_external_column.sql
6             | DDL       | 2011-02-01 10:01:56.964 | 2011-02-01 10:01:56.979 | SA         | 6_add_pipeline_label.sql
7             | DDL       | 2011-02-01 10:01:56.98  | 2011-02-01 10:01:56.983 | SA         | 7_add_pipeline_label_counters.sql
8             | DDL       | 2011-02-01 10:01:56.984 | 2011-02-01 10:01:56.987 | SA         | 8_add_build_cause_buffer.sql
9             | DDL       | 2011-02-01 10:01:56.988 | 2011-02-01 10:01:56.992 | SA         | 9_add_material_properties_table.sql
10            | DDL       | 2011-02-01 10:01:56.993 | 2011-02-01 10:01:57.004 | SA         | 10_add_stage_timestamp.sql
11            | DDL       | 2011-02-01 10:01:57.005 | 2011-02-01 10:01:57.016 | SA         | 11_add_stage_order.sql
12            | DDL       | 2011-02-01 10:01:57.016 | 2011-02-01 10:01:57.031 | SA         | 12_add_stage_result.sql
13            | DDL       | 2011-02-01 10:01:57.032 | 2011-02-01 10:01:57.043 | SA         | 13_add_stage_approvalType.sql
14            | DDL       | 2011-02-01 10:01:57.044 | 2011-02-01 10:01:57.045 | SA         | 14_add_name_pipelineId_index_for_stages.sql
15            | DDL       | 2011-02-01 10:01:57.046 | 2011-02-01 10:01:57.047 | SA         | 15_add_name_agentId_buildid_index_for_builds.sql
16            | DDL       | 2011-02-01 10:01:57.048 | 2011-02-01 10:01:57.056 | SA         | 16_add_folder_to_materials.sql
17            | DDL       | 2011-02-01 10:01:57.057 | 2011-02-01 10:01:57.061 | SA         | 17_correct_integrity_issues_in_stages.sql
18            | DDL       | 2011-02-01 10:01:57.062 | 2011-02-01 10:01:57.07  | SA         | 18_change_material_properties_value_to_nvarchar.sql
19            | DDL       | 2011-02-01 10:01:57.071 | 2011-02-01 10:01:57.078 | SA         | 19_change_material_url_to_nvarchar.sql
20            | DDL       | 2011-02-01 10:01:57.079 | 2011-02-01 10:01:57.082 | SA         | 20_add_artifact_properties_generator_table.sql
21            | DDL       | 2011-02-01 10:01:57.083 | 2011-02-01 10:01:57.095 | SA         | 21_add_materialId_to_modifications.sql
22            | DDL       | 2011-02-01 10:01:57.096 | 2011-02-01 10:01:57.105 | SA         | 22_remove_pipelineId_from_modifications.sql
23            | DDL       | 2011-02-01 10:01:57.106 | 2011-02-01 10:01:57.118 | SA         | 23_add_index_for_stages.sql
24            | DDL       | 2011-02-01 10:01:57.119 | 2011-02-01 10:01:57.136 | SA         | 24_add_columns_for_dependency_materials.sql
25            | DDL       | 2011-02-01 10:01:57.137 | 2011-02-01 10:01:57.145 | SA         | 25_change_length_of_revision_to_1024_for_modifications.sql
26            | DDL       | 2011-02-01 10:01:57.146 | 2011-02-01 10:01:57.147 | SA         | 26_add_table_fetch_artifact_plans.sql
27            | DDL       | 2011-02-01 10:01:57.148 | 2011-02-01 10:01:57.152 | SA         | 27_set_not_null_on_fetch_artifact_plans.sql
28            | DDL       | 2011-02-01 10:01:57.153 | 2011-02-01 10:01:57.155 | SA         | 28_drop_table_fetch_artifacts.sql
29            | DDL       | 2011-02-01 10:01:57.156 | 2011-02-01 10:01:57.197 | SA         | 29_fix_hsqldb_migration.sql
30            | DDL       | 2011-02-01 10:01:57.198 | 2011-02-01 10:01:57.206 | SA         | 30_add_buildcause_message_to_pipeline.sql
31            | DDL       | 2011-02-01 10:01:57.206 | 2011-02-01 10:01:57.208 | SA         | 31_add_user_setting.sql
32            | DDL       | 2011-02-01 10:01:57.209 | 2011-02-01 10:01:57.213 | SA         | 32_add_email_me_column.sql
33            | DDL       | 2011-02-01 10:01:57.214 | 2011-02-01 10:01:57.215 | SA         | 33_add_unique_constraint_to_name_column_on_usersettings.sql
34            | DDL       | 2011-02-01 10:01:57.216 | 2011-02-01 10:01:57.224 | SA         | 34_add_changed_column_to_modifications.sql
35            | DDL       | 2011-02-01 10:01:57.225 | 2011-02-01 10:01:57.227 | SA         | 35_rename_usersettings_table.sql
36            | DDL       | 2011-02-01 10:01:57.227 | 2011-02-01 10:01:57.231 | SA         | 36_add_notificationfilters_table.sql
37            | DDL       | 2011-02-01 10:01:57.233 | 2011-02-01 10:01:57.234 | SA         | 37_make_the_pipeline_name_case_insensitive.sql
38            | DDL       | 2011-02-01 10:01:57.235 | 2011-02-01 10:01:57.235 | SA         | 38_make_the_stage_name_case_insensitive.sql
39            | DDL       | 2011-02-01 10:01:57.236 | 2011-02-01 10:01:57.237 | SA         | 39_make_the_job_name_case_insensitive.sql
40            | DDL       | 2011-02-01 10:01:57.238 | 2011-02-01 10:01:57.238 | SA         | 40_undo_pipelines_case_insensitive_change.sql
41            | DDL       | 2011-02-01 10:01:57.239 | 2011-02-01 10:01:57.24  | SA         | 41_add_builds_index_on_name_state_and_stageid.sql
42            | DDL       | 2011-02-01 10:01:57.241 | 2011-02-01 10:01:57.249 | SA         | 42_add_counter_to_pipelines.sql
43            | DDL       | 2011-02-01 10:01:57.249 | 2011-02-01 10:01:57.255 | SA         | 43_alter_modifiedFiles_fileName.sql
44            | DDL       | 2011-02-01 10:01:57.256 | 2011-02-01 10:01:57.263 | SA         | 44_added_name_column_into_material.sql
45            | DDL       | 2011-02-01 10:01:57.264 | 2011-02-01 10:01:57.281 | SA         | 45_remove_matcher_from_builds.sql
46            | DDL       | 2011-02-01 10:01:57.281 | 2011-02-01 10:01:57.314 | SA         | 46_remove_material_properties.sql
47            | DDL       | 2011-02-01 10:01:57.315 | 2011-02-01 10:01:57.414 | SA         | 47_create_new_materials.sql
48            | DDL       | 2011-02-01 10:01:57.415 | 2011-02-01 10:01:57.422 | SA         | 48_add_name_to_material_instance.sql
49            | DDL       | 2011-02-01 10:01:57.423 | 2011-02-01 10:01:57.424 | SA         | 49_add_unique_constraint_to_revisions.sql
50            | DDL       | 2011-02-01 10:01:57.425 | 2011-02-01 10:01:57.441 | SA         | 50_add_run_on_all_agents_to_builds.sql
51            | DDL       | 2011-02-01 10:01:57.442 | 2011-02-01 10:01:57.443 | SA         | 51_add_environment_variable_properties.sql
52            | DDL       | 2011-02-01 10:01:57.444 | 2011-02-01 10:01:57.452 | SA         | 52_add_pipeline_lock.sql
53            | DDL       | 2011-02-01 10:01:57.453 | 2011-02-01 10:01:57.454 | SA         | 53_add_index_on_pipelines_locked.sql
54            | DDL       | 2011-02-01 10:01:57.455 | 2011-02-01 10:01:57.464 | SA         | 54_add_stage_id_to_build_transitions.sql
55            | DDL       | 2011-02-01 10:01:57.465 | 2011-02-01 10:01:57.478 | SA         | 55_add_completed_at_transition_id_to_stages.sql
56            | DDL       | 2011-02-01 10:01:57.479 | 2011-02-01 10:01:57.48  | SA         | 56_create_index_on_environment_variables_job_id.sql
57            | DDL       | 2011-02-01 10:01:57.481 | 2011-02-01 10:01:57.493 | SA         | 57_add_state_to_stage.sql
58            | DDL       | 2011-02-01 10:01:57.494 | 2011-02-01 10:01:57.503 | SA         | 58_add_natural_order_to_pipelines.sql
59            | DDL       | 2011-02-01 10:01:57.504 | 2011-02-01 10:01:57.505 | SA         | 59_create_index_on_stages_state.sql
60            | DDL       | 2011-02-01 10:01:57.506 | 2011-02-01 10:01:57.512 | SA         | 60_support_for_variables_at_different_levels.sql
61            | DDL       | 2011-02-01 10:01:57.513 | 2011-02-01 10:01:57.532 | SA         | 61_migrate_old_pipelines_to_have_counter.sql
62            | DDL       | 2011-02-01 10:01:57.532 | 2011-02-01 10:01:57.64  | SA         | 62_migrate_dependency_modifications_to_use_pipeline_counter_based_stage_locator.sql
63            | DDL       | 2011-02-01 10:01:57.641 | 2011-02-01 10:01:57.653 | SA         | 63_add_schedule_to_and_from_revisions.sql
64            | DDL       | 2011-02-01 10:01:57.654 | 2011-02-01 10:01:57.698 | SA         | 64_populate_missing_pipeline_label_in_modifications.sql
65            | DDL       | 2011-02-01 10:01:57.699 | 2011-02-01 10:01:57.711 | SA         | 65_repoint_FROM_to_TO_for_dependency_pmr.sql
66            | DDL       | 2011-02-01 10:01:57.712 | 2011-02-01 10:01:57.721 | SA         | 66_remove_schedule_to_and_from_revisions.sql
67            | DDL       | 2011-02-01 10:01:57.722 | 2011-02-01 10:01:57.723 | SA         | 67_create_pipeline_selections_table.sql
68            | DDL       | 2011-02-01 10:01:57.724 | 2011-02-01 10:01:57.725 | SA         | 68_add_foreign_key_from_pmr_to_pipeline.sql
69            | DDL       | 2011-02-01 10:01:57.726 | 2011-02-01 10:01:57.727 | SA         | 69_create_index_on_builds_name_and_stage_id.sql
70            | DDL       | 2011-02-01 10:01:57.728 | 2011-02-01 10:01:57.747 | SA         | 70_change_pipeline_stage_and_job_name_to_varchar_ignorecase.sql
71            | DDL       | 2011-02-01 10:01:57.748 | 2011-02-01 10:01:57.757 | SA         | 71_add_latest_run_flag_on_stage.sql
72            | DDL       | 2011-02-01 10:01:57.758 | 2011-02-01 10:01:57.761 | SA         | 72_create_builds_view.sql
73            | DDL       | 2011-02-01 10:01:57.761 | 2011-02-01 10:01:57.763 | SA         | 73_create_stages_view.sql
74            | DDL       | 2011-02-01 10:01:57.764 | 2011-02-01 10:01:57.765 | SA         | 74_add_unique_constraint_for_stages_on_pipelineId_name_counter.sql
75            | DDL       | 2011-02-01 10:01:57.766 | 2011-02-01 10:01:57.767 | SA         | 75_create_agent_cookie_mapping_table.sql
76            | DDL       | 2011-02-01 10:01:57.768 | 2011-02-01 10:01:57.774 | SA         | 76_create_oauth_tables.sql
77            | DDL       | 2011-02-01 10:01:57.775 | 2011-02-01 10:01:57.779 | SA         | 77_add_enabled_to_users.sql
78            | DDL       | 2011-02-01 10:01:57.779 | 2011-02-01 10:01:57.791 | SA         | 78_add_fetchMaterials_to_stages.sql
79            | DDL       | 2011-02-01 10:01:57.791 | 2011-02-01 10:01:57.796 | SA         | 79_recreate_build_and_stages_views.sql
80            | DDL       | 2011-02-01 10:01:57.796 | 2011-02-01 10:01:57.807 | SA         | 80_add_cleanWorkingDir_to_stages.sql
81            | DDL       | 2011-02-01 10:01:57.808 | 2011-02-01 10:01:57.812 | SA         | 81_recreate_build_and_stages_views.sql
82            | DDL       | 2011-02-01 10:01:57.813 | 2011-02-01 10:01:57.814 | SA         | 82_make_oauth_client_names_unique.sql
83            | DDL       | 2011-02-01 10:01:57.815 | 2011-02-01 10:01:57.82  | SA         | 83_create_gadget_oauth_tables.sql
84            | DDL       | 2011-02-01 10:01:57.821 | 2011-02-01 10:01:57.828 | SA         | 84_add_pipelineId_to_modifications.sql
85            | DDL       | 2011-02-01 10:01:57.829 | 2011-02-01 10:01:57.834 | SA         | 85_add_materialId_to_pipelineMaterialRevisions.sql
86            | DDL       | 2016-03-16 15:20:46.178 | 2016-03-16 15:20:46.338 | SA         | 86_add_actual_from_revision_to_pmr.sql
87            | DDL       | 2016-03-16 15:20:46.341 | 2016-03-16 15:20:46.344 | SA         | 87_create_index_modifications_materialId.sql
88            | DDL       | 2016-03-16 15:20:46.346 | 2016-03-16 15:20:46.529 | SA         | 88_rerun_to_actual_job_mapping.sql
89            | DDL       | 2016-03-16 15:20:46.531 | 2016-03-16 15:20:46.619 | SA         | 89_adding_rerun_of_counter_for_rerun_job_stages.sql
90            | DDL       | 2016-03-16 15:20:46.62  | 2016-03-16 15:20:46.654 | SA         | 90_populate_missing_completed_at_transition_id.sql
221001        | DDL       | 2016-03-16 15:20:46.656 | 2016-03-16 15:20:46.675 | SA         | 221001_fix_incomplete_stages_and_jobs.sql
230001        | DDL       | 2016-03-16 15:20:46.677 | 2016-03-16 15:20:46.733 | SA         | 230001_add_column_artifacts_deleted_to_stage.sql
230002        | DDL       | 2016-03-16 15:20:46.735 | 2016-03-16 15:20:46.751 | SA         | 230002_populate_missing_completed_by_transition_id.sql
230003        | DDL       | 2016-03-16 15:20:46.753 | 2016-03-16 15:20:46.773 | SA         | 230003_stop_persisting_material_password.sql
230004        | DDL       | 2016-03-16 15:20:46.775 | 2016-03-16 15:20:46.815 | SA         | 230004_add_config_version_to_stage.sql
230005        | DDL       | 2016-03-16 15:20:46.817 | 2016-03-16 15:20:46.82  | SA         | 230005_add_index_bst_buildid_currentstate.sql
230006        | DDL       | 2016-03-16 15:20:46.822 | 2016-03-16 15:20:46.873 | SA         | 230006_make_user_name_case_insensitive.sql
230007        | DDL       | 2016-03-16 15:20:46.875 | 2016-03-16 15:20:46.914 | SA         | 230007_add_completed_time_on_job_and_stage.sql
230008        | DDL       | 2016-03-16 15:20:46.916 | 2016-03-16 15:20:46.918 | SA         | 230008_drop_unique_revisions_for_material_constraint.sql
230009        | DDL       | 2016-03-16 15:20:46.92  | 2016-03-16 15:20:46.923 | SA         | 230009_update_git_material_with_null_branch_to_use_branch_master.sql
240001        | DDL       | 2016-03-16 15:20:46.925 | 2016-03-16 15:20:46.933 | SA         | 240001_add_userid_column_to_pipelineselections.sql
240002        | DDL       | 2016-03-16 15:20:46.934 | 2016-03-16 15:20:46.945 | SA         | 240002_add_disableLicenseExpiryWarning_to_users.sql
300001        | DDL       | 2016-03-16 15:20:46.946 | 2016-03-16 15:20:46.949 | SA         | 300001_add_serverBackup_table.sql
300002        | DDL       | 2016-03-16 15:20:46.95  | 2016-03-16 15:20:46.97  | SA         | 300002_add_pause_info_column.sql
300003        | DDL       | 2016-03-16 15:20:46.972 | 2016-03-16 15:20:46.983 | SA         | 300003_add_serveralias_column_to_material_instance.sql
300004        | DDL       | 2016-03-16 15:20:46.985 | 2016-03-16 15:20:46.988 | SA         | 300004_create_luau_state_table.sql
300005        | DDL       | 2016-03-16 15:20:46.989 | 2016-03-16 15:20:46.995 | SA         | 300005_drop_auth_state_column_from_luau_state.sql
300006        | DDL       | 2016-03-16 15:20:46.996 | 2016-03-16 15:20:47.03  | SA         | 300006_add_tfs_material_attributes.sql
300007        | DDL       | 2016-03-16 15:20:47.032 | 2016-03-16 15:20:47.042 | SA         | 300007_add_display_name_column_to_users.sql
300008        | DDL       | 2016-03-16 15:20:47.044 | 2016-03-16 15:20:47.05  | SA         | 300008_create_luau_groups.sql
300009        | DDL       | 2016-03-16 15:20:47.051 | 2016-03-16 15:20:47.059 | SA         | 300009_add_secure_column_to_environment_variables.sql
300010        | DDL       | 2016-03-16 15:20:47.061 | 2016-03-16 15:20:47.066 | SA         | 300010_add_column_to_store_last_successful_sync_time.sql
300011        | DDL       | 2016-03-16 15:20:47.067 | 2016-03-16 15:20:47.076 | SA         | 300011_remove_column_workspace_owner.sql
1202001       | DDL       | 2016-03-16 15:20:47.077 | 2016-03-16 15:20:47.078 | SA         | 1202001_fix_dependency_material_fingerprint_to_adjust_serveralias.sql
1202002       | DDL       | 2016-03-16 15:20:47.079 | 2016-03-16 15:20:47.087 | SA         | 1202002_add_domain_column_to_material_instance.sql
1202003       | DDL       | 2016-03-16 15:20:47.088 | 2016-03-16 15:20:47.096 | SA         | 1202003_remove_ignore_case_from_domain_column_to_material_instance.sql
1203002       | DDL       | 2016-03-16 15:20:47.097 | 2016-03-16 15:20:47.105 | SA         | 1203002_add_user_column_to_server_backup_table.sql
1203003       | DDL       | 2016-03-16 15:20:47.111 | 2016-03-16 15:20:47.112 | SA         | 1203003_zap_natural_order_values.sql
1203004       | DDL       | 2016-03-16 15:20:47.122 | 2016-03-16 15:20:47.137 | SA         | 1203004_kill_remote_dependency_material.sql
1203005       | DDL       | 2016-03-16 15:20:47.142 | 2016-03-16 15:20:47.147 | SA         | 1203005_add_index_on_modifications_revision.sql
1301001       | DDL       | 2016-03-16 15:20:47.148 | 2016-03-16 15:20:47.193 | SA         | 1301001_drop_build_event_column_from_builds.sql
1302001       | DDL       | 2016-03-16 15:20:47.194 | 2016-03-16 15:20:47.209 | SA         | 1302001_add_configuration_field_to_materials_table.sql
1303001       | DDL       | 2016-03-16 15:20:47.21  | 2016-03-16 15:20:47.219 | SA         | 1303001_add_additional_data_field_to_modifications_table.sql
1303002       | DDL       | 2016-03-16 15:20:47.22  | 2016-03-16 15:20:47.221 | SA         | 1303002_add_index_to_builds_on_stageId.sql
1303003       | DDL       | 2016-03-16 15:20:47.221 | 2016-03-16 15:20:47.222 | SA         | 1303003_add_index_to_stages_resources_tables.sql
1303004       | DDL       | 2016-03-16 15:20:47.223 | 2016-03-16 15:20:47.225 | SA         | 1303004_indexes_based_on_purge_tool.sql
1304001       | DDL       | 2016-03-16 15:20:47.225 | 2016-03-16 15:20:47.228 | SA         | 1304001_remove_luau_related_entries.sql
1401001       | DDL       | 2016-03-16 15:20:47.229 | 2016-03-16 15:20:47.23  | SA         | 1401001_recreating_trigger_because_of_cruise_to_go_change.sql
1403001       | DDL       | 2016-03-16 15:20:47.231 | 2016-03-16 15:20:47.232 | SA         | 1403001_fix_null_artifacttype_on_artifactplans_table.sql
1403002       | DDL       | 2016-03-16 15:20:47.233 | 2016-03-16 15:20:47.254 | SA         | 1403002_add_runMultipleInstance_column_on_builds_table_recreate_view.sql
1501001       | DDL       | 2016-03-16 15:20:47.255 | 2016-03-16 15:20:47.262 | SA         | 1501001_rename_pipeline_selections_unselected_pipelines_column_to_selections.sql
1501002       | DDL       | 2016-03-16 15:20:47.263 | 2016-03-16 15:20:47.279 | SA         | 1501002_add_comment_column_to_pipelines.sql
1501003       | DDL       | 2016-03-16 15:20:47.28  | 2016-03-16 15:20:47.29  | SA         | 1501003_add_additional_data_field_to_materials_table.sql
1502001       | DDL       | 2016-03-16 15:20:47.291 | 2016-03-16 15:20:47.293 | SA         | 1502001_create_plugins_table.sql
1503001       | DDL       | 2016-03-16 15:20:47.293 | 2016-03-16 15:20:47.302 | SA         | 1503001_remove_licensing_from_users.sql
1503002       | DDL       | 2016-03-16 15:20:47.303 | 2016-03-16 15:20:47.304 | SA         | 1503002_create_version_infos_table.sql
1606001       | DDL       | 2017-01-10 22:12:00.185 | 2017-01-10 22:12:09.837 | SA         | 1606001_add_index_to_buildstatetransitions.sql
1606002       | DDL       | 2017-01-10 22:12:09.839 | 2017-01-10 22:12:09.997 | SA         | 1606002_add_index_to_artifactplans.sql
1607001       | DDL       | 2017-01-10 22:12:09.998 | 2017-01-10 22:12:10.005 | SA         | 1607001_create_agent_metadata_job_table.sql
1610001       | DDL       | 2017-01-10 22:12:10.006 | 2017-01-10 22:12:10.009 | SA         | 1610001_add_index_to_modifiedfiles.sql
1701001       | DDL       | 2017-03-29 20:41:46.921 | 2017-03-29 20:41:46.95  | SA         | 1701001_remove_gadget_oauth_tables.sql
1702001       | DDL       | 2017-03-29 20:41:46.953 | 2017-03-29 20:41:46.964 | SA         | 1702001_remove_build_cause_buffer_table.sql
1704001       | DDL       | 2019-02-07 12:42:35.652 | 2019-02-07 12:42:35.658 | SA         | 1704001_widen_agents_uuid_column.sql
1704002       | DDL       | 2019-02-07 12:42:35.66  | 2019-02-07 12:42:35.671 | SA         | 1704002_widen_builds_agent_uuid_column.sql
1704003       | DDL       | 2019-02-07 12:42:35.672 | 2019-02-07 12:42:42.865 | SA         | 1704003_pipeline_state_table.sql
1708001       | DDL       | 2019-02-07 12:42:42.866 | 2019-02-07 12:42:43.505 | SA         | 1708001_add_hostname_and_ip_to_agents_table.sql
1801001       | DDL       | 2019-02-07 12:42:43.506 | 2019-02-07 12:42:43.513 | SA         | 1801001_remove_regex_generator_type_from_artifact_properties_generator.sql
1801002       | DDL       | 2019-02-07 12:42:43.514 | 2019-02-07 12:42:43.626 | SA         | 1801002_add_pluggable_artifactconfig_json_to_artifact_plans.sql
1801003       | DDL       | 2019-02-07 12:42:43.626 | 2019-02-07 12:42:43.627 | SA         | 1801003_remove_environment_variables_for_completed_jobs.sql
1801004       | DDL       | 2019-02-07 12:42:43.627 | 2019-02-07 12:42:43.627 | SA         | 1801004_remove_artifact_plans_for_completed_jobs.sql
1801005       | DDL       | 2019-02-07 12:42:43.628 | 2019-02-07 12:42:43.628 | SA         | 1801005_remove_artifact_properties_generator_for_completed_jobs.sql
1801006       | DDL       | 2019-02-07 12:42:43.628 | 2019-02-07 12:42:43.629 | SA         | 1801006_remove_resources_for_completed_jobs.sql
1801007       | DDL       | 2019-02-07 12:42:43.629 | 2019-02-07 12:42:43.629 | SA         | 1801007_remove_job_agent_metadata_for_completed_jobs.sql
1802001       | DDL       | 2019-02-07 12:42:43.63  | 2019-02-07 12:42:44.207 | SA         | 1802001_clear_username_and_comment_for_dependency_materials.sql
1802002       | DDL       | 2019-02-07 12:42:44.208 | 2019-02-07 12:42:44.75  | SA         | 1802002_add_index_on_pipelines_name_and_id_column.sql
1804001       | DDL       | 2019-02-07 12:42:44.75  | 2019-02-07 12:42:44.779 | SA         | 1804001_add_case_insensitive_pipelinename_column_to_pipelinelabelcounts.sql
1805001       | DDL       | 2019-02-07 12:42:44.78  | 2019-02-07 12:42:44.781 | SA         | 1805001_drop_preferred_table.sql
1807001       | DDL       | 2019-02-07 12:42:44.781 | 2019-02-07 12:42:44.782 | SA         | 1807001_data_sharing_settings_table.sql
1807002       | DDL       | 2019-02-07 12:42:44.782 | 2019-02-07 12:42:44.788 | SA         | 1807002_usage_data_reporting_table.sql
1808001       | DDL       | 2019-02-07 12:42:44.788 | 2019-02-07 12:42:44.79  | SA         | 1808001_remove_oauth_tables.sql
1808002       | DDL       | 2019-02-07 12:42:44.79  | 2019-02-07 12:42:44.81  | SA         | 1808002_add_filters_and_version_to_pipeline_selections.sql
1901001       | DDL       | 2019-02-21 13:17:19.94  | 2019-02-21 13:18:08.171 | SA         | 1901001_add_cancelled_by_to_stages_table.sql
1902001       | DDL       | 2020-05-14 11:14:13.194 | 2020-05-14 11:14:13.699 | SA         | 1902001_add_paused_at_to_pipeline_label_counts.sql
1902002       | DDL       | 2020-05-14 11:14:13.701 | 2020-05-14 11:14:13.711 | SA         | 1902002_add_access_token.sql
1902003       | DDL       | 2020-05-14 11:14:13.714 | 2020-05-14 11:14:13.736 | SA         | 1902003_add_revoke_cause_to_access_tokens.sql
1902004       | DDL       | 2020-05-14 11:14:13.738 | 2020-05-14 11:14:13.758 | SA         | 1902004_add_revoked_by_to_access_tokens.sql
1902005       | DDL       | 2020-05-14 11:14:13.766 | 2020-05-14 11:14:13.78  | SA         | 1902005_remove_name_from_access_tokens.sql
1902006       | DDL       | 2020-05-14 11:14:13.781 | 2020-05-14 11:14:13.799 | SA         | 1902006_access_token_description.sql
1902007       | DDL       | 2020-05-14 11:14:13.8   | 2020-05-14 11:14:13.815 | SA         | 1902007_add_soft_delete_to_access_token.sql
1902008       | DDL       | 2020-05-14 11:14:13.816 | 2020-05-14 11:14:13.829 | SA         | 1902008_rename_is_revoked_to_revoke_in_access_token.sql
1903001       | DDL       | 2020-05-14 11:14:13.83  | 2020-05-14 11:14:14.851 | SA         | 1903001_add_status_and_message_to_server_backup.sql
1903002       | DDL       | 2020-05-14 11:14:14.852 | 2020-05-14 11:14:14.911 | SA         | 1903002_add_cluster_profile_on_job_agent_metadata.sql
1903003       | DDL       | 2020-05-14 11:14:14.911 | 2020-05-14 11:14:14.953 | SA         | 1903003_add_progress_status_to_server_backup.sql
1909001       | DDL       | 2020-05-14 11:14:14.953 | 2020-05-14 11:14:33.383 | SA         | 1909001_update_agents_table.sql
1910001       | DDL       | 2020-05-14 11:14:33.383 | null                    | SA         | 1910001_drop_properties_table.sql
1910002       | DDL       | 2020-05-14 11:22:38.541 | 2020-05-14 11:22:38.552 | SA         | 1910002_drop_artifact_properties_generator_table.sql
1910003       | DDL       | 2020-05-14 11:22:38.554 | 2020-05-14 11:47:33.953 | SA         | 1910003_remove_environment_variables_for_completed_jobs.sql
1910004       | DDL       | 2020-05-14 11:47:33.955 | 2020-05-14 11:51:30.328 | SA         | 1910004_remove_artifact_plans_for_completed_jobs.sql
1910005       | DDL       | 2020-05-14 11:51:30.328 | 2020-05-14 11:51:33.47  | SA         | 1910005_remove_resources_for_completed_jobs.sql
1910006       | DDL       | 2020-05-14 11:51:33.471 | 2020-05-14 11:51:35.46  | SA         | 1910006_remove_job_agent_metadata_for_completed_jobs.sql
(180 rows, 14 ms)

java -cp lib/h2-1.4.200.jar org.h2.tools.Shell -url jdbc:h2:./cruise -user sa -sql 'SELECT * FROM information_schema.sequences'

CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_5905FFA4_C3D4_4193_8B52_666552039E7C | 270432        | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 15
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_859B5F93_EBC9_4F88_B114_BAF2E20B6934 | 328629        | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 153
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_FDC5201C_9B59_4624_825A_88685D212FAE | 7317580       | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 99
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_B878C2EE_959E_4F1A_8F4F_3AA8D316D9F3 | 973           | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 13
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_D44D740B_D094_449B_880B_B1275F6EFBEE | 9674448       | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 33
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_7E59D9C7_83A0_40F2_92A9_DECE05129B89 | 1             | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 161
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_99F415B6_76F0_4856_9A1F_537A8C905669 | 749           | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 12
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_1F27F84E_AFFC_41FD_A479_7AE38356566D | 219           | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 71
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_3700FBB3_9951_4C74_B249_BAAB0E0EDE68 | 1347          | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 67
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_DE3EC304_8573_4030_B280_2FE345E2717A | 29254         | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 40
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_6221BF74_8932_4361_BBDA_5CCE5A324FF5 | 1             | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 166
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_6B20E7FB_05C9_4875_8E5D_741CF3DF0F4F | 2574          | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 182
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_F6C2459B_D4A1_43B7_B85E_54DC3C3D129E | 258           | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 55
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_6B7E1695_E79C_4675_B07A_5DE43C9223A0 | 792084        | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 27
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_8811DC19_1147_46DD_9670_C2A9AF425FE2 | 161707        | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 11
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_2548E279_7269_47A4_981A_55F4C7AD2A1B | 5             | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 32
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_F8A69B86_705E_40B2_BABC_97A0ABD6B54B | 0             | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 43
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_DD533966_D2B7_4355_9CE4_131F7111F9E2 | 67858         | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 52
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_B8B92BF5_C569_4B0F_8E1C_9F0305078FD6 | 7672          | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 46
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_D1229517_4596_4AEB_B211_1FF03C966396 | 4654949       | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 64
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_AD7EB9A5_62CF_4D77_BE81_48B2FD2FBF20 | 2             | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 127
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_6C1CFB3E_06B1_49F3_8E42_5D580B5259B1 | 180950        | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 58
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_82CF0044_4B25_4EF0_93D5_7FA28F6441D8 | 1723          | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 176
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_2DA6D80A_0B48_40B1_AD44_235FB0263598 | 2327072       | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 31
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_2A717171_A53D_4A9B_A04F_35AFBC2310A9 | 32            | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 235
CRUISE           | PUBLIC          | SYSTEM_SEQUENCE_2C0FAF5B_CAA8_4013_A8B2_7FF9D3DD9FDA | 307           | 1         | TRUE         |         | 32    | 1         | 9223372036854775807 | FALSE    | 210
(26 rows, 1 ms)

java -cp lib/h2-1.4.200.jar org.h2.tools.Shell -url jdbc:h2:./cruise -user sa -sql 'SELECT * FROM information_schema.indexes'

TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME                     | NON_UNIQUE | INDEX_NAME                                          | ORDINAL_POSITION | COLUMN_NAME                 | CARDINALITY | PRIMARY_KEY | INDEX_TYPE_NAME | IS_GENERATED | INDEX_TYPE | ASC_OR_DESC | PAGES | FILTER_CONDITION | REMARKS | SQL                                                                                                  | ID  | SORT_TYPE | CONSTRAINT_NAME                 | INDEX_CLASS                           | AFFINITY
CRUISE        | PUBLIC       | MODIFIEDFILES                  | TRUE       | FK_MODIFIEDFILES_MODIFICATIONS_INDEX_3              | 1                | MODIFICATIONID              | 0           | FALSE       | INDEX           | TRUE         | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."FK_MODIFIEDFILES_MODIFICATIONS_INDEX_3" ON "PUBLIC"."MODIFIEDFILES"("MODIFICA | 86  | 0         | FK_MODIFIEDFILES_MODIFICATIONS  | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | MODIFIEDFILES                  | FALSE      | PRIMARY_KEY_8783C                                   | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_8783C" ON "PUBLIC"."MODIFIEDFILES"("ID")                    | 132 | 0         | CONSTRAINT_3                    | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE        | PUBLIC       | PROPERTIES                     | FALSE      | PRIMARY_KEY_E                                       | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_E" ON "PUBLIC"."PROPERTIES"("ID")                           | 35  | 0         | CONSTRAINT_E                    | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE        | PUBLIC       | PROPERTIES                     | FALSE      | CONSTRAINT_INDEX_E                                  | 1                | BUILDID                     | 0           | FALSE       | UNIQUE INDEX    | TRUE         | 3          | A           | 0     |                  |         | CREATE UNIQUE INDEX "PUBLIC"."CONSTRAINT_INDEX_E" ON "PUBLIC"."PROPERTIES"("BUILDID", "KEY")         | 37  | 0         | CONSTRAINT_E5                   | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | PROPERTIES                     | FALSE      | CONSTRAINT_INDEX_E                                  | 2                | KEY                         | 0           | FALSE       | UNIQUE INDEX    | TRUE         | 3          | A           | 0     |                  |         | CREATE UNIQUE INDEX "PUBLIC"."CONSTRAINT_INDEX_E" ON "PUBLIC"."PROPERTIES"("BUILDID", "KEY")         | 37  | 0         | CONSTRAINT_E5                   | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | PROPERTIES                     | TRUE       | IDX_PROPERTIES_KEY                                  | 1                | KEY                         | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_PROPERTIES_KEY" ON "PUBLIC"."PROPERTIES"("KEY")                           | 72  | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | PROPERTIES                     | TRUE       | IDX_PROPERTIES_BUILDID                              | 1                | BUILDID                     | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_PROPERTIES_BUILDID" ON "PUBLIC"."PROPERTIES"("BUILDID")                   | 107 | 0         | FK_PROPERTIES_BUILDS            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | ACCESSTOKEN                    | FALSE      | PRIMARY_KEY_1                                       | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_1" ON "PUBLIC"."ACCESSTOKEN"("ID")                          | 205 | 0         | CONSTRAINT_43                   | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE        | PUBLIC       | ACCESSTOKEN                    | FALSE      | CONSTRAINT_43F_INDEX_1                              | 1                | VALUE                       | 0           | FALSE       | UNIQUE INDEX    | TRUE         | 3          | A           | 0     |                  |         | CREATE UNIQUE INDEX "PUBLIC"."CONSTRAINT_43F_INDEX_1" ON "PUBLIC"."ACCESSTOKEN"("VALUE")             | 207 | 0         | CONSTRAINT_43F                  | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | ACCESSTOKEN                    | FALSE      | CONSTRAINT_43F0_INDEX_1                             | 1                | SALTID                      | 0           | FALSE       | UNIQUE INDEX    | TRUE         | 3          | A           | 0     |                  |         | CREATE UNIQUE INDEX "PUBLIC"."CONSTRAINT_43F0_INDEX_1" ON "PUBLIC"."ACCESSTOKEN"("SALTID")           | 209 | 0         | CONSTRAINT_43F0                 | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | ACCESSTOKEN                    | FALSE      | CONSTRAINT_43F05_INDEX_1                            | 1                | SALTVALUE                   | 0           | FALSE       | UNIQUE INDEX    | TRUE         | 3          | A           | 0     |                  |         | CREATE UNIQUE INDEX "PUBLIC"."CONSTRAINT_43F05_INDEX_1" ON "PUBLIC"."ACCESSTOKEN"("SALTVALUE")       | 214 | 0         | CONSTRAINT_43F05                | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | DATASHARINGSETTINGS            | FALSE      | PRIMARY_KEY_7                                       | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_7" ON "PUBLIC"."DATASHARINGSETTINGS"("ID")                  | 162 | 0         | CONSTRAINT_7D                   | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE        | PUBLIC       | PIPELINESTATES                 | FALSE      | PRIMARY_KEY_6                                       | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_6" ON "PUBLIC"."PIPELINESTATES"("ID")                       | 56  | 0         | CONSTRAINT_6A                   | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE        | PUBLIC       | PIPELINESTATES                 | FALSE      | UNIQUE_PIPELINE_STATE_INDEX_6                       | 1                | PIPELINENAME                | 0           | FALSE       | UNIQUE INDEX    | TRUE         | 3          | A           | 0     |                  |         | CREATE UNIQUE INDEX "PUBLIC"."UNIQUE_PIPELINE_STATE_INDEX_6" ON "PUBLIC"."PIPELINESTATES"("PIPELINEN | 59  | 0         | UNIQUE_PIPELINE_STATE           | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | PIPELINELABELCOUNTS            | TRUE       | IDX_PIPELINELABELCOUNTS_PIPELINENAME                | 1                | PIPELINENAME                | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_PIPELINELABELCOUNTS_PIPELINENAME" ON "PUBLIC"."PIPELINELABELCOUNTS"("PIPE | 101 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | PIPELINELABELCOUNTS            | TRUE       | IDX_PIPELINELABELCOUNTS_CASEINSENSITIVEPIPELINENAME | 1                | CASEINSENSITIVEPIPELINENAME | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_PIPELINELABELCOUNTS_CASEINSENSITIVEPIPELINENAME" ON "PUBLIC"."PIPELINELAB | 181 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | PIPELINELABELCOUNTS            | FALSE      | PRIMARY_KEY_6E                                      | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_6E" ON "PUBLIC"."PIPELINELABELCOUNTS"("ID")                 | 185 | 0         | CONSTRAINT_C7                   | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | PIPELINELABELCOUNTS            | FALSE      | UNIQUE_PIPELINE_NAME_INDEX_6                        | 1                | PIPELINENAME                | 0           | FALSE       | UNIQUE INDEX    | TRUE         | 3          | A           | 0     |                  |         | CREATE UNIQUE INDEX "PUBLIC"."UNIQUE_PIPELINE_NAME_INDEX_6" ON "PUBLIC"."PIPELINELABELCOUNTS"("PIPEL | 187 | 0         | UNIQUE_PIPELINE_NAME            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | USAGEDATAREPORTING             | FALSE      | PRIMARY_KEY_3                                       | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_3" ON "PUBLIC"."USAGEDATAREPORTING"("ID")                   | 167 | 0         | CONSTRAINT_3F                   | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE        | PUBLIC       | ARTIFACTPLANS                  | TRUE       | IDX_ARTIFACTPLAN_BUILD_ID                           | 1                | BUILDID                     | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_ARTIFACTPLAN_BUILD_ID" ON "PUBLIC"."ARTIFACTPLANS"("BUILDID")             | 108 | 0         | FK_ARTIFACTPLANS_BUILDS         | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | ARTIFACTPLANS                  | FALSE      | PRIMARY_KEY_5B                                      | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_5B" ON "PUBLIC"."ARTIFACTPLANS"("ID")                       | 115 | 0         | CONSTRAINT_E1                   | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | STAGES                         | TRUE       | IDX_STAGES_PIPELINEID                               | 1                | PIPELINEID                  | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_STAGES_PIPELINEID" ON "PUBLIC"."STAGES"("PIPELINEID")                     | 68  | 0         | FK_STAGES_PIPELINES             | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | STAGES                         | TRUE       | IDX_STAGE_NAME                                      | 1                | NAME                        | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_STAGE_NAME" ON "PUBLIC"."STAGES"("NAME")                                  | 91  | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | STAGES                         | TRUE       | IDX_STAGES_ORDERID                                  | 1                | ORDERID                     | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_STAGES_ORDERID" ON "PUBLIC"."STAGES"("ORDERID")                           | 92  | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | STAGES                         | TRUE       | IDX_STAGES_NAME_PIPELINEID                          | 1                | NAME                        | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_STAGES_NAME_PIPELINEID" ON "PUBLIC"."STAGES"("NAME", "PIPELINEID")        | 93  | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | STAGES                         | TRUE       | IDX_STAGES_NAME_PIPELINEID                          | 2                | PIPELINEID                  | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_STAGES_NAME_PIPELINEID" ON "PUBLIC"."STAGES"("NAME", "PIPELINEID")        | 93  | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | STAGES                         | TRUE       | IDX_STAGES_COUNTER_INDEX                            | 1                | COUNTER                     | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_STAGES_COUNTER_INDEX" ON "PUBLIC"."STAGES"("COUNTER")                     | 95  | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | STAGES                         | TRUE       | IDX_STAGES_COMPLETEDBYTRANSITIONID                  | 1                | COMPLETEDBYTRANSITIONID     | 0           | FALSE       | INDEX           | FALSE        | 3          | D           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_STAGES_COMPLETEDBYTRANSITIONID" ON "PUBLIC"."STAGES"("COMPLETEDBYTRANSITI | 96  | 1         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | STAGES                         | TRUE       | IDX_STAGES_STATE                                    | 1                | STATE                       | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_STAGES_STATE" ON "PUBLIC"."STAGES"("STATE")                               | 110 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | STAGES                         | TRUE       | IDX_STAGES_NAME_LATESTRUN_RESULT                    | 1                | NAME                        | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_STAGES_NAME_LATESTRUN_RESULT" ON "PUBLIC"."STAGES"("NAME", "LATESTRUN", " | 116 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | STAGES                         | TRUE       | IDX_STAGES_NAME_LATESTRUN_RESULT                    | 2                | LATESTRUN                   | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_STAGES_NAME_LATESTRUN_RESULT" ON "PUBLIC"."STAGES"("NAME", "LATESTRUN", " | 116 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | STAGES                         | TRUE       | IDX_STAGES_NAME_LATESTRUN_RESULT                    | 3                | RESULT                      | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_STAGES_NAME_LATESTRUN_RESULT" ON "PUBLIC"."STAGES"("NAME", "LATESTRUN", " | 116 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | STAGES                         | FALSE      | PRIMARY_KEY_5BD                                     | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_5BD" ON "PUBLIC"."STAGES"("ID")                             | 170 | 0         | CONSTRAINT_9                    | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | STAGES                         | FALSE      | UNIQUE_PIPELINE_ID_NAME_COUNTER_INDEX_5             | 1                | PIPELINEID                  | 0           | FALSE       | UNIQUE INDEX    | TRUE         | 3          | A           | 0     |                  |         | CREATE UNIQUE INDEX "PUBLIC"."UNIQUE_PIPELINE_ID_NAME_COUNTER_INDEX_5" ON "PUBLIC"."STAGES"("PIPELIN | 173 | 0         | UNIQUE_PIPELINE_ID_NAME_COUNTER | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | STAGES                         | FALSE      | UNIQUE_PIPELINE_ID_NAME_COUNTER_INDEX_5             | 2                | NAME                        | 0           | FALSE       | UNIQUE INDEX    | TRUE         | 3          | A           | 0     |                  |         | CREATE UNIQUE INDEX "PUBLIC"."UNIQUE_PIPELINE_ID_NAME_COUNTER_INDEX_5" ON "PUBLIC"."STAGES"("PIPELIN | 173 | 0         | UNIQUE_PIPELINE_ID_NAME_COUNTER | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | STAGES                         | FALSE      | UNIQUE_PIPELINE_ID_NAME_COUNTER_INDEX_5             | 3                | COUNTER                     | 0           | FALSE       | UNIQUE INDEX    | TRUE         | 3          | A           | 0     |                  |         | CREATE UNIQUE INDEX "PUBLIC"."UNIQUE_PIPELINE_ID_NAME_COUNTER_INDEX_5" ON "PUBLIC"."STAGES"("PIPELIN | 173 | 0         | UNIQUE_PIPELINE_ID_NAME_COUNTER | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | SERVERBACKUPS                  | FALSE      | PRIMARY_KEY_D                                       | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_D" ON "PUBLIC"."SERVERBACKUPS"("ID")                        | 45  | 0         | CONSTRAINT_7B                   | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | VERSIONINFOS                   | FALSE      | PRIMARY_KEY_848                                     | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_848" ON "PUBLIC"."VERSIONINFOS"("ID")                       | 258 | 0         | CONSTRAINT_848                  | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE        | PUBLIC       | VERSIONINFOS                   | FALSE      | CONSTRAINT_INDEX_84                                 | 1                | COMPONENTNAME               | 0           | FALSE       | UNIQUE INDEX    | TRUE         | 3          | A           | 0     |                  |         | CREATE UNIQUE INDEX "PUBLIC"."CONSTRAINT_INDEX_84" ON "PUBLIC"."VERSIONINFOS"("COMPONENTNAME")       | 260 | 0         | CONSTRAINT_848D                 | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | CHANGELOG                      | FALSE      | PRIMARY_KEY_F                                       | 1                | CHANGE_NUMBER               | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_F" ON "PUBLIC"."CHANGELOG"("CHANGE_NUMBER", "DELTA_SET")    | 9   | 0         | PKCHANGELOG                     | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | CHANGELOG                      | FALSE      | PRIMARY_KEY_F                                       | 2                | DELTA_SET                   | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_F" ON "PUBLIC"."CHANGELOG"("CHANGE_NUMBER", "DELTA_SET")    | 9   | 0         | PKCHANGELOG                     | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | RESOURCES                      | FALSE      | PRIMARY_KEY_2                                       | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_2" ON "PUBLIC"."RESOURCES"("ID")                            | 48  | 0         | CONSTRAINT_2                    | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE        | PUBLIC       | RESOURCES                      | TRUE       | FK_RESOURCES_BUILDS_INDEX_2                         | 1                | BUILDID                     | 0           | FALSE       | INDEX           | TRUE         | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."FK_RESOURCES_BUILDS_INDEX_2" ON "PUBLIC"."RESOURCES"("BUILDID")               | 90  | 0         | FK_RESOURCES_BUILDS             | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | RESOURCES                      | TRUE       | IDX_RESOURCES_BUILDID                               | 1                | BUILDID                     | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_RESOURCES_BUILDID" ON "PUBLIC"."RESOURCES"("BUILDID")                     | 103 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | NOTIFICATIONFILTERS            | FALSE      | PRIMARY_KEY_5                                       | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_5" ON "PUBLIC"."NOTIFICATIONFILTERS"("ID")                  | 104 | 0         | CONSTRAINT_5                    | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE        | PUBLIC       | NOTIFICATIONFILTERS            | TRUE       | FK_NOTIFICATIONFILTERS_USERS_INDEX_5                | 1                | USERID                      | 0           | FALSE       | INDEX           | TRUE         | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."FK_NOTIFICATIONFILTERS_USERS_INDEX_5" ON "PUBLIC"."NOTIFICATIONFILTERS"("USER | 111 | 0         | FK_NOTIFICATIONFILTERS_USERS    | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | BUILDS                         | TRUE       | IDX_BUILD_STATE                                     | 1                | STATE                       | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_BUILD_STATE" ON "PUBLIC"."BUILDS"("STATE")                                | 157 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | BUILDS                         | TRUE       | IDX_BUILD_NAME                                      | 1                | NAME                        | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_BUILD_NAME" ON "PUBLIC"."BUILDS"("NAME")                                  | 158 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | BUILDS                         | TRUE       | IDX_BUILD_RESULT                                    | 1                | RESULT                      | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_BUILD_RESULT" ON "PUBLIC"."BUILDS"("RESULT")                              | 194 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | BUILDS                         | TRUE       | IDX_BUILD_AGENT                                     | 1                | AGENTUUID                   | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_BUILD_AGENT" ON "PUBLIC"."BUILDS"("AGENTUUID")                            | 195 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | BUILDS                         | TRUE       | IDX_BUILD_IGNORED                                   | 1                | IGNORED                     | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_BUILD_IGNORED" ON "PUBLIC"."BUILDS"("IGNORED")                            | 196 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | BUILDS                         | TRUE       | IDX_BUILDS_AGENTID_STAGEID_NAME                     | 1                | NAME                        | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_BUILDS_AGENTID_STAGEID_NAME" ON "PUBLIC"."BUILDS"("NAME", "AGENTUUID", "S | 197 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | BUILDS                         | TRUE       | IDX_BUILDS_AGENTID_STAGEID_NAME                     | 2                | AGENTUUID                   | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_BUILDS_AGENTID_STAGEID_NAME" ON "PUBLIC"."BUILDS"("NAME", "AGENTUUID", "S | 197 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | BUILDS                         | TRUE       | IDX_BUILDS_AGENTID_STAGEID_NAME                     | 3                | STAGEID                     | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_BUILDS_AGENTID_STAGEID_NAME" ON "PUBLIC"."BUILDS"("NAME", "AGENTUUID", "S | 197 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | BUILDS                         | TRUE       | IDX_BUILDS_AGENTID_STAGEID_NAME                     | 4                | STATE                       | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_BUILDS_AGENTID_STAGEID_NAME" ON "PUBLIC"."BUILDS"("NAME", "AGENTUUID", "S | 197 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | BUILDS                         | TRUE       | IDX_BUILDS_AGENTID_STAGEID_NAME                     | 5                | RESULT                      | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_BUILDS_AGENTID_STAGEID_NAME" ON "PUBLIC"."BUILDS"("NAME", "AGENTUUID", "S | 197 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | BUILDS                         | TRUE       | IDX_BUILDS_NAME_STATE_STAGEID                       | 1                | NAME                        | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_BUILDS_NAME_STATE_STAGEID" ON "PUBLIC"."BUILDS"("NAME", "STATE", "STAGEID | 198 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | BUILDS                         | TRUE       | IDX_BUILDS_NAME_STATE_STAGEID                       | 2                | STATE                       | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_BUILDS_NAME_STATE_STAGEID" ON "PUBLIC"."BUILDS"("NAME", "STATE", "STAGEID | 198 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | BUILDS                         | TRUE       | IDX_BUILDS_NAME_STATE_STAGEID                       | 3                | STAGEID                     | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_BUILDS_NAME_STATE_STAGEID" ON "PUBLIC"."BUILDS"("NAME", "STATE", "STAGEID | 198 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | BUILDS                         | TRUE       | IDX_BUILDS_NAME_STAGE_ID                            | 1                | NAME                        | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_BUILDS_NAME_STAGE_ID" ON "PUBLIC"."BUILDS"("NAME", "STAGEID")             | 199 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | BUILDS                         | TRUE       | IDX_BUILDS_NAME_STAGE_ID                            | 2                | STAGEID                     | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_BUILDS_NAME_STAGE_ID" ON "PUBLIC"."BUILDS"("NAME", "STAGEID")             | 199 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | BUILDS                         | TRUE       | IDX_BUILDS_STAGEID                                  | 1                | STAGEID                     | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_BUILDS_STAGEID" ON "PUBLIC"."BUILDS"("STAGEID")                           | 211 | 0         | FK_BUILDS_STAGES                | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | BUILDS                         | FALSE      | PRIMARY_KEY_2EB                                     | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_2EB" ON "PUBLIC"."BUILDS"("ID")                             | 290 | 0         | CONSTRAINT_7                    | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE        | PUBLIC       | PIPELINES                      | TRUE       | IDX_PIPELINE_NAME_ID                                | 1                | NAME                        | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_PIPELINE_NAME_ID" ON "PUBLIC"."PIPELINES"("NAME", "ID")                   | 20  | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | PIPELINES                      | TRUE       | IDX_PIPELINE_NAME_ID                                | 2                | ID                          | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_PIPELINE_NAME_ID" ON "PUBLIC"."PIPELINES"("NAME", "ID")                   | 20  | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | PIPELINES                      | TRUE       | IDX_PIPELINE_NAME                                   | 1                | NAME                        | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_PIPELINE_NAME" ON "PUBLIC"."PIPELINES"("NAME")                            | 74  | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | PIPELINES                      | TRUE       | IDX_PIPELINE_LABEL                                  | 1                | LABEL                       | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_PIPELINE_LABEL" ON "PUBLIC"."PIPELINES"("LABEL")                          | 75  | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | PIPELINES                      | TRUE       | IDX_PIPELINES_NAME_COUNTER                          | 1                | NAME                        | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_PIPELINES_NAME_COUNTER" ON "PUBLIC"."PIPELINES"("NAME", "COUNTER")        | 76  | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | PIPELINES                      | TRUE       | IDX_PIPELINES_NAME_COUNTER                          | 2                | COUNTER                     | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_PIPELINES_NAME_COUNTER" ON "PUBLIC"."PIPELINES"("NAME", "COUNTER")        | 76  | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | PIPELINES                      | FALSE      | PRIMARY_KEY_F8                                      | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_F8" ON "PUBLIC"."PIPELINES"("ID")                           | 77  | 0         | CONSTRAINT_F                    | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | PIPELINEMATERIALREVISIONS      | TRUE       | IDX_PMR_PIPELINE_ID                                 | 1                | PIPELINEID                  | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_PMR_PIPELINE_ID" ON "PUBLIC"."PIPELINEMATERIALREVISIONS"("PIPELINEID")    | 80  | 0         | FK_PMR_PIPELINE                 | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | PIPELINEMATERIALREVISIONS      | TRUE       | FK_PMR_MATERIALID_INDEX_B                           | 1                | MATERIALID                  | 0           | FALSE       | INDEX           | TRUE         | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."FK_PMR_MATERIALID_INDEX_B" ON "PUBLIC"."PIPELINEMATERIALREVISIONS"("MATERIALI | 82  | 0         | FK_PMR_MATERIALID               | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | PIPELINEMATERIALREVISIONS      | FALSE      | PRIMARY_KEY_B81                                     | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_B81" ON "PUBLIC"."PIPELINEMATERIALREVISIONS"("ID")          | 85  | 0         | CONSTRAINT_A2                   | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE        | PUBLIC       | PIPELINEMATERIALREVISIONS      | TRUE       | FK_PMR_FROM_REVISION_INDEX_B                        | 1                | FROMREVISIONID              | 0           | FALSE       | INDEX           | TRUE         | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."FK_PMR_FROM_REVISION_INDEX_B" ON "PUBLIC"."PIPELINEMATERIALREVISIONS"("FROMRE | 100 | 0         | FK_PMR_FROM_REVISION            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | PIPELINEMATERIALREVISIONS      | TRUE       | FK_PMR_TO_REVISION_INDEX_B                          | 1                | TOREVISIONID                | 0           | FALSE       | INDEX           | TRUE         | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."FK_PMR_TO_REVISION_INDEX_B" ON "PUBLIC"."PIPELINEMATERIALREVISIONS"("TOREVISI | 102 | 0         | FK_PMR_TO_REVISION              | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | PIPELINEMATERIALREVISIONS      | TRUE       | FK_PMR_ACTUALFROMREVISIONID_INDEX_B                 | 1                | ACTUALFROMREVISIONID        | 0           | FALSE       | INDEX           | TRUE         | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."FK_PMR_ACTUALFROMREVISIONID_INDEX_B" ON "PUBLIC"."PIPELINEMATERIALREVISIONS"( | 105 | 0         | FK_PMR_ACTUALFROMREVISIONID     | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | MODIFICATIONS                  | TRUE       | IDX_MODIFICATIONS_MODIFIEDTIME                      | 1                | MODIFIEDTIME                | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_MODIFICATIONS_MODIFIEDTIME" ON "PUBLIC"."MODIFICATIONS"("MODIFIEDTIME")   | 140 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | MODIFICATIONS                  | TRUE       | IDX_MOD_NEW_MATERIAL_ID                             | 1                | MATERIALID                  | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_MOD_NEW_MATERIAL_ID" ON "PUBLIC"."MODIFICATIONS"("MATERIALID")            | 141 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | MODIFICATIONS                  | TRUE       | IDX_MODIFICATIONS_MATERIALID_ID                     | 1                | MATERIALID                  | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_MODIFICATIONS_MATERIALID_ID" ON "PUBLIC"."MODIFICATIONS"("MATERIALID", "I | 142 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | MODIFICATIONS                  | TRUE       | IDX_MODIFICATIONS_MATERIALID_ID                     | 2                | ID                          | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_MODIFICATIONS_MATERIALID_ID" ON "PUBLIC"."MODIFICATIONS"("MATERIALID", "I | 142 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | MODIFICATIONS                  | TRUE       | IDX_MODIFICATIONS_REVISION                          | 1                | REVISION                    | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_MODIFICATIONS_REVISION" ON "PUBLIC"."MODIFICATIONS"("REVISION")           | 144 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | MODIFICATIONS                  | TRUE       | FK_MODIFICATIONS_PIPELINEID_INDEX_A                 | 1                | PIPELINEID                  | 0           | FALSE       | INDEX           | TRUE         | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."FK_MODIFICATIONS_PIPELINEID_INDEX_A" ON "PUBLIC"."MODIFICATIONS"("PIPELINEID" | 145 | 0         | FK_MODIFICATIONS_PIPELINEID     | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | MODIFICATIONS                  | FALSE      | PRIMARY_KEY_AC                                      | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_AC" ON "PUBLIC"."MODIFICATIONS"("ID")                       | 190 | 0         | CONSTRAINT_C8                   | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE        | PUBLIC       | PIPELINESELECTIONS             | FALSE      | PRIMARY_KEY_99                                      | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_99" ON "PUBLIC"."PIPELINESELECTIONS"("ID")                  | 178 | 0         | CONSTRAINT_6                    | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | PIPELINESELECTIONS             | TRUE       | FK_PIPELINESELECTIONS_USERID_INDEX_9                | 1                | USERID                      | 0           | FALSE       | INDEX           | TRUE         | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."FK_PIPELINESELECTIONS_USERID_INDEX_9" ON "PUBLIC"."PIPELINESELECTIONS"("USERI | 180 | 0         | FK_PIPELINESELECTIONS_USERID    | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | PLUGINS                        | FALSE      | PRIMARY_KEY_E7                                      | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_E7" ON "PUBLIC"."PLUGINS"("ID")                             | 128 | 0         | CONSTRAINT_E7                   | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE        | PUBLIC       | PLUGINS                        | FALSE      | CONSTRAINT_INDEX_E7                                 | 1                | PLUGINID                    | 0           | FALSE       | UNIQUE INDEX    | TRUE         | 3          | A           | 0     |                  |         | CREATE UNIQUE INDEX "PUBLIC"."CONSTRAINT_INDEX_E7" ON "PUBLIC"."PLUGINS"("PLUGINID")                 | 130 | 0         | CONSTRAINT_E72                  | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | JOBAGENTMETADATA               | FALSE      | PRIMARY_KEY_23                                      | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_23" ON "PUBLIC"."JOBAGENTMETADATA"("ID")                    | 159 | 0         | CONSTRAINT_25                   | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | JOBAGENTMETADATA               | FALSE      | CONSTRAINT_25E_INDEX_2                              | 1                | JOBID                       | 0           | FALSE       | UNIQUE INDEX    | TRUE         | 3          | A           | 0     |                  |         | CREATE UNIQUE INDEX "PUBLIC"."CONSTRAINT_25E_INDEX_2" ON "PUBLIC"."JOBAGENTMETADATA"("JOBID")        | 217 | 0         | FK_JOBAGENTMETADATA_JOBS        | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | BUILDSTATETRANSITIONS          | TRUE       | IDX_BUILDSTATETRANSITION_BUILD_ID                   | 1                | BUILDID                     | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_BUILDSTATETRANSITION_BUILD_ID" ON "PUBLIC"."BUILDSTATETRANSITIONS"("BUILD | 14  | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | BUILDSTATETRANSITIONS          | TRUE       | FK_BUILDTRANSITIONS_STAGES_INDEX_F                  | 1                | STAGEID                     | 0           | FALSE       | INDEX           | TRUE         | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."FK_BUILDTRANSITIONS_STAGES_INDEX_F" ON "PUBLIC"."BUILDSTATETRANSITIONS"("STAG | 65  | 0         | FK_BUILDTRANSITIONS_STAGES      | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | BUILDSTATETRANSITIONS          | TRUE       | IDX_STATE_TRANSITION                                | 1                | CURRENTSTATE                | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_STATE_TRANSITION" ON "PUBLIC"."BUILDSTATETRANSITIONS"("CURRENTSTATE")     | 147 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | BUILDSTATETRANSITIONS          | FALSE      | PRIMARY_KEY_8                                       | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_8" ON "PUBLIC"."BUILDSTATETRANSITIONS"("ID")                | 148 | 0         | CONSTRAINT_F2                   | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE        | PUBLIC       | BUILDSTATETRANSITIONS          | TRUE       | FK_BUILDSTATETRANSITIONS_BUILDS_INDEX_8             | 1                | BUILDID                     | 0           | FALSE       | INDEX           | TRUE         | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."FK_BUILDSTATETRANSITIONS_BUILDS_INDEX_8" ON "PUBLIC"."BUILDSTATETRANSITIONS"( | 150 | 0         | FK_BUILDSTATETRANSITIONS_BUILDS | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | BUILDSTATETRANSITIONS          | TRUE       | IDX_BST_BUILDID_CURRENTSTATE                        | 1                | BUILDID                     | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_BST_BUILDID_CURRENTSTATE" ON "PUBLIC"."BUILDSTATETRANSITIONS"("BUILDID",  | 168 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | BUILDSTATETRANSITIONS          | TRUE       | IDX_BST_BUILDID_CURRENTSTATE                        | 2                | CURRENTSTATE                | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_BST_BUILDID_CURRENTSTATE" ON "PUBLIC"."BUILDSTATETRANSITIONS"("BUILDID",  | 168 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | ENVIRONMENTVARIABLES           | TRUE       | IDX_ENVIRONMENTVARIABLES_ENTITYTYPE                 | 1                | ENTITYTYPE                  | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_ENVIRONMENTVARIABLES_ENTITYTYPE" ON "PUBLIC"."ENVIRONMENTVARIABLES"("ENTI | 193 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | ENVIRONMENTVARIABLES           | TRUE       | IDX_ENV_JOB_ID                                      | 1                | ENTITYID                    | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_ENV_JOB_ID" ON "PUBLIC"."ENVIRONMENTVARIABLES"("ENTITYID")                | 303 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | ENVIRONMENTVARIABLES           | FALSE      | PRIMARY_KEY_9E                                      | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_9E" ON "PUBLIC"."ENVIRONMENTVARIABLES"("ID")                | 304 | 0         | CONSTRAINT_E6                   | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE        | PUBLIC       | AGENTS                         | TRUE       | IDX_AGENT_UUID                                      | 1                | UUID                        | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_AGENT_UUID" ON "PUBLIC"."AGENTS"("UUID")                                  | 125 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | AGENTS                         | FALSE      | PRIMARY_KEY_33D                                     | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_33D" ON "PUBLIC"."AGENTS"("ID")                             | 126 | 0         | CONSTRAINT_72                   | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | AGENTS                         | FALSE      | CONSTRAINT_72F_INDEX_3                              | 1                | UUID                        | 0           | FALSE       | UNIQUE INDEX    | TRUE         | 3          | A           | 0     |                  |         | CREATE UNIQUE INDEX "PUBLIC"."CONSTRAINT_72F_INDEX_3" ON "PUBLIC"."AGENTS"("UUID")                   | 136 | 0         | CONSTRAINT_72F                  | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | AGENTS                         | FALSE      | CONSTRAINT_72F4_INDEX_3                             | 1                | COOKIE                      | 0           | FALSE       | UNIQUE INDEX    | TRUE         | 3          | A           | 0     |                  |         | CREATE UNIQUE INDEX "PUBLIC"."CONSTRAINT_72F4_INDEX_3" ON "PUBLIC"."AGENTS"("COOKIE")                | 234 | 0         | CONSTRAINT_72F4                 | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | STAGEARTIFACTCLEANUPPROHIBITED | FALSE      | PRIMARY_KEY_8D                                      | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_8D" ON "PUBLIC"."STAGEARTIFACTCLEANUPPROHIBITED"("ID")      | 69  | 0         | CONSTRAINT_8D                   | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE        | PUBLIC       | STAGEARTIFACTCLEANUPPROHIBITED | TRUE       | IDX_STAGEARTIFACTCLEANUPPROHIBITED_PIPELINENAME     | 1                | PIPELINENAME                | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_STAGEARTIFACTCLEANUPPROHIBITED_PIPELINENAME" ON "PUBLIC"."STAGEARTIFACTCL | 288 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | USERS                          | FALSE      | PRIMARY_KEY_BFE                                     | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_BFE" ON "PUBLIC"."USERS"("ID")                              | 188 | 0         | CONSTRAINT_A                    | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE        | PUBLIC       | USERS                          | FALSE      | UNIQUE_NAME_INDEX_B                                 | 1                | NAME                        | 0           | FALSE       | UNIQUE INDEX    | TRUE         | 3          | A           | 0     |                  |         | CREATE UNIQUE INDEX "PUBLIC"."UNIQUE_NAME_INDEX_B" ON "PUBLIC"."USERS"("NAME")                       | 322 | 0         | UNIQUE_NAME                     | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | MATERIALS                      | TRUE       | IDX_MATERIALS_PIPELINENAME                          | 1                | PIPELINENAME                | 0           | FALSE       | INDEX           | FALSE        | 3          | A           | 0     |                  |         | CREATE INDEX "PUBLIC"."IDX_MATERIALS_PIPELINENAME" ON "PUBLIC"."MATERIALS"("PIPELINENAME")           | 220 | 0         | null                            | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | MATERIALS                      | FALSE      | MATERIALS_FLYWEIGHTNAME_UNIQUE_INDEX_D              | 1                | FLYWEIGHTNAME               | 0           | FALSE       | UNIQUE INDEX    | TRUE         | 3          | A           | 0     |                  |         | CREATE UNIQUE INDEX "PUBLIC"."MATERIALS_FLYWEIGHTNAME_UNIQUE_INDEX_D" ON "PUBLIC"."MATERIALS"("FLYWE | 221 | 0         | MATERIALS_FLYWEIGHTNAME_UNIQUE  | org.h2.pagestore.db.PageBtreeIndex    | FALSE
CRUISE        | PUBLIC       | MATERIALS                      | FALSE      | PRIMARY_KEY_D22                                     | 1                | ID                          | 0           | TRUE        | PRIMARY KEY     | TRUE         | 3          | A           | 0     |                  |         | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_D22" ON "PUBLIC"."MATERIALS"("ID")                          | 223 | 0         | CONSTRAINT_4                    | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE        | PUBLIC       | MATERIALS                      | FALSE      | UNIQUE_FINGERPRINT_INDEX_D                          | 1                | FINGERPRINT                 | 0           | FALSE       | UNIQUE INDEX    | TRUE         | 3          | A           | 0     |                  |         | CREATE UNIQUE INDEX "PUBLIC"."UNIQUE_FINGERPRINT_INDEX_D" ON "PUBLIC"."MATERIALS"("FINGERPRINT")     | 225 | 0         | UNIQUE_FINGERPRINT              | org.h2.pagestore.db.PageBtreeIndex    | FALSE
(data is partially truncated)
(111 rows, 30 ms)

java -cp lib/h2-1.4.200.jar org.h2.tools.Shell -url jdbc:h2:./cruise -user sa -sql 'SELECT * FROM information_schema.tables'

TABLE_CATALOG | TABLE_SCHEMA       | TABLE_NAME                     | TABLE_TYPE   | STORAGE_TYPE | SQL                                                                                                  | REMARKS | LAST_MODIFICATION   | ID  | TYPE_NAME | TABLE_CLASS                        | ROW_COUNT_ESTIMATE
CRUISE        | INFORMATION_SCHEMA | FUNCTION_COLUMNS               | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -22 | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | CONSTANTS                      | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -23 | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | SEQUENCES                      | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -9  | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | RIGHTS                         | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -12 | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | TRIGGERS                       | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -25 | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | CATALOGS                       | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -6  | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | CROSS_REFERENCES               | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -20 | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | SETTINGS                       | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 9223372036854775807 | -7  | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | FUNCTION_ALIASES               | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -13 | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | VIEWS                          | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -18 | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | TYPE_INFO                      | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -5  | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | CONSTRAINTS                    | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -21 | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | COLUMNS                        | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -2  | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | LOCKS                          | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 9223372036854775807 | -27 | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | KEY_COLUMN_USAGE               | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -32 | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | DOMAINS                        | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -24 | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | SCHEMATA                       | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -14 | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | COLUMN_PRIVILEGES              | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -16 | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | HELP                           | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -8  | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | SESSION_STATE                  | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 9223372036854775807 | -28 | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | TABLE_PRIVILEGES               | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -15 | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | REFERENTIAL_CONSTRAINTS        | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -33 | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | TABLE_TYPES                    | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -4  | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | TABLES                         | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -1  | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | QUERY_STATISTICS               | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -29 | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | ROLES                          | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -11 | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | SESSIONS                       | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 9223372036854775807 | -26 | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | IN_DOUBT                       | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 9223372036854775807 | -19 | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | USERS                          | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -10 | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | COLLATIONS                     | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -17 | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | SYNONYMS                       | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -30 | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | TABLE_CONSTRAINTS              | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -31 | null      | org.h2.table.MetaTable             | 1000
CRUISE        | INFORMATION_SCHEMA | INDEXES                        | SYSTEM TABLE | CACHED       | null                                                                                                 |         | 269804              | -3  | null      | org.h2.table.MetaTable             | 1000
CRUISE        | PUBLIC             | MODIFIEDFILES                  | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."MODIFIEDFILES"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTE |         | 0                   | 131 | null      | org.h2.pagestore.db.PageStoreTable | 179436
CRUISE        | PUBLIC             | PROPERTIES                     | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."PROPERTIES"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_S |         | 0                   | 34  | null      | org.h2.pagestore.db.PageStoreTable | 9672202
CRUISE        | PUBLIC             | _STAGES                        | VIEW         | MEMORY       | CREATE FORCE VIEW "PUBLIC"."_STAGES"("ID", "NAME", "APPROVEDBY", "PIPELINEID", "CREATEDTIME", "ORDER |         | 0                   | 61  | null      | org.h2.table.TableView             | 100
CRUISE        | PUBLIC             | ACCESSTOKEN                    | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."ACCESSTOKEN"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_ |         | 0                   | 204 | null      | org.h2.pagestore.db.PageStoreTable | 0
CRUISE        | PUBLIC             | DATASHARINGSETTINGS            | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."DATASHARINGSETTINGS"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC". |         | 0                   | 160 | null      | org.h2.pagestore.db.PageStoreTable | 1
CRUISE        | PUBLIC             | PIPELINESTATES                 | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."PIPELINESTATES"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYST |         | 0                   | 54  | null      | org.h2.pagestore.db.PageStoreTable | 149
CRUISE        | PUBLIC             | PIPELINELABELCOUNTS            | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."PIPELINELABELCOUNTS"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC". |         | 0                   | 84  | null      | org.h2.pagestore.db.PageStoreTable | 484
CRUISE        | PUBLIC             | USAGEDATAREPORTING             | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."USAGEDATAREPORTING"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"." |         | 0                   | 165 | null      | org.h2.pagestore.db.PageStoreTable | 1
CRUISE        | PUBLIC             | ARTIFACTPLANS                  | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."ARTIFACTPLANS"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTE |         | 0                   | 98  | null      | org.h2.pagestore.db.PageStoreTable | 4694
CRUISE        | PUBLIC             | STAGES                         | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."STAGES"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_SEQUE |         | 0                   | 62  | null      | org.h2.pagestore.db.PageStoreTable | 267455
CRUISE        | PUBLIC             | SERVERBACKUPS                  | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."SERVERBACKUPS"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTE |         | 0                   | 44  | null      | org.h2.pagestore.db.PageStoreTable | 607
CRUISE        | PUBLIC             | VERSIONINFOS                   | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."VERSIONINFOS"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM |         | 0                   | 70  | null      | org.h2.pagestore.db.PageStoreTable | 1
CRUISE        | PUBLIC             | CHANGELOG                      | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."CHANGELOG"(
    "CHANGE_NUMBER" INTEGER NOT NULL,
    "DELTA_SET" VARC |         | 0                   | 8   | null      | org.h2.pagestore.db.PageStoreTable | 180
CRUISE        | PUBLIC             | RESOURCES                      | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."RESOURCES"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_SE |         | 0                   | 47  | null      | org.h2.pagestore.db.PageStoreTable | 5
CRUISE        | PUBLIC             | NOTIFICATIONFILTERS            | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."NOTIFICATIONFILTERS"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC". |         | 0                   | 87  | null      | org.h2.pagestore.db.PageStoreTable | 24
CRUISE        | PUBLIC             | BUILDS                         | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."BUILDS"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_SEQUE |         | 0                   | 156 | null      | org.h2.pagestore.db.PageStoreTable | 788552
CRUISE        | PUBLIC             | PIPELINES                      | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."PIPELINES"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_SE |         | 0                   | 66  | null      | org.h2.pagestore.db.PageStoreTable | 159264
CRUISE        | PUBLIC             | PIPELINEMATERIALREVISIONS      | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."PIPELINEMATERIALREVISIONS"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PU |         | 0                   | 79  | null      | org.h2.pagestore.db.PageStoreTable | 326164
CRUISE        | PUBLIC             | MODIFICATIONS                  | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."MODIFICATIONS"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTE |         | 0                   | 139 | null      | org.h2.pagestore.db.PageStoreTable | 66178
CRUISE        | PUBLIC             | PIPELINESELECTIONS             | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."PIPELINESELECTIONS"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"." |         | 0                   | 177 | null      | org.h2.pagestore.db.PageStoreTable | 112
CRUISE        | PUBLIC             | PLUGINS                        | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."PLUGINS"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_SEQU |         | 0                   | 124 | null      | org.h2.pagestore.db.PageStoreTable | 2
CRUISE        | PUBLIC             | JOBAGENTMETADATA               | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."JOBAGENTMETADATA"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SY |         | 0                   | 155 | null      | org.h2.pagestore.db.PageStoreTable | 0
CRUISE        | PUBLIC             | BUILDSTATETRANSITIONS          | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."BUILDSTATETRANSITIONS"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC |         | 0                   | 146 | null      | org.h2.pagestore.db.PageStoreTable | 4651917
CRUISE        | PUBLIC             | ENVIRONMENTVARIABLES           | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."ENVIRONMENTVARIABLES"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC" |         | 0                   | 302 | null      | org.h2.pagestore.db.PageStoreTable | 93620
CRUISE        | PUBLIC             | AGENTS                         | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."AGENTS"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_SEQUE |         | 0                   | 123 | null      | org.h2.pagestore.db.PageStoreTable | 2357
CRUISE        | PUBLIC             | STAGEARTIFACTCLEANUPPROHIBITED | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."STAGEARTIFACTCLEANUPPROHIBITED"(
    "ID" BIGINT DEFAULT NEXT VALUE FO |         | 0                   | 63  | null      | org.h2.pagestore.db.PageStoreTable | 1100
CRUISE        | PUBLIC             | _BUILDS                        | VIEW         | MEMORY       | CREATE FORCE VIEW "PUBLIC"."_BUILDS"("ID", "NAME", "STATE", "RESULT", "AGENTUUID", "SCHEDULEDDATE",  |         | 0                   | 122 | null      | org.h2.table.TableView             | 100
CRUISE        | PUBLIC             | USERS                          | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."USERS"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_SEQUEN |         | 0                   | 135 | null      | org.h2.pagestore.db.PageStoreTable | 424
CRUISE        | PUBLIC             | MATERIALS                      | TABLE        | CACHED       | CREATE CACHED TABLE "PUBLIC"."MATERIALS"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_SE |         | 0                   | 219 | null      | org.h2.pagestore.db.PageStoreTable | 526
(data is partially truncated)
(62 rows, 7 ms)
chadlwilson commented 2 years ago

Hi @Ajoe-T

Based on

1910001       | DDL       | 2020-05-14 11:14:33.383 | null                    | SA         | 1910001_drop_properties_table.sql
1910002       | DDL       | 2020-05-14 11:22:38.541 | 2020-05-14 11:22:38.552 | SA         | 1910002_drop_artifact_properties_generator_table.sql

It looks like the properties table drop migration didn't complete. Based on the following migration being 8 minutes later, perhaps it got stuck, or GoCD server was killed, and left in a bad state. Maybe it was slow, and someone got impatient back in May 2020? :-) The only thing this migration does is DROP TABLE properties

The good news is that to my reading, it seems likely you can probably manually drop that table from your H2 DB using the same tools above (obviously ensure you have an unadulterated/clean backup of your H2DB first), and then try the migration to postgres again. It looks to me like you have all other expected migrations there and applied (180 rows).

Ajoe-T commented 2 years ago

Hi @chadlwilson @arvindsv @maheshp ,

Manually dropped the properties table and the issue is resolved.

Thank you for the quick response!!

chadlwilson commented 2 years ago

That's great to hear, hopefully you're successful getting up and running on 20.5.0 with postgres and then you can move forward to the latest version with confidence.

We can re-open this if you folks have further troubles.