You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@jmeter.apache.org by bu...@apache.org on 2016/11/16 17:04:00 UTC

[Bug 60382] DBCP2 - JDBC Sample became very slow since 3.0

https://bz.apache.org/bugzilla/show_bug.cgi?id=60382

thomas.peyrard@outlook.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All

--- Comment #1 from thomas.peyrard@outlook.com ---
I also noticed big issues with logging. Some runs might need more Xmx to avoid
issues.

Below is a stack trace of a run of 10 minutes where executing the query takes
1% (not shown) and logging 36,47% and closing connection 43,64%!
__________________________________________________________________________________________________________________________________________________________________________________
Stack Trace     Sample Count    Percentage(%)
java.lang.Thread.run()  3 658   98,972
   org.apache.jmeter.threads.JMeterThread.run() 3 658   98,972
      org.apache.jmeter.threads.JMeterThread.processSampler(Sampler, Sampler,
JMeterContext)    3 541   95,806
         org.apache.jmeter.threads.JMeterThread.executeSamplePackage(Sampler,
TransactionSampler, SamplePackage, JMeterContext) 3 541   95,806
            org.apache.jmeter.threads.JMeterThread.runPreProcessors(List)      
1 889   51,109
              
org.apache.jmeter.protocol.jdbc.processor.JDBCPreProcessor.process()     1 736 
 46,97
                 
org.apache.jmeter.protocol.jdbc.processor.AbstractJDBCProcessor.process()     1
736   46,97
                    
org.apache.jmeter.protocol.jdbc.AbstractJDBCTestElement.close(Connection)  1
613   43,642
                       
org.apache.commons.dbcp2.PoolingDataSource$PoolGuardConnectionWrapper.close()  
1 613   43,642
                          
org.apache.commons.dbcp2.DelegatingConnection.close()        1 613   43,642
                             
org.apache.commons.dbcp2.DelegatingConnection.closeInternal()     1 612  
43,615
                                
org.apache.commons.dbcp2.PoolableConnection.close()    1 611   43,588
                                   
org.apache.commons.pool2.impl.GenericObjectPool.returnObject(Object)        1
607   43,479
                                      
org.apache.commons.pool2.impl.BaseGenericObjectPool.swallowException(Exception)
 1 348   36,472
                                         
org.apache.commons.dbcp2.SwallowedExceptionLogger.onSwallowException(Exception)
      1 348   36,472
                                            
org.apache.commons.logging.impl.LogKitLogger.warn(Object, Throwable)       1
333   36,066
                                               
org.apache.log.Logger.warn(String, Throwable)   1 333   36,066
                                                  
org.apache.log.Logger.output(Priority, String, Throwable)    1 332   36,039
                                                     
org.apache.log.Logger.output(LogEvent)    1 327   35,904
                                                        
org.apache.log.Logger.fireEvent(LogEvent, LogTarget[]) 1 327   35,904
                                                           
org.apache.log.output.AbstractTarget.processEvent(LogEvent) 1 327   35,904
                                                              
org.apache.log.output.AbstractOutputTarget.doProcessEvent(LogEvent)      1 327 
 35,904
                                                                 
org.apache.log.output.io.WriterTarget.write(String)   753     20,373
                                                                    
java.io.Writer.write(String)       732     19,805
                                                                       
java.io.OutputStreamWriter.write(String, int, int)      732     19,805
                                                                          
sun.nio.cs.StreamEncoder.write(String, int, int)     732     19,805
                                                                             
sun.nio.cs.StreamEncoder.write(char[], int, int)  673     18,209
                                                                               
 sun.nio.cs.StreamEncoder.implWrite(char[], int, int)   668     18,074
                                                                               
    java.nio.charset.CharsetEncoder.encode(CharBuffer, ByteBuffer, boolean)    
666     18,019
                                                                               
       sun.nio.cs.SingleByte$Encoder.encodeLoop(CharBuffer, ByteBuffer) 666    
18,019
                                                                               
          sun.nio.cs.SingleByte$Encoder.encodeArrayLoop(CharBuffer, ByteBuffer)
655     17,722
                                                                               
             sun.nio.cs.SingleByte.access$000(CoderResult, Buffer, int, Buffer,
int)    1       0,027
_____________________________________________________________________________________________________________________________________________________________________________________

Looking at the logkit.xml file, I can see it still references excalibur, is
expected?
...  
 <factory type="file"
class="org.apache.avalon.excalibur.logger.factory.FileTargetFactory"/>
...

-- 
You are receiving this mail because:
You are the assignee for the bug.