Re: Help Needed in creation of JDBC connection at runtime

2020-07-24 Thread Flavio Cysne
You could create a pre-flight Jmeter Test plan that will generate a
property file with those values and use it as data on your JMeter script
with the simulated scenario.

This is only one way to do it, and I'm pretty sure that there are plenty
more. JMeter has other components to help you achieve this goal.

Best of luck.
Be safe and drink water!

Flavio Cysne


On Thu., Jul. 23, 2020, 11:17 a.m. deepak kodigepalli, <
deepak.kodigepa...@gmail.com> wrote:

> Hi,
>
> Is there anyway where we can create a JDBC connection using JDBC Connection
> Confiuration during runtime. The user name and password will be generated
> with a temporary connetion and new username and password will be used to
> create a new connection during runtime.
>
>
> Thanks
> Deepak
>


Re[2]: jmeter.log

2020-07-24 Thread Александр Руснак

 
I fixed it!
 
Needs to change system VARIABLE PATH and system VARIABLE JAVA_HOME to JRE
 
С уважением,
Руснак А.В.
 
  
>Пятница, 24 июля 2020, 13:12 +03:00 от Felix Schumacher 
>:
> 
>As written on  https://jmeter.apache.org/usermanual/get-started.html you can 
>tell JMeter via the environment variable JAVA_HOME which JDK/JRE should be 
>used.
>I would set those variables in the setenv.sh (or setenv.bat when running on 
>windows) script inside JMETER_HOME/bin.
>Regards
> Felix
>Am 24.07.20 um 11:59 schrieb Александр Руснак:
>>How can i switch Java if i have JRE and JDK on my server?
>> 
>> 
>>С уважением,
>>Руснак А.В.
>> 
>> 
>>>Пятница, 24 июля 2020, 10:51 +03:00 от Martin Grigorov  
>>> :
>>> 
>>>Hi Александр,  
>>>On Thu, Jul 23, 2020 at 2:58 PM Александр Руснак < 
>>>rus_alex...@mail.ru.invalid > wrote:
 
Hello!
 
I am running Jmeter drom a command line (version Jmeter 5.2.1)
Open JDK platform binary procees appears in Task Manager after running 
scripts.
This process instantly eats up all memory and i have heap space error using 
only 14 users (see log file)
 
When i run Jmeter in GUI mode i use 300+ active threads, several simple 
data writer and view results tree. And it doesnt cause any problems.
 
Can anyone help me with this?
>>> 
>>>Try with JMeter 5.3. 
>>>There is a chance that it is fixed in the latest version.
>>> 
 
 
 
С уважением,
Руснак А.В.
-
To unsubscribe, e-mail:  user-unsubscr...@jmeter.apache.org
For additional commands, e-mail:  user-h...@jmeter.apache.org
>> 
 

Re: Test plan stopped working after increasing thread count

2020-07-24 Thread David Balažic
I restarted even the OS(both client and server), does not help.
Funny, other test plans on the same db work.

Lp,
David 


