Ghost: [alpha.15] "DB_NOT_INITIALISED" after update from alpha.14

Created on 6 Mar 2017  ·  2Comments  ·  Source: TryGhost/Ghost

Issue Summary

Ghost alpha.14 was working properly. I ran 'ghost update' which was successful. After starting ghost I got "DB_NOT_INITIALISED" error.

Steps to Reproduce

  1. Install and configure ghost alpha.14 so that is works
  2. Update with 'ghost update'
  3. Run "ghost run"

Technical details:

  • Ghost Version: alpha.15
  • Node Version: v6.10.0
  • OS: Debian GNU/Linux 8 (jessie)
  • Database: MariaDB

Log

root@ghost:/var/www/ghost# ghost ls
┌───┬─────────────────────────┬──────┬─────────────┬─────────────────┬────────────────┐
│ # │ Url                     │ Port │ Environment │ Process Manager │ Location       │
├───┼─────────────────────────┼──────┼─────────────┼─────────────────┼────────────────┤
│ 1 │ http://192.168.1.75:80/ │ 80   │ production  │                 │ /var/www/ghost │
└───┴─────────────────────────┴──────┴─────────────┴─────────────────┴────────────────┘
root@ghost:/var/www/ghost# ghost update
 ✔ Checking for latest Ghost version
 ✔ Downloading and updating Ghost to v1.0.0-alpha.15
 ✔ Stopping Ghost
 ✔ Linking things
 ✔ Restarting Ghost
root@ghost:/var/www/ghost# ghost ls
┌───┬─────────────────────────┬──────┬─────────────┬─────────────────┬────────────────┐
│ # │ Url                     │ Port │ Environment │ Process Manager │ Location       │
├───┼─────────────────────────┼──────┼─────────────┼─────────────────┼────────────────┤
│ 1 │ http://192.168.1.75:80/ │ 80   │ production  │                 │ /var/www/ghost │
└───┴─────────────────────────┴──────┴─────────────┴─────────────────┴────────────────┘





root@ghost:/var/www/ghost# ghost stop
✔ Stopping Ghost
root@ghost:/var/www/ghost# ghost run

/usr/local/lib/node_modules/ghost-cli/lib/process/index.js:23
        throw error;
        ^
Please run knex-migrator init
root@ghost:/var/www/ghost# [2017-03-06 21:04:06] ERROR

NAME: DatabaseIsNotOkError
CODE: DB_NOT_INITIALISED
MESSAGE: Please run knex-migrator init

level:normal

