Project

General

Profile

Bug #14056

Cannot modify groups when workflow are enabled

Added by Nicolas CHARLES over 1 year ago. Updated over 1 year ago.

Status:
Released
Priority:
N/A
Category:
Web - Config management
Target version:
Severity:
Major - prevents use of part of Rudder | no simple workaround
User visibility:
Operational - other Techniques | Rudder settings | Plugins
Effort required:
Priority:
84
Tags:

Description

When creating a change request, it fails with the error message

There was problem with your request.
could not save change request Save Group XXXX <- Couldn't find newly created entry when saving Change Request

in the postgresql logs, we have

2018-12-28 16:26:55 CET [2905-189] rudder@rudder LOG:  execute S_1: COMMIT
2018-12-28 16:26:57 CET [2905-190] rudder@rudder LOG:  execute S_3: BEGIN
2018-12-28 16:26:57 CET [2905-191] rudder@rudder LOG:  execute <unnamed>: insert into ChangeRequest (name, description, creationTime, content, modificationId) values ($1, $2, $3, $4, $5)
    RETURNING "id" 
2018-12-28 16:26:57 CET [2905-192] rudder@rudder DETAIL:  parameters: $1 = 'Save Group XXXXXX', $2 = '', $3 = '2018-12-28 16:26:57.616+01', $4 = '<changeRequest fileFormat="6"><groups><group id="4c395876-db0b-4cd2-b48c-a370a1e56f11"><initialState><nodeGroup fileFormat="6"><id>6b536c1a-4389-4aca-b5bb-156f87da37bb)</id><displayName>nXXXXXXXXX</displayName><description></description><query>{&quot;select&quot;:&quot;node&quot;,&quot;composition&quot;:&quot;And&quot;,&quot;where&quot;:[]}</query><isDynamic>true</isDynamic><nodeIds/><isEnabled>true</isEnabled><isSystem>false</isSystem></nodeGroup></initialState><firstChange><change><actor>admin</actor><date>2018-12-28T16:26:51.515+01:00</date><reason></reason><diff action="modifyTo"><nodeGroup fileFormat="6"><id>6b536c1a-4389-4aca-b5bb-156f87da37bb)</id><displayName>XXXXXXXXXX</displayName><description>xxxxxxx</description><query>{&quot;select&quot;:&quot;node&quot;,&quot;composition&quot;:&quot;And&quot;,&quot;where&quot;:[]}</query><isDynamic>true</isDynamic><nodeIds/><isEnabled>true</isEnabled><isSystem>false</isSystem></nodeGroup></diff></change></firstChange><nextChanges/></group></groups><directives/><rules/><globalParameters/></changeRequest>', $5 = ''
2018-12-28 16:26:57 CET [2905-193] rudder@rudder LOG:  execute S_6: ROLLBACK
2018-12-28 16:27:01 CET [2905-194] rudder@rudder LOG:  execute S_3: BEGIN
2018-12-28 16:27:01 CET [2905-195] rudder@rudder LOG:  execute <unnamed>: SELECT 1
2018-12-28 16:27:01 CET [2905-196] rudder@rudder LOG:  execute <unnamed>: SELECT id, name, description, creationTime, content, modificationId FROM ChangeRequest where id = $1
2018-12-28 16:27:01 CET [2905-197] rudder@rudder DETAIL:  parameters: $1 = '8'
2018-12-28 16:27:01 CET [2905-198] rudder@rudder LOG:  execute S_6: ROLLBACK
2018-12-28 16:27:01 CET [2905-199] rudder@rudder LOG:  execute S_3: BEGIN
2018-12-28 16:27:01 CET [2905-200] rudder@rudder LOG:  execute <unnamed>: SELECT CR.id

manually executing the query succeed.

reverting the change in #13582 solves the issue (setting query to auto commit)


Related issues

Related to Rudder - Bug #13582: Hikari pool autocomit configuration is incorrect, which can impact performanceReleasedNicolas CHARLESActions

Also available in: Atom PDF