---
title: Greenplum运行SQL时提示failed to acquire resources on one or more segments
description: "使能KAEzip之前，Greenplum运行SQL时提示“failed to acquire resources on one or more segments”。"
url: https://www.hikunpeng.com/document/detail/zh/kunpengdbs/ecosystemEnable/Greenplum/kunpenggreenplum_kae_03_0026.html
sourcePath: /source/zh/kunpengdbs/ecosystemEnable/Greenplum/kunpenggreenplum_kae_03_0026.html
indexId: 0f77fe0ad800040bb1fc441a162fdac81f1742dc3d8ab7fe90a007e05afb06e881
---
# Greenplum运行SQL时提示failed to acquire resources on one or more segments

#### 问题现象描述

使能KAEzip之前，Greenplum运行SQL时提示“failed to acquire resources on one or more segments”。


#### 关键过程、根本原因分析

Greenplum的最大连接数参数“max_connections”的值设置得比较小，可能会导致segment的数据获取不到或者获取数据超时。


#### 结论、解决方案及效果

尝试增大Greenplum的最大连接数参数“max_connections”的值。同时，参数“max_prepared_transactions”也需要根据master节点的“max_connections”值做出一样的修改。

```
gpconfig -c max_connections -v 2500 -m 500
gpconfig -c max_prepared_transactions -v 500
```