Meaning of below statement

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Meaning of below statement

Srinivasa T N
Hi,
   I have the following in my log files:

2020-11-20 11:20:46.216 IST [38207] LOG: execute S_1/C_2: SELECT "gid",encode(ST_AsBinary(ST_Simplify(ST_Force2D("shape"), 14.929338247701526, true)),'base64') as "shape" FROM "ami_smart_new"."aoi_boundary" WHERE ("sectioncode" IN ('4683', '4587') AND "sectioncode" IS NOT NULL AND "shape" && ST_GeomFromText('POLYGON ((683696.123647752 989199.9990667417, 683696.123647752 1000723.135701899, 708574.8226023088 1000723.135701899, 708574.8226023088 989199.9990667417, 683696.123647752 989199.9990667417))', 32643))
2020-11-20 11:20:46.218 IST [38207] LOG: execute S_3: ROLLBACK

Does it mean that there was an error in "SELECT ..." and hence internally postgres executed ROLLBACK??  

Regards,
Seenu.
Reply | Threaded
Open this post in threaded view
|

Re: Meaning of below statement

David G Johnston

On Friday, November 20, 2020, Srinivasa T N <[hidden email]> wrote:
Hi,
   I have the following in my log files:

2020-11-20 11:20:46.216 IST [38207] LOG: execute S_1/C_2: SELECT "gid",encode(ST_AsBinary(ST_Simplify(ST_Force2D("shape"), 14.929338247701526, true)),'base64') as "shape" FROM "ami_smart_new"."aoi_boundary" WHERE ("sectioncode" IN ('4683', '4587') AND "sectioncode" IS NOT NULL AND "shape" && ST_GeomFromText('POLYGON ((683696.123647752 989199.9990667417, 683696.123647752 1000723.135701899, 708574.8226023088 1000723.135701899, 708574.8226023088 989199.9990667417, 683696.123647752 989199.9990667417))', 32643))
2020-11-20 11:20:46.218 IST [38207] LOG: execute S_3: ROLLBACK

Does it mean that there was an error in "SELECT ..." and hence internally postgres executed ROLLBACK??  


If there was an error you would see an error message.  Plus, PostgreSQL doesn’t just internally issue a rollback on its own.  That said I’m not sure what is being shown, or rather where the “execute” stuff comes from.

David J.

Reply | Threaded
Open this post in threaded view
|

Re: Meaning of below statement

Tim Clarke-3
On 20/11/2020 08:29, David G. Johnston wrote:

On Friday, November 20, 2020, Srinivasa T N <[hidden email]> wrote:
Hi,
   I have the following in my log files:

2020-11-20 11:20:46.216 IST [38207] LOG: execute S_1/C_2: SELECT "gid",encode(ST_AsBinary(ST_Simplify(ST_Force2D("shape"), 14.929338247701526, true)),'base64') as "shape" FROM "ami_smart_new"."aoi_boundary" WHERE ("sectioncode" IN ('4683', '4587') AND "sectioncode" IS NOT NULL AND "shape" && ST_GeomFromText('POLYGON ((683696.123647752 989199.9990667417, 683696.123647752 1000723.135701899, 708574.8226023088 1000723.135701899, 708574.8226023088 989199.9990667417, 683696.123647752 989199.9990667417))', 32643))
2020-11-20 11:20:46.218 IST [38207] LOG: execute S_3: ROLLBACK

Does it mean that there was an error in "SELECT ..." and hence internally postgres executed ROLLBACK??  


If there was an error you would see an error message.  Plus, PostgreSQL doesn’t just internally issue a rollback on its own.  That said I’m not sure what is being shown, or rather where the “execute” stuff comes from.

David J.


Given that PostgreSQL isn't throwing the error, I'd suggest the rollback is from a decision in the front-end application layer.


Tim Clarke MBCS
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420

 

Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 | Frankfurt: +49 (0)69 7191 6000 | Hong Kong: +852 5803 1687 | Toronto: +1 647 503 2848
Web: https://www.manifest.co.uk/

 

Minerva Analytics Ltd - A Solactive Company
9 Freebournes Court | Newland Street | Witham | Essex | CM8 2BL | United Kingdom


Copyright: This e-mail may contain confidential or legally privileged information. If you are not the named addressee you must not use or disclose such information, instead please report it to [hidden email]
Legal: Minerva Analytics is the trading name of: Minerva Analytics Ltd: Registered in England Number 11260966 & The Manifest Voting Agency Ltd: Registered in England Number 2920820 Registered Office at above address. Please Click Here https://www.manifest.co.uk/legal/ for further information.

Reply | Threaded
Open this post in threaded view
|

Re: Meaning of below statement

Tom Lane-2
In reply to this post by David G Johnston
"David G. Johnston" <[hidden email]> writes:
> On Friday, November 20, 2020, Srinivasa T N <[hidden email]> wrote:
>> 2020-11-20 11:20:46.218 IST [38207] LOG: execute S_3: ROLLBACK

> If there was an error you would see an error message.  Plus, PostgreSQL
> doesn’t just internally issue a rollback on its own.  That said I’m not
> sure what is being shown, or rather where the “execute” stuff comes from.

The "execute" says this is an execution of a previously prepared query,
ie the client is using extended query protocol rather than simple.
It's got nothing much to do with the semantics though.  It seems clear
that the client chose to roll back the transaction; the server did not
do that.

                        regards, tom lane