I am facing issues with one MySQL temporary table, which was created in an Winforms class which was closed by user, but still in memory, because CancellationToken is not triggered yet, because there is a long running query. In this situation I am opening another instance of the same Winform with supposedly new MySQL session, but it seems that this is not exactly so, because when trying to create a new temp table there is an error that it already exists.

I am creating a Winforms application (.Net 7), which depicts statistics on charts. The source of the statistical data is MySQL query, which runs in Async Task. After the query finishes the result datatable is bind to the chart.