Bug #58172 Column performance_schema.threads.processlist_time out of range
Submitted: 13 Nov 2010 7:10 Modified: 4 Jan 2011 8:11
Reporter: Alexander Nozdrin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Performance Schema Severity:S3 (Non-critical)
Version:5.6 (Erica) OS:Any
Assigned to: Marc ALFF CPU Architecture:Any
Tags: experimental, pb2, sporadic, test failure

[13 Nov 2010 7:10] Alexander Nozdrin
Description:
perfschema.func_file_io [ fail ]
        Test ended at 2010-11-12 15:59:59

CURRENT_TEST: perfschema.func_file_io
--- /export/home/pb2/test/sb_0-2519939-1289568614.58/mysql-5.6.99-m5-linux-i686-test/mysql-test/suite/perfschema/r/func_file_io.result	2010-11-12 15:33:03.000000000 +0300
+++ /export/home/pb2/test/sb_0-2519939-1289568614.58/mysql-5.6.99-m5-linux-i686-test/mysql-test/suite/perfschema/r/func_file_io.reject	2010-11-12 17:59:59.000000000 +0300
@@ -3,6 +3,8 @@
 WHERE name LIKE 'wait/io/file/%';
 update performance_schema.threads SET instrumented = 'YES'
   WHERE PROCESSLIST_ID=connection_id();
+Warnings:
+Warning	1264	Out of range value for column 'PROCESSLIST_TIME' at row 10
 DROP TABLE IF EXISTS t1;
 CREATE TABLE t1 (id INT PRIMARY KEY, b CHAR(100) DEFAULT 'initial value')
 ENGINE=MyISAM;

mysqltest: Result content mismatch

 - saving '/export/home/pb2/test/sb_0-2519939-1289568614.58/mysql-5.6.99-m5-linux-i686-test/mysql-test/var-ps_row/log/perfschema.func_file_io/' to '/export/home/pb2/test/sb_0-2519939-1289568614.58/mysql-5.6.99-m5-linux-i686-test/mysql-test/var-ps_row/log/perfschema.func_file_io/'

Retrying test perfschema.func_file_io, attempt(2/3)...

perfschema.func_file_io                  [ retry-pass ]     70

Retrying test perfschema.func_file_io, attempt(3/3)...

perfschema.func_file_io                  [ retry-pass ]    105

How to repeat:
XRef: http://pb2.norway.sun.com/?template=mysql_show_test_failure&test_failure_id=&test_output_i...
[13 Nov 2010 7:11] Alexander Nozdrin
The test case has been marked experimental due to this bug.
[2 Dec 2010 8:07] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/125752

3406 Marc Alff	2010-12-02
      Bug#58172 Column performance_schema.threads.processlist_time out of range
      
      Before this fix, the column processlist_time in table performance_schema.threads
      could receive out of range values.
      
      Some negative time was computed, because timers may have some drift and are not
      guaranteed to be always monotonous.
      
      This fix replaces negative time values with 0, to correct the data,
      and make the data fit into an unsigned column.
[3 Dec 2010 1:14] Christopher Powers
Patch approved.
[3 Dec 2010 8:52] Marc ALFF
Pushed into:
- mysql-trunk-bugfixing
[5 Dec 2010 12:40] Bugs System
Pushed into mysql-trunk 5.6.1 (revid:alexander.nozdrin@oracle.com-20101205122447-6x94l4fmslpbttxj) (version source revid:alexander.nozdrin@oracle.com-20101205122447-6x94l4fmslpbttxj) (merge vers: 5.6.1) (pib:23)
[11 Dec 2010 17:05] Paul DuBois
Bug not present in any 5.6.x release. No changelog entry needed.
[22 Dec 2010 7:40] Anitha Gopi
Re opening since the test is still in default.experimental collection. Please move it out if the test is passing
[4 Jan 2011 8:11] Marc ALFF
Cleaned up default.experimental.
Re closing.