Title
#fleet
Mystery Incorporated

Mystery Incorporated

05/31/2022, 5:38 PM
Also "Error executing distributed query: fleet_detail_query_munki_info: no such table: munki_info","version":"5.2.3"
Noah Talerman

Noah Talerman

06/01/2022, 2:41 PM
Hey, I’m sorry you’re running into this issue. The following is a bug report, which tracks this issue, filed on GitHub: https://github.com/fleetdm/fleet/issues/5992
Kathy Satterlee

Kathy Satterlee

06/02/2022, 8:03 PM
Hey, @Mystery Incorporated, can you confirm for me whether you ran
fleet prepare db
after updating and before running
fleet serve
?
Mystery Incorporated

Mystery Incorporated

06/02/2022, 8:06 PM
@Kathy Satterlee always, I run an update script that does it for me and I confirm it was done
Kathy Satterlee

Kathy Satterlee

06/02/2022, 8:09 PM
Thanks. I figured that was the case, but sometimes you have to ask the "obvious" questions.
Mystery Incorporated

Mystery Incorporated

06/02/2022, 8:10 PM
Here is my update script:
cd /home/username/fleet-source/
git stash
git checkout master
git fetch upstream
git fetch upstream --tags
git merge upstream/main
git push
read -p "Type git branch name: " branch
git checkout $branch
git pull
#echo ""
make deps
make generate
make
echo ""
echo "Stopping fleet service"
echo ""
sudo service fleet stop
/home/username/fleet-source/build/fleet prepare db --config /home/username/fleet/config.yml
sudo mv /usr/local/bin/fleet /usr/local/bin/fleet.bak
sudo mv /usr/local/bin/fleetctl /usr/local/bin/fleetctl.bak
sudo mv /home/username/fleet-source/build/fleet /usr/local/bin/fleet
sudo mv /home/username/fleet-source/build/fleetctl /usr/local/bin/fleetctl
echo ""
echo "Starting fleet service"
echo ""
sudo service fleet start
echo "Done"
8:14 PM
Also here are the migrations done
8:14 PM
mysql> select * from migration_status_tables
    -> ;
