Hi Performance Team ,
We observed following exception when doing long running tests for MB 3.2.0
[1].
Have we tested metrics with postgresql? Any idea on the issue? We created
jira [2] to follow up
[1].
TID: [] [] [2016-10-05 17:02:44,321] ERROR
{org.wso2.carbon.metrics.jdbc.reporter.JDBCReporter} - Error when
reporting timers {org.wso2.carbon.metrics.jdbc.reporter.JDBCReporter}
java.sql.BatchUpdateException: Batch entry 0 INSERT INTO METRIC_TIMER
(SOURCE,TIMESTAMP,NAME,COUNT,MAX,MEAN,MIN,STDDEV,P50,P75,P95,P98,P99,P999,MEAN_RATE,M1_RATE,M5_RATE,M15_RATE,RATE_UNIT,DURATION_UNIT)
VALUES
('MBNODE30',1475701364303,'org.wso2.mb.database.read',140,107728.44155799999,37167.08968820929,0.321192,49845.87357880018,2.830612,107728.44155799999,107728.44155799999,107728.44155799999,107728.44155799999,107728.44155799999,0.0205320360573999,0.009795331416994773,0.04902573050340198,0.04158178311107816,'calls/second','milliseconds')
was aborted. Call getNextException to see the cause.
at
org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:137)
at
org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:436)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2024)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:377)
at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:1026)
at
org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1661)
at
org.wso2.carbon.metrics.jdbc.reporter.JDBCReporter.reportTimers(JDBCReporter.java:389)
at
org.wso2.carbon.metrics.jdbc.reporter.JDBCReporter.report(JDBCReporter.java:200)
at com.codahale.metrics.ScheduledReporter.report(ScheduledReporter.java:162)
at com.codahale.metrics.ScheduledReporter$1.run(ScheduledReporter.java:117)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
[2]. https://wso2.org/jira/browse/MB-1833
Thanks
--
*Hasitha Abeykoon*
Senior Software Engineer; WSO2, Inc.; http://wso2.com
*cell:* *+94 719363063*
*blog: **abeykoon.blogspot.com* <http://abeykoon.blogspot.com>
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
