Not the answer you need?
Register and ask your own question!

pt-online-schema-change table is full

donkamesendonkamesen EntrantCurrent User Role Beginner
I ran pt-online-schema-change on a large table of 275G
The processes failed. Now I am getting a lot of errors:
/usr/sbin/mysqld: The table 'txn_line' is full
The file system has more than 600G available.
The temp file system is 50G.
Is there a limit on the size of a new table?


This is from the output from the script:
Copying `prd_rz_02`.`txn_line`: 58% 1+13:19:44 remain
Dropping triggers...
Dropped triggers OK.
Dropping new table...
Dropped new table OK.
`prd_rz_02`.`txn_line` was not altered.
Error copying rows from `prd_rz_02`.`txn_line` to `prd_rz_02`.`_txn_line_new`:
DBD::mysql::st execute failed: The table '_txn_line_new' is full [for Statement "INSERT LOW_PRIORITY IGNORE INTO `prd_rz_02`.`_txn_line_new` (`...
/*pt-online-schema-change 15072 copy nibble*/" with ParamValues: 4='.)gjÏ.s^M¶.^M.Ûß.ª', 1='.(<8d>yY¸"¼.Â.óöv<Â', 3='.)gjÏ.s^M¶.^M.Ûß.ª', 0='.(<8d>yY¸"¼.Â.óöv<Â', 2='2010-02-06 18:36:00', 5='2010-02-11 18:29:00']
at /usr/bin/pt-online-schema-change line 9531.


Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.