Missing --binary-mode alike parameter? Tool fails with FATAL Error 1366: Incorrect string value.
- Vorherrschende Sprache
- Go
- Sterne
- 13.6k
- Forks
- 1.4k
- Ø Merge
- 2 Std. 31 Min.
- Gemergte PRs (30 T.)
- 4
Beschreibung
The tool fails trying to run one of the REPLACE statements that have an URL with a character
Error message:
**FATAL Error 1366: Incorrect string value: '\xEF\xBF\xBDEve...' for column 'url' at row 1**
Values:
`args=[1480391318431_7062357157387106246_ACT_B_3522379_S_1005_EUIDS_NIL_EUIDE_EXCHG_3 2016-11-29 03:48:38 +0000 UTC RHEoWesPcC2cKQJ2KeSoMFyz http://www.viralvinny.com/21-places-earth-youre-not-allowed-visit/?utm_source=outbrain&utm_medium=LAZ_ViralVinny.com-Mobile-US-ForbiddenB&utm_content=hole&utm_campaign=21 Places Youre Not Allowed To Visit�Ever&utm_term=5333981 612475 US US-FL KISSIMMEE 534 14 -1 -1 0.5 -1 -1 4857156 1005 3522379 S_FEE 389 ip_address 172.58.169.187 1 0 3 -1 5246 3226465175 7010 7477 FWC0 SVM0 SVM_-1000 -1 -1 dc4ad-rtbbidder08.int.dealer.com 34744 -300 1610 en -1 -1 -1 false_NIL false_0 NIL_NIL_NIL_0.0.0 612475 3 1]`
Beitragsleitfaden
Rechercherichtung
Start by reproducing the failure in the REPLACE statement using the URL value shown and inspect how gh-ost handles MySQL character encoding. Determine whether the requested binary-mode-like parameter is needed, then verify that the offending URL no longer produces FATAL Error 1366 without breaking normal migrations.
Vom Indexierungsmodell aus dem Issue-Text verfasst.
Bewertung
- Tech-Stack
- go, mysql
- Bereich
- backend, databases
- Issue-Typ
- Bug
- Schwierigkeit
- 3/5
- Geschätzter Aufwand
- 1-2 Tage
- Aktivitätsstatus
- Veraltet
- Klarheit
- Größtenteils klar
- Anfängerfreundlichkeit
- 35/100