Done
Details
Details
Assignee
mohit.joshi
mohit.joshiReporter
Manish Chawla
Manish ChawlaFound by Automation
Yes
Time tracking
1d 1h logged
Priority
MediumCreated December 15, 2022 at 6:39 AM
Updated March 6, 2024 at 5:51 PM
Resolved January 5, 2023 at 7:22 AM
Pstress takes many values for the same variable. It should take only a single value for a variable in one trial. For example
[09:33:03] [19] ====== TRIAL #20 ====== [09:33:03] [19] Ensuring there are no relevant servers running... [09:33:03] [19] Clearing rundir... [09:33:03] [19] Generating new trial workdir /tmp/156159/20... [09:33:03] [19] Copying datadir from template... [09:33:03] [19] ADD_RANDOM_OPTIONS=1: adding mysqld option(s) --sql-mode=STRICT_TRANS_TABLES to this run's MYEXTRA... [09:33:03] [19] Starting mysqld. Error log is stored at /tmp/156159/20/log/master.err /home/manish.chawla/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.27-debug/bin/mysqld --sql-mode=ERROR_FOR_DIVISION_BY_ZERO --sql-mode=NO_UNSIGNED_SUBTRACTION --sql-mode=NO_ZERO_DATE --sql-mode=NO_BACKSLASH_ESCAPES --sql-mode=PIPES_AS_CONCAT --sql-mode=NO_BACKSLASH_ESCAPES --sql-mode=ERROR_FOR_DIVISION_BY_ZERO --sql-mode=NO_AUTO_VALUE_ON_ZERO --sql-mode=PIPES_AS_CONCAT --sql-mode=REAL_AS_FLOAT --sql-mode=NO_ZERO_IN_DATE --sql-mode=REAL_AS_FLOAT --sql-mode=IGNORE_SPACE --sql-mode=ONLY_FULL_GROUP_BY --sql-mode=ALLOW_INVALID_DATES --sql-mode=NO_AUTO_CREATE_USER --sql-mode=STRICT_ALL_TABLES --sql-mode=NO_ZERO_DATE --sql-mode=NO_UNSIGNED_SUBTRACTION --sql-mode=PIPES_AS_CONCAT --sql-mode=ANSI_QUOTES --sql-mode=STRICT_TRANS_TABLES --sql-mode=NO_DIR_IN_CREATE --sql-mode=NO_UNSIGNED_SUBTRACTION --sql-mode=PIPES_AS_CONCAT --sql-mode=NO_UNSIGNED_SUBTRACTION --sql-mode=ONLY_FULL_GROUP_BY --sql-mode=NO_BACKSLASH_ESCAPES --sql-mode=REAL_AS_FLOAT --sql-mode=PAD_CHAR_TO_FULL_LENGTH --sql-mode=PAD_CHAR_TO_FULL_LENGTH --sql-mode=STRICT_TRANS_TABLES --sql-mode=IGNORE_SPACE --sql-mode=NO_UNSIGNED_SUBTRACTION --sql-mode=STRICT_ALL_TABLES --sql-mode=NO_AUTO_VALUE_ON_ZERO --sql-mode=ERROR_FOR_DIVISION_BY_ZERO --sql-mode=NO_UNSIGNED_SUBTRACTION --sql-mode=NO_AUTO_CREATE_USER --sql-mode=NO_UNSIGNED_SUBTRACTION --sql-mode=PAD_CHAR_TO_FULL_LENGTH --sql-mode=NO_DIR_IN_CREATE --sql-mode=ALLOW_INVALID_DATES --sql-mode=STRICT_TRANS_TABLES --basedir=/home/manish.chawla/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.27-debug --datadir=/tmp/156159/20/data --tmpdir=/tmp/156159/20/tmp --core-file --port=55170 --pid_file=/tmp/156159/20/pid.pid --socket=/tmp/156159/20/socket.sock --log-output=none --log-error-verbosity=3 --log-error=/tmp/156159/20/log/master.errHere there should be only one value for sql-mode and each trial should have a different value of sql-mode.
Also there should be an option in pstress which will test all the values of a variable in trials. For example, if we want to test all the values of sql-mode, then specify the test variable as sql-mode and pstress should pick the values one by one in a trial. It could run as many trials as there are unique values for sql-mode.