Errors in the log during Performance Testing

[socio_pal <so...@yahoo.com>]

Hi:
I get the following 2 Errors while running the Database Performance test
scripts. And the error % is really high because of these 2 issues. Please do
explain why this is happening and how it can be fixed. My csv file looks
fine and the test passes if i just use 100 or 1000 samples. But when I have
like 50000 samples, I get this error. Do i have to increase the number of
Connections in the JDBC connection Config or soemthing? Please help.
-----------

And in my Jmeter "View Results Tree" I get the message 
"org.apache.avalon.excalibur.datasource.NoAvailableConnectionException:
Could not create enough Components to service your request (Timed out)."
under the sample Result. 

In the Jmeter.log file I get the following exception:

JDBC Users 1-409 started 
2006/11/27 13:14:44 INFO  - jmeter.threads.JMeterThread: Thread JDBC Users
1-410 started 
2006/11/27 13:14:44 WARN  - jmeter.protocol.jdbc.config.DataSourceElement:
Could not return Connection java.lang.Exception: Could not create enough
Components to service your request (Timed out).
	at
org.apache.avalon.excalibur.pool.ResourceLimitingPool.get(ResourceLimitingPool.java:350)
	at
org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(ValidatedResourceLimitingPool.java:130)
	at
org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getConnection(ResourceLimitingJdbcDataSource.java:222)
	at
org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:90)
	at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:247)
	at java.lang.Thread.run(Thread.java:595)

2006/11/27 13:14:44 ERROR - jmeter.protocol.jdbc.sampler.JDBCSampler: Error
in JDBC sampling
org.apache.avalon.excalibur.datasource.NoAvailableConnectionException: Could
not create enough Components to service your request (Timed out).
	

Error 2:
-----------
In Jmeter "View Results Tree" under the sample result, I see:
"Thread Name: JDBC Users 1-134
Sample Start: Mon Nov 27 13:14:46 CST 2006
Load time: 110
HTTP response code: 
HTTP response message: java.sql.SQLException: ORA-01400: cannot insert NULL
into ("EBITEST"."AGW_ACCT_SUB"."SUBSCRIBER_ID")" 


In the Jmeter.log file I see the folllowing error corresponding to the
message above:

2006/11/27 13:14:44 ERROR - jmeter.protocol.jdbc.sampler.JDBCSampler: Error
in JDBC sampling java.sql.SQLException: ORA-01400: cannot insert NULL into
("EBITEST"."AGW_ACCT_SUB"."SUBSCRIBER_ID")

	at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
	at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:561)
	at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1086)
	at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1552)
	at
org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:118)
	at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:247)
	at java.lang.Thread.run(Thread.java:595)

Thanks
-- 
View this message in context: http://www.nabble.com/Errors-in-the-log-during-Performance-Testing-tf2714009.html#a7566641
Sent from the JMeter - User mailing list archive at Nabble.com.


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