If knex-migrator is not installed, please run "npm install -g knex-migrator"
Read more here: https://github.com/TryGhost/knex-migrator
DatabaseIsNotOkError: Please run knex-migrator init
    at DatabaseIsNotOkError.KnexMigrateError (/var/www/ghost/versions/1.0.0-alpha.15/node_modules/knex-migrator/lib/errors.js:7:26)
    at new DatabaseIsNotOkError (/var/www/ghost/versions/1.0.0-alpha.15/node_modules/knex-migrator/lib/errors.js:19:26)
    at /var/www/ghost/versions/1.0.0-alpha.15/node_modules/knex-migrator/lib/index.js:548:19
    at tryCatcher (/var/www/ghost/versions/1.0.0-alpha.15/node_modules/knex-migrator/node_modules/bluebird/js/release/util.js:16:23)
    at Promise._settlePromiseFromHandler (/var/www/ghost/versions/1.0.0-alpha.15/node_modules/knex-migrator/node_modules/bluebird/js/release/promise.js:510:31)
    at Promise._settlePromise (/var/www/ghost/versions/1.0.0-alpha.15/node_modules/knex-migrator/node_modules/bluebird/js/release/promise.js:567:18)
    at Promise._settlePromise0 (/var/www/ghost/versions/1.0.0-alpha.15/node_modules/knex-migrator/node_modules/bluebird/js/release/promise.js:612:10)
    at Promise._settlePromises (/var/www/ghost/versions/1.0.0-alpha.15/node_modules/knex-migrator/node_modules/bluebird/js/release/promise.js:691:18)
    at Promise._fulfill (/var/www/ghost/versions/1.0.0-alpha.15/node_modules/knex-migrator/node_modules/bluebird/js/release/promise.js:636:18)
    at Promise._resolveCallback (/var/www/ghost/versions/1.0.0-alpha.15/node_modules/knex-migrator/node_modules/bluebird/js/release/promise.js:431:57)
    at Promise._settlePromiseFromHandler (/var/www/ghost/versions/1.0.0-alpha.15/node_modules/knex-migrator/node_modules/bluebird/js/release/promise.js:522:17)
    at Promise._settlePromise (/var/www/ghost/versions/1.0.0-alpha.15/node_modules/knex-migrator/node_modules/bluebird/js/release/promise.js:567:18)
    at Promise._settlePromise0 (/var/www/ghost/versions/1.0.0-alpha.15/node_modules/knex-migrator/node_modules/bluebird/js/release/promise.js:612:10)
    at Promise._settlePromises (/var/www/ghost/versions/1.0.0-alpha.15/node_modules/knex-migrator/node_modules/bluebird/js/release/promise.js:691:18)
    at Promise._fulfill (/var/www/ghost/versions/1.0.0-alpha.15/node_modules/knex-migrator/node_modules/bluebird/js/release/promise.js:636:18)
    at PropertiesPromiseArray.PromiseArray._resolve (/var/www/ghost/versions/1.0.0-alpha.15/node_modules/knex-migrator/node_modules/bluebird/js/release/promise_array.js:125:19)
    at PropertiesPromiseArray._promiseFulfilled (/var/www/ghost/versions/1.0.0-alpha.15/node_modules/knex-migrator/node_modules/bluebird/js/release/props.js:78:14)
    at Promise._settlePromise (/var/www/ghost/versions/1.0.0-alpha.15/node_modules/knex-migrator/node_modules/bluebird/js/release/promise.js:572:26)
    at Promise._settlePromise0 (/var/www/ghost/versions/1.0.0-alpha.15/node_modules/knex-migrator/node_modules/bluebird/js/release/promise.js:612:10)
    at Promise._settlePromises (/var/www/ghost/versions/1.0.0-alpha.15/node_modules/knex-migrator/node_modules/bluebird/js/release/promise.js:691:18)
    at Async._drainQueue (/var/www/ghost/versions/1.0.0-alpha.15/node_modules/knex-migrator/node_modules/bluebird/js/release/async.js:138:16)
    at Async._drainQueues (/var/www/ghost/versions/1.0.0-alpha.15/node_modules/knex-migrator/node_modules/bluebird/js/release/async.js:148:10)
    at Immediate.Async.drainQueues (/var/www/ghost/versions/1.0.0-alpha.15/node_modules/knex-migrator/node_modules/bluebird/js/release/async.js:17:14)
    at runCallback (timers.js:651:20)
    at tryOnImmediate (timers.js:624:5)
    at processImmediate [as _immediateCallback] (timers.js:596:5)


root@ghost:~# npm install -g knex-migrator
npm WARN deprecated [email protected]: use uuid module instead
/usr/local/bin/knex-migrator -> /usr/local/lib/node_modules/knex-migrator/bin/knex-migrator
/usr/local/bin/knex-migrator-init -> /usr/local/lib/node_modules/knex-migrator/bin/knex-migrator-init
/usr/local/bin/knex-migrator-health -> /usr/local/lib/node_modules/knex-migrator/bin/knex-migrator-health
/usr/local/bin/knex-migrator-migrate -> /usr/local/lib/node_modules/knex-migrator/bin/knex-migrator-migrate
/usr/local/bin/knex-migrator-reset -> /usr/local/lib/node_modules/knex-migrator/bin/knex-migrator-reset

> [email protected] install /usr/local/lib/node_modules/knex-migrator/node_modules/sqlite3
> node-pre-gyp install --fallback-to-build

