manila-manage db sync error

asked 2019-01-23 16:03:35 -0500

whoansoo gravatar image

updated 2019-01-24 14:25:37 -0500

I met below error. I find out connect to cinder database and tables (shares) and columns. It is already updated. My cinder version is 3.5.0.

Please tell me show can I resolve this.

root@controller:~# su -s /bin/sh -c "manila-manage db sync" manila

2019-01-24 06:53:47.566 22717 INFO alembic.runtime.migration [-] Context impl MySQLImpl.

2019-01-24 06:53:47.566 22717 INFO alembic.runtime.migration [-] Will assume non-transactional DDL.

2019-01-24 06:53:47.619 22717 INFO alembic.runtime.migration [-] Running upgrade -> 162a3e673105, manila_init

2019-01-24 06:53:48.402 22717 INFO alembic.runtime.migration [-] Running upgrade 162a3e673105 -> 211836bf835c, add access level

2019-01-24 06:53:48.527 22717 INFO alembic.runtime.migration [-] Running upgrade 211836bf835c -> 38e632621e5a, change volume_type to share_type

2019-01-24 06:53:48.527 22717 INFO 38e632621e5a_change_volume_type_to_share_type_py [-] Renaming column name shares.volume_type_id to shares.share_type.id

2019-01-24 06:53:48.544 22717 INFO 38e632621e5a_change_volume_type_to_share_type_py [-] Renaming volume_types table to share_types

2019-01-24 06:53:48.586 22717 ERROR oslo_db.sqlalchemy.exc_filters [-] DBAPIError exception wrapped from (pymysql.err.InternalError) (1091, u"Can't DROP INDEX vt_name_uc; check that it exists") [SQL: u'ALTER TABLE share_types DROP INDEX vt_name_uc']: InternalError: (1091, u"Can't DROP INDEX vt_name_uc; check that it exists") 2019-01-24 06:53:48.586 22717 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last): 2019-01-24 06:53:48.586 22717 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context 2019-01-24 06:53:48.586 22717 ERROR oslo_db.sqlalchemy.exc_filters context) 2019-01-24 06:53:48.586 22717 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 470, in do_execute 2019-01-24 06:53:48.586 22717 ERROR oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters) 2019-01-24 06:53:48.586 22717 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 165, in execute 2019-01-24 06:53:48.586 22717 ERROR oslo_db.sqlalchemy.exc_filters result = self._query(query) 2019-01-24 06:53:48.586 22717 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 321, in _query 2019-01-24 06:53:48.586 22717 ERROR oslo_db.sqlalchemy.exc_filters conn.query(q) 2019-01-24 06:53:48.586 22717 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 860, in query 2019-01-24 06:53:48.586 22717 ERROR oslo_db.sqlalchemy.exc_filters self._affected_rows = self._read_query_result(unbuffered=unbuffered) 2019-01-24 06:53:48.586 22717 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1061, in _read_query_result 2019-01-24 06:53:48.586 22717 ERROR oslo_db.sqlalchemy.exc_filters result.read() 2019-01-24 06:53:48.586 22717 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1349, in read 2019-01-24 06:53:48.586 22717 ERROR oslo_db.sqlalchemy.exc_filters first_packet = self.connection._read_packet() 2019-01-24 06:53:48.586 22717 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1018, in _read_packet 2019-01-24 06:53:48.586 ... (more)

edit retag flag offensive close merge delete

Comments

Anybody have no idea ? It might be already patch column in tables. But it's upgrade script was trying to patch. So I want skip this upgrade trying script "Running upgrade 211836bf835c -> 38e632621e5a". And My manila-api version is 6.0.0. Is it right ?

whoansoo gravatar imagewhoansoo ( 2019-01-24 14:23:29 -0500 )edit