Pivotal Knowledge Base

Follow

Log Message "GetSnapshotData timed out waiting for Writer"

Environment

  • Pivotal Greenplum Database (GPDB) 4.3.x
  • Operating System- Red Hat Enterprise Linux 6.x

Symptom

You may see several messages in the Master or Segment log files with the below message:

"GetSnapshotData timed out waiting for Writer to set the shared snapshot"

This is related to the Query Dispatch (QD) process, not getting a response within a specified time period. This may be related to a high load on the cluster and the system is too busy. The QD update snapshot is too slow and then gives this message. This message is a "LOG" level message, the reader gang logs this message when it takes too long to sync with the writer gang (longer than 1 sec).

Resolution

The parameter gp_interconnect_setup_timeout is set to 60 seconds as the default. Increasing this parameter may help with alleviating this log message in the log file if you are having a high load on your cluster. To set the parameter, please follow the below steps:

gpconfig -c gp_interconnect_setup_timeout -v 120 -m 120 

You will then need to restart the database for this parameter to take an effect:

gpstop
gpstart 

Comments

Powered by Zendesk