Problem in using mysql+alfresco

mialfresco — Mon, 27 Jul 2009 10:06:24 GMT

Hi team, from the last few days i'm facing a problem with configuring the mysql with alfresco.EnvironmentS: windows XP professional editionAlfresco: 3.0 labs stable versionMy SQL: mysql-essential-5.0.18-win32what i have done is, i installed My SQL sucessfully in my local machine.custom-repository.

Re: Problem in using mysql+alfresco

mialfresco — Mon, 27 Jul 2009 10:31:37 GMT

I think this is causing the problem.

Caused by: java.sql.SQLException: Can't create/write to file 'C:\WINDOWS\TEMP\#s
ql_f0c_0.MYD' (Errcode: 17)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1534)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1625)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2291)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2226)
        at com.mysql.jdbc.Statement.executeQuery(Statement.java:1159‍‍‍‍‍‍‍‍

How to cross this?

Re: Problem in using mysql+alfresco

mikeh — Mon, 27 Jul 2009 10:51:30 GMT

Disable your McAfee (or other) virus scanner for .myd and .myi files.

Mike

Re: Problem in using mysql+alfresco

mialfresco — Mon, 27 Jul 2009 12:18:09 GMT

Hi mike,
thanks for your quick reply.
Yes, you are right.
After disabling the McAfee the previous error was gone.
And there was some column lenght problem in a table.
the following error i'm getting now.

17:49:45,096  INFO  [config.xml.XMLConfigService$PropertyConfigurer] Loading pro
perties file from class path resource [alfresco/file-servers.properties]
17:50:18,373  INFO  [domain.schema.SchemaBootstrap] Schema managed by database d
ialect org.hibernate.dialect.MySQLInnoDBDialect.
17:50:22,077  INFO  [domain.schema.SchemaBootstrap] No changes were made to the
schema.
17:51:10,359 User:System ERROR [web.context.ContextLoader] Context initializatio
n failed
org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed
        at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootst
rap.java:351)
        at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBoot
strap.java:702)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLi
fecycleBean.java:62)
        at org.springframework.context.event.SimpleApplicationEventMulticaster$1
.run(SimpleApplicationEventMulticaster.java:77)
        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecut
or.java:49)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.m
ulticastEvent(SimpleApplicationEventMulticaster.java:75)
        at org.springframework.context.support.AbstractApplicationContext.publis
hEvent(AbstractApplicationContext.java:246)
        at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:355)
        at org.springframework.web.context.ContextLoader.createWebApplicationCon
text(ContextLoader.java:244)
        at org.springframework.web.context.ContextLoader.initWebApplicationConte
xt(ContextLoader.java:187)
        at org.springframework.web.context.ContextLoaderListener.contextInitiali
zed(ContextLoaderListener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3843)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
342)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:791)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:77
1)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)

        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:830)

        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:719
)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490
)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:117)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443
)
        at org.apache.catalina.core.StandardService.start(StandardService.java:5
16)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710
)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: coul
d not insert: [org.alfresco.repo.domain.hibernate.NodeImpl]; nested exception is
 org.hibernate.exception.DataException: could not insert: [org.alfresco.repo.dom
ain.hibernate.NodeImpl]
        at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHiberna
teAccessException(SessionFactoryUtils.java:616)
        at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernate
AccessException(HibernateAccessor.java:412)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:377)
        at org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTe
mplate.java:632)
        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.newNo
de(HibernateNodeDaoServiceImpl.java:859)
        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.creat
eStore(HibernateNodeDaoServiceImpl.java:635)
        at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:296)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:177)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:144)
        at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(Tran
sactionalDaoInterceptor.java:68)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:166)
        at org.alfresco.repo.domain.hibernate.DirtySessionMethodInterceptor.invo
ke(DirtySessionMethodInterceptor.java:381)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:166)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:204)
        at $Proxy2.createStore(Unknown Source)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.createStore(DbNodeService
Impl.java:214)
        at sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:296)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:177)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:144)
        at org.alfresco.repo.transaction.SingleEntryTransactionResourceIntercept
