Informix

nested-group-icon.png

DB2

Expand all | Collapse all

HQ blues

  • 1.  HQ blues

    Posted Fri May 22, 2020 05:34 AM
    Hello everyone.

    Just started to use Informix HQ. 
    Before contacting support, I wander if you have encountered this problem.

    When trying to list Tables & Indexes in our main database (others work fine) HQ displays the error: 

    Could not get the data. {{suffix}}

    In the HQ server log I get:

    2020-05-22 09:31:01.647 [qtp124888672-146] ERROR c.i.h.s.r.api.GenericExceptionMapper - Exception in REST API
    java.lang.NullPointerException: null
    at com.informix.hq.server.rest.api.informix.StorageResource.parseCompressionEstimate(StorageResource.java:1385)
    at com.informix.hq.server.rest.api.informix.StorageResource.getTablesAndIndexesInfo(StorageResource.java:1157)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
    at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
    at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
    at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205)
    at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
    at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
    at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
    at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
    at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
    at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
    at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
    at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
    at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
    at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
    at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
    at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
    at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
    at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
    at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
    at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
    at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
    at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:845)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1689)
    at com.informix.hq.server.SecurityFilter.doFilter(SecurityFilter.java:48)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1676)
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:581)
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1174)
    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511)
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1106)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
    at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)
    at org.eclipse.jetty.server.Server.handle(Server.java:524)
    at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:319)
    at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:253)
    at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273)
    at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95)
    at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)
    at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303)
    at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148)
    at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136)
    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671)
    at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589)
    at java.lang.Thread.run(Thread.java:748)

    Thanks in advance,
    -Snorri

    ------------------------------
    Snorri Bergmann
    ------------------------------


  • 2.  RE: HQ blues

    Posted Fri May 22, 2020 05:44 AM

    Hi Snorri,

     

     

    I am using 14.10 FC3 and never had this message. Which 14.10 is this ?
    And to be sincere, those java message are somewhat depressing.

     

    Does anything of HQ work apart from this functionality?

     






  • 3.  RE: HQ blues

    Posted Fri May 22, 2020 06:02 AM
    Thanks Eric.

    I am using FC3. 

    HQ works fine otherwise.

    Regs,
    -Snorri

    ------------------------------
    Snorri Bergmann
    ------------------------------



  • 4.  RE: HQ blues

    Posted Fri May 22, 2020 06:58 AM

    Never had it, as I said.

     

    What is the sequence to reproduce ?

     






  • 5.  RE: HQ blues

    Posted Fri May 22, 2020 07:15 AM
    Eric

    Storage -> Tables and Indexes

    First database (audit) is OK, tables show up.
    Then I select our main database and the error occurs.

    I just created a case with Tech Support, let's see what they come up with.
    Regards,
    -Snorri

    ------------------------------
    Snorri Bergmann
    ------------------------------



  • 6.  RE: HQ blues

    Posted Mon May 25, 2020 03:32 AM
    This is clearly a Informix HQ bug. Stack trace denotes it's something related to table compression evaluation.

    Please, contact support.

    Vicente

    ------------------------------
    Vicente Salvador Cubedo
    ------------------------------



  • 7.  RE: HQ blues

    Posted Thu May 28, 2020 05:11 AM
    Hi guys.

    Just wanted to let you know that this error went away silently on monday.
    My suspicion is that auto update stats during the weekend fixed this somehow (as I upgraded this instance from 12.10.FC12 a week ago).

    Best regards,
    -Snorri

    ------------------------------
    Snorri Bergmann
    ------------------------------