[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [JIRA-user] Startup problem with 2.6.1

To: jira-user@xxxxxxxxxxxxxxxxxxx,Owen Fellows <owen@xxxxxxxxxxxxx>
Subject: Re: [JIRA-user] Startup problem with 2.6.1
From: Joel Rosi-Schwartz <Joel.Rosi-Schwartz@xxxxxxxxx>
Date: Fri, 18 Jun 2004 03:00:24 +0100
Cc: mckoidb@xxxxxxxxx
Delivered-To: mailing list mckoidb@mckoi.com
In-Reply-To: <200406172220.46097.Joel.Rosi-Schwartz@Etish.org>
Mailing-List: contact mckoidb-help@mckoi.com; run by ezmlm
Organization: Etish Limited
References: <200406171212.15184.Joel.Rosi-Schwartz@Etish.org> <opr9q39shd0it12x@mail.atlassian.com> <200406172220.46097.Joel.Rosi-Schwartz@Etish.org>
User-Agent: KMail/1.5

Hi,

Having got past the previous problem, I now have run into a new breakdown. 
Just after Jira tries to create all of the tables to verify that they exist, 
I get the two exception that I do not understand. I have attached a trace 
below.

Cheers,
Joel

On Thursday 17 June 2004 22:20, Joel Rosi-Schwartz wrote:
> Owen,
>
> No, the database type in my entityengine.xml is set to mckoidb. The
> problem, it turns out, lies in the entitymodel.xml definitions. For several
> of your tables you have columns named "sequence". Mckoi treats the word
> SEQUENCE as a keyword and takes exception, quite literally I am afraid. I
> have added a col-name="vsequence" attribute to rename these columns. This
> clears up the problem. I actually fixed this up in 2.6.1 and I foregot
> about it since it was a year ago that I set it up. I found it by going back
> over my integration notes.
>
> I have attached a copy of my modified file for your reference.
>
> Cheers,
> Joel
>
> On Thursday 17 June 2004 19:28, Owen Fellows wrote:
> > Hi,
> >
> > Can you check that the entityengine.xml has the same field-type-name
> > specified for both the old and the new installation.  It appears that you
> > may have it still set to hsqldb and not mckoib.
> >
> > Let me know how you get on.
> > Owen
> >
> > On Thu, 17 Jun 2004 12:12:15 +0100, Joel Rosi-Schwartz
>
> <Joel.Rosi-Schwartz@Etish.org> wrote:
> > > Hi,
> > >
> > > I am doing preliminary testing toward upgrading to Professional 2.6.1.
> > > I am using the Mckoi database version 1.0.02 and I am getting SQL
> > > exceptions during startup that I do not experience against Jira 2.5.2.
> > > Essentially they are caused by the usage if "SEQUENCE NUMERIC" in the
> > > SQL creation scripts. It does not appear that this is supported in
> > > Mckoi.
> > >
> > > I would appreciated your advice on how to proceed.
> > >
> > > Cheers,
> > > Joel

[#|2004-06-18T02:41:46.328+0100|INFO|sun-appserver-pe8.0|javax.enterprise.system.stream.out|_ThreadID=10;|2004-06-18 02:41:46,328 ERROR [core.entity.jdbc.DatabaseUtil] Could not create table "versioncontrol"
|#]

[#|2004-06-18T02:41:46.328+0100|INFO|sun-appserver-pe8.0|javax.enterprise.system.stream.out|_ThreadID=10;|2004-06-18 02:41:46,328 ERROR [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
CREATE TABLE versioncontrol (ID NUMERIC(18,0) NOT NULL, vcsname VARCHAR(255), vcsdescription VARCHAR(255), vcstype VARCHAR(255), CONSTRAINT PK_versioncontrol PRIMARY KEY (ID))
Error was: com.mckoi.database.jdbc.MSQLException: Table 'APP.versioncontrol' already exists.
|#]

[#|2004-06-18T02:41:48.218+0100|INFO|sun-appserver-pe8.0|javax.enterprise.system.stream.out|_ThreadID=10;|[Filter: profiling] Using parameter [jira_profile]|#]

[#|2004-06-18T02:41:48.218+0100|INFO|sun-appserver-pe8.0|javax.enterprise.system.stream.out|_ThreadID=10;|
[Filter: profiling] defaulting to off [autostart=false]|#]

[#|2004-06-18T02:41:48.218+0100|INFO|sun-appserver-pe8.0|javax.enterprise.system.stream.out|_ThreadID=10;|
[Filter: profiling] Turning filter off [jira_profile=off]|#]

[#|2004-06-18T02:41:48.875+0100|INFO|sun-appserver-pe8.0|javax.enterprise.system.stream.out|_ThreadID=10;|
2004-06-18 02:41:48,875 ERROR [atlassian.seraph.service.WebworkService] Exception: com.sun.enterprise.InvocationException
com.sun.enterprise.InvocationException
	at com.sun.enterprise.resource.ResourceManagerImpl.getTransaction(ResourceManagerImpl.java:41)
	at com.sun.enterprise.resource.PoolManagerImpl.getResource(PoolManagerImpl.java:111)
	at com.sun.enterprise.connectors.ConnectionManagerImpl.internalGetConnection(ConnectionManagerImpl.java:197)
	at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:97)
	at com.sun.gjc.spi.DataSource.getConnection(DataSource.java:68)
	at org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:168)
	at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:140)
	at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:99)
	at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:53)
	at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:211)
	at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:283)
	at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1024)
	at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595)
	at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134)
	at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782)
	at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767)
	at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:744)
	at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.findPropertyEntry(OFBizPropertySet.java:223)
	at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.get(OFBizPropertySet.java:191)
	at com.opensymphony.module.propertyset.AbstractPropertySet.getString(AbstractPropertySet.java:373)
	at com.atlassian.jira.propertyset.JiraCachingPropertySet.getString(JiraCachingPropertySet.java:330)
	at com.atlassian.jira.config.properties.ApplicationProperties.getString(ApplicationProperties.java:70)
	at com.atlassian.jira.config.webwork.ApplicationPropertiesConfiguration.getImpl(ApplicationPropertiesConfiguration.java:29)
	at webwork.config.DelegatingConfiguration.getImpl(DelegatingConfiguration.java:43)
	at com.atlassian.jira.config.webwork.JiraConfiguration.getImpl(JiraConfiguration.java:38)
	at webwork.config.Configuration.get(Configuration.java:42)
	at com.atlassian.seraph.service.WebworkService.configureActionMapper(WebworkService.java:71)
	at com.atlassian.seraph.service.WebworkService.init(WebworkService.java:59)
	at com.atlassian.seraph.config.SecurityConfig.configureServices(SecurityConfig.java:203)
	at com.atlassian.seraph.config.SecurityConfig.init(SecurityConfig.java:86)
	at com.atlassian.seraph.config.SecurityConfig.<init>(SecurityConfig.java:62)
	at com.atlassian.seraph.config.SecurityConfig.getInstance(SecurityConfig.java:319)
	at com.atlassian.seraph.filter.SecurityFilter.init(SecurityFilter.java:46)
	at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:276)
	at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:359)
	at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:130)
	at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:3550)
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4146)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1132)
	at org.apache.catalina.core.StandardHost.start(StandardHost.java:803)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1132)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:510)
	at org.apache.catalina.startup.Embedded.start(Embedded.java:1030)
	at com.sun.enterprise.web.WebContainer.start(WebContainer.java:490)
	at com.sun.enterprise.web.PEWebContainer.startInstance(PEWebContainer.java:506)
	at com.sun.enterprise.web.PEWebContainerLifecycle.onStartup(PEWebContainerLifecycle.java:54)
	at com.sun.enterprise.server.ApplicationServer.onStartup(ApplicationServer.java:295)
	at com.sun.enterprise.server.PEMain.run(PEMain.java:220)
	at com.sun.enterprise.server.PEMain.main(PEMain.java:172)
	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.commons.launcher.ChildMain.run(ChildMain.java:269)
