rsa routines:rsa_ossl_public_decrypt:data too large for modulus

[alemsas]

I cahnge in my configuraion Here is my first node

docker-compose.yml

version: '3.7'

services: percona1: image: percona/percona-xtradb-cluster:8.0 environment: - CLUSTER_NAME=pxc-cluster - XTRABACKUP_PASSWORD=xtrabackup_password - MYSQL_ROOT_PASSWORD=root_password - MYSQL_DATABASE=mydatabase - MYSQL_USER=myuser - MYSQL_PASSWORD=mypassword - WSREP_NODE_ADDRESS=172.31.60.117 volumes: - ./data:/var/lib/mysql - ./custom.cnf:/etc/mysql/conf.d/custom.cnf network_mode: "host"

cat custom.cnf

[mysqld] bind-address = 0.0.0.0 wsrep_on=ON wsrep_provider=/usr/lib64/galera4/libgalera_smm.so wsrep_cluster_name=pxc-cluster wsrep_cluster_address=gcomm:// wsrep_sst_method=xtrabackup-v2 wsrep_node_name="percona-cluster-db1" wsrep_node_address="172.31.60.117" server-id=1 wsrep_provider_options="socket.ssl=NO"

and here is my second node configuration

docker-compose.yml

version: '3.7'

services: percona2: image: percona/percona-xtradb-cluster:8.0 environment: - CLUSTER_NAME=pxc-cluster - XTRABACKUP_PASSWORD=xtrabackup_password - MYSQL_ROOT_PASSWORD=root_password - MYSQL_DATABASE=mydatabase - MYSQL_USER=myuser - MYSQL_PASSWORD=mypassword - WSREP_NODE_ADDRESS=172.31.60.119 volumes: - ./data:/var/lib/mysql - ./custom.cnf:/etc/mysql/conf.d/custom.cnf network_mode: "host"

cat custom.cnf

[mysqld] bind-address = 0.0.0.0 wsrep_on=ON wsrep_provider=/usr/lib64/galera4/libgalera_smm.so wsrep_cluster_name=pxc-cluster wsrep_cluster_address=gcomm://172.31.60.117:4567 wsrep_sst_method=xtrabackup-v2 wsrep_node_name="percona-cluster-db2" wsrep_node_address="172.31.60.119" server-id=2 wsrep_provider_options="socket.ssl=NO"

but i get these logs from first node container:

