测试结果图表为空

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

测试结果图表为空

higkoo
刚开始所有节点机器名相同时,没有任何问题。把机器名改为唯一之后出现结果无法显示的问题,控制台日志如下:
Caused by: org.h2.jdbc.JdbcSQLException: Value too long for column "AGENT_STAT VARCHAR(2000)": "'{""agent32.higkoo.org"":{""port"":0,""system"":""LINUX"",""collectTime"":1362982622754,""freeMemory"":1587248,""totalMemory"":3924216,""cpuUse... (3234)"; SQL statement:
update PERF_TEST set last_modified_date=?, last_modified_user=?, agent_count=?, agent_stat=?, description=?, distribution_path=?, duration=?, errors=?, finish_time=?, ignore_sample_count=?, init_processes=?, init_sleep_time=?, last_progress_message=?, mean_test_time=?, monitor_stat=?, peak_tps=?, port=?, process_increment=?, process_increment_interval=?, processes=?, progress_message=?, region=?, run_count=?, running_sample=?, safe_distribution=?, scheduled_time=?, script_name=?, script_revision=?, send_mail=?, start_time=?, status=?, stop_request=?, tag_string=?, target_hosts=?, test_comment=?, test_error_cause=?, name=?, test_time_standard_deviation=?, tests=?, threads=?, threshold=?, tps=?, use_rampup=?, vuser_per_agent=? where id=? [22001-168]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) ~[h2-1.3.168.jar:1.3.168]
at org.h2.message.DbException.get(DbException.java:169) ~[h2-1.3.168.jar:1.3.168]
at org.h2.table.Column.validateConvertUpdateSequence(Column.java:315) ~[h2-1.3.168.jar:1.3.168]
at org.h2.table.Table.validateConvertUpdateSequence(Table.java:689) ~[h2-1.3.168.jar:1.3.168]
at org.h2.command.dml.Update.update(Update.java:123) ~[h2-1.3.168.jar:1.3.168]
at org.h2.command.CommandContainer.update(CommandContainer.java:75) ~[h2-1.3.168.jar:1.3.168]
at org.h2.command.Command.executeUpdate(Command.java:230) ~[h2-1.3.168.jar:1.3.168]
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:156) ~[h2-1.3.168.jar:1.3.168]
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:142) ~[h2-1.3.168.jar:1.3.168]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]
at sun.reflect.GeneratedMethodAccessor75.invoke(Unknown Source) ~[na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_09]
at java.lang.reflect.Method.invoke(Method.java:601) ~[na:1.7.0_09]
at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122) ~[hibernate-core-4.0.1.Final.jar:4.0.1.Final]
... 40 common frames omitted
2013-03-11 14:22:14,376 INFO SingleConsole.java:1206 : Sampling is stopped
2013-03-11 14:22:14,391 INFO MonitorCollectorListener.java:87 : remove monitors on [org.ngrinder.model.AgentInfo@5e18e6bf[ip=10.20.223.118,port=13243,agentIdentity=,hostName=,status=,systemStat=,region=,number=0,approved=false,id=]]
2013-03-11 14:22:14,395 INFO PerfTestService.java:1127 : Total Statistics for test 1 is {}
2013-03-11 14:22:33,914 ERROR ConsoleManager.java:239 : Exception occurs while shuttdowning console in returnback process for test perftest_1_admin.
org.ngrinder.common.exception.NGrinderRuntimeException: Connection is not completed until 10 sec
at net.grinder.SingleConsole.waitUntilAllAgentDisconnected(SingleConsole.java:562) ~[ngrinder-core-3.1.2.jar:na]
at org.ngrinder.perftest.service.ConsoleManager.returnBackConsole(ConsoleManager.java:237) ~[ConsoleManager.class:na]
at org.ngrinder.perftest.service.ConsoleManager$$FastClassByCGLIB$$bdc12b91.invoke() [cglib-2.2.2.jar:na]
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) [cglib-2.2.2.jar:na]
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689) [spring-aop-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [spring-aop-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:80) [spring-aop-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [na:1.7.0_09]
at java.util.concurrent.FutureTask.run(FutureTask.java:166) [na:1.7.0_09]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [na:1.7.0_09]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [na:1.7.0_09]
at java.lang.Thread.run(Thread.java:722) [na:1.7.0_09]
Reply | Threaded
Open this post in threaded view
|

测试环境如下:

higkoo
ngrinder-controller-3.1.2-with-tomcat.zip
ngrinder-core-3.1.2-agent-package.zip

CentOS release 6.3 (Final)

# java -version
java version "1.7.0_09"
Java(TM) SE Runtime Environment (build 1.7.0_09-b05)
Java HotSpot(TM) 64-Bit Server VM (build 23.5-b02, mixed mode)

# uname -a
Linux agent21.higkoo.org 2.6.32-279.el6.x86_64 #1 SMP Fri Jun 22 12:19:21 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux
Reply | Threaded
Open this post in threaded view
|

RE: 测试结果图表为空

Mavlarn
In reply to this post by higkoo

谢谢提供错误信息,这是由于agent的状态信息过长导致的,我们会在3.1.3版本中修复。

目前,您可以先用h2数据库的客户端工具,手动修改perf_test表的AGENT_STAT字段,将长度改大一点使用,例如改成4000。这个字段是在测试运行过程中,保存运行这个测试的agent的状态的,在测试结束以后,会清空里面的数据。

 

谢谢。

 

-----Original Message-----
From: "higkoo [via ngrinder]"<[hidden email]>
To: "Mavlarn"<[hidden email]>;
Cc:
Sent: 2013-03-11 (星期一) 15:28:38
Subject: 测试结果图表为空

刚开始所有节点机器名相同时,没有任何问题。把机器名改为唯一之后出现结果无法显示的问题,控制台日志如下:
Caused by: org.h2.jdbc.JdbcSQLException: Value too long for column "AGENT_STAT VARCHAR(2000)": "'{""agent32.higkoo.org"":{""port"":0,""system"":""LINUX"",""collectTime"":1362982622754,""freeMemory"":1587248,""totalMemory"":3924216,""cpuUse... (3234)"; SQL statement:
update PERF_TEST set last_modified_date=?, last_modified_user=?, agent_count=?, agent_stat=?, description=?, distribution_path=?, duration=?, errors=?, finish_time=?, ignore_sample_count=?, init_processes=?, init_sleep_time=?, last_progress_message=?, mean_test_time=?, monitor_stat=?, peak_tps=?, port=?, process_increment=?, process_increment_interval=?, processes=?, progress_message=?, region=?, run_count=?, running_sample=?, safe_distribution=?, scheduled_time=?, script_name=?, script_revision=?, send_mail=?, start_time=?, status=?, stop_request=?, tag_string=?, target_hosts=?, test_comment=?, test_error_cause=?, name=?, test_time_standard_deviation=?, tests=?, threads=?, threshold=?, tps=?, use_rampup=?, vuser_per_agent=? where id=? [22001-168]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) ~[h2-1.3.168.jar:1.3.168]
at org.h2.message.DbException.get(DbException.java:169) ~[h2-1.3.168.jar:1.3.168]
at org.h2.table.Column.validateConvertUpdateSequence(Column.java:315) ~[h2-1.3.168.jar:1.3.168]
at org.h2.table.Table.validateConvertUpdateSequence(Table.java:689) ~[h2-1.3.168.jar:1.3.168]
at org.h2.command.dml.Update.update(Update.java:123) ~[h2-1.3.168.jar:1.3.168]
at org.h2.command.CommandContainer.update(CommandContainer.java:75) ~[h2-1.3.168.jar:1.3.168]
at org.h2.command.Command.executeUpdate(Command.java:230) ~[h2-1.3.168.jar:1.3.168]
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:156) ~[h2-1.3.168.jar:1.3.168]
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:142) ~[h2-1.3.168.jar:1.3.168]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]
at sun.reflect.GeneratedMethodAccessor75.invoke(Unknown Source) ~[na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_09]
at java.lang.reflect.Method.invoke(Method.java:601) ~[na:1.7.0_09]
at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122) ~[hibernate-core-4.0.1.Final.jar:4.0.1.Final]
... 40 common frames omitted
2013-03-11 14:22:14,376 INFO SingleConsole.java:1206 : Sampling is stopped
2013-03-11 14:22:14,391 INFO MonitorCollectorListener.java:87 : remove monitors on [org.ngrinder.model.AgentInfo@5e18e6bf[ip=10.20.223.118,port=13243,agentIdentity=,hostName=,status=,systemStat=,region=,number=0,approved=false,id=]]
2013-03-11 14:22:14,395 INFO PerfTestService.java:1127 : Total Statistics for test 1 is {}
2013-03-11 14:22:33,914 ERROR ConsoleManager.java:239 : Exception occurs while shuttdowning console in returnback process for test perftest_1_admin.
org.ngrinder.common.exception.NGrinderRuntimeException: Connection is not completed until 10 sec
at net.grinder.SingleConsole.waitUntilAllAgentDisconnected(SingleConsole.java:562) ~[ngrinder-core-3.1.2.jar:na]
at org.ngrinder.perftest.service.ConsoleManager.returnBackConsole(ConsoleManager.java:237) ~[ConsoleManager.class:na]
at org.ngrinder.perftest.service.ConsoleManager$$FastClassByCGLIB$$bdc12b91.invoke() [cglib-2.2.2.jar:na]
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) [cglib-2.2.2.jar:na]
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689) [spring-aop-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [spring-aop-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:80) [spring-aop-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [na:1.7.0_09]
at java.util.concurrent.FutureTask.run(FutureTask.java:166) [na:1.7.0_09]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [na:1.7.0_09]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [na:1.7.0_09]
at java.lang.Thread.run(Thread.java:722) [na:1.7.0_09]


If you reply to this email, your message will be added to the discussion below:
http://ngrinder.642.n7.nabble.com/-tp440.html
To start a new topic under ngrinder-user-cn, email [hidden email]
To unsubscribe from ngrinder-user-cn, click here.
NAML