[ https://issues.apache.org/jira/browse/CONNECTORS-1670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17375979#comment-17375979 ]
Karl Wright commented on CONNECTORS-1670: ----------------------------------------- It's not clear that this is anything other than a warning. There may be a way to turn it off, if so. > PostgreSQL: transaction in progress > ----------------------------------- > > Key: CONNECTORS-1670 > URL: https://issues.apache.org/jira/browse/CONNECTORS-1670 > Project: ManifoldCF > Issue Type: Bug > Components: Framework core > Affects Versions: ManifoldCF 2.19 > Reporter: Uwe Wolfinger > Priority: Major > > We recently upgraded Manifold version to 2.19 and PostgreSQL version to 12.5. > So far everything worked fine, except some warnings within the database (row > 13): > 1: 2021-07-06 08:51:46.366 CEST-1013441-172.16.172.133(45412)-xxxxxxx: LOG: > Execute <unnamed>: START TRANSACTION > 2: 2021-07-06 08:51:46.366 CEST-1013441-172.16.172.133(45412)-xxxxxxx: LOG: > Execute S_38: SELECT id,status,connectionname FROM jobs WHERE > assessmentstate=$1 FOR UPDATE > 3: 2021-07-06 08:51:46.366 CEST-1013441-172.16.172.133(45412)-xxxxxxx: > DETAIL: Parameter: $1 = 'N' > 4: 2021-07-06 08:51:46.367 CEST-1013441-172.16.172.133(45412)-xxxxxxx: LOG: > Execute S_39: SELECT transformationname FROM jobpipelines WHERE ownerid=$1 > AND transformationname IS NOT NULL > 5:2021-07-06 08:51:46.367 CEST-1013441-172.16.172.133(45412)-xxxxxxx: > DETAIL: Parameter: $1 = '1615294637875' > 6:2021-07-06 08:51:46.368 CEST-1013441-172.16.172.133(45412)-xxxxxxx: LOG: > Execute S_40: SELECT outputname FROM jobpipelines WHERE ownerid=$1 AND > outputname IS NOT NULL > 7:2021-07-06 08:51:46.368 CEST-1013441-172.16.172.133(45412)-xxxxxxx: > DETAIL: Parameter: $1 = '1615294637875' > 8:2021-07-06 08:51:46.369 CEST-10134 > 9:2021-07-06 08:55:02.148 CEST-1012399-172.16.172.133(45330)-xxxxxxx: LOG: > Execute <unnamed>: START TRANSACTION > 10:2021-07-06 08:55:02.149 CEST-1012399-172.16.172.133(45330)-xxxxxxx: LOG: > Execute S_4: SELECT id,lasttime,status,startmethod,connectionname FROM jobs > WHERE (status=$1 OR status=$2 OR status=$3 OR status=$4 OR status=$5) AND > startmethod!=$6 FOR UPDATE > 11:2021-07-06 08:55:02.149 CEST-1012399-172.16.172.133(45330)-xxxxxxx: > DETAIL: Parameter: $1 = 'N', $2 = 'W', $3 = 'w', $4 = 'Z', $5 = 'z', $6 = 'D' > 12:2021-07-06 08:55:02.151 CEST-1012399-172.16.172.133(45330)-xxxxxxx: LOG: > Execute <unnamed>: START TRANSACTION > 13:2021-07-06 08:55:02.151 CEST-1012399-172.16.172.133(45330)-xxxxxxx: > WARNING: there is already a transaction in progress > 14:2021-07-06 08:55:02.153 CEST-1012399-172.16.172.133(45330)-xxxxxxx: LOG: > execute S_14: SELECT * FROM schedules WHERE ownerid=$1 ORDER BY ordinal ASC > 15:2021-07-06 08:55:02.153 CEST-1012399-172.16.172.133(45330)-xxxxxxx: > DETAIL: Parameter: $1 = > as we can see a new transaction ist startet in row 9 and then another one in > row 12, which causes the warning in row 13. The reason for this seems, that > the first transaction is not terminated when the second one starts. I tried > to look up the code in the source, but i couldnt find the right location. > Has anyone else encountered the behaviour or know, where to lookup the > location in the source code? -- This message was sent by Atlassian Jira (v8.3.4#803005)