hackmdio
type "public.enum_Notes_permission" does not exist
After I followed the instructions in README installation.
I got the follow error: type "public.enum_Notes_permission" does not exist .
docker-compose up
docker-hackmd_database_1 is up-to-date
docker-hackmd_app_1 is up-to-date
Attaching to docker-hackmd_database_1, docker-hackmd_app_1
database_1 | The files belonging to this database system will be owned by user "postgres".
database_1 | This user must also own the server process.
database_1 |
database_1 | The database cluster will be initialized with locale "en_US.utf8".
database_1 | The default database encoding has accordingly been set to "UTF8".
database_1 | The default text search configuration will be set to "english".
database_1 |
database_1 | Data page checksums are disabled.
database_1 |
database_1 | fixing permissions on existing directory /var/lib/postgresql/data ... ok
database_1 | creating subdirectories ... ok
database_1 | selecting default max_connections ... 100
database_1 | selecting default shared_buffers ... 128MB
database_1 | selecting dynamic shared memory implementation ... posix
database_1 | creating configuration files ... ok
database_1 | running bootstrap script ... ok
database_1 | sh: locale: not found
database_1 | performing post-bootstrap initialization ... No usable system locales were found.
database_1 | Use the option "--debug" to see details.
database_1 | ok
database_1 | syncing data to disk ... ok
database_1 |
database_1 | WARNING: enabling "trust" authentication for local connections
database_1 | You can change this by editing pg_hba.conf or using the option -A, or
database_1 | --auth-local and --auth-host, the next time you run initdb.
database_1 |
database_1 | Success. You can now start the database server using:
database_1 |
database_1 | pg_ctl -D /var/lib/postgresql/data -l logfile start
database_1 |
database_1 | waiting for server to start....LOG: database system was shut down at 2019-04-05 13:42:22 UTC
database_1 | LOG: MultiXact member wraparound protections are now enabled
database_1 | LOG: database system is ready to accept connections
database_1 | LOG: autovacuum launcher started
database_1 | done
database_1 | server started
database_1 | CREATE DATABASE
database_1 |
database_1 |
database_1 | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
database_1 |
database_1 | LOG: received fast shutdown request
database_1 | LOG: aborting any active transactions
database_1 | LOG: autovacuum launcher shutting down
database_1 | LOG: shutting down
database_1 | waiting for server to shut down....LOG: database system is shut down
database_1 | done
database_1 | server stopped
database_1 |
database_1 | PostgreSQL init process complete; ready for start up.
database_1 |
database_1 | LOG: database system was shut down at 2019-04-05 13:42:24 UTC
database_1 | LOG: MultiXact member wraparound protections are now enabled
database_1 | LOG: database system is ready to accept connections
database_1 | LOG: autovacuum launcher started
database_1 | LOG: incomplete startup packet
database_1 | ERROR: type "public.enum_Notes_permission" does not exist at character 345
database_1 | STATEMENT: ALTER TABLE "Notes" ALTER COLUMN "permission" DROP NOT NULL;ALTER TABLE "Notes" ALTER COLUMN "permission" DROP DEFAULT;CREATE TYPE "public"."enum_Notes_permission" AS ENUM('freely', 'editable', 'limited', 'locked', 'protected', 'private');ALTER TABLE "Notes" ALTER COLUMN "permission" TYPE "public"."enum_Notes_permission" USING ("permission"::"public.enum_Notes_permission");
app_1 | 2019/04/05 13:42:20 Waiting for: tcp://database:5432
app_1 | 2019/04/05 13:42:20 Problem with dial: dial tcp 172.18.0.2:5432: connect: connection refused. Sleeping 1s
app_1 | 2019/04/05 13:42:21 Problem with dial: dial tcp 172.18.0.2:5432: connect: connection refused. Sleeping 1s
app_1 | 2019/04/05 13:42:22 Problem with dial: dial tcp 172.18.0.2:5432: connect: connection refused. Sleeping 1s
app_1 | 2019/04/05 13:42:23 Problem with dial: dial tcp 172.18.0.2:5432: connect: connection refused. Sleeping 1s
app_1 | 2019/04/05 13:42:24 Problem with dial: dial tcp 172.18.0.2:5432: connect: connection refused. Sleeping 1s
app_1 | 2019/04/05 13:42:25 Connected to tcp://database:5432
app_1 |
app_1 | Sequelize [Node: 8.12.0, CLI: 2.8.0, ORM: 3.30.4]
app_1 |
app_1 | Parsed url postgres://hackmd:*****@database:5432/hackmd
app_1 | (node:24) DeprecationWarning: Using the automatically created return value from client.query as an event emitter is deprecated and will be removed in [email protected]. Please see the upgrade guide at https://node-postgres.com/guides/upgrading
app_1 | == 20150504155329-create-users: migrating =======
app_1 | == 20150504155329-create-users: migrated (0.027s)
app_1 | == 20150508114741-create-notes: migrating =======
app_1 | == 20150508114741-create-notes: migrated (0.016s)
app_1 | == 20150515125813-create-temp: migrating =======
app_1 | == 20150515125813-create-temp: migrated (0.014s)
app_1 | == 20150702001020-update-to-0_3_1: migrating =======
app_1 | == 20150702001020-update-to-0_3_1: migrated (0.039s)
app_1 | == 20150915153700-change-notes-title-to-text: migrating =======
app_1 | == 20150915153700-change-notes-title-to-text: migrated (0.009s)
app_1 | == 20160112220142-note-add-lastchange: migrating =======
app_1 | == 20160112220142-note-add-lastchange: migrated (0.720s)
app_1 | == 20160420180355-note-add-alias: migrating =======
app_1 | == 20160420180355-note-add-alias: migrated (0.526s)
app_1 | == 20160515114000-user-add-tokens: migrating =======
app_1 | == 20160515114000-user-add-tokens: migrated (0.010s)
app_1 | == 20160607060246-support-revision: migrating =======
app_1 | == 20160607060246-support-revision: migrated (0.025s)
app_1 | == 20160703062241-support-authorship: migrating =======
app_1 | == 20160703062241-support-authorship: migrated (0.018s)
app_1 | == 20161009040430-support-delete-note: migrating =======
app_1 | == 20161009040430-support-delete-note: migrated (0.008s)
app_1 | == 20161201050312-support-email-signin: migrating =======
app_1 | == 20161201050312-support-email-signin: migrated (0.010s)
app_1 | == 20171009121200-longtext-for-mysql: migrating =======
app_1 | >> WARNING: PostgreSQL does not support TEXT with options. Plain TEXT will be used instead.
app_1 | >> Check: http://www.postgresql.org/docs/9.4/static/datatype.html
app_1 | == 20171009121200-longtext-for-mysql: migrated (0.031s)
app_1 | == 20180209120907-longtext-of-authorship: migrating =======
app_1 | == 20180209120907-longtext-of-authorship: migrated (0.009s)
app_1 | == 20180306150303-fix-enum: migrating =======
app_1 | Unhandled rejection SequelizeDatabaseError: type "public.enum_Notes_permission" does not exist
app_1 | at Query.formatError (/hackmd/node_modules/sequelize/lib/dialects/postgres/query.js:357:14)
app_1 | at Result.sessionSecret in your config.js file. All users will be logged out.
app_1 | (node:1) DeprecationWarning: Using the automatically created return value from client.query as an event emitter is deprecated and will be removed in [email protected]. Please see the upgrade guide at https://node-postgres.com/guides/upgrading
app_1 | >> WARNING: PostgreSQL does not support TEXT with options. Plain TEXT will be used instead.
app_1 | >> Check: http://www.postgresql.org/docs/9.4/static/datatype.html
app_1 | 2019-04-05T13:42:33.446Z - info: HTTP Server listening at port 3000
