Model sync is broken for SQLite because of BigInteger type mismatch

[Mike Fedosin]

Here the output for glance.tests.unit.test_migrations.ModelsMigrationsSyncSQLite.test_models_sync:

AssertionError: Models and migration scripts aren't in sync:
[ [ ( 'modify_type',
      None,
      'artifact_blobs',
      'size',
      { 'existing_nullable': False,
        'existing_server_default': False},
      INTEGER(),
      BigInteger())],
  [ ( 'modify_type',
      None,
      'artifacts',
      'type_version_prefix',
      { 'existing_nullable': False,
        'existing_server_default': False},
      INTEGER(),
      BigInteger())],
  [ ( 'modify_type',
      None,
      'artifacts',
      'version_prefix',
      { 'existing_nullable': False,
        'existing_server_default': False},
      INTEGER(),
      BigInteger())],
  [ ( 'modify_type',
      None,
      'images',
      'size',
      { 'existing_nullable': True,
        'existing_server_default': False},
      INTEGER(),
      BigInteger())],
  [ ( 'modify_type',
      None,
      'images',
      'virtual_size',
      { 'existing_nullable': True,
        'existing_server_default': False},
      INTEGER(),
      BigInteger())]]

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/liberty
Review: https://review.openstack.org/259244

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/258527
Committed: https://git.openstack.org/cgit/openstack/glance/commit/?id=2e2adb3935bcbf9dc6e100c4ba9a8e1b4bf3a4e6
Submitter: Jenkins
Branch: master

commit 2e2adb3935bcbf9dc6e100c4ba9a8e1b4bf3a4e6
Author: Mike Fedosin <email address hidden>
Date: Wed Dec 16 17:05:45 2015 +0300

    Fix model sync for SQLite

    This code fixes the situation when several
    models are mismatched for SQLite because of
    type inconsistencies between Integer and
    BigInteger in sqlalchemy.

    Change-Id: I52b3a0158db8e3dc48f19509d1f9f80420ee40ea
    Closes-bug: #1526804
    Closes-bug: #1526675

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/259244
Committed: https://git.openstack.org/cgit/openstack/glance/commit/?id=2b20285a1a48aa88e6d101e62d4bef2b9eda1c35
Submitter: Jenkins
Branch: stable/liberty

commit 2b20285a1a48aa88e6d101e62d4bef2b9eda1c35
Author: Mike Fedosin <email address hidden>
Date: Wed Dec 16 17:05:45 2015 +0300

    Fix model sync for SQLite

    This code fixes the situation when several
    models are mismatched for SQLite because of
    type inconsistencies between Integer and
    BigInteger in sqlalchemy.

    Change-Id: I52b3a0158db8e3dc48f19509d1f9f80420ee40ea
    Closes-bug: #1526804
    Closes-bug: #1526675
    (cherry picked from commit 2e2adb3935bcbf9dc6e100c4ba9a8e1b4bf3a4e6)

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/kilo
Review: https://review.openstack.org/259667

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/259667
Committed: https://git.openstack.org/cgit/openstack/glance/commit/?id=5cb8d33860fbadcaee7dbcf61b866c5ce18b5054
Submitter: Jenkins
Branch: stable/kilo

commit 5cb8d33860fbadcaee7dbcf61b866c5ce18b5054
Author: Mike Fedosin <email address hidden>
Date: Wed Dec 16 17:05:45 2015 +0300

    Fix model sync for SQLite

    This code fixes the situation when several
    models are mismatched for SQLite because of
    type inconsistencies between Integer and
    BigInteger in sqlalchemy.

     Conflicts:
     glance/db/sqlalchemy/models_artifacts.py

    Change-Id: I52b3a0158db8e3dc48f19509d1f9f80420ee40ea
    Closes-bug: #1526804
    Closes-bug: #1526675
    (cherry picked from commit 2e2adb3935bcbf9dc6e100c4ba9a8e1b4bf3a4e6)
    (cherry picked from commit 2b20285a1a48aa88e6d101e62d4bef2b9eda1c35)

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/glance 11.0.1 release.