On Friday, November 20, 2020, Srinivasa T N <seenutn@xxxxxxxxx> 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: ROLLBACKDoes 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.
