Transaction size exceed set threshold

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

When I execute my proceduer, 1200 seconds later, I got an error like this:
Got error 5 - ‘Transaction size exceed set threshold’ during COMMIT
wsrep_max_ws_size

mysql> select @@wsrep_max_ws_size;
+---------------------+
| @@wsrep_max_ws_size |
+---------------------+
|          2147483647 |
+---------------------+

But my trx size is small, less than 2G.
Is there some other limits about the “Transaction size” in PXC 8.0 ?
Where can I set the timeout more than 1200 seconds?
Thanks a lot.

1 Like
2

Is your transaction less than 2GB but larger than 1GB? If so, you might be hitting some internal C function limitations that can’t handle data objects larger than 1GB.

Since you are using PXC 8, you should take a look at the new streaming transaction option available.

2 Likes
3

Thank you so much.
According to you advice, we have changed our commit method.
I will take a look at the new streaming transaction option in PXC 8.

1 Like