It's all about the answers!

Ask a question

Triple index and text index reindex


Benjamin Chodroff (8985131) | asked Mar 10 '11, 5:05 p.m.
I am seeing these two warnings in my jazz.log. Can somebody explain what they are, what are the implications, and how to resolve it?

2011-03-10 15:13:19,463 [ http-443-Processor20] WARN com.ibm.team.jfs - CRJZS5460E Triple index is ahead of the database, a full reindex is needed to recover
2011-03-10 15:13:19,513 [ http-443-Processor20] WARN com.ibm.team.jfs - CRJZS5459E Text index is ahead of the database, a full reindex is needed to recover


I ran this:

./repotools-jts.sh -rebuildIndices;./repotools-jts.sh -rebuildTextIndices;./repotools-jts.sh -reindex;./repotools-jazz.sh -rebuildIndices;./repotools-jazz.sh -rebuildTextIndices;./repotools-jazz.sh -reindex


Here is the output:

Repo Tools
Provisioning using "./conf/jts/provision_profiles".
Jazz Foundation - Core Libraries, Version 3.0 (RJF-I20101112-0630)

CRJAZ1363I Loading the configuration from "file:conf/jts/teamserver.properties".
CRJAZ1779I This server is configured as a JTS.
CRJAZ1365I The server is attempting to connect to the following database: "//localhost:50003/JTS:user=xxxxxxxx;password=xxxxxxxx;"
CRJAZ1364I The connection to the following database was successful:
Db Product Name: DB2/LINUX
Db Product Version: SQL09071
Db URL: jdbc:db2://localhost:50003/JTS:user=xxxxxxxx;password=xxxxxxxx;
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.57.82
CRJAZ8192I: Fulltext Index Location: /opt/IBM/JazzTeamServer3/server/conf/jts/indices/workitemindex/fulltext_index
Rebuilding the indices for the database "//localhost:50003/JTS:user=xxxxxxxx;password=xxxxxxxx;".
Rebuilt the indices for the database "//localhost:50003/JTS:user=xxxxxxxx;password=xxxxxxxx;".
Repo Tools
Provisioning using "./conf/jts/provision_profiles".
Jazz Foundation - Core Libraries, Version 3.0 (RJF-I20101112-0630)

CRJAZ1363I Loading the configuration from "file:conf/jts/teamserver.properties".
CRJAZ1779I This server is configured as a JTS.
CRJAZ1365I The server is attempting to connect to the following database: "//localhost:50003/JTS:user=xxxxxxxx;password=xxxxxxxx;"
CRJAZ1364I The connection to the following database was successful:
Db Product Name: DB2/LINUX
Db Product Version: SQL09071
Db URL: jdbc:db2://localhost:50003/JTS:user=xxxxxxxx;password=xxxxxxxx;
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.57.82
CRJAZ8192I: Fulltext Index Location: /opt/IBM/JazzTeamServer3/server/conf/jts/indices/workitemindex/fulltext_index
The user "ADMIN" has logged in to the database "//localhost:50003/JTS:user=xxxxxxxx;password=xxxxxxxx;".
Running pre-rebuild index for "Fulltext"...
CRJAZ8240W: Index Directory not found or not existing (/opt/IBM/JazzTeamServer3/server/conf/jts/indices/workitemindex/fulltext_index)
Rebuilding "Fulltext" indices...
The user "ADMIN" has logged out of the database "//localhost:50003/JTS:user=xxxxxxxx;password=xxxxxxxx;".
Repo Tools
Provisioning using "./conf/jts/provision_profiles".
Jazz Foundation - Core Libraries, Version 3.0 (RJF-I20101112-0630)

