Bug 794077 (JBEPP-1144) - Error in reindexing when using MySQL as database
Summary: Error in reindexing when using MySQL as database
Keywords:
Status: CLOSED NOTABUG
Alias: JBEPP-1144
Product: JBoss Enterprise Portal Platform 5
Classification: JBoss
Component: unspecified
Version: 5.2.0.DEV03
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 5.2.0.ER01
Assignee: Default User
QA Contact:
URL: http://jira.jboss.org/jira/browse/JBE...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-09-02 08:26 UTC by mposolda
Modified: 2012-02-28 16:40 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
MySQL 5.1, local-tx-datasource configured with MySQL
Last Closed: 2011-09-02 09:20:13 UTC
Type: Bug


Attachments (Terms of Use)
exception-indexing.txt (44.70 KB, text/plain)
2011-09-02 08:27 UTC, mposolda
no flags Details


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 794076 0 high CLOSED Backwards compatibility failing with MySQL 2021-02-22 00:41:40 UTC
Red Hat Issue Tracker JBEPP-1144 0 None None None Never

Internal Links: 794076

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



Note You need to log in before you can comment on or make changes to this bug.