[MDEV-18974] Result difference with --embedded --ps-protocol - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.4(EOL)
Fix Version/s: 10.4.4
Component/s: Protocol, Tests
Labels:
None

Description

After a merge of 10.3 117291db8b35ddb4cd8c89ee4d8de888160b7163 to 10.4, the following tests would fail when running with --ps-protocol:

CURRENT_TEST: archive.rnd_pos

--- /mariadb/10.4m/mysql-test/suite/archive/rnd_pos.result	2019-03-20 09:43:25.226868080 +0200

+++ /mariadb/10.4m/mysql-test/suite/archive/rnd_pos.reject	2019-03-20 10:11:19.318393810 +0200

@@ -23,7 +23,7 @@

 set max_length_for_sort_data = default;

 show status where variable_name like '%tmp%' and value != 0;

 Variable_name	Value

-Created_tmp_tables	1

+Created_tmp_tables	2

 Handler_tmp_write	10

 Rows_tmp_read	20

 alter table t1 partition by hash (c1) partitions 3;

@@ -50,7 +50,7 @@

 set max_length_for_sort_data = default;

 show status where variable_name like '%tmp%' and value != 0;

 Variable_name	Value

-Created_tmp_tables	1

+Created_tmp_tables	2

 Handler_tmp_write	10

 Rows_tmp_read	20

 drop table t1;

mysqltest: Result content mismatch

…

--- /mariadb/10.4m/mysql-test/main/profiling.result	2019-03-20 09:43:25.126866180 +0200

+++ /mariadb/10.4m/mysql-test/main/profiling.reject	2019-03-20 10:11:02.058449801 +0200

@@ -133,36 +133,36 @@

 insert into t3 values (1), (2), (3);

 show profiles;

 Query_ID	Duration	Query

-10	#	insert into t1 select * from t1

-11	#	select count(*) from t1

-12	#	insert into t1 select * from t1

-13	#	insert into t1 select * from t1

-14	#	insert into t1 select * from t1

-15	#	select count(*) from t1

-16	#	insert into t1 select * from t1

-17	#	insert into t1 select * from t1

-18	#	insert into t1 select * from t1

-19	#	select count(*) from t1

-20	#	select sum(a) from t1

-21	#	select sum(a) from t1 group by b

-22	#	select sum(a) + sum(b) from t1 group by b

-23	#	select max(x) from (select sum(a) as x from t1 group by b) as teeone

-24	#	select '0123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345

-25	#	select * from information_schema.profiling

-26	#	select query_id, state, duration from information_schema.profiling

-27	#	select query_id, sum(duration) from information_schema.profiling group by query_id

-28	#	select query_id, count(*) from information_schema.profiling group by query_id

-29	#	select sum(duration) from information_schema.profiling

-30	#	select query_id, count(*), sum(duration) from information_schema.profiling group by query_id

-31	#	select CPU_user, CPU_system, Context_voluntary, Context_involuntary, Block_ops_in, Block_ops_out, Messages_sent, Messages_received, Page_faults_major, Page_faults_minor, Swaps, Source_function, Source_file, Source_line from information_schema.profiling

-32	#	drop table if exists t1, t2, t3

-33	#	SHOW WARNINGS

-34	#	create table t1 (id int )

-35	#	create table t2 (id int not null)

-36	#	create table t3 (id int not null primary key)

-37	#	insert into t1 values (1), (2), (3)

-38	#	insert into t2 values (1), (2), (3)

-39	#	insert into t3 values (1), (2), (3)

+25	#	show profile for query 15

+26	#	show profile cpu for query 15

+27	#	show profile cpu, block io for query 15

+28	#	show profile cpu for query 9 limit 2 offset 2

+29	#	show profile cpu for query 10 limit 0

+30	#	show profile cpu for query 65534

+31	#	show profile memory

+32	#	show profile block io

+33	#	show profile context switches

+34	#	show profile page faults

+35	#	show profile ipc

+36	#	show profile swaps limit 1 offset 2

+37	#	show profile source

+38	#	show profile all for query 0 limit 0

