Skip to content
This repository has been archived by the owner on Nov 15, 2019. It is now read-only.

type "public.enum_Notes_permission" does not exist #68

Open
junlicn opened this issue Apr 6, 2019 · 0 comments
Open

type "public.enum_Notes_permission" does not exist #68

junlicn opened this issue Apr 6, 2019 · 0 comments

Comments

@junlicn
Copy link

junlicn commented Apr 6, 2019

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. (/hackmd/node_modules/sequelize/lib/dialects/postgres/query.js:88:19)
app_1 | at emitOne (events.js:116:13)
app_1 | at Result.emit (events.js:211:7)
app_1 | at Result.Query.handleError (/hackmd/node_modules/pg/lib/query.js:163:8)
app_1 | at Client. (/hackmd/node_modules/pg/lib/client.js:188:26)
app_1 | at emitOne (events.js:116:13)
app_1 | at Connection.emit (events.js:211:7)
app_1 | at Socket. (/hackmd/node_modules/pg/lib/connection.js:133:12)
app_1 | at emitOne (events.js:116:13)
app_1 | at Socket.emit (events.js:211:7)
app_1 | at addChunk (_stream_readable.js:263:12)
app_1 | at readableAddChunk (_stream_readable.js:250:11)
app_1 | at Socket.Readable.push (_stream_readable.js:208:10)
app_1 | at TCP.onread (net.js:601:20)
app_1 | == 20180306150303-fix-enum: migrated (0.014s)
app_1 | == 20180326103000-use-text-in-tokens: migrating =======
app_1 | == 20180326103000-use-text-in-tokens: migrated (0.010s)
app_1 | == 20180525153000-user-add-delete-token: migrating =======
app_1 | == 20180525153000-user-add-delete-token: migrated (0.008s)
app_1 | 2019-04-05T13:42:32.200Z - warn: Using legacy HMD prefix for environment variables. Please change your variables in future. For details see: https://github.com/hackmdio/codimd#environment-variables-will-overwrite-other-server-configs
app_1 | 2019-04-05T13:42:32.202Z - warn: Session secret not set. Using random generated one. Please set 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

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant