· 6 years ago · Aug 31, 2019, 10:24 AM
1root@sd-103624:/var/www/stalker_portal/deploy# phing
2Buildfile: /var/www/stalker_portal/deploy/build.xml
3 [property] Loading /var/www/stalker_portal/deploy/../server/custom.ini
4 [property] Loading /var/www/stalker_portal/deploy/../server/config.ini
5
6stalker_portal > build:
7
8 [exec] Executing command: lsb_release -r -s 2>&1
9 [echo] Ubuntu version: 14.04
10 [echo] Project path: /var/www/stalker_portal
11 [php] Evaluating PHP expression: substr(phpversion(), 0, 3);
12 [echo] PHP version: 5.5
13 [exec] Executing command: apt-get update 2>&1
14 [exec] Executing command: apt-get -y install zlibc curl php5-sqlite php-soap php5-intl php-gettext php5-memcache php5-curl php5-mysql php5-mcrypt php5-tidy php5-imagick php5-geoip curl npm git zip unzip 2>&1
15 [exec] Executing command: phpenmod mcrypt 2>&1
16 [exec] Executing command: phpdismod opcache 2>&1
17 [exec] Executing command: cp -r -v /var/www/stalker_portal/deploy/composer/locks/composer-5.5.9.lock /var/www/stalker_portal/deploy/composer.lock 2>&1
18 [exec] Executing command: a2enmod rewrite 2>&1
19 [exec] Executing command: curl -sS https://getcomposer.org/installer | php -- --install-dir=/var/www/stalker_portal/deploy/composer/ --filename=composer.deploy.phar 2>&1
20 [exec] Executing command: chmod +x /var/www/stalker_portal/storage/tvarchive.sh 2>&1
21 [exec] Executing command: rm -f /var/www/stalker_portal/deploy/ministra/composer.lock 2>&1
22 [exec] Executing command: php /var/www/stalker_portal/deploy/composer/composer.deploy.phar global require hirak/prestissimo --no-interaction 2>&1
23 [exec] Executing command: php /var/www/stalker_portal/deploy/composer/composer.deploy.phar --working-dir=/var/www/stalker_portal/deploy/ install --no-dev --no-suggest --no-interaction 2>&1
24 [exec] Executing command: php /var/www/stalker_portal/deploy/composer/composer.deploy.phar --working-dir=/var/www/stalker_portal/deploy/ dump-autoload --no-dev 2>&1
25 [exec] Executing command: php /var/www/stalker_portal/deploy/composer/composer.deploy.phar --working-dir=/var/www/stalker_portal/deploy/ministra install --no-dev --no-suggest --no-interaction 2>&1
26 [exec] Executing command: php /var/www/stalker_portal/deploy/composer/composer.deploy.phar --working-dir=/var/www/stalker_portal/deploy/ministra dump-autoload --no-dev 2>&1
27 [exec] Executing command: php /var/www/stalker_portal/deploy/composer/composer.deploy.phar --working-dir=/var/www/stalker_portal/storage install --no-dev --no-suggest --no-interaction 2>&1
28 [exec] Executing command: php /var/www/stalker_portal/deploy/composer/composer.deploy.phar --working-dir=/var/www/stalker_portal/storage dump-autoload --no-dev 2>&1
29 [exec] Executing command: stop stalkerd 2>&1
30 [exec] Executing command: nodejs -v 2>&1
31 [copy] Copying 1 file to /etc/cron.d
32 [chmod] Changed file mode on '/etc/cron.d/stalker_70439ea2348d37ccfc8c52d63fff51eb' to 755
33 [copy] Copying 1 file to /etc/logrotate.d
34 [echo] /var/www/stalker_portal
35 [copy] Copying 1 file to /tmp
36 [php] Evaluating PHP expression: ini_get('extension_dir');
37 [echo] PHP extension dir: /usr/lib/php5/20121212
38 [php] Evaluating PHP expression: PHP_INT_SIZE === 8 ? 64 : 32
39 [echo] OS: 64 bit
40 [copy] Copying 1 file to /usr/lib/php5/20121212
41 [chmod] Changed file mode on '/usr/lib/php5/20121212/ioncube_loader_lin_5.5.so' to 644
42 [exec] Executing command: php -v | grep -i ioncube | wc -l 2>&1
43 [echo] IonCube installed: 1
44 [exec] Executing command: cp -r -v /var/www/stalker_portal/deploy/src/core/53/* /var/www/stalker_portal 2>&1
45 [exec] Executing command: php /var/www/stalker_portal/admin/bin/console migrations:upgrade --no-interaction 2>&1
46 [exec] Executing command: php /var/www/stalker_portal/admin/bin/console migrations:deploy --no-interaction 2>&1
47 [echo] Loading configuration from the integration code of your framework (setter).
48
49 Ministra DB Migrations
50
51
52WARNING! You have 2 previously executed migrations in the database that are not registered migrations.
53 >> ()
54 >> ()
55Migrating up to 20190805112404 from 1535720186
56
57 ++ migrating 1535720101
58
59Migration 1535720101 was executed but did not result in any SQL statements.
60
61 ++ migrated (0.63s)
62
63 ++ migrating 1535720116
64
65 -> --
66
67INSERT INTO `adm_grp_action_access`
68 (`controller_name`, `action_name`, `is_ajax`, `description`)
69VALUES ('audio-club', 'get-media-info-json', 1, 'Getting audio-info from source');
70
71 ++ migrated (0.97s)
72
73 ++ migrating 1535720187
74
75Migration 1535720187 was executed but did not result in any SQL statements.
76
77 ++ migrated (0.99s)
78
79 ++ migrating 1535720188
80
81 -> --
82CREATE TABLE `resellers_ips_ranges` (
83 `id` INT NOT NULL AUTO_INCREMENT,
84 `reseller_id` INT NOT NULL DEFAULT 0,
85 `ip_range` VARCHAR(32) NOT NULL DEFAULT '',
86 `calculated_range_begin` INT UNSIGNED NOT NULL DEFAULT 0,
87 `calculated_range_end` INT UNSIGNED NOT NULL DEFAULT 0,
88 INDEX `idx_reseller_id` (`reseller_id`),
89 PRIMARY KEY (`id`)
90) DEFAULT CHARSET = UTF8;
91ALTER TABLE users ADD COLUMN last_change_ip VARCHAR(64) NOT NULL DEFAULT '{}';
92ALTER TABLE reseller ADD COLUMN use_ip_ranges TINYINT NOT NULL DEFAULT 0;
93
94 ++ migrated (0.1s)
95
96 ++ migrating 1535720189
97
98 -> --
99INSERT INTO `adm_grp_action_access`
100 (`controller_name`, `action_name`, `is_ajax`, `description`, `only_top_admin`)
101VALUES ( 'admins', 'resellers-check-name', 1, 'Check if available this name for reseller', 1),
102 ( 'admins','check-ip-range-intersection', 1, 'Сheck for use of the current address or address range by another reseller', 1);
103
104 ++ migrated (0s)
105
106 ++ migrating 1535720190
107
108 -> --
109INSERT INTO `adm_grp_action_access`
110(`controller_name`, `action_name`, `is_ajax`, `description`)
111VALUES ('users', 'user-tariff-plan', 1, 'Getting packets of tariff\'s plan');
112
113 ++ migrated (0s)
114
115 ++ migrating 1535720191
116
117 -> --
118DELETE FROM `adm_grp_action_access` WHERE controller_name='index' AND action_name='index-datatable1-list-json';
119DELETE FROM `adm_grp_action_access` WHERE controller_name='index' AND action_name='index-datatable2-list-json';
120DELETE FROM `adm_grp_action_access` WHERE controller_name='index' AND action_name='index-datatable3-list-json';
121INSERT INTO `adm_grp_action_access`
122(`controller_name`, `action_name`, `is_ajax`, `view_access`, `edit_access`, `action_access`, `description`, `hidden`)
123VALUES ('index', 'datatable-devices', 1, 1, 1, 1, 'Getting data for devices table', 1),
124 ('index', 'datatable-content', 1, 1, 1, 1, 'Getting data for content table', 1),
125 ('index', 'datatable-licenses', 1, 1, 1, 1, 'Getting data for licenses keys table', 1),
126 ('index', 'datatable-storages', 1, 1, 1, 1, 'Getting data for Storages', 1),
127 ('index', 'datatable-streaming', 1, 1, 1, 1, 'Getting data for Streaming', 1);
128
129 ++ migrated (0.01s)
130
131 ++ migrating 1535720192
132
133 -> --
134INSERT INTO `adm_grp_action_access`
135(`controller_name`, `action_name`, `is_ajax`, `description`)
136VALUES
137('users', 'toggle-status', 1, 'Status changed for users'),
138('users', 'remove-users', 1, 'Remove users'),
139('users', 'change-users-reseller', 1, 'Reseller is assigned to users'),
140('users', 'clear-users-reseller', 1, 'Reseller is unassigned to users');
141
142 ++ migrated (0s)
143
144 ++ migrating 1535720193
145
146 -> --
147ALTER TABLE `video_season` MODIFY `season_number` SMALLINT NOT NULL;
148ALTER TABLE `video_season` MODIFY `season_series` SMALLINT NOT NULL DEFAULT 0;
149
150 ++ migrated (0.03s)
151
152 ++ migrating 1535720194
153
154 -> INSERT INTO `adm_grp_action_access`
155( `controller_name`, `action_name`, `is_ajax`, `description`)
156VALUES ('tv-channels', 'check-channel-name', 1, 'Checking channel name'),
157 ('tv-channels', 'check-channel-number', 1, 'Checking channel number');
158
159 ++ migrated (0s)
160
161 ++ migrating 1535720195
162
163 -> INSERT INTO `adm_grp_action_access`
164( `controller_name`, `action_name`, `is_ajax`, `description`)
165VALUES ('tariffs', 'check-tariff-name', 1, 'Checking tariff name'),
166 ('tariffs', 'check-package-name ', 1, 'Checking package number');
167
168 ++ migrated (0s)
169
170 ++ migrating 1535720196
171
172 -> --
173update adm_grp_action_access set is_ajax = 0 where action_name = 'message-templates';
174
175 ++ migrated (0s)
176
177 ++ migrating 20190402162130
178
179 -> ALTER TABLE `user_log` ADD COLUMN `media_id` INT NULL DEFAULT 0;
180
181 ++ migrated (0.81s)
182
183 ++ migrating 20190402191636
184
185 -> ALTER TABLE smac_codes ADD expire_date BIGINT DEFAULT -1 NOT NULL, ADD count_cleared INT DEFAULT -1 NOT NULL, ADD count_clearing INT DEFAULT -1 NOT NULL
186
187 ++ migrated (0.66s)
188
189 ++ migrating 20190409113241
190
191Migration 20190409113241 was executed but did not result in any SQL statements.
192
193 ++ migrated (0s)
194
195 ++ migrating 20190411183424
196
197 -> ALTER TABLE smac_codes ADD end_cleared_date BIGINT DEFAULT -1 NOT NULL
198
199 ++ migrated (0.82s)
200
201 ++ migrating 20190415124322
202
203 -> --
204ALTER TABLE `smac_codes` MODIFY `status` ENUM("Not Activated", "Activated", "Blocked", "Manually entered", "Reserved")
205 DEFAULT "Not Activated";
206
207 ++ migrated (0.01s)
208
209 ++ migrating 20190415135112
210
211 -> ALTER TABLE smac_codes CHANGE end_cleared_date end_cleared_date BIGINT DEFAULT -1
212
213 ++ migrated (0.85s)
214
215 ++ migrating 20190422133134
216
217 -> UPDATE smac_codes SET status = "Reserved" WHERE status = "Blocked"
218
219 ++ migrated (0s)
220
221 ++ migrating 20190710145830
222
223 -> ALTER TABLE updates ADD history_hash VARCHAR(255) DEFAULT NULL
224
225 ++ migrated (0.75s)
226
227 ++ migrating 20190805112404
228
229 -> CREATE UNIQUE INDEX uid_idx ON stb_in_group (uid)
230Migration 20190805112404 failed during Execution. Error An exception occurred while executing 'CREATE UNIQUE INDEX uid_idx ON stb_in_group (uid)':
231
232SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '41' for key 'uid_idx'
233
234
235 [Doctrine\DBAL\Exception\UniqueConstraintViolationException]
236 An exception occurred while executing 'CREATE UNIQUE INDEX uid_idx ON stb_in_group (uid)':
237 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '41' for key 'uid_idx'
238
239
240
241 [Doctrine\DBAL\Driver\PDOException]
242 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '41' for key 'uid_idx'
243
244
245
246 [PDOException]
247 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '41' for key 'uid_idx'
248
249
250migrations:migrate [--write-sql] [--dry-run] [--query-time] [--allow-no-migration] [--configuration [CONFIGURATION]] [--db-configuration [DB-CONFIGURATION]] [--] [<version>]
251
252Loading configuration from the integration code of your framework (setter).
253
254 Ministra DB Migrations
255
256
257WARNING! You have 2 previously executed migrations in the database that are not registered migrations.
258 >> ()
259 >> ()
260Migrating down to 1535720186 from 20190710145830
261
262 -- reverting 20190710145830
263
264 -> ALTER TABLE updates DROP history_hash
265
266 -- reverted (0.86s)
267
268 -- reverting 20190422133134
269
270 -> UPDATE smac_codes SET status = "Blocked" WHERE status = "Reserved"
271
272 -- reverted (0s)
273
274 -- reverting 20190415135112
275
276 -> ALTER TABLE smac_codes CHANGE end_cleared_date end_cleared_date BIGINT DEFAULT -1 NOT NULL
277
278 -- reverted (0.93s)
279
280 -- reverting 20190415124322
281
282 -> ALTER TABLE `smac_codes` MODIFY `status` ENUM("Not Activated", "Activated", "Blocked") DEFAULT "Not Activated";
283--
284
285 -- reverted (0.01s)
286
287 -- reverting 20190411183424
288
289 -> ALTER TABLE smac_codes DROP end_cleared_date
290
291 -- reverted (0.98s)
292
293 -- reverting 20190409113241
294
295Migration 20190409113241 was executed but did not result in any SQL statements.
296
297 -- reverted (0s)
298
299 -- reverting 20190402191636
300
301 -> ALTER TABLE smac_codes DROP expire_date, DROP count_cleared, DROP count_clearing
302
303 -- reverted (0.84s)
304
305 -- reverting 20190402162130
306
307 -> ALTER TABLE `user_log` DROP COLUMN `media_id`;
308
309 -- reverted (0.01s)
310
311 -- reverting 1535720196
312
313Migration 1535720196 was executed but did not result in any SQL statements.
314
315 -- reverted (0s)
316
317 -- reverting 1535720195
318
319 -> DELETE FROM `adm_grp_action_access` WHERE controller_name='tariffs' AND action_name='check-package-name';
320DELETE FROM `adm_grp_action_access` WHERE controller_name='tariffs' AND action_name='check-tariff-name';
321--
322
323 -- reverted (0s)
324
325 -- reverting 1535720194
326
327 -> DELETE FROM `adm_grp_action_access` WHERE controller_name='tv-channels' AND action_name='check-channel-number';
328DELETE FROM `adm_grp_action_access` WHERE controller_name='tv-channels' AND action_name='check-channel-name';
329--
330
331 -- reverted (0s)
332
333 -- reverting 1535720193
334
335 -> ALTER TABLE `video_season` MODIFY `season_series` TINYINT NOT NULL DEFAULT 0;
336ALTER TABLE `video_season` MODIFY `season_number` TINYINT NOT NULL;
337--
338
339 -- reverted (0.03s)
340
341 -- reverting 1535720192
342
343 -> DELETE FROM `adm_grp_action_access` WHERE controller_name='users' AND action_name='toggle-status';
344DELETE FROM `adm_grp_action_access` WHERE controller_name='users' AND action_name='remove-users';
345DELETE FROM `adm_grp_action_access` WHERE controller_name='users' AND action_name='change-users-reseller';
346DELETE FROM `adm_grp_action_access` WHERE controller_name='users' AND action_name='clear-users-reseller';
347--
348
349 -- reverted (0.01s)
350
351 -- reverting 1535720191
352
353 -> DELETE FROM `adm_grp_action_access` WHERE controller_name='index' AND action_name='datatable-devices';
354DELETE FROM `adm_grp_action_access` WHERE controller_name='index' AND action_name='datatable-content';
355DELETE FROM `adm_grp_action_access` WHERE controller_name='index' AND action_name='datatable-licenses';
356DELETE FROM `adm_grp_action_access` WHERE controller_name='index' AND action_name='datatable-storages';
357DELETE FROM `adm_grp_action_access` WHERE controller_name='index' AND action_name='datatable-streaming';
358INSERT INTO `adm_grp_action_access`
359(`controller_name`, `action_name`, `is_ajax`, `view_access`, `edit_access`, `action_access`, `description`, `hidden`)
360VALUES ('index', 'index-datatable1-list-json', 1, 1, 1, 1, 'Getting data for index page', 1),
361 ('index', 'index-datatable2-list-json', 1, 1, 1, 1, 'Getting data for index page', 1),
362 ('index', 'index-datatable3-list-json', 1, 1, 1, 1, 'Getting data for index page', 1);
363--
364
365 -- reverted (0.01s)
366
367 -- reverting 1535720190
368
369Migration 1535720190 was executed but did not result in any SQL statements.
370
371 -- reverted (0s)
372
373 -- reverting 1535720189
374
375Migration 1535720189 was executed but did not result in any SQL statements.
376
377 -- reverted (0s)
378
379 -- reverting 1535720188
380
381 -> DROP TABLE `resellers_ips_ranges`;
382ALTER TABLE users DROP COLUMN last_change_ip;
383ALTER TABLE reseller DROP COLUMN use_ip_ranges;
384--
385
386 -- reverted (0.09s)
387
388 -- reverting 1535720187
389
390 -> ALTER TABLE `video` DROP INDEX `admin_id` ;
391ALTER TABLE `video` DROP `admin_id`;
392--
393Migration 1535720187 failed during Execution. Error An exception occurred while executing 'ALTER TABLE `video` DROP INDEX `admin_id` ;
394ALTER TABLE `video` DROP `admin_id`;
395--':
396
397SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'admin_id'; check that column/key exists
398
399
400 [Doctrine\DBAL\Exception\DriverException]
401 An exception occurred while executing 'ALTER TABLE `video` DROP INDEX `admin_id` ;
402 ALTER TABLE `video` DROP `admin_id`;
403 --':
404 SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'admin_id'; check that column/key exists
405
406
407
408 [Doctrine\DBAL\Driver\PDOException]
409 SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'admin_id'; check that column/key exists
410
411
412
413 [PDOException]
414 SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'admin_id'; check that column/key exists
415
416
417migrations:migrate [--write-sql] [--dry-run] [--query-time] [--allow-no-migration] [--configuration [CONFIGURATION]] [--db-configuration [DB-CONFIGURATION]] [--] [<version>]
418
419Failed migration rollback command
420
421BUILD FAILED
422/var/www/stalker_portal/deploy/build.xml:357:12: /var/www/stalker_portal/deploy/build.xml:363:26: Migrations run failed
423
424Total time: 29.8683 seconds