Skip to content
This repository was archived by the owner on Jan 17, 2022. It is now read-only.
This repository was archived by the owner on Jan 17, 2022. It is now read-only.

Fix "Upgrade 'dbName' blocked by other connection" warning when changing table schema #6

@NateLevin1

Description

@NateLevin1

Whenever you set a table's schema then change it the following warning is thrown.

Upgrade 'dbName' blocked by other connection holding version n

The rest of the behavior is perfectly normal AFAIK but the warning is always thrown.

Code Example
First, have a table constructor like this

const tbl = new Table(`CREATE TABLE tbl (
  id AUTO_INCREMENT,
  firstName,
  lastName
)`, db);

then edit it to

const tbl = new Table(`CREATE TABLE tbl (
  id AUTO_INCREMENT,
  firstName,
  lastName,
  email
)`, db);

and when running again the warning will be thrown.

See also
https://github.com/UltimatePro-Grammer/JSQL/blob/5fdb6840c2a48f814c665071d655c7f23173c2dc/src/lib/runner/create/addDatabase.ts#L11-L16

Metadata

Metadata

Assignees

No one assigned

    Labels

    backburnerThis issue will not be actively worked on, though may be fixed some time in the future.bugSomething isn't working

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions