[MDEV-12904] main.userstat failed in buildbot with CryptGenRandom error or Unknown SSL error Created: 2017-05-24  Updated: 2023-11-29  Resolved: 2023-11-29

Status: Closed
Project: MariaDB Server
Component/s: SSL, Tests
Affects Version/s: 10.1, 10.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: Windows


 Description   

http://buildbot.askmonty.org/buildbot/builders/win32-packages/builds/3414/steps/test/logs/stdio

main.userstat 'innodb_plugin'            w2 [ fail ]
        Test ended at 2017-05-20 06:44:00
 
CURRENT_TEST: main.userstat
mysqltest: At line 37: query 'connect  ssl_con,localhost,root,,,,,SSL' failed: 2026: SSL connection error: CryptGenRandom error
 
The result from queries just before the failure was:
< snip >
show columns from information_schema.table_statistics;
Field	Type	Null	Key	Default	Extra
TABLE_SCHEMA	varchar(192)	NO			
TABLE_NAME	varchar(192)	NO			
ROWS_READ	bigint(21)	NO		0	
ROWS_CHANGED	bigint(21)	NO		0	
ROWS_CHANGED_X_INDEXES	bigint(21)	NO		0	
set @save_general_log=@@global.general_log;
set @@global.general_log=0;
set @@global.userstat=1;
flush status;
create table t1 (a int, primary key (a), b int default 0) engine=innodb;
insert into t1 (a) values (1),(2),(3),(4);
update t1 set b=1;
update t1 set b=5 where a=2;
delete from t1 where a=3;
/* Empty query */
select * from t1 where a=999;
a	b
drop table t1;



 Comments   
Comment by Elena Stepanova [ 2017-09-22 ]

http://buildbot.askmonty.org/buildbot/builders/win32-debug/builds/5059

main.userstat 'innodb'                   w1 [ fail ]
        Test ended at 2017-08-18 18:27:13
 
CURRENT_TEST: main.userstat
mysqltest: At line 37: query 'connect  ssl_con,localhost,root,,,,,SSL' failed: 2026: Unknown SSL error (0x80090308)
 
The result from queries just before the failure was:
< snip >
show columns from information_schema.table_statistics;
Field	Type	Null	Key	Default	Extra
TABLE_SCHEMA	varchar(192)	NO			
TABLE_NAME	varchar(192)	NO			
ROWS_READ	bigint(21)	NO		0	
ROWS_CHANGED	bigint(21)	NO		0	
ROWS_CHANGED_X_INDEXES	bigint(21)	NO		0	
set @save_general_log=@@global.general_log;
set @@global.general_log=0;
set @@global.userstat=1;
flush status;
create table t1 (a int, primary key (a), b int default 0) engine=innodb;
insert into t1 (a) values (1),(2),(3),(4);
update t1 set b=1;
update t1 set b=5 where a=2;
delete from t1 where a=3;
/* Empty query */
select * from t1 where a=999;
a	b
drop table t1;
 
More results from queries before failure can be found in D:\win32-debug\build\mysql-test\var\1\log\userstat.log

Generated at Thu Feb 08 08:01:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.