[MDEV-21467] Rows_sent: 6148914691236517205 Created: 2020-01-13 Updated: 2020-02-15 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | 10.3.11 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Vincent Milum Jr | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Environment: |
CentOS 7 |
||
| Description |
|
I'm investigating some oddities in the slow query log on a client's server. I've come across this:
This oddly high Rows_sent value is happening over and over again within their logs. 6148914691236517205 = 0x5555555555555555 This looks to be some sort of either debug value or default initialization value that isn't being set properly before being read. Any thoughts? When I get more time later this afternoon, I'll try to filter out some stuff from the logs to hopefully share schema and query information (need to ensure no NDA stuff is shared) |
| Comments |
| Comment by Elena Stepanova [ 2020-02-14 ] |
|
darkain, |
| Comment by Vincent Milum Jr [ 2020-02-14 ] |
|
This is a very active server
The main query in question hitting the slow log is short, but a little complicated. The columns returned are passed through stored functions. There is a subquery. There is JOINs. The WHERE clause uses more custom function calls. I'm going to try to break it out and eliminate each section to see if I can build a test case that still causes the issue. |