[BUG] Lite could not read the DuckDB-file #218
Description
Component
Lite
Performance Monitor Version
1.3.0
SQL Server Version
Microsoft SQL Server 2019 (RTM-CU32) (KB5054833) - 15.0.4430.1 (X64) Feb 21 2025 17:28:26 Copyright (C) 2019 Microsoft Corporation Enterprise Edition (64-bit) on Windows Server 2016 Standard 10.0 (Build 14393: ) (Hypervisor) + Azure SQL Database
Windows Version
Windows Server 2019 Standard
Describe the Bug
I had the Lite-version running for about an error when the status at the bottom said logging was Broken. Tried to close and reopen, but then a message box with error message popped up. No servers was in the list at the right menu. When I added one of the servers again, the two servers that had been there was shown again, but no data could be shown.
I probably can extract to a new folder and start over, but wanted to report this anyhow.
Steps to Reproduce
Open Lite application
Leave it running for a while
Expected Behavior
Application should be able to run for more than one hour.
Actual Behavior
Failed after an hour. See comments above.
Error Messages / Log Output
Here is a couple of lines from the log-file when the error startet:
2026-02-21 13:39:18.269 [INFO ] [Overview] Failed to get summary for HVI-SANNTIDSHUB-DB: IO Error: Could not read file "D:\PerformanceMonitor\PerformanceMonitorLite-1.3.0\monitor.duckdb" (error in ReadFile(location: 269758464, nr_bytes: 262144)): Reached the end of the file.
2026-02-21 13:39:18.286 [INFO ] [Overview] Failed to get summary for PSDV-ETL: DuckDBOpen failed: IO Error: Could not read file "D:\PerformanceMonitor\PerformanceMonitorLite-1.3.0\monitor.duckdb" (error in ReadFile(location: 457453568, nr_bytes: 262144)): Reached the end of the file.
2026-02-21 13:39:30.410 [INFO ] [ServerTab] Trend query failed: DuckDBOpen failed: IO Error: Could not read file "D:\PerformanceMonitor\PerformanceMonitorLite-1.3.0\monitor.duckdb" (error in ReadFile(location: 457453568, nr_bytes: 262144)): Reached the end of the file.
2026-02-21 13:39:30.418 [INFO ] [ServerTab] Trend query failed: DuckDBOpen failed: IO Error: Could not read file "D:\PerformanceMonitor\PerformanceMonitorLite-1.3.0\monitor.duckdb" (error in ReadFile(location: 457453568, nr_bytes: 262144)): Reached the end of the file.
2026-02-21 13:39:30.428 [INFO ] [ServerTab] Trend query failed: DuckDBOpen failed: IO Error: Could not read file "D:\PerformanceMonitor\PerformanceMonitorLite-1.3.0\monitor.duckdb" (error in ReadFile(location: 457453568, nr_bytes: 262144)): Reached the end of the file.
2026-02-21 13:39:30.439 [INFO ] [ServerTab] Trend query failed: DuckDBOpen failed: IO Error: Could not read file "D:\PerformanceMonitor\PerformanceMonitorLite-1.3.0\monitor.duckdb" (error in ReadFile(location: 457453568, nr_bytes: 262144)): Reached the end of the file.
2026-02-21 13:39:30.447 [INFO ] [ServerTab] Trend query failed: DuckDBOpen failed: IO Error: Could not read file "D:\PerformanceMonitor\PerformanceMonitorLite-1.3.0\monitor.duckdb" (error in ReadFile(location: 457453568, nr_bytes: 262144)): Reached the end of the file.
2026-02-21 13:39:30.458 [INFO ] [ServerTab] Trend query failed: DuckDBOpen failed: IO Error: Could not read file "D:\PerformanceMonitor\PerformanceMonitorLite-1.3.0\monitor.duckdb" (error in ReadFile(location: 457453568, nr_bytes: 262144)): Reached the end of the file.
2026-02-21 13:39:30.466 [INFO ] [ServerTab] Trend query failed: DuckDBOpen failed: IO Error: Could not read file "D:\PerformanceMonitor\PerformanceMonitorLite-1.3.0\monitor.duckdb" (error in ReadFile(location: 457453568, nr_bytes: 262144)): Reached the end of the file.
2026-02-21 13:39:30.502 [INFO ] [ServerTab] [HVI-SANNTIDSHUB-DB] RefreshAllDataAsync failed: DuckDB.NET.Data.DuckDBException (0x80004005): DuckDBOpen failed: IO Error: Could not read file "D:\PerformanceMonitor\PerformanceMonitorLite-1.3.0\monitor.duckdb" (error in ReadFile(location: 457453568, nr_bytes: 262144)): Reached the end of the file.
at DuckDB.NET.Data.Connection.ConnectionManager.GetConnectionReference(DuckDBConnectionString connectionString)
at System.Data.Common.DbConnection.OpenAsync(CancellationToken cancellationToken)
--- End of stack trace from previous location ---
at PerformanceMonitorLite.Services.LocalDataService.OpenConnectionAsync() in D:\a\PerformanceMonitor\PerformanceMonitor\Lite\Services\LocalDataService.cs:line 40
at PerformanceMonitorLite.Services.LocalDataService.GetLatestQuerySnapshotsAsync(Int32 serverId, Int32 hoursBack, Nullable`1 fromDate, Nullable`1 toDate) in D:\a\PerformanceMonitor\PerformanceMonitor\Lite\Services\LocalDataService.Blocking.cs:line 114
at PerformanceMonitorLite.Controls.ServerTab.RefreshAllDataAsync() in D:\a\PerformanceMonitor\PerformanceMonitor\Lite\Controls\ServerTab.xaml.cs:line 472
2026-02-21 13:39:48.289 [INFO ] [Overview] Failed to get summary for HVI-SANNTIDSHUB-DB: DuckDBOpen failed: IO Error: Could not read file "D:\PerformanceMonitor\PerformanceMonitorLite-1.3.0\monitor.duckdb" (error in ReadFile(location: 457453568, nr_bytes: 262144)): Reached the end of the file.
Screenshots
No response
Additional Context
This has worked before, yes. Only thing that have changed, is that I previously used Lite only to monitor an Azure SQL Database, but today I also added an onprem SQL Server database.