yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1488740] [NEW] neutron dbsync fails with 44621190bc02_add_uniqueconstraint_ipavailability_ranges.py

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Emilien Macchi <1488740@xxxxxxxxxxxxxxxxxx>
Date: Wed, 26 Aug 2015 03:27:35 -0000
Reply-to: Bug 1488740 <1488740@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

2015-08-26 02:50:39.383 | Debug: Executing 'neutron-db-manage --config-
file /etc/neutron/neutron.conf --config-file /etc/neutron/plugin.ini
upgrade head'

2015-08-26 02:50:41.398 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: No handlers could be found for logger "neutron.quota"
2015-08-26 02:50:41.399 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: INFO  [alembic.migration] Context impl MySQLImpl.
2015-08-26 02:50:41.399 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: INFO  [alembic.migration] Will assume non-transactional DDL.
2015-08-26 02:50:41.399 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: INFO  [alembic.migration] Context impl MySQLImpl.
2015-08-26 02:50:41.399 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: INFO  [alembic.migration] Will assume non-transactional DDL.
2015-08-26 02:50:41.401 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: INFO  [alembic.migration] Running upgrade  -> juno, juno_initial
2015-08-26 02:50:41.401 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: INFO  [alembic.migration] Running upgrade juno -> 44621190bc02, add_uniqueconstraint_ipavailability_ranges
2015-08-26 02:50:41.401 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: Running upgrade for neutron ...
2015-08-26 02:50:41.401 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: Traceback (most recent call last):
2015-08-26 02:50:41.401 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/bin/neutron-db-manage", line 10, in <module>
2015-08-26 02:50:41.402 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     sys.exit(main())
2015-08-26 02:50:41.402 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/neutron/db/migration/cli.py", line 519, in main
2015-08-26 02:50:41.402 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     CONF.command.func(config, CONF.command.name)
2015-08-26 02:50:41.402 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/neutron/db/migration/cli.py", line 152, in do_upgrade
2015-08-26 02:50:41.402 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     do_alembic_command(config, cmd, revision, sql=CONF.command.sql)
2015-08-26 02:50:41.402 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/neutron/db/migration/cli.py", line 106, in do_alembic_command
2015-08-26 02:50:41.402 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     getattr(alembic_command, cmd)(config, *args, **kwargs)
2015-08-26 02:50:41.402 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/alembic/command.py", line 165, in upgrade
2015-08-26 02:50:41.402 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     script.run_env()
2015-08-26 02:50:41.402 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/alembic/script.py", line 382, in run_env
2015-08-26 02:50:41.403 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     util.load_python_file(self.dir, 'env.py')
2015-08-26 02:50:41.403 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/alembic/util.py", line 242, in load_python_file
2015-08-26 02:50:41.403 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     module = load_module_py(module_id, path)
2015-08-26 02:50:41.403 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/alembic/compat.py", line 79, in load_module_py
2015-08-26 02:50:41.403 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     mod = imp.load_source(module_id, path, fp)
2015-08-26 02:50:41.403 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/env.py", line 126, in <module>
2015-08-26 02:50:41.403 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     run_migrations_online()
2015-08-26 02:50:41.403 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/env.py", line 117, in run_migrations_online
2015-08-26 02:50:41.403 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     context.run_migrations()
2015-08-26 02:50:41.403 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "<string>", line 7, in run_migrations
2015-08-26 02:50:41.408 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/alembic/environment.py", line 742, in run_migrations
2015-08-26 02:50:41.408 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     self.get_context().run_migrations(**kw)
2015-08-26 02:50:41.408 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/alembic/migration.py", line 305, in run_migrations
2015-08-26 02:50:41.409 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     step.migration_fn(**kw)
2015-08-26 02:50:41.409 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/versions/44621190bc02_add_uniqueconstraint_ipavailability_ranges.py", line 40, in upgrade
2015-08-26 02:50:41.409 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     columns=['first_ip', 'allocation_pool_id']
2015-08-26 02:50:41.409 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: TypeError: create_unique_constraint() takes at least 3 arguments (0 given)
2015-08-26 02:50:41.409 | Error: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]: Failed to call refresh: neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugin.ini upgrade head returned 1 instead of one of [0]
2015-08-26 02:50:41.409 | Error: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]: neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugin.ini upgrade head returned 1 instead of one of [0]


Running Neutron from master (RDO trunk packaging).

** Affects: neutron
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1488740

Title:
  neutron dbsync fails with
  44621190bc02_add_uniqueconstraint_ipavailability_ranges.py