2024-05-03T11:56:46.994670Z 1 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification. 2024-05-03T11:56:46.998437Z 1 [Note] [MY-000000] [Galera] Recording CC from group: 25 2024-05-03T11:56:46.998900Z 1 [Note] [MY-000000] [Galera] Lowest cert index boundary for CC from group: 25 2024-05-03T11:56:46.999347Z 1 [Note] [MY-000000] [Galera] Min available from gcache for CC from group: 1 2024-05-03T11:56:48.298364Z 0 [Note] [MY-000000] [Galera] Member 1.0 (percona-cluster-db2) requested state transfer from 'any'. Selected 0.0 (percona-cluster-db1)(SYNCED) as donor. 2024-05-03T11:56:48.299065Z 0 [Note] [MY-000000] [Galera] Shifting SYNCED -> DONOR/DESYNCED (TO: 25) 2024-05-03T11:56:48.299471Z 1 [Note] [MY-000000] [Galera] Detected STR version: 1, req_len: 133, req: STRv1 2024-05-03T11:56:48.299864Z 1 [Note] [MY-000000] [Galera] Cert index preload: 25 -> 25 2024-05-03T11:56:48.300611Z 1 [Note] [MY-000000] [WSREP] Server status change synced -> donor 2024-05-03T11:56:48.300922Z 1 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification. 2024-05-03T11:56:48.301427Z 0 [Note] [MY-000000] [WSREP] Initiating SST/IST transfer on DONOR side (wsrep_sst_xtrabackup-v2 --role 'donor' --address '172.31.60.119:4444/xtrabackup_sst//1' --socket '/tmp/mysql.sock' --datadir '/var/lib/mysql/' --basedir '/usr/' --plugindir '/usr/lib64/mysql/plugin/' --defaults-file '/etc/my.cnf' --defaults-group-suffix '' --mysqld-version '8.0.36-28.1' '' --gtid '207ee875-0944-11ef-b35d-f6daf1e1f7e8:25' ) 2024-05-03T11:56:48.304418Z 0 [Note] [MY-000000] [Galera] async IST sender starting to serve tcp://172.31.60.119:4568 sending 25-25, preload starts from 25 2024-05-03T11:56:48.304916Z 0 [Note] [MY-000000] [Galera] IST sender 25 -> 25 2024-05-03T11:56:48.311069Z 12 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead' 2024-05-03T11:56:48.313052Z 1 [Note] [MY-000000] [WSREP] DONOR thread signaled with 0 2024-05-03T11:56:48.453845Z 0 [ERROR] [MY-000000] [WSREP-SST] ******************* ERROR ********************** 2024-05-03T11:56:48.454201Z 0 [ERROR] [MY-000000] [WSREP-SST] Missing version string in comparison 2024-05-03T11:56:48.454498Z 0 [ERROR] [MY-000000] [WSREP-SST] left-side: operation:< right-side:2.4.29 2024-05-03T11:56:48.454790Z 0 [ERROR] [MY-000000] [WSREP-SST] ******************* ERROR ********************** 2024-05-03T11:56:49.206508Z 0 [Note] [MY-000000] [Galera] (2bf9160d-9bfb, 'tcp://0.0.0.0:4567') turning message relay requesting off 2024-05-03T11:56:49.306498Z 13 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead' 2024-05-03T11:56:49.310960Z 13 [Warning] [MY-013712] [Server] No suitable 'keyring_component_metadata_query' service implementation found to fulfill the request. 2024-05-03T11:56:49.347607Z 0 [Note] [MY-000000] [WSREP-SST] 2024/05/03 11:56:49 socat[718] E SSL_connect(): error:04067084:rsa routines:rsa_ossl_public_decrypt:data too large for modulus 2024-05-03T11:56:50.365377Z 0 [Note] [MY-000000] [WSREP-SST] 2024/05/03 11:56:50 socat[721] E SSL_connect(): error:04067084:rsa routines:rsa_ossl_public_decrypt:data too large for modulus 2024-05-03T11:56:51.384731Z 0 [Note] [MY-000000] [WSREP-SST] 2024/05/03 11:56:51 socat[724] E SSL_connect(): error:04067084:rsa routines:rsa_ossl_public_decrypt:data too large for modulus 2024-05-03T11:56:52.404129Z 0 [Note] [MY-000000] [WSREP-SST] 2024/05/03 11:56:52 socat[727] E SSL_connect(): error:04067084:rsa routines:rsa_ossl_public_decrypt:data too large for modulus 2024-05-03T11:56:53.422993Z 0 [Note] [MY-000000] [WSREP-SST] 2024/05/03 11:56:53 socat[730] E SSL_connect(): error:04067084:rsa routines:rsa_ossl_public_decrypt:data too large for modulus 2024-05-03T11:56:54.440124Z 0 [Note] [MY-000000] [WSREP-SST] 2024/05/03 11:56:54 socat[733] E SSL_connect(): error:04067084:rsa routines:rsa_ossl_public_decrypt:data too large for modulus 2024-05-03T11:56:55.456840Z 0 [Note] [MY-000000] [WSREP-SST] 2024/05/03 11:56:55 socat[736] E SSL_connect(): error:04067084:rsa routines:rsa_ossl_public_decrypt:data too large for modulus 2024-05-03T11:56:56.474493Z 0 [Note] [MY-000000] [WSREP-SST] 2024/05/03 11:56:56 socat[739] E SSL_connect(): error:04067084:rsa routines:rsa_ossl_public_decrypt:data too large for modulus 2024-05-03T11:56:57.492080Z 0 [Note] [MY-000000] [WSREP-SST] 2024/05/03 11:56:57 socat[742] E SSL_connect(): error:04067084:rsa routines:rsa_ossl_public_decrypt:data too large for modulus 2024-05-03T11:56:58.508463Z 0 [Note] [MY-000000] [WSREP-SST] 2024/05/03 11:56:58 socat[745] E SSL_connect(): error:04067084:rsa routines:rsa_ossl_public_decrypt:data too large for modulus 2024-05-03T11:56:59.524905Z 0 [Note] [MY-000000] [WSREP-SST] 2024/05/03 11:56:59 socat[748] E SSL_connect(): error:04067084:rsa routines:rsa_ossl_public_decrypt:data too large for modulus 2024-05-03T11:57:00.542288Z 0 [Note] [MY-000000] [WSREP-SST] 2024/05/03 11:57:00 socat[751] E SSL_connect(): error:04067084:rsa routines:rsa_ossl_public_decrypt:data too large for modulus 2024-05-03T11:57:01.559595Z 0 [Note] [MY-000000] [WSREP-SST] 2024/05/03 11:57:01 socat[754] E SSL_connect(): error:04067084:rsa routines:rsa_ossl_public_decrypt:data too large for modulus 2024-05-03T11:57:02.577415Z 0 [Note] [MY-000000] [WSREP-SST] 2024/05/03 11:57:02 socat[757] E SSL_connect(): error:04067084:rsa routines:rsa_ossl_public_decrypt:data too large for modulus 2024-05-03T11:57:03.594968Z 0 [Note] [MY-000000] [WSREP-SST] 2024/05/03 11:57:03 socat[760] E SSL_connect(): error:04067084:rsa routines:rsa_ossl_public_decrypt:data too large for modulus 2024-05-03T11:57:04.611778Z 0 [Note] [MY-000000] [WSREP-SST] 2024/05/03 11:57:04 socat[763] E SSL_connect(): error:04067084:rsa routines:rsa_ossl_public_decrypt:data too large for modulus