|#]

[#|2004-06-18T02:41:48.875+0100|INFO|sun-appserver-pe8.0|javax.enterprise.system.stream.out|_ThreadID=10;|2004-06-18 02:41:48,875 ERROR [atlassian.seraph.service.WebworkService] Exception: com.sun.enterprise.InvocationException
com.sun.enterprise.InvocationException
	at com.sun.enterprise.resource.ResourceManagerImpl.getTransaction(ResourceManagerImpl.java:41)
	at com.sun.enterprise.resource.PoolManagerImpl.getResource(PoolManagerImpl.java:111)
	at com.sun.enterprise.connectors.ConnectionManagerImpl.internalGetConnection(ConnectionManagerImpl.java:197)
	at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:97)
	at com.sun.gjc.spi.DataSource.getConnection(DataSource.java:68)
	at org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:168)
	at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:140)
	at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:99)
	at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:53)
	at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:211)
	at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:283)
	at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1024)
	at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595)
	at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134)
	at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782)
	at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767)
	at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:744)
	at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.findPropertyEntry(OFBizPropertySet.java:223)
	at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.get(OFBizPropertySet.java:191)
	at com.opensymphony.module.propertyset.AbstractPropertySet.getString(AbstractPropertySet.java:373)
	at com.atlassian.jira.propertyset.JiraCachingPropertySet.getString(JiraCachingPropertySet.java:330)
	at com.atlassian.jira.config.properties.ApplicationProperties.getString(ApplicationProperties.java:70)
	at com.atlassian.jira.config.webwork.ApplicationPropertiesConfiguration.getImpl(ApplicationPropertiesConfiguration.java:29)
	at webwork.config.DelegatingConfiguration.getImpl(DelegatingConfiguration.java:43)
	at com.atlassian.jira.config.webwork.JiraConfiguration.getImpl(JiraConfiguration.java:38)
	at webwork.config.Configuration.get(Configuration.java:42)
	at com.atlassian.seraph.service.WebworkService.configureActionMapper(WebworkService.java:71)
	at com.atlassian.seraph.service.WebworkService.init(WebworkService.java:59)
	at com.atlassian.seraph.config.SecurityConfig.configureServices(SecurityConfig.java:203)
	at com.atlassian.seraph.config.SecurityConfig.init(SecurityConfig.java:86)
	at com.atlassian.seraph.config.SecurityConfig.<init>(SecurityConfig.java:62)
	at com.atlassian.seraph.config.SecurityConfig.getInstance(SecurityConfig.java:319)
	at com.atlassian.seraph.filter.SecurityFilter.init(SecurityFilter.java:46)
	at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:276)
	at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:359)
	at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:130)
	at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:3550)
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4146)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1132)
	at org.apache.catalina.core.StandardHost.start(StandardHost.java:803)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1132)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:510)
	at org.apache.catalina.startup.Embedded.start(Embedded.java:1030)
	at com.sun.enterprise.web.WebContainer.start(WebContainer.java:490)
	at com.sun.enterprise.web.PEWebContainer.startInstance(PEWebContainer.java:506)
	at com.sun.enterprise.web.PEWebContainerLifecycle.onStartup(PEWebContainerLifecycle.java:54)
	at com.sun.enterprise.server.ApplicationServer.onStartup(ApplicationServer.java:295)
	at com.sun.enterprise.server.PEMain.run(PEMain.java:220)
	at com.sun.enterprise.server.PEMain.main(PEMain.java:172)
	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.commons.launcher.ChildMain.run(ChildMain.java:269)
