Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Hyland Connect
- Content Management
- Alfresco
- Alfresco Archive
- error updating mysql 4.1 to 5.0
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
error updating mysql 4.1 to 5.0
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-26-2007 10:53 AM
hi,
i want to update MySQL 4.1 to 5.0. I've done this:
-Backup the database from 4.1.
-Remove Service MySQL (ponting to 4.1).
-Install MySQL 5.0.
-Create Service MySQL (pointing to 5.0).
-Restore the backup in 5.0.
-Put index.recovery.mode=FULL in order to rebuild lucene indexes.
-Restart alfrescto (it rebuilds index ok).
After that it shows a "content integrity error: System content not in content store."
what i've done wrong?
thanx
PD: dir.root points to c:\alfresco\alf_data, as with 4.1, but the only solution i coud find, is create a new repository, losing the old one.
i want to update MySQL 4.1 to 5.0. I've done this:
-Backup the database from 4.1.
-Remove Service MySQL (ponting to 4.1).
-Install MySQL 5.0.
-Create Service MySQL (pointing to 5.0).
-Restore the backup in 5.0.
-Put index.recovery.mode=FULL in order to rebuild lucene indexes.
-Restart alfrescto (it rebuilds index ok).
After that it shows a "content integrity error: System content not in content store."
what i've done wrong?
thanx
PD: dir.root points to c:\alfresco\alf_data, as with 4.1, but the only solution i coud find, is create a new repository, losing the old one.
CompilerOracle: exclude org/apache/lucene/index/IndexReader$1 doBody
CompilerOracle: exclude org/alfresco/repo/search/impl/lucene/index/IndexInfo$Mer
ger mergeIndexes
CompilerOracle: exclude org/alfresco/repo/search/impl/lucene/index/IndexInfo$Mer
ger mergeDeletions
26-nov-2007 13:56:07 org.apache.coyote.http11.Http11BaseProtocol init
INFO: Inicializando Coyote HTTP/1.1 en puerto http-8080
26-nov-2007 13:56:07 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 3282 ms
26-nov-2007 13:56:07 org.apache.catalina.core.StandardService start
INFO: Arrancando servicio Catalina
26-nov-2007 13:56:07 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.23
26-nov-2007 13:56:07 org.apache.catalina.core.StandardHost start
INFO: Desactivada la validaci¾n XML
26-nov-2007 13:56:14 org.apache.catalina.startup.HostConfig deployWAR
INFO: Despliegue del archivo alfresco.war de la aplicaci¾n web
13:57:58,312 WARN [remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI re
gistry - creating new one
13:58:16,390 INFO [domain.schema.SchemaBootstrap] Schema managed by database di
alect org.hibernate.dialect.MySQLInnoDBDialect.
13:58:24,078 INFO [domain.schema.SchemaBootstrap] No changes were made to the s
chema.
13:58:26,828 DEBUG [repo.importer.ImporterBootstrap] Store exists - bootstrap ig
nored: user://alfrescoUserStore
13:58:26,828 DEBUG [repo.importer.ImporterBootstrap] Store exists - bootstrap ig
nored: system://system
13:58:26,859 DEBUG [repo.importer.ImporterBootstrap] Store exists - bootstrap ig
nored: workspace://lightWeightVersionStore
13:58:26,906 DEBUG [repo.importer.ImporterBootstrap] Store exists - bootstrap ig
nored: archive://SpacesStore
13:58:26,921 DEBUG [repo.importer.ImporterBootstrap] Store exists - bootstrap ig
nored: workspace://SpacesStore
13:58:32,031 INFO [node.index.FullIndexRecoveryComponent] Index recovery starte
d: 80 transactions.
13:58:40,078 INFO [node.index.FullIndexRecoveryComponent] 10 % complete.
13:58:41,296 INFO [node.index.FullIndexRecoveryComponent] 20 % complete.
13:58:41,656 INFO [node.index.FullIndexRecoveryComponent] 30 % complete.
13:58:41,984 INFO [node.index.FullIndexRecoveryComponent] 40 % complete.
13:58:42,265 INFO [node.index.FullIndexRecoveryComponent] 50 % complete.
13:58:42,484 INFO [node.index.FullIndexRecoveryComponent] 60 % complete.
13:58:42,671 INFO [node.index.FullIndexRecoveryComponent] 70 % complete.
13:58:42,843 INFO [node.index.FullIndexRecoveryComponent] 80 % complete.
13:58:43,078 INFO [node.index.FullIndexRecoveryComponent] 90 % complete.
13:58:43,265 INFO [node.index.FullIndexRecoveryComponent] 100 % complete.
13:58:43,296 INFO [node.index.FullIndexRecoveryComponent] Index recovery comple
ted.
13:59:49,718 INFO [repo.admin.ConfigurationChecker] The Alfresco root data dire
ctory ('dir.root') is: C:\alfresco\alf_data
13:59:49,765 ERROR [repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: Sy
stem content not found in content store.
13:59:49,765 ERROR [repo.admin.ConfigurationChecker] Ensure that the 'dir.root'
property is pointing to the correct data location.
13:59:49,796 ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Ensure that the 'dir.root' property
is pointing to the correct data location.
at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationCheck
er.java:312)
at org.alfresco.repo.admin.ConfigurationChecker.access$000(Configuration
Checker.java:72)
at org.alfresco.repo.admin.ConfigurationChecker$1.execute(ConfigurationC
hecker.java:178)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransacti
on(RetryingTransactionHelper.java:225)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransacti
on(RetryingTransactionHelper.java:155)
at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(Configuratio
nChecker.java:182)
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:241)
at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:349)
at org.springframework.web.context.support.AbstractRefreshableWebApplica
tionContext.refresh(AbstractRefreshableWebApplicationContext.java:156)
at org.springframework.web.context.ContextLoader.createWebApplicationCon
text(ContextLoader.java:246)
at org.springframework.web.context.ContextLoader.initWebApplicationConte
xt(ContextLoader.java:184)
at org.springframework.web.context.ContextLoaderListener.contextInitiali
zed(ContextLoaderListener.java:49)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3764)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
216)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:74
0)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714
)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490
)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443
)
at org.apache.catalina.core.StandardService.start(StandardService.java:4
48)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700
)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
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:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
13:59:49,796 ERROR [[Catalina].[localhost].[/alfresco]] Excepci¾n enviando event
o inicializado de contexto a instancia de escuchador de clase org.springframewor
k.web.context.ContextLoaderListener
org.alfresco.error.AlfrescoRuntimeException: Ensure that the 'dir.root' property
is pointing to the correct data location.
at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationCheck
er.java:312)
at org.alfresco.repo.admin.ConfigurationChecker.access$000(Configuration
Checker.java:72)
at org.alfresco.repo.admin.ConfigurationChecker$1.execute(ConfigurationC
hecker.java:178)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransacti
on(RetryingTransactionHelper.java:225)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransacti
on(RetryingTransactionHelper.java:155)
at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(Configuratio
nChecker.java:182)
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:241)
at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:349)
at org.springframework.web.context.support.AbstractRefreshableWebApplica
tionContext.refresh(AbstractRefreshableWebApplicationContext.java:156)
at org.springframework.web.context.ContextLoader.createWebApplicationCon
text(ContextLoader.java:246)
at org.springframework.web.context.ContextLoader.initWebApplicationConte
xt(ContextLoader.java:184)
at org.springframework.web.context.ContextLoaderListener.contextInitiali
zed(ContextLoaderListener.java:49)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3764)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
216)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:74
0)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714
)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490
)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443
)
at org.apache.catalina.core.StandardService.start(StandardService.java:4
48)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700
)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
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:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
13:59:49,812 ERROR [[Catalina].[localhost].[/alfresco]] Excepci¾n enviando event
o inicializado de contexto a instancia de escuchador de clase org.alfresco.web.a
pp.ContextListener
org.alfresco.error.AlfrescoRuntimeException: Ensure that the 'dir.root' property
is pointing to the correct data location.
at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationCheck
er.java:312)
at org.alfresco.repo.admin.ConfigurationChecker.access$000(Configuration
Checker.java:72)
at org.alfresco.repo.admin.ConfigurationChecker$1.execute(ConfigurationC
hecker.java:178)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransacti
on(RetryingTransactionHelper.java:225)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransacti
on(RetryingTransactionHelper.java:155)
at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(Configuratio
nChecker.java:182)
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:241)
at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:349)
at org.springframework.web.context.support.AbstractRefreshableWebApplica
tionContext.refresh(AbstractRefreshableWebApplicationContext.java:156)
at org.springframework.web.context.ContextLoader.createWebApplicationCon
text(ContextLoader.java:246)
at org.springframework.web.context.ContextLoader.initWebApplicationConte
xt(ContextLoader.java:184)
at org.springframework.web.context.ContextLoaderListener.contextInitiali
zed(ContextLoaderListener.java:49)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3764)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
216)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:74
0)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714
)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490
)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443
)
at org.apache.catalina.core.StandardService.start(StandardService.java:4
48)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700
)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
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:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
26-nov-2007 13:59:49 org.apache.catalina.core.StandardContext start
GRAVE: Error listenerStart
26-nov-2007 13:59:49 org.apache.catalina.core.StandardContext start
GRAVE: Fall¾ en arranque del Contexto [/alfresco] debido a errores previos
26-nov-2007 13:59:56 org.apache.coyote.http11.Http11BaseProtocol start
INFO: Arrancando Coyote HTTP/1.1 en puerto http-8080
26-nov-2007 13:59:56 org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
26-nov-2007 13:59:57 org.apache.catalina.startup.Catalina start
INFO: Server startup in 229860 ms
Labels:
- Labels:
-
Archive
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2007 07:16 AM
anyone?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2007 07:48 AM
Unfortunately I had the same problem.
I just wonder whether you do not need to complete erase the mysql database schema & files, and have it rebuilt from scratch. If you had a previous installation on MySQL (or other RDBMS), it seems to be sticky and Alfresco cannot clean and restart from that installation, even if you re-install.
Regards,
Ronny.
I just wonder whether you do not need to complete erase the mysql database schema & files, and have it rebuilt from scratch. If you had a previous installation on MySQL (or other RDBMS), it seems to be sticky and Alfresco cannot clean and restart from that installation, even if you re-install.
Regards,
Ronny.
Related Content
- Getting Started: Run Alfresco AI Development Locally with Docker Model Runner in Alfresco Blog
- From Alfresco CE 7.3/Tomcat 9 to Alfresco 23.2.1/Tomcat 10 in Alfresco Forum
- Keystore exception on Setting up alfresco 23.1.0 with MySQL database in Alfresco Forum
- Streaming result set com.mysql.cj.protocol.a.result.ResultsetRowsStreaming@4d221f7a is still active in Alfresco Forum
- Keystore Validation Error During Alfresco Deployment on Tomcat in Alfresco Forum
Getting started
Tags
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.
