Обсуждение: BUG #14367: Pressing execute 20-30 times really fast causes loop of error messages

VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDM2NwpMb2dnZWQgYnk6ICAg
ICAgICAgIEphbiBLb3J0CkVtYWlsIGFkZHJlc3M6ICAgICAgamFuLmtvcnRA
Z2VuZXRpY3MubmwKUG9zdGdyZVNRTCB2ZXJzaW9uOiA5LjYuMApPcGVyYXRp
bmcgc3lzdGVtOiAgIFdpbmRvd3MgMTAKRGVzY3JpcHRpb246ICAgICAgICAK
Ci0tIEV4ZWN1dGUgKEY1KSB0aGUgZmlyc3QgMyBsaW5lcyBvZiB0aGlzIHNj
cmlwdCBvbmNlDQpEUk9QIFRBQkxFIElGIEVYSVNUUyBURVNUX0pBTjsNCkNS
RUFURSBUQUJMRSBURVNUX0pBTiAoRjEgVEVYVCk7DQpJTlNFUlQgSU5UTyBU
RVNUX0pBTiAoRjEpIFZBTFVFUyAoJ1Rlc3QnKTsNCi0tIEV4ZWN1dGUgKEY1
KSB0aGUgbmV4dCBsaW5lIDIwLTMwIHRpbWVzIHJlYWxseSBmYXN0LCBjYXVz
ZXMgbG9vcCBzYXlpbmc6CmNvbm5lY3Rpb24uQ3Vyc29yIGNvdWxkIG5vdCBi
ZSBmb3VuZCBmb3IgdGhlIGFzeW5jDQpJTlNFUlQgSU5UTyBURVNUX0pBTiAo
U0VMRUNUICogRlJPTSBURVNUX0pBTik7DQotLSBFeGVjdXRlIChGNSkgdGhl
IG5leHQgbGluZSBzaG93cyA0MDk2IHJlY29yZHMgaW5zZXJ0ZWQNClNFTEVD
VCBDT1VOVCgqKSBGUk9NIFRFU1RfSkFOOw0KLS0gT3RoZXIgaXNzdWVzOg0K
LS0gMS4gZXhlY3V0aW5nIHRyaXZpYWwgcXVlcmllcyB0YWtlIDQwMG1zIG9y
IG1vcmUsIHVzZWQgdG8gYmUgMTVtcw0KLS0gMi4gSSB3YXMgdHJ5aW5nIHRv
IHJlcHJvZHVjZSBhbm90aGVyIGlzc3VlIHdpdGggdGhpcyBleGFtcGxlLCBi
dXQgSQpjYW4ndC4NCi0tICAgIFRoZSBvdGhlciBpc3N1ZXMgd2FzIHRoYXQg
c29tZXRpbWVzIHRoZSBwcm9ncmVzIG9mIHRoZSAiUXVlcnkgVG9vbCIKa2Vl
cHMgb24gZ29pbmcNCi0tICAgIGV2ZW50aG91Z2ggdGhlIHF1ZXJ5IGlzIHF1
aWNrIGVub3VnaC4gV2hlbiBJIHJlc3RhcnQgdGhlIHF1ZXJ5dG9vbCwKdGhl
IGV4YWN0IHNhbWUNCi0tICAgIHF1ZXJ5IGV4ZWN1dGVzIGZpbmUgKDQwMG1z
KS4gVGhpcyBoYXBwZW5zIG1heWJlIDEgaW4gMjAgdGltZXMsIGJ1dCBub3QK
d2l0aCBzaW1wbGUNCi0tICAgIGV4YW1wbGVzLCBzbyBJIGRvbnQga25vdy4u
DQoNCgoK

On Wed, Oct 12, 2016 at 5:45 AM,  <jan.kort@genetics.nl> wrote:

> -- Execute (F5) the first 3 lines of this script once
> DROP TABLE IF EXISTS TEST_JAN;
> CREATE TABLE TEST_JAN (F1 TEXT);
> INSERT INTO TEST_JAN (F1) VALUES ('Test');
> -- Execute (F5) the next line 20-30 times really fast, causes loop saying:
> connection.Cursor could not be found for the async
> INSERT INTO TEST_JAN (SELECT * FROM TEST_JAN);
> -- Execute (F5) the next line shows 4096 records inserted
> SELECT COUNT(*) FROM TEST_JAN;

This sounds like a bug in whatever you are using to run the
queries.  You didn't say what that is, or what version.

Note that if it is some version of pgadmin, you might get better
results asking on the pgadmin-support list.

> -- Other issues:
> -- 1. executing trivial queries take 400ms or more, used to be 15ms

https://wiki.postgresql.org/wiki/SlowQueryQuestions

> -- 2. I was trying to reproduce another issue with this example, but I
> can't.
> --    The other issues was that sometimes the progres of the "Query Tool"
> keeps on going
> --    eventhough the query is quick enough. When I restart the querytool,
> the exact same

querytool?

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company