[YSQL] PG OPENSSL_LH_insert related core dump in mount and tserver restart test scenario

[qvad]

Jira Link: DB-14104

Description

This core dump occurred during unmount volume test in one of the latest master builds
1730760028 looks like is exactly time when we restarted node and mount directory back.

(lldb) target create "/home/yugabyte/yb-software/yugabyte-2.25.0.0-b254-almalinux8-aarch64/postgres/bin/postgres" --core "/home/yugabyte/cores/core_yb.1730760028.postgres.121340.121378"
Core file '/home/yugabyte/cores/core_yb.1730760028.postgres.121340.121378' (aarch64) was loaded.
(lldb) bt all
* thread #1, name = 'postgres', stop reason = signal SIGQUIT
  * frame #0: 0x0000ffff80e1bc88 libcrypto.so.3`OPENSSL_LH_insert + 360
    frame #1: 0x0000ffff80e43d80 libcrypto.so.3`OBJ_NAME_add + 288
    frame #2: 0x0000ffff80dcc2b0 libcrypto.so.3`openssl_add_all_ciphers_int + 4480
    frame #3: 0x0000ffff80e27b7c libcrypto.so.3`ossl_init_add_all_ciphers_ossl_ + 12
    frame #4: 0x0000ffff7fe7f7ac libpthread.so.0`__pthread_once_slow + 284
    frame #5: 0x0000ffff80e250f0 libcrypto.so.3`OPENSSL_init_crypto + 448
    frame #6: 0x0000ffff80e1fd20 libcrypto.so.3`ossl_namemap_stored + 96
    frame #7: 0x0000ffff80dee364 libcrypto.so.3`inner_evp_generic_fetch + 100
    frame #8: 0x0000ffff80e72aac libcrypto.so.3`rand_new_seed + 108
    frame #9: 0x0000ffff80e72990 libcrypto.so.3`RAND_get0_primary + 208
    frame #10: 0x0000ffff80e736c8 libcrypto.so.3`RAND_status + 72
    frame #11: 0x0000aaaad4219378 postgres`pg_strong_random(buf=0x0000aaaad4343b10, len=16) at pg_strong_random.c:84:7
    frame #12: 0x0000aaaad3eb214c postgres`InitProcessGlobals at postmaster.c:2905:6
    frame #13: 0x0000aaaad3eb06d0 postgres`PostmasterMain(argc=25, argv=0x000034ac3fd220d0) at postmaster.c:614:2
    frame #14: 0x0000aaaad3da2d68 postgres`PostgresServerProcessMain(argc=25, argv=0x000034ac3fd220d0) at main.c:208:3
    frame #15: 0x0000aaaad3a01af8 postgres`main + 36
    frame #16: 0x0000ffff7fd14384 libc.so.6`__libc_start_main + 220
    frame #17: 0x0000aaaad3a019b4 postgres`_start + 52

Issue Type

kind/bug

Warning: Please confirm that this issue does not contain any sensitive information

• I confirm this issue does not contain any sensitive information.

[Arjun-yb]

Noticed

Core file '/home/yugabyte/cores/core_145965_1734426775_!home!yugabyte!yb-software!yugabyte-2024.2.1.0-b108-almalinux8-aarch64!postgres!bin!postgres' (aarch64) was loaded.
(lldb) bt all
* thread #1, name = 'postgres', stop reason = signal SIGABRT
  * frame #0: 0x0000ffff9bba6274 libc.so.6`raise + 172
    frame #1: 0x0000ffff9bb90a2c libc.so.6`abort + 276
    frame #2: 0x0000aaaac8328580 postgres`errfinish(dummy=<unavailable>) at elog.c:817:3
    frame #3: 0x0000aaaac7d18d00 postgres`StartupXLOG at xlog.c:6661:4
    frame #4: 0x0000aaaac80ace34 postgres`StartupProcessMain at startup.c:211:2
    frame #5: 0x0000aaaac7d422d8 postgres`AuxiliaryProcessMain(argc=<unavailable>, argv=<unavailable>) at bootstrap.c:447:4
    frame #6: 0x0000aaaac80a6398 postgres`StartChildProcess(type=<unavailable>) at postmaster.c:5829:3
    frame #7: 0x0000aaaac80a2fe4 postgres`PostmasterMain(argc=<unavailable>, argv=<unavailable>) at postmaster.c:1435:15
    frame #8: 0x0000aaaac7f9a624 postgres`PostgresServerProcessMain(argc=25, argv=0x000024bdbfd220d0) at main.c:234:3
    frame #9: 0x0000aaaac7c53278 postgres`main + 36
    frame #10: 0x0000ffff9bb94384 libc.so.6`__libc_start_main + 220
    frame #11: 0x0000aaaac7c53134 postgres`_start + 52```
    
    in another run in `2024.2.1.0-b108` build