Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.8.3, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
None
-
Ubuntu 20.04
Description
I used my fuzzing tool to test MariaDB and found a statement that produce undermined (different) results in different executions.
Mariadb installation
1) cd mariadb-10.8.3
2) mkdir build; cd build
3) cmake .. -DCMAKE_BUILD_TYPE=Debug
4) make -j12 && sudo make install
Setup the environment
1) export ASAN_OPTIONS=detect_leaks=0
2) /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql &
3) /usr/local/mysql/bin/mysql -uroot -Dtestdb < mysql_bk.sql (attached) # set up the database
Reproduce bug
/usr/local/mysql/bin/mysql -uroot -Dtestdb < min_stmts.sql
some times it output 1 row:
11 60000 70.67 evl_3b 1epdod uudutd 75 NULL NULL |
some times it output 18 rows:
1 11000 84.47 _zi_wc phds2c NULL 11 NULL 59 |
1 12000 44.54 shtqnb fnsi0 NULL 8 2147483648.1 37 |
1 13000 67.69 ohmogd kmvhg NULL 77 28.4 11 |
2 14000 81.63 m1rbo _uj5ab pau_bd 70 NULL 12 |
2 15000 26.59 lo4xbb 0j212d i8qtdc 28 NULL 38 |
2 16000 96.28 gqf6o d_fttc blv1k 25 NULL 68 |
2 17000 77.52 k1q6kd srorfc 3hozeb 35 NULL 60 |
3 18000 12.15 cbnkrb NULL kotd6c 63 25.54 40 |
3 19000 28.17 wn1qpd NULL kk3lv 60 20.6 71 |
3 20000 39.2 r7txyb NULL dcvvj 44 87.15 4 |
3 21000 86.94 uk6vtd NULL zxw54 63 95.1 50 |
3 22000 46.79 xy_rqd NULL _8dxj 86 46.12 42 |
3 23000 98.38 jud5_c NULL qjiswd 71 2.1 65 |
11 60000 70.67 evl_3b 1epdod uudutd 75 NULL NULL |
11 61000 29.41 x_lkyd alqu3 hbeso 2 NULL NULL |
11 62000 29.66 y_uezd zi9wb sahip 28 NULL NULL |
11 63000 31.11 NULL rdy_wb NULL 82 NULL NULL |
11 64000 75.21 6yzn6c _ll4ld afpiw 53 NULL NULL |
It may need to try multiple times and restart the server to see the different results.
Attachments
Issue Links
- relates to
-
MDEV-29399 Affected by ROLLBACK txn, COMMIT txn produce incorrect result
- Confirmed