Issues
- Prevent SST after IST failurePXC-4631Kamil Holubicki
- Creating temporary table as select puts the whole session in TOI/NBO not allowing to kill any queryPXC-4629
- Assertion `msg.uuid() != GU_UUID_NIL' failed in debug buildPXC-4604
- SST Role lacks INNODB_REDO_LOG_ARCHIVEPXC-4573Resolved issue: PXC-4573Kamil Holubicki
- PXC is not compatible with sql_generate_invisible_primary_key settingPXC-4548
- Replication fails and the node becomes Inconsistent if transaction is committed on node by setting tagged gtidPXC-4526Venkatesh Prasad
- Garb receiving error/fatal messages during the stopPXC-4522
- DROP PROCEDURE/FUNCTION IF EXISTS generates local GTID eventPXC-4504Resolved issue: PXC-4504Kamil Holubicki
- Assertion `state() == s_executing || state() == s_preparing || state() == s_prepared || state() == s_must_abort || state() == s_aborting || state() == s_cert_failed || state() == s_must_replay' failedPXC-4491
- pc.bootstrap not seen in wsrep_provider_optionsPXC-4440
- Create file with current MySQL statePXC-4433Resolved issue: PXC-4433Kamil Holubicki
- Garbd terminates SST script's children after SST is completePXC-4428Resolved issue: PXC-4428Kamil Holubicki
- SPIKE - investigate the improvement and propose implementation solutionPXC-4425Resolved issue: PXC-4425
- A PXC node receiving write statements will become unresponsive when another node enters or leaves the cluster, and innodb_thread_concurrency is non-zero.PXC-4400Aaditya Dubey
- FLUSH TABLES during writes to table stalls the cluster nodePXC-4399Kamil Holubicki
- Misleading SST version comparison messagePXC-4394
- Error lost in wsrep_sst_xtrabackup_v2PXC-4393Resolved issue: PXC-4393Kamil Holubicki
- Default SST timeout logic is insufficient and causes SST abortsPXC-4392Kamil Holubicki
- garbd workdir configuration is brokenPXC-4352
- Run wsrep-lib unit tests on JenkinsPXC-4314Venkatesh Prasad
- Cluster breakdown with concurrent ALTER INSTANCE and ALTER TABLE in NBOPXC-4251
- Cluster inconsistency with LOCK TABLES + TOIPXC-4184
- Xtrabackup corrupt the seqno on big endian architecturesPXC-3945
- TOI constantly fails after setting `repl.max_ws_size`PXC-3944
- provide SST with CLONE pluginPXC-3802Resolved issue: PXC-3802
- wsrep_OSU_method should have only session scope as global RSU mode is dangerousPXC-3781
- Inconsistency voting deadlockPXC-3770
- Possible Deadlock with gcs votingPXC-3718Aaditya Dubey
- [MTR] Refactor port allocation for MTR testsPXC-3667
- SELinux support for keyring_vaultPXC-3590Kamil Holubicki
- PXC create a role mapping an upper case database with lower_case_table_names=1PXC-3576Venkatesh Prasad
- [MTR] Fix failing keyring_vault sute testsPXC-3546Kamil Holubicki
- Setting up slave_parallel_type = LOGICAL_CLOCK dynamically not working in pxcPXC-3465Resolved issue: PXC-3465Venkatesh Prasad
- Counter for Streaming ReplicationPXC-3099Resolved issue: PXC-3099
- Donor or backup node can be blocked for writes completely by DDL or DCL queriesPXC-2593Resolved issue: PXC-2593
- LP #1182094: Incremental SSTPXC-1165Resolved issue: PXC-1165
- PXC concurrent backups - metadata lock hang with xtrabackup_historyPXB-3359aibek.bukabayev
- Introduce the ability to do check tables at the end of preparePXB-3328
- Remove dead option : --rebuild_threadsPXB-3285
- Race condition in redo-log-consumer causes redo log read failurePXB-3282
- Verify PXB 8.0.35 works with PS 8.0.37PXB-3273Resolved issue: PXB-3273Hrvoje Matijakovic
- Increase the default timeout in xbcloudPXB-3136
- Potential race condition during backupPXB-3118
- No valid checkpoint found - Did not detect backup was from newer versionPXB-3042
- Wrong prompt in --helpPXB-3011
- Enable Doublewrite buffer for preparePXB-2879
- xbcloud cannot be used with ObjectLock-enabled AWS S3 bucketsPXB-2833Marcelo Altmann
- use [[maybe_unused]] instead of __attribute__((unused))PXB-2645
- Automatically gather replication and galera informationPXB-2642
- add --generate-transition-key test to keyring_filePXB-2581
50 of 217
If IST fails for some reason, it resets the grastate.dat file. This means that a subsequent start will perform SST.
How to repeat:
Deploy a PXC environment
Grastate.dat file current state
Kill the instance
Add an iptables rule preventing access on port 4444
Start the instance
It fails due to sst-initial-timeout/joiner-timeout:
The failed IST caused the grastate.dat to be reset:
And on the next start, it requests a full SST:
In case IST fails, there should be a mechanism to preserve the previous grastate.dat file. Another alternative is modifying the grastate.dat file with the information from the wsrep-recover option.
Thanks!