2 Replies Latest reply on Jul 30, 2004 10:49 AM by Gary Cuozzo

    Postgres related issues with CVS from 7/28

    Gary Cuozzo Newbie

      I FINALLY got some time to get back to playing with nukes. I'm running on Debian linux with Postgresql. I installed yesterday's snapshot and had some minor issues during install.

      I'll let you know if I find any issues during actual testing. These were just installation related.

      Also, I found that for a few modules I had to run the setup.ddl files first (adminmessages, poll). I had thought these were converted to be done via CMP, but maybe I'm wrong about that.

      Cheers,
      gary.


      Here's the first, I'm not sure about what actually was being done here, but the system seems to operate so far:
      ------------------------------------------------------------------------
      09:25:42,936 INFO [html] Start indexing
      09:25:43,319 ERROR [DocumentIterator]
      java.sql.SQLException: ERROR: Unable to identify an operator '=' for types 'boolean' and 'integer'
      You will have to retype this query using an explicit cast

      at org.postgresql.core.QueryExecutor.execute(Unknown Source)
      at org.postgresql.Connection.ExecSQL(Unknown Source)
      at org.postgresql.jdbc2.Statement.execute(Unknown Source)
      at org.postgresql.jdbc2.Statement.executeQuery(Unknown Source)
      at org.postgresql.jdbc2.PreparedStatement.executeQuery(Unknown Source)
      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:304)
      at org.jboss.nukes.core.modules.index.DocumentIterator.(DocumentIterator.java:52)
      at org.jboss.nukes.core.modules.html.HtmlModule$5.(HtmlModule.java:1391)
      at org.jboss.nukes.core.modules.html.HtmlModule.documents(HtmlModule.java:1381)
      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:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.interceptor.ObjectReferenceInterceptor.invoke(ObjectReferenceInterceptor.java:59)
      at org.jboss.mx.interceptor.MBeanAttributeInterceptor.invoke(MBeanAttributeInterceptor.java:43)
      at org.jboss.mx.interceptor.PersistenceInterceptor2.invoke(PersistenceInterceptor2.java:93)
      at org.jboss.nukes.mx.LifeCycleInterceptor.invoke(LifeCycleInterceptor.java:93)
      at org.jboss.mx.server.MBeanInvoker.invoke(MBeanInvoker.java:76)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
      at org.jboss.mx.util.JMXInvocationHandler.invoke(JMXInvocationHandler.java:177)
      at $Proxy61.documents(Unknown Source)
      at org.jboss.nukes.core.modules.index.Index$IndexingTask.run(Index.java:643)
      at org.jboss.nukes.core.modules.index.Index$WriterTask.run(Index.java:538)
      at EDU.oswego.cs.dl.util.concurrent.QueuedExecutor$RunLoop.run(QueuedExecutor.java:88)
      at java.lang.Thread.run(Thread.java:534)
      09:25:43,358 INFO [html] Indexing finished, time elapsed : 0.0 sec
      ---------------------------------------------------------------------


      This next one was fixed by re-running the query and replacing a 0 with FALSE for the 'prune_enable' field with boolean type. I'm not sure where this code is, but it should be an easy fix
      ----------------------------------------------------------------------
      09:44:13,888 WARN [ForumEJB] Issuing sql INSERT INTO phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status,
      forum_order,forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read,auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote,auth_pollcreate, auth_attachments) VALUES (0,0,'My forum','This is a sample forum',0,10,0,0,NULL,NULL,0,0,0,1,1,1,1,3,3,3,3,0); failed: java.sql.SQLException: ERROR: column "prune_enable" is of type 'boolean' but expression is of type 'integer'
      You will need to rewrite or cast the expression

      09:44:13,891 ERROR [EntityContainer] Starting failed
      org.jboss.deployment.DeploymentException: Error while issuing sql in post-table-create; - nested throwable: (java.sql.SQLException: ERROR: column "prune_enable" is of type 'boolean' but expression is of type 'integer'
      You will need to rewrite or cast the expression
      )
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.issuePostCreateSQL(JDBCStartCommand.java:392)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:110)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:484)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:388)
      at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:152)
      at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:342)
      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
      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:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976)
      at $Proxy14.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:394)
      at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      ----------------------------------------------------------

        • 1. Re: Postgres related issues with CVS from 7/28
          jae Master

          only the modules that are part of the 1.1 release have been converted to pure cmp. the rest will follow as they are "re-released".

          • 2. Re: Postgres related issues with CVS from 7/28
            Gary Cuozzo Newbie

            Found a bug related to posting a comment to a news article.
            -----------------------------------------------------------------------------
            05:33:53,598 ERROR [LogInterceptor] TransactionRolledbackLocalException in method: public abstract org.jboss.nukes.addons.modules.news.ejb.CommentEJBLocal org.jboss.nukes.addons.modules.news.ejb.CommentEJBLocalHome.create(org.jboss.nukes.addons.modules.news.model.Comment,org.jboss.nukes.addons.modules.news.ejb.StoryEJBLocal,org.jboss.nukes.addons.modules.news.ejb.CommentEJBLocal,org.jboss.nukes.core.ejb.UserEJBLocal) throws javax.ejb.CreateException, causedBy:
            java.sql.SQLException: ERROR: pg_aclcheck: class "nuke_news_comments_comment_id_s" not found

            at org.postgresql.core.QueryExecutor.execute(Unknown Source)
            at org.postgresql.Connection.ExecSQL(Unknown Source)
            at org.postgresql.jdbc2.Statement.execute(Unknown Source)
            at org.postgresql.jdbc2.Statement.executeQuery(Unknown Source)
            at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:241)
            at org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCPostgreSQLCreateCommand.executeInsert(JDBCPostgreSQLCreateCommand.java:69)
            at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.performInsert(JDBCAbstractCreateCommand.java:287)
            at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:138)
            at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:554)
            at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:208)
            at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:269)
            at org.jboss.ejb.EntityContainer.createLocalHome(EntityContainer.java:581)
            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:324)
            at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1043)
            at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
            at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:197)
            at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:214) at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
            at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:89)
            at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61)
            at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28)
            at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88)
            at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
            at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:98)
            at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92)
            at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
            at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
            at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:483)
            at org.jboss.ejb.Container.invoke(Container.java:720)
            at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:293)
            at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
            at $Proxy179.create(Unknown Source)
            at org.jboss.nukes.addons.modules.news.utils.NewsDAO.createComment(NewsDAO.java:113)
            at org.jboss.nukes.addons.modules.news.NewsModule.commentshandlecomment(NewsModule.java:209)
            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:324)
            at org.jboss.nukes.module.ModuleSupport.operation(ModuleSupport.java:117)
            at org.jboss.nukes.module.ModuleSupport.process(ModuleSupport.java:91)
            at sun.reflect.GeneratedMethodAccessor245.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
            at org.jboss.mx.interceptor.ObjectReferenceInterceptor.invoke(ObjectReferenceInterceptor.java:59)
            at org.jboss.mx.interceptor.MBeanAttributeInterceptor.invoke(MBeanAttributeInterceptor.java:43)
            at org.jboss.mx.interceptor.PersistenceInterceptor2.invoke(PersistenceInterceptor2.java:93)
            at org.jboss.nukes.mx.LifeCycleInterceptor.invoke(LifeCycleInterceptor.java:93)
            at org.jboss.mx.server.MBeanInvoker.invoke(MBeanInvoker.java:76)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
            at org.jboss.nukes.core.Main$LastNext.process(Main.java:557)
            at org.jboss.nukes.core.modules.html.HtmlModule$1.process(HtmlModule.java:259)
            at org.jboss.nukes.core.Main$HandlerNext.process(Main.java:508)
            at org.jboss.nukes.core.modules.core.CoreModule$3.process(CoreModule.java:404)
            at org.jboss.nukes.core.Main$HandlerNext.process(Main.java:508)
            at org.jboss.nukes.core.modules.block.BlockModule$3.process(BlockModule.java:810)
            at org.jboss.nukes.core.Main$HandlerNext.process(Main.java:508)
            at org.jboss.nukes.core.modules.theme.ThemeModule$2.process(ThemeModule.java:255)
            at org.jboss.nukes.core.Main$HandlerNext.process(Main.java:508)
            at org.jboss.nukes.core.modules.user.UserModule$4.process(UserModule.java:1487)
            at org.jboss.nukes.core.Main$HandlerNext.process(Main.java:508)
            at org.jboss.nukes.core.Main.process(Main.java:119)
            at sun.reflect.GeneratedMethodAccessor48.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
            at org.jboss.nukes.servlet.NukeServlet.doGet(NukeServlet.java:175)
            at org.jboss.nukes.servlet.NukeServlet.doPost(NukeServlet.java:113)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
            at org.jboss.nukes.servlet.TransactionFilter.doFilter(TransactionFilter.java:95)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
            at org.jboss.nukes.servlet.FileUploadFilter.doFilter(FileUploadFilter.java:64)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
            at org.jboss.nukes.servlet.CompressFilter.doFilter(CompressFilter.java:77)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
            at org.jboss.nukes.servlet.ParameterEncodingFilter.doFilter(ParameterEncodingFilter.java:60)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
            at org.jboss.nukes.servlet.DatabasePollerFilter.doFilter(DatabasePollerFilter.java:88)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
            at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
            at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
            at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
            at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
            at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
            at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)

            -----------------------------------------------------------------------------