[MDEV-13778] sql_sequence.alter fails in buildbot and outside with embedded (query 'select nextval(s1)' succeeded - should have failed with errno 1142) Created: 2017-09-11  Updated: 2018-05-14  Resolved: 2018-05-14

Status: Closed
Project: MariaDB Server
Component/s: Embedded Server, Sequences, Tests
Affects Version/s: 10.3
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Michael Widenius
Resolution: Cannot Reproduce Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest/builds/10121/steps/test_1/logs/stdio

sql_sequence.alter 'innodb'              w4 [ fail ]
        Test ended at 2017-09-08 13:20:39
 
CURRENT_TEST: sql_sequence.alter
Warning: /mnt/buildbot/build/mariadb-10.3.2/libmysqld/examples/mysqltest_embedded: unknown variable 'loose-ssl-ca=/mnt/buildbot/build/mariadb-10.3.2/mysql-test/std_data/cacert.pem'
Warning: /mnt/buildbot/build/mariadb-10.3.2/libmysqld/examples/mysqltest_embedded: unknown variable 'loose-ssl-cert=/mnt/buildbot/build/mariadb-10.3.2/mysql-test/std_data/client-cert.pem'
Warning: /mnt/buildbot/build/mariadb-10.3.2/libmysqld/examples/mysqltest_embedded: unknown variable 'loose-ssl-key=/mnt/buildbot/build/mariadb-10.3.2/mysql-test/std_data/client-key.pem'
Warning: /mnt/buildbot/build/mariadb-10.3.2/libmysqld/examples/mysqltest_embedded: unknown option '--loose-skip-ssl'
mysqltest: At line 154: query 'select nextval(s1)' succeeded - should have failed with errno 1142...
 
The result from queries just before the failure was:
< snip >
alter sequence t1 restart;
select next value for t1;
next value for t1
50
alter sequence t1 restart with 90;
select next value for t1;
next value for t1
90
drop sequence t1;
 
GRANT
 
create database s_db;
create sequence s_db.s1;
grant select on s_db.s1 to normal_1@'%' identified by 'pass';
connect m_normal_1, localhost, normal_1, pass, s_db;
select * from s1;
next_not_cached_value	minimum_value	maximum_value	start_value	increment	cache_size	cycle_option	cycle_count
1	1	9223372036854775806	1	1	1000	0	0
select nextval(s1);



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

Reproducible when run with --embedded.

Comment by Michael Widenius [ 2018-05-14 ]

I have not been able to repeat the issue with latest 10.3
Buildbot cross-reference doesn't show any failures since 2017-11-22, so I will assume it's fixed.

Comment by Michael Widenius [ 2018-05-14 ]

Closed as can't reproduce

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