> On 24 Jul 2020, at 09:48, Martin Grigorov  wrote:
> 
> CAUTION: Origin is external! The content might not be safe!
> 
> 
> Hi David,
> 
>> On Thu, Jul 16, 2020 at 7:06 PM David Balažic 
>> wrote:
>> 
>> Hi!
>> 
>> I made a test plan in JMeter 5.3 with some JDBC Request samplers.
>> 
>> It worked fine, until I increased the number of threads parameter in the
>> (only) thread group element from 1 to 2.
>> 
>> In the next run about 30 test steps were executed, then the test stopped.
>> I started in the GUI, watching results in "Summary Report" listener.
>> 
>> After changing the thread count back to 1, it still did not work.
>> When I start the test, it just stop after a second.
>> 
>> Here is the log:
>> 
>> 
>> 2020-07-16 17:55:10,543 INFO o.a.j.e.StandardJMeterEngine: Running the
>> test!
>> 2020-07-16 17:55:10,543 INFO o.a.j.s.SampleEvent: List of
>> sample_variables: []
>> 2020-07-16 17:55:10,547 INFO o.a.j.g.u.JMeterMenuBar: setRunning(true,
>> *local*)
>> 2020-07-16 17:55:10,585 INFO o.a.j.e.StandardJMeterEngine: Starting
>> ThreadGroup: 1 : myThreadGroup.
>> 2020-07-16 17:55:10,585 INFO o.a.j.e.StandardJMeterEngine: Starting 1
>> threads for group addRoleToUser  tests.
>> 2020-07-16 17:55:10,585 INFO o.a.j.e.StandardJMeterEngine: Test will stop
>> on error
>> 2020-07-16 17:55:10,585 INFO o.a.j.t.ThreadGroup: Starting thread group...
>> number=1 threads=1 ramp-up=0 delayedStart=false
>> 2020-07-16 17:55:10,586 INFO o.a.j.t.ThreadGroup: Started thread group
>> number 1
>> 2020-07-16 17:55:10,586 INFO o.a.j.e.StandardJMeterEngine: All thread
>> groups have been started
>> 2020-07-16 17:55:10,587 INFO o.a.j.t.JMeterThread: Thread started:
>> addRoleToUser  tests 1-1
>> 2020-07-16 17:55:10,753 INFO o.a.j.t.JMeterThread: Shutdown Test detected
>> by thread: addRoleToUser  tests 1-1
>> 2020-07-16 17:55:10,753 INFO o.a.j.t.JMeterThread: Thread finished:
>> addRoleToUser  tests 1-1
>> 2020-07-16 17:55:10,754 INFO o.a.j.e.StandardJMeterEngine: Notifying test
>> listeners of end of test
>> 2020-07-16 17:55:10,757 INFO o.a.j.g.u.JMeterMenuBar: setRunning(false,
>> *local*)
>> 
>> 
>> I compared the JMX file to an older version and there are no changes.
>> 
>> What could be wrong? Where to look?
>> Increasing log level does not say anything useful. It shows an SQL is
>> about to be started, then the Shutdown Test detected by thread is printed.
>> Restarting JMeter also does not help.
>> 
>> 
> A wild guess: is it possible that you have jdbc connections leak and at
> some point the DB cannot create new connections anymore.
> Try by restarting both the DB and JMeter.
> 
> 
>> 
>> Lep pozdrav,
>> David Balažic
>> 
>> 
>> -
>> To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org
>> For additional commands, e-mail: user-h...@jmeter.apache.org
>> 
>> 
> 

-
To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org
For additional commands, e-mail: user-h...@jmeter.apache.org



Re: jmeter.log

2020-07-24 Thread Felix Schumacher
As written on https://jmeter.apache.org/usermanual/get-started.html you
can tell JMeter via the environment variable JAVA_HOME which JDK/JRE
should be used.

I would set those variables in the setenv.sh (or setenv.bat when running
on windows) script inside JMETER_HOME/bin.

Regards

 Felix

Am 24.07.20 um 11:59 schrieb Александр Руснак:
> How can i switch Java if i have JRE and JDK on my server?
>  
>  
> С уважением,
> Руснак А.В.
>  
>  
>
> Пятница, 24 июля 2020, 10:51 +03:00 от Martin Grigorov
> :
>  
> Hi Александр,
>  
> On Thu, Jul 23, 2020 at 2:58 PM Александр Руснак
>  > wrote:
>
>  
> Hello!
>  
> I am running Jmeter drom a command line (version Jmeter 5.2.1)
> Open JDK platform binary procees appears in Task Manager after
> running scripts.
> This process instantly eats up all memory and i have heap
> space error using only 14 users (see log file)
>  
> When i run Jmeter in GUI mode i use 300+ active threads,
> several simple data writer and view results tree. And it
> doesnt cause any problems.
>  
> Can anyone help me with this?
>
>  
> Try with JMeter 5.3. 
> There is a chance that it is fixed in the latest version.
>  
>
>  
>  
>  
> С уважением,
> Руснак А.В.
>
> -
> To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org
> 
> 
> For additional commands, e-mail: user-h...@jmeter.apache.org
> 
>
>  


Re: jmeter.log

2020-07-24 Thread Felix Schumacher
After you ran it from command line. Have a look in the newly written
jmeter.log file. JMeter will print a few status messages at start
concerning the used versions and paths.

Are the values of those the ones that you would expect?

Do the same for a run with the gui version. Where do the values differ?

My guess is, that your environment variables differ when run as GUI and
when run as CLI.

Regards

 Felix

