[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Transactions starting with Cursor with Hold are not closing in database.
From: "Kumar, Mukesh" <MKumar () peabodyenergy ! com>
Date: 2022-02-25 13:06:23
Message-ID: CH0P221MB0474AA322E66CC888201BE54DE3E9 () CH0P221MB0474 ! NAMP221 ! PROD ! OUTLOOK ! COM
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Hi Team,
We are facing an issue with few of the transactions which are running from =
SAP end. Below is the case statement.
Issue -: We are seeing that , the session which are generated from SAP repo=
rt end to PostgreSQL Database, it starts with the "Open Cursor " Cursor Nam=
e " with Hold - Select * from abc' (Screenshot Attached)
The problem here is that , when any report runs from SAP end , and if it ta=
kes time to run into the database and cancelled from Application end , it k=
eeps running into the database till its end or indefinitely. Suppose they c=
ancel one report and runs that report again , there is another session whic=
h generated and previous one also run at the same time. Even after cancelli=
ng the report from application end.
There is one parameter which we are suspecting that at ODBC level , there i=
s option for Fetch/Declare we are using , so that can be an issue but we ar=
e not sure.
Please suggest if there is any parameter, we need to look in the conf file =
in order to resolve this issue as it acquires a locks on the table and prev=
ent it from modifying from other sessions or users.
Thanks and Regards,
Mukesh Kumar
[Attachment #5 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"> <head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Times New Roman",serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:199977840;
mso-list-type:hybrid;
mso-list-template-ids:774678712 1380061138 67698713 67698715 67698703 67698713 \
67698715 67698703 67698713 67698715;} @list l0:level1
{mso-level-text:%1>;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New \
Roman",serif">Hi Team, <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New \
Roman",serif"><o:p> </o:p></span></p> <p class="MsoNormal"><span \
style="font-size:12.0pt;font-family:"Times New Roman",serif">We are facing \
an issue with few of the transactions which are running from SAP end. Below is the \
case statement.<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="font-size:12.0pt;font-family:"Times New \
Roman",serif"><o:p> </o:p></span></p> <p class="MsoNormal"><span \
style="font-size:12.0pt;font-family:"Times New Roman",serif">Issue -: We \
are seeing that , the session which are generated from SAP report end to PostgreSQL \
Database, it starts with the “Open Cursor “ Cursor Name “ with Hold \
– Select
* from abc’ (Screenshot Attached)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New \
Roman",serif">The problem here is that , when any report runs from SAP end , and \
if it takes time to run into the database and cancelled from Application end , it \
keeps running into the database till its end or indefinitely. Suppose they cancel \
one report and runs that report again , there is another session which generated and \
previous one also run at the same time. Even after cancelling the report from \
application end.<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="font-size:12.0pt;font-family:"Times New \
Roman",serif"><o:p> </o:p></span></p> <p class="MsoNormal"><span \
style="font-size:12.0pt;font-family:"Times New Roman",serif">There is one \
parameter which we are suspecting that at ODBC level , there is option for \
Fetch/Declare we are using , so that can be an issue but we are not \
sure.<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="font-size:12.0pt;font-family:"Times New \
Roman",serif"><o:p> </o:p></span></p> <p class="MsoNormal"><span \
style="font-size:12.0pt;font-family:"Times New Roman",serif">Please suggest \
if there is any parameter, we need to look in the conf file in order to resolve this \
issue as it acquires a locks on the table and prevent it from modifying from other \
sessions or users.<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="font-size:12.0pt;font-family:"Times New \
Roman",serif"><o:p> </o:p></span></p> <p class="MsoNormal">Thanks and \
Regards, <o:p></o:p></p> <p class="MsoNormal">Mukesh Kumar<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>
["Capture.PNG" (image/png)]
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic