Error in joiner node Too many arguments first extra is 'file'.

[Angelo Lavides]

Hi,

I'm not sure if my recent message has been posted. please delete if this is duplicate.

Anyway, we are having this error after the joiner node successfully syncs, may we know what causes this error. Is this related to innodb or galera?

2022-10-22T08:56:33.135409Z 0 [Note] WSREP: 4.1 (Prod2): State transfer to 2.1 (Prod3) complete.
2022-10-22T08:56:33.137752Z 0 [Note] WSREP: Member 4.1 (Prod2) synced with group.
WSREP_SST: [INFO] Joiner cleanup. rsync PID: 2108 (20221022 16:56:33.267)
WSREP_SST: [INFO] Joiner cleanup done. (20221022 16:56:33.777)
2022-10-22T08:56:33.779499Z 0 [Note] WSREP: SST complete, seqno: 722712
2022-10-22T08:56:33.781560Z 0 [Note] InnoDB: PUNCH HOLE support available
2022-10-22T08:56:33.781601Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-10-22T08:56:33.781606Z 0 [Note] InnoDB: Uses event mutexes
2022-10-22T08:56:33.781611Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2022-10-22T08:56:33.781616Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-10-22T08:56:33.781656Z 0 [Note] InnoDB: Using Linux native AIO
2022-10-22T08:56:33.781962Z 0 [Note] InnoDB: Number of pools: 1
2022-10-22T08:56:33.782074Z 0 [Note] InnoDB: Using CPU crc32 instructions
2022-10-22T08:56:33.785078Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-10-22T08:56:33.794535Z 0 [Note] InnoDB: Completed initialization of buffer pool
2022-10-22T08:56:33.796812Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-10-22T08:56:33.809511Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2022-10-22T08:56:33.815517Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 3502937134
2022-10-22T08:56:33.815545Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 3502937143
2022-10-22T08:56:33.815550Z 0 [Note] InnoDB: Database was not shutdown normally!
2022-10-22T08:56:33.815554Z 0 [Note] InnoDB: Starting crash recovery.
2022-10-22T08:56:34.151289Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-10-22T08:56:34.151393Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-10-22T08:56:34.210198Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-10-22T08:56:34.210973Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2022-10-22T08:56:34.211001Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2022-10-22T08:56:34.212729Z 0 [Note] InnoDB: Waiting for purge to start
2022-10-22T08:56:34.262968Z 0 [Note] InnoDB: 5.7.35 started; log sequence number 3502937143
2022-10-22T08:56:34.263003Z 0 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!!
2022-10-22T08:56:34.263211Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2022-10-22T08:56:34.263383Z 0 [Note] Plugin 'FEDERATED' is disabled.
2022-10-22T08:56:34.264719Z 0 [Note] InnoDB: Buffer pool(s) load completed at 221022 16:56:34
2022-10-22T08:56:34.269781Z 0 [ERROR] Too many arguments (first extra is 'file').
2022-10-22T08:56:34.269802Z 0 [Note] Use --verbose --help to get a list of available options!
2022-10-22T08:56:34.269805Z 0 [ERROR] Aborting
2022-10-22T08:56:34.269808Z 0 [Note] Giving 2 client threads a chance to die gracefully