Bug 794077 (JBEPP-1144)

Summary: Error in reindexing when using MySQL as database
Product: [JBoss] JBoss Enterprise Portal Platform 5 Reporter: mposolda
Component: unspecifiedAssignee: Default User <jbpapp-maint>
Status: CLOSED NOTABUG QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.2.0.DEV03CC: epp-bugs, mposolda, mweiler
Target Milestone: ---   
Target Release: 5.2.0.ER01   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/JBEPP-1144
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
MySQL 5.1, local-tx-datasource configured with MySQL
Last Closed: 2011-09-02 09:20:13 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Attachments:
Description Flags
exception-indexing.txt none

Description mposolda 2011-09-02 08:26:38 UTC 
project_key: JBEPP

1) Configure EPP 5.2.0.DEV03
	- use MySQL database. Configure datasource in server/default/deploy/gatein-ds.xml to use MySQL (local-tx-datasource used for both IDM and JCR as this is default datasource type in EPP 5.2)
	- use gatein.data.dir=/tmp/gatein in server/default/conf/gatein/configuration.properties

2) Start EPP 5.2 . now it starts correctly without problem. Then stop it.

3) Delete data directory /tmp/gatein

4) Start EPP 5.2 again. Now I am seeing exception during indexation (See stacktrace in attachement)

I did not investigate deeper and I am not sure if this scenario is expected to work, but it is working with EPP 5.1 but now it starting to fail with EPP 5.2.
Comment 1 mposolda 2011-09-02 08:27:18 UTC 
Attachment: Added: exception-indexing.txt
Comment 2 mposolda 2011-09-02 08:28:44 UTC 
Linking this issue with JBEPP-1143. Maybe it's not related as exception stacktrace is different, but scenario to reproduce is quite similar.
Comment 3 mposolda 2011-09-02 08:28:44 UTC 
Link: Added: This issue relates to JBEPP-1143
Comment 4 Martin Weiler 2011-09-02 08:34:43 UTC 
From the attached stack trace:
Caused by: java.io.FileNotFoundException: /tmp/gatein/jcr/values/portal-system/2/9/2/e/f/5/c/87f00000100cffeb560c19a0d/292ef5c87f00000100cffeb560c19a0d0 (No such file or directory)

I've seen similar problems with EPP 5.1 after deleting the complete ${gatein.data.dir} directory. Binary content (such as gadgets) is stored in this location - or underneath ${gatein.jcr.storage.data.dir} to be precise -, so you should not delete it. If a forced index re-creation is required, only delete the ${gatein.jcr.index.data.dir} directory.
Comment 5 mposolda 2011-09-02 09:19:53 UTC 
Thanks Martin. I can confirm that delete only index data dir and left storage data dir is reindexation working.

Scenario which I described is working fine in EPP 5.1.1 but with EPP 5.1.1 it's failing when I am trying to add some gadget into dashboard page.

Anyway, seems that this jira can be closed.
Comment 6 Thomas Heute 2011-09-22 07:14:07 UTC 
Release Notes Docs Status: Added: Not Required