Schematic overview is attached Screenshots are uploaded at imgbb:
JDBC Configuration: https://ibb.co/Nm1nbN1 Thread Group: https://ibb.co/wKRQsQG JDBC Request: https://ibb.co/T4ng1R9 Commit: https://ibb.co/dcBVHNF CSV: https://ibb.co/Y8TRRRZ Timer: https://ibb.co/yXX4PgM Counter: https://ibb.co/Xb9B47Q Thanks! On 9/3/20 12:40 PM, UBIK LOAD PACK Support wrote: > 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> >> >> >> >>
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