+-----+----------------+------------+---------------------+
| id  | version_id     | is_applied | tstamp              |
+-----+----------------+------------+---------------------+
|   1 |              0 |          1 | 2021-06-22 18:16:05 |
|   2 | 20161118193812 |          1 | 2021-06-22 18:16:34 |
|   3 | 20161118211713 |          1 | 2021-06-22 18:16:34 |
|   4 | 20161118212436 |          1 | 2021-06-22 18:16:35 |
|   5 | 20161118212515 |          1 | 2021-06-22 18:16:35 |
|   6 | 20161118212528 |          1 | 2021-06-22 18:16:36 |
|   7 | 20161118212538 |          1 | 2021-06-22 18:16:37 |
|   8 | 20161118212549 |          1 | 2021-06-22 18:16:37 |
|   9 | 20161118212557 |          1 | 2021-06-22 18:16:38 |
|  10 | 20161118212604 |          1 | 2021-06-22 18:16:38 |
|  11 | 20161118212613 |          1 | 2021-06-22 18:16:39 |
|  12 | 20161118212621 |          1 | 2021-06-22 18:16:39 |
|  13 | 20161118212630 |          1 | 2021-06-22 18:16:39 |
|  14 | 20161118212641 |          1 | 2021-06-22 18:16:40 |
|  15 | 20161118212649 |          1 | 2021-06-22 18:16:40 |
|  16 | 20161118212656 |          1 | 2021-06-22 18:16:40 |
|  17 | 20161118212758 |          1 | 2021-06-22 18:16:40 |
|  18 | 20161128234849 |          1 | 2021-06-22 18:16:42 |
|  19 | 20161230162221 |          1 | 2021-06-22 18:16:43 |
|  20 | 20170104113816 |          1 | 2021-06-22 18:16:44 |
|  21 | 20170105151732 |          1 | 2021-06-22 18:16:45 |
|  22 | 20170108191242 |          1 | 2021-06-22 18:16:45 |
|  23 | 20170109094020 |          1 | 2021-06-22 18:16:45 |
|  24 | 20170109130438 |          1 | 2021-06-22 18:16:46 |
|  25 | 20170110202752 |          1 | 2021-06-22 18:16:47 |
|  26 | 20170111133013 |          1 | 2021-06-22 18:16:47 |
|  27 | 20170117025759 |          1 | 2021-06-22 18:16:50 |
|  28 | 20170118191001 |          1 | 2021-06-22 18:16:50 |
|  29 | 20170119234632 |          1 | 2021-06-22 18:16:51 |
|  30 | 20170124230432 |          1 | 2021-06-22 18:16:51 |
|  31 | 20170127014618 |          1 | 2021-06-22 18:16:51 |
|  32 | 20170131232841 |          1 | 2021-06-22 18:16:51 |
|  33 | 20170223094154 |          1 | 2021-06-22 18:16:53 |
|  34 | 20170306075207 |          1 | 2021-06-22 18:17:08 |
|  35 | 20170309100733 |          1 | 2021-06-22 18:17:08 |
|  36 | 20170331111922 |          1 | 2021-06-22 18:17:11 |
|  37 | 20170502143928 |          1 | 2021-06-22 18:17:11 |
|  38 | 20170504130602 |          1 | 2021-06-22 18:17:11 |
|  39 | 20170509132100 |          1 | 2021-06-22 18:17:11 |
|  40 | 20170519105647 |          1 | 2021-06-22 18:17:11 |
|  41 | 20170519105648 |          1 | 2021-06-22 18:17:12 |
|  42 | 20170831234300 |          1 | 2021-06-22 18:17:12 |
|  43 | 20170831234301 |          1 | 2021-06-22 18:17:12 |
|  44 | 20170831234303 |          1 | 2021-06-22 18:17:12 |
|  45 | 20171116163618 |          1 | 2021-06-22 18:17:13 |
|  46 | 20171219164727 |          1 | 2021-06-22 18:17:14 |
|  47 | 20180620164811 |          1 | 2021-06-22 18:17:15 |
|  48 | 20180620175054 |          1 | 2021-06-22 18:17:16 |
|  49 | 20180620175055 |          1 | 2021-06-22 18:17:16 |
|  50 | 20191010101639 |          1 | 2021-06-22 18:17:16 |
|  51 | 20191010155147 |          1 | 2021-06-22 18:17:17 |
|  52 | 20191220130734 |          1 | 2021-06-22 18:17:18 |
|  53 | 20200311140000 |          1 | 2021-06-22 18:17:20 |
|  54 | 20200405120000 |          1 | 2021-06-22 18:17:23 |
|  55 | 20200407120000 |          1 | 2021-06-22 18:17:25 |
|  56 | 20200420120000 |          1 | 2021-06-22 18:17:25 |
|  57 | 20200504120000 |          1 | 2021-06-22 18:17:28 |
|  58 | 20200512120000 |          1 | 2021-06-22 18:17:32 |
|  59 | 20200707120000 |          1 | 2021-06-22 18:17:33 |
|  60 | 20201011162341 |          1 | 2021-06-22 18:17:48 |
|  61 | 20201021104586 |          1 | 2021-06-22 18:17:49 |
|  62 | 20201102112520 |          1 | 2021-06-22 18:17:52 |
|  63 | 20201208121729 |          1 | 2021-06-22 18:17:55 |
|  64 | 20201215091637 |          1 | 2021-06-22 18:17:56 |
|  65 | 20210119174155 |          1 | 2021-06-22 18:17:56 |
|  66 | 20210326182902 |          1 | 2021-06-22 18:17:56 |
|  67 | 20210421112652 |          1 | 2021-06-22 18:17:56 |
|  68 | 20210506095025 |          1 | 2021-06-22 18:17:57 |
|  69 | 20210513115729 |          1 | 2021-06-22 18:18:00 |
|  70 | 20210526113559 |          1 | 2021-06-22 18:18:03 |
|  71 | 20210601000001 |          1 | 2021-07-03 22:01:55 |
|  72 | 20210601000002 |          1 | 2021-07-03 22:01:55 |
|  73 | 20210601000003 |          1 | 2021-07-03 22:01:56 |
|  74 | 20210601000004 |          1 | 2021-07-03 22:01:56 |
|  75 | 20210601000005 |          1 | 2021-07-03 22:01:56 |
|  76 | 20210601000006 |          1 | 2021-07-03 22:01:56 |
|  77 | 20210601000007 |          1 | 2021-07-03 22:01:56 |
|  78 | 20210601000008 |          1 | 2021-07-03 22:01:58 |
|  79 | 20210606151329 |          1 | 2021-07-03 22:01:58 |
|  80 | 20210616163757 |          1 | 2021-07-03 22:01:58 |
|  81 | 20210617174723 |          1 | 2021-07-03 22:01:58 |
|  82 | 20210622160235 |          1 | 2021-07-03 22:01:59 |
|  83 | 20210623100031 |          1 | 2021-07-03 22:01:59 |
|  84 | 20210623133615 |          1 | 2021-07-03 22:02:00 |
|  85 | 20210708143152 |          1 | 2021-07-29 23:06:15 |
|  86 | 20210709124443 |          1 | 2021-07-29 23:06:15 |
|  87 | 20210712155608 |          1 | 2021-07-29 23:06:15 |
|  88 | 20210714102108 |          1 | 2021-07-29 23:06:15 |
|  89 | 20210719153709 |          1 | 2021-07-29 23:06:15 |
|  90 | 20210721171531 |          1 | 2021-08-14 23:08:45 |
|  91 | 20210723135713 |          1 | 2021-08-14 23:08:46 |
|  92 | 20210802135933 |          1 | 2021-08-14 23:08:46 |
|  93 | 20210806112844 |          1 | 2021-08-14 23:08:46 |
|  94 | 20210810095603 |          1 | 2021-08-14 23:08:46 |
|  95 | 20210811150223 |          1 | 2021-08-14 23:08:47 |
|  96 | 20210818151827 |          1 | 2021-08-20 14:17:55 |
|  97 | 20210818151828 |          1 | 2021-09-24 03:02:30 |
|  98 | 20210818182258 |          1 | 2021-09-24 03:02:31 |
|  99 | 20210819131107 |          1 | 2021-09-24 03:02:32 |
| 100 | 20210819143446 |          1 | 2021-09-24 03:02:32 |
| 101 | 20210903132338 |          1 | 2021-09-24 03:02:32 |
| 102 | 20210915144307 |          1 | 2021-09-24 03:02:32 |
| 103 | 20210920155130 |          1 | 2021-09-24 03:02:32 |
| 104 | 20210927143115 |          1 | 2021-10-02 16:04:49 |
| 105 | 20210927143116 |          1 | 2021-10-09 20:34:06 |
| 106 | 20211013133706 |          1 | 2021-11-02 16:44:01 |
| 107 | 20211013133707 |          1 | 2021-11-02 16:44:01 |
| 108 | 20211102135149 |          1 | 2021-11-19 18:17:53 |
| 109 | 20211109121546 |          1 | 2021-11-19 18:17:53 |
| 110 | 20211110163320 |          1 | 2021-11-19 18:17:53 |
| 111 | 20211116184029 |          1 | 2021-11-19 18:17:53 |
| 112 | 20211116184030 |          1 | 2022-01-21 16:06:36 |
| 113 | 20211202092042 |          1 | 2022-01-21 16:06:36 |
| 114 | 20211202181033 |          1 | 2022-01-21 16:06:36 |
| 115 | 20211207161856 |          1 | 2022-01-21 16:06:36 |
| 116 | 20211216131203 |          1 | 2022-01-21 16:06:36 |
| 117 | 20211221110132 |          1 | 2022-01-21 16:06:36 |
| 118 | 20220107155700 |          1 | 2022-02-03 12:24:25 |
| 119 | 20220125105650 |          1 | 2022-02-15 17:10:58 |
| 120 | 20220201084510 |          1 | 2022-02-15 17:10:58 |
| 121 | 20220208144830 |          1 | 2022-02-15 17:10:58 |
| 122 | 20220208144831 |          1 | 2022-03-15 03:01:24 |
| 123 | 20220215152203 |          1 | 2022-03-15 03:01:24 |
| 124 | 20220223113157 |          1 | 2022-03-15 03:01:24 |
| 125 | 20220307104655 |          1 | 2022-03-31 13:43:17 |
| 126 | 20220309133956 |          1 | 2022-03-31 13:43:17 |
| 127 | 20220316155700 |          1 | 2022-03-31 13:43:17 |
| 128 | 20220323152301 |          1 | 2022-03-31 13:43:18 |
| 129 | 20220330100659 |          1 | 2022-05-07 17:16:40 |
| 130 | 20220404091216 |          1 | 2022-05-07 17:16:40 |
| 131 | 20220419140750 |          1 | 2022-05-10 21:47:42 |
| 132 | 20220428140039 |          1 | 2022-05-10 21:47:42 |
| 133 | 20220503134048 |          1 | 2022-05-29 21:37:11 |
+-----+----------------+------------+---------------------+
133 rows in set (0.00 sec)