I am using MySQL V8.4.0 & mysql connector odbc 8.4.0 on my RHEL 9.3 VM.
Getting below stacktrace when my application is trying to connect MySQL server:
<code>Stack trace of thread 1991278:
#0 0x00007fecdb19b3ac EVP_PKEY_get_size (libcrypto.so.3 + 0x19b3ac)
#1 0x00007fecdb6cfea8 _Z33caching_sha2_password_auth_clientP16MYSQL_PLUGIN_VIOP5MYSQL (libmyodbc8w.so + 0xcfea8)
#2 0x00007fecdb6c3376 _ZL34authsm_run_first_authenticate_userP16mysql_async_auth (libmyodbc8w.so + 0xc3376)
#3 0x00007fecdb6c602c run_plugin_auth (libmyodbc8w.so + 0xc602c)
#4 0x00007fecdb6c6244 _ZL16csm_authenticateP19mysql_async_connect (libmyodbc8w.so + 0xc6244)
#5 0x00007fecdb6c82e9 connect_helper (libmyodbc8w.so + 0xc82e9)
#6 0x00007fecdb6c6354 mysql_real_connect (libmyodbc8w.so + 0xc6354)
#7 0x00007fecdb68702b _ZN3DBC7connectEP10DataSource (libmyodbc8w.so + 0x8702b)
#8 0x00007fecdb688b66 _Z18MySQLDriverConnectPvS_PtsS0_sPst (libmyodbc8w.so + 0x88b66)
#9 0x00007fecdb6b3b94 SQLDriverConnectW (libmyodbc8w.so + 0xb3b94)
#10 0x00007fecdeeb0a48 SQLDriverConnect (libodbc.so + 0x1ca48)
<code>Stack trace of thread 1991278:
#0 0x00007fecdb19b3ac EVP_PKEY_get_size (libcrypto.so.3 + 0x19b3ac)
#1 0x00007fecdb6cfea8 _Z33caching_sha2_password_auth_clientP16MYSQL_PLUGIN_VIOP5MYSQL (libmyodbc8w.so + 0xcfea8)
#2 0x00007fecdb6c3376 _ZL34authsm_run_first_authenticate_userP16mysql_async_auth (libmyodbc8w.so + 0xc3376)
#3 0x00007fecdb6c602c run_plugin_auth (libmyodbc8w.so + 0xc602c)
#4 0x00007fecdb6c6244 _ZL16csm_authenticateP19mysql_async_connect (libmyodbc8w.so + 0xc6244)
#5 0x00007fecdb6c82e9 connect_helper (libmyodbc8w.so + 0xc82e9)
#6 0x00007fecdb6c6354 mysql_real_connect (libmyodbc8w.so + 0xc6354)
#7 0x00007fecdb68702b _ZN3DBC7connectEP10DataSource (libmyodbc8w.so + 0x8702b)
#8 0x00007fecdb688b66 _Z18MySQLDriverConnectPvS_PtsS0_sPst (libmyodbc8w.so + 0x88b66)
#9 0x00007fecdb6b3b94 SQLDriverConnectW (libmyodbc8w.so + 0xb3b94)
#10 0x00007fecdeeb0a48 SQLDriverConnect (libodbc.so + 0x1ca48)
</code>
Stack trace of thread 1991278:
#0 0x00007fecdb19b3ac EVP_PKEY_get_size (libcrypto.so.3 + 0x19b3ac)
#1 0x00007fecdb6cfea8 _Z33caching_sha2_password_auth_clientP16MYSQL_PLUGIN_VIOP5MYSQL (libmyodbc8w.so + 0xcfea8)
#2 0x00007fecdb6c3376 _ZL34authsm_run_first_authenticate_userP16mysql_async_auth (libmyodbc8w.so + 0xc3376)
#3 0x00007fecdb6c602c run_plugin_auth (libmyodbc8w.so + 0xc602c)
#4 0x00007fecdb6c6244 _ZL16csm_authenticateP19mysql_async_connect (libmyodbc8w.so + 0xc6244)
#5 0x00007fecdb6c82e9 connect_helper (libmyodbc8w.so + 0xc82e9)
#6 0x00007fecdb6c6354 mysql_real_connect (libmyodbc8w.so + 0xc6354)
#7 0x00007fecdb68702b _ZN3DBC7connectEP10DataSource (libmyodbc8w.so + 0x8702b)
#8 0x00007fecdb688b66 _Z18MySQLDriverConnectPvS_PtsS0_sPst (libmyodbc8w.so + 0x88b66)
#9 0x00007fecdb6b3b94 SQLDriverConnectW (libmyodbc8w.so + 0xb3b94)
#10 0x00007fecdeeb0a48 SQLDriverConnect (libodbc.so + 0x1ca48)
Using Connection string as: “Driver={MySQL ODBC 8.4 Unicode Driver};Server=localhost;Database=testdb;UID=root;PWD=*;SslMode=Disabled;GET_SERVER_PUBLIC_KEY=1″
If I connect to the mysql server using mysql client with credentials it is working fine.
After mysql client, my application also working fine and no crash observed.
If I restart the mysql server and directly executed my application, it is crashing again.
To make it work properly, I have to manually start mysql client and do login after every MySQL server restart.
What could be the problem here ?
My application should connect to MySQL server without crashing everytime.
There should be no need to start mysql client everytime after restarting the MySQL server.