We are trying to use gh-ost to add a new column to an existing table with a few hundreds of millions of rows and we are getting an Error 1264: Out of range value for column '...' at row 1 error message. Unfortunately, I cannot reproduce this error on my dev environment. In the prod environment, the migration goes fine until a new row is inserted into the table (so it seems to me that it has something to do with live updates, although I am just guessing since I am not too familiar with the MySql replication protocol that gh-ost uses).

The column that is causing this issue is of type Decimal(65, 30) and the values in there are pretty large (10**35-1 which is slightly smaller than the max possible value). Also in production, we have a master/slave setup that I don't have on my dev machine. Does any of these ring a bell? Is this a known issue in gh-ost?