or.invokeInternal(SingleEntryTransactionResourceInterceptor.java:163)
        at org.alfresco.repo.transaction.SingleEntryTransactionResourceIntercept
or.invoke(SingleEntryTransactionResourceInterceptor.java:138)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:166)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:204)
        at $Proxy7.createStore(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:296)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:177)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:144)
        at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNo
deServiceInterceptor.java:110)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:166)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:204)
        at $Proxy7.createStore(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvoc
ationHandler.invoke(StoreRedirectorProxyFactory.java:221)
        at $Proxy8.createStore(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:296)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:177)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:144)
        at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterce
ptor.java:306)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:166)
        at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterce
ptor.java:306)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:166)
        at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRe
fPropertyMethodInterceptor.java:274)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:166)
        at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRe
fPropertyMethodInterceptor.java:274)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:166)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:204)
        at $Proxy7.createStore(Unknown Source)
        at org.alfresco.repo.importer.ImporterBootstrap.doImport(ImporterBootstr
ap.java:376)
        at org.alfresco.repo.importer.ImporterBootstrap.access$000(ImporterBoots
trap.java:72)
        at org.alfresco.repo.importer.ImporterBootstrap$1$1.execute(ImporterBoot
strap.java:340)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransacti
on(RetryingTransactionHelper.java:320)
        at org.alfresco.repo.importer.ImporterBootstrap$1.doWork(ImporterBootstr
ap.java:344)
        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(Au
thenticationUtil.java:437)
        at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootst
rap.java:347)
        … 34 more
Caused by: org.hibernate.exception.DataException: could not insert: [org.alfresc
o.repo.domain.hibernate.NodeImpl]
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:77)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
        at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(Abstr
actReturningDelegate.java:40)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
tEntityPersister.java:2163)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
tEntityPersister.java:2643)
        at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentit
yInsertAction.java:51)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:322)
        at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplic
ate(AbstractSaveEventListener.java:298)
        at org.hibernate.event.def.AbstractSaveEventListener.performSave(Abstrac
tSaveEventListener.java:181)
        at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId
(AbstractSaveEventListener.java:107)
        at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGene
ratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
        at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrR
equestedId(DefaultSaveEventListener.java:33)
        at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTran
sient(DefaultSaveOrUpdateEventListener.java:172)
        at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(
DefaultSaveEventListener.java:27)
        at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpda
te(DefaultSaveOrUpdateEventListener.java:70)
        at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
        at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
        at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
        at org.springframework.orm.hibernate3.HibernateTemplate$12.doInHibernate
(HibernateTemplate.java:635)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:372)
        … 99 more
Caused by: java.sql.SQLException: Data too long for column 'node_deleted' at row
 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1534)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1625)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2297)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2226)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1812)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1906)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1831)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1693)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Del
egatingPreparedStatement.java:101)
        at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAn
dExtract(IdentityGenerator.java:73)
        at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(Abstr
actReturningDelegate.java:33)
        … 116 more
Jul 27, 2009 5:51:10 PM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Jul 27, 2009 5:51:10 PM org.apache.catalina.core.StandardContext start
SEVERE: Context [/alfresco] startup failed due to previous errors
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class
 reloading, using NOPLoggerRepository.
Jul 27, 2009 5:51:17 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive share.war
17:51:40,870  INFO  [web.site.FrameworkHelper] Successfully Initialized Web Fram
ework
Jul 27, 2009 5:51:41 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive studio.war

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Problem in using mysql+alfresco

mialfresco — Mon, 27 Jul 2009 13:02:53 GMT

even i tried with a new (version) jar mysql-connector-java-5.1.7-bin.jar

but still no luck.

Re: Problem in using mysql+alfresco

mialfresco — Tue, 28 Jul 2009 05:05:01 GMT

Hi team,
can anyone suggest me what is the solution for this problem?

topic Re: Problem in using mysql+alfresco in Alfresco Archive

Problem in using mysql+alfresco

Re: Problem in using mysql+alfresco

Re: Problem in using mysql+alfresco

Re: Problem in using mysql+alfresco

Re: Problem in using mysql+alfresco

Re: Problem in using mysql+alfresco