github / github/gh-ost

gh-ost aborts on trying to UPDATE, errors on invalid character

Aperta
#290 44 commenti 0 reazioni 1 assegnatario Rivendicata da @shlomi-noach Vedi su GitHub
bug
Lingua principale
Go
Stelle
13.6k
Fork
1.4k
Merge medio
2h 31m
PR unite (30g)
4

Descrizione

v1.0.21

gh-ost with --test-on-replica failed like this:

```
FATAL Error 1366: Incorrect string value: '\xE1...' for column 'column_name' at row 1; query=
```

`column_name` is a latin1 VARCHAR and the value coming in the UPDATE statement contained this problematic character:

á

So this may be related to the safe SQL mode settings.

The binlogs showed this:
- first, a row with the relevant `id` is INSERTed into the ghost table. At the moment, the data contains no \xE1 character.
- eventually, there is incoming UPDATE for the original table that introduces the \xE1 character. gh-ost refuses to handle it and aborts

Guida per i contributori

Apri la guida per i contributori

Valutazione

Questa issue non è ancora stata valutata.

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.