History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: QB-4067
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Blocker Blocker
Assignee: Unassigned
Reporter: Alexey Kuznetsov
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
QuickBuild

java.sql.SQLSyntaxErrorException when update from 13.0.37

Created: 12/Jan/24 08:34 AM   Updated: 17/Jan/24 12:10 PM
Component/s: None
Affects Version/s: 14.0.2
Fix Version/s: 14.0.4

Original Estimate: Unknown Remaining Estimate: Unknown Time Spent: Unknown
File Attachments: 1. XML File log4j2.xml (1 kb)



 Description  « Hide
I got the following error at the end of QB update from version 13.0.37 to 14.0.2.
NOTE: There was no such issue on update to version 14.0.1.

INFO Copying new program files into /etc/quickbuild-8.0.20...
INFO Migrating exported data...
INFO >>> 2024-01-11 13:19:44,380 INFO Cleaning cached plugin libraries...
INFO >>> 2024-01-11 13:19:44,434 INFO Cleaning temp directory...
INFO >>> 2024-01-11 13:19:44,439 INFO Booting QuickBuild from '/etc/quickbuild-8.0.20'...
INFO >>> 2024-01-11 13:19:44,439 INFO Starting framework...
INFO >>> 2024-01-11 13:19:44,489 INFO Caching plugin libraries...
INFO >>> 2024-01-11 13:19:47,453 INFO Starting QuickBuild server...
INFO >>> 2024-01-11 13:20:07,828 INFO Stopping QuickBuild server...
INFO >>> 2024-01-11 13:20:08,271 INFO Stopping plugins...
INFO >>> 2024-01-11 13:20:08,274 INFO Stopping task scheduler...
INFO >>> 2024-01-11 13:20:08,409 INFO QuickBuild server stopped.
INFO >>> 2024-01-11 13:20:09,523 INFO Cleaning cached plugin libraries...
INFO >>> 2024-01-11 13:20:09,560 INFO Cleaning temp directory...
INFO >>> 2024-01-11 13:20:09,565 INFO Booting QuickBuild from '/etc/quickbuild-8.0.20'...
INFO >>> 2024-01-11 13:20:09,565 INFO Starting framework...
INFO >>> 2024-01-11 13:20:09,616 INFO Caching plugin libraries...
INFO >>> 2024-01-11 13:20:11,815 INFO Starting QuickBuild server...
INFO >>> 2024-01-11 13:20:19,590 INFO Stopping QuickBuild server...
INFO >>> 2024-01-11 13:20:19,604 INFO Stopping plugins...
INFO >>> 2024-01-11 13:20:19,607 INFO Stopping task scheduler...
INFO >>> 2024-01-11 13:20:19,624 INFO QuickBuild server stopped.
ERROR >>> Exception in thread "main" java.lang.ExceptionInInitializerError
ERROR >>> at com.pmease.quickbuild.Quickbuild.importData(Quickbuild.java:1166)
ERROR >>> at com.pmease.quickbuild.bootstrap.Bootstrap$6.execute(Bootstrap.java:201)
ERROR >>> at com.pmease.quickbuild.Quickbuild$3.run(Quickbuild.java:872)
ERROR >>> at java.base/java.lang.Thread.run(Thread.java:829)
ERROR >>> Caused by: com.google.inject.ProvisionException: Guice provision errors:
ERROR >>>
ERROR >>> 1) Error in custom provider, java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
ERROR >>> while locating com.pmease.quickbuild.persistence.SessionFactoryProvider
ERROR >>> at com.pmease.quickbuild.QuickbuildModule.configure(QuickbuildModule.java:36)
ERROR >>> while locating org.hibernate.SessionFactory
ERROR >>> for field at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager.sessionFactory(DefaultDataManager.java:137)
ERROR >>> at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager.class(DefaultDataManager.java:137)
ERROR >>> while locating com.pmease.quickbuild.entitymanager.impl.DefaultDataManager
ERROR >>> while locating com.pmease.quickbuild.entitymanager.DataManager
ERROR >>>
ERROR >>> 1 error
ERROR >>> at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:987)
ERROR >>> at com.google.inject.internal.InjectorImpl.getInstance(InjectorImpl.java:1013)
ERROR >>> at com.pmease.quickbuild.Quickbuild.getInstance(Quickbuild.java:1061)
ERROR >>> at com.pmease.quickbuild.entitymanager.DataManager.<clinit>(DataManager.java:67)
ERROR >>> ... 4 more
ERROR >>> Caused by: java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
ERROR >>> at com.pmease.quickbuild.util.DbUtils.execute(DbUtils.java:122)
ERROR >>> at com.pmease.quickbuild.persistence.SessionFactoryProvider.get(SessionFactoryProvider.java:99)
ERROR >>> at com.pmease.quickbuild.persistence.SessionFactoryProvider.get(SessionFactoryProvider.java:36)
ERROR >>> at com.google.inject.internal.BoundProviderFactory.get(BoundProviderFactory.java:55)
ERROR >>> at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:46)
ERROR >>> at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1031)
ERROR >>> at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40)
ERROR >>> at com.google.inject.Scopes$1$1.get(Scopes.java:65)
ERROR >>> at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:40)
ERROR >>> at com.google.inject.internal.SingleFieldInjector.inject(SingleFieldInjector.java:53)
ERROR >>> at com.google.inject.internal.MembersInjectorImpl.injectMembers(MembersInjectorImpl.java:110)
ERROR >>> at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:94)
ERROR >>> at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:254)
ERROR >>> at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:46)
ERROR >>> at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1031)
ERROR >>> at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40)
ERROR >>> at com.google.inject.Scopes$1$1.get(Scopes.java:65)
ERROR >>> at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:40)
ERROR >>> at com.google.inject.internal.InjectorImpl$3.get(InjectorImpl.java:737)
ERROR >>> at com.google.inject.internal.InjectorImpl$4$1.call(InjectorImpl.java:978)
ERROR >>> at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1024)
ERROR >>> at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:974)
ERROR >>> ... 7 more
ERROR >>> Caused by: java.sql.SQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
ERROR >>> at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
ERROR >>> at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
ERROR >>> at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763)
ERROR >>> at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
ERROR >>> at com.pmease.quickbuild.util.DbUtils.execute(DbUtils.java:119)
ERROR >>> ... 28 more
ERROR Failed to upgrade /etc/quickbuild-8.0.20
INFO Now restoring old installation directory due to upgrade failure...
INFO Old installation directory is now restored.
WARN The database might be in an inconsistent state due to upgrade failure. In that case, you need to restore the database by first cleaning it, and then running below command:
INFO /etc/quickbuild-8.0.20/bin/restore.sh /etc/quickbuild-8.0.20/dbbackup~2024-01-11_13-00-44.zip

 All   Comments   Work Log   Change History      Sort Order:
Robin Shen [12/Jan/24 12:36 PM]
Which MySQL version are you using. I tested with 8.0 and it works fine. Also please copy attached file into "conf" directory of QB 14.0.2, and then run upgrade again. QB will print the exact failed SQL.

Alexey Kuznetsov [12/Jan/24 01:01 PM]
Aurora MySQL 3.05.1 (compatible with MySQL 8.0.32).
Thank you, I'll do it on Monday.