+39	#	show profile all for query 15

+40	#	select * from information_schema.profiling

+41	#	select query_id, state, duration from information_schema.profiling

+42	#	select query_id, sum(duration) from information_schema.profiling group by query_id

+43	#	select query_id, count(*) from information_schema.profiling group by query_id

+44	#	select sum(duration) from information_schema.profiling

+45	#	select query_id, count(*), sum(duration) from information_schema.profiling group by query_id

+46	#	select CPU_user, CPU_system, Context_voluntary, Context_involuntary, Block_ops_in, Block_ops_out, Messages_sent, Messages_received, Page_faults_major, Page_faults_minor, Swaps, Source_function, Source_file, Source_line from information_schema.profiling

+47	#	drop table if exists t1, t2, t3

+48	#	SHOW WARNINGS

+49	#	create table t1 (id int )

+50	#	create table t2 (id int not null)

+51	#	create table t3 (id int not null primary key)

+52	#	insert into t1 values (1), (2), (3)

+53	#	insert into t2 values (1), (2), (3)

+54	#	insert into t3 values (1), (2), (3)

 select * from t1;

id

@@ -170,36 +170,36 @@

 show profiles;

 Query_ID	Duration	Query

-11	#	select count(*) from t1

-12	#	insert into t1 select * from t1

-13	#	insert into t1 select * from t1

-14	#	insert into t1 select * from t1

-15	#	select count(*) from t1

-16	#	insert into t1 select * from t1

-17	#	insert into t1 select * from t1

-18	#	insert into t1 select * from t1

-19	#	select count(*) from t1

-20	#	select sum(a) from t1

-21	#	select sum(a) from t1 group by b

-22	#	select sum(a) + sum(b) from t1 group by b

-23	#	select max(x) from (select sum(a) as x from t1 group by b) as teeone

-24	#	select '0123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345

-25	#	select * from information_schema.profiling

-26	#	select query_id, state, duration from information_schema.profiling

-27	#	select query_id, sum(duration) from information_schema.profiling group by query_id

-28	#	select query_id, count(*) from information_schema.profiling group by query_id

-29	#	select sum(duration) from information_schema.profiling

-30	#	select query_id, count(*), sum(duration) from information_schema.profiling group by query_id

-31	#	select CPU_user, CPU_system, Context_voluntary, Context_involuntary, Block_ops_in, Block_ops_out, Messages_sent, Messages_received, Page_faults_major, Page_faults_minor, Swaps, Source_function, Source_file, Source_line from information_schema.profiling

-32	#	drop table if exists t1, t2, t3

-33	#	SHOW WARNINGS

-34	#	create table t1 (id int )

-35	#	create table t2 (id int not null)

-36	#	create table t3 (id int not null primary key)

-37	#	insert into t1 values (1), (2), (3)

-38	#	insert into t2 values (1), (2), (3)

-39	#	insert into t3 values (1), (2), (3)

-40	#	select * from t1

+26	#	show profile cpu for query 15

+27	#	show profile cpu, block io for query 15

+28	#	show profile cpu for query 9 limit 2 offset 2

+29	#	show profile cpu for query 10 limit 0

+30	#	show profile cpu for query 65534

+31	#	show profile memory

+32	#	show profile block io

+33	#	show profile context switches

+34	#	show profile page faults

+35	#	show profile ipc

+36	#	show profile swaps limit 1 offset 2

+37	#	show profile source

+38	#	show profile all for query 0 limit 0

+39	#	show profile all for query 15

+40	#	select * from information_schema.profiling

+41	#	select query_id, state, duration from information_schema.profiling

+42	#	select query_id, sum(duration) from information_schema.profiling group by query_id

+43	#	select query_id, count(*) from information_schema.profiling group by query_id

+44	#	select sum(duration) from information_schema.profiling

+45	#	select query_id, count(*), sum(duration) from information_schema.profiling group by query_id

+46	#	select CPU_user, CPU_system, Context_voluntary, Context_involuntary, Block_ops_in, Block_ops_out, Messages_sent, Messages_received, Page_faults_major, Page_faults_minor, Swaps, Source_function, Source_file, Source_line from information_schema.profiling