and here is second nod log container

2024-05-03T11:56:46.509125Z 0 [Note] [MY-000000] [Galera] Save the discovered primary-component to disk 2024-05-03T11:56:46.999479Z 0 [Note] [MY-000000] [Galera] gcomm: connected 2024-05-03T11:56:46.999692Z 0 [Note] [MY-000000] [Galera] Changing maximum packet size to 64500, resulting msg size: 32636 2024-05-03T11:56:47.000042Z 0 [Note] [MY-000000] [Galera] Shifting CLOSED -> OPEN (TO: 0) 2024-05-03T11:56:47.000221Z 0 [Note] [MY-000000] [Galera] Opened channel 'pxc-cluster' 2024-05-03T11:56:47.001048Z 1 [Note] [MY-000000] [WSREP] Starting applier thread 1 2024-05-03T11:56:47.001380Z 2 [Note] [MY-000000] [WSREP] Starting rollbacker thread 2 2024-05-03T11:56:47.001687Z 0 [Note] [MY-000000] [Galera] New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2 2024-05-03T11:56:47.001954Z 0 [Note] [MY-000000] [Galera] STATE EXCHANGE: Waiting for state UUID. 2024-05-03T11:56:47.002272Z 0 [Note] [MY-000000] [Galera] STATE EXCHANGE: sent state msg: 377907e1-0944-11ef-ad3e-3635768b8a24 2024-05-03T11:56:47.002670Z 0 [Note] [MY-000000] [Galera] STATE EXCHANGE: got state msg: 377907e1-0944-11ef-ad3e-3635768b8a24 from 0 (percona-cluster-db1) 2024-05-03T11:56:47.002911Z 0 [Note] [MY-000000] [Galera] STATE EXCHANGE: got state msg: 377907e1-0944-11ef-ad3e-3635768b8a24 from 1 (percona-cluster-db2) 2024-05-03T11:56:47.003093Z 0 [Note] [MY-000000] [Galera] Quorum results: version = 6, component = PRIMARY, conf_id = 1, members = 1/2 (primary/total), act_id = 24, last_appl. = 23, protocols = 2/11/4 (gcs/repl/appl), vote policy= 0, group UUID = 207ee875-0944-11ef-b35d-f6daf1e1f7e8 2024-05-03T11:56:47.003486Z 0 [Note] [MY-000000] [Galera] Flow-control interval: [141, 141] 2024-05-03T11:56:47.003668Z 0 [Note] [MY-000000] [Galera] Shifting OPEN -> PRIMARY (TO: 25) 2024-05-03T11:56:47.003941Z 1 [Note] [MY-000000] [Galera] ####### processing CC 25, local, ordered 2024-05-03T11:56:47.004147Z 1 [Note] [MY-000000] [Galera] Maybe drain monitors from 1 upto current CC event 25 upto:1 2024-05-03T11:56:47.004355Z 1 [Note] [MY-000000] [Galera] Drain monitors from 1 up to 1 2024-05-03T11:56:47.004598Z 1 [Note] [MY-000000] [Galera] Process first view: 207ee875-0944-11ef-b35d-f6daf1e1f7e8 my uuid: 372e3f3b-0944-11ef-8259-27f90f2bc570 2024-05-03T11:56:47.004792Z 1 [Note] [MY-000000] [Galera] Server percona-cluster-db2 connected to cluster at position 207ee875-0944-11ef-b35d-f6daf1e1f7e8:25 with ID 372e3f3b-0944-11ef-8259-27f90f2bc570 2024-05-03T11:56:47.004986Z 1 [Note] [MY-000000] [WSREP] Server status change disconnected -> connected 2024-05-03T11:56:47.005251Z 1 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification. 2024-05-03T11:56:47.005509Z 1 [Note] [MY-000000] [Galera] ####### My UUID: 372e3f3b-0944-11ef-8259-27f90f2bc570 2024-05-03T11:56:47.005696Z 1 [Note] [MY-000000] [Galera] Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 11), state transfer needed: yes 2024-05-03T11:56:47.005957Z 0 [Note] [MY-000000] [Galera] Service thread queue flushed. 2024-05-03T11:56:47.006186Z 1 [Note] [MY-000000] [Galera] ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1 2024-05-03T11:56:47.006388Z 1 [Note] [MY-000000] [Galera] State transfer required: Group state: 207ee875-0944-11ef-b35d-f6daf1e1f7e8:25 Local state: 85c72e56-0943-11ef-b61d-772502bcc1ab:1 2024-05-03T11:56:47.006606Z 1 [Note] [MY-000000] [WSREP] Server status change connected -> joiner 2024-05-03T11:56:47.006791Z 1 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification. 2024-05-03T11:56:47.007149Z 0 [Note] [MY-000000] [WSREP] Initiating SST/IST transfer on JOINER side (wsrep_sst_xtrabackup-v2 --role 'joiner' --address '172.31.60.119' --datadir '/var/lib/mysql/' --basedir '/usr/' --plugindir '/usr/lib64/mysql/plugin/' --defaults-file '/etc/my.cnf' --defaults-group-suffix '' --parent '1' --mysqld-version '8.0.36-28.1' '' ) 2024-05-03T11:56:47.157768Z 0 [ERROR] [MY-000000] [WSREP-SST] ******************* ERROR ********************** 2024-05-03T11:56:47.157956Z 0 [ERROR] [MY-000000] [WSREP-SST] Missing version string in comparison 2024-05-03T11:56:47.158123Z 0 [ERROR] [MY-000000] [WSREP-SST] left-side: operation:< right-side:2.4.29 2024-05-03T11:56:47.158270Z 0 [ERROR] [MY-000000] [WSREP-SST] ******************* ERROR ********************** 2024-05-03T11:56:47.881463Z 0 [Warning] [MY-000000] [WSREP-SST] Found a stale sst_in_progress file: /var/lib/mysql//sst_in_progress 2024-05-03T11:56:48.315749Z 1 [Note] [MY-000000] [WSREP] Prepared SST request: xtrabackup-v2|172.31.60.119:4444/xtrabackup_sst//1 2024-05-03T11:56:48.316002Z 1 [Note] [MY-000000] [Galera] Check if state gap can be serviced using IST 2024-05-03T11:56:48.316185Z 1 [Note] [MY-000000] [Galera] Local UUID: 85c72e56-0943-11ef-b61d-772502bcc1ab != Group UUID: 207ee875-0944-11ef-b35d-f6daf1e1f7e8 2024-05-03T11:56:48.316362Z 1 [Note] [MY-000000] [Galera] ####### IST uuid:85c72e56-0943-11ef-b61d-772502bcc1ab f: 0, l: 25, STRv: 3 2024-05-03T11:56:48.316578Z 1 [Note] [MY-000000] [Galera] IST receiver addr using tcp://172.31.60.119:4568 2024-05-03T11:56:48.316916Z 1 [Note] [MY-000000] [Galera] Prepared IST receiver for 0-25, listening at: tcp://172.31.60.119:4568 2024-05-03T11:56:48.318542Z 0 [Note] [MY-000000] [Galera] Member 1.0 (percona-cluster-db2) requested state transfer from 'any'. Selected 0.0 (percona-cluster-db1)(SYNCED) as donor. 2024-05-03T11:56:48.318709Z 0 [Note] [MY-000000] [Galera] Shifting PRIMARY -> JOINER (TO: 25) 2024-05-03T11:56:48.318890Z 1 [Note] [MY-000000] [Galera] Requesting state transfer: success, donor: 0 2024-05-03T11:56:48.319057Z 1 [Note] [MY-000000] [Galera] Resetting GCache seqno map due to different histories. 2024-05-03T11:56:48.319208Z 1 [Note] [MY-000000] [Galera] GCache history reset: 85c72e56-0943-11ef-b61d-772502bcc1ab:1 -> 207ee875-0944-11ef-b35d-f6daf1e1f7e8:25 2024-05-03T11:56:48.319570Z 1 [Note] [MY-000000] [Galera] GCache DEBUG: RingBuffer::seqno_reset(): discarded 18446744073709551600 bytes 2024-05-03T11:56:48.319718Z 1 [Note] [MY-000000] [Galera] GCache DEBUG: RingBuffer::seqno_reset(): found 1/2 locked buffers 2024-05-03T11:56:49.499832Z 0 [Note] [MY-000000] [Galera] (372e3f3b-8259, 'tcp://0.0.0.0:4567') turning message relay requesting off