Alexey Kuznetsov [15/Jan/24 09:17 AM]
INFO >>> 2024-01-15 09:10:44,878 INFO Booting QuickBuild from '/etc/quickbuild-8.0.20'...
INFO >>> 2024-01-15 09:10:44,878 INFO Starting framework...
INFO >>> 2024-01-15 09:10:44,928 INFO Caching plugin libraries...
INFO >>> 2024-01-15 09:10:47,191 INFO Starting QuickBuild server...
INFO >>> 2024-01-15 09:10:49,268 DEBUG Executing sql: create table QB_ALARM (QB_ID bigint not null, QB_NOTIFIER varchar(255) not null, QB_USER_ID bigint not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,295 DEBUG Executing sql: create table QB_ALERT (QB_ID bigint not null, QB_ACK_MESSAGE longtext, QB_ACK_TIME bigint, QB_ALERT_MESSAGE longtext, QB_CATEGORY integer not null, QB_CTIME bigint, QB_FIXED bit, QB_FIXED_AT datetime, QB_PRIORITY varchar(255) not null, QB_SUBJECT varchar(255) not null, QB_TRIGGER varchar(255) not null, QB_FIXED_BY_ID bigint, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,323 DEBUG Executing sql: create table QB_AUDIT (QB_ID bigint not null, QB_ACTION varchar(4000) not null, QB_CONTENT longtext, QB_PREVIOUS_CONTENT longtext, QB_TIMESTAMP datetime not null, QB_USER varchar(255) not null, QB_CONFIGURATION_ID bigint, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,348 DEBUG Executing sql: create table QB_AUTHORIZATION (QB_ID bigint not null, QB_PERMISSIONS longblob, QB_CONFIGURATION_ID bigint not null, QB_GROUP_ID bigint not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,371 DEBUG Executing sql: create table QB_BUILD (QB_ID bigint not null, QB_BEGIN_DATE datetime not null, QB_DESCRIPTION longtext, QB_DURATION bigint, QB_ERROR_MESSAGE longtext, QB_GLOBAL_RESOURCE_NAMES longblob, QB_MASTER_NODE_ADDRESS varchar(255), QB_REPOSITORY_RUNTIMES longblob not null, QB_SCHEDULED bit not null, bld_sec_var_vals longblob not null, QB_SHORT_BRANCH varchar(255), QB_SHORT_BRANCH_REPO varchar(255), QB_STATUS integer not null, QB_STATUS_DATE datetime not null, QB_STEP_RUNTIMES longblob not null, QB_VERSION varchar(255) not null, QB_WAIT_DURATION bigint, QB_CANCELLER_ID bigint, QB_CONFIGURATION_ID bigint not null, QB_PROMOTED_FROM_ID bigint, QB_REQUESTER_ID bigint, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,400 DEBUG Executing sql: create table QB_BUILD_DEPENDENCE (QB_ID bigint not null, QB_DEPENDENCY_ID bigint not null, QB_DEPENDENT_ID bigint not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,424 DEBUG Executing sql: create table QB_BUILD_OPTION (QB_ID bigint not null, QB_VARIABLES longblob, QB_CONFIGURATION_ID bigint not null, QB_USER_ID bigint not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,446 DEBUG Executing sql: create table QB_CLOUD_PROFILE (QB_ID bigint not null, QB_DESCRIPTION varchar(1024), QB_IDLE_TIME_TO_TERMINATE integer not null, QB_MAX_NODES_TO_LAUNCH integer not null, QB_NAME varchar(255) not null, QB_NODE_LAUNCHERDOM longblob, QB_PROFILE_ATTRIBUTES longblob not null, QB_RETRY_PERIOD integer not null, QB_TEST_INFO longblob, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,471 DEBUG Executing sql: create table QB_CONFIGURATION (QB_ID bigint not null, qb_access_deny_msg varchar(255), QB_ACTIVE_REPOSITORY varchar(255), QB_AGGREGATIONDOMS longblob not null, QB_ARTIFACT_CLEANUP_STRATEGY longblob, QB_ARTIFACT_STORAGEDOM longblob, qb_audit_request bit, qb_conf_bd_script longtext, QB_BUILD_CLEANUP_STRATEGY longblob, QB_BUILD_CONDITION longblob, QB_CHECK_CONDITION_TIMEOUT varchar(255), qb_cmd_pre_kill longtext, QB_CONCURRENT bit, qb_custom_col_conf longblob, QB_DATA longblob not null, QB_DESCRIPTION longtext, QB_DISABLED bit, qb_conf_err_notify longtext, QB_ERROR_MESSAGE varchar(2048), QB_FORCE_KILL_TIMEOUT longtext, QB_GLOBAL_RESOURCE_REQUIREMENT longblob, QB_LEGACY_CMD_MODE bit, QB_LOG_LEVEL longblob, QB_NAME varchar(255) not null, QB_NODE_ASSIGNMENT longblob, QB_NOTIFICATIONS longblob not null, qb_bld_del_script longtext, qb_conf_del_script longtext, QB_ORDER integer not null, qb_pause_notify bit, qb_pipeline_name varchar(255), QB_PLUGIN_SETTINGDOMS longblob not null, QB_POST_BUILD_SCRIPT longtext, post_rec_script longtext, post_unrec_script longtext, QB_PRE_BUILD_SCRIPT longtext, QB_PRE_QUEUE_SCRIPT longtext, QB_PRIORITY longtext, QB_PROMOTIONS longblob not null, qb_queue_changed bit, QB_RECORDSCMCHANGES bit, QB_REPOSITORYDOMS longblob not null, QB_SCHEDULE longblob, QB_SHORT_BRANCHES longblob, qb_show_pipe_conf bit, qb_para_vertical bit, QB_SNAPSHOT_TAKING longblob, QB_STATUS_DATE datetime not null, QB_STEPDOMS longblob not null, QB_STORAGE_SETTING longblob, QB_TIMEOUT varchar(255), QB_TRIGGER_DEPENDENTS bit, qb_validate_var bit, QB_VARIABLES longblob not null, QB_VERSION_MANAGERDOM longblob, QB_WORKSPACE_SETTING longblob, QB_PARENT_ID bigint, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,508 DEBUG Executing sql: create table QB_DASHBOARD (QB_ID bigint not null, QB_COLUMNS longblob, QB_DESCRIPTION varchar(2048), QB_NAME varchar(255) not null, QB_PRIMARY bit not null, QB_USER_ID bigint not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,532 DEBUG Executing sql: create table QB_DISCUSSION (QB_ID bigint not null, QB_CREATED_AT datetime not null, QB_HTML longtext not null, QB_MARKUP_TYPE integer not null, QB_NUMBER integer, QB_RAW longtext not null, QB_UPDATED_AT datetime not null, QB_AUTHOR_ID bigint not null, QB_BUILD_ID bigint not null, QB_CONFIGURATION_ID bigint not null, QB_REPLY_TO_ID bigint, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,559 DEBUG Executing sql: create table QB_FAVORITE (QB_ID bigint not null, QB_CONFIGURATION_ID bigint not null, QB_USER_ID bigint not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,584 DEBUG Executing sql: create table QB_GROUP (QB_ID bigint not null, QB_ADMIN bit not null, QB_AGENT_ALLOWED bit not null, qb_download_agent bit, qb_edit_node_attr bit, qb_manage_bld_grid bit, QB_DESCRIPTION varchar(1024), QB_ENFORCE2FA bit not null, QB_EXPAND_ALL_ALLOWED bit not null, QB_FORCE_HTTPS bit not null, QB_GRID_ACCESS_ALLOWED bit not null, QB_NAME varchar(255) not null, qb_node_attr_allow bit, QB_PLUGIN_SETTINGDOMS longblob not null, QB_QUEUE_ACCESS_ALLOWED bit not null, QB_RESOLVE_ALERTS_ALLOWED bit not null, QB_REST_ACCESS_ALLOWED bit not null, QB_SCRIPT_ALLOWED bit not null, qb_share_dashboard bit, QB_SYSTEM_LOG_ALLOWED bit not null, QB_VIEW_ALERTS_ALLOWED bit not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,615 DEBUG Executing sql: create table QB_GROUP_SHARE (QB_ID bigint not null, QB_DASHBOARD_ID bigint not null, QB_GROUP_ID bigint, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,639 DEBUG Executing sql: create table QB_ID (QB_ID bigint not null, QB_NAME varchar(255) not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,669 DEBUG Executing sql: create table QB_MEASUREMENT_DATA1D (QB_ID bigint not null, QB_MAX_VALUE double precision, QB_METRIC_NAME varchar(255) not null, QB_MIN_VALUE double precision, QB_SOURCE varchar(255) not null, QB_TIMESTAMP bigint, QB_VALUE double precision, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,705 DEBUG Executing sql: create table QB_MEASUREMENT_DATA1H (QB_ID bigint not null, QB_MAX_VALUE double precision, QB_METRIC_NAME varchar(255) not null, QB_MIN_VALUE double precision, QB_SOURCE varchar(255) not null, QB_TIMESTAMP bigint, QB_VALUE double precision, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,731 DEBUG Executing sql: create table QB_MEASUREMENT_DATA6H (QB_ID bigint not null, QB_MAX_VALUE double precision, QB_METRIC_NAME varchar(255) not null, QB_MIN_VALUE double precision, QB_SOURCE varchar(255) not null, QB_TIMESTAMP bigint, QB_VALUE double precision, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,757 DEBUG Executing sql: create table QB_MEASUREMENT_DATAR00 (QB_ID bigint not null, QB_METRIC_NAME varchar(255) not null, QB_SOURCE varchar(255) not null, QB_TIMESTAMP bigint, QB_VALUE double precision, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,782 DEBUG Executing sql: create table QB_MEASUREMENT_DATAR01 (QB_ID bigint not null, QB_METRIC_NAME varchar(255) not null, QB_SOURCE varchar(255) not null, QB_TIMESTAMP bigint, QB_VALUE double precision, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,805 DEBUG Executing sql: create table QB_MEASUREMENT_DATAR02 (QB_ID bigint not null, QB_METRIC_NAME varchar(255) not null, QB_SOURCE varchar(255) not null, QB_TIMESTAMP bigint, QB_VALUE double precision, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,830 DEBUG Executing sql: create table QB_MEASUREMENT_DATAR03 (QB_ID bigint not null, QB_METRIC_NAME varchar(255) not null, QB_SOURCE varchar(255) not null, QB_TIMESTAMP bigint, QB_VALUE double precision, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,854 DEBUG Executing sql: create table QB_MEASUREMENT_DATAR04 (QB_ID bigint not null, QB_METRIC_NAME varchar(255) not null, QB_SOURCE varchar(255) not null, QB_TIMESTAMP bigint, QB_VALUE double precision, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,878 DEBUG Executing sql: create table QB_MEMBERSHIP (QB_ID bigint not null, QB_ASSIGNED_LOCALLY bit not null, QB_GROUP_ID bigint not null, QB_USER_ID bigint not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,903 DEBUG Executing sql: create table QB_PERMISSION_SET (QB_ID bigint not null, QB_NAME varchar(255) not null, QB_PERMISSIONS longblob not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,932 DEBUG Executing sql: create table QB_PLUGIN_CONFIG (QB_ID bigint not null, QB_ENABLED bit not null, QB_PLUGIN_ID varchar(255), QB_SETTINGDOM longblob, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,957 DEBUG Executing sql: create table QB_PROMOTE_OPTION (QB_ID bigint not null, QB_ACTIVE bit not null, QB_NAME varchar(255) not null, QB_VARIABLES longblob, QB_CONFIGURATION_ID bigint not null, QB_USER_ID bigint not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:49,980 DEBUG Executing sql: create table QB_RESOURCE (QB_ID bigint not null, QB_DESCRIPTION varchar(2048), QB_NAME varchar(255) not null, QB_TYPE longblob not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:50,018 DEBUG Executing sql: create table QB_RESOURCE_ACCESS (QB_ID bigint not null, QB_DURATION bigint not null, QB_STEPS longblob not null, QB_WHEN datetime not null, QB_CONFIGURATION_ID bigint not null, QB_RESOURCE_ID bigint not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:50,060 DEBUG Executing sql: create table QB_SETTING (QB_ID bigint not null, QB_OBJECT longblob, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:50,087 DEBUG Executing sql: create table QB_SUBSCRIPTION (QB_ID bigint not null, QB_COMMIT_ONLY bit not null, QB_CONDITION integer not null, QB_NOTIFIER varchar(255) not null, QB_SUBSCRIBE_DESCENDENTS bit not null, QB_CONFIGURATION_ID bigint not null, QB_USER_ID bigint not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:50,113 DEBUG Executing sql: create table QB_TOKEN (QB_ID bigint not null, QB_HOST_NAME varchar(255) not null, QB_IP varchar(255), QB_LAST_USED_DATE datetime, QB_LAST_USED_REASON longtext, QB_NODE_LAUNCH_ID varchar(255), QB_OFFLINE_ALERT bit not null, QB_OFFLINE_NOTE varchar(255), QB_OVERSSL bit, QB_PORT integer not null, QB_TEST bit not null, QB_VALUE varchar(255) not null, QB_CLOUD_PROFILE_ID bigint, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:50,139 DEBUG Executing sql: create table QB_TRIGGER_DEPENDENCE (QB_ID bigint not null, QB_DEPENDENCY_ID bigint not null, QB_DEPENDENT_ID bigint not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:50,165 DEBUG Executing sql: create table QB_USER (QB_ID bigint not null, QB_ACCESS_TOKEN varchar(255) not null, QB_AUTHENTICATOR varchar(255), QB_EMAIL varchar(255), QB_FAVORITE_DASHBOARD_IDS longblob, QB_FULL_NAME varchar(255), QB_LAST_LOGIN datetime not null, QB_NAME varchar(255) not null, QB_PASSWORD varchar(255) not null, QB_PLUGIN_SETTINGDOMS longblob not null, QB_SEARCH_FOR integer, QB_TWO_FACTOR_AUTHENTICATION longblob, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:50,191 DEBUG Executing sql: create table QB_USER_SHARE (QB_ID bigint not null, QB_DASHBOARD_ID bigint not null, QB_USER_ID bigint not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 09:10:50,216 DEBUG Executing sql: create index ALERT_CTIME on QB_ALERT (QB_CTIME)
INFO >>> 2024-01-15 09:10:50,239 DEBUG Executing sql: create index ALERT_TRIGGER on QB_ALERT (QB_TRIGGER)
INFO >>> 2024-01-15 09:10:50,261 DEBUG Executing sql: create index IDX_AUDIT_TIME on QB_AUDIT (QB_TIMESTAMP)
INFO >>> 2024-01-15 09:10:50,283 DEBUG Executing sql: create index IDX_AUDIT_USER on QB_AUDIT (QB_USER)
INFO >>> 2024-01-15 09:10:50,303 DEBUG Executing sql: alter table QB_AUTHORIZATION add constraint UK_mhpclqvpwnsd5r0j55u7wse1m unique (QB_CONFIGURATION_ID, QB_GROUP_ID)
INFO >>> 2024-01-15 09:10:50,322 DEBUG Executing sql: create index IDX_BLD_DATE on QB_BUILD (QB_BEGIN_DATE)
INFO >>> 2024-01-15 09:10:50,356 DEBUG Executing sql: create index IDX_BLD_DURATION on QB_BUILD (QB_DURATION)
INFO >>> 2024-01-15 09:10:50,383 DEBUG Executing sql: create index IDX_BLD_BRANCH on QB_BUILD (QB_SHORT_BRANCH)
INFO >>> 2024-01-15 09:10:50,416 DEBUG Executing sql: create index IDX_BLD_BR_REPO on QB_BUILD (QB_SHORT_BRANCH_REPO)
INFO >>> 2024-01-15 09:10:50,446 DEBUG Executing sql: create index IDX_BLD_STATUS on QB_BUILD (QB_STATUS)
INFO >>> 2024-01-15 09:10:50,484 DEBUG Executing sql: create index IDX_BLD_VERSION on QB_BUILD (QB_VERSION)
INFO >>> 2024-01-15 09:10:50,522 DEBUG Executing sql: create index UK_q762tyw11sfk0rnyv0moigl54 on QB_BUILD (QB_ID, QB_CONFIGURATION_ID)
INFO >>> 2024-01-15 09:10:50,593 DEBUG Executing sql: create index UK_9c1r7675hu1n3emnep638qi96 on QB_BUILD (QB_STATUS, QB_CONFIGURATION_ID)
INFO >>> 2024-01-15 09:10:50,625 DEBUG Executing sql: alter table QB_BUILD_DEPENDENCE add constraint UK_k86vplpii7ebddfyek69gr91d unique (QB_DEPENDENT_ID, QB_DEPENDENCY_ID)
INFO >>> 2024-01-15 09:10:50,644 DEBUG Executing sql: alter table QB_BUILD_OPTION add constraint UK_4kt0icrv81msq2t2bfswcmqb unique (QB_USER_ID, QB_CONFIGURATION_ID)
INFO >>> 2024-01-15 09:10:50,673 DEBUG Executing sql: alter table QB_CLOUD_PROFILE add constraint UK_og3rvlib691t0th507mgby22x unique (QB_NAME)
INFO >>> 2024-01-15 09:10:50,695 DEBUG Executing sql: alter table QB_CONFIGURATION add constraint UK_9kvrhab72gmiw3gqfphbgmedq unique (QB_PARENT_ID, QB_NAME)
INFO >>> 2024-01-15 09:10:50,732 DEBUG Executing sql: alter table QB_DASHBOARD add constraint UK_540gxxofu01arwvx1ousx77p2 unique (QB_USER_ID, QB_NAME)
INFO >>> 2024-01-15 09:10:50,753 DEBUG Executing sql: create index IDX_DISCUSSION_NUM on QB_DISCUSSION (QB_NUMBER)
INFO >>> 2024-01-15 09:10:50,776 DEBUG Executing sql: create index IDX_DISCUSSION_CD on QB_DISCUSSION (QB_CREATED_AT)
INFO >>> 2024-01-15 09:10:50,799 DEBUG Executing sql: create index IDX_DISCUSSION_UD on QB_DISCUSSION (QB_UPDATED_AT)
INFO >>> 2024-01-15 09:10:50,824 DEBUG Executing sql: alter table QB_FAVORITE add constraint UK_mcg8rxkslku1vxl2xumbekjyl unique (QB_USER_ID, QB_CONFIGURATION_ID)
INFO >>> 2024-01-15 09:10:50,845 DEBUG Executing sql: alter table QB_GROUP add constraint UK_sm296bowcb3gsq44o9hnmkf07 unique (QB_NAME)
INFO >>> 2024-01-15 09:10:50,873 DEBUG Executing sql: alter table QB_GROUP_SHARE add constraint UK_e5ut0jadkuj5l8gaa06nep5er unique (QB_GROUP_ID, QB_DASHBOARD_ID)
INFO >>> 2024-01-15 09:10:50,892 DEBUG Executing sql: alter table QB_ID add constraint UK_kxcav1xl5r0p4f44f6l0i0qv1 unique (QB_NAME)
INFO >>> 2024-01-15 09:10:50,910 DEBUG Executing sql: alter table QB_MEASUREMENT_DATA1D add constraint PK_DATA unique (QB_TIMESTAMP, QB_SOURCE, QB_METRIC_NAME)
INFO >>> 2024-01-15 09:10:50,930 DEBUG Executing sql: create index IDX_TIMESTAMP_1D on QB_MEASUREMENT_DATA1D (QB_TIMESTAMP)
INFO >>> 2024-01-15 09:10:50,952 DEBUG Executing sql: create index IDX_SOURCE_1D on QB_MEASUREMENT_DATA1D (QB_SOURCE)
INFO >>> 2024-01-15 09:10:50,972 DEBUG Executing sql: create index IDX_METRIC_NAME_1D on QB_MEASUREMENT_DATA1D (QB_METRIC_NAME)
INFO >>> 2024-01-15 09:10:50,993 DEBUG Executing sql: alter table QB_MEASUREMENT_DATA1H add constraint PK_DATA_1H unique (QB_TIMESTAMP, QB_SOURCE, QB_METRIC_NAME)
INFO >>> 2024-01-15 09:10:51,053 DEBUG Executing sql: create index IDX_TIMESTAMP_1H on QB_MEASUREMENT_DATA1H (QB_TIMESTAMP)
INFO >>> 2024-01-15 09:10:51,075 DEBUG Executing sql: create index IDX_SOURCE_1H on QB_MEASUREMENT_DATA1H (QB_SOURCE)
INFO >>> 2024-01-15 09:10:51,097 DEBUG Executing sql: create index IDX_METRIC_NAME_1H on QB_MEASUREMENT_DATA1H (QB_METRIC_NAME)
INFO >>> 2024-01-15 09:10:51,121 DEBUG Executing sql: alter table QB_MEASUREMENT_DATA6H add constraint PK_DATA_6H unique (QB_TIMESTAMP, QB_SOURCE, QB_METRIC_NAME)
INFO >>> 2024-01-15 09:10:51,139 DEBUG Executing sql: create index IDX_TIMESTAMP_6H on QB_MEASUREMENT_DATA6H (QB_TIMESTAMP)
INFO >>> 2024-01-15 09:10:51,166 DEBUG Executing sql: create index IDX_SOURCE_6H on QB_MEASUREMENT_DATA6H (QB_SOURCE)
INFO >>> 2024-01-15 09:10:51,190 DEBUG Executing sql: create index IDX_METRIC_NAME_6H on QB_MEASUREMENT_DATA6H (QB_METRIC_NAME)
INFO >>> 2024-01-15 09:10:51,218 DEBUG Executing sql: alter table QB_MEASUREMENT_DATAR00 add constraint PK_DATA_R00 unique (QB_TIMESTAMP, QB_SOURCE, QB_METRIC_NAME)
INFO >>> 2024-01-15 09:10:51,237 DEBUG Executing sql: create index IDX_TIMESTAMP_R00 on QB_MEASUREMENT_DATAR00 (QB_TIMESTAMP)
INFO >>> 2024-01-15 09:10:51,257 DEBUG Executing sql: create index IDX_SOURCE_R00 on QB_MEASUREMENT_DATAR00 (QB_SOURCE)
INFO >>> 2024-01-15 09:10:51,277 DEBUG Executing sql: create index IDX_METRIC_NAME_R00 on QB_MEASUREMENT_DATAR00 (QB_METRIC_NAME)
INFO >>> 2024-01-15 09:10:51,300 DEBUG Executing sql: alter table QB_MEASUREMENT_DATAR01 add constraint PK_DATA_R01 unique (QB_TIMESTAMP, QB_SOURCE, QB_METRIC_NAME)
INFO >>> 2024-01-15 09:10:51,322 DEBUG Executing sql: create index IDX_TIMESTAMP_R01 on QB_MEASUREMENT_DATAR01 (QB_TIMESTAMP)
INFO >>> 2024-01-15 09:10:51,341 DEBUG Executing sql: create index IDX_SOURCE_R01 on QB_MEASUREMENT_DATAR01 (QB_SOURCE)
INFO >>> 2024-01-15 09:10:51,361 DEBUG Executing sql: create index IDX_METRIC_NAME_R01 on QB_MEASUREMENT_DATAR01 (QB_METRIC_NAME)
INFO >>> 2024-01-15 09:10:51,383 DEBUG Executing sql: alter table QB_MEASUREMENT_DATAR02 add constraint PK_DATA_R02 unique (QB_TIMESTAMP, QB_SOURCE, QB_METRIC_NAME)
INFO >>> 2024-01-15 09:10:51,402 DEBUG Executing sql: create index IDX_TIMESTAMP_R02 on QB_MEASUREMENT_DATAR02 (QB_TIMESTAMP)
INFO >>> 2024-01-15 09:10:51,420 DEBUG Executing sql: create index IDX_SOURCE_R02 on QB_MEASUREMENT_DATAR02 (QB_SOURCE)
INFO >>> 2024-01-15 09:10:51,441 DEBUG Executing sql: create index IDX_METRIC_NAME_R02 on QB_MEASUREMENT_DATAR02 (QB_METRIC_NAME)
INFO >>> 2024-01-15 09:10:51,461 DEBUG Executing sql: alter table QB_MEASUREMENT_DATAR03 add constraint PK_DATA_R03 unique (QB_TIMESTAMP, QB_SOURCE, QB_METRIC_NAME)
INFO >>> 2024-01-15 09:10:51,480 DEBUG Executing sql: create index IDX_TIMESTAMP_R03 on QB_MEASUREMENT_DATAR03 (QB_TIMESTAMP)
INFO >>> 2024-01-15 09:10:51,499 DEBUG Executing sql: create index IDX_SOURCE_R03 on QB_MEASUREMENT_DATAR03 (QB_SOURCE)
INFO >>> 2024-01-15 09:10:51,519 DEBUG Executing sql: create index IDX_METRIC_NAME_R03 on QB_MEASUREMENT_DATAR03 (QB_METRIC_NAME)
INFO >>> 2024-01-15 09:10:51,541 DEBUG Executing sql: alter table QB_MEASUREMENT_DATAR04 add constraint PK_DATA_R04 unique (QB_TIMESTAMP, QB_SOURCE, QB_METRIC_NAME)
INFO >>> 2024-01-15 09:10:51,560 DEBUG Executing sql: create index IDX_TIMESTAMP_R04 on QB_MEASUREMENT_DATAR04 (QB_TIMESTAMP)
INFO >>> 2024-01-15 09:10:51,578 DEBUG Executing sql: create index IDX_SOURCE_R04 on QB_MEASUREMENT_DATAR04 (QB_SOURCE)
INFO >>> 2024-01-15 09:10:51,599 DEBUG Executing sql: create index IDX_METRIC_NAME_R04 on QB_MEASUREMENT_DATAR04 (QB_METRIC_NAME)
INFO >>> 2024-01-15 09:10:51,620 DEBUG Executing sql: alter table QB_MEMBERSHIP add constraint UK_sno51rkm9p2dacq0djfppmu2j unique (QB_USER_ID, QB_GROUP_ID)
INFO >>> 2024-01-15 09:10:51,641 DEBUG Executing sql: alter table QB_PERMISSION_SET add constraint UK_b4j6gy9p60vqva8yw3ly5x92t unique (QB_NAME)
INFO >>> 2024-01-15 09:10:51,663 DEBUG Executing sql: alter table QB_PLUGIN_CONFIG add constraint UK_n9p1ai2370kgl0aff0oaicmyc unique (QB_PLUGIN_ID)
INFO >>> 2024-01-15 09:10:51,690 DEBUG Executing sql: alter table QB_PROMOTE_OPTION add constraint UK_k3yeeyftwc0sd3682vm05u7jb unique (QB_USER_ID, QB_CONFIGURATION_ID, QB_NAME)
INFO >>> 2024-01-15 09:10:51,711 DEBUG Executing sql: alter table QB_RESOURCE add constraint UK_103m61jxd6bak2debc3ro4hh4 unique (QB_NAME)
INFO >>> 2024-01-15 09:10:51,729 DEBUG Executing sql: alter table QB_RESOURCE_ACCESS add constraint UK_jid404bqsdo51b98uxl56xhx9 unique (QB_CONFIGURATION_ID, QB_RESOURCE_ID)
INFO >>> 2024-01-15 09:10:51,748 DEBUG Executing sql: create index IDX_RU_DURA on QB_RESOURCE_ACCESS (QB_DURATION)
INFO >>> 2024-01-15 09:10:51,769 DEBUG Executing sql: create index IDX_RU_WHEN on QB_RESOURCE_ACCESS (QB_WHEN)
INFO >>> 2024-01-15 09:10:51,788 DEBUG Executing sql: alter table QB_TOKEN add constraint UK_nasqhwlkbyycoq7arl0jxgo2y unique (QB_VALUE)
INFO >>> 2024-01-15 09:10:51,809 DEBUG Executing sql: alter table QB_TRIGGER_DEPENDENCE add constraint UK_aat2tko654y9hcj95ii7lkxko unique (QB_DEPENDENT_ID, QB_DEPENDENCY_ID)
INFO >>> 2024-01-15 09:10:51,827 DEBUG Executing sql: alter table QB_USER add constraint UK_olcwj9kpm4d1a768jv1g4yhwe unique (QB_NAME)
INFO >>> 2024-01-15 09:10:51,846 DEBUG Executing sql: alter table QB_USER_SHARE add constraint UK_87lllhay0y860hys51ni3oeam unique (QB_USER_ID, QB_DASHBOARD_ID)
INFO >>> 2024-01-15 09:10:51,875 DEBUG Executing sql: alter table QB_ALARM add constraint FK_ALARM_USER foreign key (QB_USER_ID) references QB_USER (QB_ID)
INFO >>> 2024-01-15 09:10:51,936 DEBUG Executing sql: alter table QB_ALERT add constraint FK_ALERT_FIXED_BY foreign key (QB_FIXED_BY_ID) references QB_USER (QB_ID)
INFO >>> 2024-01-15 09:10:52,047 DEBUG Executing sql: alter table QB_AUDIT add constraint FK_AUDIT_CONF foreign key (QB_CONFIGURATION_ID) references QB_CONFIGURATION (QB_ID)
INFO >>> 2024-01-15 09:10:52,143 DEBUG Executing sql: alter table QB_AUTHORIZATION add constraint FK_AUTH_CONFIG foreign key (QB_CONFIGURATION_ID) references QB_CONFIGURATION (QB_ID)
INFO >>> 2024-01-15 09:10:52,217 DEBUG Executing sql: alter table QB_AUTHORIZATION add constraint FK_AUTH_GROUP foreign key (QB_GROUP_ID) references QB_GROUP (QB_ID)
INFO >>> 2024-01-15 09:10:52,287 DEBUG Executing sql: alter table QB_BUILD add constraint FK_BLD_CANCELLER foreign key (QB_CANCELLER_ID) references QB_USER (QB_ID)
INFO >>> 2024-01-15 09:10:52,397 DEBUG Executing sql: alter table QB_BUILD add constraint FK_BLD_CONF foreign key (QB_CONFIGURATION_ID) references QB_CONFIGURATION (QB_ID)
INFO >>> 2024-01-15 09:10:52,527 DEBUG Executing sql: alter table QB_BUILD add constraint FK_BLD_PROMO_FR foreign key (QB_PROMOTED_FROM_ID) references QB_BUILD (QB_ID)
INFO >>> 2024-01-15 09:10:52,670 DEBUG Executing sql: alter table QB_BUILD add constraint FK_BLD_REQUESTER foreign key (QB_REQUESTER_ID) references QB_USER (QB_ID)
INFO >>> 2024-01-15 09:10:52,798 DEBUG Executing sql: alter table QB_BUILD_DEPENDENCE add constraint FK_BLD_DEPDENCY foreign key (QB_DEPENDENCY_ID) references QB_BUILD (QB_ID)
INFO >>> 2024-01-15 09:10:52,864 DEBUG Executing sql: alter table QB_BUILD_DEPENDENCE add constraint FK_BLD_DEPDENT foreign key (QB_DEPENDENT_ID) references QB_BUILD (QB_ID)
INFO >>> 2024-01-15 09:10:52,933 DEBUG Executing sql: alter table QB_BUILD_OPTION add constraint FK_BLDOPT_CONF foreign key (QB_CONFIGURATION_ID) references QB_CONFIGURATION (QB_ID)
INFO >>> 2024-01-15 09:10:53,008 DEBUG Executing sql: alter table QB_BUILD_OPTION add constraint FK_BLDOPT_USER foreign key (QB_USER_ID) references QB_USER (QB_ID)
INFO >>> 2024-01-15 09:10:53,119 DEBUG Executing sql: alter table QB_CONFIGURATION add constraint FK_CONF_PARENT foreign key (QB_PARENT_ID) references QB_CONFIGURATION (QB_ID)
INFO >>> 2024-01-15 09:10:53,229 DEBUG Executing sql: alter table QB_DASHBOARD add constraint FK_DASH_USER foreign key (QB_USER_ID) references QB_USER (QB_ID)
INFO >>> 2024-01-15 09:10:53,314 DEBUG Executing sql: alter table QB_DISCUSSION add constraint FK_AUTHOR_DISCUSSION foreign key (QB_AUTHOR_ID) references QB_USER (QB_ID)
INFO >>> 2024-01-15 09:10:53,393 DEBUG Executing sql: alter table QB_DISCUSSION add constraint FK_BLD_DISCUSSION foreign key (QB_BUILD_ID) references QB_BUILD (QB_ID)
INFO >>> 2024-01-15 09:10:53,480 DEBUG Executing sql: alter table QB_DISCUSSION add constraint FK_CFG_DISCUSSION foreign key (QB_CONFIGURATION_ID) references QB_CONFIGURATION (QB_ID)
INFO >>> 2024-01-15 09:10:53,568 DEBUG Executing sql: alter table QB_DISCUSSION add constraint FK_R_DISCUSSION foreign key (QB_REPLY_TO_ID) references QB_DISCUSSION (QB_ID)
INFO >>> 2024-01-15 09:10:53,666 DEBUG Executing sql: alter table QB_FAVORITE add constraint FK_FAVO_CONF foreign key (QB_CONFIGURATION_ID) references QB_CONFIGURATION (QB_ID)
INFO >>> 2024-01-15 09:10:53,738 DEBUG Executing sql: alter table QB_FAVORITE add constraint FK_FAVO_USER foreign key (QB_USER_ID) references QB_USER (QB_ID)
INFO >>> 2024-01-15 09:10:53,805 DEBUG Executing sql: alter table QB_GROUP_SHARE add constraint FK_G_SHARE_DASH foreign key (QB_DASHBOARD_ID) references QB_DASHBOARD (QB_ID)
INFO >>> 2024-01-15 09:10:53,877 DEBUG Executing sql: alter table QB_GROUP_SHARE add constraint FK_SHARE_GROUP foreign key (QB_GROUP_ID) references QB_GROUP (QB_ID)
INFO >>> 2024-01-15 09:10:53,946 DEBUG Executing sql: alter table QB_MEMBERSHIP add constraint FK_MEM_GROUP foreign key (QB_GROUP_ID) references QB_GROUP (QB_ID)
INFO >>> 2024-01-15 09:10:54,067 DEBUG Executing sql: alter table QB_MEMBERSHIP add constraint FK_MEM_USER foreign key (QB_USER_ID) references QB_USER (QB_ID)
INFO >>> 2024-01-15 09:10:54,145 DEBUG Executing sql: alter table QB_PROMOTE_OPTION add constraint FK_PROMOOPT_CONF foreign key (QB_CONFIGURATION_ID) references QB_CONFIGURATION (QB_ID)
INFO >>> 2024-01-15 09:10:54,230 DEBUG Executing sql: alter table QB_PROMOTE_OPTION add constraint FK_PROMOOPT_USR foreign key (QB_USER_ID) references QB_USER (QB_ID)
INFO >>> 2024-01-15 09:10:54,304 DEBUG Executing sql: alter table QB_RESOURCE_ACCESS add constraint FK_RA_CONF foreign key (QB_CONFIGURATION_ID) references QB_CONFIGURATION (QB_ID)
INFO >>> 2024-01-15 09:10:54,382 DEBUG Executing sql: alter table QB_RESOURCE_ACCESS add constraint FK_RA_RES foreign key (QB_RESOURCE_ID) references QB_RESOURCE (QB_ID)
INFO >>> 2024-01-15 09:10:54,458 DEBUG Executing sql: alter table QB_SUBSCRIPTION add constraint FK_SUBSCRI_CONF foreign key (QB_CONFIGURATION_ID) references QB_CONFIGURATION (QB_ID)
INFO >>> 2024-01-15 09:10:54,532 DEBUG Executing sql: alter table QB_SUBSCRIPTION add constraint FK_SUBSCRI_USER foreign key (QB_USER_ID) references QB_USER (QB_ID)
INFO >>> 2024-01-15 09:10:54,604 DEBUG Executing sql: alter table QB_TOKEN add constraint FK_TOKEN_PROFILE foreign key (QB_CLOUD_PROFILE_ID) references QB_CLOUD_PROFILE (QB_ID)
INFO >>> 2024-01-15 09:10:54,678 DEBUG Executing sql: alter table QB_TRIGGER_DEPENDENCE add constraint FK_TRIG_DEPDENCY foreign key (QB_DEPENDENCY_ID) references QB_CONFIGURATION (QB_ID)
INFO >>> 2024-01-15 09:10:54,750 DEBUG Executing sql: alter table QB_TRIGGER_DEPENDENCE add constraint FK_TRIG_DEPDENT foreign key (QB_DEPENDENT_ID) references QB_CONFIGURATION (QB_ID)
INFO >>> 2024-01-15 09:10:54,819 DEBUG Executing sql: alter table QB_USER_SHARE add constraint FK_U_SHARE_DASH foreign key (QB_DASHBOARD_ID) references QB_DASHBOARD (QB_ID)
INFO >>> 2024-01-15 09:10:54,900 DEBUG Executing sql: alter table QB_USER_SHARE add constraint FK_SHARE_USER foreign key (QB_USER_ID) references QB_USER (QB_ID)
INFO >>> 2024-01-15 09:10:54,967 DEBUG Executing sql: ALTER TABLE QB_CONFIGURATION ROW_FORMAT = COMPRESSED;
INFO >>> 2024-01-15 09:10:55,000 INFO Stopping QuickBuild server...
INFO >>> 2024-01-15 09:10:55,016 INFO Stopping plugins...
INFO >>> 2024-01-15 09:10:55,020 INFO Stopping task scheduler...
INFO >>> 2024-01-15 09:10:55,035 INFO QuickBuild server stopped.
ERROR >>> Exception in thread "main" java.lang.ExceptionInInitializerError
ERROR >>> at com.pmease.quickbuild.Quickbuild.importData(Quickbuild.java:1166)
ERROR >>> at com.pmease.quickbuild.bootstrap.Bootstrap$6.execute(Bootstrap.java:201)
ERROR >>> at com.pmease.quickbuild.Quickbuild$3.run(Quickbuild.java:872)
ERROR >>> at java.base/java.lang.Thread.run(Thread.java:829)
ERROR >>> Caused by: com.google.inject.ProvisionException: Guice provision errors:
ERROR >>>
ERROR >>> 1) Error in custom provider, java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
ERROR >>> while locating com.pmease.quickbuild.persistence.SessionFactoryProvider
ERROR >>> at com.pmease.quickbuild.QuickbuildModule.configure(QuickbuildModule.java:36)
ERROR >>> while locating org.hibernate.SessionFactory
ERROR >>> for field at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager.sessionFactory(DefaultDataManager.java:137)
ERROR >>> at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager.class(DefaultDataManager.java:137)
ERROR >>> while locating com.pmease.quickbuild.entitymanager.impl.DefaultDataManager
ERROR >>> while locating com.pmease.quickbuild.entitymanager.DataManager
ERROR >>>
ERROR >>> 1 error
ERROR >>> at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:987)
ERROR >>> at com.google.inject.internal.InjectorImpl.getInstance(InjectorImpl.java:1013)
ERROR >>> at com.pmease.quickbuild.Quickbuild.getInstance(Quickbuild.java:1061)
ERROR >>> at com.pmease.quickbuild.entitymanager.DataManager.<clinit>(DataManager.java:67)
ERROR >>> ... 4 more
ERROR >>> Caused by: java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
ERROR >>> at com.pmease.quickbuild.util.DbUtils.execute(DbUtils.java:122)
ERROR >>> at com.pmease.quickbuild.persistence.SessionFactoryProvider.get(SessionFactoryProvider.java:99)
ERROR >>> at com.pmease.quickbuild.persistence.SessionFactoryProvider.get(SessionFactoryProvider.java:36)
ERROR >>> at com.google.inject.internal.BoundProviderFactory.get(BoundProviderFactory.java:55)
ERROR >>> at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:46)
ERROR >>> at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1031)
ERROR >>> at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40)
ERROR >>> at com.google.inject.Scopes$1$1.get(Scopes.java:65)
ERROR >>> at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:40)
ERROR >>> at com.google.inject.internal.SingleFieldInjector.inject(SingleFieldInjector.java:53)
ERROR >>> at com.google.inject.internal.MembersInjectorImpl.injectMembers(MembersInjectorImpl.java:110)
ERROR >>> at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:94)
ERROR >>> at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:254)
ERROR >>> at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:46)
ERROR >>> at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1031)
ERROR >>> at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40)
ERROR >>> at com.google.inject.Scopes$1$1.get(Scopes.java:65)
ERROR >>> at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:40)
ERROR >>> at com.google.inject.internal.InjectorImpl$3.get(InjectorImpl.java:737)
ERROR >>> at com.google.inject.internal.InjectorImpl$4$1.call(InjectorImpl.java:978)
ERROR >>> at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1024)
ERROR >>> at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:974)
ERROR >>> ... 7 more
ERROR >>> Caused by: java.sql.SQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
ERROR >>> at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
ERROR >>> at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
ERROR >>> at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763)
ERROR >>> at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
ERROR >>> at com.pmease.quickbuild.util.DbUtils.execute(DbUtils.java:119)
ERROR >>> ... 28 more
ERROR Failed to upgrade /etc/quickbuild-8.0.20
INFO Now restoring old installation directory due to upgrade failure...
INFO Old installation directory is now restored.
WARN The database might be in an inconsistent state due to upgrade failure. In that case, you need to restore the database by first cleaning it, and then running below command:
INFO /etc/quickbuild-8.0.20/bin/restore.sh /etc/quickbuild-8.0.20/dbbackup~2024-01-15_08-51-37.zip

Robin Shen [15/Jan/24 10:58 AM]
Please upgrade to 14.0.3 from QB13 directly.

Alexey Kuznetsov [15/Jan/24 01:09 PM]
I've got the same issue on 14.0.3 update:

INFO >>> 2024-01-15 13:02:33,187 INFO Booting QuickBuild from '/etc/quickbuild-8.0.20'...
INFO >>> 2024-01-15 13:02:33,187 INFO Starting framework...
INFO >>> 2024-01-15 13:02:33,237 INFO Caching plugin libraries...
INFO >>> 2024-01-15 13:02:35,396 INFO Starting QuickBuild server...
INFO >>> 2024-01-15 13:02:37,352 DEBUG Executing sql: create table QB_ALARM (QB_ID bigint not null, QB_NOTIFIER varchar(255) not null, QB_USER_ID bigint not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,379 DEBUG Executing sql: create table QB_ALERT (QB_ID bigint not null, QB_ACK_MESSAGE longtext, QB_ACK_TIME bigint, QB_ALERT_MESSAGE longtext, QB_CATEGORY integer not null, QB_CTIME bigint, QB_FIXED bit, QB_FIXED_AT datetime, QB_PRIORITY varchar(255) not null, QB_SUBJECT varchar(255) not null, QB_TRIGGER varchar(255) not null, QB_FIXED_BY_ID bigint, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,407 DEBUG Executing sql: create table QB_AUDIT (QB_ID bigint not null, QB_ACTION varchar(4000) not null, QB_CONTENT longtext, QB_PREVIOUS_CONTENT longtext, QB_TIMESTAMP datetime not null, QB_USER varchar(255) not null, QB_CONFIGURATION_ID bigint, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,431 DEBUG Executing sql: create table QB_AUTHORIZATION (QB_ID bigint not null, QB_PERMISSIONS longblob, QB_CONFIGURATION_ID bigint not null, QB_GROUP_ID bigint not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,455 DEBUG Executing sql: create table QB_BUILD (QB_ID bigint not null, QB_BEGIN_DATE datetime not null, QB_DESCRIPTION longtext, QB_DURATION bigint, QB_ERROR_MESSAGE longtext, QB_GLOBAL_RESOURCE_NAMES longblob, QB_MASTER_NODE_ADDRESS varchar(255), QB_REPOSITORY_RUNTIMES longblob not null, QB_SCHEDULED bit not null, bld_sec_var_vals longblob not null, QB_SHORT_BRANCH varchar(255), QB_SHORT_BRANCH_REPO varchar(255), QB_STATUS integer not null, QB_STATUS_DATE datetime not null, QB_STEP_RUNTIMES longblob not null, QB_VERSION varchar(255) not null, QB_WAIT_DURATION bigint, QB_CANCELLER_ID bigint, QB_CONFIGURATION_ID bigint not null, QB_PROMOTED_FROM_ID bigint, QB_REQUESTER_ID bigint, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,483 DEBUG Executing sql: create table QB_BUILD_DEPENDENCE (QB_ID bigint not null, QB_DEPENDENCY_ID bigint not null, QB_DEPENDENT_ID bigint not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,507 DEBUG Executing sql: create table QB_BUILD_OPTION (QB_ID bigint not null, QB_VARIABLES longblob, QB_CONFIGURATION_ID bigint not null, QB_USER_ID bigint not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,530 DEBUG Executing sql: create table QB_CLOUD_PROFILE (QB_ID bigint not null, QB_DESCRIPTION varchar(1024), QB_IDLE_TIME_TO_TERMINATE integer not null, QB_MAX_NODES_TO_LAUNCH integer not null, QB_NAME varchar(255) not null, QB_NODE_LAUNCHERDOM longblob, QB_PROFILE_ATTRIBUTES longblob not null, QB_RETRY_PERIOD integer not null, QB_TEST_INFO longblob, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,556 DEBUG Executing sql: create table QB_CONFIGURATION (QB_ID bigint not null, qb_access_deny_msg longtext, QB_ACTIVE_REPOSITORY varchar(255), QB_AGGREGATIONDOMS longblob not null, QB_ARTIFACT_CLEANUP_STRATEGY longblob, QB_ARTIFACT_STORAGEDOM longblob, qb_audit_request bit, qb_conf_bd_script longtext, QB_BUILD_CLEANUP_STRATEGY longblob, QB_BUILD_CONDITION longblob, QB_CHECK_CONDITION_TIMEOUT longtext, qb_cmd_pre_kill longtext, QB_CONCURRENT bit, qb_custom_col_conf longblob, QB_DATA longblob not null, QB_DESCRIPTION longtext, QB_DISABLED bit, qb_conf_err_notify longtext, QB_ERROR_MESSAGE varchar(2048), QB_FORCE_KILL_TIMEOUT longtext, QB_GLOBAL_RESOURCE_REQUIREMENT longblob, QB_LEGACY_CMD_MODE bit, QB_LOG_LEVEL longblob, QB_NAME varchar(255) not null, QB_NODE_ASSIGNMENT longblob, QB_NOTIFICATIONS longblob not null, qb_bld_del_script longtext, qb_conf_del_script longtext, QB_ORDER integer not null, qb_pause_notify bit, qb_pipeline_name varchar(255), QB_PLUGIN_SETTINGDOMS longblob not null, QB_POST_BUILD_SCRIPT longtext, post_rec_script longtext, post_unrec_script longtext, QB_PRE_BUILD_SCRIPT longtext, QB_PRE_QUEUE_SCRIPT longtext, QB_PRIORITY longtext, QB_PROMOTIONS longblob not null, qb_queue_changed bit, QB_RECORDSCMCHANGES bit, QB_REPOSITORYDOMS longblob not null, QB_SCHEDULE longblob, QB_SHORT_BRANCHES longblob, qb_show_pipe_conf bit, qb_para_vertical bit, QB_SNAPSHOT_TAKING longblob, QB_STATUS_DATE datetime not null, QB_STEPDOMS longblob not null, QB_STORAGE_SETTING longblob, QB_TIMEOUT longtext, QB_TRIGGER_DEPENDENTS bit, qb_validate_var bit, QB_VARIABLES longblob not null, QB_VERSION_MANAGERDOM longblob, QB_WORKSPACE_SETTING longblob, QB_PARENT_ID bigint, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,593 DEBUG Executing sql: create table QB_DASHBOARD (QB_ID bigint not null, QB_COLUMNS longblob, QB_DESCRIPTION varchar(2048), QB_NAME varchar(255) not null, QB_PRIMARY bit not null, QB_USER_ID bigint not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,624 DEBUG Executing sql: create table QB_DISCUSSION (QB_ID bigint not null, QB_CREATED_AT datetime not null, QB_HTML longtext not null, QB_MARKUP_TYPE integer not null, QB_NUMBER integer, QB_RAW longtext not null, QB_UPDATED_AT datetime not null, QB_AUTHOR_ID bigint not null, QB_BUILD_ID bigint not null, QB_CONFIGURATION_ID bigint not null, QB_REPLY_TO_ID bigint, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,649 DEBUG Executing sql: create table QB_FAVORITE (QB_ID bigint not null, QB_CONFIGURATION_ID bigint not null, QB_USER_ID bigint not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,675 DEBUG Executing sql: create table QB_GROUP (QB_ID bigint not null, QB_ADMIN bit not null, QB_AGENT_ALLOWED bit not null, qb_download_agent bit, qb_edit_node_attr bit, qb_manage_bld_grid bit, QB_DESCRIPTION varchar(1024), QB_ENFORCE2FA bit not null, QB_EXPAND_ALL_ALLOWED bit not null, QB_FORCE_HTTPS bit not null, QB_GRID_ACCESS_ALLOWED bit not null, QB_NAME varchar(255) not null, qb_node_attr_allow bit, QB_PLUGIN_SETTINGDOMS longblob not null, QB_QUEUE_ACCESS_ALLOWED bit not null, QB_RESOLVE_ALERTS_ALLOWED bit not null, QB_REST_ACCESS_ALLOWED bit not null, QB_SCRIPT_ALLOWED bit not null, qb_share_dashboard bit, QB_SYSTEM_LOG_ALLOWED bit not null, QB_VIEW_ALERTS_ALLOWED bit not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,702 DEBUG Executing sql: create table QB_GROUP_SHARE (QB_ID bigint not null, QB_DASHBOARD_ID bigint not null, QB_GROUP_ID bigint, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,726 DEBUG Executing sql: create table QB_ID (QB_ID bigint not null, QB_NAME varchar(255) not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,750 DEBUG Executing sql: create table QB_MEASUREMENT_DATA1D (QB_ID bigint not null, QB_MAX_VALUE double precision, QB_METRIC_NAME varchar(255) not null, QB_MIN_VALUE double precision, QB_SOURCE varchar(255) not null, QB_TIMESTAMP bigint, QB_VALUE double precision, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,775 DEBUG Executing sql: create table QB_MEASUREMENT_DATA1H (QB_ID bigint not null, QB_MAX_VALUE double precision, QB_METRIC_NAME varchar(255) not null, QB_MIN_VALUE double precision, QB_SOURCE varchar(255) not null, QB_TIMESTAMP bigint, QB_VALUE double precision, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,798 DEBUG Executing sql: create table QB_MEASUREMENT_DATA6H (QB_ID bigint not null, QB_MAX_VALUE double precision, QB_METRIC_NAME varchar(255) not null, QB_MIN_VALUE double precision, QB_SOURCE varchar(255) not null, QB_TIMESTAMP bigint, QB_VALUE double precision, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,822 DEBUG Executing sql: create table QB_MEASUREMENT_DATAR00 (QB_ID bigint not null, QB_METRIC_NAME varchar(255) not null, QB_SOURCE varchar(255) not null, QB_TIMESTAMP bigint, QB_VALUE double precision, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,846 DEBUG Executing sql: create table QB_MEASUREMENT_DATAR01 (QB_ID bigint not null, QB_METRIC_NAME varchar(255) not null, QB_SOURCE varchar(255) not null, QB_TIMESTAMP bigint, QB_VALUE double precision, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,871 DEBUG Executing sql: create table QB_MEASUREMENT_DATAR02 (QB_ID bigint not null, QB_METRIC_NAME varchar(255) not null, QB_SOURCE varchar(255) not null, QB_TIMESTAMP bigint, QB_VALUE double precision, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,894 DEBUG Executing sql: create table QB_MEASUREMENT_DATAR03 (QB_ID bigint not null, QB_METRIC_NAME varchar(255) not null, QB_SOURCE varchar(255) not null, QB_TIMESTAMP bigint, QB_VALUE double precision, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,918 DEBUG Executing sql: create table QB_MEASUREMENT_DATAR04 (QB_ID bigint not null, QB_METRIC_NAME varchar(255) not null, QB_SOURCE varchar(255) not null, QB_TIMESTAMP bigint, QB_VALUE double precision, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,944 DEBUG Executing sql: create table QB_MEMBERSHIP (QB_ID bigint not null, QB_ASSIGNED_LOCALLY bit not null, QB_GROUP_ID bigint not null, QB_USER_ID bigint not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,968 DEBUG Executing sql: create table QB_PERMISSION_SET (QB_ID bigint not null, QB_NAME varchar(255) not null, QB_PERMISSIONS longblob not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:37,991 DEBUG Executing sql: create table QB_PLUGIN_CONFIG (QB_ID bigint not null, QB_ENABLED bit not null, QB_PLUGIN_ID varchar(255), QB_SETTINGDOM longblob, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:38,083 DEBUG Executing sql: create table QB_PROMOTE_OPTION (QB_ID bigint not null, QB_ACTIVE bit not null, QB_NAME varchar(255) not null, QB_VARIABLES longblob, QB_CONFIGURATION_ID bigint not null, QB_USER_ID bigint not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:38,109 DEBUG Executing sql: create table QB_RESOURCE (QB_ID bigint not null, QB_DESCRIPTION varchar(2048), QB_NAME varchar(255) not null, QB_TYPE longblob not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:38,135 DEBUG Executing sql: create table QB_RESOURCE_ACCESS (QB_ID bigint not null, QB_DURATION bigint not null, QB_STEPS longblob not null, QB_WHEN datetime not null, QB_CONFIGURATION_ID bigint not null, QB_RESOURCE_ID bigint not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:38,161 DEBUG Executing sql: create table QB_SETTING (QB_ID bigint not null, QB_OBJECT longblob, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:38,185 DEBUG Executing sql: create table QB_SUBSCRIPTION (QB_ID bigint not null, QB_COMMIT_ONLY bit not null, QB_CONDITION integer not null, QB_NOTIFIER varchar(255) not null, QB_SUBSCRIBE_DESCENDENTS bit not null, QB_CONFIGURATION_ID bigint not null, QB_USER_ID bigint not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:38,209 DEBUG Executing sql: create table QB_TOKEN (QB_ID bigint not null, QB_HOST_NAME varchar(255) not null, QB_IP varchar(255), QB_LAST_USED_DATE datetime, QB_LAST_USED_REASON longtext, QB_NODE_LAUNCH_ID varchar(255), QB_OFFLINE_ALERT bit not null, QB_OFFLINE_NOTE varchar(255), QB_OVERSSL bit, QB_PORT integer not null, QB_TEST bit not null, QB_VALUE varchar(255) not null, QB_CLOUD_PROFILE_ID bigint, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:38,235 DEBUG Executing sql: create table QB_TRIGGER_DEPENDENCE (QB_ID bigint not null, QB_DEPENDENCY_ID bigint not null, QB_DEPENDENT_ID bigint not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:38,260 DEBUG Executing sql: create table QB_USER (QB_ID bigint not null, QB_ACCESS_TOKEN varchar(255) not null, QB_AUTHENTICATOR varchar(255), QB_EMAIL varchar(255), QB_FAVORITE_DASHBOARD_IDS longblob, QB_FULL_NAME varchar(255), QB_LAST_LOGIN datetime not null, QB_NAME varchar(255) not null, QB_PASSWORD varchar(255) not null, QB_PLUGIN_SETTINGDOMS longblob not null, QB_SEARCH_FOR integer, QB_TWO_FACTOR_AUTHENTICATION longblob, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:38,289 DEBUG Executing sql: create table QB_USER_SHARE (QB_ID bigint not null, QB_DASHBOARD_ID bigint not null, QB_USER_ID bigint not null, primary key (QB_ID)) ENGINE=InnoDB
INFO >>> 2024-01-15 13:02:38,315 DEBUG Executing sql: create index ALERT_CTIME on QB_ALERT (QB_CTIME)
INFO >>> 2024-01-15 13:02:38,337 DEBUG Executing sql: create index ALERT_TRIGGER on QB_ALERT (QB_TRIGGER)
INFO >>> 2024-01-15 13:02:38,361 DEBUG Executing sql: create index IDX_AUDIT_TIME on QB_AUDIT (QB_TIMESTAMP)
INFO >>> 2024-01-15 13:02:38,386 DEBUG Executing sql: create index IDX_AUDIT_USER on QB_AUDIT (QB_USER)
INFO >>> 2024-01-15 13:02:38,406 DEBUG Executing sql: alter table QB_AUTHORIZATION add constraint UK_mhpclqvpwnsd5r0j55u7wse1m unique (QB_CONFIGURATION_ID, QB_GROUP_ID)
INFO >>> 2024-01-15 13:02:38,425 DEBUG Executing sql: create index IDX_BLD_DATE on QB_BUILD (QB_BEGIN_DATE)
INFO >>> 2024-01-15 13:02:38,458 DEBUG Executing sql: create index IDX_BLD_DURATION on QB_BUILD (QB_DURATION)
INFO >>> 2024-01-15 13:02:38,480 DEBUG Executing sql: create index IDX_BLD_BRANCH on QB_BUILD (QB_SHORT_BRANCH)
INFO >>> 2024-01-15 13:02:38,505 DEBUG Executing sql: create index IDX_BLD_BR_REPO on QB_BUILD (QB_SHORT_BRANCH_REPO)
INFO >>> 2024-01-15 13:02:38,534 DEBUG Executing sql: create index IDX_BLD_STATUS on QB_BUILD (QB_STATUS)
INFO >>> 2024-01-15 13:02:38,561 DEBUG Executing sql: create index IDX_BLD_VERSION on QB_BUILD (QB_VERSION)
INFO >>> 2024-01-15 13:02:38,593 DEBUG Executing sql: create index UK_q762tyw11sfk0rnyv0moigl54 on QB_BUILD (QB_ID, QB_CONFIGURATION_ID)
INFO >>> 2024-01-15 13:02:38,622 DEBUG Executing sql: create index UK_9c1r7675hu1n3emnep638qi96 on QB_BUILD (QB_STATUS, QB_CONFIGURATION_ID)
INFO >>> 2024-01-15 13:02:38,650 DEBUG Executing sql: alter table QB_BUILD_DEPENDENCE add constraint UK_k86vplpii7ebddfyek69gr91d unique (QB_DEPENDENT_ID, QB_DEPENDENCY_ID)
INFO >>> 2024-01-15 13:02:38,670 DEBUG Executing sql: alter table QB_BUILD_OPTION add constraint UK_4kt0icrv81msq2t2bfswcmqb unique (QB_USER_ID, QB_CONFIGURATION_ID)
INFO >>> 2024-01-15 13:02:38,689 DEBUG Executing sql: alter table QB_CLOUD_PROFILE add constraint UK_og3rvlib691t0th507mgby22x unique (QB_NAME)
INFO >>> 2024-01-15 13:02:38,709 DEBUG Executing sql: alter table QB_CONFIGURATION add constraint UK_9kvrhab72gmiw3gqfphbgmedq unique (QB_PARENT_ID, QB_NAME)
INFO >>> 2024-01-15 13:02:38,742 DEBUG Executing sql: alter table QB_DASHBOARD add constraint UK_540gxxofu01arwvx1ousx77p2 unique (QB_USER_ID, QB_NAME)
INFO >>> 2024-01-15 13:02:38,761 DEBUG Executing sql: create index IDX_DISCUSSION_NUM on QB_DISCUSSION (QB_NUMBER)
INFO >>> 2024-01-15 13:02:38,787 DEBUG Executing sql: create index IDX_DISCUSSION_CD on QB_DISCUSSION (QB_CREATED_AT)
INFO >>> 2024-01-15 13:02:38,809 DEBUG Executing sql: create index IDX_DISCUSSION_UD on QB_DISCUSSION (QB_UPDATED_AT)
INFO >>> 2024-01-15 13:02:38,832 DEBUG Executing sql: alter table QB_FAVORITE add constraint UK_mcg8rxkslku1vxl2xumbekjyl unique (QB_USER_ID, QB_CONFIGURATION_ID)
INFO >>> 2024-01-15 13:02:38,850 DEBUG Executing sql: alter table QB_GROUP add constraint UK_sm296bowcb3gsq44o9hnmkf07 unique (QB_NAME)
INFO >>> 2024-01-15 13:02:38,882 DEBUG Executing sql: alter table QB_GROUP_SHARE add constraint UK_e5ut0jadkuj5l8gaa06nep5er unique (QB_GROUP_ID, QB_DASHBOARD_ID)
INFO >>> 2024-01-15 13:02:38,901 DEBUG Executing sql: alter table QB_ID add constraint UK_kxcav1xl5r0p4f44f6l0i0qv1 unique (QB_NAME)
INFO >>> 2024-01-15 13:02:38,919 DEBUG Executing sql: alter table QB_MEASUREMENT_DATA1D add constraint PK_DATA unique (QB_TIMESTAMP, QB_SOURCE, QB_METRIC_NAME)
INFO >>> 2024-01-15 13:02:38,940 DEBUG Executing sql: create index IDX_TIMESTAMP_1D on QB_MEASUREMENT_DATA1D (QB_TIMESTAMP)
INFO >>> 2024-01-15 13:02:38,958 DEBUG Executing sql: create index IDX_SOURCE_1D on QB_MEASUREMENT_DATA1D (QB_SOURCE)
INFO >>> 2024-01-15 13:02:38,982 DEBUG Executing sql: create index IDX_METRIC_NAME_1D on QB_MEASUREMENT_DATA1D (QB_METRIC_NAME)
INFO >>> 2024-01-15 13:02:39,010 DEBUG Executing sql: alter table QB_MEASUREMENT_DATA1H add constraint PK_DATA_1H unique (QB_TIMESTAMP, QB_SOURCE, QB_METRIC_NAME)
INFO >>> 2024-01-15 13:02:39,090 DEBUG Executing sql: create index IDX_TIMESTAMP_1H on QB_MEASUREMENT_DATA1H (QB_TIMESTAMP)
INFO >>> 2024-01-15 13:02:39,110 DEBUG Executing sql: create index IDX_SOURCE_1H on QB_MEASUREMENT_DATA1H (QB_SOURCE)
INFO >>> 2024-01-15 13:02:39,135 DEBUG Executing sql: create index IDX_METRIC_NAME_1H on QB_MEASUREMENT_DATA1H (QB_METRIC_NAME)
INFO >>> 2024-01-15 13:02:39,154 DEBUG Executing sql: alter table QB_MEASUREMENT_DATA6H add constraint PK_DATA_6H unique (QB_TIMESTAMP, QB_SOURCE, QB_METRIC_NAME)
INFO >>> 2024-01-15 13:02:39,178 DEBUG Executing sql: create index IDX_TIMESTAMP_6H on QB_MEASUREMENT_DATA6H (QB_TIMESTAMP)
INFO >>> 2024-01-15 13:02:39,199 DEBUG Executing sql: create index IDX_SOURCE_6H on QB_MEASUREMENT_DATA6H (QB_SOURCE)
INFO >>> 2024-01-15 13:02:39,221 DEBUG Executing sql: create index IDX_METRIC_NAME_6H on QB_MEASUREMENT_DATA6H (QB_METRIC_NAME)
INFO >>> 2024-01-15 13:02:39,244 DEBUG Executing sql: alter table QB_MEASUREMENT_DATAR00 add constraint PK_DATA_R00 unique (QB_TIMESTAMP, QB_SOURCE, QB_METRIC_NAME)
INFO >>> 2024-01-15 13:02:39,264 DEBUG Executing sql: create index IDX_TIMESTAMP_R00 on QB_MEASUREMENT_DATAR00 (QB_TIMESTAMP)
INFO >>> 2024-01-15 13:02:39,283 DEBUG Executing sql: create index IDX_SOURCE_R00 on QB_MEASUREMENT_DATAR00 (QB_SOURCE)
INFO >>> 2024-01-15 13:02:39,303 DEBUG Executing sql: create index IDX_METRIC_NAME_R00 on QB_MEASUREMENT_DATAR00 (QB_METRIC_NAME)
INFO >>> 2024-01-15 13:02:39,324 DEBUG Executing sql: alter table QB_MEASUREMENT_DATAR01 add constraint PK_DATA_R01 unique (QB_TIMESTAMP, QB_SOURCE, QB_METRIC_NAME)
INFO >>> 2024-01-15 13:02:39,343 DEBUG Executing sql: create index IDX_TIMESTAMP_R01 on QB_MEASUREMENT_DATAR01 (QB_TIMESTAMP)
INFO >>> 2024-01-15 13:02:39,364 DEBUG Executing sql: create index IDX_SOURCE_R01 on QB_MEASUREMENT_DATAR01 (QB_SOURCE)
INFO >>> 2024-01-15 13:02:39,385 DEBUG Executing sql: create index IDX_METRIC_NAME_R01 on QB_MEASUREMENT_DATAR01 (QB_METRIC_NAME)
INFO >>> 2024-01-15 13:02:39,408 DEBUG Executing sql: alter table QB_MEASUREMENT_DATAR02 add constraint PK_DATA_R02 unique (QB_TIMESTAMP, QB_SOURCE, QB_METRIC_NAME)
INFO >>> 2024-01-15 13:02:39,431 DEBUG Executing sql: create index IDX_TIMESTAMP_R02 on QB_MEASUREMENT_DATAR02 (QB_TIMESTAMP)
INFO >>> 2024-01-15 13:02:39,453 DEBUG Executing sql: create index IDX_SOURCE_R02 on QB_MEASUREMENT_DATAR02 (QB_SOURCE)
INFO >>> 2024-01-15 13:02:39,473 DEBUG Executing sql: create index IDX_METRIC_NAME_R02 on QB_MEASUREMENT_DATAR02 (QB_METRIC_NAME)
INFO >>> 2024-01-15 13:02:39,493 DEBUG Executing sql: alter table QB_MEASUREMENT_DATAR03 add constraint PK_DATA_R03 unique (QB_TIMESTAMP, QB_SOURCE, QB_METRIC_NAME)
INFO >>> 2024-01-15 13:02:39,514 DEBUG Executing sql: create index IDX_TIMESTAMP_R03 on QB_MEASUREMENT_DATAR03 (QB_TIMESTAMP)
INFO >>> 2024-01-15 13:02:39,534 DEBUG Executing sql: create index IDX_SOURCE_R03 on QB_MEASUREMENT_DATAR03 (QB_SOURCE)
INFO >>> 2024-01-15 13:02:39,553 DEBUG Executing sql: create index IDX_METRIC_NAME_R03 on QB_MEASUREMENT_DATAR03 (QB_METRIC_NAME)
INFO >>> 2024-01-15 13:02:39,576 DEBUG Executing sql: alter table QB_MEASUREMENT_DATAR04 add constraint PK_DATA_R04 unique (QB_TIMESTAMP, QB_SOURCE, QB_METRIC_NAME)
INFO >>> 2024-01-15 13:02:39,596 DEBUG Executing sql: create index IDX_TIMESTAMP_R04 on QB_MEASUREMENT_DATAR04 (QB_TIMESTAMP)
INFO >>> 2024-01-15 13:02:39,623 DEBUG Executing sql: create index IDX_SOURCE_R04 on QB_MEASUREMENT_DATAR04 (QB_SOURCE)
INFO >>> 2024-01-15 13:02:39,643 DEBUG Executing sql: create index IDX_METRIC_NAME_R04 on QB_MEASUREMENT_DATAR04 (QB_METRIC_NAME)
INFO >>> 2024-01-15 13:02:39,661 DEBUG Executing sql: alter table QB_MEMBERSHIP add constraint UK_sno51rkm9p2dacq0djfppmu2j unique (QB_USER_ID, QB_GROUP_ID)
INFO >>> 2024-01-15 13:02:39,682 DEBUG Executing sql: alter table QB_PERMISSION_SET add constraint UK_b4j6gy9p60vqva8yw3ly5x92t unique (QB_NAME)
INFO >>> 2024-01-15 13:02:39,702 DEBUG Executing sql: alter table QB_PLUGIN_CONFIG add constraint UK_n9p1ai2370kgl0aff0oaicmyc unique (QB_PLUGIN_ID)
INFO >>> 2024-01-15 13:02:39,720 DEBUG Executing sql: alter table QB_PROMOTE_OPTION add constraint UK_k3yeeyftwc0sd3682vm05u7jb unique (QB_USER_ID, QB_CONFIGURATION_ID, QB_NAME)
INFO >>> 2024-01-15 13:02:39,738 DEBUG Executing sql: alter table QB_RESOURCE add constraint UK_103m61jxd6bak2debc3ro4hh4 unique (QB_NAME)
INFO >>> 2024-01-15 13:02:39,754 DEBUG Executing sql: alter table QB_RESOURCE_ACCESS add constraint UK_jid404bqsdo51b98uxl56xhx9 unique (QB_CONFIGURATION_ID, QB_RESOURCE_ID)
INFO >>> 2024-01-15 13:02:39,773 DEBUG Executing sql: create index IDX_RU_DURA on QB_RESOURCE_ACCESS (QB_DURATION)
INFO >>> 2024-01-15 13:02:39,794 DEBUG Executing sql: create index IDX_RU_WHEN on QB_RESOURCE_ACCESS (QB_WHEN)
INFO >>> 2024-01-15 13:02:39,813 DEBUG Executing sql: alter table QB_TOKEN add constraint UK_nasqhwlkbyycoq7arl0jxgo2y unique (QB_VALUE)
INFO >>> 2024-01-15 13:02:39,834 DEBUG Executing sql: alter table QB_TRIGGER_DEPENDENCE add constraint UK_aat2tko654y9hcj95ii7lkxko unique (QB_DEPENDENT_ID, QB_DEPENDENCY_ID)
INFO >>> 2024-01-15 13:02:39,851 DEBUG Executing sql: alter table QB_USER add constraint UK_olcwj9kpm4d1a768jv1g4yhwe unique (QB_NAME)
INFO >>> 2024-01-15 13:02:39,874 DEBUG Executing sql: alter table QB_USER_SHARE add constraint UK_87lllhay0y860hys51ni3oeam unique (QB_USER_ID, QB_DASHBOARD_ID)
INFO >>> 2024-01-15 13:02:39,896 DEBUG Executing sql: alter table QB_ALARM add constraint FK_ALARM_USER foreign key (QB_USER_ID) references QB_USER (QB_ID)
INFO >>> 2024-01-15 13:02:39,959 DEBUG Executing sql: alter table QB_ALERT add constraint FK_ALERT_FIXED_BY foreign key (QB_FIXED_BY_ID) references QB_USER (QB_ID)
INFO >>> 2024-01-15 13:02:40,079 DEBUG Executing sql: alter table QB_AUDIT add constraint FK_AUDIT_CONF foreign key (QB_CONFIGURATION_ID) references QB_CONFIGURATION (QB_ID)
INFO >>> 2024-01-15 13:02:40,162 DEBUG Executing sql: alter table QB_AUTHORIZATION add constraint FK_AUTH_CONFIG foreign key (QB_CONFIGURATION_ID) references QB_CONFIGURATION (QB_ID)
INFO >>> 2024-01-15 13:02:40,241 DEBUG Executing sql: alter table QB_AUTHORIZATION add constraint FK_AUTH_GROUP foreign key (QB_GROUP_ID) references QB_GROUP (QB_ID)
INFO >>> 2024-01-15 13:02:40,313 DEBUG Executing sql: alter table QB_BUILD add constraint FK_BLD_CANCELLER foreign key (QB_CANCELLER_ID) references QB_USER (QB_ID)
INFO >>> 2024-01-15 13:02:40,426 DEBUG Executing sql: alter table QB_BUILD add constraint FK_BLD_CONF foreign key (QB_CONFIGURATION_ID) references QB_CONFIGURATION (QB_ID)
INFO >>> 2024-01-15 13:02:40,541 DEBUG Executing sql: alter table QB_BUILD add constraint FK_BLD_PROMO_FR foreign key (QB_PROMOTED_FROM_ID) references QB_BUILD (QB_ID)
INFO >>> 2024-01-15 13:02:40,673 DEBUG Executing sql: alter table QB_BUILD add constraint FK_BLD_REQUESTER foreign key (QB_REQUESTER_ID) references QB_USER (QB_ID)
INFO >>> 2024-01-15 13:02:40,798 DEBUG Executing sql: alter table QB_BUILD_DEPENDENCE add constraint FK_BLD_DEPDENCY foreign key (QB_DEPENDENCY_ID) references QB_BUILD (QB_ID)
INFO >>> 2024-01-15 13:02:40,875 DEBUG Executing sql: alter table QB_BUILD_DEPENDENCE add constraint FK_BLD_DEPDENT foreign key (QB_DEPENDENT_ID) references QB_BUILD (QB_ID)
INFO >>> 2024-01-15 13:02:40,947 DEBUG Executing sql: alter table QB_BUILD_OPTION add constraint FK_BLDOPT_CONF foreign key (QB_CONFIGURATION_ID) references QB_CONFIGURATION (QB_ID)
INFO >>> 2024-01-15 13:02:41,080 DEBUG Executing sql: alter table QB_BUILD_OPTION add constraint FK_BLDOPT_USER foreign key (QB_USER_ID) references QB_USER (QB_ID)
INFO >>> 2024-01-15 13:02:41,158 DEBUG Executing sql: alter table QB_CONFIGURATION add constraint FK_CONF_PARENT foreign key (QB_PARENT_ID) references QB_CONFIGURATION (QB_ID)
INFO >>> 2024-01-15 13:02:41,272 DEBUG Executing sql: alter table QB_DASHBOARD add constraint FK_DASH_USER foreign key (QB_USER_ID) references QB_USER (QB_ID)
INFO >>> 2024-01-15 13:02:41,340 DEBUG Executing sql: alter table QB_DISCUSSION add constraint FK_AUTHOR_DISCUSSION foreign key (QB_AUTHOR_ID) references QB_USER (QB_ID)
INFO >>> 2024-01-15 13:02:41,430 DEBUG Executing sql: alter table QB_DISCUSSION add constraint FK_BLD_DISCUSSION foreign key (QB_BUILD_ID) references QB_BUILD (QB_ID)
INFO >>> 2024-01-15 13:02:41,528 DEBUG Executing sql: alter table QB_DISCUSSION add constraint FK_CFG_DISCUSSION foreign key (QB_CONFIGURATION_ID) references QB_CONFIGURATION (QB_ID)
INFO >>> 2024-01-15 13:02:41,660 DEBUG Executing sql: alter table QB_DISCUSSION add constraint FK_R_DISCUSSION foreign key (QB_REPLY_TO_ID) references QB_DISCUSSION (QB_ID)
INFO >>> 2024-01-15 13:02:41,762 DEBUG Executing sql: alter table QB_FAVORITE add constraint FK_FAVO_CONF foreign key (QB_CONFIGURATION_ID) references QB_CONFIGURATION (QB_ID)
INFO >>> 2024-01-15 13:02:41,833 DEBUG Executing sql: alter table QB_FAVORITE add constraint FK_FAVO_USER foreign key (QB_USER_ID) references QB_USER (QB_ID)
INFO >>> 2024-01-15 13:02:41,907 DEBUG Executing sql: alter table QB_GROUP_SHARE add constraint FK_G_SHARE_DASH foreign key (QB_DASHBOARD_ID) references QB_DASHBOARD (QB_ID)
INFO >>> 2024-01-15 13:02:41,971 DEBUG Executing sql: alter table QB_GROUP_SHARE add constraint FK_SHARE_GROUP foreign key (QB_GROUP_ID) references QB_GROUP (QB_ID)
INFO >>> 2024-01-15 13:02:42,086 DEBUG Executing sql: alter table QB_MEMBERSHIP add constraint FK_MEM_GROUP foreign key (QB_GROUP_ID) references QB_GROUP (QB_ID)
INFO >>> 2024-01-15 13:02:42,164 DEBUG Executing sql: alter table QB_MEMBERSHIP add constraint FK_MEM_USER foreign key (QB_USER_ID) references QB_USER (QB_ID)
INFO >>> 2024-01-15 13:02:42,242 DEBUG Executing sql: alter table QB_PROMOTE_OPTION add constraint FK_PROMOOPT_CONF foreign key (QB_CONFIGURATION_ID) references QB_CONFIGURATION (QB_ID)
INFO >>> 2024-01-15 13:02:42,315 DEBUG Executing sql: alter table QB_PROMOTE_OPTION add constraint FK_PROMOOPT_USR foreign key (QB_USER_ID) references QB_USER (QB_ID)
INFO >>> 2024-01-15 13:02:42,385 DEBUG Executing sql: alter table QB_RESOURCE_ACCESS add constraint FK_RA_CONF foreign key (QB_CONFIGURATION_ID) references QB_CONFIGURATION (QB_ID)
INFO >>> 2024-01-15 13:02:42,464 DEBUG Executing sql: alter table QB_RESOURCE_ACCESS add constraint FK_RA_RES foreign key (QB_RESOURCE_ID) references QB_RESOURCE (QB_ID)
INFO >>> 2024-01-15 13:02:42,542 DEBUG Executing sql: alter table QB_SUBSCRIPTION add constraint FK_SUBSCRI_CONF foreign key (QB_CONFIGURATION_ID) references QB_CONFIGURATION (QB_ID)
INFO >>> 2024-01-15 13:02:42,623 DEBUG Executing sql: alter table QB_SUBSCRIPTION add constraint FK_SUBSCRI_USER foreign key (QB_USER_ID) references QB_USER (QB_ID)
INFO >>> 2024-01-15 13:02:42,695 DEBUG Executing sql: alter table QB_TOKEN add constraint FK_TOKEN_PROFILE foreign key (QB_CLOUD_PROFILE_ID) references QB_CLOUD_PROFILE (QB_ID)
INFO >>> 2024-01-15 13:02:42,766 DEBUG Executing sql: alter table QB_TRIGGER_DEPENDENCE add constraint FK_TRIG_DEPDENCY foreign key (QB_DEPENDENCY_ID) references QB_CONFIGURATION (QB_ID)
INFO >>> 2024-01-15 13:02:42,833 DEBUG Executing sql: alter table QB_TRIGGER_DEPENDENCE add constraint FK_TRIG_DEPDENT foreign key (QB_DEPENDENT_ID) references QB_CONFIGURATION (QB_ID)
INFO >>> 2024-01-15 13:02:42,909 DEBUG Executing sql: alter table QB_USER_SHARE add constraint FK_U_SHARE_DASH foreign key (QB_DASHBOARD_ID) references QB_DASHBOARD (QB_ID)
INFO >>> 2024-01-15 13:02:42,975 DEBUG Executing sql: alter table QB_USER_SHARE add constraint FK_SHARE_USER foreign key (QB_USER_ID) references QB_USER (QB_ID)
INFO >>> 2024-01-15 13:02:43,098 DEBUG Executing sql: ALTER TABLE QB_CONFIGURATION ROW_FORMAT = COMPRESSED;
INFO >>> 2024-01-15 13:02:43,133 INFO Stopping QuickBuild server...
INFO >>> 2024-01-15 13:02:43,147 INFO Stopping plugins...
INFO >>> 2024-01-15 13:02:43,150 INFO Stopping task scheduler...
INFO >>> 2024-01-15 13:02:43,165 INFO QuickBuild server stopped.
ERROR >>> Exception in thread "main" java.lang.ExceptionInInitializerError
ERROR >>> at com.pmease.quickbuild.Quickbuild.importData(Quickbuild.java:1166)
ERROR >>> at com.pmease.quickbuild.bootstrap.Bootstrap$6.execute(Bootstrap.java:201)
ERROR >>> at com.pmease.quickbuild.Quickbuild$3.run(Quickbuild.java:872)
ERROR >>> at java.base/java.lang.Thread.run(Thread.java:829)
ERROR >>> Caused by: com.google.inject.ProvisionException: Guice provision errors:
ERROR >>>
ERROR >>> 1) Error in custom provider, java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
ERROR >>> while locating com.pmease.quickbuild.persistence.SessionFactoryProvider
ERROR >>> at com.pmease.quickbuild.QuickbuildModule.configure(QuickbuildModule.java:36)
ERROR >>> while locating org.hibernate.SessionFactory
ERROR >>> for field at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager.sessionFactory(DefaultDataManager.java:137)
ERROR >>> at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager.class(DefaultDataManager.java:137)
ERROR >>> while locating com.pmease.quickbuild.entitymanager.impl.DefaultDataManager
ERROR >>> while locating com.pmease.quickbuild.entitymanager.DataManager
ERROR >>>
ERROR >>> 1 error
ERROR >>> at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:987)
ERROR >>> at com.google.inject.internal.InjectorImpl.getInstance(InjectorImpl.java:1013)
ERROR >>> at com.pmease.quickbuild.Quickbuild.getInstance(Quickbuild.java:1061)
ERROR >>> at com.pmease.quickbuild.entitymanager.DataManager.<clinit>(DataManager.java:67)
ERROR >>> ... 4 more
ERROR >>> Caused by: java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
ERROR >>> at com.pmease.quickbuild.util.DbUtils.execute(DbUtils.java:122)
ERROR >>> at com.pmease.quickbuild.persistence.SessionFactoryProvider.get(SessionFactoryProvider.java:99)
ERROR >>> at com.pmease.quickbuild.persistence.SessionFactoryProvider.get(SessionFactoryProvider.java:36)
ERROR >>> at com.google.inject.internal.BoundProviderFactory.get(BoundProviderFactory.java:55)
ERROR >>> at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:46)
ERROR >>> at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1031)
ERROR >>> at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40)
ERROR >>> at com.google.inject.Scopes$1$1.get(Scopes.java:65)
ERROR >>> at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:40)
ERROR >>> at com.google.inject.internal.SingleFieldInjector.inject(SingleFieldInjector.java:53)
ERROR >>> at com.google.inject.internal.MembersInjectorImpl.injectMembers(MembersInjectorImpl.java:110)
ERROR >>> at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:94)
ERROR >>> at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:254)
ERROR >>> at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:46)
ERROR >>> at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1031)
ERROR >>> at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40)
ERROR >>> at com.google.inject.Scopes$1$1.get(Scopes.java:65)
ERROR >>> at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:40)
ERROR >>> at com.google.inject.internal.InjectorImpl$3.get(InjectorImpl.java:737)
ERROR >>> at com.google.inject.internal.InjectorImpl$4$1.call(InjectorImpl.java:978)
ERROR >>> at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1024)
ERROR >>> at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:974)
ERROR >>> ... 7 more
ERROR >>> Caused by: java.sql.SQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
ERROR >>> at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
ERROR >>> at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
ERROR >>> at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763)
ERROR >>> at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
ERROR >>> at com.pmease.quickbuild.util.DbUtils.execute(DbUtils.java:119)
ERROR >>> ... 28 more
ERROR Failed to upgrade /etc/quickbuild-8.0.20
INFO Now restoring old installation directory due to upgrade failure...
INFO Old installation directory is now restored.
WARN The database might be in an inconsistent state due to upgrade failure. In that case, you need to restore the database by first cleaning it, and then running below command:
INFO /etc/quickbuild-8.0.20/bin/restore.sh /etc/quickbuild-8.0.20/dbbackup~2024-01-15_12-44-21.zip

Alexey Kuznetsov [16/Jan/24 04:28 PM]
I found the following:

When I upgraded QB from 13.0.37 to 14.0.1 my DB version was Aurora MySQL3.04.1 (compatible with MySQL 8.0.28).
And I had not an issue with upgrade.

But I got the bug https://track.pmease.com/browse/QB-4065 and, while reverting QB, restored DB from snapshot and set Aurora MySQL 3.05.1 (compatible with MySQL 8.0.32).
And now I get DB error if even upgrade QB from 13.0.37 to 14.0.1.

May be need to investigate in this direction?..
I.e., QB version changed and QB upgrade fails.

Alexey Kuznetsov [16/Jan/24 04:32 PM]
Sorry, there is the typo in my previous comment.
Should be: DB version changed and QB upgrade fails.

Alexey Kuznetsov [16/Jan/24 04:34 PM]
By the way, QB 13.0.37 works fine on Aurora MySQL 3.05.1

Alexey Kuznetsov [17/Jan/24 12:10 PM]
Verified on 14.0.4