node-pre-gyp ERR! Tried to download(undefined): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.8/node-v48-linux-ia32.tar.gz
node-pre-gyp ERR! Pre-built binaries not found for [email protected] and [email protected] (node-v48 ABI) (falling back to source compile with node-gyp)
gyp WARN EACCES user "root" does not have permission to access the dev dir "/root/.node-gyp/6.10.0"
gyp WARN EACCES attempting to reinstall using temporary dev dir "/usr/local/lib/node_modules/knex-migrator/node_modules/sqlite3/.node-gyp"
gyp WARN install got an error, rolling back install
gyp WARN install got an error, rolling back install
gyp ERR! configure error
gyp ERR! stack Error: This is most likely not a problem with node-gyp or the package itself and
gyp ERR! stack is related to network connectivity. In most cases you are behind a proxy or have bad
gyp ERR! stack network settings.
gyp ERR! stack     at Request.<anonymous> (/usr/local/lib/node_modules/npm/node_modules/node-gyp/lib/install.js:193:21)
gyp ERR! stack     at emitOne (events.js:96:13)
gyp ERR! stack     at Request.emit (events.js:188:7)
gyp ERR! stack     at Request.onRequestError (/usr/local/lib/node_modules/npm/node_modules/request/request.js:813:8)
gyp ERR! stack     at emitOne (events.js:96:13)
gyp ERR! stack     at ClientRequest.emit (events.js:188:7)
gyp ERR! stack     at TLSSocket.socketErrorListener (_http_client.js:310:9)
gyp ERR! stack     at emitOne (events.js:96:13)
gyp ERR! stack     at TLSSocket.emit (events.js:188:7)
gyp ERR! stack     at connectErrorNT (net.js:1022:8)
gyp ERR! System Linux 3.16.0-4-586
gyp ERR! command "/usr/local/bin/node" "/usr/local/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js" "configure" "--fallback-to-build" "--module=/usr/local/lib/node_modules/knex-migrator/node_modules/sqlite3/lib/binding/node-v48-linux-ia32/node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=/usr/local/lib/node_modules/knex-migrator/node_modules/sqlite3/lib/binding/node-v48-linux-ia32"
gyp ERR! cwd /usr/local/lib/node_modules/knex-migrator/node_modules/sqlite3
gyp ERR! node -v v6.10.0
gyp ERR! node-gyp -v v3.4.0
gyp ERR! not ok
node-pre-gyp ERR! build error
node-pre-gyp ERR! stack Error: Failed to execute '/usr/local/bin/node /usr/local/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js configure --fallback-to-build --module=/usr/local/lib/node_modules/knex-migrator/node_modules/sqlite3/lib/binding/node-v48-linux-ia32/node_sqlite3.node --module_name=node_sqlite3 --module_path=/usr/local/lib/node_modules/knex-migrator/node_modules/sqlite3/lib/binding/node-v48-linux-ia32' (1)
node-pre-gyp ERR! stack     at ChildProcess.<anonymous> (/usr/local/lib/node_modules/knex-migrator/node_modules/sqlite3/node_modules/node-pre-gyp/lib/util/compile.js:83:29)
node-pre-gyp ERR! stack     at emitTwo (events.js:106:13)
node-pre-gyp ERR! stack     at ChildProcess.emit (events.js:191:7)
node-pre-gyp ERR! stack     at maybeClose (internal/child_process.js:877:16)
node-pre-gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:226:5)
node-pre-gyp ERR! System Linux 3.16.0-4-586
node-pre-gyp ERR! command "/usr/local/bin/node" "/usr/local/lib/node_modules/knex-migrator/node_modules/sqlite3/node_modules/.bin/node-pre-gyp" "install" "--fallback-to-build"
node-pre-gyp ERR! cwd /usr/local/lib/node_modules/knex-migrator/node_modules/sqlite3
node-pre-gyp ERR! node -v v6.10.0
node-pre-gyp ERR! node-pre-gyp -v v0.6.31
node-pre-gyp ERR! not ok
Failed to execute '/usr/local/bin/node /usr/local/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js configure --fallback-to-build --module=/usr/local/lib/node_modules/knex-migrator/node_modules/sqlite3/lib/binding/node-v48-linux-ia32/node_sqlite3.node --module_name=node_sqlite3 --module_path=/usr/local/lib/node_modules/knex-migrator/node_modules/sqlite3/lib/binding/node-v48-linux-ia32' (1)
/usr/local/lib
└── [email protected]

npm WARN optional SKIPPING OPTIONAL DEPENDENCY: [email protected] (node_modules/knex-migrator/node_modules/sqlite3):
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: [email protected] install: `node-pre-gyp install --fallback-to-build`
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: Exit status 1
picture PaszaVonPomiot

Most helpful comment

@kirrg001 I'm glad you have that under control. No worries - I'm testing the alpha just to provide you feedback. Keep up good work! :+1:

picture PaszaVonPomiot on 6 Mar 2017
👍2 ❤1 😄1

All 2 comments

Hey @draconus Sorry to hear you are having trouble.

This is a known issue. We have changed the database migrations in alpha.15. The Ghost CLI does not reset the database and that's why people experience this error.

As the alpha release is for development purpose only, you could either call knex-migrator reset && knex-migrator init to start from scratch or you could delete the third row of the migrations table (3-insert-settings.js).

Thanks for testing the alpha, good luck and swing by our slack channel if you need any help 👍

kirrg001 picture kirrg001 on 6 Mar 2017

@kirrg001 I'm glad you have that under control. No worries - I'm testing the alpha just to provide you feedback. Keep up good work! :+1:

PaszaVonPomiot picture PaszaVonPomiot on 6 Mar 2017
👍2 ❤1 😄1
Was this page helpful?
0 / 5 - 0 ratings

Related issues

krokofant picture krokofant  ·  3Comments
marcuspoehls picture marcuspoehls  ·  4Comments
jgreenemi picture jgreenemi  ·  4Comments
fueko picture fueko  ·  3Comments
kirrg001 picture kirrg001  ·  3Comments