[MDEV-33347] some tests are very slow in the ps2 protocol Created: 2024-01-31  Updated: 2024-01-31

Status: Open
Project: MariaDB Server
Component/s: Prepared Statements
Affects Version/s: 10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2
Fix Version/s: 10.5, 10.6, 10.11, 11.0, 11.1, 11.2

Type: Bug Priority: Major
Reporter: Sergei Golubchik Assignee: Dmitry Shulga
Resolution: Unresolved Votes: 0
Labels: None


 Description   

for example, see funcs_1.innodb_views.

Note, how long it takes to run it in normal protocol, note, how long it takes to run it in --ps protocol. Then remove disable_ps2_protocol lines from it and time it again.

on my laptop, debug build. in --ps-protocol I get

funcs_1.innodb_views 'innodb'            [ pass ]   3045
--------------------------------------------------------------------------
Spent 3.045 of 6 seconds executing testcases

but if I remove disable_ps2_protocol it becomes

funcs_1.innodb_views 'innodb'            [ pass ]  3047412
--------------------------------------------------------------------------
Spent 3047.412 of 3050 seconds executing testcases

note the default timeout is 900 seconds, the above was run with --testcase-timeout=9000


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