You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@openmeetings.apache.org by "SebastianWagner (JIRA)" <ji...@apache.org> on 2012/05/05 08:59:49 UTC
[jira] [Created] (OPENMEETINGS-257) Exception in CLI Installer when
installing in a new database
SebastianWagner created OPENMEETINGS-257:
--------------------------------------------
Summary: Exception in CLI Installer when installing in a new database
Key: OPENMEETINGS-257
URL: https://issues.apache.org/jira/browse/OPENMEETINGS-257
Project: Openmeetings
Issue Type: Bug
Affects Versions: 2.0 Apache Incubator Release
Reporter: SebastianWagner
Assignee: Maxim Solodovnik
Fix For: 2.0 Apache Incubator Release
Tested with revision 1334316
I have made sure that the database "openmeetings_asf" does not exist before running the installer.
Installer command:
dist\red5>admin -v -i -user swagner --password qweqwe -email seba.wagner
@gmail.com -tz Europe/Berlin -group webbase --smtp-server smtp.webbase-design.de --email-auth-user i4c@webbase-design.de --system-email
-address i4c@webbase-design.de --email-auth-pass ****** --db-type mysql --db-name openmeetings_asf --db-user root --db-pass admin --db
-host localhost
Exception in the console while installing:
ERROR 05-05 08:55:23.775 SessionClearJob.java 9445 38 org.openmeetings.app.quartz.scheduler.SessionClearJob [org.springframework.schedu
ling.quartz.SchedulerFactoryBean#0_Worker-1] - execute
org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is
<openjpa-2.2.0-r422266:1244990 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Table 'sessiondata' alread
y exists {stmnt 16069402 CREATE TABLE sessiondata (id BIGINT NOT NULL AUTO_INCREMENT, language_id BIGINT, organization_id BIGINT, refre
sh_time DATETIME, sessionXml TEXT, session_id VARCHAR(255), starttermin_time DATETIME, storePermanent BIT, user_id BIGINT, PRIMARY KEY
(id)) ENGINE = myisam} [code=1050, state=42S01]
at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:382) ~[org.springframework.orm-jar-3.0.
6.RELEASE.jar:3.0.6.RELEASE]
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager
.java:371) ~[org.springframework.transaction-jar-3.0.6.RELEASE.jar:3.0.6.RELEASE]
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.j
ava:335) ~[org.springframework.transaction-jar-3.0.6.RELEASE.jar:3.0.6.RELEASE]
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105) ~[org.springframe
work.transaction-jar-3.0.6.RELEASE.jar:3.0.6.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) ~[org.springframew
ork.aop-jar-3.0.6.RELEASE.jar:3.0.6.RELEASE]
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621) ~[org.springfr
amework.aop-jar-3.0.6.RELEASE.jar:3.0.6.RELEASE]
at org.openmeetings.app.data.basic.Sessionmanagement$$EnhancerByCGLIB$$89d20ca6.clearSessionTable(<generated>) ~[cglib-jar-2.2.
2.jar:na]
at org.openmeetings.app.quartz.scheduler.SessionClearJob.doIt(SessionClearJob.java:36) ~[openmeetings-2.0.0-SNAPSHOT.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_31]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_31]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_31]
at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.6.0_31]
at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273) [spring-core-3.0.6.RELEASE.jar:3.0.6.RELEASE]
at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJob
DetailFactoryBean.java:264) [spring-context-support-3.0.6.RELEASE.jar:3.0.6.RELEASE]
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86) [spring-context-support-3.0.6.RELEASE.jar
:3.0.6.RELEASE]
at org.quartz.core.JobRunShell.run(JobRunShell.java:216) [quartz-1.8.5.jar:na]
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549) [quartz-1.8.5.jar:na]
Caused by: org.apache.openjpa.persistence.PersistenceException: Table 'sessiondata' already exists {stmnt 16069402 CREATE TABLE session
data (id BIGINT NOT NULL AUTO_INCREMENT, language_id BIGINT, organization_id BIGINT, refresh_time DATETIME, sessionXml TEXT, session_id
VARCHAR(255), starttermin_time DATETIME, storePermanent BIT, user_id BIGINT, PRIMARY KEY (id)) ENGINE = myisam} [code=1050, state=42S0
1]
at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:559) ~[openjpa-bundle-2.2.0.jar:2.2.0]
at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:455) ~[openjpa-bundle-2.2.0.jar:2.2.0]
at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:160) ~[openjpa-bundle-2.2.0.jar:
2.2.0]
at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:164) ~[openjpa-bundle-2.2.0.jar:
2.2.0]
at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:122) ~[openjpa-bundle-2.2.0.jar:2.2.0]
at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:209) ~[openjpa-bundle-2.2.0.jar:2.2.0]
at org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156) ~[openjpa-bundle-2.2.0.jar:2.2
.0]
at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227) ~[openjpa-bun
dle-2.2.0.jar:2.2.0]
at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:154) ~[openjpa-bun
dle-2.2.0.jar:2.2.0]
at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60) ~[openjpa-bund
le-2.2.0.jar:2.2.0]
at org.springframework.orm.jpa.JpaTransactionManager.createEntityManagerForTransaction(JpaTransactionManager.java:400) ~[org.sp
ringframework.orm-jar-3.0.6.RELEASE.jar:3.0.6.RELEASE]
at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:321) ~[org.springframework.orm-jar-3.0.
6.RELEASE.jar:3.0.6.RELEASE]
... 16 common frames omitted
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table 'sessiondata' already exists {stmnt 16069402 CREATE TABLE sessionda
ta (id BIGINT NOT NULL AUTO_INCREMENT, language_id BIGINT, organization_id BIGINT, refresh_time DATETIME, sessionXml TEXT, session_id V
ARCHAR(255), starttermin_time DATETIME, storePermanent BIT, user_id BIGINT, PRIMARY KEY (id)) ENGINE = myisam} [code=1050, state=42S01]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:247) ~[openjpa-bundle-2.2.0.jar:
2.2.0]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:231) ~[openjpa-bundle-2.2.0.jar:
2.2.0]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:72) ~[openjpa-bundle-2.2.0
.jar:2.2.0]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingStatement.executeUpdate(LoggingConnectionDec
orator.java:942) ~[openjpa-bundle-2.2.0.jar:2.2.0]
at org.apache.openjpa.lib.jdbc.DelegatingStatement.executeUpdate(DelegatingStatement.java:114) ~[openjpa-bundle-2.2.0.jar:2.2.0
]
at org.apache.openjpa.jdbc.schema.SchemaTool.executeSQL(SchemaTool.java:1224) ~[openjpa-bundle-2.2.0.jar:2.2.0]
at org.apache.openjpa.jdbc.schema.SchemaTool.createTable(SchemaTool.java:975) ~[openjpa-bundle-2.2.0.jar:2.2.0]
at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:551) ~[openjpa-bundle-2.2.0.jar:2.2.0]
at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:366) ~[openjpa-bundle-2.2.0.jar:2.2.0]
at org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:343) ~[openjpa-bundle-2.2.0.jar:2.2.0]
at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:505) ~[openjpa-bundle-2.2.0.jar:2.2.0]
... 27 common frames omitted
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Closed] (OPENMEETINGS-257) Exception in CLI Installer when
installing in a new database
Posted by "SebastianWagner (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENMEETINGS-257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
SebastianWagner closed OPENMEETINGS-257.
----------------------------------------
Resolution: Cannot Reproduce
I installed several times, I cannot reproduce it stable. Sometimes it seems when you run the CLI installer twice it happens.
> Exception in CLI Installer when installing in a new database
> ------------------------------------------------------------
>
> Key: OPENMEETINGS-257
> URL: https://issues.apache.org/jira/browse/OPENMEETINGS-257
> Project: Openmeetings
> Issue Type: Bug
> Affects Versions: 2.0 Apache Incubator Release
> Reporter: SebastianWagner
> Assignee: Maxim Solodovnik
> Fix For: 2.0 Apache Incubator Release
>
>
> Tested with revision 1334316
> I have made sure that the database "openmeetings_asf" does not exist before running the installer.
> Installer command:
> dist\red5>admin -v -i -user swagner --password qweqwe -email seba.wagner
> @gmail.com -tz Europe/Berlin -group webbase --smtp-server smtp.webbase-design.de --email-auth-user i4c@webbase-design.de --system-email
> -address i4c@webbase-design.de --email-auth-pass ****** --db-type mysql --db-name openmeetings_asf --db-user root --db-pass admin --db
> -host localhost
> Exception in the console while installing:
> ERROR 05-05 08:55:23.775 SessionClearJob.java 9445 38 org.openmeetings.app.quartz.scheduler.SessionClearJob [org.springframework.schedu
> ling.quartz.SchedulerFactoryBean#0_Worker-1] - execute
> org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is
> <openjpa-2.2.0-r422266:1244990 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Table 'sessiondata' alread
> y exists {stmnt 16069402 CREATE TABLE sessiondata (id BIGINT NOT NULL AUTO_INCREMENT, language_id BIGINT, organization_id BIGINT, refre
> sh_time DATETIME, sessionXml TEXT, session_id VARCHAR(255), starttermin_time DATETIME, storePermanent BIT, user_id BIGINT, PRIMARY KEY
> (id)) ENGINE = myisam} [code=1050, state=42S01]
> at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:382) ~[org.springframework.orm-jar-3.0.
> 6.RELEASE.jar:3.0.6.RELEASE]
> at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager
> .java:371) ~[org.springframework.transaction-jar-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.j
> ava:335) ~[org.springframework.transaction-jar-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105) ~[org.springframe
> work.transaction-jar-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) ~[org.springframew
> ork.aop-jar-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621) ~[org.springfr
> amework.aop-jar-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.openmeetings.app.data.basic.Sessionmanagement$$EnhancerByCGLIB$$89d20ca6.clearSessionTable(<generated>) ~[cglib-jar-2.2.
> 2.jar:na]
> at org.openmeetings.app.quartz.scheduler.SessionClearJob.doIt(SessionClearJob.java:36) ~[openmeetings-2.0.0-SNAPSHOT.jar:na]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_31]
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_31]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_31]
> at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.6.0_31]
> at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273) [spring-core-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJob
> DetailFactoryBean.java:264) [spring-context-support-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86) [spring-context-support-3.0.6.RELEASE.jar
> :3.0.6.RELEASE]
> at org.quartz.core.JobRunShell.run(JobRunShell.java:216) [quartz-1.8.5.jar:na]
> at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549) [quartz-1.8.5.jar:na]
> Caused by: org.apache.openjpa.persistence.PersistenceException: Table 'sessiondata' already exists {stmnt 16069402 CREATE TABLE session
> data (id BIGINT NOT NULL AUTO_INCREMENT, language_id BIGINT, organization_id BIGINT, refresh_time DATETIME, sessionXml TEXT, session_id
> VARCHAR(255), starttermin_time DATETIME, storePermanent BIT, user_id BIGINT, PRIMARY KEY (id)) ENGINE = myisam} [code=1050, state=42S0
> 1]
> at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:559) ~[openjpa-bundle-2.2.0.jar:2.2.0]
> at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:455) ~[openjpa-bundle-2.2.0.jar:2.2.0]
> at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:160) ~[openjpa-bundle-2.2.0.jar:
> 2.2.0]
> at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:164) ~[openjpa-bundle-2.2.0.jar:
> 2.2.0]
> at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:122) ~[openjpa-bundle-2.2.0.jar:2.2.0]
> at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:209) ~[openjpa-bundle-2.2.0.jar:2.2.0]
> at org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156) ~[openjpa-bundle-2.2.0.jar:2.2
> .0]
> at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227) ~[openjpa-bun
> dle-2.2.0.jar:2.2.0]
> at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:154) ~[openjpa-bun
> dle-2.2.0.jar:2.2.0]
> at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60) ~[openjpa-bund
> le-2.2.0.jar:2.2.0]
> at org.springframework.orm.jpa.JpaTransactionManager.createEntityManagerForTransaction(JpaTransactionManager.java:400) ~[org.sp
> ringframework.orm-jar-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:321) ~[org.springframework.orm-jar-3.0.
> 6.RELEASE.jar:3.0.6.RELEASE]
> ... 16 common frames omitted
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table 'sessiondata' already exists {stmnt 16069402 CREATE TABLE sessionda
> ta (id BIGINT NOT NULL AUTO_INCREMENT, language_id BIGINT, organization_id BIGINT, refresh_time DATETIME, sessionXml TEXT, session_id V
> ARCHAR(255), starttermin_time DATETIME, storePermanent BIT, user_id BIGINT, PRIMARY KEY (id)) ENGINE = myisam} [code=1050, state=42S01]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:247) ~[openjpa-bundle-2.2.0.jar:
> 2.2.0]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:231) ~[openjpa-bundle-2.2.0.jar:
> 2.2.0]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:72) ~[openjpa-bundle-2.2.0
> .jar:2.2.0]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingStatement.executeUpdate(LoggingConnectionDec
> orator.java:942) ~[openjpa-bundle-2.2.0.jar:2.2.0]
> at org.apache.openjpa.lib.jdbc.DelegatingStatement.executeUpdate(DelegatingStatement.java:114) ~[openjpa-bundle-2.2.0.jar:2.2.0
> ]
> at org.apache.openjpa.jdbc.schema.SchemaTool.executeSQL(SchemaTool.java:1224) ~[openjpa-bundle-2.2.0.jar:2.2.0]
> at org.apache.openjpa.jdbc.schema.SchemaTool.createTable(SchemaTool.java:975) ~[openjpa-bundle-2.2.0.jar:2.2.0]
> at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:551) ~[openjpa-bundle-2.2.0.jar:2.2.0]
> at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:366) ~[openjpa-bundle-2.2.0.jar:2.2.0]
> at org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:343) ~[openjpa-bundle-2.2.0.jar:2.2.0]
> at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:505) ~[openjpa-bundle-2.2.0.jar:2.2.0]
> ... 27 common frames omitted
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira