Hi folks, I have some failing migration on the lat...
# fleetc
clong
10/14/2024, 11:19 PMHi folks, I have some failing migration on the latest update. Deployed via K8s on GCP:
Copy code
################################################################################
# WARNING:
# This will perform Fleet database migrations. Please back up your data before
# continuing.
#
# Missing migrations: tables=[20240826160025 20240829165448 20240829165605 20240829165715 20240829165930 20240829170023 20240829170033 20240829170044 20240905105135 20240905140514 20240905200000 20240905200001 20241002104104], data=[].
#
# Press Enter to continue, or Control-c to exit.
################################################################################
2024/10/14 23:14:10 [2024-08-26] Add Removed To Installs
2024/10/14 23:14:10 FAIL 20240826160025_AddRemovedToInstalls.go (failed to find host_software_installs to remove: Error 1054 (42S22): Unknown column 'st.id' in 'on clause'), quitting migration.clong
10/14/2024, 11:26 PMI was able to work around this by taking
fleet prepare db Copy code
features:
enable_host_users: true
enable_software_inventory: falsez
Zay Hanlon
10/15/2024, 12:15 AMhey @clong which version were you upgrading from and which version were you upgrading to?
c
clong
10/15/2024, 3:38 AMUpgrading to
4.57.3clong
10/15/2024, 4:19 PM@Zay Hanlon sorry, just wanted to check to see if you had any guidance of how i could resolve this migration issue -- happy to open a GH issue for tracking if that's better
z
Zay Hanlon
10/15/2024, 4:34 PM@clong - let's see if my team can jump in and help before we kick off an issue for you.
@Rebecca Cowart or @Kathy Satterlee can you take a look here? ^
k
Kathy Satterlee
10/15/2024, 4:38 PMWhat version of MySQL are you running? The minimum required version is v8.0.36 and I've seen this error pop up for previous versions of MySQL.
c
clong
10/15/2024, 4:39 PMlooks like 5.7
clong
10/15/2024, 4:41 PMlet me look at my options for upgrading 👀
clong
10/15/2024, 4:43 PMOK, attempting the upgrade now 🙏
clong
10/15/2024, 4:59 PMMigrations completed.z
Zay Hanlon
10/15/2024, 5:00 PMBeautiful! Sorry I should’ve suggested this last night @clong
c
clong
10/15/2024, 5:00 PMmight be worth having a check in that migration for the SQL version and to post an error like "if you're hitting this error, ensure you're running SQL version v8.0.36+"
clong
10/15/2024, 5:00 PMbut glad we're back in action 🙂
k
Kathy Satterlee
10/16/2024, 2:32 PMGreat feedback @clong, glad you're up and running!
9 Views