Postgres related issues with CVS from 7/28
cuoz Jul 29, 2004 11:33 AMI 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)
----------------------------------------------------------