Am 23.07.20 um 13:57 schrieb Александр Руснак:
>  
> Hello!
>  
> I am running Jmeter drom a command line (version Jmeter 5.2.1)
> Open JDK platform binary procees appears in Task Manager after running
> scripts.
> This process instantly eats up all memory and i have heap space error
> using only 14 users (see log file)
>  
> When i run Jmeter in GUI mode i use 300+ active threads, several
> simple data writer and view results tree. And it doesnt cause any
> problems.
>  
> Can anyone help me with this?
>  
>  
>  
> С уважением,
> Руснак А.В.
>
> -
> To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org
> For additional commands, e-mail: user-h...@jmeter.apache.org


Re[2]: jmeter.log

2020-07-24 Thread Александр Руснак

How can i switch Java if i have JRE and JDK on my server?
 
 
С уважением,
Руснак А.В.
 
  
>Пятница, 24 июля 2020, 10:51 +03:00 от Martin Grigorov :
> 
>Hi Александр,  
>On Thu, Jul 23, 2020 at 2:58 PM Александр Руснак < rus_alex...@mail.ru.invalid 
>> wrote:
>> 
>>Hello!
>> 
>>I am running Jmeter drom a command line (version Jmeter 5.2.1)
>>Open JDK platform binary procees appears in Task Manager after running 
>>scripts.
>>This process instantly eats up all memory and i have heap space error using 
>>only 14 users (see log file)
>> 
>>When i run Jmeter in GUI mode i use 300+ active threads, several simple data 
>>writer and view results tree. And it doesnt cause any problems.
>> 
>>Can anyone help me with this?
> 
>Try with JMeter 5.3. 
>There is a chance that it is fixed in the latest version.
> 
>> 
>> 
>> 
>>С уважением,
>>Руснак А.В.
>>-
>>To unsubscribe, e-mail:  user-unsubscr...@jmeter.apache.org
>>For additional commands, e-mail:  user-h...@jmeter.apache.org
 

Re[2]: jmeter.log

2020-07-24 Thread Александр Руснак

Yes i try.
I dont understand why open jdk used in non gui. I install jre



Отправлено из мобильной Почты Mail.ru


пятница, 24 июля 2020 г., 10:51 +0300 от mgrigo...@apache.org  
:
>Hi Александр,
>On Thu, Jul 23, 2020 at 2:58 PM Александр Руснак < rus_alex...@mail.ru.invalid 
>> wrote:
>> 
>>Hello!
>> 
>>I am running Jmeter drom a command line (version Jmeter 5.2.1)
>>Open JDK platform binary procees appears in Task Manager after running 
>>scripts.
>>This process instantly eats up all memory and i have heap space error using 
>>only 14 users (see log file)
>> 
>>When i run Jmeter in GUI mode i use 300+ active threads, several simple data 
>>writer and view results tree. And it doesnt cause any problems.
>> 
>>Can anyone help me with this?
>
>Try with JMeter 5.3. 
>There is a chance that it is fixed in the latest version.
> 
>> 
>> 
>> 
>>С уважением,
>>Руснак А.В.
>>-
>>To unsubscribe, e-mail:  user-unsubscr...@jmeter.apache.org
>>For additional commands, e-mail:  user-h...@jmeter.apache.org

Re[2]: jmeter.log

2020-07-24 Thread Александр Руснак

How it work???



Отправлено из мобильной Почты Mail.ru


пятница, 24 июля 2020 г., 10:51 +0300 от mgrigo...@apache.org  
:
>Hi Александр,
>On Thu, Jul 23, 2020 at 2:58 PM Александр Руснак < rus_alex...@mail.ru.invalid 
>> wrote:
>> 
>>Hello!
>> 
>>I am running Jmeter drom a command line (version Jmeter 5.2.1)
>>Open JDK platform binary procees appears in Task Manager after running 
>>scripts.
>>This process instantly eats up all memory and i have heap space error using 
>>only 14 users (see log file)
>> 
>>When i run Jmeter in GUI mode i use 300+ active threads, several simple data 
>>writer and view results tree. And it doesnt cause any problems.
>> 
>>Can anyone help me with this?
>
>Try with JMeter 5.3. 
>There is a chance that it is fixed in the latest version.
> 
>> 
>> 
>> 
>>С уважением,
>>Руснак А.В.
>>-
>>To unsubscribe, e-mail:  user-unsubscr...@jmeter.apache.org
>>For additional commands, e-mail:  user-h...@jmeter.apache.org

