ImportError: Unable to import backend 'sqlalchemy'

[Digambar]

when I try baymodel create, it raises the error -

digambar@Openstack_diga:~/magnum$ magnum baymodel-create --name testbaymodel --image-id bbaeb798-7c29-4ee2-9f40-6487fc6d7b24 --keypair-id testkey --external-network-id f98abaf2-bd3b-47cc-8fba-5f2037a29542 --dns-nameserver 8.8.8.8 --flavor-id m1.small --docker-volume-size 5

Getting error at magnum-api log -

2015-04-02 18:22:22.714 5943 ERROR wsme.api [-] Server-side error: "Unable to import backend 'sqlalchemy'". Detail:
Traceback (most recent call last):

  File "/usr/local/lib/python2.7/dist-packages/wsmeext/pecan.py", line 82, in callfunction
    result = f(self, *args, **kwargs)

  File "/home/digambar/magnum/magnum/api/controllers/v1/baymodel.py", line 253, in post
    new_baymodel.create()

  File "/home/digambar/magnum/magnum/objects/base.py", line 143, in wrapper
    return fn(self, context, *args, **kwargs)

  File "/home/digambar/magnum/magnum/objects/baymodel.py", line 143, in create
    db_baymodel = self.dbapi.create_baymodel(values)

  File "/usr/local/lib/python2.7/dist-packages/oslo/db/api.py", line 188, in __getattr__
    self._load_backend()

  File "/usr/local/lib/python2.7/dist-packages/oslo/db/api.py", line 183, in _load_backend
    self._backend_name)

ImportError: Unable to import backend 'sqlalchemy'

[Digambar (digambarpatil15)]

This bug is related to oslo.db api. Need to inform oslo team about this.

[Doug Hellmann (doug-hellmann)]

Do you have SQLAlchemy installed? What versions of magnum and oslo.db are installed? How did you install them (devstack, system packages, some other way)?

[Digambar (digambarpatil15)]

Hi Aoug,

I have SQLAlcehmy installed using devstack, I also updated to the latest version but still getting this error.

See this latest error again I am facing -

  File "/home/digambar/openstack_magnum/integrating_glance/magnum/magnum/db/sqlalchemy/api.py", line 28, in <module>
    from magnum.db.sqlalchemy import models

  File "/home/digambar/openstack_magnum/integrating_glance/magnum/magnum/db/sqlalchemy/models.py", line 46, in <module>
    db_options.set_defaults(cfg.CONF, _DEFAULT_SQL_CONNECTION, 'magnum.sqlite')

  File "/usr/local/lib/python2.7/dist-packages/oslo_db/options.py", line 192, in set_defaults
    conf.register_opts(database_opts, group='database')

  File "/usr/local/lib/python2.7/dist-packages/oslo_config/cfg.py", line 1679, in __inner
    result = f(self, *args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/oslo_config/cfg.py", line 1836, in register_opts
    self.register_opt(opt, group, clear_cache=False)

  File "/usr/local/lib/python2.7/dist-packages/oslo_config/cfg.py", line 1683, in __inner
    return f(self, *args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/oslo_config/cfg.py", line 1820, in register_opt
    return group._register_opt(opt, cli)

  File "/usr/local/lib/python2.7/dist-packages/oslo_config/cfg.py", line 1239, in _register_opt
    if _is_opt_registered(self._opts, opt):

  File "/usr/local/lib/python2.7/dist-packages/oslo_config/cfg.py", line 572, in _is_opt_registered
    raise DuplicateOptError(opt.name)

DuplicateOptError: duplicate option: max_retries

[Digambar (digambarpatil15)]

This log confirms that its a oslo.db error, I have upgraded oslo.db & sqlalchemy packages also but still getting same error

[Kai Qiang Wu(Kennan) (wkqwu)]

use latest devstack in Apr 24th,

ubuntu@kqcontainer:~$ magnum baymodel-create --name testbaymodel --image-id fedora-21-atomic-2 \
> --keypair-id testkey \
> --external-network-id $NIC_ID \
> --dns-nameserver 8.8.8.8 --flavor-id m1.small \
> --docker-volume-size 4
+---------------------+--------------------------------------+
| Property | Value |
+---------------------+--------------------------------------+
| fixed_network | None |
| apiserver_port | None |
| uuid | 5f7e29db-45b9-4bc6-a84a-377a77fade2a |
| external_network_id | 747ba261-612b-493e-a6e1-fc7bb4e195d6 |
| created_at | 2015-04-25T03:45:14.098390+00:00 |
| updated_at | None |
| name | testbaymodel |
| ssh_authorized_key | None |
| image_id | fedora-21-atomic-2 |
| keypair_id | testkey |
| master_flavor_id | None |
| flavor_id | m1.small |
| dns_nameserver | 8.8.8.8 |
| docker_volume_size | 4 |
+---------------------+--------------------------------------+

Not found any issue, So close it now.