Purpose (problem description)
This page handle the issue of queries that run for an unexpected long time, you can observe this by comparing the query start time with the actual time, knowing that the state is active and there is no AIP component used. The following query list the queries in activity:
SELECT * FROM pg_stat_activity WHERE state = 'active'
Observed in CAST AIP
Release | Yes/No |
---|---|
8.2.x | |
8.1.x | |
8.0.x | |
Observed on RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 | |
Step by Step scenario
- Open RDBMS session
- Check quries status and query start time
Action Plan
- As a workaround you can abort the query, for example the abort operation under CSS is as follows:
- Get the pid of the query:
Figure 2 Abort the query that correspond to this pid:
SELECT Pg_cancel_backend (PID)
- Get the pid of the query:
- Check on which schema you are observing the issue, for this you have to read the query and get the schema name, then contact CAST Technical Support. with the following Relevant input
Relevant input
- Screenhot showing the issue
- All RDBMS log files, for example CSS logfiles are located as follows: <Program Files>\CAST\CASTStorageService2\db_data\pg_log
- If the issue ocurs on the central base:
- Deployed CAST CED AED and Restapi WAR folders
- Logs located under <Tomcat_Installation_dir>\logs
- CAST Support Tool (CST) - alias Sherlock export with the following options CAST Bases Checker, Export Logs, Export Configuration files, Export Computer Environment, Export CAST Bases Management Base, Knowledge Base, Central base, Export source code
- If the issue ocurs on the local or mngt base:
- CAST Support Tool (CST) - alias Sherlock export with the following options CAST Bases Checker, Export Logs, Export Configuration files, Export Computer Environment, Export CAST Bases Management Base, Knowledge Base, Central base, Export source code
- If the issue ocurs on the measurment schema:
- Logs located under <Tomcat_Installation_dir>\logs
- Deployed CAST AAD and Restapi WAR folders
- CAST Support Tool (CST) - alias Sherlock export with the following options CAST Bases Checker, Export Logs, Export Configuration files, Export Computer Environment, Export CAST Bases Central base, Measurement base
Notes/comments
Ticket # 9271
Related Pages