[
https://issues.apache.org/jira/browse/OPENMEETINGS-194?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13264299#comment-13264299
]
SebastianWagner commented on OPENMEETINGS-194:
----------------------------------------------
There is an Exception when you do the --drop option while doing installation:
Command:
C:Openmeetings\dist\red5>admin -i -v -tz Europe/Berlin -email
[email protected] -gr
oup webbase -user swagner --password qweqwe --db-pass admin --smtp-server
smtp.webbase-design.de --db-type mysql --db-name openmeetings
--email-auth-user [email protected] --system-email-address
[email protected] --db-user root --drop
Exception:
DEBUG 04-28 13:56:54.760 MeetingReminderJob.java 8034 34
org.openmeetings.app.quartz.scheduler.MeetingReminderJob
[org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-2] -
MeetingReminderJob.execute
ERROR 04-28 13:56:55.608 SessionClearJob.java 8882 38
org.openmeetings.app.quartz.scheduler.SessionClearJob
[org.springframework.scheduling.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'
already exists {stmnt 30541552 CREATE TABLE sessiondata (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=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.java: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.springframework.transaction-jar-3.0.6.RELEASE.jar:3.0.6.RELEASE]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
~[org.springframework.aop-jar-3.0.6.RELEASE.jar:3.0.6.RELEASE]
at
org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)
~[org.springframework.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(MethodInvokingJobDetailFactoryBean.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 30541552 CREATE TABLE sessiondata (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=42S01]
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-bundle-2.2.0.jar:2.2.0]
at
org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:154)
~[openjpa-bundle-2.2.0.jar:2.2.0]
at
org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60)
~[openjpa-bundle-2.2.0.jar:2.2.0]
at
org.springframework.orm.jpa.JpaTransactionManager.createEntityManagerForTransaction(JpaTransactionManager.java:400)
~[org.springframework.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 30541552 CREATE TABLE sessiondata (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=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(LoggingConnectionDecorator.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
> Command line admin: added parameter "--drop", to drop database before install
> -----------------------------------------------------------------------------
>
> Key: OPENMEETINGS-194
> URL: https://issues.apache.org/jira/browse/OPENMEETINGS-194
> Project: Openmeetings
> Issue Type: Improvement
> Reporter: Dmitry Zamula
> Assignee: Maxim Solodovnik
> Priority: Minor
> Labels: cli, install, patch
> Fix For: 2.0 Apache Incubator Release
>
> Attachments: openmeetings_cli_install_drop_db.patch,
> openmeetings_cli_install_drop_db_version2.patch,
> openmeetings_cli_install_drop_db_version3.patch
>
>
> Optional parameter "--drop" allows to drop existing database before
> Openmeetings install.
--
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
