Invalid packets on long running queries
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Connector/Python |
Fix Released
|
Critical
|
Geert JM Vanderkelen | ||
Ubuntu |
Invalid
|
Undecided
|
Unassigned |
Bug Description
Doing in I_S: SELECT * FROM TABLES a, TABLES b gives 'sometimes' an invalid packet length.
Header says length is 433, but buffer is 279 long
b1 01 00 dc fb 12 69 6e 66 6f 72 6d 61 74 69 6f 6e 5f 73 63 68 65 6d 61 05 56 49
45 57 53 0b 53 59 53 54 45 4d 20 56 49 45 57 06 4d 79 49 53 41 4d 02 31 30 07 44
79 6e 61 6d 69 63 fb 01 30 01 30 0f 32 38 31 34 37 34 39 37 36 37 31 30 36 35 35
04 31 30 32 34 01 30 fb 13 32 30 30 39 2d 30 32 2d 31 34 20 30 39 3a 35 34 3a 33
32 13 32 30 30 39 2d 30 32 2d 31 34 20 30 39 3a 35 34 3a 33 32 fb 0f 75 74 66 38
5f 67 65 6e 65 72 61 6c 5f 63 69 fb 0d 6d 61 78 5f 72 6f 77 73 3d 36 39 33 32 00
fb 12 69 6e 66 6f 72 6d 61 74 69 6f 6e 5f 73 63 68 65 6d 61 0a 43 4f 4c 4c 41 54
49 4f 4e 53 0b 53 59 53 54 45 4d 20 56 49 45 57 06 4d 45 4d 4f 52 59 02 31 30 05
46 69 78 65 64 fb 03 34 32 33 01 30 08 31 36 37 33 37 32 36 34 01 30 01 30 fb fb
fb fb 0f 75 74 66 38 5f 67 65 6e 65 72 61 6c 5f 63 69 fb 0e 6d 61 78 5f 72 6f 77
73 3d 33 39 36 36 32 00 fb 12 69 6e 66
Only seen on OpenSolaris for now. Worked fine on Mac OS.
(BTW, queries was just to make a test case..)
Related branches
Changed in myconnpy: | |
assignee: | nobody → geertjmvdk |
importance: | Undecided → Critical |
status: | New → Confirmed |
Changed in myconnpy: | |
status: | In Progress → Fix Committed |
Changed in myconnpy: | |
milestone: | none → 0.1.4 |
Changed in myconnpy: | |
status: | Fix Committed → Fix Released |
I think I'm running into this quite alot on on Linux (Ubuntu 9.04). Very hard to reproduce and non-deterministic in nature. Always results in 'Invalid Packet' on the RowDataPacket. Would a stack trace help or do you have enough information at this point to address the defect? My particular queries don't seem to be long running though they seem to occur more from my laptop connected via wifi than a desktop connected over gigabit ethernet so latency may have something to do with it. Any known workarounds?