You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@manifoldcf.apache.org by "Karl Wright (Jira)" <ji...@apache.org> on 2021/07/06 19:53:00 UTC
[jira] [Commented] (CONNECTORS-1670) PostgreSQL: transaction in
progress
[ 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)