文章目录
- Function 'nova.servicegroup.drivers.db.DbDriver._report_state' run outlasted interval by 7.53 sec
- class 'pymysql.err.ProgrammingError'> (1064, u"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near
- cannot load glue library: libibverbs.so.1: cannot open shared object file: No such file or directory
Function ‘nova.servicegroup.drivers.db.DbDriver._report_state’ run outlasted interval by 7.53 sec
创建虚拟机过程中,把虚拟机分配到A节点,进入A节点/var/log/nova/compute.log
中查看日志
2020-03-04 14:38:45.811 22256 WARNING oslo.service.loopingcall [-] Function 'nova.servicegroup.drivers.db.DbDriver._report_state' run outlasted interval by 10.44 sec
2020-03-04 14:39:21.464 22256 INFO nova.compute.resource_tracker [req-2fc669ea-ac83-474d-8372-160eeacebc58 - - - - -] Final resource view: name=worker.node phys_ram=32767MB used_ram=4864MB phys_disk=1019GB used_disk=130GB total_vcpus=4 used_vcpus=4 pci_stats=[]
2020-03-04 14:40:15.518 22256 WARNING oslo.service.loopingcall [-] Function 'nova.servicegroup.drivers.db.DbDriver._report_state' run outlasted interval by 8.68 sec
2020-03-04 14:40:21.377 22256 INFO nova.compute.resource_tracker [req-2fc669ea-ac83-474d-8372-160eeacebc58 - - - - -] Final resource view: name=worker.node phys_ram=32767MB used_ram=4864MB phys_disk=1019GB used_disk=130GB total_vcpus=4 used_vcpus=4 pci_stats=[]
2020-03-04 14:40:26.836 22256 WARNING oslo.service.loopingcall [-] Function 'nova.servicegroup.drivers.db.DbDriver._report_state' run outlasted interval by 1.32 sec
2020-03-04 14:40:54.617 22256 WARNING oslo.service.loopingcall [-] Function 'nova.servicegroup.drivers.db.DbDriver._report_state' run outlasted interval by 17.78 sec
2020-03-04 14:41:06.477 22256 WARNING oslo.service.loopingcall [-] Function 'nova.servicegroup.drivers.db.DbDriver._report_state' run outlasted interval by 1.86 sec
2020-03-04 14:41:17.868 22256 WARNING oslo.service.loopingcall [-] Function 'nova.servicegroup.drivers.db.DbDriver._report_state' run outlasted interval by 1.39 sec
2020-03-04 14:41:21.393 22256 INFO nova.compute.resource_tracker [req-2fc669ea-ac83-474d-8372-160eeacebc58 - - - - -] Final resource view: name=worker.node phys_ram=32767MB used_ram=4864MB phys_disk=1019GB used_disk=130GB total_vcpus=4 used_vcpus=4 pci_stats=[]
2020-03-04 14:41:35.401 22256 WARNING oslo.service.loopingcall [-] Function 'nova.servicegroup.drivers.db.DbDriver._report_state' run outlasted interval by 7.53 sec
解决办法:
修改/etc/nova/nova.conf
文件,增加以下属性
# Possible values:
#
# * 60 (default)
# * If value is 0, then one attempt is made.
# * Any negative value is treated as 0.
# * For any value > 0, total attempts are (value + 1)
# (integer value)
block_device_allocate_retries=60
参考:https://blog.csdn.net/zuopiezia/article/details/80458821
class ‘pymysql.err.ProgrammingError’> (1064, u"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near
很多服务的状态虽然是运行状态,但是报了异常,说是SQL数据库的问题
Feb 28 17:52:23 manager.node systemd[1]: Starting OpenStack Nova VNC console auth Server...
Feb 28 17:52:35 manager.node systemd[1]: Started OpenStack Nova VNC console auth Server.
Feb 29 09:46:00 manager.node nova-consoleauth[1952]: /usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py:74: SAWarning: An exception has occurred during handling of a previous exception. The previous exception is:
Feb 29 09:46:00 manager.node nova-consoleauth[1952]: <class 'pymysql.err.ProgrammingError'> (1064, u"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1")
Feb 29 09:46:00 manager.node nova-consoleauth[1952]: "is:\n %s %s\n" % (self._exc_info[0], self._exc_info[1]))
查看数据库,发现可以登陆,但是查询表查询不到了
[root@manager ~]# mysql -root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 5362
Server version: 10.1.20-MariaDB MariaDB Server
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
Ignoring query to other database
MariaDB [(none)]> show databases;
Ignoring query to other database
MariaDB [(none)]> Ctrl-C -- exit!
Aborted
解决方法:重启mariadb服务(可能是服务器重启过的原因吧)
cannot load glue library: libibverbs.so.1: cannot open shared object file: No such file or directory
[root@manager ~]# systemctl status neutron-openvswitch-agent
● neutron-openvswitch-agent.service - OpenStack Neutron Open vSwitch Agent
Loaded: loaded (/usr/lib/systemd/system/neutron-openvswitch-agent.service; enabled; vendor preset: disabled)
Active: active (running) since Fri 2020-03-27 15:58:50 CST; 5s ago
Process: 2885 ExecStartPre=/usr/bin/neutron-enable-bridge-firewall.sh (code=exited, status=0/SUCCESS)
Main PID: 2891 (neutron-openvsw)
CGroup: /system.slice/neutron-openvswitch-agent.service
└─2891 /usr/bin/python2 /usr/bin/neutron-openvswitch-agent --config-file /usr/share/neutron/neutron-dist.conf --config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugins/ml2/openvswitch_agent.ini --config-dir /etc/neutron/conf.d/common --con...
Mar 27 15:58:50 manager.node systemd[1]: Starting OpenStack Neutron Open vSwitch Agent...
Mar 27 15:58:50 manager.node neutron-enable-bridge-firewall.sh[2885]: net.bridge.bridge-nf-call-iptables = 1
Mar 27 15:58:50 manager.node neutron-enable-bridge-firewall.sh[2885]: net.bridge.bridge-nf-call-ip6tables = 1
Mar 27 15:58:50 manager.node systemd[1]: Started OpenStack Neutron Open vSwitch Agent.
Mar 27 15:58:52 manager.node neutron-openvswitch-agent[2891]: net_mlx5: cannot load glue library: libibverbs.so.1: cannot open shared object file: No such file or directory
Mar 27 15:58:52 manager.node neutron-openvswitch-agent[2891]: net_mlx5: cannot initialize PMD due to missing run-time dependency on rdma-core libraries (libibverbs, libmlx5)
Mar 27 15:58:52 manager.node neutron-openvswitch-agent[2891]: PMD: net_mlx4: cannot load glue library: libibverbs.so.1: cannot open shared object file: No such file or directory
Mar 27 15:58:52 manager.node neutron-openvswitch-agent[2891]: PMD: net_mlx4: cannot initialize PMD due to missing run-time dependency on rdma-core libraries (libibverbs, libmlx4)
安装以下包解决
yum install libibverbs -y