Discrepancies with latest pxc build and tarball

Description

Hi Team , 

Various issues has been noticed which are described below .

1) Difference in wsrep_provider_version in tarball and compiled vuild 

In tarball i can see

In compiled build

2) Revision seems to be empty in tarball 

 

 

 
 

Environment

None

Activity

Show:

puneet.kaushik March 13, 2023 at 7:13 AM

Executed Tarball tests and they look good , so Tarball is fixed now .

puneet.kaushik March 13, 2023 at 6:22 AM

Hi Alex , 
Thanks for the update , let me run some tests and get back to you.

Alex Miroshnychenko March 13, 2023 at 6:19 AM

Hi  
The issues were sorted out, so now the Revision is properly shown in binary tarballs and the installation on DEB systems finishes correctly.

Venkatesh Prasad March 8, 2023 at 7:21 PM

The root cause is below

  1. The inti sql file has a SHUTDOWN command in it. Since this gets run when mysqld is not fullt started, the server sets mysqld_process_must_end_at_startup flag inside kill_mysql() function.

  2. Once the server bootstrap is over, the server checks that mysqld_process_must_end_at_startup is set and thus calls unireg_abort(), which in turn sets wsrep_unireg_abort flag.

  3. On the other side, we have the replication process thread that is trying to update the XID in InnoDB after storing the view in stable storage. This is done by calling wsrep_set_SE_checkpoint() function in Wsrep_server_service::log_view().

  4. Since wsrep_unireg_abort flag is already set by the bootstrap thread, the call to wsrep_set_SE_checkpoint() will perform an early return with invalid gtid resulting in the above error.

 

The below patch fixed the assertion failure on debug builds. However the SIGSEGV was not seen on release builds.

puneet.kaushik March 6, 2023 at 12:57 PM

Hey   , 

Please let me know whenever you have any updates , i will run tests again.

Done

Details

Assignee

Reporter

Needs QA

Yes

Components

Affects versions

Priority

Smart Checklist

Created March 3, 2023 at 2:21 PM
Updated March 6, 2024 at 8:44 PM
Resolved March 16, 2023 at 2:02 PM