Murano environment with a large number of applications cannot be deployed.

Bug #1566306 reported by Anatolii Neliubin
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mirantis OpenStack
Status tracked in 10.0.x
10.0.x
Fix Committed
High
Alexander Tivelkov
7.0.x
Won't Fix
High
Alexey Stupnikov
8.0.x
Won't Fix
High
Alexey Stupnikov
9.x
Fix Released
High
Alexander Tivelkov

Bug Description

Detailed bug description:
 Murano environment with 19 applications got stuck during deployment process
Steps to reproduce:
 Add a large number of applications in a Murano environment and deploy it
Expected results:
 The environment should be deployed successfully
Actual result:
 The environment got stuck
Reproducibility:
 Personally I could not reproduce this bug since do not have enough hardware resources to launch a large number of applications.
Workaround:
 I presume that the error happens because the 'description' column in the tables 'environment' and 'session' is a TEXT datatype. The value that was inserted in this case is 70162 bytes long. As a workaround it might be useful to alter the tables and to set a MEDIUMTEXT datatype.
Impact:
  Customer cannot deploy large Murano environments
Description of the environment:
- Operation system: Ubuntu 14.04
- Versions of components: MOS 7.0
- Reference architecture:
- Network model: Neutron
- Related projects installed:
Additional information:
The log file is attached.

Upstream bug: https://bugs.launchpad.net/murano/+bug/1567863

Revision history for this message
Anatolii Neliubin (aneliubin) wrote :
Revision history for this message
Dina Belova (dbelova) wrote :

MOS-murano team, please take a look. it the bug is in fact related to the DB scheme that's won't be easy to fix it in previous releases. Please provide a workaround for customers.

Changed in mos:
assignee: nobody → MOS Murano (mos-murano)
milestone: none → 7.0-updates
importance: Undecided → High
status: New → Confirmed
Revision history for this message
Anatolii Neliubin (aneliubin) wrote :

Sorry, made a mistake. The Murano system administrator had an environment with 19 applications initially. Then he decided to add four more applications and to deploy the modified environment.

Stan Lagun (slagun)
description: updated
Dina Belova (dbelova)
tags: added: area-murano
Revision history for this message
Fuel Devops McRobotson (fuel-devops-robot) wrote : Fix proposed to openstack/murano (openstack-ci/fuel-8.0/liberty)

Fix proposed to branch: openstack-ci/fuel-8.0/liberty
Change author: Alexander Tivelkov <email address hidden>
Review: https://review.fuel-infra.org/19695

Revision history for this message
Fuel Devops McRobotson (fuel-devops-robot) wrote : Fix proposed to openstack/murano (openstack-ci/fuel-7.0/2015.1.0)

Fix proposed to branch: openstack-ci/fuel-7.0/2015.1.0
Change author: Alexander Tivelkov <email address hidden>
Review: https://review.fuel-infra.org/19696

Revision history for this message
Fuel Devops McRobotson (fuel-devops-robot) wrote : Fix merged to openstack/murano (9.0/mitaka)

Reviewed: https://review.fuel-infra.org/19691
Submitter: Pkgs Jenkins <email address hidden>
Branch: 9.0/mitaka

Commit: b15adb14c4fc32233b572fb979f97ef5ff18f897
Author: Alexander Tivelkov <email address hidden>
Date: Fri Apr 15 12:04:40 2016

Increased the size of TEXT columns to store large object models

Object model is stored in database in the columns of type TEXT. In
MySQL database this type of column is limited by default and cannot
hold data structures which are large enough.

This patch adds an extra migration which alters appropriate columns in
database when the mysql is used. The column type is explicitly set to
LONGTEXT.

Change-Id: Ic04fb99469edc087cc12d4c78a983484ae49a6c1
Closes-bug: #1566306

Revision history for this message
Alex Kholkin (akholkin) wrote :

QA team cannot vetify this bug due to insufficient resources.

tags: added: scale
Revision history for this message
Alexey Stupnikov (astupnikov) wrote :

Closing this bug as Won't Fix for MOS7 and MOS8, since as per [1] it is completely forbidden to change DB schemas in stable branches.
[1] http://docs.openstack.org/project-team-guide/stable-branches.html

tags: added: wontfix-risky
Revision history for this message
Alexey Stupnikov (astupnikov) wrote :

This bug will be documented as a known issue with a workaround based on ALTER TABLE.

Revision history for this message
Fuel Devops McRobotson (fuel-devops-robot) wrote : Change abandoned on openstack/murano (openstack-ci/fuel-8.0/liberty)

Change abandoned by Alexey Stupnikov <email address hidden> on branch: openstack-ci/fuel-8.0/liberty
Review: https://review.fuel-infra.org/19695
Reason: It is forbidden to change DB schemas in stable branches.
http://docs.openstack.org/project-team-guide/stable-branches.html

Revision history for this message
Fuel Devops McRobotson (fuel-devops-robot) wrote : Change abandoned on openstack/murano (openstack-ci/fuel-7.0/2015.1.0)

Change abandoned by Alexey Stupnikov <email address hidden> on branch: openstack-ci/fuel-7.0/2015.1.0
Review: https://review.fuel-infra.org/19696
Reason: It is forbidden to change DB schemas in stable branches.
http://docs.openstack.org/project-team-guide/stable-branches.html

Revision history for this message
Fuel Devops McRobotson (fuel-devops-robot) wrote : Related fix proposed to mos/mos-docs (stable/7.0)

Related fix proposed to branch: stable/7.0
Change author: Alexey Stupnikov <email address hidden>
Review: https://review.fuel-infra.org/21928

Revision history for this message
Fuel Devops McRobotson (fuel-devops-robot) wrote : Related fix merged to mos/mos-docs (stable/7.0)

Reviewed: https://review.fuel-infra.org/21928
Submitter: Evgeny Konstantinov <email address hidden>
Branch: stable/7.0

Commit: 7491cd3fb67f4b5efc5428213b520339e4d6a6b2
Author: Alexey Stupnikov <email address hidden>
Date: Tue Jun 14 10:33:39 2016

[Murano] Add known issue with WA

There is an issue with murano DB schema breaking deployment of
large murano environments. I have described this issue and
a possible workaround to fix it in production environments.

Related-bug: #1566306
Change-Id: I9d1c7046f78c44d7cd96fbe10c28e866a0a4bb50

Revision history for this message
Fuel Devops McRobotson (fuel-devops-robot) wrote : Related fix proposed to mos/mos-docs (stable/8.0)

Related fix proposed to branch: stable/8.0
Change author: Alexey Stupnikov <email address hidden>
Review: https://review.fuel-infra.org/22197

Revision history for this message
Fuel Devops McRobotson (fuel-devops-robot) wrote : Related fix merged to mos/mos-docs (stable/8.0)

Reviewed: https://review.fuel-infra.org/22197
Submitter: Evgeny Konstantinov <email address hidden>
Branch: stable/8.0

Commit: cec02a2debd4bf5aa24de9926d1ab3353dc619b6
Author: Alexey Stupnikov <email address hidden>
Date: Fri Jun 17 11:27:21 2016

[Murano] Add known issue with WA

There is an issue with murano DB schema breaking deployment of
large murano environments. I have described this issue and
a possible workaround to fix it in production environments.

Related-bug: #1566306
Change-Id: I9d1c7046f78c44d7cd96fbe10c28e866a0a4bb50

Revision history for this message
Kirill Zaitsev (kzaitsev) wrote :

fixed in upstream

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.