[Bug]: Docker: Failed to start after updating #1754

Closed
opened 2026-02-28 19:53:51 -06:00 by GiteaMirror · 2 comments
Owner

Originally created by @dwong33 on GitHub (Jan 8, 2025).

Verified issue does not already exist?

  • I have searched and found no existing issue

What happened?

After updating to the newest version, the docker failed to start, with the following error log:

/app/node_modules/better-sqlite3/lib/methods/wrappers.js:9
        this[cppdb].exec(sql);
                    ^
SqliteError: no such column: password
    at Database.exec (/app/node_modules/better-sqlite3/lib/methods/wrappers.js:9:14)
    at WrappedDatabase.exec (file:///app/src/db.js:30:20)
    at Migration.up (file:///app/migrations/1718889148000-openid.js:4:24)
    at next (/app/node_modules/migrate/lib/migrate.js:35:45)
    at /app/node_modules/migrate/lib/migrate.js:71:9
    at /app/node_modules/migrate/lib/set.js:84:5
    at FSReqCallback.oncomplete (node:fs:192:23) {
  code: 'SQLITE_ERROR'
Checking if there are any migrations to run for direction "up"...
}

Node.js v18.20.5
Checking if there are any migrations to run for direction "up"...

/app/node_modules/better-sqlite3/lib/methods/wrappers.js:9
        this[cppdb].exec(sql);
                    ^
SqliteError: no such column: password
    at Database.exec (/app/node_modules/better-sqlite3/lib/methods/wrappers.js:9:14)
    at WrappedDatabase.exec (file:///app/src/db.js:30:20)
    at Migration.up (file:///app/migrations/1718889148000-openid.js:4:24)
    at next (/app/node_modules/migrate/lib/migrate.js:35:45)
    at migrate (/app/node_modules/migrate/lib/migrate.js:76:3)
    at MigrationSet.migrate (/app/node_modules/migrate/lib/set.js:123:3)
    at MigrationSet.up (/app/node_modules/migrate/lib/set.js:107:8)
    at file:///app/src/migrations.js:23:23
    at /app/node_modules/migrate/index.js:62:5
    at /app/node_modules/migrate/lib/load-migrations.js:97:7 {
  code: 'SQLITE_ERROR'
}

Node.js v18.20.5

How can we reproduce the issue?

Updating the version to the latest one.

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

No response

Operating System

None

Originally created by @dwong33 on GitHub (Jan 8, 2025). ### Verified issue does not already exist? - [X] I have searched and found no existing issue ### What happened? After updating to the newest version, the docker failed to start, with the following error log: ``` /app/node_modules/better-sqlite3/lib/methods/wrappers.js:9 this[cppdb].exec(sql); ^ SqliteError: no such column: password at Database.exec (/app/node_modules/better-sqlite3/lib/methods/wrappers.js:9:14) at WrappedDatabase.exec (file:///app/src/db.js:30:20) at Migration.up (file:///app/migrations/1718889148000-openid.js:4:24) at next (/app/node_modules/migrate/lib/migrate.js:35:45) at /app/node_modules/migrate/lib/migrate.js:71:9 at /app/node_modules/migrate/lib/set.js:84:5 at FSReqCallback.oncomplete (node:fs:192:23) { code: 'SQLITE_ERROR' Checking if there are any migrations to run for direction "up"... } Node.js v18.20.5 Checking if there are any migrations to run for direction "up"... /app/node_modules/better-sqlite3/lib/methods/wrappers.js:9 this[cppdb].exec(sql); ^ SqliteError: no such column: password at Database.exec (/app/node_modules/better-sqlite3/lib/methods/wrappers.js:9:14) at WrappedDatabase.exec (file:///app/src/db.js:30:20) at Migration.up (file:///app/migrations/1718889148000-openid.js:4:24) at next (/app/node_modules/migrate/lib/migrate.js:35:45) at migrate (/app/node_modules/migrate/lib/migrate.js:76:3) at MigrationSet.migrate (/app/node_modules/migrate/lib/set.js:123:3) at MigrationSet.up (/app/node_modules/migrate/lib/set.js:107:8) at file:///app/src/migrations.js:23:23 at /app/node_modules/migrate/index.js:62:5 at /app/node_modules/migrate/lib/load-migrations.js:97:7 { code: 'SQLITE_ERROR' } Node.js v18.20.5 ``` ### How can we reproduce the issue? Updating the version to the latest one. ### Where are you hosting Actual? Docker ### What browsers are you seeing the problem on? _No response_ ### Operating System None
GiteaMirror added the bug label 2026-02-28 19:53:51 -06:00
Author
Owner

@Teprifer commented on GitHub (Jan 8, 2025):

Check out: #3957 - should provide a resolution.

@Teprifer commented on GitHub (Jan 8, 2025): Check out: #3957 - should provide a resolution.
Author
Owner

@dwong33 commented on GitHub (Jan 8, 2025):

Perfect! Thank you so much! It fixed the issue.

@dwong33 commented on GitHub (Jan 8, 2025): Perfect! Thank you so much! It fixed the issue.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#1754