执行su -s /bin/sh -c "keystone-manage db_sync" keystone报错

系统安装、升级讨论
版面规则
我们都知道新人的确很菜,也喜欢抱怨,并且带有浓厚的Windows习惯,但既然在这里询问,我们就应该有责任帮助他们解决问题,而不是直接泼冷水、简单的否定或发表对解决问题没有任何帮助的帖子。乐于分享,以人为本,这正是Ubuntu的精神所在。
回复
Morata
帖子: 6
注册时间: 2017-12-14 10:25
系统: win10

执行su -s /bin/sh -c "keystone-manage db_sync" keystone报错

#1

帖子 Morata » 2017-12-14 10:50

Ubuntu 16.4
在搭建open stack中
在创建keystone时,到执行su -s /bin/sh -c "keystone-manage db_sync" keystone报错,新人不知什么原因。求大神。谢谢拉。

错误代码如下:

root@controller:~# su -s /bin/sh -c "keystone-manage db_sync" keystone
2017-12-13 16:46:06.297 1464 WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. 10 attempts left.
2017-12-13 16:46:16.329 1464 WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. 9 attempts left.
^C
Session terminated, terminating shell...2017-12-13 16:46:21.781 1464 CRITICAL keystone [-] KeyboardInterrupt
2017-12-13 16:46:21.781 1464 ERROR keystone Traceback (most recent call last):
2017-12-13 16:46:21.781 1464 ERROR keystone File "/usr/bin/keystone-manage", line 10, in <module>
2017-12-13 16:46:21.781 1464 ERROR keystone sys.exit(main())
2017-12-13 16:46:21.781 1464 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/cmd/manage.py", line 47, in main
2017-12-13 16:46:21.781 1464 ERROR keystone cli.main(argv=sys.argv, config_files=config_files)
2017-12-13 16:46:21.781 1464 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/cmd/cli.py", line 1048, in main
2017-12-13 16:46:21.781 1464 ERROR keystone CONF.command.cmd_class.main()
2017-12-13 16:46:21.781 1464 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/cmd/cli.py", line 403, in main
2017-12-13 16:46:21.781 1464 ERROR keystone migration_helpers.sync_database_to_version(extension, version)
2017-12-13 16:46:21.781 1464 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py", line 210, in sync_database_to_version
2017-12-13 16:46:21.781 1464 ERROR keystone _sync_common_repo(version)
2017-12-13 16:46:21.781 1464 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py", line 132, in _sync_common_repo
2017-12-13 16:46:21.781 1464 ERROR keystone with sql.session_for_write() as session:
2017-12-13 16:46:21.781 1464 ERROR keystone File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__
2017-12-13 16:46:21.781 1464 ERROR keystone return self.gen.next()
2017-12-13 16:46:21.781 1464 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 759, in _transaction_scope
2017-12-13 16:46:21.781 1464 ERROR keystone allow_async=self._allow_async) as resource:
2017-12-13 16:46:21.781 1464 ERROR keystone File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__
2017-12-13 16:46:21.781 1464 ERROR keystone return self.gen.next()
2017-12-13 16:46:21.781 1464 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 491, in _session
2017-12-13 16:46:21.781 1464 ERROR keystone bind=self.connection, mode=self.mode)
2017-12-13 16:46:21.781 1464 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 272, in _create_session
2017-12-13 16:46:21.781 1464 ERROR keystone self._start()
2017-12-13 16:46:21.781 1464 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 338, in _start
2017-12-13 16:46:21.781 1464 ERROR keystone engine_args, maker_args)
2017-12-13 16:46:21.781 1464 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 362, in _setup_for_connection
2017-12-13 16:46:21.781 1464 ERROR keystone sql_connection=sql_connection, **engine_kwargs)
2017-12-13 16:46:21.781 1464 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py", line 152, in create_engine
2017-12-13 16:46:21.781 1464 ERROR keystone test_conn = _test_connection(engine, max_retries, retry_interval)
2017-12-13 16:46:21.781 1464 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py", line 330, in _test_connection
2017-12-13 16:46:21.781 1464 ERROR keystone time.sleep(retry_interval)
2017-12-13 16:46:21.781 1464 ERROR keystone KeyboardInterrupt
2017-12-13 16:46:21.781 1464 ERROR keystone
...terminated.
头像
九天星
帖子: 1440
注册时间: 2007-07-14 20:45

Re: 执行su -s /bin/sh -c "keystone-manage db_sync" keystone报错

#2

帖子 九天星 » 2017-12-14 17:59

连接数据库出现问题
Morata
帖子: 6
注册时间: 2017-12-14 10:25
系统: win10

Re: 执行su -s /bin/sh -c "keystone-manage db_sync" keystone报错

#3

帖子 Morata » 2017-12-14 18:55

九天星 写了:连接数据库出现问题
知道怎么解决吗?
头像
九天星
帖子: 1440
注册时间: 2007-07-14 20:45

Re: 执行su -s /bin/sh -c "keystone-manage db_sync" keystone报错

#4

帖子 九天星 » 2017-12-14 20:03

Morata 写了:
九天星 写了:连接数据库出现问题
知道怎么解决吗?

从日志文件看来是连不上数据库

但是连不上数据库有很多可能,1、网络问题。2、配置问题。3、防火墙问题。4、端口问题。这些可能都会导致连接不上数据库。你只有自已从这些方面去排查啊。仅提供这份日志信息没法帮你进一步排除问题所在的。
Morata
帖子: 6
注册时间: 2017-12-14 10:25
系统: win10

Re: 执行su -s /bin/sh -c "keystone-manage db_sync" keystone报错

#5

帖子 Morata » 2017-12-14 20:17

九天星 写了:
Morata 写了:
九天星 写了:连接数据库出现问题
知道怎么解决吗?

从日志文件看来是连不上数据库

但是连不上数据库有很多可能,1、网络问题。2、配置问题。3、防火墙问题。4、端口问题。这些可能都会导致连接不上数据库。你只有自已从这些方面去排查啊。仅提供这份日志信息没法帮你进一步排除问题所在的。
好的。谢啦。我重新搞下。
回复