repotools-jazz -addTables gets into deadlock (DB2 type)
Hi,
I'm trying to migrate a fairly large RTC repository (db is 17G) and on several tries a certain point is reached and proceeds no further. Monitoring the database shows that applications go into lock wait and never proceeds.
DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL09055"
with level identifier "06060107".
Informational tokens are "DB2 v9.5.0.5", "s091123", "U829462", and Fix Pack
"5".
2011-02-23 15:14:17,716 Change and Configuration Management - Core Libraries,
Version 3.0 (RTC-I20101112-1731)
Jazz Foundation - Core Libraries, Version 3.0 (RJF-I20101112-0630)
2011-02-23 15:14:17,736 CRJAZ1363I Loading the configuration from "file:conf/jazz/teamserver.properties".
2011-02-23 15:14:18,600 CRJAZ1781W The Public URI Root has not been set. Use the server setup wizard to enter the public URI. This property is required to enforce consistent URL management in the application. The public URI represents the URL that all clients must use to access the application.
2011-02-23 15:14:18,627 CRJAZ1778I This server is configured as an application.
2011-02-23 15:14:23,354 CRJAZ1365I The server is attempting to connect to the fo
llowing database: "//localhost:50000/RTCDB:user=xxxxxxxx;password=xxxxxxxx;"
2011-02-23 15:14:30,894 CRJAZ1364I The connection to the following database was
successful:
Db Product Name: DB2/AIX64
Db Product Version: SQL09055
Db URL: jdbc:db2://localhost:50000/RTCDB:user=xxxxxxxx;password=xxxxxxxx;
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.57.82
2011-02-23 15:14:33,270 CRJAZ8192I: Fulltext Index Location: /rtccode/JazzTeamServer_1/server/conf/jazz/indices/workitemindex/fulltext_index
2011-02-23 15:14:33,271 CRJAZ8190I: The fulltext index should point to an absolute directory but is currently set to 'conf/jazz/indices/workitemindex'
2011-02-23 15:14:44,206 Removing project move component...
2011-02-23 15:14:44,287 Removed project move component in 81 ms.
...
2011-02-23 15:15:06,269 CRJAZ1438I Model evolution: added new attribute "endDate" to class "com.ibm.team.apt.internal.common.resource.model.WorkResourceDetails
".
2011-02-23 15:15:06,269 CRJAZ1441I Model evolution: New server version record for "com.ibm.teami.scm".
2011-02-23 15:15:06,756 CRJAZ1442I Model evolution: server version record of "com.ibm.team.build" updated from "8" to "11".
2011-02-23 15:15:08,306 CRJAZ1439I Model evolution: added new collection attribute "configurationElements" to class "BuildEngine".
2011-02-23 15:15:09,500 CRJAZ1441I Model evolution: New server version record for "com.ibm.team.repository.auth".
2011-02-23 15:15:09,741 CRJAZ1441I Model evolution: New server version record for "com.ibm.teamz.supa.admin".
2011-02-23 15:15:09,799 CRJAZ1441I Model evolution: New server version record for "com.ibm.team.apt.plansnapshot".
2011-02-23 15:15:09,799 CRJAZ1441I Model evolution: New server version record for "com.ibm.team.repository.friends".
At this point I've killed the attempt. I have a statement capture but pasting it here doesn't seem to like this posting tool.
I've run the -reindex (under my RTC v2 configuration) to see if that eases this pain (it didn't). I started the -addTables yesterday afternoon and let it run overnight with no progress.
This is not my largest RTC v2 repository (it's an old copy of what is now the largest at >40Gb). I've got 17 RTC repositories of varying sizes and users have been asking "When will RTC be upgraded to V3?"
I did find one or two posts regarding the performance of this but none were similar to this.
I'm trying to migrate a fairly large RTC repository (db is 17G) and on several tries a certain point is reached and proceeds no further. Monitoring the database shows that applications go into lock wait and never proceeds.
DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL09055"
with level identifier "06060107".
Informational tokens are "DB2 v9.5.0.5", "s091123", "U829462", and Fix Pack
"5".
2011-02-23 15:14:17,716 Change and Configuration Management - Core Libraries,
Version 3.0 (RTC-I20101112-1731)
Jazz Foundation - Core Libraries, Version 3.0 (RJF-I20101112-0630)
2011-02-23 15:14:17,736 CRJAZ1363I Loading the configuration from "file:conf/jazz/teamserver.properties".
2011-02-23 15:14:18,600 CRJAZ1781W The Public URI Root has not been set. Use the server setup wizard to enter the public URI. This property is required to enforce consistent URL management in the application. The public URI represents the URL that all clients must use to access the application.
2011-02-23 15:14:18,627 CRJAZ1778I This server is configured as an application.
2011-02-23 15:14:23,354 CRJAZ1365I The server is attempting to connect to the fo
llowing database: "//localhost:50000/RTCDB:user=xxxxxxxx;password=xxxxxxxx;"
2011-02-23 15:14:30,894 CRJAZ1364I The connection to the following database was
successful:
Db Product Name: DB2/AIX64
Db Product Version: SQL09055
Db URL: jdbc:db2://localhost:50000/RTCDB:user=xxxxxxxx;password=xxxxxxxx;
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.57.82
2011-02-23 15:14:33,270 CRJAZ8192I: Fulltext Index Location: /rtccode/JazzTeamServer_1/server/conf/jazz/indices/workitemindex/fulltext_index
2011-02-23 15:14:33,271 CRJAZ8190I: The fulltext index should point to an absolute directory but is currently set to 'conf/jazz/indices/workitemindex'
2011-02-23 15:14:44,206 Removing project move component...
2011-02-23 15:14:44,287 Removed project move component in 81 ms.
...
2011-02-23 15:15:06,269 CRJAZ1438I Model evolution: added new attribute "endDate" to class "com.ibm.team.apt.internal.common.resource.model.WorkResourceDetails
".
2011-02-23 15:15:06,269 CRJAZ1441I Model evolution: New server version record for "com.ibm.teami.scm".
2011-02-23 15:15:06,756 CRJAZ1442I Model evolution: server version record of "com.ibm.team.build" updated from "8" to "11".
2011-02-23 15:15:08,306 CRJAZ1439I Model evolution: added new collection attribute "configurationElements" to class "BuildEngine".
2011-02-23 15:15:09,500 CRJAZ1441I Model evolution: New server version record for "com.ibm.team.repository.auth".
2011-02-23 15:15:09,741 CRJAZ1441I Model evolution: New server version record for "com.ibm.teamz.supa.admin".
2011-02-23 15:15:09,799 CRJAZ1441I Model evolution: New server version record for "com.ibm.team.apt.plansnapshot".
2011-02-23 15:15:09,799 CRJAZ1441I Model evolution: New server version record for "com.ibm.team.repository.friends".
At this point I've killed the attempt. I have a statement capture but pasting it here doesn't seem to like this posting tool.
I've run the -reindex (under my RTC v2 configuration) to see if that eases this pain (it didn't). I started the -addTables yesterday afternoon and let it run overnight with no progress.
This is not my largest RTC v2 repository (it's an old copy of what is now the largest at >40Gb). I've got 17 RTC repositories of varying sizes and users have been asking "When will RTC be upgraded to V3?"
I did find one or two posts regarding the performance of this but none were similar to this.