Status in neutron:
  New

Bug description:
  2015-08-26 02:50:39.383 | Debug: Executing 'neutron-db-manage
  --config-file /etc/neutron/neutron.conf --config-file
  /etc/neutron/plugin.ini upgrade head'

  2015-08-26 02:50:41.398 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: No handlers could be found for logger "neutron.quota"
  2015-08-26 02:50:41.399 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: INFO  [alembic.migration] Context impl MySQLImpl.
  2015-08-26 02:50:41.399 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: INFO  [alembic.migration] Will assume non-transactional DDL.
  2015-08-26 02:50:41.399 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: INFO  [alembic.migration] Context impl MySQLImpl.
  2015-08-26 02:50:41.399 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: INFO  [alembic.migration] Will assume non-transactional DDL.
  2015-08-26 02:50:41.401 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: INFO  [alembic.migration] Running upgrade  -> juno, juno_initial
  2015-08-26 02:50:41.401 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: INFO  [alembic.migration] Running upgrade juno -> 44621190bc02, add_uniqueconstraint_ipavailability_ranges
  2015-08-26 02:50:41.401 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: Running upgrade for neutron ...
  2015-08-26 02:50:41.401 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: Traceback (most recent call last):
  2015-08-26 02:50:41.401 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/bin/neutron-db-manage", line 10, in <module>
  2015-08-26 02:50:41.402 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     sys.exit(main())
  2015-08-26 02:50:41.402 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/neutron/db/migration/cli.py", line 519, in main
  2015-08-26 02:50:41.402 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     CONF.command.func(config, CONF.command.name)
  2015-08-26 02:50:41.402 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/neutron/db/migration/cli.py", line 152, in do_upgrade
  2015-08-26 02:50:41.402 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     do_alembic_command(config, cmd, revision, sql=CONF.command.sql)
  2015-08-26 02:50:41.402 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/neutron/db/migration/cli.py", line 106, in do_alembic_command
  2015-08-26 02:50:41.402 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     getattr(alembic_command, cmd)(config, *args, **kwargs)
  2015-08-26 02:50:41.402 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/alembic/command.py", line 165, in upgrade
  2015-08-26 02:50:41.402 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     script.run_env()
  2015-08-26 02:50:41.402 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/alembic/script.py", line 382, in run_env
  2015-08-26 02:50:41.403 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     util.load_python_file(self.dir, 'env.py')
  2015-08-26 02:50:41.403 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/alembic/util.py", line 242, in load_python_file
  2015-08-26 02:50:41.403 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     module = load_module_py(module_id, path)
  2015-08-26 02:50:41.403 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/alembic/compat.py", line 79, in load_module_py
  2015-08-26 02:50:41.403 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     mod = imp.load_source(module_id, path, fp)
  2015-08-26 02:50:41.403 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/env.py", line 126, in <module>
  2015-08-26 02:50:41.403 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     run_migrations_online()
  2015-08-26 02:50:41.403 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/env.py", line 117, in run_migrations_online
  2015-08-26 02:50:41.403 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     context.run_migrations()
  2015-08-26 02:50:41.403 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "<string>", line 7, in run_migrations
  2015-08-26 02:50:41.408 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/alembic/environment.py", line 742, in run_migrations
  2015-08-26 02:50:41.408 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     self.get_context().run_migrations(**kw)
  2015-08-26 02:50:41.408 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/alembic/migration.py", line 305, in run_migrations
  2015-08-26 02:50:41.409 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     step.migration_fn(**kw)
  2015-08-26 02:50:41.409 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/versions/44621190bc02_add_uniqueconstraint_ipavailability_ranges.py", line 40, in upgrade
  2015-08-26 02:50:41.409 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     columns=['first_ip', 'allocation_pool_id']
  2015-08-26 02:50:41.409 | Notice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: TypeError: create_unique_constraint() takes at least 3 arguments (0 given)
  2015-08-26 02:50:41.409 | Error: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]: Failed to call refresh: neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugin.ini upgrade head returned 1 instead of one of [0]
  2015-08-26 02:50:41.409 | Error: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]: neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugin.ini upgrade head returned 1 instead of one of [0]

  
  Running Neutron from master (RDO trunk packaging).

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1488740/+subscriptions
Follow ups

[Bug 1488740] Re: neutron dbsync fails with 44621190bc02_add_uniqueconstraint_ipavailability_ranges.py
From: Emilien Macchi, 2015-08-26