· 8 years ago · Mar 05, 2018, 11:02 AM
1[root@ipevpetxnas01 ~]# docker exec -it rubyapp bundle exec hanami db migrate
2[hanami] [INFO] (0.000442s) SET standard_conforming_strings = ON
3[hanami] [INFO] (0.000169s) SET client_min_messages = 'WARNING'
4[hanami] [INFO] (0.000152s) SET DateStyle = 'ISO'
5[hanami] [ERROR] PG::UndefinedTable: ERROR: relation "schema_migrations" does not exist
6LINE 1: SELECT NULL AS "nil" FROM "schema_migrations" LIMIT 1
7 ^: SELECT NULL AS "nil" FROM "schema_migrations" LIMIT 1
8[hanami] [INFO] (0.008338s) CREATE TABLE "schema_migrations" ("filename" text PRIMARY KEY)
9[hanami] [ERROR] PG::UndefinedTable: ERROR: relation "schema_info" does not exist
10LINE 1: SELECT NULL AS "nil" FROM "schema_info" LIMIT 1
11 ^: SELECT NULL AS "nil" FROM "schema_info" LIMIT 1
12[hanami] [INFO] (0.001104s) SELECT "filename" FROM "schema_migrations" ORDER BY "filename"
13[hanami] [INFO] Begin applying migration 20170403091442_create_items.rb, direction: up
14[hanami] [INFO] (0.000204s) BEGIN
15[hanami] [INFO] (0.000139s) SAVEPOINT autopoint_1
16[hanami] [ERROR] PG::UndefinedTable: ERROR: relation "fias_items" does not exist
17LINE 1: SELECT NULL AS "nil" FROM "fias_items" LIMIT 1
18 ^: SELECT NULL AS "nil" FROM "fias_items" LIMIT 1
19[hanami] [INFO] (0.000151s) ROLLBACK TO SAVEPOINT autopoint_1
20[hanami] [INFO] (0.015218s) --
21-- Name: fias_items; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
22--
23
24CREATE TABLE IF NOT EXISTS fias_items (
25 actstatus integer,
26 aoguid uuid,
27 aoid uuid NOT NULL,
28 aolevel integer,
29 areacode character varying(3),
30 autocode character varying(1),
31 centstatus integer,
32 citycode character varying(3),
33 code character varying(17),
34 currstatus integer,
35 livestatus integer,
36 startdate date,
37 enddate date,
38 updatedate date,
39 formalname text,
40 offname text,
41 ifnsfl character varying(4),
42 ifnsul character varying(4),
43 nextid character varying(36),
44 previd character varying(36),
45 okato character varying(11),
46 oktmo character varying(11),
47 operstatus integer,
48 parentguid character varying(36),
49 placecode character varying(3),
50 plaincode character varying(15),
51 postalcode character varying(6),
52 regioncode character varying(2),
53 shortname character varying(255),
54 streetcode character varying(4),
55 terrifnsfl character varying(4),
56 terrifnsul character varying(4),
57 ctarcode character varying(3),
58 extrcode character varying(4),
59 sextcode character varying(3),
60 normdoc character varying(36),
61 full_name text,
62 prefixed_name text,
63 cadnum character varying(255),
64 divtype integer,
65 housenum character varying(20),
66 buildnum character varying(10),
67 strucnum character varying(10),
68 plancode character varying(4)
69);
70
71--
72-- Name: composite_fias_code_index; Type: INDEX; Schema: public; Owner:
73-- postgres; Tablespace:
74--
75
76CREATE INDEX composite_fias_code_index ON fias_items USING btree (regioncode, autocode, areacode, citycode, ctarcode, placecode, streetcode, extrcode, sextcode);
77
78
79--
80-- Name: index_fias_items_on_aoguid; Type: INDEX; Schema: public; Owner:
81-- postgres; Tablespace:
82--
83
84CREATE INDEX index_fias_items_on_aoguid ON fias_items USING btree (aoguid);
85
86
87--
88-- Name: index_fias_items_on_aoid; Type: INDEX; Schema: public; Owner: postgres;
89-- Tablespace:
90--
91
92CREATE UNIQUE INDEX index_fias_items_on_aoid ON fias_items USING btree (aoid);
93
94
95--
96-- Name: index_fias_items_on_aolevel; Type: INDEX; Schema: public; Owner:
97-- postgres; Tablespace:
98--
99
100CREATE INDEX index_fias_items_on_aolevel ON fias_items USING btree (aolevel);
101
102
103--
104-- Name: index_fias_items_on_okato; Type: INDEX; Schema: public; Owner:
105-- postgres; Tablespace:
106--
107
108CREATE INDEX index_fias_items_on_okato ON fias_items USING btree (okato);
109
110
111--
112-- Name: index_fias_items_on_parentguid; Type: INDEX; Schema: public; Owner:
113-- postgres; Tablespace:
114--
115
116CREATE INDEX index_fias_items_on_parentguid ON fias_items USING btree (parentguid);
117
118[hanami] [INFO] (0.002041s) SELECT pg_attribute.attname AS pk FROM pg_class, pg_attribute, pg_index, pg_namespace WHERE pg_class.oid = pg_attribute.attrelid AND pg_class.relnamespace = pg_namespace.oid AND pg_class.oid = pg_index.indrelid AND pg_index.indkey[0] = pg_attribute.attnum AND pg_index.indisprimary = 't' AND pg_class.oid = CAST(CAST('"schema_migrations"' AS regclass) AS oid)
119[hanami] [INFO] (0.000514s) INSERT INTO "schema_migrations" ("filename") VALUES ('20170403091442_create_items.rb') RETURNING "filename"
120[hanami] [INFO] (0.000871s) COMMIT
121[hanami] [INFO] Finished applying migration 20170403091442_create_items.rb, direction: up, took 0.022322 seconds
122[hanami] [INFO] Begin applying migration 20170403093627_add_primary_key_to_fias_items.rb, direction: up
123[hanami] [INFO] (0.000242s) BEGIN
124[hanami] [INFO] (0.000319s) INSERT INTO "schema_migrations" ("filename") VALUES ('20170403093627_add_primary_key_to_fias_items.rb') RETURNING "filename"
125[hanami] [INFO] (0.000532s) COMMIT
126[hanami] [INFO] Finished applying migration 20170403093627_add_primary_key_to_fias_items.rb, direction: up, took 0.001683 seconds