Uploaded image for project: 'Help-Coaches-Desk'
  1. Help-Coaches-Desk
  2. HELC-937

FIWARE.Request.Coach.CreatiFI.FIWARE.Request.Lab.Data.BigData-Analysis.EventualHiveConnectionRefuse

    Details

    • Type: extRequest
    • Status: Closed
    • Priority: Major
    • Resolution: Done
    • Component/s: CreatiFI
    • Labels:
      None

      Description

      Hi,

      an applicant has reported the following high priority issue:

      *Hi! *

      *We are connecting SpagoBI to Cosmos via
      jdbc:hive://cosmos.lab.fi-ware.org:10000/default
      <http://cosmos.lab.fi-ware.org:10000/default> and sometimes it works and
      sometimes we get the exception below. Is there a quota by day or If I made
      "many" invalid connections it just banned the connections from that IP for
      a period of time...*

      *The exception below is using SpagoBI Studio, using SpagoBI Web application
      I have the same exception Connection refused, but with other StackTrace.*

      org.eclipse.birt.report.data.*oda.jdbc.JDBCException: There is an
      error in get connection, Could not establish connection to
      cosmos.lab.fi-ware.org:10000/default
      <http://cosmos.lab.fi-ware.org:10000/default>:
      java.net.ConnectException: Connection refused: connect.
      at org.eclipse.birt.report.data.*oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.*java:303)
      at org.eclipse.birt.report.data.*oda.jdbc.JDBCDriverManager.getConnection(*JDBCDriverManager.java:205)
      at org.eclipse.birt.report.data.*oda.jdbc.JDBCDriverManager.tryCreateConnection(*JDBCDriverManager.java:787)
      at org.eclipse.birt.report.data.*oda.jdbc.JDBCDriverManager.testConnection(*JDBCDriverManager.java:708)
      at org.eclipse.birt.report.data.*oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.*java:147)
      at org.eclipse.birt.report.data.*oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.*java:175)
      at org.eclipse.birt.report.data.*oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.*java:156)
      at org.eclipse.birt.report.data.*oda.jdbc.ui.profile.JDBCSelectionPageHelper.testConnection(JDBCSelectionPageHelper.java:*729)
      at org.eclipse.birt.report.data.*oda.jdbc.ui.profile.JDBCSelectionPageHelper.access$8(JDBCSelectionPageHelper.java:*697)
      at org.eclipse.birt.report.data.*oda.jdbc.ui.profile.JDBCSelectionPageHelper$8.widgetSelected(JDBCSelectionPageHelper.java:*620)
      at org.eclipse.swt.widgets.*TypedListener.handleEvent(*TypedListener.java:234)
      at org.eclipse.swt.widgets.*EventTable.sendEvent(*EventTable.java:84)
      at org.eclipse.swt.widgets.*Widget.sendEvent(Widget.java:*1053)
      at org.eclipse.swt.widgets.*Display.runDeferredEvents(*Display.java:4066)
      at org.eclipse.swt.widgets.*Display.readAndDispatch(*Display.java:3657)
      at org.eclipse.jface.window.*Window.runEventLoop(Window.*java:825)
      at org.eclipse.jface.window.**Window.open(Window.java:801)
      at org.eclipse.birt.report.*designer.ui.dialogs.BaseDialog.open(BaseDialog.*java:111)
      at org.eclipse.birt.report.*designer.data.ui.providers.EditableDataSourceNodeProvider.performEdit(EditableDataSourceNodeProvider*.java:73)
      at org.eclipse.birt.report.*designer.internal.ui.views.DefaultNodeProvider.performRequest(*DefaultNodeProvider.java:442)
      at org.eclipse.birt.report.*designer.internal.ui.views.actions.EditAction.doAction(*EditAction.java:90)
      at org.eclipse.birt.report.*designer.internal.ui.views.actions.AbstractElementAction.run(AbstractElementAction.*java:70)
      at org.eclipse.birt.report.*designer.internal.ui.views.RenameListener.doubleClick(*RenameListener.java:214)
      at org.eclipse.jface.viewers.*StructuredViewer$1.run(*StructuredViewer.java:824)
      at org.eclipse.core.runtime.*SafeRunner.run(SafeRunner.*java:42)
      at org.eclipse.ui.internal.*JFaceUtil$1.run(JFaceUtil.*java:49)
      at org.eclipse.jface.util.*SafeRunnable.run(SafeRunnable.*java:175)
      at org.eclipse.jface.viewers.*StructuredViewer.fireDoubleClick(*StructuredViewer.java:822)
      at org.eclipse.jface.viewers.*AbstractTreeViewer.handleDoubleSelect(*AbstractTreeViewer.java:1421)
      at org.eclipse.jface.viewers.*StructuredViewer$4.widgetDefaultSelected(*StructuredViewer.java:1225)
      at org.eclipse.jface.util.*OpenStrategy.fireDefaultSelectionEvent(*OpenStrategy.java:238)
      at org.eclipse.jface.util.*OpenStrategy.access$0(*OpenStrategy.java:235)
      at org.eclipse.jface.util.*OpenStrategy$1.handleEvent(*OpenStrategy.java:296)
      at org.eclipse.swt.widgets.*EventTable.sendEvent(*EventTable.java:84)
      at org.eclipse.swt.widgets.*Widget.sendEvent(Widget.java:*1053)
      at org.eclipse.swt.widgets.*Display.runDeferredEvents(*Display.java:4066)
      at org.eclipse.swt.widgets.*Display.readAndDispatch(*Display.java:3657)
      at org.eclipse.ui.internal.*Workbench.runEventLoop(*Workbench.java:2640)
      at org.eclipse.ui.internal.*Workbench.runUI(Workbench.*java:2604)
      at org.eclipse.ui.internal.*Workbench.access$4(Workbench.*java:2438)
      at org.eclipse.ui.internal.*Workbench$7.run(Workbench.*java:671)
      at org.eclipse.core.databinding.*observable.Realm.*runWithDefault(Realm.java:332)
      at org.eclipse.ui.internal.*Workbench.createAndRunWorkbench(*Workbench.java:664)
      at org.eclipse.ui.PlatformUI.*createAndRunWorkbench(*PlatformUI.java:149)
      at org.eclipse.ui.internal.ide.*application.IDEApplication.*start(IDEApplication.java:115)
      at org.eclipse.equinox.internal.*app.EclipseAppHandle.run(*EclipseAppHandle.java:196)
      at org.eclipse.core.runtime.*internal.adaptor.EclipseAppLauncher.runApplication(*EclipseAppLauncher.java:110)
      at org.eclipse.core.runtime.*internal.adaptor.EclipseAppLauncher.start(*EclipseAppLauncher.java:79)
      at org.eclipse.core.runtime.*adaptor.EclipseStarter.run(*EclipseStarter.java:369)
      at org.eclipse.core.runtime.*adaptor.EclipseStarter.run(*EclipseStarter.java:179)
      at sun.reflect.*NativeMethodAccessorImpl.*invoke0(Native Method)
      at sun.reflect.*NativeMethodAccessorImpl.*invoke(Unknown Source)
      at sun.reflect.*DelegatingMethodAccessorImpl.*invoke(Unknown Source)
      at java.lang.reflect.Method.**invoke(Unknown Source)
      at org.eclipse.equinox.launcher.*Main.invokeFramework(Main.*java:620)
      at org.eclipse.equinox.launcher.**Main.basicRun(Main.java:575)
      at org.eclipse.equinox.launcher.**Main.run(Main.java:1408)
      *

      Regards,
      --------------------------------------------------------

      Gerard Castillo Lasheras
      Enginyer de Projectes
      FundaciĆ³ i2CAT - Unitat Audiovisual
      SkypeID: gerardcl85
      Telf.: +34.93.553.26.30 (530)
      --------------------------------------------------------

      _______________________________________________
      Fiware-creatifi-coaching mailing list
      Fiware-creatifi-coaching@lists.fi-ware.org
      https://lists.fi-ware.org/listinfo/fiware-creatifi-coaching

      [Created via e-mail received from: Gerard Castillo Lasheras <gerard.castillo@i2cat.net>]

        Issue Links

          Activity

          Hide
          frb Francisco Romero added a comment -

          Hi,

          there is no connection limit nor quota on the Hive interface usage. The problem is this is a shared interface among all the FIWARE Lab users, and sometimes it gets flooded due to the large ammount of parallel connections. This is something that cannot be easily fixed, several servers should be running on parallel and some kind of balancer would be needed; since a new global instance is going to be released in the very short-term, this is something to think about regarding such new instance (the current one will be deprecated).

          Regards,
          Francisco

          Show
          frb Francisco Romero added a comment - Hi, there is no connection limit nor quota on the Hive interface usage. The problem is this is a shared interface among all the FIWARE Lab users, and sometimes it gets flooded due to the large ammount of parallel connections. This is something that cannot be easily fixed, several servers should be running on parallel and some kind of balancer would be needed; since a new global instance is going to be released in the very short-term, this is something to think about regarding such new instance (the current one will be deprecated). Regards, Francisco

            People

            • Assignee:
              silviocretti Silvio Cretti
              Reporter:
              fw.ext.user FW External User
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: