java.lang.IllegalStateException: MonetDB.ERROR_COUL - MonetDB failed to shutdown.

Pentaho BI Platform Tracking | Sean Flatley | 4 years ago
  1. 0

    To repro: - Start spoon and get to where the Data Integration perspective is displaying the Welcome screen. - Close Spoon by clicking the Windows "Close Window" widget. The following exception is thrown: ERROR 02-10 16:28:49,225 - unable to read properties from /home/sflatley/.kettle/instaview/dbfarm: No such file or directory ERROR 02-10 16:28:49,225 - InstaService.ERROR_COUL - Could not stop MonetDB. java.lang.IllegalStateException: MonetDB.ERROR_COUL - MonetDB failed to shutdown. at org.pentaho.agilebi.insta.MonetDbUtil.stop(MonetDbUtil.java:233) at org.pentaho.agilebi.insta.InstaviewLifecycleListener.unLoaded(InstaviewLifecycleListener.java:56) at org.pentaho.platform.plugin.services.pluginmgr.PlatformPlugin.unLoaded(PlatformPlugin.java:201) at org.pentaho.platform.plugin.services.pluginmgr.DefaultPluginManager.unloadPlugins(DefaultPluginManager.java:88) at org.pentaho.platform.plugin.services.pluginmgr.DefaultPluginManager.unloadAllPlugins(DefaultPluginManager.java:515) at org.pentaho.platform.plugin.services.pluginmgr.PluginAdapter.shutdown(PluginAdapter.java:49) at org.pentaho.platform.engine.core.system.PentahoSystem.shutdown(PentahoSystem.java:793) at org.pentaho.platform.web.http.context.SolutionContextListener.contextDestroyed(SolutionContextListener.java:215) at org.mortbay.jetty.handler.ContextHandler.doStop(ContextHandler.java:599) at org.mortbay.jetty.webapp.WebAppContext.doStop(WebAppContext.java:505) at org.mortbay.component.AbstractLifeCycle.stop(AbstractLifeCycle.java:76) at org.mortbay.jetty.handler.HandlerCollection.doStop(HandlerCollection.java:169) at org.mortbay.component.AbstractLifeCycle.stop(AbstractLifeCycle.java:76) at org.mortbay.jetty.handler.HandlerWrapper.doStop(HandlerWrapper.java:142) at org.mortbay.jetty.Server.doStop(Server.java:283) at org.mortbay.component.AbstractLifeCycle.stop(AbstractLifeCycle.java:76) at org.pentaho.agilebi.platform.JettyServer.stopServer(JettyServer.java:86) at org.pentaho.di.core.lifecycle.pdi.AgileBILifecycleListener.onExit(AgileBILifecycleListener.java:104) at org.pentaho.di.core.lifecycle.LifecycleSupport.onExit(LifecycleSupport.java:70) at org.pentaho.di.ui.spoon.Spoon.quitFile(Spoon.java:4311) at org.pentaho.di.ui.spoon.Spoon.widgetDisposed(Spoon.java:8310) 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.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.release(Unknown Source) at org.eclipse.swt.widgets.Control.release(Unknown Source) at org.eclipse.swt.widgets.Widget.dispose(Unknown Source) at org.eclipse.swt.widgets.Shell.dispose(Unknown Source) at org.eclipse.jface.window.Window.close(Window.java:330) at org.eclipse.jface.window.ApplicationWindow.close(ApplicationWindow.java:306) at org.eclipse.jface.window.Window.handleShellCloseEvent(Window.java:736) at org.eclipse.jface.window.Window$3.shellClosed(Window.java:682) 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.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Shell.closeWidget(Unknown Source) at org.eclipse.swt.widgets.Shell.gtk_delete_event(Unknown Source) at org.eclipse.swt.widgets.Widget.windowProc(Unknown Source) at org.eclipse.swt.widgets.Control.windowProc(Unknown Source) at org.eclipse.swt.widgets.Display.windowProc(Unknown Source) at org.eclipse.swt.internal.gtk.OS._gtk_main_do_event(Native Method) at org.eclipse.swt.internal.gtk.OS.gtk_main_do_event(Unknown Source) at org.eclipse.swt.widgets.Display.eventProc(Unknown Source) at org.eclipse.swt.internal.gtk.OS._g_main_context_iteration(Native Method) at org.eclipse.swt.internal.gtk.OS.g_main_context_iteration(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:8298) 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)

    Pentaho BI Platform Tracking | 4 years ago | Sean Flatley
    java.lang.IllegalStateException: MonetDB.ERROR_COUL - MonetDB failed to shutdown.
  2. 0

    To repro: - Start spoon and get to where the Data Integration perspective is displaying the Welcome screen. - Close Spoon by clicking the Windows "Close Window" widget. The following exception is thrown: ERROR 02-10 16:28:49,225 - unable to read properties from /home/sflatley/.kettle/instaview/dbfarm: No such file or directory ERROR 02-10 16:28:49,225 - InstaService.ERROR_COUL - Could not stop MonetDB. java.lang.IllegalStateException: MonetDB.ERROR_COUL - MonetDB failed to shutdown. at org.pentaho.agilebi.insta.MonetDbUtil.stop(MonetDbUtil.java:233) at org.pentaho.agilebi.insta.InstaviewLifecycleListener.unLoaded(InstaviewLifecycleListener.java:56) at org.pentaho.platform.plugin.services.pluginmgr.PlatformPlugin.unLoaded(PlatformPlugin.java:201) at org.pentaho.platform.plugin.services.pluginmgr.DefaultPluginManager.unloadPlugins(DefaultPluginManager.java:88) at org.pentaho.platform.plugin.services.pluginmgr.DefaultPluginManager.unloadAllPlugins(DefaultPluginManager.java:515) at org.pentaho.platform.plugin.services.pluginmgr.PluginAdapter.shutdown(PluginAdapter.java:49) at org.pentaho.platform.engine.core.system.PentahoSystem.shutdown(PentahoSystem.java:793) at org.pentaho.platform.web.http.context.SolutionContextListener.contextDestroyed(SolutionContextListener.java:215) at org.mortbay.jetty.handler.ContextHandler.doStop(ContextHandler.java:599) at org.mortbay.jetty.webapp.WebAppContext.doStop(WebAppContext.java:505) at org.mortbay.component.AbstractLifeCycle.stop(AbstractLifeCycle.java:76) at org.mortbay.jetty.handler.HandlerCollection.doStop(HandlerCollection.java:169) at org.mortbay.component.AbstractLifeCycle.stop(AbstractLifeCycle.java:76) at org.mortbay.jetty.handler.HandlerWrapper.doStop(HandlerWrapper.java:142) at org.mortbay.jetty.Server.doStop(Server.java:283) at org.mortbay.component.AbstractLifeCycle.stop(AbstractLifeCycle.java:76) at org.pentaho.agilebi.platform.JettyServer.stopServer(JettyServer.java:86) at org.pentaho.di.core.lifecycle.pdi.AgileBILifecycleListener.onExit(AgileBILifecycleListener.java:104) at org.pentaho.di.core.lifecycle.LifecycleSupport.onExit(LifecycleSupport.java:70) at org.pentaho.di.ui.spoon.Spoon.quitFile(Spoon.java:4311) at org.pentaho.di.ui.spoon.Spoon.widgetDisposed(Spoon.java:8310) 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.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.release(Unknown Source) at org.eclipse.swt.widgets.Control.release(Unknown Source) at org.eclipse.swt.widgets.Widget.dispose(Unknown Source) at org.eclipse.swt.widgets.Shell.dispose(Unknown Source) at org.eclipse.jface.window.Window.close(Window.java:330) at org.eclipse.jface.window.ApplicationWindow.close(ApplicationWindow.java:306) at org.eclipse.jface.window.Window.handleShellCloseEvent(Window.java:736) at org.eclipse.jface.window.Window$3.shellClosed(Window.java:682) 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.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Shell.closeWidget(Unknown Source) at org.eclipse.swt.widgets.Shell.gtk_delete_event(Unknown Source) at org.eclipse.swt.widgets.Widget.windowProc(Unknown Source) at org.eclipse.swt.widgets.Control.windowProc(Unknown Source) at org.eclipse.swt.widgets.Display.windowProc(Unknown Source) at org.eclipse.swt.internal.gtk.OS._gtk_main_do_event(Native Method) at org.eclipse.swt.internal.gtk.OS.gtk_main_do_event(Unknown Source) at org.eclipse.swt.widgets.Display.eventProc(Unknown Source) at org.eclipse.swt.internal.gtk.OS._g_main_context_iteration(Native Method) at org.eclipse.swt.internal.gtk.OS.g_main_context_iteration(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:8298) 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)

    Pentaho BI Platform Tracking | 4 years ago | Sean Flatley
    java.lang.IllegalStateException: MonetDB.ERROR_COUL - MonetDB failed to shutdown.
  3. 0

    To reproduce - create an instaview. Example of how to create: - Open Spoon - Create a new instaview - Choose the "Local File" / "CSV" template - Use the customer-100.txt sample data file as inpu.t. Change the delimiter to a a semicolon - Click close on the "document scan dialog" - Click ok on the step dialog - Click "Close" in the Instaview perspective. - Click "Don't save" - From the Instaview start page quickly create a new instaview clicking through the wizard quickly to get to the step dialog. It appears that MonetDB is not completely shut down when the restart happens. This appears in the Spoon console: RROR 04-10 15:49:58,632 - directory is already initialised: /home/sflatley/.kettle/instaview/dbfarm another monetdbd is already running monetdb: cannot find a control socket, use -h and/or -p monetdb: cannot find a control socket, use -h and/or -p monetdb: cannot find a control socket, use -h and/or -p ERROR 04-10 14:37:06,701 - InstaService.ERROR_COUL - Could not start MonetDB. java.lang.IllegalStateException: MonetDB.ERROR_COUL - MonetDB could not start. at org.pentaho.agilebi.insta.MonetDbUtil.start(MonetDbUtil.java:203) at org.pentaho.agilebi.insta.InstaService.beforeProjectOpen(InstaService.java:2399) at org.pentaho.agilebi.insta.InstaService.beforeProjectOpenJson(InstaService.java:2390) at org.pentaho.agilebi.insta.InstaContentGenerator.beforeProjectOpen(InstaContentGenerator.java:152) at org.pentaho.agilebi.insta.InstaContentGenerator.createContent(InstaContentGenerator.java:134) at org.pentaho.platform.engine.services.solution.SimpleContentGenerator.createContent(SimpleContentGenerator.java:66) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261) at org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:80) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:142) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:108) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:322) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:536) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:930) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:405) at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) This exception appeared when I was in the "CSV" step dialog. I was able to use the dialog, i.e., I was not informed through the UI that there was an exceotion. When I clicked "OK" in the dialog an error dialog was displayed with " Could not adjust schema for table: instaview_20121004024804211". Spoon's console had: INFO 04-10 14:48:04,564 - Output - Exit Value of psql: 2 Util.updateMetadata writing AgileBI~$NULL$~instaview_20121004024804211 rowCount=-1 ERROR 04-10 14:48:04,575 - Output - An error occurred: Error occured while trying to connect to the database Error connecting to database: (using class nl.cwi.monetdb.jdbc.MonetDriver) Unable to connect (localhost:50000): Connection refused ERROR 04-10 14:48:04,583 - Output - Output from mclient: ERROR 04-10 14:48:04,584 - Output - Could not adjust schema for table: instaview_20121004024804211 ERROR 04-10 14:48:04,585 - Output - org.pentaho.di.core.exception.KettleException: An error occurred writing data to the mclient process An error occurred creating SQL statement at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoader.autoAdjustSchema(MonetDBBulkLoader.java:628) at org.pentaho.di.trans.steps.monetdbagilemart.MonetDBAgileMart.adjustSchema(MonetDBAgileMart.java:160) at org.pentaho.agilebi.insta.PdiRunnerBase.updateSchema(PdiRunnerBase.java:688) at org.pentaho.agilebi.insta.PdiRunner.run(PdiRunner.java:44) at org.eclipse.swt.widgets.RunnableLock.run(Unknown Source) at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Unknown Source) at org.eclipse.swt.widgets.Display.runAsyncMessages(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:8298) 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.KettleException: An error occurred creating SQL statement at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoader.autoAdjustSchema(MonetDBBulkLoader.java:595) ... 16 more ERROR 04-10 14:48:04,587 - PdiRunner.SCHEMA_UPDATE_FAILED - Could not adjust schema for table: /home/sflatley/pdi-ee-4.4.0-GA-oct-4/pdi-ee/data-integration/projects/Untitled 3/Untitled 3.ktr ERROR 04-10 14:48:04,590 - operation failed: MODE_UPDATE_SCHEMA

    Pentaho BI Platform Tracking | 4 years ago | Sean Flatley
    java.lang.IllegalStateException: MonetDB.ERROR_COUL - MonetDB could not start.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    To reproduce - create an instaview. Example of how to create: - Open Spoon - Create a new instaview - Choose the "Local File" / "CSV" template - Use the customer-100.txt sample data file as inpu.t. Change the delimiter to a a semicolon - Click close on the "document scan dialog" - Click ok on the step dialog - Click "Close" in the Instaview perspective. - Click "Don't save" - From the Instaview start page quickly create a new instaview clicking through the wizard quickly to get to the step dialog. It appears that MonetDB is not completely shut down when the restart happens. This appears in the Spoon console: RROR 04-10 15:49:58,632 - directory is already initialised: /home/sflatley/.kettle/instaview/dbfarm another monetdbd is already running monetdb: cannot find a control socket, use -h and/or -p monetdb: cannot find a control socket, use -h and/or -p monetdb: cannot find a control socket, use -h and/or -p ERROR 04-10 14:37:06,701 - InstaService.ERROR_COUL - Could not start MonetDB. java.lang.IllegalStateException: MonetDB.ERROR_COUL - MonetDB could not start. at org.pentaho.agilebi.insta.MonetDbUtil.start(MonetDbUtil.java:203) at org.pentaho.agilebi.insta.InstaService.beforeProjectOpen(InstaService.java:2399) at org.pentaho.agilebi.insta.InstaService.beforeProjectOpenJson(InstaService.java:2390) at org.pentaho.agilebi.insta.InstaContentGenerator.beforeProjectOpen(InstaContentGenerator.java:152) at org.pentaho.agilebi.insta.InstaContentGenerator.createContent(InstaContentGenerator.java:134) at org.pentaho.platform.engine.services.solution.SimpleContentGenerator.createContent(SimpleContentGenerator.java:66) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261) at org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:80) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:142) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:108) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:322) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:536) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:930) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:405) at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) This exception appeared when I was in the "CSV" step dialog. I was able to use the dialog, i.e., I was not informed through the UI that there was an exceotion. When I clicked "OK" in the dialog an error dialog was displayed with " Could not adjust schema for table: instaview_20121004024804211". Spoon's console had: INFO 04-10 14:48:04,564 - Output - Exit Value of psql: 2 Util.updateMetadata writing AgileBI~$NULL$~instaview_20121004024804211 rowCount=-1 ERROR 04-10 14:48:04,575 - Output - An error occurred: Error occured while trying to connect to the database Error connecting to database: (using class nl.cwi.monetdb.jdbc.MonetDriver) Unable to connect (localhost:50000): Connection refused ERROR 04-10 14:48:04,583 - Output - Output from mclient: ERROR 04-10 14:48:04,584 - Output - Could not adjust schema for table: instaview_20121004024804211 ERROR 04-10 14:48:04,585 - Output - org.pentaho.di.core.exception.KettleException: An error occurred writing data to the mclient process An error occurred creating SQL statement at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoader.autoAdjustSchema(MonetDBBulkLoader.java:628) at org.pentaho.di.trans.steps.monetdbagilemart.MonetDBAgileMart.adjustSchema(MonetDBAgileMart.java:160) at org.pentaho.agilebi.insta.PdiRunnerBase.updateSchema(PdiRunnerBase.java:688) at org.pentaho.agilebi.insta.PdiRunner.run(PdiRunner.java:44) at org.eclipse.swt.widgets.RunnableLock.run(Unknown Source) at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Unknown Source) at org.eclipse.swt.widgets.Display.runAsyncMessages(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:8298) 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.KettleException: An error occurred creating SQL statement at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoader.autoAdjustSchema(MonetDBBulkLoader.java:595) ... 16 more ERROR 04-10 14:48:04,587 - PdiRunner.SCHEMA_UPDATE_FAILED - Could not adjust schema for table: /home/sflatley/pdi-ee-4.4.0-GA-oct-4/pdi-ee/data-integration/projects/Untitled 3/Untitled 3.ktr ERROR 04-10 14:48:04,590 - operation failed: MODE_UPDATE_SCHEMA

    Pentaho BI Platform Tracking | 4 years ago | Sean Flatley
    java.lang.IllegalStateException: MonetDB.ERROR_COUL - MonetDB could not start.
  6. 0

    Karaf:Step by Step Guide - OpenDaylight Project

    opendaylight.org | 3 weeks ago
    java.lang.IllegalStateException: Error while copying old configuration from ModuleInternalInfo [name=ModuleIdentifier{factoryName='shutdown', instanceName='shutdown'}] to org.opendaylight.controller.config.yang.shutdown.impl.ShutdownModuleFactory@1ea5c8f6

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.lang.IllegalStateException

      MonetDB.ERROR_COUL - MonetDB failed to shutdown.

      at org.pentaho.agilebi.insta.MonetDbUtil.stop()
    2. org.pentaho.agilebi
      InstaviewLifecycleListener.unLoaded
      1. org.pentaho.agilebi.insta.MonetDbUtil.stop(MonetDbUtil.java:233)
      2. org.pentaho.agilebi.insta.InstaviewLifecycleListener.unLoaded(InstaviewLifecycleListener.java:56)
      2 frames
    3. org.pentaho.platform
      SolutionContextListener.contextDestroyed
      1. org.pentaho.platform.plugin.services.pluginmgr.PlatformPlugin.unLoaded(PlatformPlugin.java:201)
      2. org.pentaho.platform.plugin.services.pluginmgr.DefaultPluginManager.unloadPlugins(DefaultPluginManager.java:88)
      3. org.pentaho.platform.plugin.services.pluginmgr.DefaultPluginManager.unloadAllPlugins(DefaultPluginManager.java:515)
      4. org.pentaho.platform.plugin.services.pluginmgr.PluginAdapter.shutdown(PluginAdapter.java:49)
      5. org.pentaho.platform.engine.core.system.PentahoSystem.shutdown(PentahoSystem.java:793)
      6. org.pentaho.platform.web.http.context.SolutionContextListener.contextDestroyed(SolutionContextListener.java:215)
      6 frames
    4. Jetty Server
      WebAppContext.doStop
      1. org.mortbay.jetty.handler.ContextHandler.doStop(ContextHandler.java:599)
      2. org.mortbay.jetty.webapp.WebAppContext.doStop(WebAppContext.java:505)
      2 frames
    5. Jetty Util
      AbstractLifeCycle.stop
      1. org.mortbay.component.AbstractLifeCycle.stop(AbstractLifeCycle.java:76)
      1 frame
    6. Jetty Server
      HandlerCollection.doStop
      1. org.mortbay.jetty.handler.HandlerCollection.doStop(HandlerCollection.java:169)
      1 frame
    7. Jetty Util
      AbstractLifeCycle.stop
      1. org.mortbay.component.AbstractLifeCycle.stop(AbstractLifeCycle.java:76)
      1 frame
    8. Jetty Server
      Server.doStop
      1. org.mortbay.jetty.handler.HandlerWrapper.doStop(HandlerWrapper.java:142)
      2. org.mortbay.jetty.Server.doStop(Server.java:283)
      2 frames
    9. Jetty Util
      AbstractLifeCycle.stop
      1. org.mortbay.component.AbstractLifeCycle.stop(AbstractLifeCycle.java:76)
      1 frame
    10. org.pentaho.agilebi
      JettyServer.stopServer
      1. org.pentaho.agilebi.platform.JettyServer.stopServer(JettyServer.java:86)
      1 frame
    11. org.pentaho.di
      Spoon.widgetDisposed
      1. org.pentaho.di.core.lifecycle.pdi.AgileBILifecycleListener.onExit(AgileBILifecycleListener.java:104)
      2. org.pentaho.di.core.lifecycle.LifecycleSupport.onExit(LifecycleSupport.java:70)
      3. org.pentaho.di.ui.spoon.Spoon.quitFile(Spoon.java:4311)
      4. org.pentaho.di.ui.spoon.Spoon.widgetDisposed(Spoon.java:8310)
      4 frames
    12. RWT
      Shell.dispose
      1. org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
      2. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
      3. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
      4. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
      5. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
      6. org.eclipse.swt.widgets.Widget.release(Unknown Source)
      7. org.eclipse.swt.widgets.Control.release(Unknown Source)
      8. org.eclipse.swt.widgets.Widget.dispose(Unknown Source)
      9. org.eclipse.swt.widgets.Shell.dispose(Unknown Source)
      9 frames
    13. JFace
      Window$3.shellClosed
      1. org.eclipse.jface.window.Window.close(Window.java:330)
      2. org.eclipse.jface.window.ApplicationWindow.close(ApplicationWindow.java:306)
      3. org.eclipse.jface.window.Window.handleShellCloseEvent(Window.java:736)
      4. org.eclipse.jface.window.Window$3.shellClosed(Window.java:682)
      4 frames
    14. RWT
      Display.windowProc
      1. org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
      2. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
      3. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
      4. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
      5. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
      6. org.eclipse.swt.widgets.Shell.closeWidget(Unknown Source)
      7. org.eclipse.swt.widgets.Shell.gtk_delete_event(Unknown Source)
      8. org.eclipse.swt.widgets.Widget.windowProc(Unknown Source)
      9. org.eclipse.swt.widgets.Control.windowProc(Unknown Source)
      10. org.eclipse.swt.widgets.Display.windowProc(Unknown Source)
      10 frames
    15. org.eclipse.swt
      OS.gtk_main_do_event
      1. org.eclipse.swt.internal.gtk.OS._gtk_main_do_event(Native Method)
      2. org.eclipse.swt.internal.gtk.OS.gtk_main_do_event(Unknown Source)
      2 frames
    16. RWT
      Display.eventProc
      1. org.eclipse.swt.widgets.Display.eventProc(Unknown Source)
      1 frame
    17. org.eclipse.swt
      OS.g_main_context_iteration
      1. org.eclipse.swt.internal.gtk.OS._g_main_context_iteration(Native Method)
      2. org.eclipse.swt.internal.gtk.OS.g_main_context_iteration(Unknown Source)
      2 frames
    18. RWT
      Display.readAndDispatch
      1. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
      1 frame
    19. org.pentaho.di
      Spoon.main
      1. org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1221)
      2. org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7044)
      3. org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8298)
      4. org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:580)
      4 frames
    20. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    21. org.pentaho.commons
      Launcher.main
      1. org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
      1 frame