Tags: bluebrey/xdmod
Tags
Second attempt to fix db timeouts. This time I tested by running the docker build with a database timeout of 10 seconds. ``` echo "wait_timeout = 10" >> /etc/my.cnf.d/server.cnf ``` On my workstation this timeout is short enough that the upgrade fails on the alter shredded job slurm action ``` 2022-02-14 21:34:23 [warning] Stopping ETL due to exception in xdmod.migration-9_5_0-10_0_0.alter-shredded_job_slurm (ETL\Maintenance\ExecuteSql) xdmod.migration-9_5_0-10_0_0.alter-shredded_job_slurm (ETL\Maintenance\ExecuteSql): Error executing SQL Exception: 'SQLSTATE[HY000]: General error: 2006 MySQL server has gone away' ``` With this patch in place (and the timeout still set to 10 seconds), the upgrade completes. Note that a 10 second timeout in the docker then causes the cloud ingest steps to fail.
Fix schema version history (ubccr#1608) * Fixing datetime columns default values This commit adds a default value of `CURRENT_TIMESTAMP` to schema_version_history's `action_datetime` column and removes the associated value from `./etl_data.d/**/schema-version-history.json` files. This was found to be a problem in CentOS8 builds. * Adding sql to cover the upgrade path. * Removing schema_version_history table - Removed all references to schema_version_history as it is not currently being used. - Added a sql script that removes all schema_version_history tables if they are present. * Missed one * Removing all db related contents Since the db table associated with this class / functions / variables is no longer present, they are no longer necessary. * Replacing mod_logger data sql * Woops needed that * Apply suggestions from code review Reverting unintended spacing changes. Co-authored-by: Jeffrey T. Palmer <jeffrey.t.palmer@gmail.com> Co-authored-by: Ryan Rathsam <build@shippable.com> Co-authored-by: Jeffrey T. Palmer <jeffrey.t.palmer@gmail.com>
Merge pull request ubccr#1601 from jpwhite4/alternate_gb Add ability to specify an alternate group by.
Merge pull request ubccr#1540 from jpwhite4/timeseries Add exportJson function back. The 'whitespace changes' error in the CI build is a false positive.
Merge pull request ubccr#1521 from jpwhite4/changelog95 Initial version of the changelog for 9.5 release
Merge pull request ubccr#1529 from eiffel777/fix-pdf-export-report-sc… …heduler Use strtolower to check format for a PDF report
Merge pull request ubccr#1528 from eiffel777/95-upgrade-host-key-coll… …ision Update host dimension migration sql to avoid primary key duplicate during migration
Merge pull request ubccr#1527 from eiffel777/update-raw-stats-correct… …-time-field Updates for cloud Data Export and migration pipelines.
Merge pull request ubccr#1379 from ryanrath/make_save_user_great_again Ensuring that Users have a username
PreviousNext