use QGis import data cause pgpool hang.

[liujinyang-highgo]

hi,
when I use Qgis import data from local disk to postgresql(with postgis) through pgpool, that cause pgpool hang.
pgpool version: 4.6.2

reproduce:
1.install Qis
version: QGIS-OSGeo4W-3.40.14-1.msi
you can download it on https://qgis.org/downloads-list/#windows and search by file name "QGIS-OSGeo4W-3.40.14-1", then can download it.
install this version, after installed, directory "QGIS 3.40.14" will be appeared on your desktop, and later use "OSGeo4W Shell" in this directory to test.
2. install pg 16 with postgis.
3. test file see attachment : sampleGDB.zip
unzip this file to local disk d:\testdata
4. test command
ogr2ogr -f "PostgreSQL" "PG:dbname=postgres host=192.168.71.100 port=9999 user=postgres password=123456" D:\testdata\sampleGDB\sampleGDB.gdb sample -nln "sde.bbbbb10" -lco GEOMETRY_NAME=shape -lco FID=objectid -overwrite -progress

run above command in "OSGeo4W Shell", then pgool is hung.
if change port to 5432 connect to PG that can success.

I checked code, it is hung in function CopyDataRows(),but don't know the root cause.

CopyDataRows()
{

if (copyin)
{
	for (i = 0; i < NUM_BACKENDS; i++)
	{
		if (VALID_BACKEND(i))
		{
			pool_flush(CONNECTION(backend, i));

			/*
			 * Check response from the backend.  First check SSL and read
			 * buffer of the backend. It is possible that there's an error
			 * message in the buffer if the COPY command went wrong.
			 * Otherwise wait for data arrival to the backend socket.
			 */
			if (!pool_ssl_pending(CONNECTION(backend, i)) &&
				pool_read_buffer_is_empty(CONNECTION(backend, i)) &&
				synchronize(CONNECTION(backend, i)))                                                 -------was hung in this function
				ereport(FATAL,
						(return_code(2),
						 errmsg("unable to copy data rows"),
						 errdetail("failed to synchronize")));
		}
	}
}

}

could you help check this?
thanks a lot!

sampleGDB.zip

[tatsuo-ishii]

Yes, it looks like synchronize() is waiting for data coming from backend.
Can you share pgpool log with log_client_messages = on ?
Unfortunately I don't have an Windows environment, and cannot reproduce the issue.
Also, if possible, can you share the COPY data so that I could feed the data to pgpool using plain psql -c "COPY TO" command?

[liujinyang-highgo]

hi，
I upload the log.
the last log info is "2026-05-22 13:21:27.882: GDAL 3.12.1 pid 1868236: DETAIL: invalid copyin kind. expected 'd' got 'c'"

your system is MacOS? QGIS also supply that.

pool.log

[tatsuo-ishii]

I upload the log.

Thanks. I will take a look at it.

your system is MacOS? QGIS also supply that.

Ubuntu 24.

[tatsuo-ishii]

Can you share PostgreSQL log?

[liujinyang-highgo]

hi，
I capture the packets between ogr2ogr and pgpool.

we can see, pgpool, received S after c from fronted ,I checked code, pgpool would not forward S to backend , I don't if that cause this issue.

since I did not use offical PG（a database from another company based on PG）,I did not find useful log, I will try later.

hope the Wireshark packets is useful to you.

thanks!

pg1.zip

[liujinyang-highgo]

attachment is database log(not offical pg), I did not find useful info.
with ：
logging_collector = on
log_min_messages = debug5
log_min_error_statement = debug5

pg.log

[tatsuo-ishii]

Thank you for the WireShark packet capture log. With pool.log you sent, I noticed that QGis uses extended query protocol + COPY-IN which pgpool currently cannot handle.

we can see, pgpool, received S after c from fronted ,I checked code, pgpool would not forward S to backend , I don't if that cause this issue.

Probably it's not related to the issue. The code path is used while 'd' packet (copy data) is receiving. But in this case the sync message comes after 'c' (CopyDone).

I think the real issue is, PostgreSQL backend does not respond with 'Z' (ReadyForQuery) when a Sync message is received after Execute message. It seems the backend responds with 'G' (CopyInResponse) instead. As far as I know the behavior is not described in the PostgreSQL document.
BTW, I have modified "pgproto" which comes with pgpool so that I simulate your case. Below is an output from pgproto. As you can see, the first Sync is followed by Parse Complete (it's a response of "Parse" message), Bind Complete (response of "Bind") and CopyInResponse. No ReadyForQuery. On the other hand, the second Sync is responded by CommandComplete and ReadyForQuery. Pgpool is not prepared for the behavior. I am going to adapt the behavior but it will take sometime.

FE=> Query (query="CREATE TEMP TABLE t1(i int)")
<= BE CommandComplete(CREATE TABLE)
<= BE ReadyForQuery(I)
FE=> Parse(stmt="", query="COPY t1 FROM STDIN")
FE=> Bind(stmt="", portal="")
FE=> Execute(portal="")
FE=> Sync
<= BE ParseComplete
<= BE BindComplete
<= BE CopyInResponse
FE=> CopyData (copy data="1
")
FE=> CopyData (copy data="2
")
FE=> CopyDone
FE=> Sync
<= BE CommandComplete(COPY 2)
<= BE ReadyForQuery(I)
FE=> Terminate