Hello, Can you share your test plan ? or run in JMeter 5.X: Menu Tools > Generate Schematic Overview. Or screenshots of your test plan (the Tree + Screenshots of each JDBC Request element) Thanks
On Thu, Sep 3, 2020 at 6:16 PM Brian Flowers <[email protected]> wrote: > 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 > [email protected] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > -- > <[email protected]> > > Regards > <[email protected]>Ubik Load Pack <http://ubikloadpack.com> Team > Follow us on Twitter <http://twitter.com/ubikloadpack> > > > Cordialement > L'équipe Ubik Load Pack <http://ubikloadpack.com> > Suivez-nous sur Twitter <http://twitter.com/ubikloadpack> > > > >
