Mistral

expiration_policy does not work with mysql/mariadb with max_finished_executions

Bug #1712585 reported by Kupai József on 2017-08-23

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	Mistral	Fix Released	Medium	Kupai József	Mistral queens-1 "q1"

Bug Description

These are the requirements to reproduce this bug:
- configure expiration policy
- set max_finished_executions to a value greater than 0 (zero is the default)
- use mysql/mariadb

The expiration policy will fail in every iteration with this error:
NotSupportedError: (1235, "This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'")

https://mariadb.com/kb/en/the-mariadb-library/subquery-limitations/#limit

Tags:

Kupai József (kupsef) on 2017-08-23

Changed in mistral:
assignee:	nobody → Kupai József (kupsef)

Revision history for this message

OpenStack Infra (hudson-openstack) wrote on 2017-08-23: Fix proposed to mistral (master)

Fix proposed to branch: master
Review: https://review.openstack.org/496721

Changed in mistral:
status:	New → In Progress

Lingxian Kong (kong) on 2017-08-23

Changed in mistral:
importance:	Undecided → Medium
milestone:	none → queens-1

Revision history for this message

OpenStack Infra (hudson-openstack) wrote on 2017-09-21: Fix merged to mistral (master)

Reviewed: https://review.openstack.org/496721
Committed: https://git.openstack.org/cgit/openstack/mistral/commit/?id=5c0b720da273b6f5a4437056e5b3309c2253271f
Submitter: Jenkins
Branch: master

commit 5c0b720da273b6f5a4437056e5b3309c2253271f
Author: Kupai József <email address hidden>
Date: Mon Sep 18 16:05:15 2017 +0200

Removed NOT IN query from expiration policy.

NOT IN subquery with limit is not supported by some databases.

Closes-bug: #1712585
Change-Id: Ieeb6629cc6c2fc0794ac9a0ef731816c2b6ea59b

Changed in mistral:
status:	In Progress → Fix Released

Revision history for this message

OpenStack Infra (hudson-openstack) wrote on 2017-10-09: Fix proposed to mistral (stable/pike)

Fix proposed to branch: stable/pike
Review: https://review.openstack.org/510582

Revision history for this message

OpenStack Infra (hudson-openstack) wrote on 2017-10-10: Fix merged to mistral (stable/pike)

Reviewed: https://review.openstack.org/510582
Committed: https://git.openstack.org/cgit/openstack/mistral/commit/?id=902b38d51cda2996b4d514974ce5d34f364dd1c7
Submitter: Jenkins
Branch: stable/pike

commit 902b38d51cda2996b4d514974ce5d34f364dd1c7
Author: Kupai József <email address hidden>
Date: Mon Sep 18 16:05:15 2017 +0200

Removed NOT IN query from expiration policy.

NOT IN subquery with limit is not supported by some databases.

    Closes-bug: #1712585
    Change-Id: Ieeb6629cc6c2fc0794ac9a0ef731816c2b6ea59b
    (cherry picked from commit 5c0b720da273b6f5a4437056e5b3309c2253271f)