|#]

[#|2004-06-18T02:41:48.921+0100|INFO|sun-appserver-pe8.0|javax.enterprise.system.stream.out|_ThreadID=10;|2004-06-18 02:41:48,921 WARN [webwork.dispatcher.ServletDispatcher] Unable to find 'webwork.multipart.saveDir' property setting. Defaulting to javax.servlet.context.tempdir
|#]

[#|2004-06-18T02:41:52.375+0100|INFO|sun-appserver-pe8.0|javax.enterprise.resource.jms|_ThreadID=10;|JMS5023: JMS service successfully started. Instance Name = imqbroker, Home = [C:\opt\Java\AppServer\E8\imq\bin].|#]

[#|2004-06-18T02:41:52.375+0100|INFO|sun-appserver-pe8.0|javax.enterprise.system.tools.admin|_ThreadID=10;|[AutoDeploy] Enabling AutoDeployment service at :1087522912375|#]

[#|2004-06-18T02:41:52.375+0100|INFO|sun-appserver-pe8.0|javax.enterprise.system.core|_ThreadID=10;|CORE5053: Application onReady complete.|#]

[#|2004-06-18T02:41:52.375+0100|INFO|sun-appserver-pe8.0|javax.enterprise.system.core|_ThreadID=10;|Application server startup complete.|#]

References:
- Startup problem with 2.6.1
  - From: Joel Rosi-Schwartz
- Re: [JIRA-user] Startup problem with 2.6.1
  - From: Joel Rosi-Schwartz

Prev by Date: Re: [JIRA-user] Startup problem with 2.6.1
Next by Date: Re: Disable logging
Prev by thread: Re: [JIRA-user] Startup problem with 2.6.1
Next by thread: Re: [JIRA-user] Startup problem with 2.6.1
Index(es):
- Date
- Thread