# Copying \`test\`.\`testtable\_copy1\`: 99% 00:01 remain # Exiting on SIGHUP **URL:** \ **Category:** Percona Server for MySQL 5.7\ **Tags:** community, mysql, percona\ **Created:** [March 4, 2023, 1:06pm UTC](https://forums.percona.com/t/copying-test-testtable-copy1-99-00-01-remain-exiting-on-sighup/20418 "2023-03-04T13:06:16Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![404\_error](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/404_error/32/9603_2.png) [@404\_error](https://forums.percona.com/u/404_error)\ **Post date:** [March 4, 2023, 1:06pm UTC](https://forums.percona.com/t/copying-test-testtable-copy1-99-00-01-remain-exiting-on-sighup/20418/1 "2023-03-04T13:06:16Z")
Hi When I use pt-online-schema-change 3.4.0 to add column to a large mysql table of 50 million, I get an error:Exiting on SIGHUP. Here are my steps and related information. 1. OS version is CentOS 7.9 (Final) 4.14.105-19-0023.1 #1 SMP Tue Mar 8 15:12:36 CST 2022 x86\_64 x86\_64 x86\_64 x86\_64 GNU/Linux 2. script: #! /bin/bash host=“127.0.0.1” port=“3306” user=“root” passwd=“password” database=“test” table=“test\_copy1” echo `date +"%Y-%m-%d %H:%M:%S"` echo $table /bin/pt-online-schema-change --host=${host} --port=${port} --user=${user} --password=${passwd} --recursion-method=processlist --no- version-check --charset=“utf8” --check-interval=5 --chunk-time=1 --max-load=threads\_running:80 --max-lag=3 --chunk-size=3000 D=${database },t=${table} –alter=“ADD COLUMN matrix\_id tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘matrix ID’ AFTER sid” --print --execute 3. Execution method: nohup /bin/bash /mnt/add\_modify\_online.sh & 4. Error message: Copying `test`.`test_copy1`: 99% 00:01 remain # Exiting on SIGHUP. Not dropping triggers because the tool was interrupted. To drop the triggers, execute Could anyone plz help me out? thx so much. ---
**Author:** ![CTutte](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ctutte/32/1341_2.png) [@CTutte](https://forums.percona.com/u/CTutte)\ **Post date:** [March 21, 2023, 8:02pm UTC](https://forums.percona.com/t/copying-test-testtable-copy1-99-00-01-remain-exiting-on-sighup/20418/2 "2023-03-21T20:02:28Z")
Hi, The triggers were not dropped automatically because the tool was interrupted. You need to manually drop the triggers with the commands shown on the output of execution. And the reason for the tool to be aborted could be many. Did you manually cancel pt-osc execution? Did threads\_running reach 80 ? Was the server shutdown ? I suggest you manually remove the triggers and then test again executing pt-osc while the load on the server is down and check if the issue persists. You should also use latest pt-osc version (v 3.5.1) just in case. Regards ---
**Author:** ![Taras\_Onishchuk](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/taras_onishchuk/32/10117_2.png) [@Taras\_Onishchuk](https://forums.percona.com/u/Taras_Onishchuk)\ **Post date:** [April 12, 2023, 2:16pm UTC](https://forums.percona.com/t/copying-test-testtable-copy1-99-00-01-remain-exiting-on-sighup/20418/3 "2023-04-12T14:16:03Z")
Hi, You might want to run it with PTDEBUG=1 to see what is happening in more detail, but beware, the output can be huge. Also, do you have enough disk space for the new table? And I’d suggest running the command in a screen session, rather than sending it to the background, for easier management. ---
**Author:** ![Hidayet\_PINARAKAR](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/hidayet_pinarakar/32/18989_2.png) [@Hidayet\_PINARAKAR](https://forums.percona.com/u/Hidayet_PINARAKAR)\ **Post date:** [February 6, 2025, 6:58am UTC](https://forums.percona.com/t/copying-test-testtable-copy1-99-00-01-remain-exiting-on-sighup/20418/4 "2025-02-06T06:58:54Z")
Hello, I got the same error while using pt-online-schema-change on RDS mysql 8.03.6. The table has 570 million rows with 2 foreign keys. Mysql has a replica. The command is: tdebug=1 pt-online-schema-change D=xxx,t=xxx,[h=vxxx.ds.amazonaws.com](http://h=vxxx.ds.amazonaws.com),P=3306,u=xxx –alter “MODIFY COLUMN Id BIGINT NOT NULL AUTO\_INCREMENT,AUTO\_INCREMENT = 1885209475” --password “xxx” --execute --recursion-method=NONE --p reserve-triggers --max-load Threads\_running=60 --critical-load Threads\_running=75 --chunk-time=0 --chunk-size=10000 --sleep=1 --print --statistics I tried different options of chunk-size anf chunk-time parameters but everytime it failed. # Exiting on SIGHUP. Not dropping triggers because the tool was interrupted. To drop the triggers, execute: dou you have any idea? Thank you.