[MDEV-4578] information_schema.processlist reports incorrect value for Time (2147483647) - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Minor
Resolution: Fixed
Affects Version/s: 10.0.2, 5.5.31, 5.1.67, 5.2.14, 5.3.12
Fix Version/s: 10.0.4, 5.5.32
Component/s: None
Labels:
None
Environment:
Debian Squeeze (6.0.6) x86_64, Linux 3.2.40. Compiled locally. This is 5.5.28-MariaDB-log.

Description

In the information_schema.processlist table, the Time column frequently reports an incorrect value of 2147483647. "show processlist" is not similarly affected. From my testing, I'm reasonably sure these queries are all less than 1 second old. I do see plenty of processes reported with an accurate Time value (>=1).

Examples (with some obfuscation):

*************************** 1. row ***************************

       ID: 81365

     USER: xxx

     HOST: xxx

       DB: xxx

  COMMAND: Query

     TIME: 2147483647

    STATE: Sending data

     INFO: select xxx left outer join xxx on xxx where xxx

  TIME_MS: 18446744073709550.000

    STAGE: 0

MAX_STAGE: 0

 PROGRESS: 0.000

*************************** 1. row ***************************

       ID: 82602

     USER: xxx

     HOST: xxx

       DB: xxx

  COMMAND: Query

     TIME: 2147483647

    STATE: optimizing

     INFO: select xxx from xxx where xxx

  TIME_MS: 18446744073709550.000

    STAGE: 0

MAX_STAGE: 0

 PROGRESS: 0.000

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

mdev4578_debug_sync.patch
0.9 kB
2013-05-27 04:06

Issue Links

duplicates

MDEV-4673 PROCESSLIST time in processlist is very high (maybe time = 0 setted and unsigned overflow?)

Closed

relates to

MDEV-773 LP:611878 - user_statistics.busy_time is unreliable

Open

MDEV-775 LP:1018694 - CPU_TIME counter from USER_STATISTICS gets wrong after some uptime

Open

MDEV-5101 INFORMATION_SCHEMA.PROCESSLIST reports an incorrect value for Time for connecting threads

Closed

Activity

Ascending order - Click to sort in descending order

Jonathan Nicol created issue - 2013-05-24 23:15

Elena Stepanova made changes - 2013-05-24 23:26

Field	Original Value	New Value
Description	In the information_schema.processlist table, the Time column frequently reports an incorrect value of 2147483647. "show processlist" is not similarly affected. From my testing, I'm reasonably sure these queries are all less than 1 second old. I do see plenty of processes reported with an accurate Time value (>=1). Examples (with some obfuscation): ************************* 1. row *********************** ID: 81365 USER: xxx HOST: xxx DB: xxx COMMAND: Query TIME: 2147483647 STATE: Sending data INFO: select xxx left outer join xxx on xxx where xxx TIME_MS: 18446744073709550.000 STAGE: 0 MAX_STAGE: 0 PROGRESS: 0.000 *********************** 1. row ************************* ID: 82602 USER: xxx HOST: xxx DB: xxx COMMAND: Query TIME: 2147483647 STATE: optimizing INFO: select xxx from xxx where xxx TIME_MS: 18446744073709550.000 STAGE: 0 MAX_STAGE: 0 PROGRESS: 0.000	In the information_schema.processlist table, the Time column frequently reports an incorrect value of 2147483647. "show processlist" is not similarly affected. From my testing, I'm reasonably sure these queries are all less than 1 second old. I do see plenty of processes reported with an accurate Time value (>=1). Examples (with some obfuscation): {noformat} ************************* 1. row *********************** ID: 81365 USER: xxx HOST: xxx DB: xxx COMMAND: Query TIME: 2147483647 STATE: Sending data INFO: select xxx left outer join xxx on xxx where xxx TIME_MS: 18446744073709550.000 STAGE: 0 MAX_STAGE: 0 PROGRESS: 0.000 *********************** 1. row ************************* ID: 82602 USER: xxx HOST: xxx DB: xxx COMMAND: Query TIME: 2147483647 STATE: optimizing INFO: select xxx from xxx where xxx TIME_MS: 18446744073709550.000 STAGE: 0 MAX_STAGE: 0 PROGRESS: 0.000 {noformat}

Elena Stepanova made changes - 2013-05-24 23:27

Assignee

Elena Stepanova [ elenst ]

Sergei Golubchik made changes - 2013-05-25 00:30

Link

This issue relates to MDEV-773 [ MDEV-773 ]

Sergei Golubchik made changes - 2013-05-25 00:30

Link

This issue relates to MDEV-775 [ MDEV-775 ]

Elena Stepanova made changes - 2013-05-27 04:06

Attachment

mdev4578_debug_sync.patch [ 22300 ]

Elena Stepanova made changes - 2013-05-27 04:20

Affects Version/s		5.1.67 [ 12100 ]
Affects Version/s		5.2.14 [ 12101 ]
Affects Version/s		5.3.12 [ 12000 ]
Affects Version/s		10.0.2 [ 11900 ]

Elena Stepanova made changes - 2013-05-27 04:21

Fix Version/s		10.0.3 [ 12900 ]
Fix Version/s		5.5.32 [ 13000 ]
Fix Version/s		5.3.13 [ 12602 ]

Elena Stepanova made changes - 2013-05-27 04:21

Assignee

Elena Stepanova [ elenst ]

Sergei Golubchik [ serg ]

Sergei Golubchik made changes - 2013-06-04 15:39

Fix Version/s		10.0.4 [ 13101 ]
Fix Version/s	10.0.3 [ 12900 ]

Sergei Golubchik made changes - 2013-06-13 17:33

Status

Open [ 1 ]

In Progress [ 3 ]

Sergei Golubchik made changes - 2013-06-14 11:01

Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2013-06-14 11:01

Resolution	Fixed [ 1 ]
Status	Closed [ 6 ]	Reopened [ 4 ]

Sergei Golubchik made changes - 2013-06-14 11:01

Fix Version/s

5.3.13 [ 12602 ]

Sergei Golubchik made changes - 2013-06-14 11:01

Resolution		Fixed [ 1 ]
Status	Reopened [ 4 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2013-06-18 00:13

Link

This issue duplicates ~~MDEV-4673~~ [ ~~MDEV-4673~~ ]

Jean Weisbuch made changes - 2013-10-04 17:36

Link

This issue relates to ~~MDEV-5101~~ [ ~~MDEV-5101~~ ]

Sergei Golubchik made changes - 2014-06-13 15:07

Workflow

defaullt [ 27541 ]

MariaDB v2 [ 46582 ]

Rasmus Johansson (Inactive) made changes - 2015-05-18 17:51

Workflow

MariaDB v2 [ 46582 ]

MariaDB v3 [ 67290 ]

Sergei Golubchik made changes - 2021-12-06 21:38

Workflow

MariaDB v3 [ 67290 ]

MariaDB v4 [ 146736 ]

People

Assignee:: Sergei Golubchik

Reporter:: Jonathan Nicol

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2013-05-24 23:15

Updated:: 2013-11-11 08:31

Resolved:: 2013-06-14 11:01

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Attachments

Issue Links

Activity

People

Dates

Git Integration