Failed to Export Upgrade Metadata Due to Insufficient Transaction Locks

Latest reply: Jun 27, 2019 08:53:28 143 1 12 2

1. Symptom

An error is reported during the upgrade. The error message "You might need to increase max_locks_per_transaction" is displayed in the log.

2. Cause Analysis

Log in as user omm to the primary CMS server where the LibrA service is deployed, and run the following command:

source /opt/huawei/Bigdata/mppdb/.mppdbgs_profile

grep -nr "You might need to increase max_locks_per_transaction" $GAUSSLOG/bin/

gs_dump/gs_dump -*-current.log

If "You might need to increase max_locks_per_transaction" can be found, the export failure is caused by insufficient transaction locks. In this case, perform the following steps to rectify the fault.

3. Solution:

Log in to a data node as user omm and run the following commands to modify related parameters:

source ${BIGDATA_HOME}/mppdb/.mppdbgs_profile

gs_guc set -Z coordinator -N all -I all -c "max_locks_per_transaction=512" -c

"max_connections=1000" -c "max_prepared_transactions = 1000"

gs_guc set -Z datanode -N all -I all -c "max_locks_per_transaction=512" -c

"max_connections=1000" -c "max_prepared_transactions = 1000"

cm_ctl stop && cm_ctl start

Notice: The value of max_prepared_transactions can only be increased and cannot be decreased. If the value has been greater than 1000, modify the other values to obtain sufficient transaction locks.


  • x
  • convention:

user_3433675
Created Jun 27, 2019 08:53:28 Helpful(0) Helpful(0)

Great
  • x
  • convention:

Login and enjoy all the member benefits

Login and enjoy all the member benefits

Login