Support oceanbase as metadb

[yhilmare]

If I use oceanbase as metadb, starting airflow will fail. Can you support oceanbase as metadb?

[2024-08-02T03:19:09.010+0000] {configuration.py:2090} INFO - Creating new FAB webserver config file in: /opt/airflow/webserver_config.py

Please confirm database initialize (or wait 4 seconds to skip it). Are you sure? [y/N]
y
[2024-08-02T03:19:12.242+0000] {migration.py:215} INFO - Context impl MySQLImpl.
[2024-08-02T03:19:12.243+0000] {migration.py:218} INFO - Will assume non-transactional DDL.
(MySQLdb.OperationalError) (1305, 'FUNCTION RELEASE_LOCK does not exist')
[SQL: select RELEASE_LOCK(%s)]
[parameters: ('airflow_MIGRATIONS',)]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
You still have unapplied migrations. You may need to initialize the database by running `airflow db init`.  Make sure the command is run using Airflow version 2.9.3.

[2024-08-02T05:57:21.974+0000] {configuration.py:2090} INFO - Creating new FAB webserver config file in: /opt/airflow/webserver_config.py

Please confirm database initialize (or wait 4 seconds to skip it). Are you sure? [y/N]
[2024-08-02T05:57:27.433+0000] {db.py:918} INFO - Log template table does not exist (added in 2.3.0); skipping log template sync.
  ____________       _____________
 ____    |__( )_________  __/__  /________      __
____  /| |_  /__  ___/_  /_ __  /_  __ \_ | /| / /
___  ___ |  / _  /   _  __/ _  / / /_/ /_ |/ |/ /
 _/_/  |_/_/  /_/    /_/    /_/  \____/____/|__/
Running the Gunicorn Server with:
Workers: 4 sync
Host: 0.0.0.0:8080
Timeout: 120
Logfiles: - -
Access Logformat:
=================================================================
/home/airflow/.local/lib/python3.9/site-packages/flask_limiter/extension.py:333 UserWarning: Using the in-memory storage for tracking rate limits as no storage was explicitly specified. This is not recommended for production use. See: https://flask-limiter.readthedocs.io#configuring-a-storage-backend for documentation about configuring the storage backend.
[2024-08-02T05:57:32.289+0000] {override.py:938} INFO - Security DB not found Creating all Models from Base
[2024-08-02T05:57:33.075+0000] {override.py:953} ERROR - DB Creation and initialization failed: (MySQLdb.OperationalError) (1273, "Unknown collation: 'latin1_general_cs'")
[SQL:
CREATE TABLE dataset (
	id INTEGER NOT NULL AUTO_INCREMENT,
	uri VARCHAR(3000) COLLATE latin1_general_cs NOT NULL,
	extra JSON NOT NULL,
	created_at TIMESTAMP(6) NOT NULL,
	updated_at TIMESTAMP(6) NOT NULL,
	is_orphaned BOOL NOT NULL DEFAULT '0',
	CONSTRAINT dataset_pkey PRIMARY KEY (id)
)

]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
[2024-08-02T05:59:27.496+0000] {webserver_command.py:223} ERROR - No response from gunicorn master within 120 seconds
[2024-08-02T05:59:27.497+0000] {webserver_command.py:224} ERROR - Shutting down webserver