Martin Pöhlmann
11/22/2021, 12:55 PM{
"message": "unsupported Scan, storing driver.Value type <nil> into type *time.Time",
"errors": [
{
"name": "base",
"reason": "unsupported Scan, storing driver.Value type <nil> into type *time.Time"
}
]
}
Any ideas?Lucas Rodriguez
11/22/2021, 12:57 PMMartin Pöhlmann
11/22/2021, 2:02 PMfleet_1 | {"component":"crons","cron":"cleanups","details":"looping through ids: running visitFunc for queries: getting user_time p50 for query 1: timestamp: 2021-11-22T13:45:38+01:00: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'row_number, mm.* FROM (\n\t\tSELECT d.scheduled_query_id, d.user_time, d.executions' at line 4","err":"aggregating query stats","level":"error","ts":"2021-11-22T12:45:38.017855521Z"}
fleet_1 | {"component":"crons","cron":"cleanups","details":"looping through ids: running visitFunc for scheduled_queries: getting user_time p50 for scheduled_query 4: timestamp: 2021-11-22T13:45:38+01:00: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'row_number, mm.* FROM (\n\t\tSELECT d.scheduled_query_id, d.user_time, d.executions' at line 4","err":"aggregating scheduled query stats","level":"error","ts":"2021-11-22T12:45:38.019472394Z"}
Lucas Rodriguez
11/22/2021, 2:05 PMfleet prepare db
before running the new version of fleet?Martin Pöhlmann
11/22/2021, 2:05 PMcommand: sh -c "/usr/bin/fleet prepare db --no-prompt && /usr/bin/fleet serve"
Lucas Rodriguez
11/22/2021, 2:08 PMMartin Pöhlmann
11/22/2021, 2:09 PMLucas Rodriguez
11/22/2021, 2:12 PMMartin Pöhlmann
11/24/2021, 6:28 PMLucas Rodriguez
11/24/2021, 6:33 PMMartin Pöhlmann
11/24/2021, 6:37 PMLucas Rodriguez
11/24/2021, 6:41 PMMartin Pöhlmann
11/24/2021, 10:34 PMLucas Rodriguez
11/29/2021, 9:22 PMMartin Pöhlmann
11/29/2021, 9:22 PMLucas Rodriguez
11/29/2021, 9:23 PMMartin Pöhlmann
11/29/2021, 9:23 PMLucas Rodriguez
11/29/2021, 9:24 PMMartin Pöhlmann
11/29/2021, 9:24 PMLucas Rodriguez
11/29/2021, 9:51 PMFlngen Flugen
11/30/2021, 2:22 PMLucas Rodriguez
11/30/2021, 5:52 PMMartin Pöhlmann
12/02/2021, 9:03 AMLucas Rodriguez
12/02/2021, 12:33 PMMartin Pöhlmann
12/02/2021, 12:47 PMLucas Rodriguez
12/02/2021, 1:03 PMSELECT * FROM fleet.hosts h LEFT JOIN fleet.host_seen_times hst ON h.id = hst.host_id
(feel free to not include any sensitive data like hostnames)Martin Pöhlmann
12/02/2021, 1:32 PMLucas Rodriguez
12/02/2021, 1:45 PM