Comment 4 for bug 1774688

FYI, as I encountered a similar issue but turned out to be devstack doing (stable/queens, CentOS 7).

The problem for me is that devstack installs package rdo-release from https://rdoproject.org/repos/rdo-release.rpm which redirects to latest stable, Stein at present, and where MariaDB 10.3.z is available and gets installed.

[vagrant@localhost devstack]$ git rev-parse HEAD
e3100794d1615fc6b4216f54e2f7859a33d60b05

vagrant@localhost devstack]$ rpm -qa | grep maria
mariadb-config-10.3.10-1.el7.0.0.rdo2.x86_64
mariadb-devel-10.3.10-1.el7.0.0.rdo2.x86_64
mariadb-10.3.10-1.el7.0.0.rdo2.x86_64
mariadb-server-10.3.10-1.el7.0.0.rdo2.x86_64
mariadb-common-10.3.10-1.el7.0.0.rdo2.x86_64
mariadb-errmsg-10.3.10-1.el7.0.0.rdo2.x86_64
mariadb-libs-10.3.10-1.el7.0.0.rdo2.x86_64

vagrant@localhost devstack]$ ./stack.sh
[...]
INFO migrate.versioning.api [-] done
INFO migrate.versioning.api [-] 32 -> 33...
INFO migrate.versioning.api [-] done
INFO migrate.versioning.api [-] 33 -> 34...
INFO migrate.versioning.api [-] done
INFO migrate.versioning.api [-] 34 -> 35...
ERROR oslo_db.sqlalchemy.exc_filters [-] DBAPIError exception wrapped from (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 'VARCHAR(64)' at line 1") [SQL: u'\nALTER TABLE application_credential ADD system VARCHAR(64)'] (Background on this error at: http://sqlalche.me/e/f405): 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 'VARCHAR(64)' at line 1")
ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
ERROR oslo_db.sqlalchemy.exc_filters context)
ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
ERROR oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters)
ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
ERROR oslo_db.sqlalchemy.exc_filters result = self._query(query)
ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
ERROR oslo_db.sqlalchemy.exc_filters conn.query(q)
ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
ERROR oslo_db.sqlalchemy.exc_filters self._affected_rows = self._read_query_result(unbuffered=unbuffered)
ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
ERROR oslo_db.sqlalchemy.exc_filters result.read()
ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
ERROR oslo_db.sqlalchemy.exc_filters first_packet = self.connection._read_packet()
ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
ERROR oslo_db.sqlalchemy.exc_filters packet.check_error()
ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
ERROR oslo_db.sqlalchemy.exc_filters err.raise_mysql_exception(self._data)
ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
ERROR oslo_db.sqlalchemy.exc_filters raise errorclass(errno, errval)
ERROR oslo_db.sqlalchemy.exc_filters 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 'VARCHAR(64)' at line 1")
ERROR oslo_db.sqlalchemy.exc_filters
CRITICAL keystone [-] Unhandled error: DBMigrationError: (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 'VARCHAR(64)' at line 1") [SQL: u'\nALTER TABLE application_credential ADD system VARCHAR(64)'] (Background on this error at: http://sqlalche.me/e/f405)
ERROR keystone Traceback (most recent call last):
ERROR keystone File "/usr/bin/keystone-manage", line 10, in <module>
ERROR keystone sys.exit(main())
ERROR keystone File "/opt/stack/keystone/keystone/cmd/manage.py", line 45, in main
ERROR keystone cli.main(argv=sys.argv, config_files=config_files)
ERROR keystone File "/opt/stack/keystone/keystone/cmd/cli.py", line 1349, in main
ERROR keystone CONF.command.cmd_class.main()
ERROR keystone File "/opt/stack/keystone/keystone/cmd/cli.py", line 548, in main
ERROR keystone CONF.command.version)
ERROR keystone File "/opt/stack/keystone/keystone/common/sql/upgrades.py", line 250, in offline_sync_database_to_version
ERROR keystone expand_schema()
ERROR keystone File "/opt/stack/keystone/keystone/common/sql/upgrades.py", line 325, in expand_schema
ERROR keystone _sync_repo(repo_name=EXPAND_REPO)
ERROR keystone File "/opt/stack/keystone/keystone/common/sql/upgrades.py", line 187, in _sync_repo
ERROR keystone init_version=init_version, sanity_check=False)
ERROR keystone File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/migration.py", line 81, in db_sync
ERROR keystone raise exception.DBMigrationError(ex)
ERROR keystone DBMigrationError: (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 'VARCHAR(64)' at line 1") [SQL: u'\nALTER TABLE application_credential ADD system VARCHAR(64)'] (Background on this error at: http://sqlalche.me/e/f405)
ERROR keystone
+lib/keystone:init_keystone:1 exit_trap
+./stack.sh:exit_trap:510 local r=1
++./stack.sh:exit_trap:511 jobs -p
+./stack.sh:exit_trap:511 jobs=
+./stack.sh:exit_trap:514 [[ -n '' ]]
+./stack.sh:exit_trap:520 '[' -f /tmp/tmp.pFdNvvsTTG ']'
+./stack.sh:exit_trap:521 rm /tmp/tmp.pFdNvvsTTG
+./stack.sh:exit_trap:525 kill_spinner
+./stack.sh:kill_spinner:424 '[' '!' -z '' ']'
+./stack.sh:exit_trap:527 [[ 1 -ne 0 ]]
+./stack.sh:exit_trap:528 echo 'Error on exit'
Error on exit
+./stack.sh:exit_trap:530 type -p generate-subunit
+./stack.sh:exit_trap:531 generate-subunit 1561105010 823 fail
+./stack.sh:exit_trap:533 [[ -z /opt/stack/logs ]]
+./stack.sh:exit_trap:536 /home/vagrant/devstack/tools/worlddump.py -d /opt/stack/logs
World dumping... see /opt/stack/logs/worlddump-2019-06-21-083033.txt for details
+./stack.sh:exit_trap:545 exit 1
[vagrant@localhost devstack]$