2024-05-03T11:57:19.889523Z 0 [Warning] [MY-000000] [Galera] 0.0 (percona-cluster-db1): State transfer to 1.0 (percona-cluster-db2) failed: -32 (Broken pipe) 2024-05-03T11:57:19.889985Z 0 [ERROR] [MY-000000] [Galera] /mnt/jenkins/workspace/pxc80-autobuild-RELEASE/test/rpmbuild/BUILD/Percona-XtraDB-Cluster-8.0.36/percona-xtradb-cluster-galera/gcs/src/gcs_group.cpp:gcs_group_handle_join_msg():1285: Will never receive state. Need to abort. 2024-05-03T11:57:19.891319Z 0 [Note] [MY-000000] [Galera] gcomm: terminating thread 2024-05-03T11:57:19.891818Z 0 [Note] [MY-000000] [Galera] gcomm: joining thread 2024-05-03T11:57:19.892427Z 0 [Note] [MY-000000] [Galera] gcomm: closing backend 2024-05-03T11:57:20.896114Z 0 [Note] [MY-000000] [Galera] Current view of cluster as seen by this node view (view_id(NON_PRIM,2bf9160d-9bfb,2) memb { 372e3f3b-8259,0 } joined { } left { } partitioned { 2bf9160d-9bfb,0 } ) 2024-05-03T11:57:20.898604Z 0 [Note] [MY-000000] [Galera] PC protocol downgrade 1 -> 0 2024-05-03T11:57:20.898943Z 0 [Note] [MY-000000] [Galera] Current view of cluster as seen by this node view ((empty)) 2024-05-03T11:57:20.899642Z 0 [Note] [MY-000000] [Galera] gcomm: closed 2024-05-03T11:57:20.899966Z 0 [Note] [MY-000000] [Galera] mysqld: Terminated. 2024-05-03T11:57:20.900248Z 0 [Note] [MY-000000] [WSREP] Initiating SST cancellation 2024-05-03T11:57:20.900524Z 0 [Note] [MY-000000] [WSREP] Terminating SST process 2024-05-03T11:57:20.904117Z 0 [ERROR] [MY-000000] [WSREP-SST] Removing /var/lib/mysql//xtrabackup_galera_info file due to signal 2024-05-03T11:57:20Z UTC - mysqld got signal 11 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. BuildID[sha1]=8849a9bea52d6d7129f6c4910d67e380da94c3ed Server Version: 8.0.36-28.1 Percona XtraDB Cluster (GPL), Release rel28, Revision bfb687f, WSREP version 26.1.4.3, wsrep_26.1.4.3

Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x100000 /usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x2283e41] 2024-05-03T11:57:20.912142Z 0 [ERROR] [MY-000000] [WSREP-SST] ******************* FATAL ERROR ********************** 2024-05-03T11:57:20.912430Z 0 [ERROR] [MY-000000] [WSREP-SST] SST script interrupted 2024-05-03T11:57:20.912694Z 0 [ERROR] [MY-000000] [WSREP-SST] ****************************************************** 2024-05-03T11:57:20.912948Z 0 [ERROR] [MY-000000] [WSREP-SST] Cleanup after exit with status:32

is there anyone to help me and solve this problem?!