CRJAZ1363I Loading the configuration from "file:conf/jts/teamserver.properties".
CRJAZ1779I This server is configured as a JTS.
CRJAZ1365I The server is attempting to connect to the following database: "//localhost:50003/JTS:user=xxxxxxxx;password=xxxxxxxx;"
CRJAZ1364I The connection to the following database was successful:
Db Product Name: DB2/LINUX
Db Product Version: SQL09071
Db URL: jdbc:db2://localhost:50003/JTS:user=xxxxxxxx;password=xxxxxxxx;
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.57.82
CRJAZ8192I: Fulltext Index Location: /opt/IBM/JazzTeamServer3/server/conf/jts/indices/workitemindex/fulltext_index
The user "ADMIN" has logged in to the database "//localhost:50003/JTS:user=xxxxxxxx;password=xxxxxxxx;".
CRJZS5170I Reindexing resources from database //localhost:50003/JTS:user=xxxxxxxx;password=xxxxxxxx;
The user "ADMIN" has logged out of the database "//localhost:50003/JTS:user=xxxxxxxx;password=xxxxxxxx;".
Repo Tools
Provisioning using "./conf/jazz/provision_profiles".
Change and Configuration Management - Core Libraries, Version 3.0 (RTC-I20101112-1731)
Jazz Foundation - Core Libraries, Version 3.0 (RJF-I20101112-0630)

CRJAZ1363I Loading the configuration from "file:conf/jazz/teamserver.properties".
CRJAZ1778I This server is configured as an application.
CRJAZ1365I The server is attempting to connect to the following database: "//localhost:50003/CCM:user=xxxxxxxx;password=xxxxxxxx;"
CRJAZ1364I The connection to the following database was successful:
Db Product Name: DB2/LINUX
Db Product Version: SQL09071
Db URL: jdbc:db2://localhost:50003/CCM:user=xxxxxxxx;password=xxxxxxxx;
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.57.82
CRJAZ8192I: Fulltext Index Location: /opt/IBM/JazzTeamServer3/server/conf/jazz/indices/workitemindex/fulltext_index
Rebuilding the indices for the database "//localhost:50003/CCM:user=xxxxxxxx;password=xxxxxxxx;".
Rebuilt the indices for the database "//localhost:50003/CCM:user=xxxxxxxx;password=xxxxxxxx;".
Repo Tools
Provisioning using "./conf/jazz/provision_profiles".
Change and Configuration Management - Core Libraries, Version 3.0 (RTC-I20101112-1731)
Jazz Foundation - Core Libraries, Version 3.0 (RJF-I20101112-0630)

CRJAZ1363I Loading the configuration from "file:conf/jazz/teamserver.properties".
CRJAZ1778I This server is configured as an application.
CRJAZ1365I The server is attempting to connect to the following database: "//localhost:50003/CCM:user=xxxxxxxx;password=xxxxxxxx;"
CRJAZ1364I The connection to the following database was successful:
Db Product Name: DB2/LINUX
Db Product Version: SQL09071
Db URL: jdbc:db2://localhost:50003/CCM:user=xxxxxxxx;password=xxxxxxxx;
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.57.82
CRJAZ8192I: Fulltext Index Location: /opt/IBM/JazzTeamServer3/server/conf/jazz/indices/workitemindex/fulltext_index
The user "ADMIN" has logged in to the database "//localhost:50003/CCM:user=xxxxxxxx;password=xxxxxxxx;".
Running pre-rebuild index for "Work Item"...
Running pre-rebuild index for "Agile Planning"...
Running pre-rebuild index for "Fulltext"...
Rebuilding "Work Item" indices...
Can not create a URIReference for a work item
CRRTC0182E: Error while indexing page
Can not create a URIReference for a work item
Can not create a URIReference for a work item
CRRTC0182E: Error while indexing page
Error indexing work items . See the log file "/opt/IBM/JazzTeamServer3/server/repotools-jazz_rebuildTextIndices.log" for details.
CRRTC0182E: Error while indexing page null argument:CRJAZ8181E: Artifact's ID must not be null.. See the log file "/opt/IBM/JazzTeamServer3/server/repotools-jazz_rebuildTextIndices.log" for details.
CRRTC0182E: Error while indexing page null argument:CRJAZ8181E: Artifact's ID must not be null.. See the log file "/opt/IBM/JazzTeamServer3/server/repotools-jazz_rebuildTextIndices.log" for details.
Rebuilding "Agile Planning" indices...
Rebuilding "Fulltext" indices...
The user "ADMIN" has logged out of the database "//localhost:50003/CCM:user=xxxxxxxx;password=xxxxxxxx;".
Repo Tools
Provisioning using "./conf/jazz/provision_profiles".
Change and Configuration Management - Core Libraries, Version 3.0 (RTC-I20101112-1731)
Jazz Foundation - Core Libraries, Version 3.0 (RJF-I20101112-0630)

