Attempting to update Fleet from 4.41.0 to 4.44.0.....
# fleets
Shawn Maddock
02/13/2024, 12:59 AMAttempting to update Fleet from 4.41.0 to 4.44.0... when running
fleet prepare dbShawn Maddock
02/13/2024, 12:59 AM Copy code
################################################################################
# WARNING:
# This will perform Fleet database migrations. Please back up your data before
# continuing.
#
# Missing migrations: tables=[20240129162819 20240130115133], data=[].
#
# Press Enter to continue, or Control-c to exit.
################################################################################
2024/02/12 18:58:14 [2024-01-29] Add Prefix To Windows Updates Profiles
2024/02/12 18:58:14 FAIL 20240129162819_AddPrefixToWindowsUpdatesProfiles.go (add w prefix to windows updates profiles uuid: Error 1054 (42S22): Unknown column 'w%' in 'where clause'), quitting migration.Shawn Maddock
02/13/2024, 1:04 AMAppears this fix is breaking: https://github.com/fleetdm/fleet/pull/16437
Shawn Maddock
02/13/2024, 1:25 AMI don't actually have any data in that table, I just need to indicate the migration is complete
Shawn Maddock
02/13/2024, 1:26 AMReplacing the double
"'Shawn Maddock
02/13/2024, 1:34 AMManually added the
migration_status_tablesk
Kathy Satterlee
02/13/2024, 3:43 PMInteresting. Sorry you ran in to that! What version of MySQL are you using?
s
Shawn Maddock
02/13/2024, 3:55 PM8.0.30
k
Kathy Satterlee
02/13/2024, 6:52 PMThanks @Shawn Maddock!
@Grant Bilstad or I will get a bug ticket submitted for this.
b
Brock Walters
02/13/2024, 9:53 PM@Shawn Maddock do you have an example of the single vs. double quotes you can share? Thanks.
k
Kathy Satterlee
02/13/2024, 9:57 PMAt a guess, it was this:
Copy code
stmt = `
UPDATE
host_mdm_windows_profiles
SET
profile_uuid = CONCAT("w", profile_uuid)
WHERE
profile_uuid NOT LIKE "w%";
` Copy code
stmt = `
UPDATE
host_mdm_windows_profiles
SET
profile_uuid = CONCAT("w", profile_uuid)
WHERE
profile_uuid NOT LIKE 'w%'
`Kathy Satterlee
02/13/2024, 9:57 PMs
Shawn Maddock
02/13/2024, 9:57 PMAh, my bad. In https://github.com/fleetdm/fleet/blob/main/server/datastore/mysql/migrations/tables/20240129162819_AddPrefixToWindowsUpdatesProfiles.go the double quotes on lines 17, 20, 31 and 33 need to be single quotes
Shawn Maddock
02/13/2024, 9:58 PMYeah more than just the one where clause
Shawn Maddock
04/04/2024, 9:29 PMI'm getting errors upgrading the DB again. This time:
Copy code
Using config file: /etc/fleet/server.yml
################################################################################
# WARNING:
# This will perform Fleet database migrations. Please back up your data before
# continuing.
#
# Missing migrations: tables=[20240327115617], data=[].
#
# Press Enter to continue, or Control-c to exit.
################################################################################
2024/04/04 16:28:20 [2024-03-27] Create Table Nano DDM Requests
2024/04/04 16:28:20 FAIL 20240327115617_CreateTableNanoDDMRequests.go (creating mdm_apple_declarative_requsts: Error 3780 (HY000): Referencing column 'enrollment_id' and referenced column 'id' in foreign key constraint 'mdm_apple_declarative_requests_enrollment_id' are incompatible.), quitting migration.Shawn Maddock
04/04/2024, 9:50 PMThis time I had to add
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_cienrollment_idShawn Maddock
04/04/2024, 9:52 PMI feel like my MySQL DB is in ultra-strict mode or something 😞
Shawn Maddock
04/10/2024, 2:01 PM@Jason Lewis is this not the bug y’all fixed yesterday?
j
Jason Lewis
04/10/2024, 5:26 PMHey @Shawn Maddock! Yes, I believe this is the one. 😕. Sorry it took so long to get fixed. cc @Kathy Satterlee @Grant Bilstad.
s
Shawn Maddock
04/10/2024, 5:30 PMWe had some DB migration issues a while back and @zwass chimed in letting us know MariaDB was not supported, only MySQL official. Now we've had two more in the last couple months, I assumed we were just doing something wrong again and not lining up with whatever environments your releases get tested with, but I couldn't figure out what.
6 Views