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

vcol.not_supported, vcol.vcol_keys_innodb failed with timeout in buildbot

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.0
    • None
    • Tests
    • None

    Description

      Logs are not available

      10.0	44554d611194e2ac02e5beaf4b88ffe5	kvm-deb-trusty-amd64	2016-04-26 16:02:19	2704	nm	Normal run, no --ps-protocol	vcol.not_supported		timeout after 900 seconds
      vcol.not_supported                       w3 [ fail ]  timeout after 900 seconds
              Test ended at 2016-04-26 13:54:07
       
      Test case timeout after 900 seconds
       
      == /run/shm/var/3/log/not_supported.log == 
      select * from t8;
      a	b	v
      1234567890	2	2009-02-14 09:31:30
      set time_zone='+1:00';
      select * from t1;
      a	b	v
      1	2	0.3333333333333333333
      select * from t5;
      a	b	v
      20141010	2	octubre
      select * from t6;
      a	b	v
      20141010	2	viernes
      select * from t7;
      a	b	v
      20141010	2	viernes vie octubre oct
      select * from t8;
      a	b	v
      1234567890	2	2009-02-14 09:31:30
      flush tables;
       
       == /run/shm/var/3/tmp/analyze-timeout-mysqld.1.err ==
      

      vcol.vcol_keys_innodb 'xtradb'           w4 [ fail ]  timeout after 9000 seconds
              Test ended at 2016-04-26 20:49:41
       
      Test case timeout after 9000 seconds
       
      == /mnt/data/buildot/maria-slave/work-opensuse-amd64/build/mysql-test/var/4/log/vcol_keys_innodb.log == 
      # Rejected FK options.
      create table t1 (a int, b int as (a+1) persistent,
      foreign key (b) references t2(a) on update set null);
      ERROR HY000: Cannot define foreign key with ON UPDATE SET NULL clause on a computed column
      create table t1 (a int, b int as (a+1) persistent,
      foreign key (b) references t2(a) on update cascade);
      ERROR HY000: Cannot define foreign key with ON UPDATE CASCADE clause on a computed column
      create table t1 (a int, b int as (a+1) persistent,
      foreign key (b) references t2(a) on delete set null);
      ERROR HY000: Cannot define foreign key with ON DELETE SET NULL clause on a computed column
      create table t1 (a int, b int as (a+1) persistent);
      alter table t1 add foreign key (b) references t2(a) on update set null;
      ERROR HY000: Cannot define foreign key with ON UPDATE SET NULL clause on a computed column
      alter table t1 add foreign key (b) references t2(a) on update cascade;
      ERROR HY000: Cannot define foreign key with ON UPDATE CASCADE clause on a computed column
      alter table t1 add foreign key (b) references t2(a) on delete set null;
      ERROR HY000: Cannot define foreign key with ON DELETE SET NULL clause on a computed column
      drop table t1;
      create table t1 (a int, b int as (a+1),
      foreign key (b) references t2(a));
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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