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
-
HELP-4508 FIWARE.Request.Tech.Data.BigData-Analysis.EventualHiveConnectionRefuse
- Closed
Activity
- All
- Comments
- History
- Activity
- Transitions
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