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

            relates to

            extRequest - Request from external stakeholder received in the help desk HELP-4508 FIWARE.Request.Tech.Data.BigData-Analysis.EventualHiveConnectionRefuse

            • Major - Major loss of function.
            • Closed

              Activity

              Ascending order - Click to sort in descending order
              fw.ext.user FW External User created issue -
              silviocretti Silvio Cretti made changes -
              Field Original Value New Value
              Component/s CreatiFI [ 10357 ]
              silviocretti Silvio Cretti made changes -
              Assignee Leandro Guillén [ leandro.guillen ]
              mcp Miguel Carrillo made changes -
              Assignee Leandro Guillén [ leandro.guillen ] Francisco Romero [ frb ]
              frb Francisco Romero made changes -
              Summary [Fiware-creatifi-coaching] [CreatiFI Barcelona Hub] General Support #392: Connect to Hive - Connection Refused FIWARE.Request.Lab.Data.BigData-Analysis.EventualHiveConnectionRefuse
              frb Francisco Romero made changes -
              Status Open [ 1 ] In Progress [ 3 ]
              Hide
              Permalink
              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
              frb Francisco Romero made changes -
              Status In Progress [ 3 ] Answered [ 10104 ]
              mev Manuel Escriche made changes -
              Assignee Francisco Romero [ frb ] Silvio Cretti [ silvio.cretti ]
              mev Manuel Escriche made changes -
              Component/s _TECH_ [ 11400 ]
              backlogmanager Backlog Manager made changes -
              Link This issue relates to HELP-4508 [ HELP-4508 ]
              backlogmanager Backlog Manager made changes -
              Component/s _TECH_ [ 11400 ]
              silviocretti Silvio Cretti made changes -
              Resolution Done [ 10000 ]
              Status Answered [ 10104 ] Closed [ 6 ]
              backlogmanager Backlog Manager made changes -
              Summary FIWARE.Request.Lab.Data.BigData-Analysis.EventualHiveConnectionRefuse FIWARE.Request.Coach.CreatiFI.FIWARE.Request.Lab.Data.BigData-Analysis.EventualHiveConnectionRefuse
              Transition Time In Source Status Execution Times Last Executer Last Execution Date
              Open Open In Progress In Progress
              		2d 22h 1m 1 Francisco Romero 14/Aug/15 11:51 AM
              In Progress In Progress Answered Answered
              		4m 23s 1 Francisco Romero 14/Aug/15 11:56 AM
              Answered Answered Closed Closed
              		47d 4h 27m 1 Silvio Cretti 30/Sep/15 4:24 PM

                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: