It's all about the answers!

Ask a question

CQConnector loses connection to CQ after backup


Kyle Christianson (1261615) | asked Sep 01 '10, 9:33 a.m.
We have weekly and nightly backup outages scheduled for our CQ databases. When a CQ database is taken down, the CQConnector gateway loses connection to the database. When the CQ database comes back up the CQConnector gateway should reconnect to the database but it never does. Therefore we have to manually restart the CQConnector gateway to reestablish the connection. Is this a known issue or a defect? Is there a workaround?

I have copied the log below. You can see that the gateway lost connection at 7:03 and we restarted the gateway at 7:59.


29 Aug 2010 07:00:38,436 [CQ Interop Polling] DEBUG com.ibm.rational.interop.level2 - Using CQInteropEventHandler-STGC_TG/TECH-CQ Interop Polling
29 Aug 2010 07:00:38,436 [CQ Interop Polling] DEBUG com.ibm.rational.interop.level2 - Got handler for CQ Interop Polling
29 Aug 2010 07:00:38,448 [CQ Interop Polling] DEBUG com.ibm.rational.interop.level2 - Releasing CQInteropEventHandler-STGC_TG/TECH-CQ Interop Polling
29 Aug 2010 07:01:38,460 [CQ Interop Polling] DEBUG com.ibm.rational.interop.level2 - Using CQInteropEventHandler-STGC_TG/TECH-CQ Interop Polling
29 Aug 2010 07:01:38,460 [CQ Interop Polling] DEBUG com.ibm.rational.interop.level2 - Got handler for CQ Interop Polling
29 Aug 2010 07:01:38,465 [CQ Interop Polling] DEBUG com.ibm.rational.interop.level2 - Releasing CQInteropEventHandler-STGC_TG/TECH-CQ Interop Polling
29 Aug 2010 07:02:38,476 [CQ Interop Polling] DEBUG com.ibm.rational.interop.level2 - Using CQInteropEventHandler-STGC_TG/TECH-CQ Interop Polling
29 Aug 2010 07:02:38,476 [CQ Interop Polling] DEBUG com.ibm.rational.interop.level2 - Got handler for CQ Interop Polling
29 Aug 2010 07:02:38,481 [CQ Interop Polling] DEBUG com.ibm.rational.interop.level2 - Releasing CQInteropEventHandler-STGC_TG/TECH-CQ Interop Polling
29 Aug 2010 07:03:38,492 [CQ Interop Polling] DEBUG com.ibm.rational.interop.level2 - Using CQInteropEventHandler-STGC_TG/TECH-CQ Interop Polling
29 Aug 2010 07:03:38,492 [CQ Interop Polling] DEBUG com.ibm.rational.interop.level2 - Got handler for CQ Interop Polling
29 Aug 2010 07:03:38,496 [CQ Interop Polling] DEBUG com.ibm.rational.interop.level2 - The CQRepository has become unusable. Allocating a new one
29 Aug 2010 07:03:38,625 [CQ Interop Polling] INFO com.ibm.rational.interop.level2 - Pausing before trying to reset the CQ database connection
29 Aug 2010 07:04:38,636 [CQ Interop Polling] DEBUG com.ibm.rational.interop.level2 - Getting Team Provider for STGC_TG/TECH login: stgconn
29 Aug 2010 07:59:39,904 [Start Level Event Dispatcher] INFO com.ibm.rational.interop.level2 - CRRTC4562I: temp dir is: /home/jazz/2.0.0.2ifix1/cqconnector/jazz/connectors/gat
eway/tomcat/temp/interop
29 Aug 2010 07:59:39,909 [Start Level Event Dispatcher] INFO com.ibm.rational.interop.level1 - CRRTC4552I: The gateway is now only accepting setup requests
29 Aug 2010 07:59:39,921 [Start Level Event Dispatcher] DEBUG com.ibm.rational.interop.level1 - Jazz Interop server is: jazz07.rchland.ibm.com(10443)
29 Aug 2010 07:59:39,921 [Start Level Event Dispatcher] DEBUG com.ibm.rational.interop.level1 - Logging in as stgconn
29 Aug 2010 07:59:41,445 [Start Level Event Dispatcher] DEBUG com.ibm.rational.interop.level2 - Stage label of CQ: 7.1.1.D091201A
29 Aug 2010 07:59:41,445 [Start Level Event Dispatcher] DEBUG com.ibm.rational.interop.level2 - CQ Provider (JNI) Version is: 711
29 Aug 2010 07:59:41,445 [Start Level Event Dispatcher] DEBUG com.ibm.rational.interop.level2 - CM API Version is: 71
29 Aug 2010 07:59:41,445 [Start Level Event Dispatcher] DEBUG com.ibm.rational.interop.level2 - CQ Version Info is: 71
29 Aug 2010 07:59:41,451 [Start Level Event Dispatcher] DEBUG com.ibm.rational.interop.level2 - Getting Team Provider for STGC_TG/TECH login: stgconn
29 Aug 2010 08:01:09,791 [Start Level Event Dispatcher] INFO com.ibm.rational.interop.level2 - CRRTC4562I: temp dir is: /home/jazz/2.0.0.2ifix1/cqconnector/jazz/connectors/gat
eway/tomcat/temp/interop
29 Aug 2010 08:01:09,794 [Start Level Event Dispatcher] INFO com.ibm.rational.interop.level1 - CRRTC4552I: The gateway is now only accepting setup requests
29 Aug 2010 08:01:09,819 [Start Level Event Dispatcher] DEBUG com.ibm.rational.interop.level1 - Jazz Interop server is: jazz07.rchland.ibm.com(10443)
29 Aug 2010 08:01:09,819 [Start Level Event Dispatcher] DEBUG com.ibm.rational.interop.level1 - Logging in as stgconn
29 Aug 2010 08:01:11,139 [Start Level Event Dispatcher] DEBUG com.ibm.rational.interop.level2 - Stage label of CQ: 7.1.1.D091201A
29 Aug 2010 08:01:11,140 [Start Level Event Dispatcher] DEBUG com.ibm.rational.interop.level2 - CQ Provider (JNI) Version is: 711
29 Aug 2010 08:01:11,140 [Start Level Event Dispatcher] DEBUG com.ibm.rational.interop.level2 - CM API Version is: 71
29 Aug 2010 08:01:11,140 [Start Level Event Dispatcher] DEBUG com.ibm.rational.interop.level2 - CQ Version Info is: 71
29 Aug 2010 08:01:11,145 [Start Level Event Dispatcher] DEBUG com.ibm.rational.interop.level2 - Getting Team Provider for STGC_TG/TECH login: stgconn
29 Aug 2010 08:02:43,873 [Start Level Event Dispatcher] DEBUG com.ibm.rational.interop.level2 - Allocating an admin session for STGC_TG/TECH thread name: Start Level Event Disp
atcher
29 Aug 2010 08:02:43,874 [Start Level Event Dispatcher] DEBUG com.ibm.rational.interop.level2 - Allocating another (1) static CQ Interop handler Start Level Event Dispatcher
29 Aug 2010 08:02:43,874 [Start Level Event Dispatcher] DEBUG com.ibm.rational.interop.level2 - Using CQInteropEventHandler-STGC_TG/TECH-Start Level Event Dispatcher
29 Aug 2010 08:03:14,431 [Start Level Event Dispatcher] DEBUG com.ibm.rational.interop.level2 - Number of record types: 92
29 Aug 2010 08:03:14,476 [Start Level Event Dispatcher] DEBUG com.ibm.rational.interop.level2 - Processed (1) ServerConnection
29 Aug 2010 08:03:15,132 [Start Level Event Dispatcher] DEBUG com.ibm.rational.interop.level2 - Processed (2) Defect
29 Aug 2010 08:03:15,166 [Start Level Event Dispatcher] DEBUG com.ibm.rational.interop.level2 - Processed (3) VerifyRecord
29 Aug 2010 08:03:15,181 [Start Level Event Dispatcher] DEBUG com.ibm.rational.interop.level2 - Processed (4) Attachment



Kyle Christianson
IBM STG Rational Solutions Team

4 answers



permanent link
Lorelei Ngooi (1.5k22) | answered Sep 01 '10, 10:52 a.m.
JAZZ DEVELOPER
I found this work item, https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/47027, but obviously it's not working. If you are running the CQ gateway as a windows service, then maybe you can write a script that starts the CQ gateway when the CQ database comes back up.

permanent link
Kyle Christianson (1261615) | answered Sep 02 '10, 9:28 a.m.
We are running all our gateways on Linux and planing to write reoccurring cron jobs to restart the gateways. Nevertheless, this is still a defect and would be nice to have fixed. Would you like me to submit a new defect for this?

permanent link
Lorelei Ngooi (1.5k22) | answered Sep 02 '10, 11:57 a.m.
JAZZ DEVELOPER
Please submit a defect.

permanent link
Kyle Christianson (1261615) | answered Sep 03 '10, 12:11 p.m.
Please submit a defect.


Submitted Defect https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=129372

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.