Re: Maximum number of redirects reached, aborting connection attempt. Sorry.

Hello Brandon,

On 28.01.2013, at 18:36, Brandon Jackson usbrandon@gmail.com wrote:

I am using a release version of MonetDB 11.13.9 "OCT2012-SP3" on Fedora 18, running as an unprivileged user with no firewall. The server quit allowing connections via JDBC and mclient this morning. mclient hangs indefinitely after asking for a password run from the same machine and account that started mserver5 via monetdbd.

"monetdb status", reports a healthy database.

JDBC connections initiated using monetdb-jdbc-2.8.jar through Pentaho Data Integration. "Maximum number of redirects reached, aborting connection attempt. Sorry." is the error message.

Does connecting to monetdb via the mclient tool work? Also, could you give us the JDBC database URL you have used to connect? Finally, if you append ?debug=1 to that string, the JDBC driver will create a debug log file of its interactions with the DB. It would be nice if you could also provide that.

Best,

Hannes

Shutting down MonetDB seemed to work. It also seems to start up okay, but still does not allow any connections. I am happy to install MonetDB with debug symbols and provide some output from gdb if that would be helpful.

Please let me know a few things I can try that may be helpful for filing a bug report and getting us back online.

Thanks for your help,

Brandon

The stack trace that came back to java was this:

Error connecting to database [monet_testing] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database

Error connecting to database: (using class nl.cwi.monetdb.jdbc.MonetDriver) Maximum number of redirects reached, aborting connection attempt. Sorry.

org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database

Error connecting to database: (using class nl.cwi.monetdb.jdbc.MonetDriver) Maximum number of redirects reached, aborting connection attempt. Sorry.

   at org.pentaho.di.core.database.Database.normalConnect(Database.java:366)
   at org.pentaho.di.core.database.Database.connect(Database.java:315)
   at org.pentaho.di.core.database.Database.connect(Database.java:277)
   at org.pentaho.di.core.database.Database.connect(Database.java:267)
   at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:86)
   at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2464)
   at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:533)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
   at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)
   at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
   at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:26)
   at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:119)
   at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
   at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
   at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
   at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
   at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
   at org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
   at org.eclipse.jface.window.Window.open(Window.java:796)
   at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:378)
   at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:304)
   at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:115)
   at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:62)
   at org.pentaho.di.ui.trans.steps.monetdbbulkloader.MonetDBBulkLoaderDialog$20.widgetSelected(MonetDBBulkLoaderDialog.java:1350)
   at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
   at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
   at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
   at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
   at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
   at org.pentaho.di.ui.trans.steps.monetdbbulkloader.MonetDBBulkLoaderDialog.open(MonetDBBulkLoaderDialog.java:905)
   at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:136)
   at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:7835)
   at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:2749)
   at org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:705)
   at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
   at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
   at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
   at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
   at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
   at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1221)
   at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7044)
   at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8304)
   at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:580)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)

Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Error connecting to database: (using class nl.cwi.monetdb.jdbc.MonetDriver) Maximum number of redirects reached, aborting connection attempt. Sorry.

   at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:502)
   at org.pentaho.di.core.database.Database.normalConnect(Database.java:350)
   ... 51 more

Caused by: java.sql.SQLException: Maximum number of redirects reached, aborting connection attempt. Sorry. at nl.cwi.monetdb.jdbc.MonetConnection.<init>(MonetConnection.java:254) at nl.cwi.monetdb.jdbc.MonetDriver.connect(MonetDriver.java:171) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:482) ... 52 more Caused by: nl.cwi.monetdb.mcl.MCLException: Maximum number of redirects reached, aborting connection attempt. Sorry. at nl.cwi.monetdb.mcl.net.MapiSocket.connect(MapiSocket.java:255) at nl.cwi.monetdb.mcl.net.MapiSocket.connect(MapiSocket.java:395) at nl.cwi.monetdb.mcl.net.MapiSocket.connect(MapiSocket.java:395) at nl.cwi.monetdb.mcl.net.MapiSocket.connect(MapiSocket.java:395) at nl.cwi.monetdb.mcl.net.MapiSocket.connect(MapiSocket.java:395) at nl.cwi.monetdb.mcl.net.MapiSocket.connect(MapiSocket.java:395) at nl.cwi.monetdb.mcl.net.MapiSocket.connect(MapiSocket.java:395) at nl.cwi.monetdb.mcl.net.MapiSocket.connect(MapiSocket.java:395) at nl.cwi.monetdb.mcl.net.MapiSocket.connect(MapiSocket.java:395) at nl.cwi.monetdb.mcl.net.MapiSocket.connect(MapiSocket.java:395) at nl.cwi.monetdb.mcl.net.MapiSocket.connect(MapiSocket.java:395) at nl.cwi.monetdb.mcl.net.MapiSocket.connect(MapiSocket.java:248) at nl.cwi.monetdb.jdbc.MonetConnection.<init>(MonetConnection.java:232) ... 56 more

Hostname : 172.27.0.209 Port : 50000 Database name : testing _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list