[MDEV-10639] vcol.not_supported, vcol.vcol_keys_innodb failed with timeout in buildbot Created: 2016-08-21  Updated: 2022-09-08

Status: Open
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.0
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-7069 Fix buildbot failures in main server ... Stalled

 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));


Generated at Thu Feb 08 07:43:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.