Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4629

MTR tests main.variables and some of sys_vars.* fail on 32-bit builds

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.5.32
    • Component/s: None
    • Labels:

      Description

      On maria/5.5, after revision 3789 (which fixed a build problem introduced by revision 3788), 32-bit server builds, but some of the tests fail:

      http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-precise-x86/builds/942/steps/test/logs/stdio

      main.variables
      sys_vars.binlog_cache_size_basic
      sys_vars.binlog_stmt_cache_size_basic
      sys_vars.bulk_insert_buffer_size_basic
      sys_vars.join_buffer_size_basic
      sys_vars.max_binlog_cache_size_basic
      sys_vars.max_binlog_stmt_cache_size_basic
      sys_vars.sort_buffer_size_basic

      CURRENT_TEST: main.variables
      --- /usr/local/mariadb-5.5.31-linux-i686/mysql-test/r/variables.result	2013-06-09 18:23:58.000000000 +0300
      +++ /usr/local/mariadb-5.5.31-linux-i686/mysql-test/r/variables.reject	2013-06-09 22:50:54.241462001 +0300
      @@ -1495,9 +1495,11 @@
       SET @old_max_binlog_cache_size = @@GLOBAL.max_binlog_cache_size;
       # Set the max_binlog_cache_size to size more than 4GB. 
       SET GLOBAL max_binlog_cache_size = 5 * 1024 * 1024 * 1024;
      +Warnings:
      +Warning	1292	Truncated incorrect max_binlog_cache_size value: '5368709120'
       SELECT @@GLOBAL.max_binlog_cache_size;
       @@GLOBAL.max_binlog_cache_size
      -5368709120
      +4294963200
       SET GLOBAL max_binlog_cache_size = @old_max_binlog_cache_size;
       #
       # Bug #37168 : Missing variable - skip_name_resolve

      CURRENT_TEST: sys_vars.binlog_cache_size_basic
      --- /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/binlog_cache_size_basic.result	2013-06-09 18:23:55.000000000 +0300
      +++ /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/binlog_cache_size_basic.reject	2013-06-09 22:53:34.941462000 +0300
      @@ -59,7 +59,7 @@
       Warning	1292	Truncated incorrect binlog_cache_size value: '42949672950'
       SELECT @@global.binlog_cache_size;
       @@global.binlog_cache_size
      -42949668864
      +4294963200
       'Bug: Errors are not coming on assigning invalid values to variable'
       SET @@global.binlog_cache_size = ON;
       ERROR 42000: Incorrect argument type to variable 'binlog_cache_size'

      sys_vars.binlog_stmt_cache_size_basic    w1 [ fail ]
              Test ended at 2013-06-09 22:53:44

      CURRENT_TEST: sys_vars.binlog_stmt_cache_size_basic
      --- /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/binlog_stmt_cache_size_basic.result	2013-06-09 18:23:55.000000000 +0300
      +++ /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/binlog_stmt_cache_size_basic.reject	2013-06-09 22:53:44.061462000 +0300
      @@ -59,7 +59,7 @@
       Warning	1292	Truncated incorrect binlog_stmt_cache_size value: '42949672950'
       SELECT @@global.binlog_stmt_cache_size;
       @@global.binlog_stmt_cache_size
      -42949668864
      +4294963200
       'Bug: Errors are not coming on assigning invalid values to variable'
       SET @@global.binlog_stmt_cache_size = ON;
       ERROR 42000: Incorrect argument type to variable 'binlog_stmt_cache_size'

      CURRENT_TEST: sys_vars.bulk_insert_buffer_size_basic
      --- /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/bulk_insert_buffer_size_basic.result	2013-06-09 18:23:55.000000000 +0300
      +++ /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/bulk_insert_buffer_size_basic.reject	2013-06-09 22:53:49.049462001 +0300
      @@ -62,9 +62,11 @@
       429496
       '#------------------FN_DYNVARS_007_05-----------------------#'
       SET @@global.bulk_insert_buffer_size = 42949672950;
      +Warnings:
      +Warning	1292	Truncated incorrect bulk_insert_buffer_size value: '42949672950'
       SELECT @@global.bulk_insert_buffer_size;
       @@global.bulk_insert_buffer_size
      -42949672950
      +4294967295
       SET @@global.bulk_insert_buffer_size = -1024;
       Warnings:
       Warning	1292	Truncated incorrect bulk_insert_buffer_size value: '-1024'
      @@ -78,9 +80,11 @@
       SET @@global.bulk_insert_buffer_size = 429496.10;
       ERROR 42000: Incorrect argument type to variable 'bulk_insert_buffer_size'
       SET @@session.bulk_insert_buffer_size = 42949672950;
      +Warnings:
      +Warning	1292	Truncated incorrect bulk_insert_buffer_size value: '42949672950'
       SELECT @@session.bulk_insert_buffer_size;
       @@session.bulk_insert_buffer_size
      -42949672950
      +4294967295
       SET @@session.bulk_insert_buffer_size = -2;
       Warnings:
       Warning	1292	Truncated incorrect bulk_insert_buffer_size value: '-2'

      CURRENT_TEST: sys_vars.join_buffer_size_basic
      --- /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/join_buffer_size_basic.result	2013-06-09 18:23:55.000000000 +0300
      +++ /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/join_buffer_size_basic.reject	2013-06-09 22:56:09.113462002 +0300
      @@ -73,17 +73,17 @@
       Warning	1292	Truncated incorrect join_buffer_size value: '42949672951'
       SELECT @@global.join_buffer_size;
       @@global.join_buffer_size
      -42949672832
      +4294967168
       SET @@global.join_buffer_size = 65530.34;
       ERROR 42000: Incorrect argument type to variable 'join_buffer_size'
       SELECT @@global.join_buffer_size;
       @@global.join_buffer_size
      -42949672832
      +4294967168
       SET @@global.join_buffer_size = test;
       ERROR 42000: Incorrect argument type to variable 'join_buffer_size'
       SELECT @@global.join_buffer_size;
       @@global.join_buffer_size
      -42949672832
      +4294967168
       SET @@session.join_buffer_size = 0;
       Warnings:
       Warning	1292	Truncated incorrect join_buffer_size value: '0'
      @@ -107,17 +107,17 @@
       Warning	1292	Truncated incorrect join_buffer_size value: '42949672951'
       SELECT @@session.join_buffer_size;
       @@session.join_buffer_size
      -42949672832
      +4294967168
       SET @@session.join_buffer_size = 65530.34;
       ERROR 42000: Incorrect argument type to variable 'join_buffer_size'
       SELECT @@session.join_buffer_size;
       @@session.join_buffer_size
      -42949672832
      +4294967168
       SET @@session.join_buffer_size = test;
       ERROR 42000: Incorrect argument type to variable 'join_buffer_size'
       SELECT @@session.join_buffer_size;
       @@session.join_buffer_size
      -42949672832
      +4294967168
       '#------------------FN_DYNVARS_053_06-----------------------#'
       SELECT @@global.join_buffer_size = VARIABLE_VALUE 
       FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 

      CURRENT_TEST: sys_vars.max_binlog_cache_size_basic
      --- /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/max_binlog_cache_size_basic.result	2013-06-09 18:23:56.000000000 +0300
      +++ /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/max_binlog_cache_size_basic.reject	2013-06-09 22:56:57.317462001 +0300
      @@ -1,7 +1,7 @@
       SET @start_value = @@global.max_binlog_cache_size;
       SELECT @start_value;
       @start_value
      -18446744073709547520
      +4294963200
       '#--------------------FN_DYNVARS_072_01------------------------#'
       SET @@global.max_binlog_cache_size = 5000;
       Warnings:
      @@ -9,7 +9,7 @@
       SET @@global.max_binlog_cache_size = DEFAULT;
       SELECT @@global.max_binlog_cache_size;
       @@global.max_binlog_cache_size
      -18446744073709547520
      +4294963200
       '#---------------------FN_DYNVARS_072_02-------------------------#'
       SET @@global.max_binlog_cache_size = @start_value;
       SELECT @@global.max_binlog_cache_size = 4294967295;
      @@ -56,12 +56,12 @@
       Warning	1292	Truncated incorrect max_binlog_cache_size value: '100000000000'
       SELECT @@global.max_binlog_cache_size;
       @@global.max_binlog_cache_size
      -99999997952
      +4294963200
       SET @@global.max_binlog_cache_size = 10000.01;
       ERROR 42000: Incorrect argument type to variable 'max_binlog_cache_size'
       SELECT @@global.max_binlog_cache_size;
       @@global.max_binlog_cache_size
      -99999997952
      +4294963200
       SET @@global.max_binlog_cache_size = -1024;
       Warnings:
       Warning	1292	Truncated incorrect max_binlog_cache_size value: '-1024'
      @@ -75,9 +75,11 @@
       @@global.max_binlog_cache_size
       4096
       SET @@global.max_binlog_cache_size = 4294967296;
      +Warnings:
      +Warning	1292	Truncated incorrect max_binlog_cache_size value: '4294967296'
       SELECT @@global.max_binlog_cache_size;
       @@global.max_binlog_cache_size
      -4294967296
      +4294963200
       SET @@global.max_binlog_cache_size = 4095;
       Warnings:
       Warning	1292	Truncated incorrect max_binlog_cache_size value: '4095'
      @@ -149,4 +151,4 @@
       SET @@global.max_binlog_cache_size = @start_value;
       SELECT @@global.max_binlog_cache_size;
       @@global.max_binlog_cache_size
      -18446744073709547520
      +4294963200

      CURRENT_TEST: sys_vars.max_binlog_stmt_cache_size_basic
      --- /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/max_binlog_stmt_cache_size_basic.result	2013-06-09 18:23:56.000000000 +0300
      +++ /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/max_binlog_stmt_cache_size_basic.reject	2013-06-09 22:57:02.581462000 +0300
      @@ -1,7 +1,7 @@
       SET @start_value = @@global.max_binlog_stmt_cache_size;
       SELECT @start_value;
       @start_value
      -18446744073709547520
      +4294963200
       '#--------------------FN_DYNVARS_072_01------------------------#'
       SET @@global.max_binlog_stmt_cache_size = 5000;
       Warnings:
      @@ -9,7 +9,7 @@
       SET @@global.max_binlog_stmt_cache_size = DEFAULT;
       SELECT @@global.max_binlog_stmt_cache_size;
       @@global.max_binlog_stmt_cache_size
      -18446744073709547520
      +4294963200
       '#---------------------FN_DYNVARS_072_02-------------------------#'
       SET @@global.max_binlog_stmt_cache_size = @start_value;
       SELECT @@global.max_binlog_stmt_cache_size = 4294967295;
      @@ -56,12 +56,12 @@
       Warning	1292	Truncated incorrect max_binlog_stmt_cache_size value: '100000000000'
       SELECT @@global.max_binlog_stmt_cache_size;
       @@global.max_binlog_stmt_cache_size
      -99999997952
      +4294963200
       SET @@global.max_binlog_stmt_cache_size = 10000.01;
       ERROR 42000: Incorrect argument type to variable 'max_binlog_stmt_cache_size'
       SELECT @@global.max_binlog_stmt_cache_size;
       @@global.max_binlog_stmt_cache_size
      -99999997952
      +4294963200
       SET @@global.max_binlog_stmt_cache_size = -1024;
       Warnings:
       Warning	1292	Truncated incorrect max_binlog_stmt_cache_size value: '-1024'
      @@ -75,9 +75,11 @@
       @@global.max_binlog_stmt_cache_size
       4096
       SET @@global.max_binlog_stmt_cache_size = 4294967296;
      +Warnings:
      +Warning	1292	Truncated incorrect max_binlog_stmt_cache_size value: '4294967296'
       SELECT @@global.max_binlog_stmt_cache_size;
       @@global.max_binlog_stmt_cache_size
      -4294967296
      +4294963200
       SET @@global.max_binlog_stmt_cache_size = 4095;
       Warnings:
       Warning	1292	Truncated incorrect max_binlog_stmt_cache_size value: '4095'
      @@ -149,4 +151,4 @@
       SET @@global.max_binlog_stmt_cache_size = @start_value;
       SELECT @@global.max_binlog_stmt_cache_size;
       @@global.max_binlog_stmt_cache_size
      -18446744073709547520
      +4294963200

      CURRENT_TEST: sys_vars.sort_buffer_size_basic
      --- /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/sort_buffer_size_basic.result	2013-06-09 18:23:56.000000000 +0300
      +++ /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/sort_buffer_size_basic.reject	2013-06-09 22:58:19.473461998 +0300
      @@ -66,17 +66,17 @@
       SET @@global.sort_buffer_size = 4294967296;
       SELECT @@global.sort_buffer_size;
       @@global.sort_buffer_size
      -4294967296
      +4294967295
       SET @@global.sort_buffer_size = 65530.34;
       ERROR 42000: Incorrect argument type to variable 'sort_buffer_size'
       SELECT @@global.sort_buffer_size;
       @@global.sort_buffer_size
      -4294967296
      +4294967295
       SET @@global.sort_buffer_size = test;
       ERROR 42000: Incorrect argument type to variable 'sort_buffer_size'
       SELECT @@global.sort_buffer_size;
       @@global.sort_buffer_size
      -4294967296
      +4294967295
       SET @@session.sort_buffer_size = 32775;
       SELECT @@session.sort_buffer_size;
       @@session.sort_buffer_size
      @@ -90,7 +90,7 @@
       SET @@session.sort_buffer_size = 4294967296;
       SELECT @@session.sort_buffer_size;
       @@session.sort_buffer_size
      -4294967296
      +4294967295
       SET @@session.sort_buffer_size = test;
       ERROR 42000: Incorrect argument type to variable 'sort_buffer_size'
       '#------------------FN_DYNVARS_151_06-----------------------#'
       

        Attachments

          Activity

            People

            • Assignee:
              monty Michael Widenius
              Reporter:
              elenst Elena Stepanova
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: