Meltano

Target-postgres (pipelinewise) is throwing a “type error” `mpsycopg2.errors.InvalidTextRepresentation: invalid input syntax for integer: "0.0"`, but I can’t find that anywhere in the data. I ran it in debug mode and I can’t find any values that would shouldn’t be able to be interpreted as an integer.

The tap is the Singer variant for MySQL using binlogging. Anyone seen anything like this before? My pipeline has been running great for a while not. Never seen this before.

Ok I figured it out (I think). There was an upstream change, but it was done by creating a temp table, dropping some columns, and replacing the old table with a new one.

So the tap was reading from the old binlog, meaning that the columns were in the wrong order.