# This file is part of the rsyslog project, released under ASL 2.0
echo ===============================================================================
echo \[mysql-act-mt.sh\]: test for mysql with multithread actionq
source $srcdir/diag.sh init
mysql --user=rsyslog --password=testbench < testsuites/mysql-truncate.sql
source $srcdir/diag.sh startup-vg mysql-actq-mt.conf
source $srcdir/diag.sh injectmsg  0 50000
source $srcdir/diag.sh wait-queueempty 
echo waiting for worker threads to timeout
./msleep 3000
source $srcdir/diag.sh injectmsg  50000 50000
source $srcdir/diag.sh wait-queueempty 
echo waiting for worker threads to timeout
./msleep 2000
source $srcdir/diag.sh injectmsg  100000 50000
source $srcdir/diag.sh shutdown-when-empty
source $srcdir/diag.sh wait-shutdown-vg 
source $srcdir/diag.sh check-exit-vg
# note "-s" is requried to suppress the select "field header"
mysql -s --user=rsyslog --password=testbench < testsuites/mysql-select-msg.sql > rsyslog.out.log
source $srcdir/diag.sh seq-check  0 149999
source $srcdir/diag.sh exit