+47	#	drop table if exists t1, t2, t3

+48	#	SHOW WARNINGS

+49	#	create table t1 (id int )

+50	#	create table t2 (id int not null)

+51	#	create table t3 (id int not null primary key)

+52	#	insert into t1 values (1), (2), (3)

+53	#	insert into t2 values (1), (2), (3)

+54	#	insert into t3 values (1), (2), (3)

+55	#	select * from t1

 This ^^ should end in "select * from t1;"

 delete from t1;

 insert into t1 values (1), (2), (3);

@@ -214,72 +214,72 @@

 show profiles;

 Query_ID	Duration	Query

-15	#	select count(*) from t1

-16	#	insert into t1 select * from t1

-17	#	insert into t1 select * from t1

-18	#	insert into t1 select * from t1

-19	#	select count(*) from t1

-20	#	select sum(a) from t1

-21	#	select sum(a) from t1 group by b

-22	#	select sum(a) + sum(b) from t1 group by b

-23	#	select max(x) from (select sum(a) as x from t1 group by b) as teeone

-24	#	select '0123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345

-25	#	select * from information_schema.profiling

-26	#	select query_id, state, duration from information_schema.profiling

-27	#	select query_id, sum(duration) from information_schema.profiling group by query_id

-28	#	select query_id, count(*) from information_schema.profiling group by query_id

-29	#	select sum(duration) from information_schema.profiling

-30	#	select query_id, count(*), sum(duration) from information_schema.profiling group by query_id

-31	#	select CPU_user, CPU_system, Context_voluntary, Context_involuntary, Block_ops_in, Block_ops_out, Messages_sent, Messages_received, Page_faults_major, Page_faults_minor, Swaps, Source_function, Source_file, Source_line from information_schema.profiling

-32	#	drop table if exists t1, t2, t3

-33	#	SHOW WARNINGS

-34	#	create table t1 (id int )

-35	#	create table t2 (id int not null)

-36	#	create table t3 (id int not null primary key)

-37	#	insert into t1 values (1), (2), (3)

-38	#	insert into t2 values (1), (2), (3)

-39	#	insert into t3 values (1), (2), (3)

-40	#	select * from t1

-41	#	delete from t1

-42	#	insert into t1 values (1), (2), (3)

-43	#	insert into t1 values (1), (2), (3)

-44	#	select * from t1

+30	#	show profile cpu for query 65534

+31	#	show profile memory

+32	#	show profile block io

+33	#	show profile context switches

+34	#	show profile page faults

+35	#	show profile ipc

+36	#	show profile swaps limit 1 offset 2

+37	#	show profile source

+38	#	show profile all for query 0 limit 0

+39	#	show profile all for query 15

+40	#	select * from information_schema.profiling

+41	#	select query_id, state, duration from information_schema.profiling

+42	#	select query_id, sum(duration) from information_schema.profiling group by query_id

+43	#	select query_id, count(*) from information_schema.profiling group by query_id

+44	#	select sum(duration) from information_schema.profiling

+45	#	select query_id, count(*), sum(duration) from information_schema.profiling group by query_id

+46	#	select CPU_user, CPU_system, Context_voluntary, Context_involuntary, Block_ops_in, Block_ops_out, Messages_sent, Messages_received, Page_faults_major, Page_faults_minor, Swaps, Source_function, Source_file, Source_line from information_schema.profiling

+47	#	drop table if exists t1, t2, t3

+48	#	SHOW WARNINGS

+49	#	create table t1 (id int )

+50	#	create table t2 (id int not null)

+51	#	create table t3 (id int not null primary key)

+52	#	insert into t1 values (1), (2), (3)

+53	#	insert into t2 values (1), (2), (3)

+54	#	insert into t3 values (1), (2), (3)

+55	#	select * from t1

+56	#	delete from t1

+57	#	insert into t1 values (1), (2), (3)

+58	#	insert into t1 values (1), (2), (3)

