Updated from 9.5 to 11.5.2 directly on FreeBSD 13.4, Grafana makes 10-15 MySQL queries A SECOND that look like this:
657 Query COMMIT
657 Query SET TRANSACTION ISOLATION LEVEL READ COMMITTED
657 Query START TRANSACTION READ ONLY
657 Query SELECT `resource_version`, `group`, `resource` FROM `resource_version`
These resource_* tables are empty.
I tried to drop the database and start Grafana with an empty one to generate new tables - same problem.
Log:
logger=settings t=2025-03-26T02:11:50.854431836+05:00 level=info msg="Starting Grafana" version=11.5.2 commit=598e033 branch=main compiled=2025-03-26T02:11:50+05:00
logger=settings t=2025-03-26T02:11:50.855166872+05:00 level=info msg="Config loaded from" file=/usr/local/share/grafana/conf/defaults.ini
logger=settings t=2025-03-26T02:11:50.85520497+05:00 level=info msg="Config loaded from" file=/usr/local/etc/grafana/grafana.ini
logger=settings t=2025-03-26T02:11:50.85522601+05:00 level=info msg=Target target=[all]
logger=settings t=2025-03-26T02:11:50.855264406+05:00 level=info msg="Path Home" path=/usr/local/share/grafana
logger=settings t=2025-03-26T02:11:50.855300807+05:00 level=info msg="Path Data" path=/var/db/grafana
logger=settings t=2025-03-26T02:11:50.855336536+05:00 level=info msg="Path Logs" path=/var/log/grafana
logger=settings t=2025-03-26T02:11:50.855375266+05:00 level=info msg="Path Plugins" path=/var/db/grafana/plugins
logger=settings t=2025-03-26T02:11:50.855493455+05:00 level=info msg="Path Provisioning" path=/usr/local/etc/grafana/provisioning
logger=settings t=2025-03-26T02:11:50.855528195+05:00 level=info msg="App mode production"
logger=featuremgmt t=2025-03-26T02:11:50.856895807+05:00 level=info msg=FeatureToggles nestedFolders=true addFieldFromCalculationStatFunctions=true annotationPermissionUpdate=true angularDeprecationUI=true cloudWatchRoundUpEndTime=true dashboardSceneSolo=true lokiStructuredMetadata=true exploreMetrics=true lokiLabelNamesQueryApi=true alertingSimplifiedRouting=true newDashboardSharingComponent=true preinstallAutoUpdate=true azureMonitorEnableUserAuth=true reportingUseRawTimeRange=true ssoSettingsApi=true lokiQueryHints=true influxdbBackendMigration=true logsExploreTableVisualisation=true lokiQuerySplitting=true alertingInsights=true openSearchBackendFlowEnabled=true correlations=true awsAsyncQueryCaching=true zipkinBackendMigration=true publicDashboardsScene=true transformationsRedesign=true userStorageAPI=true transformationsVariableSupport=true formatString=true logRowsPopoverMenu=true pinNavItems=true dashboardSceneForViewers=true logsInfiniteScrolling=true useSessionStorageForRedirection=true dashgpt=true promQLScope=true newPDFRendering=true tlsMemcached=true prometheusAzureOverrideAudience=true newFiltersUI=true alertingUIOptimizeReducer=true accessControlOnCall=true accessActionSets=true logsContextDatasourceUi=true unifiedRequestLog=true dashboardScene=true groupToNestedTableTransformation=true dataplaneFrontendFallback=true managedPluginsInstall=true alertingNoDataErrorExecution=true onPremToCloudMigrations=true panelMonitoring=true alertingApiServer=true cloudWatchCrossAccountQuerying=true kubernetesPlaylists=true cloudWatchNewLabelParsing=true recordedQueriesMulti=true recoveryThreshold=true
logger=sqlstore t=2025-03-26T02:11:50.857104721+05:00 level=info msg="Connecting to DB" dbtype=mysql
logger=migrator t=2025-03-26T02:11:50.863265235+05:00 level=info msg="Locking database"
logger=migrator t=2025-03-26T02:11:50.863964888+05:00 level=info msg="Starting DB migrations"
logger=migrator t=2025-03-26T02:11:50.902962437+05:00 level=info msg="migrations completed" performed=0 skipped=629 duration=5.012254ms
logger=migrator t=2025-03-26T02:11:50.907492817+05:00 level=info msg="Unlocking database"
logger=secrets t=2025-03-26T02:11:50.909755597+05:00 level=info msg="Envelope encryption state" enabled=true currentprovider=secretKey.v1
logger=plugin.angulardetectorsprovider.dynamic t=2025-03-26T02:11:51.088813834+05:00 level=info msg="Restored cache from database" duration=1.501194ms
logger=plugin.store t=2025-03-26T02:11:51.094067858+05:00 level=info msg="Loading plugins..."
logger=local.finder t=2025-03-26T02:11:51.212086694+05:00 level=warn msg="Skipping finding plugins as directory does not exist" path=/usr/local/share/grafana/plugins-bundled
logger=plugins.registration t=2025-03-26T02:11:51.245247994+05:00 level=info msg="Plugin registered" pluginId=farski-blendstat-panel
logger=plugins.registration t=2025-03-26T02:11:51.381074628+05:00 level=info msg="Plugin registered" pluginId=grafana-lokiexplore-app
logger=plugins.registration t=2025-03-26T02:11:51.539659669+05:00 level=info msg="Plugin registered" pluginId=grafana-pyroscope-app
logger=plugin.store t=2025-03-26T02:11:51.539806816+05:00 level=info msg="Plugins loaded" count=57 duration=445.741291ms
logger=resource-migrator t=2025-03-26T02:11:51.546990848+05:00 level=info msg="Locking database"
logger=resource-migrator t=2025-03-26T02:11:51.548010418+05:00 level=info msg="Starting DB migrations"
logger=resource-migrator t=2025-03-26T02:11:51.55317084+05:00 level=info msg="migrations completed" performed=0 skipped=22 duration=392.753Вµs
logger=resource-migrator t=2025-03-26T02:11:51.556906244+05:00 level=info msg="Unlocking database"
logger=query_data t=2025-03-26T02:11:51.570048365+05:00 level=info msg="Query Service initialization"
logger=live.push_http t=2025-03-26T02:11:51.580525689+05:00 level=info msg="Live Push Gateway initialization"
logger=ngalert.notifier.alertmanager org=1 t=2025-03-26T02:11:51.591169323+05:00 level=info msg="Applying new configuration to Alertmanager" configHash=d2c56faca6af2a5772ff4253222f7386
logger=ngalert.state.manager t=2025-03-26T02:11:51.600146833+05:00 level=info msg="Running in alternative execution of Error/NoData mode"
logger=cloudmigration.service t=2025-03-26T02:11:51.606604489+05:00 level=info msg="using gcom client for auth"
logger=infra.usagestats.collector t=2025-03-26T02:11:51.606869923+05:00 level=info msg="registering usage stat providers" usageStatsProvidersLen=2
logger=provisioning.alerting t=2025-03-26T02:11:51.609476853+05:00 level=info msg="starting to provision alerting"
logger=provisioning.alerting t=2025-03-26T02:11:51.609580436+05:00 level=info msg="finished to provision alerting"
logger=ngalert.state.manager t=2025-03-26T02:11:51.611214153+05:00 level=info msg="Warming state cache for startup"
logger=grafanaStorageLogger t=2025-03-26T02:11:51.61136139+05:00 level=info msg="Storage starting"
logger=ngalert.multiorg.alertmanager t=2025-03-26T02:11:51.61179522+05:00 level=info msg="Starting MultiOrg Alertmanager"
logger=ngalert.state.manager t=2025-03-26T02:11:51.612566816+05:00 level=info msg="State cache has been initialized" states=0 duration=1.350236ms
logger=ngalert.scheduler t=2025-03-26T02:11:51.612664558+05:00 level=info msg="Starting scheduler" tickInterval=10s maxAttempts=3
logger=ticker t=2025-03-26T02:11:51.612766751+05:00 level=info msg=starting first_tick=2025-03-26T02:12:00+05:00
logger=provisioning.dashboard t=2025-03-26T02:11:51.613996285+05:00 level=info msg="starting to provision dashboards"
logger=provisioning.dashboard t=2025-03-26T02:11:51.61405726+05:00 level=info msg="finished to provision dashboards"
logger=http.server t=2025-03-26T02:11:51.616951244+05:00 level=info msg="HTTP Server Listen" address=127.0.0.1:8084 protocol=http subUrl=/grafana socket=
logger=grafana-apiserver t=2025-03-26T02:11:52.541867574+05:00 level=info msg="Adding GroupVersion playlist.grafana.app v0alpha1 to ResourceManager"
logger=resource-server t=2025-03-26T02:11:52.542210528+05:00 level=warn msg="failed to register storage metrics" error="duplicate metrics collector registration attempted"
logger=resource-server t=2025-03-26T02:11:52.54248193+05:00 level=warn msg="failed to register storage metrics" error="duplicate metrics collector registration attempted"
logger=resource-server t=2025-03-26T02:11:52.542711176+05:00 level=warn msg="failed to register storage metrics" error="duplicate metrics collector registration attempted"
logger=grafana-apiserver t=2025-03-26T02:11:52.547936466+05:00 level=info msg="Adding GroupVersion dashboard.grafana.app v0alpha1 to ResourceManager"
logger=grafana-apiserver t=2025-03-26T02:11:52.549884818+05:00 level=info msg="Adding GroupVersion dashboard.grafana.app v1alpha1 to ResourceManager"
logger=grafana-apiserver t=2025-03-26T02:11:52.551634371+05:00 level=info msg="Adding GroupVersion dashboard.grafana.app v2alpha1 to ResourceManager"
logger=grafana-apiserver t=2025-03-26T02:11:52.553399353+05:00 level=info msg="Adding GroupVersion featuretoggle.grafana.app v0alpha1 to ResourceManager"
logger=grafana-apiserver t=2025-03-26T02:11:52.558077894+05:00 level=info msg="Adding GroupVersion iam.grafana.app v0alpha1 to ResourceManager"
logger=grafana-apiserver t=2025-03-26T02:11:52.567256734+05:00 level=info msg="Adding GroupVersion notifications.alerting.grafana.app v0alpha1 to ResourceManager"
logger=grafana-apiserver t=2025-03-26T02:11:52.570605146+05:00 level=info msg="Adding GroupVersion userstorage.grafana.app v0alpha1 to ResourceManager"
logger=app-registry t=2025-03-26T02:11:52.663229453+05:00 level=info msg="app registry initialized"
logger=infra.usagestats t=2025-03-26T02:12:21.622107356+05:00 level=info msg="Usage stats are ready to report"