Uploaded image for project: 'ngrinder'
  1. ngrinder
  2. NGRINDER-571

Fix DB errors occurred during running test because agent_status field is not long enough

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.1.2
    • Fix Version/s: 3.1.3
    • Component/s: controller
    • Labels:
      None

      Description

      Error during running test:

      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]

        Activity

        Hide
        mavlarn Mavlarn Tuohuti added a comment -

        Duplicated with NGRINDER-569.

        Show
        mavlarn Mavlarn Tuohuti added a comment - Duplicated with NGRINDER-569 .
        Hide
        junoyoon JunHo Yoon added a comment -

        Change the issue name. and close

        Show
        junoyoon JunHo Yoon added a comment - Change the issue name. and close
        Hide
        junoyoon JunHo Yoon added a comment -

        Close All

        Show
        junoyoon JunHo Yoon added a comment - Close All

          People

          • Assignee:
            junoyoon JunHo Yoon
            Reporter:
            mavlarn Mavlarn Tuohuti
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: