> add foreign key fk_profile_od_to_profile: PROFILE_ORDER_DISCOUNT (PROFILE_ID) references PROFILE (PROFILE_ID) ... done (time: 0.191s)
    > add foreign key fk_profile_od_to_discount_type: PROFILE_ORDER_DISCOUNT (PROFILE_ORDER_DISCOUNT_TYPE_ID) references PROFILE_ORDER_DISCOUNT_TYPES (PROFILE_ORDER_DISCOUNT_TYPE_ID) ... done (time: 0.174s)
    > create index idx_profile_order_issue_id on PROFILE_ORDER_DISCOUNT (PROFILE_ORDER_DISCOUNT_TYPE_ID,ORDER_ISSUE_ID) ... done (time: 0.045s)
    > create index idx_profile_order_issue_id_profile_id on PROFILE_ORDER_DISCOUNT (PROFILE_ORDER_DISCOUNT_TYPE_ID,ORDER_ISSUE_ID,PROFILE_ID) ... done (time: 0.024s)
*** applied m190121_063438_add_profile_discount (time: 72.759s)

*** applying m190122_072349_add_profile_metrics
    > create table PROFILE_METRICS_TYPE ... done (time: 0.025s)
    > insert into PROFILE_METRICS_TYPE ... done (time: 0.003s)
    > insert into PROFILE_METRICS_TYPE ... done (time: 0.002s)
    > create table PROFILE_METRICS ... done (time: 0.041s)
    > add foreign key idx_profile_metrics_metric_type_id: PROFILE_METRICS (PROFILE_METRICS_TYPE_ID) references PROFILE_METRICS_TYPE (PROFILE_METRICS_TYPE_ID) ... done (time: 0.040s)
    > create index idx_profile_metrics_phone on PROFILE_METRICS (PHONE) ... done (time: 0.012s)
    > add foreign key idx_profile_metrics_profile_id: PROFILE_METRICS (PROFILE_ID) references PROFILE (PROFILE_ID) ... done (time: 0.085s)
    > execute SQL: CREATE VIEW VIEW_CANCELLED_ORDERS as
SELECT 1, `PHONE`, PROFILE_ID, SUM(`VALUE`) as `VALUE` FROM (
  SELECT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(PHONE, ' ', ''), '+', ''), '(', ''), ')', ''), '-', '') as `PHONE`, PROFILE_ID, count(1) as `VALUE`
    FROM tanuki.ORDER_ISSUE
    WHERE ORDER_STATUS_ID IN (4, 12)
    AND CREATE_DATE BETWEEN SUBDATE(NOW(), INTERVAL 1 YEAR) AND NOW()
    GROUP BY PROFILE_ID, REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(PHONE, ' ', ''), '+', ''), '(', ''), ')', ''), '-', '')
  UNION ALL
   SELECT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(PHONE, ' ', ''), '+', ''), '(', ''), ')', ''), '-', '') as `PHONE`, PROFILE_ID, count(1) as `VALUE`
   FROM tanuki.ORDER_ISSUE_ARCHIVE
   WHERE ORDER_STATUS_ID IN (4, 12)
     AND CREATE_DATE BETWEEN SUBDATE(NOW(), INTERVAL 1 YEAR) AND NOW()
   GROUP BY PROFILE_ID, REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(PHONE, ' ', ''), '+', ''), '(', ''), ')', ''), '-', '')
) A GROUP BY PROFILE_ID, PHONE ORDER BY `VALUE` DESC
 ... done (time: 0.003s)
    > execute SQL: INSERT INTO PROFILE_METRICS (PROFILE_METRICS_TYPE_ID, PHONE, PROFILE_ID, VALUE)
          SELECT * FROM VIEW_CANCELLED_ORDERS ...Exception: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`stage20190125135013`.`PROFILE_METRICS`, CONSTRAINT `idx_profile_metrics_profile_id` FOREIGN KEY (`PROFILE_ID`) REFERENCES `PROFILE` (`PROFILE_ID`))
The SQL being executed was: INSERT INTO PROFILE_METRICS (PROFILE_METRICS_TYPE_ID, PHONE, PROFILE_ID, VALUE)
          SELECT * FROM VIEW_CANCELLED_ORDERS (/var/www/stage/releases/20190125135013/vendor/yiisoft/yii2/db/Schema.php:664)
#0 /var/www/stage/releases/20190125135013/vendor/yiisoft/yii2/db/Command.php(1263): yii\db\Schema->convertException(Object(PDOException), 'INSERT INTO PRO...')
#1 /var/www/stage/releases/20190125135013/vendor/yiisoft/yii2/db/Command.php(1075): yii\db\Command->internalExecute('INSERT INTO PRO...')
#2 /var/www/stage/releases/20190125135013/vendor/yiisoft/yii2/db/Migration.php(219): yii\db\Command->execute()
#3 /var/www/stage/releases/20190125135013/common/migrations/db/m190122_072349_add_profile_metrics.php(67): yii\db\Migration->execute('INSERT INTO PRO...')
#4 /var/www/stage/releases/20190125135013/vendor/yiisoft/yii2/db/Migration.php(114): m190122_072349_add_profile_metrics->safeUp()
#5 /var/www/stage/releases/20190125135013/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(725): yii\db\Migration->up()
#6 /var/www/stage/releases/20190125135013/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(199): yii\console\controllers\BaseMigrateController->migrateUp('m190122_072349_...')
#7 [internal function]: yii\console\controllers\BaseMigrateController->actionUp(0)
#8 /var/www/stage/releases/20190125135013/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#9 /var/www/stage/releases/20190125135013/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams(Array)
#10 /var/www/stage/releases/20190125135013/vendor/yiisoft/yii2/console/Controller.php(148): yii\base\Controller->runAction('', Array)
#11 /var/www/stage/releases/20190125135013/vendor/yiisoft/yii2/base/Module.php(528): yii\console\Controller->runAction('', Array)
#12 /var/www/stage/releases/20190125135013/vendor/yiisoft/yii2/console/Application.php(180): yii\base\Module->runAction('migrate', Array)
#13 /var/www/stage/releases/20190125135013/vendor/yiisoft/yii2/console/Application.php(147): yii\console\Application->runAction('migrate', Array)
#14 /var/www/stage/releases/20190125135013/vendor/yiisoft/yii2/base/Application.php(386): yii\console\Application->handleRequest(Object(yii\console\Request))
#15 /var/www/stage/releases/20190125135013/console/yii(26): yii\base\Application->run()
#16 {main}
*** failed to apply m190122_072349_add_profile_metrics (time: 33.659s)


3 from 4 migrations were applied.

Migration failed. The rest of the migrations are canceled.
Build step 'Execute shell' marked build as failure
Finished: FAILURE