Hi Hasitha,
Thanks for reporting this issue. I don't think we tested the metrics with
postgresql. We will get back to you soon.
On Wed, Oct 5, 2016 at 5:29 PM, Hasitha Hiranya <hasit...@wso2.com> wrote:
> 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>
>
>
--
Malith Jayasinghe
WSO2, Inc. (http://wso2.com)
Email : mali...@wso2.com
Mobile : 0770704040
Lean . Enterprise . Middleware
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