Ha: Re: jmeter.log

2020-07-24 Thread RusnakAV


Ha: Re: Re: jmeter.log

2020-07-24 Thread RusnakAV


Re: Test plan stopped working after increasing thread count

2020-07-24 Thread Martin Grigorov
Hi David,

On Thu, Jul 16, 2020 at 7:06 PM David Balažic 
wrote:

> Hi!
>
> I made a test plan in JMeter 5.3 with some JDBC Request samplers.
>
> It worked fine, until I increased the number of threads parameter in the
> (only) thread group element from 1 to 2.
>
> In the next run about 30 test steps were executed, then the test stopped.
> I started in the GUI, watching results in "Summary Report" listener.
>
> After changing the thread count back to 1, it still did not work.
> When I start the test, it just stop after a second.
>
> Here is the log:
>
>
> 2020-07-16 17:55:10,543 INFO o.a.j.e.StandardJMeterEngine: Running the
> test!
> 2020-07-16 17:55:10,543 INFO o.a.j.s.SampleEvent: List of
> sample_variables: []
> 2020-07-16 17:55:10,547 INFO o.a.j.g.u.JMeterMenuBar: setRunning(true,
> *local*)
> 2020-07-16 17:55:10,585 INFO o.a.j.e.StandardJMeterEngine: Starting
> ThreadGroup: 1 : myThreadGroup.
> 2020-07-16 17:55:10,585 INFO o.a.j.e.StandardJMeterEngine: Starting 1
> threads for group addRoleToUser  tests.
> 2020-07-16 17:55:10,585 INFO o.a.j.e.StandardJMeterEngine: Test will stop
> on error
> 2020-07-16 17:55:10,585 INFO o.a.j.t.ThreadGroup: Starting thread group...
> number=1 threads=1 ramp-up=0 delayedStart=false
> 2020-07-16 17:55:10,586 INFO o.a.j.t.ThreadGroup: Started thread group
> number 1
> 2020-07-16 17:55:10,586 INFO o.a.j.e.StandardJMeterEngine: All thread
> groups have been started
> 2020-07-16 17:55:10,587 INFO o.a.j.t.JMeterThread: Thread started:
> addRoleToUser  tests 1-1
> 2020-07-16 17:55:10,753 INFO o.a.j.t.JMeterThread: Shutdown Test detected
> by thread: addRoleToUser  tests 1-1
> 2020-07-16 17:55:10,753 INFO o.a.j.t.JMeterThread: Thread finished:
> addRoleToUser  tests 1-1
> 2020-07-16 17:55:10,754 INFO o.a.j.e.StandardJMeterEngine: Notifying test
> listeners of end of test
> 2020-07-16 17:55:10,757 INFO o.a.j.g.u.JMeterMenuBar: setRunning(false,
> *local*)
>
>
> I compared the JMX file to an older version and there are no changes.
>
> What could be wrong? Where to look?
> Increasing log level does not say anything useful. It shows an SQL is
> about to be started, then the Shutdown Test detected by thread is printed.
> Restarting JMeter also does not help.
>
>
A wild guess: is it possible that you have jdbc connections leak and at
some point the DB cannot create new connections anymore.
Try by restarting both the DB and JMeter.


>
> Lep pozdrav,
> David Balažic
>
>
> -
> To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org
> For additional commands, e-mail: user-h...@jmeter.apache.org
>
>


Re: jmeter.log

2020-07-24 Thread Martin Grigorov
Hi Александр,

On Thu, Jul 23, 2020 at 2:58 PM Александр Руснак
 wrote:

>
> Hello!
>
> I am running Jmeter drom a command line (version Jmeter 5.2.1)
> Open JDK platform binary procees appears in Task Manager after running
> scripts.
> This process instantly eats up all memory and i have heap space error
> using only 14 users (see log file)
>
> When i run Jmeter in GUI mode i use 300+ active threads, several simple
> data writer and view results tree. And it doesnt cause any problems.
>
> Can anyone help me with this?
>

Try with JMeter 5.3.
There is a chance that it is fixed in the latest version.


>
>
>
> С уважением,
> Руснак А.В.
>
> -
> To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org
> For additional commands, e-mail: user-h...@jmeter.apache.org