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

main.func_regexp_pcre fails in buildbot on ppc64le: server crash or wrong result

    Details

    • Sprint:
      10.2.10

      Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-deb-xenial-ppc64le/builds/1224/steps/mtr/logs/stdio

      main.func_regexp_pcre                    w2 [ fail ]
              Test ended at 2017-07-25 09:20:00
       
      CURRENT_TEST: main.func_regexp_pcre
      mysqltest: At line 432: query 'SELECT 1 FROM dual WHERE ('Alpha,Bravo,Charlie,Delta,Echo,Foxtrot,StrataCentral,Golf,Hotel,India,Juliet,Kilo,Lima,Mike,StrataL3,November,Oscar,StrataL2,Sand,P3,P4SwitchTest,Arsys,Poppa,ExtensionMgr,Arp,Quebec,Romeo,StrataApiV2,PtReyes,Sierra,SandAcl,Arrow,Artools,BridgeTest,Tango,SandT,PAlaska,Namespace,Agent,Qos,PatchPanel,ProjectReport,Ark,Gimp,Agent,SliceAgent,Arnet,Bgp,Ale,Tommy,Central,AsicPktTestLib,Hsc,SandL3,Abuild,Pca9555,Standby,ControllerDut,CalSys,SandLib,Sb820,PointV2,BfnLib,Evpn,BfnSdk,Sflow,ManagementActive,AutoTest,GatedTest,Bgp,Sand,xinetd,BfnAgentLib,bf-utils,Hello,BfnState,Eos,Artest,Qos,Scd,ThermoMgr,Uniform,EosUtils,Eb,FanController,Central,BfnL3,BfnL2,tcp_wrappers,Victor,Environment,Route,Failover,Whiskey,Xray,Gimp,BfnFixed,Strata,SoCal,XApi,Msrp,XpProfile,tcpdump,PatchPanel,ArosTest,FhTest,Arbus,XpAcl,MacConc,XpApi,telnet,QosTest,Alpha2,BfnVlan,Stp,VxlanControllerTest,MplsAgent,Bravo2,Lanz,BfnMbb,Intf,XCtrl,Unicast,SandTunnel,L3Unicast,Ipsec,MplsTest,Rsvp,EthIntf,StageMgr,Sol,MplsUtils,Nat,Ira,P4NamespaceDut,Counters,Charlie2,Aqlc,Mlag,Power,OpenFlow,Lag,RestApi,BfdTest,strongs,Sfa,CEosUtils,Adt746,MaintenanceMode,MlagDut,EosImage,IpEth,MultiProtocol,Launcher,Max3179,Snmp,Acl,IpEthTest,PhyEee,bf-syslibs,tacc,XpL2,p4-ar-switch,p4-bf-switch,LdpTest,BfnPhy,Mirroring,Phy6,Ptp'  REGEXP '^((?!\b(Strata|StrataApi|StrataApiV2)\b).)*$')' failed: 2013: Lost connection to MySQL server during query
       
      The result from queries just before the failure was:
      < snip >
      # Testing workaround N1: This makes the pattern to be a binary string:
      SET NAMES latin1;
      SET @regCheck= X'E001';
      SELECT 0xE001 REGEXP @regCheck;
      0xE001 REGEXP @regCheck
      1
      # Testing workaround N2: This also makes the pattern to be a binary string, using a different syntax:
      SET NAMES latin1;
      SET @regCheck= _binary '\\xE0\\x01';
      SELECT 0xE001 REGEXP @regCheck;
      0xE001 REGEXP @regCheck
      1
      # Testing workarond N3: This makes derivation of the subject string stronger (IMLICIT instead of COERCIBLE)
      SET NAMES latin1;
      SET @regCheck= '\\xE0\\x01';
      SELECT CAST(0xE001 AS BINARY) REGEXP @regCheck;
      CAST(0xE001 AS BINARY) REGEXP @regCheck
      1
      # MDEV-12420: Testing recursion overflow
      SELECT 1 FROM dual WHERE ('Alpha,Bravo,Charlie,Delta,Echo,Foxtrot,StrataCentral,Golf,Hotel,India,Juliet,Kilo,Lima,Mike,StrataL3,November,Oscar,StrataL2,Sand,P3,P4SwitchTest,Arsys,Poppa,ExtensionMgr,Arp,Quebec,Romeo,StrataApiV2,PtReyes,Sierra,SandAcl,Arrow,Artools,BridgeTest,Tango,SandT,PAlaska,Namespace,Agent,Qos,PatchPanel,ProjectReport,Ark,Gimp,Agent,SliceAgent,Arnet,Bgp,Ale,Tommy,Central,AsicPktTestLib,Hsc,SandL3,Abuild,Pca9555,Standby,ControllerDut,CalSys,SandLib,Sb820,PointV2,BfnLib,Evpn,BfnSdk,Sflow,ManagementActive,AutoTest,GatedTest,Bgp,Sand,xinetd,BfnAgentLib,bf-utils,Hello,BfnState,Eos,Artest,Qos,Scd,ThermoMgr,Uniform,EosUtils,Eb,FanController,Central,BfnL3,BfnL2,tcp_wrappers,Victor,Environment,Route,Failover,Whiskey,Xray,Gimp,BfnFixed,Strata,SoCal,XApi,Msrp,XpProfile,tcpdump,PatchPanel,ArosTest,FhTest,Arbus,XpAcl,MacConc,XpApi,telnet,QosTest,Alpha2,BfnVlan,Stp,VxlanControllerTest,MplsAgent,Bravo2,Lanz,BfnMbb,Intf,XCtrl,Unicast,SandTunnel,L3Unicast,Ipsec,MplsTest,Rsvp,EthIntf,StageMgr,Sol,MplsUtils,Nat,Ira,P4NamespaceDut,Counters,Charlie2,Aqlc,Mlag,Power,OpenFlow,Lag,RestApi,BfdTest,strongs,Sfa,CEosUtils,Adt746,MaintenanceMode,MlagDut,EosImage,IpEth,MultiProtocol,Launcher,Max3179,Snmp,Acl,IpEthTest,PhyEee,bf-syslibs,tacc,XpL2,p4-ar-switch,p4-bf-switch,LdpTest,BfnPhy,Mirroring,Phy6,Ptp'  REGEXP '^((?!\b(Strata|StrataApi|StrataApiV2)\b).)*$');
       
      More results from queries before failure can be found in /dev/shm/var/2/log/func_regexp_pcre.log
       
       
      Server [mysqld.1 - pid: 16801, winpid: 16801, exit: 256] failed during test run
      Server log from this test:
      ----------SERVER LOG START-----------
      ----------SERVER LOG END-------------
      

      http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-ppc64le/builds/1171/steps/mtr/logs/stdio

      main.func_regexp_pcre                    w1 [ fail ]
              Test ended at 2017-07-20 15:38:10
       
      CURRENT_TEST: main.func_regexp_pcre
      --- /usr/share/mysql/mysql-test/r/func_regexp_pcre.result	2017-07-20 14:24:19.000000000 -0400
      +++ /dev/shm/var/1/log/func_regexp_pcre.reject	2017-07-20 15:38:09.916000008 -0400
      @@ -881,7 +881,9 @@
       Warning	1139	Got error 'pcre_exec: recursion limit of NUM exceeded' from regexp
       SELECT CONCAT(REPEAT('100,',500),'101') RLIKE '^(([1-9][0-9]*),)*[1-9][0-9]*$';
       CONCAT(REPEAT('100,',500),'101') RLIKE '^(([1-9][0-9]*),)*[1-9][0-9]*$'
      -1
      +0
      +Warnings:
      +Warning	1139	Got error 'pcre_exec: recursion limit of 434 exceeded' from regexp
       SELECT CONCAT(REPEAT('100,',600),'101') RLIKE '^(([1-9][0-9]*),)*[1-9][0-9]*$';
       CONCAT(REPEAT('100,',600),'101') RLIKE '^(([1-9][0-9]*),)*[1-9][0-9]*$'
       0
      @@ -889,7 +891,9 @@
       Warning	1139	Got error 'pcre_exec: recursion limit of NUM exceeded' from regexp
       SELECT REGEXP_INSTR(CONCAT(REPEAT('100,',500),'101'), '^(([1-9][0-9]*),)*[1-9][0-9]*$');
       REGEXP_INSTR(CONCAT(REPEAT('100,',500),'101'), '^(([1-9][0-9]*),)*[1-9][0-9]*$')
      -1
      +0
      +Warnings:
      +Warning	1139	Got error 'pcre_exec: recursion limit of 434 exceeded' from regexp
       SELECT REGEXP_INSTR(CONCAT(REPEAT('100,',600),'101'), '^(([1-9][0-9]*),)*[1-9][0-9]*$');
       REGEXP_INSTR(CONCAT(REPEAT('100,',600),'101'), '^(([1-9][0-9]*),)*[1-9][0-9]*$')
       0
      @@ -897,7 +901,9 @@
       Warning	1139	Got error 'pcre_exec: recursion limit of NUM exceeded' from regexp
       SELECT LENGTH(REGEXP_SUBSTR(CONCAT(REPEAT('100,',500/3),'101'), '^(([1-9][0-9]*),)*[1-9][0-9]*$'));
       LENGTH(REGEXP_SUBSTR(CONCAT(REPEAT('100,',500/3),'101'), '^(([1-9][0-9]*),)*[1-9][0-9]*$'))
      -671
      +0
      +Warnings:
      +Warning	1139	Got error 'pcre_exec: recursion limit of 433 exceeded' from regexp
       SELECT LENGTH(REGEXP_SUBSTR(CONCAT(REPEAT('100,',600/3),'101'), '^(([1-9][0-9]*),)*[1-9][0-9]*$'));
       LENGTH(REGEXP_SUBSTR(CONCAT(REPEAT('100,',600/3),'101'), '^(([1-9][0-9]*),)*[1-9][0-9]*$'))
       0
      @@ -905,7 +911,9 @@
       Warning	1139	Got error 'pcre_exec: recursion limit of NUM exceeded' from regexp
       SELECT LENGTH(REGEXP_REPLACE(CONCAT(REPEAT('100,',500/3),'101'), '^(([1-9][0-9]*),)*[1-9][0-9]*$', ''));
       LENGTH(REGEXP_REPLACE(CONCAT(REPEAT('100,',500/3),'101'), '^(([1-9][0-9]*),)*[1-9][0-9]*$', ''))
      -0
      +671
      +Warnings:
      +Warning	1139	Got error 'pcre_exec: recursion limit of 433 exceeded' from regexp
       SELECT LENGTH(REGEXP_REPLACE(CONCAT(REPEAT('100,',600/3),'101'), '^(([1-9][0-9]*),)*[1-9][0-9]*$', ''));
       LENGTH(REGEXP_REPLACE(CONCAT(REPEAT('100,',600/3),'101'), '^(([1-9][0-9]*),)*[1-9][0-9]*$', ''))
       803
       
      mysqltest: Result length mismatch
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                serg Sergei Golubchik
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: