# pt-online-schema-change and nohup

**URL:** <https://forums.percona.com/t/pt-online-schema-change-and-nohup/2923>\
**Category:** Percona Toolkit\
**Created:** [September 5, 2013, 3:24am UTC](https://forums.percona.com/t/pt-online-schema-change-and-nohup/2923 "2013-09-05T03:24:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sue](https://avatars.discourse-cdn.com/v4/letter/s/87869e/32.png) [@Sue](https://forums.percona.com/u/Sue)\
**Post date:** [September 5, 2013, 3:24am UTC](https://forums.percona.com/t/pt-online-schema-change-and-nohup/2923/1 "2013-09-05T03:24:09Z")

</div>

Hi all,

I am using pt-online-schema-change and running it with a nohup. The change is a long one - 40 hours, so needs protecting with a nohup command. I maybe doing some wrong but when I run the following and lose my session it fails:

nohup pt-online-schema-change -u root --chunk-size-limit=0 --chunk-size=1000000 --max-load=Threads\_running=100 --max-lag=6000 --statistics --recursion-method=none --set-vars lock\_wait\_timeout=1800 --execute --alter=“ADD COLUMN suetest\_col101 int” D=suetest,t=suetest,u=root &

# 2 software updates are available:

# \* Security vulnerability. See [http://www.mysqlperformanceblog.com/2012/09/10/introducing-the-version-check-feature-in-percona-toolkit/](http://www.mysqlperformanceblog.com/2012/09/10/introducing-the-version-check-feature-in-percona-toolkit/). The current version for MySQL Community Server (GPL) is 5.5.32.

# \* The current version for Percona::Toolkit is 2.2.4.

Operation, tries, wait:  
copy\_rows, 10, 0.25  
create\_triggers, 10, 1  
drop\_triggers, 10, 1  
swap\_tables, 10, 1  
update\_foreign\_keys, 10, 1  
Altering `suetest`.`suetest`…  
Creating new table…  
Created new table suetest.\_suetest\_new OK.  
Altering new table…  
Altered `suetest`.`_suetest_new` OK.  
Creating triggers…  
Created triggers OK.  
Copying approximately 14464903 rows…

# Exiting on SIGHUP.

Not dropping triggers because the tool was interrupted. To drop the triggers, execute:  
DROP TRIGGER IF EXISTS `suetest`.`pt_osc_suetest_suetest_del`;  
DROP TRIGGER IF EXISTS `suetest`.`pt_osc_suetest_suetest_upd`;  
DROP TRIGGER IF EXISTS `suetest`.`pt_osc_suetest_suetest_ins`;  
Not dropping the new table `suetest`.`_suetest_new` because the tool was interrupted. To drop the new table, execute:  
DROP TABLE IF EXISTS `suetest`.`_suetest_new`;

# Event Count

# ====== =====

# INSERT 2

`suetest`.`suetest` was not altered.

Thanks for looking.

---

<div class="post-metadata">

**Author:** ![eroomydna](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/eroomydna/32/941_2.png) [@eroomydna](https://forums.percona.com/u/eroomydna)\
**Post date:** [September 10, 2013, 5:02pm UTC](https://forums.percona.com/t/pt-online-schema-change-and-nohup/2923/2 "2013-09-10T17:02:20Z")

</div>

Did you try using screen (& nohup), you might have some different results here without having to drop the session?