level 4
风清扬灬丶
楼主
数据库版本：5.6.16
Biot您好，在修改一张大表，数据量大约3亿多行。
通过pt-online工具在线修改表字段，执行到39%的时候自动退出。 查资料发现，源码中有一向是exit退出，
但是不明白是什么原因触发的退出？ 请指教，谢谢。
报错信息如下：
Copying `jxclick`.`tj_VisitData`: 39% 11:06:32 remain
# Exiting on SIGHUP.
Not dropping triggers because the tool was interrupted. To drop the triggers, execute:
DROP TRIGGER IF EXISTS `jxclick`.`pt_osc_jxclick_tj_VisitData_del`;
DROP TRIGGER IF EXISTS `jxclick`.`pt_osc_jxclick_tj_VisitData_upd`;
DROP TRIGGER IF EXISTS `jxclick`.`pt_osc_jxclick_tj_VisitData_ins`;
Not dropping the new table `jxclick`.`_tj_VisitData_new` because the tool was interrupted. To drop the new table, execute:
DROP TABLE IF EXISTS `jxclick`.`_tj_VisitData_new`;
`jxclick`.`tj_VisitData` was not altered.
2016年03月07日 01点03分
1
Biot您好，在修改一张大表，数据量大约3亿多行。
通过pt-online工具在线修改表字段，执行到39%的时候自动退出。 查资料发现，源码中有一向是exit退出，
但是不明白是什么原因触发的退出？ 请指教，谢谢。
报错信息如下：
Copying `jxclick`.`tj_VisitData`: 39% 11:06:32 remain
# Exiting on SIGHUP.
Not dropping triggers because the tool was interrupted. To drop the triggers, execute:
DROP TRIGGER IF EXISTS `jxclick`.`pt_osc_jxclick_tj_VisitData_del`;
DROP TRIGGER IF EXISTS `jxclick`.`pt_osc_jxclick_tj_VisitData_upd`;
DROP TRIGGER IF EXISTS `jxclick`.`pt_osc_jxclick_tj_VisitData_ins`;
Not dropping the new table `jxclick`.`_tj_VisitData_new` because the tool was interrupted. To drop the new table, execute:
DROP TABLE IF EXISTS `jxclick`.`_tj_VisitData_new`;
`jxclick`.`tj_VisitData` was not altered.
