Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

SQL error: Data too long for column 'user_id' #16249

Closed
orlitzky opened this issue Jul 28, 2020 · 1 comment · Fixed by #16250
Closed

SQL error: Data too long for column 'user_id' #16249

orlitzky opened this issue Jul 28, 2020 · 1 comment · Fixed by #16250
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Milestone
4.0.0

Comments

@orlitzky
Copy link

We hit this SQL error last night:

Error query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'user_id' at row 1...
Parameters: array (
ERROR BulkTracking[2020-07-28 06:59:44 UTC] [6291e] 0 => '�?���',
ERROR BulkTracking[2020-07-28 06:59:44 UTC] [6291e] 1 => 'S�(<�',
ERROR BulkTracking[2020-07-28 06:59:44 UTC] [6291e] 2 => '�k�w',
ERROR BulkTracking[2020-07-28 06:59:44 UTC] [6291e] 3 => 237,
ERROR BulkTracking[2020-07-28 06:59:44 UTC] [6291e] 4 => '%252525252525252525252525252525252525252525252525252525252525252525252525252525252528...%252525252525252525252525252525252525252525252525252525252525252525252525252525252529a.langton@Sus.ta.i.n.j.ex.k@fen.Gku.an.gx.r.ku.ai8.xn%252525252525252525252525252525252525252525252525252525252525252525252525252525252520.xn%252525252525252525252525252525252525252525252525252525252525252525252525252525252520.u.k@Meli.S.a.Ri.c.h4223@e.xultan.tacoustic.sfat.lettuceerz@fault.ybeamdulltnderwearertwe.s.e@p.laus.i.bleljh@r.eces.si.v.e.x.g.z@leanna.langton@WWW.EMEKAOLISA@www.karunakumari46@sh.jdus.h.a.i.j.5.8.7.4.8574.85@c.o.nne.c.t.tn.tu@Go.O.gle.email.2.%25252525252525252525252525252525252525252525252525252525252525252525252525252525255C%25252525252525252525252525252525252525252525252525252525252525252525252525252525255Cn1@sarahjohnsonw.estbrookbertrew.e.r@hu.fe.ng.k.Ua.ngniu.bi..uk41@Www.Zanele@silvia.woodw.o.r.t.h@w.anting.parentcrazyre.stfir.stdro@www.mondaymorninginspiration@fidelia.commons@Hu.Fen.Gk.Uang.Ni.U.B.I.Xn--.U.K.6.2@p.a.r.a.ju.mp.e.r.sj.a.s.s.en20.14@Leanna.Langton@Your.Qwe.Aqmail@Sus.Ta.I.N.J.Ex.K',
ERROR BulkTracking[2020-07-28 06:59:44 UTC] [6291e] 5 => '2020-07-27 05:16:49',

Obviously that horrendous "user id" is to blame. The associated log file entry is,

www.example.org 172.107.167.119 - %252525252525252525252525252525252525252525252525252525252525252525252525252525252528...%252525252525252525252525252525252525252525252525252525252525252525252525252525252529a.langton@Sus.ta.i.n.j.ex.k@fen.Gku.an.gx.r.ku.ai8.xn%252525252525252525252525252525252525252525252525252525252525252525252525252525252520.xn%252525252525252525252525252525252525252525252525252525252525252525252525252525252520.u.k@Meli.S.a.Ri.c.h4223@e.xultan.tacoustic.sfat.lettuceerz@fault.ybeamdulltnderwearertwe.s.e@p.laus.i.bleljh@r.eces.si.v.e.x.g.z@leanna.langton@WWW.EMEKAOLISA@www.karunakumari46@sh.jdus.h.a.i.j.5.8.7.4.8574.85@c.o.nne.c.t.tn.tu@Go.O.gle.email.2.%25252525252525252525252525252525252525252525252525252525252525252525252525252525255C%25252525252525252525252525252525252525252525252525252525252525252525252525252525255Cn1@sarahjohnsonw.estbrookbertrew.e.r@hu.fe.ng.k.Ua.ngniu.bi..uk41@Www.Zanele@silvia.woodw.o.r.t.h@w.anting.parentcrazyre.stfir.stdro@www.mondaymorninginspiration@fidelia.commons@Hu.Fen.Gk.Uang.Ni.U.B.I.Xn--.U.K.6.2@p.a.r.a.ju.mp.e.r.sj.a.s.s.en20.14@Leanna.Langton@Your.Qwe.Aqmail@Sus.Ta.I.N.J.Ex.K [27/Jul/2020:01:16:49 -0400] "GET /en/node/2265/track HTTP/1.1" 301 - "https://%25252525252525252525252525252525252525252525252525252525252525252525252525252525252528...%25252525252525252525252525252525252525252525252525252525252525252525252525252525252529a.langton@Sus.ta.i.n.j.ex.k@fen.Gku.an.gx.r.ku.ai8.xn%25252525252525252525252525252525252525252525252525252525252525252525252525252525252520.xn%25252525252525252525252525252525252525252525252525252525252525252525252525252525252520.u.k@Meli.S.a.Ri.c.h4223@e.xultan.tacoustic.sfat.lettuceerz@fault.ybeamdulltnderwearertwe.s.e@p.laus.i.bleljh@r.eces.si.v.e.x.g.z@leanna.langton@WWW.EMEKAOLISA@www.karunakumari46@sh.jdus.h.a.i.j.5.8.7.4.8574.85@c.o.nne.c.t.tn.tu@Go.O.gle.email.2.%2525252525252525252525252525252525252525252525252525252525252525252525252525252525255C%2525252525252525252525252525252525252525252525252525252525252525252525252525252525255Cn1@sarahjohnsonw.estbrookbertrew.e.r@hu.fe.ng.k.Ua.ngniu.bi..uk41@Www.Zanele@silvia.woodw.o.r.t.h@w.anting.parentcrazyre.stfir.stdro@www.mondaymorninginspiration@fidelia.commons@Hu.Fen.Gk.Uang.Ni.U.B.I.Xn--.U.K.6.2@p.a.r.a.ju.mp.e.r.sj.a.s.s.en20.14@Leanna.Langton@Your.Qwe.Aqmail@Sus.Ta.I.N.J.Ex.K@www.example.org/" "Mozilla/5.0 (X11; OpenBSD i386) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/43.0.2357.125 Safari/537.36"

This is during an off-line mass log file import. I guess that column should be sanitized, within reason?
@tsteur tsteur added the Bug For errors / faults / flaws / inconsistencies etc. label Jul 28, 2020
@tsteur tsteur added this to the Priority Backlog (Help wanted) milestone Jul 28, 2020
@tsteur tsteur mentioned this issue Jul 28, 2020
Merged
@tsteur
Copy link
Member

tsteur commented Jul 28, 2020

Thanks for letting us know @orlitzky

I've created a PR for this in #16250 which should fix this and truncate the userId automatically to 200.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Projects
None yet
Milestone
4.0.0
Development

Successfully merging a pull request may close this issue.

Truncate userId to prevent error data too long matomo-org/matomo
3 participants
@tsteur @mattab @orlitzky