Skip to content

When executing long or multiple queries, HeidiSQL hangs when it tries to get database system info #278

@Ivan-Perez

Description

@Ivan-Perez

Steps to reproduce this issue

  1. Execute a long query on the query tab or, alternatively, multiple queries (for example, when I detected the error I was doing 10.000 inserts on a remote server, that would take some minutes to complete).
  2. Move the mouse over the status bar, exactly over the database system name. When idle, HeidiSQL performs a query to get some information about the database system, and a popup is shown.
  3. But when a query is running, the program I think still tries to get that information and hangs because another query is already running.

The exact part of the status bar where you have to over the mouse is this:

status bar

Current behavior

HeidiSQL crashes and no queries continue to be executed. I have to force stop the program.

Expected behavior / Possible solution

If a query is executing at the moment, don't load database system information.

Environment

  • HeidiSQL version: 9.5.0.5278 (this has been happening to me since long time ago)
  • Database system and version: MySQL 5.5 / MySQL 5.6 / MariaDB 10.2 (happens in multiple database systems)
  • Operating system: Windows 7 64-bit

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugDefective behaviour in HeidiSQLconfirmedIssue verified by project member

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions