SAWarning: Datatype FLOAT(53) does not support CAST on MySQL; the CAST will be skipped

[xiaoxu790]

panko: queens

# openstack event capabilities list
+---------------+-------------------------------------+
| Field | Value |
+---------------+-------------------------------------+
| api | {u'events:query:simple': True} |
| event_storage | {u'storage:production_ready': True} |
+---------------+-------------------------------------+

# more /var/log/panko/panko-api-error.log
[Mon Jun 04 15:42:34.180013 2018] [:error] [pid 18] /var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py:870: SAWarning: Datatype FLOAT(53) does not support CAST on MySQL; the CAST will be skipped.
[Mon Jun 04 15:42:34.221669 2018] [:error] [pid 18] self.dialect.type_compiler.process(cast.typeclause.type))
[Tue Jun 05 18:15:11.112085 2018] [:error] [pid 21] /var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py:870: SAWarning: Datatype FLOAT(53) does not support CAST on MySQL; the CAST will be skipped.
[Tue Jun 05 18:15:11.112725 2018] [:error] [pid 21] self.dialect.type_compiler.process(cast.typeclause.type))

# cat /etc/kolla/panko-api/panko.conf
[DEFAULT]
log_dir = /var/log/kolla/panko
debug = True
log_file = /var/log/kolla/panko/panko-api.log

[database]
event_connection = mysql+pymysql://panko:fkeRa5dmSsbxulsGQjhBLjgVYyuG0EcvDCWXijvC@172.17.223.20:3306/panko
metering_connection = mysql+pymysql://panko:fkeRa5dmSsbxulsGQjhBLjgVYyuG0EcvDCWXijvC@172.17.223.20:3306/panko

[keystone_authtoken]
auth_uri = http://172.17.223.20:5000
project_domain_name = Default
project_name = service
user_domain_name = Default
username = panko
password = z3cgJeD07tg26PfCdfynubS3J5Nqde9JMaPOuWhn
auth_url = http://172.17.223.20:35357
auth_type = password
memcache_security_strategy = ENCRYPT
memcache_secret_key = wRJgCSJjqUT5JWlGVyvSygovRiyXFgJg7kYz1sXX
memcached_servers = 172.17.223.21:11211,172.17.223.26:11211