· 7 years ago · Mar 06, 2018, 01:00 PM
1javascripts stylesheets
2deploy@ip-172-31-3-200:~/peatio/vendor/assets$ bundle exec rake db:setup
3(in /home/deploy/peatio)
4/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/figaro-1.1.1/lib/figaro/application.rb:84:in `non_string_configuration!' : WARNING: Use strings for Figaro configuration. false was converted to "false". (StructuredWarnings::StandardWarning)Access denied for user 'root'@'localhost' (using password: NO)Please provide the root password for your MySQL installation
5>I<3ella
6Mysql2::Error: Can't create database 'peatio_production'; database exists: CREATE DATABASE `peatio_production` DEFAULT CHARACTER SET `utf8` COLLATE `utf8_unicode_ci`
7/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/mysql2-0.3.21/lib/mysql2/client.rb:80:in `_query'
8/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/mysql2-0.3.21/lib/mysql2/client.rb:80:in `block in query'
9/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/mysql2-0.3.21/lib/mysql2/client.rb:79:in `handle_interrupt'
10/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/mysql2-0.3.21/lib/mysql2/client.rb:79:in `query'
11/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:317:in `block in execute'
12/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract_adapter.rb:484:in `block in log'
13/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/activesupport-4.2.10/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
14/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract_adapter.rb:478:in `log'
15/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:317:in `execute'
16/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/mysql2_adapter.rb:217:in `execute'
17/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:385:in `create_database'
18/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/activerecord-4.2.10/lib/active_record/tasks/mysql_database_tasks.rb:28:in `rescue in create'
19/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/activerecord-4.2.10/lib/active_record/tasks/mysql_database_tasks.rb:14:in `create'
20/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/activerecord-4.2.10/lib/active_record/tasks/database_tasks.rb:93:in `create'
21/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/activerecord-4.2.10/lib/active_record/tasks/database_tasks.rb:107:in `block in create_current'
22/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/activerecord-4.2.10/lib/active_record/tasks/database_tasks.rb:278:in `block in each_current_configuration'
23/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/activerecord-4.2.10/lib/active_record/tasks/database_tasks.rb:277:in `each'
24/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/activerecord-4.2.10/lib/active_record/tasks/database_tasks.rb:277:in `each_current_configuration'
25/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/activerecord-4.2.10/lib/active_record/tasks/database_tasks.rb:106:in `create_current'
26/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/activerecord-4.2.10/lib/active_record/railties/databases.rake:17:in `block (2 levels) in <top (required)>'
27/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/task.rb:251:in `block in execute'
28/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/task.rb:251:in `each'
29/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/task.rb:251:in `execute'
30/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/task.rb:195:in `block in invoke_with_call_chain'
31/home/deploy/.rbenv/versions/2.5.0/lib/ruby/2.5.0/monitor.rb:226:in `mon_synchronize'
32/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/task.rb:188:in `invoke_with_call_chain'
33/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/task.rb:217:in `block in invoke_prerequisites'
34/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/task.rb:215:in `each'
35/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/task.rb:215:in `invoke_prerequisites'
36/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/task.rb:194:in `block in invoke_with_call_chain'
37/home/deploy/.rbenv/versions/2.5.0/lib/ruby/2.5.0/monitor.rb:226:in `mon_synchronize'
38/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/task.rb:188:in `invoke_with_call_chain'
39/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/task.rb:217:in `block in invoke_prerequisites'
40/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/task.rb:215:in `each'
41/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/task.rb:215:in `invoke_prerequisites'
42/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/task.rb:194:in `block in invoke_with_call_chain'
43/home/deploy/.rbenv/versions/2.5.0/lib/ruby/2.5.0/monitor.rb:226:in `mon_synchronize'
44/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/task.rb:188:in `invoke_with_call_chain'
45/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/task.rb:181:in `invoke'
46/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/application.rb:160:in `invoke_task'
47/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/application.rb:116:in `block (2 levels) in top_level'
48/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/application.rb:116:in `each'
49/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/application.rb:116:in `block in top_level'
50/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/application.rb:125:in `run_with_threads'
51/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/application.rb:110:in `top_level'
52/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/application.rb:83:in `block in run'
53/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/application.rb:186:in `standard_exception_handling'
54/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/lib/rake/application.rb:80:in `run'
55/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/rake-12.3.0/exe/rake:27:in `<top (required)>'
56/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/redis-rack-2.0.3/bin/rake:17:in `load'
57/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/redis-rack-2.0.3/bin/rake:17:in `<top (required)>'
58/home/deploy/.rbenv/versions/2.5.0/bin/rake:23:in `load'
59/home/deploy/.rbenv/versions/2.5.0/bin/rake:23:in `<top (required)>'
60/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/bundler-1.16.1/lib/bundler/cli/exec.rb:75:in `load'
61/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/bundler-1.16.1/lib/bundler/cli/exec.rb:75:in `kernel_load'
62/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/bundler-1.16.1/lib/bundler/cli/exec.rb:28:in `run'
63/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/bundler-1.16.1/lib/bundler/cli.rb:424:in `exec'
64/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/bundler-1.16.1/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run'
65/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/bundler-1.16.1/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command'
66/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/bundler-1.16.1/lib/bundler/vendor/thor/lib/thor.rb:387:in `dispatch'
67/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/bundler-1.16.1/lib/bundler/cli.rb:27:in `dispatch'
68/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/bundler-1.16.1/lib/bundler/vendor/thor/lib/thor/base.rb:466:in `start'
69/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/bundler-1.16.1/lib/bundler/cli.rb:18:in `start'
70/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/bundler-1.16.1/exe/bundle:30:in `block in <top (required)>'
71/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/bundler-1.16.1/lib/bundler/friendly_errors.rb:122:in `with_friendly_errors'
72/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/bundler-1.16.1/exe/bundle:22:in `<top (required)>'
73/home/deploy/.rbenv/versions/2.5.0/bin/bundle:23:in `load'
74/home/deploy/.rbenv/versions/2.5.0/bin/bundle:23:in `<main>'
75Couldn't create database for {"adapter"=>"mysql2", "encoding"=>"utf8", "pool"=>10, "host"=>nil, "username"=>nil, "password"=>nil, "url"=>nil, "database"=>"peatio_production"}
76rake aborted!
77Errno::ENOENT: No such file or directory @ dir_chdir - vendor/assets/yarn_components
78/home/deploy/peatio/config/initializers/assets.rb:29:in `chdir'
79/home/deploy/peatio/config/initializers/assets.rb:29:in `<top (required)>'
80/home/deploy/peatio/config/environment.rb:5:in `<top (required)>'
81/home/deploy/.rbenv/versions/2.5.0/bin/bundle:23:in `load'
82/home/deploy/.rbenv/versions/2.5.0/bin/bundle:23:in `<main>'
83Tasks: TOP => db:setup => db:schema:load_if_ruby => environment
84(See full trace by running task with --trace)
85deploy@ip-172-31-3-200:~/peatio/vendor/assets$
86deploy@ip-172-31-3-200:~/peatio/vendor/assets$ ls
87javascripts stylesheets
88deploy@ip-172-31-3-200:~/peatio/vendor/assets$ cd ..
89deploy@ip-172-31-3-200:~/peatio/vendor$ ls
90assets plugins
91deploy@ip-172-31-3-200:~/peatio/vendor$ cd ..
92deploy@ip-172-31-3-200:~/peatio$ ls
93app CHANGELOG.md config db docs Gemfile.lock LICENSE.md package.json public README.md vendor yarn.lock
94bin ci config.ru Dockerfile Gemfile lib Makefile package-lock.json Rakefile spec VERSION
95deploy@ip-172-31-3-200:~/peatio$ nano config/da
96daemons.yml database.yml
97deploy@ip-172-31-3-200:~/peatio$ nano config/da
98daemons.yml database.yml
99deploy@ip-172-31-3-200:~/peatio$ nano config/da
100daemons.yml database.yml
101deploy@ip-172-31-3-200:~/peatio$ nano config/database.yml
102deploy@ip-172-31-3-200:~/peatio$ cd config/
103deploy@ip-172-31-3-200:~/peatio/config$ mv database.yml database.yml_bak
104deploy@ip-172-31-3-200:~/peatio/config$ cp ../../peatio_old/current/config/database.yml .
105deploy@ip-172-31-3-200:~/peatio/config$ nano database.yml
106deploy@ip-172-31-3-200:~/peatio/config$ cd ..
107deploy@ip-172-31-3-200:~/peatio$ bundle exec rake db:setup
108/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/figaro-1.1.1/lib/figaro/application.rb:84:in `non_string_configuration!' : WARNING: Use strings for Figaro configuration. false was converted to "false". (StructuredWarnings::StandardWarning)rake aborted!
109Errno::ENOENT: No such file or directory @ dir_chdir - vendor/assets/yarn_components
110/home/deploy/peatio/config/initializers/assets.rb:29:in `chdir'
111/home/deploy/peatio/config/initializers/assets.rb:29:in `<top (required)>'
112/home/deploy/peatio/config/environment.rb:5:in `<top (required)>'
113/home/deploy/.rbenv/versions/2.5.0/bin/bundle:23:in `load'
114/home/deploy/.rbenv/versions/2.5.0/bin/bundle:23:in `<main>'
115Tasks: TOP => db:setup => db:schema:load_if_ruby => environment
116(See full trace by running task with --trace)
117deploy@ip-172-31-3-200:~/peatio$ ^C
118deploy@ip-172-31-3-200:~/peatio$ ls
119app CHANGELOG.md config db docs Gemfile.lock LICENSE.md package.json public README.md vendor yarn.lock
120bin ci config.ru Dockerfile Gemfile lib Makefile package-lock.json Rakefile spec VERSION
121deploy@ip-172-31-3-200:~/peatio$ cd ..
122deploy@ip-172-31-3-200:~$ ls
123peatio peatio_old
124deploy@ip-172-31-3-200:~$ cd peatio
125deploy@ip-172-31-3-200:~/peatio$ cd ..
126deploy@ip-172-31-3-200:~$ cd peatio_old/
127deploy@ip-172-31-3-200:~/peatio_old$ ls
128current
129deploy@ip-172-31-3-200:~/peatio_old$ cd current/
130deploy@ip-172-31-3-200:~/peatio_old/current$ ls
131app bin CHANGELOG.md config config.ru db doc eth Gemfile Gemfile.lock lib log public Rakefile README.md script spec tmp vendor
132deploy@ip-172-31-3-200:~/peatio_old/current$ cd vendor/assets/
133deploy@ip-172-31-3-200:~/peatio_old/current/vendor/assets$ ls
134javascripts stylesheets
135deploy@ip-172-31-3-200:~/peatio_old/current/vendor/assets$ ls -la
136total 16
137drwxrwxr-x 4 deploy deploy 4096 Mar 4 15:34 .
138drwxrwxr-x 5 deploy deploy 4096 Mar 4 15:34 ..
139drwxrwxr-x 3 deploy deploy 4096 Mar 4 15:34 javascripts
140drwxrwxr-x 3 deploy deploy 4096 Mar 4 15:34 stylesheets
141deploy@ip-172-31-3-200:~/peatio_old/current/vendor/assets$ cd
142deploy@ip-172-31-3-200:~$ cd peatio
143deploy@ip-172-31-3-200:~/peatio$ bundle exec rake tmp:create yarn:install
144/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/figaro-1.1.1/lib/figaro/application.rb:84:in `non_string_configuration!' : WARNING: Use strings for Figaro configuration. false was converted to "false". (StructuredWarnings::StandardWarning)mkdir -p tmp/sessions
145mkdir -p tmp/cache
146mkdir -p tmp/sockets
147mkdir -p tmp/pids
148mkdir -p tmp/cache/assets/development
149mkdir -p tmp/cache/assets/test
150mkdir -p tmp/cache/assets/production
151deploy@ip-172-31-3-200:~/peatio$ bundle exec rake db:setup
152/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/figaro-1.1.1/lib/figaro/application.rb:84:in `non_string_configuration!' : WARNING: Use strings for Figaro configuration. false was converted to "false". (StructuredWarnings::StandardWarning)exchange_production_new already exists
153rake aborted!
154Errno::ENOENT: No such file or directory @ dir_chdir - vendor/assets/yarn_components
155/home/deploy/peatio/config/initializers/assets.rb:29:in `chdir'
156/home/deploy/peatio/config/initializers/assets.rb:29:in `<top (required)>'
157/home/deploy/peatio/config/environment.rb:5:in `<top (required)>'
158/home/deploy/.rbenv/versions/2.5.0/bin/bundle:23:in `load'
159/home/deploy/.rbenv/versions/2.5.0/bin/bundle:23:in `<main>'
160Tasks: TOP => db:setup => db:schema:load_if_ruby => environment
161(See full trace by running task with --trace)
162deploy@ip-172-31-3-200:~/peatio$ npm install -g yarn
163npm WARN checkPermissions Missing write access to /usr/lib/node_modules
164/usr/lib
165└── yarn@1.5.1
166
167npm ERR! Linux 4.4.0-1049-aws
168npm ERR! argv "/usr/bin/node" "/usr/bin/npm" "install" "-g" "yarn"
169npm ERR! node v6.13.0
170npm ERR! npm v3.10.10
171npm ERR! path /usr/lib/node_modules
172npm ERR! code EACCES
173npm ERR! errno -13
174npm ERR! syscall access
175
176npm ERR! Error: EACCES: permission denied, access '/usr/lib/node_modules'
177npm ERR! at Error (native)
178npm ERR! { Error: EACCES: permission denied, access '/usr/lib/node_modules'
179npm ERR! at Error (native)
180npm ERR! errno: -13,
181npm ERR! code: 'EACCES',
182npm ERR! syscall: 'access',
183npm ERR! path: '/usr/lib/node_modules' }
184npm ERR!
185npm ERR! Please try running this command again as root/Administrator.
186
187npm ERR! Please include the following file with any support request:
188npm ERR! /home/deploy/peatio/npm-debug.log
189deploy@ip-172-31-3-200:~/peatio$ exit
190exit
191ubuntu@ip-172-31-3-200:/home/deploy/peatio$ sudo npm install -g yarn
192/usr/bin/yarn -> /usr/lib/node_modules/yarn/bin/yarn.js
193/usr/bin/yarnpkg -> /usr/lib/node_modules/yarn/bin/yarn.js
194/usr/lib
195└── yarn@1.5.1
196
197ubuntu@ip-172-31-3-200:/home/deploy/peatio$ sudo su deploy
198deploy@ip-172-31-3-200:~/peatio$ bundle exec rake db:setup
199/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/figaro-1.1.1/lib/figaro/application.rb:84:in `non_string_configuration!' : WARNING: Use strings for Figaro configuration. false was converted to "false". (StructuredWarnings::StandardWarning)exchange_production_new already exists
200rake aborted!
201Errno::ENOENT: No such file or directory @ dir_chdir - vendor/assets/yarn_components
202/home/deploy/peatio/config/initializers/assets.rb:29:in `chdir'
203/home/deploy/peatio/config/initializers/assets.rb:29:in `<top (required)>'
204/home/deploy/peatio/config/environment.rb:5:in `<top (required)>'
205/home/deploy/.rbenv/versions/2.5.0/bin/bundle:23:in `load'
206/home/deploy/.rbenv/versions/2.5.0/bin/bundle:23:in `<main>'
207Tasks: TOP => db:setup => db:schema:load_if_ruby => environment
208(See full trace by running task with --trace)
209deploy@ip-172-31-3-200:~/peatio$ bundle exec rake tmp:create yarn:install
210/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/figaro-1.1.1/lib/figaro/application.rb:84:in `non_string_configuration!' : WARNING: Use strings for Figaro configuration.yarn install v1.5.1
211[1/4] Resolving packages...
212[2/4] Fetching packages...
213[3/4] Linking dependencies...
214[4/4] Building fresh packages...
215Done in 1.16s.
216deploy@ip-172-31-3-200:~/peatio$ bundle exec rake db:setup
217/home/deploy/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/figaro-1.1.1/lib/figaro/application.rb:84:in `non_string_configuration!' : WARNING: Use strings for Figaro configuration. false was converted to "false". (StructuredWarnings::StandardWarning)exchange_production_new already exists
218W, [2018-03-06T12:57:48.537412 #24758] WARN -- : Deposit: overriding method 'warn'!
219-- create_table("account_versions", {:force=>:cascade})
220 (41.5ms) CREATE TABLE `account_versions` (`id` int(11) auto_increment PRIMARY KEY, `member_id` int(11), `account_id` int(11), `reason` int(11), `balance` decimal(32,16), `locked` decimal(32,16), `fee` decimal(32,16), `amount` decimal(32,16), `modifiable_id` int(11), `modifiable_type` varchar(255), `created_at` datetime, `updated_at` datetime, `currency` int(11), `fun` int(11)) ENGINE=InnoDB
221 -> 0.0463s
222-- add_index("account_versions", ["account_id", "reason"], {:name=>"index_account_versions_on_account_id_and_reason", :using=>:btree})
223 (15.5ms) CREATE INDEX `index_account_versions_on_account_id_and_reason` USING btree ON `account_versions` (`account_id`, `reason`)
224 -> 0.0169s
225-- add_index("account_versions", ["account_id"], {:name=>"index_account_versions_on_account_id", :using=>:btree})
226 (9.8ms) CREATE INDEX `index_account_versions_on_account_id` USING btree ON `account_versions` (`account_id`)
227 -> 0.0104s
228-- add_index("account_versions", ["member_id", "reason"], {:name=>"index_account_versions_on_member_id_and_reason", :using=>:btree})
229 (13.3ms) CREATE INDEX `index_account_versions_on_member_id_and_reason` USING btree ON `account_versions` (`member_id`, `reason`)
230 -> 0.0139s
231-- add_index("account_versions", ["modifiable_id", "modifiable_type"], {:name=>"index_account_versions_on_modifiable_id_and_modifiable_type", :using=>:btree})
232 (10.2ms) CREATE INDEX `index_account_versions_on_modifiable_id_and_modifiable_type` USING btree ON `account_versions` (`modifiable_id`, `modifiable_type`)
233 -> 0.0107s
234-- create_table("accounts", {:force=>:cascade})
235 (12.2ms) CREATE TABLE `accounts` (`id` int(11) auto_increment PRIMARY KEY, `member_id` int(11), `currency` int(11), `balance` decimal(32,16), `locked` decimal(32,16), `created_at` datetime, `updated_at` datetime, `in` decimal(32,16), `out` decimal(32,16), `default_withdraw_fund_source_id` int(11)) ENGINE=InnoDB
236 -> 0.0129s
237-- add_index("accounts", ["member_id", "currency"], {:name=>"index_accounts_on_member_id_and_currency", :using=>:btree})
238 (9.7ms) CREATE INDEX `index_accounts_on_member_id_and_currency` USING btree ON `accounts` (`member_id`, `currency`)
239 -> 0.0104s
240-- add_index("accounts", ["member_id"], {:name=>"index_accounts_on_member_id", :using=>:btree})
241 (11.1ms) CREATE INDEX `index_accounts_on_member_id` USING btree ON `accounts` (`member_id`)
242 -> 0.0117s
243-- create_table("api_tokens", {:force=>:cascade})
244 (12.4ms) CREATE TABLE `api_tokens` (`id` int(11) auto_increment PRIMARY KEY, `member_id` int(11) NOT NULL, `access_key` varchar(50) NOT NULL, `secret_key` varchar(50) NOT NULL, `created_at` datetime, `updated_at` datetime, `trusted_ip_list` varchar(255), `label` varchar(255), `expires_at` datetime, `scopes` varchar(255), `deleted_at` datetime) ENGINE=InnoDB
245 -> 0.0130s
246-- add_index("api_tokens", ["access_key"], {:name=>"index_api_tokens_on_access_key", :unique=>true, :using=>:btree})
247 (10.0ms) CREATE UNIQUE INDEX `index_api_tokens_on_access_key` USING btree ON `api_tokens` (`access_key`)
248 -> 0.0108s
249-- add_index("api_tokens", ["secret_key"], {:name=>"index_api_tokens_on_secret_key", :unique=>true, :using=>:btree})
250 (9.6ms) CREATE UNIQUE INDEX `index_api_tokens_on_secret_key` USING btree ON `api_tokens` (`secret_key`)
251 -> 0.0102s
252-- create_table("audit_logs", {:force=>:cascade})
253 (13.5ms) CREATE TABLE `audit_logs` (`id` int(11) auto_increment PRIMARY KEY, `type` varchar(255), `operator_id` int(11), `created_at` datetime, `updated_at` datetime, `auditable_id` int(11), `auditable_type` varchar(255), `source_state` varchar(255), `target_state` varchar(255)) ENGINE=InnoDB
254 -> 0.0141s
255-- add_index("audit_logs", ["auditable_id", "auditable_type"], {:name=>"index_audit_logs_on_auditable_id_and_auditable_type", :using=>:btree})
256 (9.6ms) CREATE INDEX `index_audit_logs_on_auditable_id_and_auditable_type` USING btree ON `audit_logs` (`auditable_id`, `auditable_type`)
257 -> 0.0103s
258-- add_index("audit_logs", ["operator_id"], {:name=>"index_audit_logs_on_operator_id", :using=>:btree})
259 (9.9ms) CREATE INDEX `index_audit_logs_on_operator_id` USING btree ON `audit_logs` (`operator_id`)
260 -> 0.0104s
261-- create_table("authentications", {:force=>:cascade})
262 (12.2ms) CREATE TABLE `authentications` (`id` int(11) auto_increment PRIMARY KEY, `provider` varchar(255), `uid` varchar(255), `token` text, `member_id` int(11), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB
263 -> 0.0128s
264-- add_index("authentications", ["member_id"], {:name=>"index_authentications_on_member_id", :using=>:btree})
265 (10.0ms) CREATE INDEX `index_authentications_on_member_id` USING btree ON `authentications` (`member_id`)
266 -> 0.0106s
267-- add_index("authentications", ["provider", "uid"], {:name=>"index_authentications_on_provider_and_uid", :using=>:btree})
268 (8.8ms) CREATE INDEX `index_authentications_on_provider_and_uid` USING btree ON `authentications` (`provider`, `uid`)
269 -> 0.0094s
270-- create_table("deposits", {:force=>:cascade})
271 (18.2ms) CREATE TABLE `deposits` (`id` int(11) auto_increment PRIMARY KEY, `account_id` int(11), `member_id` int(11), `currency` int(11), `amount` decimal(32,16), `fee` decimal(32,16), `fund_uid` varchar(255), `fund_extra` varchar(255), `txid` varchar(255), `state` int(11), `aasm_state` varchar(255), `created_at` datetime, `updated_at` datetime, `done_at` datetime, `confirmations` varchar(255), `type` varchar(255), `payment_transaction_id` int(11), `txout` int(11)) ENGINE=InnoDB
272 -> 0.0189s
273-- add_index("deposits", ["txid", "txout"], {:name=>"index_deposits_on_txid_and_txout", :using=>:btree})
274 (10.0ms) CREATE INDEX `index_deposits_on_txid_and_txout` USING btree ON `deposits` (`txid`, `txout`)
275 -> 0.0107s
276-- create_table("fund_sources", {:force=>:cascade})
277 (12.8ms) CREATE TABLE `fund_sources` (`id` int(11) auto_increment PRIMARY KEY, `member_id` int(11), `currency` int(11), `extra` varchar(255), `uid` varchar(255), `is_locked` tinyint(1) DEFAULT 0, `created_at` datetime, `updated_at` datetime, `deleted_at` datetime) ENGINE=InnoDB
278 -> 0.0137s
279-- create_table("members", {:force=>:cascade})
280 (13.3ms) CREATE TABLE `members` (`id` int(11) auto_increment PRIMARY KEY, `level` varchar(20) DEFAULT '', `sn` varchar(12) NOT NULL, `email` varchar(255) NOT NULL, `disabled` tinyint(1) DEFAULT 0 NOT NULL, `api_disabled` tinyint(1) DEFAULT 0 NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL) ENGINE=InnoDB
281 -> 0.0141s
282-- add_index("members", ["sn"], {:name=>"index_members_on_sn", :unique=>true, :using=>:btree})
283 (9.9ms) CREATE UNIQUE INDEX `index_members_on_sn` USING btree ON `members` (`sn`)
284 -> 0.0106s
285-- create_table("orders", {:force=>:cascade})
286 (13.9ms) CREATE TABLE `orders` (`id` int(11) auto_increment PRIMARY KEY, `bid` int(11), `ask` int(11), `currency` int(11), `price` decimal(32,16), `volume` decimal(32,16), `origin_volume` decimal(32,16), `state` int(11), `done_at` datetime, `type` varchar(8), `member_id` int(11), `created_at` datetime, `updated_at` datetime, `sn` varchar(255), `source` varchar(255) NOT NULL, `ord_type` varchar(10), `locked` decimal(32,16), `origin_locked` decimal(32,16), `funds_received` decimal(32,16) DEFAULT 0.0, `trades_count` int(11) DEFAULT 0) ENGINE=InnoDB
287 -> 0.0149s
288-- add_index("orders", ["currency", "state"], {:name=>"index_orders_on_currency_and_state", :using=>:btree})
289 (9.8ms) CREATE INDEX `index_orders_on_currency_and_state` USING btree ON `orders` (`currency`, `state`)
290 -> 0.0105s
291-- add_index("orders", ["member_id", "state"], {:name=>"index_orders_on_member_id_and_state", :using=>:btree})
292 (9.8ms) CREATE INDEX `index_orders_on_member_id_and_state` USING btree ON `orders` (`member_id`, `state`)
293 -> 0.0105s
294-- add_index("orders", ["member_id"], {:name=>"index_orders_on_member_id", :using=>:btree})
295 (14.9ms) CREATE INDEX `index_orders_on_member_id` USING btree ON `orders` (`member_id`)
296 -> 0.0156s
297-- add_index("orders", ["state"], {:name=>"index_orders_on_state", :using=>:btree})
298 (12.0ms) CREATE INDEX `index_orders_on_state` USING btree ON `orders` (`state`)
299 -> 0.0126s
300-- create_table("partial_trees", {:force=>:cascade})
301 (14.0ms) CREATE TABLE `partial_trees` (`id` int(11) auto_increment PRIMARY KEY, `proof_id` int(11) NOT NULL, `account_id` int(11) NOT NULL, `json` text NOT NULL, `created_at` datetime, `updated_at` datetime, `sum` varchar(255)) ENGINE=InnoDB
302 -> 0.0147s
303-- create_table("payment_addresses", {:force=>:cascade})
304 (13.5ms) CREATE TABLE `payment_addresses` (`id` int(11) auto_increment PRIMARY KEY, `account_id` int(11), `address` varchar(255), `created_at` datetime, `updated_at` datetime, `currency` int(11), `secret` varchar(255), `details` varchar(1024) DEFAULT '{}' NOT NULL) ENGINE=InnoDB
305 -> 0.0143s
306-- create_table("payment_transactions", {:force=>:cascade})
307 (12.9ms) CREATE TABLE `payment_transactions` (`id` int(11) auto_increment PRIMARY KEY, `txid` varchar(255), `amount` decimal(32,16), `confirmations` int(11), `address` varchar(255), `state` int(11), `aasm_state` varchar(255), `created_at` datetime, `updated_at` datetime, `receive_at` datetime, `dont_at` datetime, `currency` int(11), `type` varchar(60), `txout` int(11)) ENGINE=InnoDB
308 -> 0.0137s
309-- add_index("payment_transactions", ["txid", "txout"], {:name=>"index_payment_transactions_on_txid_and_txout", :using=>:btree})
310 (10.0ms) CREATE INDEX `index_payment_transactions_on_txid_and_txout` USING btree ON `payment_transactions` (`txid`, `txout`)
311 -> 0.0107s
312-- add_index("payment_transactions", ["type"], {:name=>"index_payment_transactions_on_type", :using=>:btree})
313 (9.5ms) CREATE INDEX `index_payment_transactions_on_type` USING btree ON `payment_transactions` (`type`)
314 -> 0.0101s
315-- create_table("proofs", {:force=>:cascade})
316 (13.6ms) CREATE TABLE `proofs` (`id` int(11) auto_increment PRIMARY KEY, `root` varchar(255), `currency` int(11), `ready` tinyint(1) DEFAULT 0, `created_at` datetime, `updated_at` datetime, `sum` varchar(255), `addresses` text, `balance` varchar(30)) ENGINE=InnoDB
317 -> 0.0143s
318-- create_table("trades", {:force=>:cascade})
319 (15.8ms) CREATE TABLE `trades` (`id` int(11) auto_increment PRIMARY KEY, `price` decimal(32,16), `volume` decimal(32,16), `ask_id` int(11), `bid_id` int(11), `trend` int(11), `currency` int(11), `created_at` datetime, `updated_at` datetime, `ask_member_id` int(11), `bid_member_id` int(11), `funds` decimal(32,16)) ENGINE=InnoDB
320 -> 0.0165s
321-- add_index("trades", ["ask_id"], {:name=>"index_trades_on_ask_id", :using=>:btree})
322 (9.9ms) CREATE INDEX `index_trades_on_ask_id` USING btree ON `trades` (`ask_id`)
323 -> 0.0106s
324-- add_index("trades", ["ask_member_id"], {:name=>"index_trades_on_ask_member_id", :using=>:btree})
325 (9.9ms) CREATE INDEX `index_trades_on_ask_member_id` USING btree ON `trades` (`ask_member_id`)
326 -> 0.0105s
327-- add_index("trades", ["bid_id"], {:name=>"index_trades_on_bid_id", :using=>:btree})
328 (9.8ms) CREATE INDEX `index_trades_on_bid_id` USING btree ON `trades` (`bid_id`)
329 -> 0.0104s
330-- add_index("trades", ["bid_member_id"], {:name=>"index_trades_on_bid_member_id", :using=>:btree})
331 (9.2ms) CREATE INDEX `index_trades_on_bid_member_id` USING btree ON `trades` (`bid_member_id`)
332 -> 0.0098s
333-- add_index("trades", ["created_at"], {:name=>"index_trades_on_created_at", :using=>:btree})
334 (9.9ms) CREATE INDEX `index_trades_on_created_at` USING btree ON `trades` (`created_at`)
335 -> 0.0106s
336-- add_index("trades", ["currency"], {:name=>"index_trades_on_currency", :using=>:btree})
337 (10.0ms) CREATE INDEX `index_trades_on_currency` USING btree ON `trades` (`currency`)
338 -> 0.0106s
339-- create_table("versions", {:force=>:cascade})
340 (12.2ms) CREATE TABLE `versions` (`id` int(11) auto_increment PRIMARY KEY, `item_type` varchar(255) NOT NULL, `item_id` int(11) NOT NULL, `event` varchar(255) NOT NULL, `whodunnit` varchar(255), `object` text, `created_at` datetime) ENGINE=InnoDB
341 -> 0.0129s
342-- add_index("versions", ["item_type", "item_id"], {:name=>"index_versions_on_item_type_and_item_id", :using=>:btree})
343 (8.6ms) CREATE INDEX `index_versions_on_item_type_and_item_id` USING btree ON `versions` (`item_type`, `item_id`)
344 -> 0.0093s
345-- create_table("withdraws", {:force=>:cascade})
346 (13.7ms) CREATE TABLE `withdraws` (`id` int(11) auto_increment PRIMARY KEY, `sn` varchar(255), `account_id` int(11), `member_id` int(11), `currency` int(11), `amount` decimal(32,16), `fee` decimal(32,16), `fund_uid` varchar(255), `fund_extra` varchar(255), `created_at` datetime, `updated_at` datetime, `done_at` datetime, `txid` varchar(255), `aasm_state` varchar(255), `sum` decimal(32,16) DEFAULT 0.0 NOT NULL, `type` varchar(255)) ENGINE=InnoDB
347 -> 0.0144s
348-- initialize_schema_migrations_table()
349 (15.8ms) CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB
350 (21.3ms) CREATE UNIQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`)
351 -> 0.0436s
352 (0.1ms) SELECT version FROM `schema_migrations`
353 (4.6ms) INSERT INTO `schema_migrations` (version) VALUES ('20180303121013')
354 (1.8ms) INSERT INTO `schema_migrations` (version) VALUES ('20180215144645')
355 (0.7ms) INSERT INTO `schema_migrations` (version) VALUES ('20180212115751')
356 (0.7ms) INSERT INTO `schema_migrations` (version) VALUES ('20180216145412')
357 (0.7ms) INSERT INTO `schema_migrations` (version) VALUES ('20180212115002')
358 (1.9ms) INSERT INTO `schema_migrations` (version) VALUES ('20180213160501')
359 (0.7ms) INSERT INTO `schema_migrations` (version) VALUES ('20180112151205')
360 (0.7ms) INSERT INTO `schema_migrations` (version) VALUES ('20180215124645')
361 (0.7ms) INSERT INTO `schema_migrations` (version) VALUES ('20180215131129')
362 ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations`