Project

General

Profile

Defect #21398 ยป redmine_convert_utf8_to_utf8mb4.log

agile tuan, 2019-10-14 09:57

 
1
https://www.redmine.org/issues/21398#note-19
2

    
3
root@ubuntu:/usr/share/redmine# RAILS_ENV=production bundle exec rake db:migrate --trace
4
** Invoke db:migrate (first_time)
5
** Invoke environment (first_time)
6
** Execute environment
7
** Invoke db:load_config (first_time)
8
** Execute db:load_config
9
** Execute db:migrate
10
== 20191014134254 EncodingConvertion: migrating ===============================
11
-- execute("ALTER DATABASE `redmine_default` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
12
   -> 0.0014s
13
-- execute("ALTER TABLE `attachments` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
14
   -> 0.8099s
15
-- execute("ALTER TABLE `attachments` MODIFY `container_type` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
16
   -> 0.0320s
17
-- execute("ALTER TABLE `attachments` MODIFY `filename` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
18
   -> 0.0352s
19
-- execute("ALTER TABLE `attachments` MODIFY `disk_filename` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
20
   -> 0.0300s
21
-- execute("ALTER TABLE `attachments` MODIFY `content_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
22
   -> 0.0355s
23
-- execute("ALTER TABLE `attachments` MODIFY `digest` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
24
   -> 0.0357s
25
-- execute("ALTER TABLE `attachments` MODIFY `description` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
26
   -> 0.0422s
27
-- execute("ALTER TABLE `attachments` MODIFY `disk_directory` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
28
   -> 0.0351s
29
-- execute("ALTER TABLE `auth_sources` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
30
   -> 0.5144s
31
-- execute("ALTER TABLE `auth_sources` MODIFY `type` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
32
   -> 0.0616s
33
-- execute("ALTER TABLE `auth_sources` MODIFY `name` VARCHAR(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
34
   -> 0.0298s
35
-- execute("ALTER TABLE `auth_sources` MODIFY `host` VARCHAR(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
36
   -> 0.0301s
37
-- execute("ALTER TABLE `auth_sources` MODIFY `account` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
38
   -> 0.0292s
39
-- execute("ALTER TABLE `auth_sources` MODIFY `account_password` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
40
   -> 0.0300s
41
-- execute("ALTER TABLE `auth_sources` MODIFY `base_dn` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
42
   -> 0.0290s
43
-- execute("ALTER TABLE `auth_sources` MODIFY `attr_login` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
44
   -> 0.0297s
45
-- execute("ALTER TABLE `auth_sources` MODIFY `attr_firstname` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
46
   -> 0.0298s
47
-- execute("ALTER TABLE `auth_sources` MODIFY `attr_lastname` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
48
   -> 0.0301s
49
-- execute("ALTER TABLE `auth_sources` MODIFY `attr_mail` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
50
   -> 0.0295s
51
-- execute("ALTER TABLE `auth_sources` MODIFY `filter` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
52
   -> 0.6944s
53
-- execute("ALTER TABLE `boards` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
54
   -> 0.5202s
55
-- execute("ALTER TABLE `boards` MODIFY `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
56
   -> 0.7860s
57
-- execute("ALTER TABLE `boards` MODIFY `description` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
58
   -> 0.9671s
59
-- execute("ALTER TABLE `changes` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
60
   -> 0.6898s
61
-- execute("ALTER TABLE `changes` MODIFY `action` VARCHAR(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
62
   -> 1.1586s
63
-- execute("ALTER TABLE `changes` MODIFY `path` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL")
64
   -> 0.6880s
65
-- execute("ALTER TABLE `changes` MODIFY `from_path` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
66
   -> 0.6578s
67
-- execute("ALTER TABLE `changes` MODIFY `from_revision` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
68
   -> 0.7778s
69
-- execute("ALTER TABLE `changes` MODIFY `revision` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
70
   -> 0.6643s
71
-- execute("ALTER TABLE `changes` MODIFY `branch` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
72
   -> 0.7471s
73
-- execute("ALTER TABLE `changeset_parents` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
74
   -> 0.5042s
75
-- execute("ALTER TABLE `changesets` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
76
   -> 0.6271s
77
-- execute("ALTER TABLE `changesets` MODIFY `revision` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
78
   -> 0.8025s
79
-- execute("ALTER TABLE `changesets` MODIFY `committer` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
80
   -> 0.8494s
81
-- execute("ALTER TABLE `changesets` MODIFY `comments` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
82
   -> 0.7777s
83
-- execute("ALTER TABLE `changesets` MODIFY `scmid` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
84
   -> 0.8615s
85
-- execute("ALTER TABLE `changesets_issues` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
86
   -> 0.3590s
87
-- execute("ALTER TABLE `comments` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
88
   -> 0.6384s
89
-- execute("ALTER TABLE `comments` MODIFY `commented_type` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
90
   -> 0.6312s
91
-- execute("ALTER TABLE `comments` MODIFY `comments` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
92
   -> 0.8362s
93
-- execute("ALTER TABLE `custom_field_enumerations` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
94
   -> 0.3661s
95
-- execute("ALTER TABLE `custom_field_enumerations` MODIFY `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
96
   -> 0.5058s
97
-- execute("ALTER TABLE `custom_fields` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
98
   -> 0.4260s
99
-- execute("ALTER TABLE `custom_fields` MODIFY `type` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
100
   -> 0.5215s
101
-- execute("ALTER TABLE `custom_fields` MODIFY `name` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
102
   -> 0.7120s
103
-- execute("ALTER TABLE `custom_fields` MODIFY `field_format` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
104
   -> 0.5677s
105
-- execute("ALTER TABLE `custom_fields` MODIFY `possible_values` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
106
   -> 0.6763s
107
-- execute("ALTER TABLE `custom_fields` MODIFY `regexp` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
108
   -> 0.6634s
109
-- execute("ALTER TABLE `custom_fields` MODIFY `default_value` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
110
   -> 0.7841s
111
-- execute("ALTER TABLE `custom_fields` MODIFY `format_store` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
112
   -> 0.6935s
113
-- execute("ALTER TABLE `custom_fields` MODIFY `description` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
114
   -> 0.7358s
115
-- execute("ALTER TABLE `custom_fields_projects` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
116
   -> 0.4313s
117
-- execute("ALTER TABLE `custom_fields_roles` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
118
   -> 0.5005s
119
-- execute("ALTER TABLE `custom_fields_trackers` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
120
   -> 0.4356s
121
-- execute("ALTER TABLE `custom_values` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
122
   -> 0.4700s
123
-- execute("ALTER TABLE `custom_values` MODIFY `customized_type` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
124
   -> 0.7569s
125
-- execute("ALTER TABLE `custom_values` MODIFY `value` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
126
   -> 0.6338s
127
-- execute("ALTER TABLE `documents` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
128
   -> 0.5329s
129
-- execute("ALTER TABLE `documents` MODIFY `title` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
130
   -> 0.8276s
131
-- execute("ALTER TABLE `documents` MODIFY `description` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
132
   -> 0.8377s
133
-- execute("ALTER TABLE `email_addresses` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
134
   -> 0.6286s
135
-- execute("ALTER TABLE `email_addresses` MODIFY `address` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
136
   -> 0.7806s
137
-- execute("ALTER TABLE `enabled_modules` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
138
   -> 0.5565s
139
-- execute("ALTER TABLE `enabled_modules` MODIFY `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
140
   -> 0.9247s
141
-- execute("ALTER TABLE `enumerations` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
142
   -> 0.7662s
143
-- execute("ALTER TABLE `enumerations` MODIFY `name` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
144
   -> 0.7925s
145
-- execute("ALTER TABLE `enumerations` MODIFY `type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
146
   -> 0.9574s
147
-- execute("ALTER TABLE `enumerations` MODIFY `position_name` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
148
   -> 1.0763s
149
-- execute("ALTER TABLE `groups_users` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
150
   -> 0.4372s
151
-- execute("ALTER TABLE `import_items` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
152
   -> 0.4955s
153
-- execute("ALTER TABLE `import_items` MODIFY `message` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
154
   -> 0.6432s
155
-- execute("ALTER TABLE `imports` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
156
   -> 0.4552s
157
-- execute("ALTER TABLE `imports` MODIFY `type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
158
   -> 0.6189s
159
-- execute("ALTER TABLE `imports` MODIFY `filename` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
160
   -> 0.6694s
161
-- execute("ALTER TABLE `imports` MODIFY `settings` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
162
   -> 0.6583s
163
-- execute("ALTER TABLE `issue_categories` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
164
   -> 0.5214s
165
-- execute("ALTER TABLE `issue_categories` MODIFY `name` VARCHAR(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
166
   -> 0.7454s
167
-- execute("ALTER TABLE `issue_relations` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
168
   -> 0.9750s
169
-- execute("ALTER TABLE `issue_relations` MODIFY `relation_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
170
   -> 0.8408s
171
-- execute("ALTER TABLE `issue_statuses` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
172
   -> 0.6946s
173
-- execute("ALTER TABLE `issue_statuses` MODIFY `name` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
174
   -> 0.8050s
175
-- execute("ALTER TABLE `issues` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
176
   -> 1.5025s
177
-- execute("ALTER TABLE `issues` MODIFY `subject` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
178
   -> 1.1138s
179
-- execute("ALTER TABLE `issues` MODIFY `description` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
180
   -> 1.1300s
181
-- execute("ALTER TABLE `journal_details` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
182
   -> 0.7473s
183
-- execute("ALTER TABLE `journal_details` MODIFY `property` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
184
   -> 0.7336s
185
-- execute("ALTER TABLE `journal_details` MODIFY `prop_key` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
186
   -> 0.9329s
187
-- execute("ALTER TABLE `journal_details` MODIFY `old_value` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
188
   -> 0.7344s
189
-- execute("ALTER TABLE `journal_details` MODIFY `value` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
190
   -> 0.7880s
191
-- execute("ALTER TABLE `journals` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
192
   -> 0.8564s
193
-- execute("ALTER TABLE `journals` MODIFY `journalized_type` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
194
   -> 0.8874s
195
-- execute("ALTER TABLE `journals` MODIFY `notes` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
196
   -> 0.9786s
197
-- execute("ALTER TABLE `member_roles` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
198
   -> 0.4834s
199
-- execute("ALTER TABLE `members` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
200
   -> 0.5715s
201
-- execute("ALTER TABLE `messages` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
202
   -> 0.6249s
203
-- execute("ALTER TABLE `messages` MODIFY `subject` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
204
   -> 0.8776s
205
-- execute("ALTER TABLE `messages` MODIFY `content` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
206
   -> 0.9928s
207
-- execute("ALTER TABLE `news` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
208
   -> 0.9450s
209
-- execute("ALTER TABLE `news` MODIFY `title` VARCHAR(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
210
   -> 1.1221s
211
-- execute("ALTER TABLE `news` MODIFY `summary` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
212
   -> 0.8017s
213
-- execute("ALTER TABLE `news` MODIFY `description` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
214
   -> 0.8495s
215
-- execute("ALTER TABLE `open_id_authentication_associations` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
216
   -> 0.4067s
217
-- execute("ALTER TABLE `open_id_authentication_associations` MODIFY `handle` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
218
   -> 0.5975s
219
-- execute("ALTER TABLE `open_id_authentication_associations` MODIFY `assoc_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
220
   -> 0.5798s
221
-- execute("ALTER TABLE `open_id_authentication_nonces` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
222
   -> 0.4012s
223
-- execute("ALTER TABLE `open_id_authentication_nonces` MODIFY `server_url` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
224
   -> 0.7148s
225
-- execute("ALTER TABLE `open_id_authentication_nonces` MODIFY `salt` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
226
   -> 0.8855s
227
-- execute("ALTER TABLE `projects` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
228
   -> 0.6280s
229
-- execute("ALTER TABLE `projects` MODIFY `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
230
   -> 1.0958s
231
-- execute("ALTER TABLE `projects` MODIFY `description` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
232
   -> 0.7402s
233
-- execute("ALTER TABLE `projects` MODIFY `homepage` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
234
   -> 0.9336s
235
-- execute("ALTER TABLE `projects` MODIFY `identifier` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
236
   -> 0.9739s
237
-- execute("ALTER TABLE `projects_trackers` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
238
   -> 0.7184s
239
-- execute("ALTER TABLE `queries` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
240
   -> 0.5121s
241
-- execute("ALTER TABLE `queries` MODIFY `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
242
   -> 0.7619s
243
-- execute("ALTER TABLE `queries` MODIFY `filters` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
244
   -> 0.8440s
245
-- execute("ALTER TABLE `queries` MODIFY `column_names` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
246
   -> 0.9089s
247
-- execute("ALTER TABLE `queries` MODIFY `sort_criteria` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
248
   -> 0.7778s
249
-- execute("ALTER TABLE `queries` MODIFY `group_by` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
250
   -> 0.8494s
251
-- execute("ALTER TABLE `queries` MODIFY `type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
252
   -> 0.8023s
253
-- execute("ALTER TABLE `queries` MODIFY `options` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
254
   -> 0.9015s
255
-- execute("ALTER TABLE `queries_roles` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
256
   -> 0.4960s
257
-- execute("ALTER TABLE `repositories` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
258
   -> 0.5490s
259
-- execute("ALTER TABLE `repositories` MODIFY `url` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
260
   -> 0.6359s
261
-- execute("ALTER TABLE `repositories` MODIFY `login` VARCHAR(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
262
   -> 0.6823s
263
-- execute("ALTER TABLE `repositories` MODIFY `password` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
264
   -> 0.7825s
265
-- execute("ALTER TABLE `repositories` MODIFY `root_url` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
266
   -> 0.7959s
267
-- execute("ALTER TABLE `repositories` MODIFY `type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
268
   -> 0.7527s
269
-- execute("ALTER TABLE `repositories` MODIFY `path_encoding` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
270
   -> 0.7477s
271
-- execute("ALTER TABLE `repositories` MODIFY `log_encoding` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
272
   -> 0.6514s
273
-- execute("ALTER TABLE `repositories` MODIFY `extra_info` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
274
   -> 0.7414s
275
-- execute("ALTER TABLE `repositories` MODIFY `identifier` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
276
   -> 0.7283s
277
-- execute("ALTER TABLE `roles` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
278
   -> 0.5636s
279
-- execute("ALTER TABLE `roles` MODIFY `name` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
280
   -> 0.7680s
281
-- execute("ALTER TABLE `roles` MODIFY `permissions` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
282
   -> 0.8613s
283
-- execute("ALTER TABLE `roles` MODIFY `issues_visibility` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'default' NOT NULL;")
284
   -> 0.8845s
285
-- execute("ALTER TABLE `roles` MODIFY `users_visibility` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'all' NOT NULL;")
286
   -> 0.8368s
287
-- execute("ALTER TABLE `roles` MODIFY `time_entries_visibility` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'all' NOT NULL;")
288
   -> 0.6993s
289
-- execute("ALTER TABLE `roles_managed_roles` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
290
   -> 0.4731s
291
-- execute("ALTER TABLE `schema_migrations` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
292
   -> 0.6022s
293
-- execute("ALTER TABLE `schema_migrations` MODIFY `version` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
294
   -> 0.6666s
295
-- execute("ALTER TABLE `settings` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
296
   -> 0.7362s
297
-- execute("ALTER TABLE `settings` MODIFY `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
298
   -> 0.8109s
299
-- execute("ALTER TABLE `settings` MODIFY `value` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
300
   -> 0.9216s
301
-- execute("ALTER TABLE `time_entries` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
302
   -> 0.5931s
303
-- execute("ALTER TABLE `time_entries` MODIFY `comments` VARCHAR(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
304
   -> 1.0249s
305
-- execute("ALTER TABLE `tokens` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
306
   -> 0.8274s
307
-- execute("ALTER TABLE `tokens` MODIFY `action` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
308
   -> 1.1569s
309
-- execute("ALTER TABLE `tokens` MODIFY `value` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
310
   -> 0.8556s
311
-- execute("ALTER TABLE `trackers` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
312
   -> 0.5986s
313
-- execute("ALTER TABLE `trackers` MODIFY `name` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
314
   -> 0.6784s
315
-- execute("ALTER TABLE `user_preferences` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
316
   -> 0.6172s
317
-- execute("ALTER TABLE `user_preferences` MODIFY `others` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
318
   -> 0.8289s
319
-- execute("ALTER TABLE `user_preferences` MODIFY `time_zone` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
320
   -> 0.6340s
321
-- execute("ALTER TABLE `users` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
322
   -> 0.8623s
323
-- execute("ALTER TABLE `users` MODIFY `login` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
324
   -> 0.7257s
325
-- execute("ALTER TABLE `users` MODIFY `hashed_password` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
326
   -> 0.7829s
327
-- execute("ALTER TABLE `users` MODIFY `firstname` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
328
   -> 0.9152s
329
-- execute("ALTER TABLE `users` MODIFY `lastname` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
330
   -> 0.8319s
331
-- execute("ALTER TABLE `users` MODIFY `language` VARCHAR(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
332
   -> 0.8309s
333
-- execute("ALTER TABLE `users` MODIFY `type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
334
   -> 0.9157s
335
-- execute("ALTER TABLE `users` MODIFY `identity_url` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
336
   -> 0.8368s
337
-- execute("ALTER TABLE `users` MODIFY `mail_notification` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
338
   -> 0.8133s
339
-- execute("ALTER TABLE `users` MODIFY `salt` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
340
   -> 0.7596s
341
-- execute("ALTER TABLE `versions` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
342
   -> 0.5274s
343
-- execute("ALTER TABLE `versions` MODIFY `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
344
   -> 0.6965s
345
-- execute("ALTER TABLE `versions` MODIFY `description` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
346
   -> 0.8079s
347
-- execute("ALTER TABLE `versions` MODIFY `wiki_page_title` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
348
   -> 0.7051s
349
-- execute("ALTER TABLE `versions` MODIFY `status` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'open' ;")
350
   -> 1.2270s
351
-- execute("ALTER TABLE `versions` MODIFY `sharing` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'none' NOT NULL;")
352
   -> 0.6575s
353
-- execute("ALTER TABLE `watchers` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
354
   -> 0.7486s
355
-- execute("ALTER TABLE `watchers` MODIFY `watchable_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
356
   -> 0.9113s
357
-- execute("ALTER TABLE `wiki_content_versions` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
358
   -> 0.4493s
359
-- execute("ALTER TABLE `wiki_content_versions` MODIFY `compression` VARCHAR(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
360
   -> 0.8405s
361
-- execute("ALTER TABLE `wiki_content_versions` MODIFY `comments` VARCHAR(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
362
   -> 0.8557s
363
-- execute("ALTER TABLE `wiki_contents` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
364
   -> 0.5335s
365
-- execute("ALTER TABLE `wiki_contents` MODIFY `text` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ")
366
   -> 0.6601s
367
-- execute("ALTER TABLE `wiki_contents` MODIFY `comments` VARCHAR(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
368
   -> 0.7543s
369
-- execute("ALTER TABLE `wiki_pages` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
370
   -> 0.6169s
371
-- execute("ALTER TABLE `wiki_pages` MODIFY `title` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
372
   -> 0.7618s
373
-- execute("ALTER TABLE `wiki_redirects` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
374
   -> 0.4857s
375
-- execute("ALTER TABLE `wiki_redirects` MODIFY `title` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
376
   -> 0.8047s
377
-- execute("ALTER TABLE `wiki_redirects` MODIFY `redirects_to` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
378
   -> 0.6998s
379
-- execute("ALTER TABLE `wikis` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
380
   -> 0.6651s
381
-- execute("ALTER TABLE `wikis` MODIFY `start_page` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL;")
382
   -> 0.9296s
383
-- execute("ALTER TABLE `workflows` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
384
   -> 1.0128s
385
-- execute("ALTER TABLE `workflows` MODIFY `type` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
386
   -> 0.9832s
387
-- execute("ALTER TABLE `workflows` MODIFY `field_name` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
388
   -> 1.8117s
389
-- execute("ALTER TABLE `workflows` MODIFY `rule` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  ;")
390
   -> 1.1431s
391
== 20191014134254 EncodingConvertion: migrated (130.0542s) ====================
392

    
393
** Invoke db:_dump (first_time)
394
** Execute db:_dump
395
** Invoke db:schema:dump (first_time)
396
** Invoke environment
397
** Invoke db:load_config
398
** Execute db:schema:dump
399
root@ubuntu:/usr/share/redmine#
    (1-1/1)