Details
-
Bug
-
Status: Done
-
High
-
Resolution: Fixed
-
8.0.x
-
None
Description
PXC-5.7 version : 5.7.24-26-31.33-debug
PXC-8.0 version : 8.0.15-5-31.33-debug
Testcase
/dev/shm/qa/pxc57/bin/mysqld --no-defaults --defaults-group-suffix=.1 --basedir=/dev/shm/qa/pxc57 --datadir=/dev/shm/qa/node1 --innodb_file_per_table --log-error-verbosity=3 --wsrep-debug=1 --pxc_maint_transition_period=1 --innodb_autoinc_lock_mode=2 --wsrep-provider=/dev/shm/qa/pxc57/lib/libgalera_smm.so --wsrep_cluster_address=gcomm:// --wsrep_node_incoming_address=127.0.0.1 --wsrep_provider_options=gmcast.listen_addr=tcp://127.0.0.1:26108 --wsrep_sst_method=rsync --wsrep_sst_auth=root: --wsrep_node_address=127.0.0.1 --innodb_flush_method=O_DIRECT --core-file --sql-mode=no_engine_substitution --secure-file-priv= --loose-innodb-status-file=1 --log-error=/dev/shm/qa/node1/node1.err --socket=/dev/shm/qa/node1/socket.sock --log-output=none --port=26100 --server-id=11 --wsrep_slave_threads=2 & /dev/shm/qa/pxc57/bin/mysqld --no-defaults --defaults-group-suffix=.1 --basedir=/dev/shm/qa/pxc57 --datadir=/dev/shm/qa/node2 --innodb_file_per_table --log-error-verbosity=3 --wsrep-debug=1 --pxc_maint_transition_period=1 --innodb_autoinc_lock_mode=2 --wsrep-provider=/dev/shm/qa/pxc57/lib/libgalera_smm.so --wsrep_cluster_address=gcomm://127.0.0.1:26108,gcomm://127.0.0.1:26208 --wsrep_node_incoming_address=127.0.0.1 --wsrep_provider_options=gmcast.listen_addr=tcp://127.0.0.1:26208 --wsrep_sst_method=rsync --wsrep_sst_auth=root: --wsrep_node_address=127.0.0.1 --innodb_flush_method=O_DIRECT --core-file --sql-mode=no_engine_substitution --secure-file-priv= --loose-innodb-status-file=1 --log-error=/dev/shm/qa/node2/node2.err --socket=/dev/shm/qa/node2/socket.sock --log-output=none --port=26200 --server-id=12 --wsrep_slave_threads=2 & /dev/shm/qa/pxc57/bin/mysqld --no-defaults --defaults-group-suffix=.1 --basedir=/dev/shm/qa/pxc57 --datadir=/dev/shm/qa/node3 --innodb_file_per_table --log-error-verbosity=3 --wsrep-debug=1 --pxc_maint_transition_period=1 --innodb_autoinc_lock_mode=2 --wsrep-provider=/dev/shm/qa/pxc57/lib/libgalera_smm.so --wsrep_cluster_address=gcomm://127.0.0.1:26108,gcomm://127.0.0.1:26208,gcomm://127.0.0.1:26308 --wsrep_node_incoming_address=127.0.0.1 --wsrep_provider_options=gmcast.listen_addr=tcp://127.0.0.1:26308 --wsrep_sst_method=rsync --wsrep_sst_auth=root: --wsrep_node_address=127.0.0.1 --innodb_flush_method=O_DIRECT --core-file --sql-mode=no_engine_substitution --secure-file-priv= --loose-innodb-status-file=1 --log-error=/dev/shm/qa/node3/node3.err --socket=/dev/shm/qa/node3/socket.sock --log-output=none --port=26300 --server-id=13 --wsrep_slave_threads=2 & mysql -A -uroot -S/dev/shm/qa/node1/socket.sock -e "create user [email protected]'%' identified with mysql_native_password by 'test';" mysql -A -uroot -S/dev/shm/qa/node1/socket.sock -e "grant all on *.* to [email protected]'%';" mysql -A -uroot -S/dev/shm/qa/node1/socket.sock -e "drop database if exists sbtest;create database sbtest" sysbench /usr/share/sysbench/oltp_insert.lua --mysql-db=sbtest --mysql-user=sysbench --mysql-password=test --db-driver=mysql --mysql-socket=/dev/shm/qa/node1/socket.sock --threads=10 --tables=10 --table-size=1000 prepare sysbench /usr/share/sysbench/oltp_read_write.lua --mysql-db=sbtest --mysql-user=sysbench --mysql-password=test --db-driver=mysql --mysql-socket=/dev/shm/qa/node1/socket.sock --threads=10 --tables=10 --time=3000 --report-interval=10 run /dev/shm/qa/pxc80/bin/mysqld --no-defaults --defaults-group-suffix=.1 --basedir=/dev/shm/qa/pxc80 --datadir=/dev/shm/qa/node3 --innodb_file_per_table --log-error-verbosity=3 --wsrep-debug=1 --pxc_maint_transition_period=1 --innodb_autoinc_lock_mode=2 --wsrep-provider=/dev/shm/qa/pxc80/lib/libgalera_smm.so --wsrep_cluster_address=gcomm://127.0.0.1:26108,gcomm://127.0.0.1:26208,gcomm://127.0.0.1:26308 --wsrep_node_incoming_address=127.0.0.1 --wsrep_provider_options=gmcast.listen_addr=tcp://127.0.0.1:26308 --wsrep_sst_method=rsync --wsrep_node_address=127.0.0.1 --innodb_flush_method=O_DIRECT --core-file --sql-mode=no_engine_substitution --secure-file-priv= --loose-innodb-status-file=1 --log-error=/dev/shm/qa/node3/node3.err --socket=/dev/shm/qa/node3/socket.sock --log-output=none --port=26300 --server-id=13 --wsrep_slave_threads=2 & node3:[email protected]> show databases; ERROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not exist node3:[email protected]>