Skip to content

[Bug]: Freeze when trying to save changes after aborted pragma legacy_alter_table #3741

@chrschllr

Description

@chrschllr

What did you do?

Minimal steps to reproduce:

  • Go to File → New In-Memory Database
  • Create dummy table (anything that creates a savepoint/transaction)
  • Execute pragma legacy_alter_table=1
  • Select either option of the "Setting PRAGMA values or vacuuming will commit your current transaction" dialog (the outcome is the same) - execution will finish with errors
  • Write changes (Ctrl+S) - a popup will appear ("The database is currently busy: executing query")
  • Select either option of the "Do you want to abort that other operation" dialog (the outcome is the same)
  • Application will freeze and has to be killed externally

What did you expect to see?

When aborting the other operation, a normal save
When not aborting the other operation, nothing

What did you see instead?

A total freeze/deadlock in any case

DB4S Version

3.13.99 (nightly)

What OS are you seeing the problem on?

Windows, Linux

OS version

Windows 10, Arch Linux 2024.03.01

Relevant log output

No response

Prevention against duplicate issues

  • I have searched for similar issues

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions