jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Debbie Troxel <dtro...@e-tractions.com>
Subject Re: Error with postgresql clustering
Date Thu, 06 Dec 2007 20:08:51 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<font face="Helvetica, Arial, sans-serif">Following up to my post, in
case anyone trying to set up </font><font
 face="Helvetica, Arial, sans-serif">Postgres clustering</font><font
 face="Helvetica, Arial, sans-serif"> lands on this thread.<br>
<br>
See:<br>
<a class="moz-txt-link-freetext" href="https://issues.apache.org/jira/browse/JCR-1174?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel">https://issues.apache.org/jira/browse/JCR-1174?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel</a><br>
<br>
Postgresql doesn't provide the varbinary type.&nbsp; Copy
org/apache/jackrabbit/core/journal/default.ddl to
org/apache/jackrabbit/core/journal/postgresql.ddl and change the
varbinary to bytea<br>
</font><br>
Debbie Troxel wrote:
<blockquote cite="mid:4755CFF5.5080102@e-tractions.com" type="cite"><font
 face="Helvetica, Arial, sans-serif">I'm running the 1.3.3
Resource Adapter under Glassfish on Linux.<br>
  <br>
The persistence managers for the repository and versioning are
connecting to Postgres.&nbsp; This seems to be working and I can
successfully run some simple tests.<br>
  <br>
When I try to add a Cluster config to the repository.xml, I get an
error (below) when the application server starts up.<br>
  <br>
Here is the Cluster config:<br>
  <br>
&nbsp;&nbsp;&nbsp; &lt;Cluster id="dbdev"&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;Journal
class="org.apache.jackrabbit.core.journal.DatabaseJournal"&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;param name="revision"
value="${rep.home}/revision.log" /&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;param name="driver"
value="org.postgresql.Driver" /&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;param name="url"
value="jdbc:postgresql://localhost:5432/XXX" /&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;param name="schema"
value="postgresql"/&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;param name="user"
value="XXX"/&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;param name="password"
value="XXX"/&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/Journal&gt;<br>
&nbsp;&nbsp;&nbsp; &lt;/Cluster&gt;<br>
  <br>
If I comment out the above, there are no errors on start up and
everything seems OK.&nbsp; The Journal db parameters are all the same as
what I use for the SimpleDBPersistenceManager, except there I also
provide the schemaObjectPrefix and set externalBlobs=false.&nbsp; <br>
  <br>
I am doing something obviously wrong?&nbsp; Is there a way to get more
detailed logging?&nbsp;&nbsp; Any suggestions?<br>
  <br>
Thanks very much for any help!<br>
Debbie&nbsp; <br>
  <br>
Error stack trace from server.log:<br>
  <br>
[#|2007-12-04T16:23:23.478-0500|SEVERE|sun-appserver-pe9.0|javax.enterprise.system.core.naming|_ThreadID=10;_ThreadName=main;_RequestID=db5fa69d-7e65-43b9-a42e-5b5946043a3b;|NAM0004:
Exception during name lookup : {0}<br>
javax.resource.ResourceException: Failed to create session: Unable to
initialize connection.<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.apache.jackrabbit.jca.JCAManagedConnectionFactory.createRepository(JCAManagedConnectionFactory.java:293)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.apache.jackrabbit.jca.JCAManagedConnectionFactory.createConnectionFactory(JCAManagedConnectionFactory.java:124)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.naming.factory.ConnectorObjectFactory.getObjectInstance(ConnectorObjectFactory.java:117)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.naming.SerialContext.lookup(SerialContext.java:314)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.naming.InitialContext.lookup(InitialContext.java:392)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.naming.NamingManagerImpl.bindObjects(NamingManagerImpl.java:369)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.web.WebContainer.loadWebModule(WebContainer.java:1451)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.web.WebContainer.loadStandaloneWebModule(WebContainer.java:973)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.web.WebContainer.loadWebModules(WebContainer.java:918)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.web.WebContainer.start(WebContainer.java:775)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.web.PEWebContainer.startInstance(PEWebContainer.java:722)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.web.PEWebContainerLifecycle.onStartup(PEWebContainerLifecycle.java:72)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ondemand.ServiceGroup.startLifecycleServices(ServiceGroup.java:266)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ondemand.WebServiceGroup.startLifecycleServices(WebServiceGroup.java:210)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ondemand.WebServiceGroup.start(WebServiceGroup.java:60)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ondemand.ServiceGroup$1.run(ServiceGroup.java:180)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ondemand.WebServiceGroup.start(WebServiceGroup.java:60)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ondemand.ServiceGroup$1.run(ServiceGroup.java:180)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.security.AccessController.doPrivileged(Native
Method)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ondemand.ServiceGroup.startChildren(ServiceGroup.java:177)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ondemand.MainServiceGroup.start(MainServiceGroup.java:45)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ondemand.ServerEntryListenerImpl.notifyEntry(ServerEntryListenerImpl.java:72)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ondemand.entry.ServerEntryHelper.sendEvent(ServerEntryHelper.java:62)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ondemand.entry.ServerEntryHelper.generateAppLoaderEntryContext(ServerEntryHelper.java:47)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.AbstractLoader.generateEntryContext(AbstractLoader.java:831)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.AbstractLoader.notifyAppEvent(AbstractLoader.java:837)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.DummyWebModuleLoader.load(DummyWebModuleLoader.java:62)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.AbstractManager.load(AbstractManager.java:206)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ApplicationLifecycle.onStartup(ApplicationLifecycle.java:201)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ApplicationServer.onStartup(ApplicationServer.java:326)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ondemand.OnDemandServer.onStartup(OnDemandServer.java:112)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sun.enterprise.server.PEMain.run(PEMain.java:326)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sun.enterprise.server.PEMain.main(PEMain.java:260)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:597)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sun.enterprise.server.PELaunch.main(PELaunch.java:272)<br>
|#]<br>
  <br>
[#|2007-12-04T16:23:23.487-0500|SEVERE|sun-appserver-pe9.0|javax.enterprise.system.core.naming|_ThreadID=10;_ThreadName=main;jcr/testRepository;_RequestID=db5fa69d-7e65-43b9-a42e-5b5946043a3b;|NAM0006:
JMS Destination object not found: jcr/testRepository|#]<br>
  <br>
[#|2007-12-04T16:23:23.489-0500|SEVERE|sun-appserver-pe9.0|javax.enterprise.system.core.naming|_ThreadID=10;_ThreadName=main;_RequestID=db5fa69d-7e65-43b9-a42e-5b5946043a3b;|javax.naming.CommunicationException<br>
javax.naming.CommunicationException: serial context communication ex
[Root exception is javax.resource.ResourceException: Failed to create
session: Unable to initialize connection.]<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.naming.SerialContext.lookup(SerialContext.java:338)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.naming.InitialContext.lookup(InitialContext.java:392)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.naming.NamingManagerImpl.bindObjects(NamingManagerImpl.java:369)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.web.WebContainer.loadWebModule(WebContainer.java:1451)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.web.WebContainer.loadStandaloneWebModule(WebContainer.java:973)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.web.WebContainer.loadWebModules(WebContainer.java:918)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.web.WebContainer.start(WebContainer.java:775)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.web.PEWebContainer.startInstance(PEWebContainer.java:722)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.web.PEWebContainerLifecycle.onStartup(PEWebContainerLifecycle.java:72)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ondemand.ServiceGroup.startLifecycleServices(ServiceGroup.java:266)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ondemand.WebServiceGroup.startLifecycleServices(WebServiceGroup.java:210)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ondemand.WebServiceGroup.start(WebServiceGroup.java:60)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ondemand.ServiceGroup$1.run(ServiceGroup.java:180)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.security.AccessController.doPrivileged(Native
Method)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ondemand.ServiceGroup.startChildren(ServiceGroup.java:177)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ondemand.MainServiceGroup.start(MainServiceGroup.java:45)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ondemand.ServerEntryListenerImpl.notifyEntry(ServerEntryListenerImpl.java:72)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ondemand.entry.ServerEntryHelper.sendEvent(ServerEntryHelper.java:62)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ondemand.entry.ServerEntryHelper.generateAppLoaderEntryContext(ServerEntryHelper.java:47)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.AbstractLoader.generateEntryContext(AbstractLoader.java:831)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ondemand.entry.ServerEntryHelper.generateAppLoaderEntryContext(ServerEntryHelper.java:47)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.AbstractLoader.generateEntryContext(AbstractLoader.java:831)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.AbstractLoader.notifyAppEvent(AbstractLoader.java:837)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.DummyWebModuleLoader.load(DummyWebModuleLoader.java:62)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.AbstractManager.load(AbstractManager.java:206)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ApplicationLifecycle.onStartup(ApplicationLifecycle.java:201)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ApplicationServer.onStartup(ApplicationServer.java:326)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.server.ondemand.OnDemandServer.onStartup(OnDemandServer.java:112)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sun.enterprise.server.PEMain.run(PEMain.java:326)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sun.enterprise.server.PEMain.main(PEMain.java:260)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:597)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sun.enterprise.server.PELaunch.main(PELaunch.java:272)<br>
Caused by: javax.resource.ResourceException: Failed to create session:
Unable to initialize connection.<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.apache.jackrabbit.jca.JCAManagedConnectionFactory.createRepository(JCAManagedConnectionFactory.java:293)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.apache.jackrabbit.jca.JCAManagedConnectionFactory.createConnectionFactory(JCAManagedConnectionFactory.java:124)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.naming.factory.ConnectorObjectFactory.getObjectInstance(ConnectorObjectFactory.java:117)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.sun.enterprise.naming.SerialContext.lookup(SerialContext.java:314)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ... 32 more<br>
  <br>
  <br>
  </font>
</blockquote>
</body>
</html>

Mime
View raw message