CRJAZ1363I Loading the configuration from "file:conf/jazz/teamserver.properties".
CRJAZ1778I This server is configured as an application.
CRJAZ1365I The server is attempting to connect to the following database: "//localhost:50003/CCM:user=xxxxxxxx;password=xxxxxxxx;"
CRJAZ1364I The connection to the following database was successful:
Db Product Name: DB2/LINUX
Db Product Version: SQL09071
Db URL: jdbc:db2://localhost:50003/CCM:user=xxxxxxxx;password=xxxxxxxx;
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.57.82
CRJAZ8192I: Fulltext Index Location: /opt/IBM/JazzTeamServer3/server/conf/jazz/indices/workitemindex/fulltext_index
The user "ADMIN" has logged in to the database "//localhost:50003/CCM:user=xxxxxxxx;password=xxxxxxxx;".
CRJZS5170I Reindexing resources from database //localhost:50003/CCM:user=xxxxxxxx;password=xxxxxxxx;
The user "ADMIN" has logged out of the database "//localhost:50003/CCM:user=xxxxxxxx;password=xxxxxxxx;".


As you can see, there are some errors. Should I contact support?

4 answers



permanent link
Philippe Mulet (55112) | answered Mar 31 '11, 5:15 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
The original warning is supposed to be issued in the event an administrator did restore an older DB backup, but forgot to restore matching indexes (in which case the index is effectively ahead of the DB, and need to be recreated).

We found recently a couple cases where the warning would go out per mistake, even though the DB and the index are both in sync (see items listed below).

These issues will be addressed for CLM 3.0 (CCM 3.0.1, JTS 3.0.1) and unless you are restoring older DB backups, you can safely ignore it for now.
BTW - the repotools -reindex is all you need to run to recover here.

References:
https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/149533
https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/158879

permanent link
Benjamin Chodroff (8985131) | answered Mar 31 '11, 6:02 a.m.
Thanks!

permanent link
Work Item & UI Commons Team (1.3k1) | answered Mar 31 '11, 6:14 a.m.
Will take care of some extra logging to find out which work items cause this.

permanent link
Peter Eichelsheim (61) | answered Aug 09 '11, 10:06 a.m.
We are running into the same errors, but after performing the described backup procedure here on Jazz.net. So, Stop the indexing, create DB backup, resume indexing.

The following log entries take place when performing our backup process:
- CRJZS5350I Indexing: suspending ...
- CRJZS5349I Indexing: suspended
- CRJZS5348I Indexing: resuming ...
- CRJZS5459E Text index is ahead of the database, a full reindex is needed to recover
- CRJZS5347I Indexing: resumed
- CRJZS5106I Index consistency check processing 1 resources
- CRJZS5106I Index consistency check processing 0 resources
- CRJZS5107I Index consistency check : completed in 78 ms
- CRJZS5107I Index consistency check : completed in 93 ms

Between Indexing: suspended and Indexing: resuming... there is a 20 minute time frame where we perform the actual DB Backup.

Can we ignore this error as well?

Thanks and regards,

Peter

Your answer


Register or to post your answer.