--
http://dotcms.com - Open Source Java Content Management
---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+unsubscribe@googlegroups.com.
To post to this group, send email to dot...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/7f67f67b-f4d4-4c60-8c32-697dc0fc1b3e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
So, very roughly, it seems like you are missing the stored proc that builds the list of records to index. I would make sure that the 1) the stored procedure exists on the remote environ (and all of the stored procedures) and 2) that the db user has the proper permissions on it. I know my nomenclature is off for Oracle but the ideas are the same.
On Wed, Aug 23, 2017 at 11:00 AM, Xander Steinmann <xan...@isaac.nl> wrote:
Hi all,I have a very strange issue in one of our environments. When running a reindex the reindex is blocked on 0% (I can see records in dist_reindex_journal), but when I copy the database to my local pc and run a reindex then it indexes without issues. What could be causing this reindexing problem? There are no errors in the logs...It's a dotCMS 3.7.1 with an Oracle DB.Kind regards,Xander
--
http://dotcms.com - Open Source Java Content Management
---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com.
To post to this group, send email to dot...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/7f67f67b-f4d4-4c60-8c32-697dc0fc1b3e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Also try clearing the Indices cache and/or restarting the bad node (clears memory cache for sure.)
We just recovered from a recent index issue ourselves.
Nathan I. Keiter
|
Lead Network Applications Programmer
|
Benefits Advisory Council Member
|
I.D.E.A Council Member
Gettysburg College | Information Technology | DataSystems
Campus Box 2453 | 300 North Washington Street | Gettysburg, PA 17325
Phone: 717.337.6993
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/06149507-e756-4a96-ae13-0845f674696e%40googlegroups.com.
--
http://dotcms.com - Open Source Java Content Management
---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+unsubscribe@googlegroups.com.
To post to this group, send email to dot...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/35e74b21-7333-42b3-8eed-174f53f5c4fa%40googlegroups.com.
Most likely the db restore is missing something imo
--
http://dotcms.com - Open Source Java Content Management
---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com.
To post to this group, send email to dot...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/ad5c3742-2408-4680-b7d2-0430941b5f98%40googlegroups.com.
In our experience, restarting dotCMS usually solves this kind of “errorless” index issue.
Our theory is something in the JVM memory relating to index cache gets corrupted occasionally, interfering with the index process. Oddly, dumping the caches won’t resolve it, only a fresh JVM instance.
Nathan I. Keiter
|
Lead Network Applications Programmer
|
Benefits Advisory Council Member
|
I.D.E.A Council Member
Gettysburg College | Information Technology | DataSystems
Campus Box 2453 | 300 North Washington Street | Gettysburg, PA 17325
Phone: 717.337.6993
From: dot...@googlegroups.com [mailto:dot...@googlegroups.com]
On Behalf Of Xander Steinmann
Sent: Wednesday, September 06, 2017 9:00 AM
To: dotCMS User Group
Subject: Re: [dotcms] Index blocked for some reason
Is there some class we can override to add logging of some sort? There must be an exception somewhere that is not logged...
Kind regards,
Xander
--
http://dotcms.com - Open Source Java Content Management
---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
dotcms+un...@googlegroups.com.
To post to this group, send email to dot...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/0f7adef1-ce2d-473e-81fa-9d1084b0c957%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/643894bbae074d29890ca3527352f994%40exch13c.ms.gettysburg.edu.
create or replace TYPE reindex_record AS OBJECT (
ID INTEGER,
INODE_TO_INDEX varchar2(36),
IDENT_TO_INDEX varchar2(36),
priority INTEGER,
dist_action INTEGER
)
This solved our headache. It was probably caused by a database restore or maybe an upgrade? We can't think of anything else.
Thanks all for the help!
Xander
Note: Why is the exception in https://github.com/dotCMS/core/blob/3.7.1/src/com/dotcms/journal/business/ESDistributedJournalFactoryImpl.java line 458 wrapped and not logged?