Hi everyone, I'm having some issues using JMeter to insert some records in a MariaDB database with autocommit disabled (the idea being that we want to commit every ~1000 records, not after each one).
Did some searches and couldn't find any documentation or tutorials explaining this...I got desperate enough to ask on StackOverflow :) but the only response so far seems to indicate that I'm configuring it correctly: https://stackoverflow.com/questions/63713516/jmeter-jdbc-manual-commit I started with JMeter 3.2 connecting via the mysql connector version 5.1.27 as that's what we already had...I realize those are pretty old, so I did try upgrading, but got the same results. Tried on JMeter 5.3 with mysql connector 8.0.21, and also with the dedicated mariadb connector version 2.11.3 (all connectors from the Maven repository). With auto commit true, any combination of those versions works fine. With auto commit false, I can't get my data committed on any of them. What I have set up right now is a thread group with one thread, than contains a JDBC request with a single INSERT statement, using a couple variables that it takes from a csv data set and a counter, on a constant throughput timer, and I'm using the loop count in the thread group to control the number of records inserted. When I have auto commit set to true in the JDBC configuration, the records all get inserted just fine. But when I turn auto commit off, I can't get those statements committed. I set the JDBC request query type to "AutoCommit(false)" instead of "Update Statement", then I added a second JDBC request on the same configuration with request type of "Commit". In the results tree I can see a commit statement following each insert statement with no errors, but the records don't actually get committed in the DB. I tried adding the commit inside the original JDBC request (just to see if that'd work) but that gave a SQL error; I tried adding a commit post processor within the main JDBC request, but no luck there. I tried adding a pre-processor to open a transaction, assuming that it wasn't including the commit and the insert on the same transaction, but no change with that. I tried configuration transaction isolation as DEFAULT or as TRANSACTION_SERIALIZABLE but that had no apparent effect either. So...how do I manually commit an insert statement on a mariaDB database? Or what else can I check to try to diagnose exactly what is going on here? Are there any resources or documentation about exactly how to use the autocommit setting? Thanks! Brian Flowers jmeter-s...@bsflowers.net --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org For additional commands, e-mail: user-h...@jmeter.apache.org