+59	#	select * from t1

 set session profiling = OFF;

 select sum(id) from t1;

 sum(id)

 show profiles;

 Query_ID	Duration	Query

-15	#	select count(*) from t1

-16	#	insert into t1 select * from t1

-17	#	insert into t1 select * from t1

-18	#	insert into t1 select * from t1

-19	#	select count(*) from t1

-20	#	select sum(a) from t1

-21	#	select sum(a) from t1 group by b

-22	#	select sum(a) + sum(b) from t1 group by b

-23	#	select max(x) from (select sum(a) as x from t1 group by b) as teeone

-24	#	select '0123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345678900123456789001234567890012345

-25	#	select * from information_schema.profiling

-26	#	select query_id, state, duration from information_schema.profiling

-27	#	select query_id, sum(duration) from information_schema.profiling group by query_id

-28	#	select query_id, count(*) from information_schema.profiling group by query_id

-29	#	select sum(duration) from information_schema.profiling

-30	#	select query_id, count(*), sum(duration) from information_schema.profiling group by query_id

-31	#	select CPU_user, CPU_system, Context_voluntary, Context_involuntary, Block_ops_in, Block_ops_out, Messages_sent, Messages_received, Page_faults_major, Page_faults_minor, Swaps, Source_function, Source_file, Source_line from information_schema.profiling

-32	#	drop table if exists t1, t2, t3

-33	#	SHOW WARNINGS

-34	#	create table t1 (id int )

-35	#	create table t2 (id int not null)

-36	#	create table t3 (id int not null primary key)

-37	#	insert into t1 values (1), (2), (3)

-38	#	insert into t2 values (1), (2), (3)

-39	#	insert into t3 values (1), (2), (3)

-40	#	select * from t1

-41	#	delete from t1

-42	#	insert into t1 values (1), (2), (3)

-43	#	insert into t1 values (1), (2), (3)

-44	#	select * from t1

+30	#	show profile cpu for query 65534

+31	#	show profile memory

+32	#	show profile block io

+33	#	show profile context switches

+34	#	show profile page faults

+35	#	show profile ipc

+36	#	show profile swaps limit 1 offset 2

+37	#	show profile source

+38	#	show profile all for query 0 limit 0

+39	#	show profile all for query 15

+40	#	select * from information_schema.profiling

+41	#	select query_id, state, duration from information_schema.profiling

+42	#	select query_id, sum(duration) from information_schema.profiling group by query_id

+43	#	select query_id, count(*) from information_schema.profiling group by query_id

+44	#	select sum(duration) from information_schema.profiling

+45	#	select query_id, count(*), sum(duration) from information_schema.profiling group by query_id

+46	#	select CPU_user, CPU_system, Context_voluntary, Context_involuntary, Block_ops_in, Block_ops_out, Messages_sent, Messages_received, Page_faults_major, Page_faults_minor, Swaps, Source_function, Source_file, Source_line from information_schema.profiling

+47	#	drop table if exists t1, t2, t3

+48	#	SHOW WARNINGS

+49	#	create table t1 (id int )

+50	#	create table t2 (id int not null)

+51	#	create table t3 (id int not null primary key)

+52	#	insert into t1 values (1), (2), (3)

+53	#	insert into t2 values (1), (2), (3)

+54	#	insert into t3 values (1), (2), (3)

+55	#	select * from t1

+56	#	delete from t1

+57	#	insert into t1 values (1), (2), (3)

+58	#	insert into t1 values (1), (2), (3)

+59	#	select * from t1

 set session profiling = ON;

 select @@profiling;

 @@profiling

mysqltest: Result length mismatch

The test main.profiling passes if at most one of --embedded --ps-protocol is specified.
The test archive.rnd_pos fails with --ps-protocol for both the embedded and non-embedded server.

Attachments

Issue Links

relates to

MDEV-15945 --ps-protocol does not test some queries

Closed

Activity

People

Assignee:: Marko Mäkelä

Reporter:: Marko Mäkelä

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2019-03-20 08:23

Updated:: 2019-04-01 17:30

Resolved:: 2019-04-01 17:30

Git Integration

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