Informix

Expand all | Collapse all

HQ blues

  • 1.  HQ blues

    Posted 7 days ago
    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 7 days ago

    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 7 days ago
    Thanks Eric.

    I am using FC3. 

    HQ works fine otherwise.

    Regs,
    -Snorri

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



  • 4.  RE: HQ blues

    Posted 7 days ago

    Never had it, as I said.

     

    What is the sequence to reproduce ?

     






  • 5.  RE: HQ blues

    Posted 7 days ago
    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 4 days ago
    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 yesterday
    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
    ------------------------------