Advertisement
Guest User

Untitled

a guest
Sep 19th, 2018
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.87 KB | None | 0 0
  1. shell% ./bin/reset_db
  2. +++ dirname ./bin/reset_db
  3. ++ cd ./bin
  4. ++ cd ..
  5. ++ pwd
  6. + PARENT_DIR=/home/uni/Project/school_life/db
  7. + DUMPFILE=
  8. + psql -h 127.0.0.1 --username=postgres -c 'drop database school_life_development'
  9. DROP DATABASE
  10. + psql -h 127.0.0.1 --username=postgres -c 'create database school_life_development'
  11. CREATE DATABASE
  12. + gzip -cd
  13. + psql -h 127.0.0.1 --username=postgres school_life_development
  14. gzip: compressed data not read from a terminal. Use -f to force decompression.
  15. For help, type: gzip -h
  16. + bin/flyway migrate
  17. Flyway 4.2.0 by Boxfuse
  18.  
  19. Database: jdbc:postgresql://127.0.0.1:5432/school_life_development (PostgreSQL 9.6)
  20. Successfully validated 102 migrations (execution time 00:00.039s)
  21. Creating Metadata table: "public"."schema_version"
  22. Current version of schema "public": << Empty Schema >>
  23. Migrating schema "public" to version 20171026192738 - create id generator function
  24. Migrating schema "public" to version 20171026192739 - create bitemporal op function
  25. Migrating schema "public" to version 20171026193836 - create user table
  26. ERROR: Migration of schema "public" to version 20171026193836 - create user table failed! Changes successfully rolled back.
  27. ERROR:
  28. Migration V20171026193836__create_user_table.sql failed
  29. -------------------------------------------------------
  30. SQL State : 3F000
  31. Error Code : 0
  32. Message : ERROR: スキーマ"bitemporal_internal"は存在しません
  33. Position: 8
  34. Location : /home/uni/Project/school_life/db/lib/flyway-4.2.0/sql/V20171026193836__create_user_table.sql (/home/uni/Project/school_life/db/lib/flyway-4.2.0/sql/V20171026193836__create_user_table.sql)
  35. Line : 16
  36. Statement : SELECT bitemporal_internal.ll_create_bitemporal_table(
  37. 'public',
  38. '_user',
  39. 'id BIGINT NOT NULL DEFAULT id_generator(),
  40. _user_id BIGINT NOT NULL DEFAULT 0,
  41. _source JSONB,
  42. name VARCHAR(256) NOT NULL',
  43. 'id'
  44. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement