When starting MySQL flexible after server crash (after memory leak), plugin aad_auth cannot start, because Function 'aad_auth' already exists.
This leads to server to not be able to authorize connections using EntraID. There is need to reenable EntraID in portal/CLI, which makes it work.
Is this just another MS bug, or it is something, we can avoid by some proper configuration? There is no information on https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-azure-ad-authentication.
2024-08-05T09:56:08.525198Z 0 [ERROR] [MY-013180] [Server] Function 'aad_auth' already exists.
2024-08-05T09:56:08.525352Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'aad_auth' with soname 'aad_auth.so'.
Full log of server startup:
2024-08-05T09:55:38.836417Z 0 [Note] [MY-013667] [Server] Error-log destination "stderr" is not a file. Can not restore error log messages from previous run.
2024-08-05T09:55:38.612484Z 0 [Warning] [MY-010079] [Server] Invalid instrument name or value for performance_schema_instrument ''
2024-08-05T09:55:38.820692Z 0 [Warning] [MY-013245] [Server] The SSL library function CRYPTO_set_mem_functions failed. This is typically caused by the SSL library already being used. As a result the SSL memory allocation will not be instrumented.
2024-08-05T09:55:38.822000Z 0 [Warning] [MY-011069] [Server] The syntax 'avoid_temporal_upgrade' is deprecated and will be removed in a future release.
2024-08-05T09:55:38.822131Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2024-08-05T09:55:38.822462Z 0 [Warning] [MY-011069] [Server] The syntax '--log-bin-use-v1-row-events' is deprecated and will be removed in a future release.
2024-08-05T09:55:38.822486Z 0 [Warning] [MY-011068] [Server] The syntax 'log_slave_updates' is deprecated and will be removed in a future release. Please use log_replica_updates instead.
2024-08-05T09:55:38.822497Z 0 [Warning] [MY-011068] [Server] The syntax 'log_slow_slave_statements' is deprecated and will be removed in a future release. Please use log_slow_replica_statements instead.
2024-08-05T09:55:38.822520Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2024-08-05T09:55:38.822526Z 0 [Warning] [MY-011068] [Server] The syntax 'master_verify_checksum' is deprecated and will be removed in a future release. Please use source_verify_checksum instead.
2024-08-05T09:55:38.822776Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2024-08-05T09:55:38.822792Z 0 [Warning] [MY-011068] [Server] The syntax 'rpl_stop_slave_timeout' is deprecated and will be removed in a future release. Please use rpl_stop_replica_timeout instead.
2024-08-05T09:55:38.822824Z 0 [Warning] [MY-011069] [Server] The syntax 'show_old_temporals' is deprecated and will be removed in a future release.
2024-08-05T09:55:38.822837Z 0 [Warning] [MY-011068] [Server] The syntax 'skip_slave_start' is deprecated and will be removed in a future release. Please use skip_replica_start instead.
2024-08-05T09:55:38.822843Z 0 [Warning] [MY-011068] [Server] The syntax 'slave_allow_batching' is deprecated and will be removed in a future release. Please use replica_allow_batching instead.
2024-08-05T09:55:38.822851Z 0 [Warning] [MY-011068] [Server] The syntax 'slave_checkpoint_group' is deprecated and will be removed in a future release. Please use replica_checkpoint_group instead.
2024-08-05T09:55:38.822857Z 0 [Warning] [MY-011068] [Server] The syntax 'slave_checkpoint_period' is deprecated and will be removed in a future release. Please use replica_checkpoint_period instead.
2024-08-05T09:55:38.822863Z 0 [Warning] [MY-011068] [Server] The syntax 'slave_compressed_protocol' is deprecated and will be removed in a future release. Please use replica_compressed_protocol instead.
2024-08-05T09:55:38.822871Z 0 [Warning] [MY-011068] [Server] The syntax 'slave_exec_mode' is deprecated and will be removed in a future release. Please use replica_exec_mode instead.
2024-08-05T09:55:38.822876Z 0 [Warning] [MY-011068] [Server] The syntax 'slave_load_tmpdir' is deprecated and will be removed in a future release. Please use replica_load_tmpdir instead.
2024-08-05T09:55:38.822881Z 0 [Warning] [MY-011068] [Server] The syntax 'slave_max_allowed_packet' is deprecated and will be removed in a future release. Please use replica_max_allowed_packet instead.
2024-08-05T09:55:38.822887Z 0 [Warning] [MY-011068] [Server] The syntax 'slave_net_timeout' is deprecated and will be removed in a future release. Please use replica_net_timeout instead.
2024-08-05T09:55:38.822894Z 0 [Warning] [MY-011068] [Server] The syntax 'slave_parallel_type' is deprecated and will be removed in a future release. Please use replica_parallel_type instead.
2024-08-05T09:55:38.822897Z 0 [Warning] [MY-011069] [Server] The syntax '--replica-parallel-type' is deprecated and will be removed in a future release.
2024-08-05T09:55:38.822903Z 0 [Warning] [MY-011068] [Server] The syntax 'slave_parallel_workers' is deprecated and will be removed in a future release. Please use replica_parallel_workers instead.
2024-08-05T09:55:38.822909Z 0 [Warning] [MY-011068] [Server] The syntax 'slave_pending_jobs_size_max' is deprecated and will be removed in a future release. Please use replica_pending_jobs_size_max instead.
2024-08-05T09:55:38.822914Z 0 [Warning] [MY-011068] [Server] The syntax 'slave_preserve_commit_order' is deprecated and will be removed in a future release. Please use replica_preserve_commit_order instead.
2024-08-05T09:55:38.822920Z 0 [Warning] [MY-011069] [Server] The syntax '--slave-rows-search-algorithms' is deprecated and will be removed in a future release.
2024-08-05T09:55:38.822927Z 0 [Warning] [MY-011068] [Server] The syntax 'slave_skip_errors' is deprecated and will be removed in a future release. Please use replica_skip_errors instead.
2024-08-05T09:55:38.822932Z 0 [Warning] [MY-011068] [Server] The syntax 'slave_sql_verify_checksum' is deprecated and will be removed in a future release. Please use replica_sql_verify_checksum instead.
2024-08-05T09:55:38.822937Z 0 [Warning] [MY-011068] [Server] The syntax 'slave_transaction_retries' is deprecated and will be removed in a future release. Please use replica_transaction_retries instead.
2024-08-05T09:55:38.822942Z 0 [Warning] [MY-011068] [Server] The syntax 'slave_type_conversions' is deprecated and will be removed in a future release. Please use replica_type_conversions instead.
2024-08-05T09:55:38.822970Z 0 [Warning] [MY-011068] [Server] The syntax 'sync_master_info' is deprecated and will be removed in a future release. Please use sync_source_info instead.
2024-08-05T09:55:38.823033Z 0 [Warning] [MY-011069] [Server] The syntax '--transaction-write-set-extraction' is deprecated and will be removed in a future release.
2024-08-05T09:55:38.823347Z 0 [Note] [MY-000000] [Server] mount dir '/app/work'
2024-08-05T09:55:38.823361Z 0 [Note] [MY-010098] [Server] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2024-08-05T09:55:38.823704Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2024-08-05T09:55:38.823869Z 0 [Note] [MY-013932] [Server] BuildID[sha1]=db61038fe03d280f43f2d772beafc67bb6653bb9
2024-08-05T09:55:38.823873Z 0 [Note] [MY-010949] [Server] Basedir set to /mysql/.
2024-08-05T09:55:38.823882Z 0 [System] [MY-010116] [Server] /mysql/bin/mysqld (mysqld 8.0.32) starting as process 139
2024-08-05T09:55:38.832305Z 0 [Note] [MY-000000] [Server] new coredump filter: 0x00000037
2024-08-05T09:55:38.998512Z 0 [Warning] [MY-000080] [Server] option 'innodb-open-files': signed value -1 adjusted to 0.
2024-08-05T09:55:39.000634Z 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
2024-08-05T09:55:39.001780Z 0 [Note] [MY-010747] [Server] Plugin 'ARCHIVE' is disabled.
2024-08-05T09:55:39.001832Z 0 [Note] [MY-010747] [Server] Plugin 'BLACKHOLE' is disabled.
2024-08-05T09:55:39.001853Z 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2024-08-05T09:55:39.001904Z 0 [Note] [MY-010747] [Server] Plugin 'mysqlx' is disabled.
2024-08-05T09:55:39.043816Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-08-05T09:55:39.044012Z 1 [Note] [MY-013547] [InnoDB] Atomic write disabled
2024-08-05T09:55:39.098803Z 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2024-08-05T09:55:39.098872Z 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2024-08-05T09:55:39.098893Z 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2024-08-05T09:55:39.098933Z 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.13
2024-08-05T09:55:39.103547Z 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication.
2024-08-05T09:55:39.104865Z 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
2024-08-05T09:55:39.138321Z 1 [Note] [MY-012204] [InnoDB] Scanning './'
2024-08-05T09:55:39.195813Z 1 [Note] [MY-013503] [InnoDB] Directory '/app/work/data/.binlogposclean' will not be scanned because it is a hidden directory.
2024-08-05T09:55:39.195975Z 1 [Note] [MY-013503] [InnoDB] Directory '/app/work/data/.build_number' will not be scanned because it is a hidden directory.
2024-08-05T09:55:39.196037Z 1 [Note] [MY-013503] [InnoDB] Directory '/app/work/data/.dataversion' will not be scanned because it is a hidden directory.
2024-08-05T09:55:39.196089Z 1 [Note] [MY-013503] [InnoDB] Directory '/app/work/data/.dataversionupgrade_8028' will not be scanned because it is a hidden directory.
2024-08-05T09:55:39.196137Z 1 [Note] [MY-013503] [InnoDB] Directory '/app/work/data/.enginecontainerstarttime' will not be scanned because it is a hidden directory.
2024-08-05T09:55:39.196182Z 1 [Note] [MY-013503] [InnoDB] Directory '/app/work/data/.myinitfile' will not be scanned because it is a hidden directory.
2024-08-05T09:55:39.196229Z 1 [Note] [MY-013503] [InnoDB] Directory '/app/work/data/.replay' will not be scanned because it is a hidden directory.
2024-08-05T09:55:39.196274Z 1 [Note] [MY-013503] [InnoDB] Directory '/app/work/data/.running' will not be scanned because it is a hidden directory.
2024-08-05T09:55:39.196316Z 1 [Note] [MY-013503] [InnoDB] Directory '/app/work/data/.setup' will not be scanned because it is a hidden directory.
2024-08-05T09:55:39.709549Z 1 [Note] [MY-012206] [InnoDB] Found 769 '.ibd' and 2 undo files
2024-08-05T09:55:39.709660Z 1 [Note] [MY-012207] [InnoDB] Using 2 threads to scan 769 tablespace files
2024-08-05T09:55:49.712275Z 0 [Note] [MY-012200] [InnoDB] Thread# 0 - Checked 499/769 files
2024-08-05T09:55:54.608216Z 0 [Note] [MY-012201] [InnoDB] Checked 769 files
2024-08-05T09:55:54.670127Z 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 771 files.
2024-08-05T09:55:54.672385Z 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 57.000000G, instances = 8, chunk size =128.000000M
2024-08-05T09:55:54.672756Z 1 [Note] [MY-011825] [InnoDB] HOTCACHE: Hot Cache is OFF
2024-08-05T09:55:56.130246Z 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2024-08-05T09:55:56.333409Z 1 [Note] [MY-011825] [InnoDB] delayed data sync enabled
2024-08-05T09:55:56.333495Z 1 [Note] [MY-011825] [InnoDB] delayed log write enabled
2024-08-05T09:55:56.334914Z 0 [Note] [MY-011825] [InnoDB] dynamic page cleaner priority enabled
2024-08-05T09:55:56.335024Z 0 [Note] [MY-011825] [InnoDB] page cleaner threads:
2024-08-05T09:55:56.335049Z 0 [Note] [MY-011825] [InnoDB] writer thread, id 924808768, uniqid 188
2024-08-05T09:55:56.335069Z 0 [Note] [MY-011825] [InnoDB] pgcleaner_coord thread, id 2714072640, uniqid 189
2024-08-05T09:55:56.715396Z 1 [Note] [MY-011825] [InnoDB] HOTCACHE: restore(): Feature flag is off
2024-08-05T09:55:56.949756Z 1 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 7358626244139 in redo log file ./#innodb_redo/#ib_redo233660.
2024-08-05T09:55:56.957510Z 1 [Note] [MY-012560] [InnoDB] The log sequence number 6935079101123 in the system tablespace does not match the log sequence number 7358626244139 in the redo log files!
2024-08-05T09:55:56.957581Z 1 [Note] [MY-012551] [InnoDB] Database was not shutdown normally!
2024-08-05T09:55:56.957608Z 1 [Note] [MY-012552] [InnoDB] Starting crash recovery.
2024-08-05T09:55:56.972595Z 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 7358626253449, whereas checkpoint_lsn = 7358626244139 and start_lsn = 7358626244096
2024-08-05T09:55:57.550433Z 1 [Note] [MY-012550] [InnoDB] Doing recovery: scanned up to log sequence number 7358629130503
2024-08-05T09:55:57.692392Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2024-08-05T09:55:57.693236Z 1 [Note] [MY-012532] [InnoDB] Applying a batch of 2547 redo log records ...
2024-08-05T09:55:57.955656Z 1 [Note] [MY-012533] [InnoDB] 10%
2024-08-05T09:55:58.197256Z 1 [Note] [MY-012533] [InnoDB] 20%
2024-08-05T09:55:58.578795Z 1 [Note] [MY-012533] [InnoDB] 30%
2024-08-05T09:55:58.579064Z 1 [Note] [MY-012533] [InnoDB] 40%
2024-08-05T09:55:58.678676Z 1 [Note] [MY-012533] [InnoDB] 50%
2024-08-05T09:55:58.724368Z 1 [Note] [MY-012533] [InnoDB] 60%
2024-08-05T09:55:58.950739Z 1 [Note] [MY-012533] [InnoDB] 70%
2024-08-05T09:55:59.145934Z 1 [Note] [MY-012533] [InnoDB] 80%
2024-08-05T09:55:59.358889Z 1 [Note] [MY-012533] [InnoDB] 90%
2024-08-05T09:55:59.657896Z 1 [Note] [MY-012533] [InnoDB] 100%
2024-08-05T09:56:00.204032Z 1 [Note] [MY-012535] [InnoDB] Apply batch completed!
2024-08-05T09:56:00.487362Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
2024-08-05T09:56:00.566244Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
2024-08-05T09:56:01.235516Z 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
2024-08-05T09:56:01.235838Z 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 8434327847
2024-08-05T09:56:01.644776Z 1 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete
2024-08-05T09:56:01.644931Z 1 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 4 thread: 409119 ms.
2024-08-05T09:56:01.645049Z 1 [Note] [MY-013023] [InnoDB] 1 transaction(s) which must be rolled back or cleaned up in total 1 row operations to undo
2024-08-05T09:56:01.645095Z 1 [Note] [MY-013024] [InnoDB] Trx id counter is 8434328321
2024-08-05T09:56:01.678294Z 1 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
2024-08-05T09:56:01.678352Z 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2024-08-05T09:56:01.689824Z 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-08-05T09:56:01.821796Z 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2024-08-05T09:56:01.845375Z 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'/mnt/temp/'
2024-08-05T09:56:01.854040Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2024-08-05T09:56:01.854513Z 0 [Note] [MY-011825] [InnoDB] aggressive page cleaner enabled
2024-08-05T09:56:01.854596Z 0 [Note] [MY-011953] [InnoDB] Page cleaner took 5520ms to flush 0 and evict 0 pages
2024-08-05T09:56:01.859134Z 1 [Note] [MY-012976] [InnoDB] 8.0.32 started; log sequence number 7358629130625
2024-08-05T09:56:01.859487Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-08-05T09:56:01.956427Z 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80023'.
2024-08-05T09:56:03.310427Z 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files
2024-08-05T09:56:08.039787Z 1 [Note] [MY-012356] [InnoDB] Scanned 773 tablespaces. Validated 773.
2024-08-05T09:56:08.429922Z 0 [Note] [MY-013014] [InnoDB] Starting in background the rollback of uncommitted transactions
2024-08-05T09:56:08.430048Z 0 [Note] [MY-013011] [InnoDB] Rolling back trx with id 8434327845, 1 rows to undo
2024-08-05T09:56:08.452857Z 0 [Note] [MY-013012] [InnoDB] Rollback of trx with id 8434327845 completed
2024-08-05T09:56:08.453007Z 0 [Note] [MY-013015] [InnoDB] Rollback of non-prepared transactions completed
2024-08-05T09:56:08.492507Z 1 [Note] [MY-010006] [Server] Using data dictionary with version '80023'.
2024-08-05T09:56:08.525198Z 0 [ERROR] [MY-013180] [Server] Function 'aad_auth' already exists.
2024-08-05T09:56:08.525352Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'aad_auth' with soname 'aad_auth.so'.
2024-08-05T09:56:08.525964Z 0 [Note] [MY-000000] [Server] BINLOG: THD sync lock/cond enabled.
2024-08-05T09:56:08.748533Z 0 [Note] [MY-010902] [Server] Thread priority attribute setting in Resource Group SQL shall be ignored due to unsupported platform or insufficient privilege.
2024-08-05T09:56:09.176948Z 0 [Note] [MY-010855] [Server] Recovering after a crash using /app/work/binlogs/mysql-bin
2024-08-05T09:56:14.144405Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2024-08-05T09:56:14.151712Z 0 [Note] [MY-013911] [Server] Crash recovery finished in binlog engine. No attempts to commit, rollback or prepare any transactions.
2024-08-05T09:56:14.151782Z 0 [Note] [MY-013911] [Server] Crash recovery finished in InnoDB engine. No attempts to commit, rollback or prepare any transactions.
2024-08-05T09:56:14.151798Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2024-08-05T09:56:14.548689Z 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin
2024-08-05T09:56:14.554917Z 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 57.99999999999999%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)