[tuigwaa-user:76] Re: インストール失敗？

2006年 5月 26日 (金) 09:51:52 JST

染田です。

以下、PostgreSQL 8.1 での以下の変更 (add_missing_from) と、

http://www.sraoss.co.jp/PostgreSQL/8.1/changes.html

Slide の PostgresRDBMSAdapter との組み合わせで
発生します。

ご利用の postmaster.conf 内で、

  add_missing_from = on

を設定頂ければ回避することが可能です。

尚、Tuigwaa 0.9 においては、Slide のコンテンツ管理部分を
DB -> ファイルへと変更しますので、これ以降の
バージョンでは、Slide の DB 対応依存部分がなくなります。

よろしくお願い致します。

染田

Yuumi Yoshida wrote:
> こんばんは、Yuumi3 です。
> 
> tuigwaa をインストールしていますが、初期化でエラーになっています。
> 
> catalina.out に以下のようなエラーが出ています。どうしたらよいでしょうか？
> 
> 環境
>  OS: CentOS-3.5
>  JDK: 1.4.2_09
>  Tomcat: 5.5.15 + JDK 1.4 Compatability Package
>  RDB: PostgreSQL 8.1.3
>  JDBC: postgresql-8.1-404.jdbc3.jar
> 
> ...
> 25 May 2006 15:54:34 - org.apache.slide.common.Namespace - INFO - Import
> data into namespace slide
> 25 May 2006 15:54:34 - org.apache.slide.common.XMLUnmarshaller - INFO -
> Loading object /
> 25 May 2006 15:54:34 - org.apache.slide.common.XMLUnmarshaller - INFO -
> Object already exists at /
> 25 May 2006 15:54:35 -
> org.apache.slide.store.impl.rdbms.PostgresRDBMSAdapter - ERROR -
> org.postgresql.util.PSQLException: ERROR: missing FROM-clause entry for
> table "version_history"
> org.postgresql.util.PSQLException: ERROR: missing FROM-clause entry for
> table "version_history"
>         at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
>         at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
>         at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
>         at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)
>         at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346)
>         at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:300)
>         at
> org.apache.slide.store.impl.rdbms.PostgresRDBMSAdapter.removeRevisionDescriptor(PostgresRDBMSAdapter.java:172)
>         at
> org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeRevisionDescriptor(StandardRDBMSAdapter.java:1252)
>         at
> org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.storeRevisionDescriptor(AbstractRDBMSStore.java:759)
>         at
> org.apache.slide.store.AbstractStore.storeRevisionDescriptor(AbstractStore.java:1219)
>         at
> org.apache.slide.store.ExtendedStore.storeRevisionDescriptor(ExtendedStore.java:912)
>         at org.apache.slide.content.ContentImpl.store(ContentImpl.java:1033)
>         at
> org.apache.slide.common.XMLUnmarshaller.loadObjectRevision(XMLUnmarshaller.java:390)
>         at
> org.apache.slide.common.XMLUnmarshaller.loadDefaultObjectRevision(XMLUnmarshaller.java:307)
>         at
> org.apache.slide.common.XMLUnmarshaller.loadObjectNode(XMLUnmarshaller.java:237)
>         at
> org.apache.slide.common.XMLUnmarshaller.unmarshal(XMLUnmarshaller.java:90)
>         at
> org.apache.slide.common.NamespaceAccessTokenImpl.importData(NamespaceAccessTokenImpl.java:272)
>         at
> org.apache.slide.common.Namespace.loadBaseData(Namespace.java:808)
>         at org.apache.slide.common.Domain.initNamespace(Domain.java:845)
>         at org.apache.slide.common.Domain.init(Domain.java:432)
>         at org.apache.slide.common.Domain.init(Domain.java:366)
>         at
> com.isenshi.tuigwaa.cms.ContentsStoreServiceSlideImpl.<init>(ContentsStoreServiceSlideImpl.java:102)
>         at
> com.isenshi.tuigwaa.cms.ContentsStoreServiceSlideImpl$$EnhancedByS2AOP$$109dc35.<init>(ContentsStoreServiceSlideImpl$$EnhancedByS2AOP$$109dc35.java)
>         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
>         at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>         at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>         at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
>         at
> org.seasar.framework.util.ConstructorUtil.newInstance(ConstructorUtil.java:29)
>         at
> org.seasar.framework.container.assembler.AbstractConstructorAssembler.assembleDefault(AbstractConstructorAssembler.java:23)
>         at
> org.seasar.framework.container.assembler.AutoConstructorAssembler.assemble(AutoConstructorAssembler.java:27)
>         at
> org.seasar.framework.container.deployer.SingletonComponentDeployer.assemble(SingletonComponentDeployer.java:43)
>         at
> org.seasar.framework.container.deployer.SingletonComponentDeployer.deploy(SingletonComponentDeployer.java:27)
>         at
> org.seasar.framework.container.impl.ComponentDefImpl.getComponent(ComponentDefImpl.java:75)
>         at
> org.seasar.framework.container.impl.S2ContainerImpl.getComponent(S2ContainerImpl.java:89)
>         at
> org.seasar.framework.container.assembler.AbstractAssembler.getArgs(AbstractAssembler.java:50)
>         at
> org.seasar.framework.container.assembler.AutoConstructorAssembler.assemble(AutoConstructorAssembler.java:29)
>         at
> org.seasar.framework.container.deployer.SingletonComponentDeployer.assemble(SingletonComponentDeployer.java:43)
>         at
> org.seasar.framework.container.deployer.SingletonComponentDeployer.deploy(SingletonComponentDeployer.java:27)
>         at
> org.seasar.framework.container.deployer.SingletonComponentDeployer.init(SingletonComponentDeployer.java:55)
>         at
> org.seasar.framework.container.impl.ComponentDefImpl.init(ComponentDefImpl.java:249)
>         at
> org.seasar.framework.container.impl.S2ContainerImpl.init(S2ContainerImpl.java:344)
>         at
> org.seasar.framework.container.impl.S2ContainerImpl.init(S2ContainerImpl.java:341)
>         at
> org.seasar.framework.container.factory.SingletonS2ContainerFactory.init(SingletonS2ContainerFactory.java:36)
>         at
> org.seasar.framework.container.servlet.S2ContainerServlet.init(S2ContainerServlet.java:47)
>         at
> org.seasar.struts.servlet.S2StrutsServlet.init(S2StrutsServlet.java:22)
>         at javax.servlet.GenericServlet.init(GenericServlet.java:211)
>         at
> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1105)
>         at
> org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:932)
>         at
> org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3915)
>         at
> org.apache.catalina.core.StandardContext.start(StandardContext.java:4176)
>         at
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
>         at
> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
>         at
> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
>         at
> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:603)
>         at
> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535)
>         at
> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470)
>         at
> org.apache.catalina.startup.HostConfig.start(HostConfig.java:1118)
>         at
> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
>         at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
>         at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
>         at
> org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
>         at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
>         at
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
>         at
> org.apache.catalina.core.StandardService.start(StandardService.java:450)
>         at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
>         at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
>         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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:275)
>         at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
> org.apache.slide.common.ServiceAccessException: Service
> com.isenshi.util.extlib.S2Store ＠ 1123eb0 access error : ERROR: missing
> FROM-clause entry for table "version_history"
>         at
> org.apache.slide.store.impl.rdbms.PostgresRDBMSAdapter.removeRevisionDescriptor(PostgresRDBMSAdapter.java:188)
>         at
> org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeRevisionDescriptor(StandardRDBMSAdapter.java:1252)
>         at
> org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.storeRevisionDescriptor(AbstractRDBMSStore.java:759)
>         at
> org.apache.slide.store.AbstractStore.storeRevisionDescriptor(AbstractStore.java:1219)
>         at
> org.apache.slide.store.ExtendedStore.storeRevisionDescriptor(ExtendedStore.java:912)
>         at org.apache.slide.content.ContentImpl.store(ContentImpl.java:1033)
>         at
> org.apache.slide.common.XMLUnmarshaller.loadObjectRevision(XMLUnmarshaller.java:390)
>         at
> org.apache.slide.common.XMLUnmarshaller.loadDefaultObjectRevision(XMLUnmarshaller.java:307)
>         at
> org.apache.slide.common.XMLUnmarshaller.loadObjectNode(XMLUnmarshaller.java:237)
>         at
> org.apache.slide.common.XMLUnmarshaller.unmarshal(XMLUnmarshaller.java:90)
>         at
> org.apache.slide.common.NamespaceAccessTokenImpl.importData(NamespaceAccessTokenImpl.java:272)
>         at
> org.apache.slide.common.Namespace.loadBaseData(Namespace.java:808)
>         at org.apache.slide.common.Domain.initNamespace(Domain.java:845)
>         at org.apache.slide.common.Domain.init(Domain.java:432)
>         at org.apache.slide.common.Domain.init(Domain.java:366)
>         at
> com.isenshi.tuigwaa.cms.ContentsStoreServiceSlideImpl.<init>(ContentsStoreServiceSlideImpl.java:102)
> 


-- 
SOMEDA Takashi (takashi.someda ＠ gmail.com)
http://tuigwaa.sandbox.seasar.org/