when insert `2023 04 21T12 32 27 327912Z E i q c p PGConnect

Question

when insert `2023 04 21T12 32 27 327912Z E i q c p PGConnectionContext undersized receive buffer or someone is abusing protocol` pouting cat

Bolek Ziobrowski · Answer

Please elaborate

Bolek Ziobrowski · Answer

You might be sending a super long sql text insert with multiple values and filling the receive buffer

Bolek Ziobrowski · Answer

If you re inserting lots of data via pg wire then use prepared statements and reasonably sized batch

Super Richman · Answer

```2023 04 21T12 32 27 327523Z I i q c p PGConnectionContext parse fd=7260 q=DISCARD ALL 2023 04 21T12 32 27 327614Z I i q c p PGConnectionContext parse fd=7260 q=INSERT INTO Models VALUES $1 to timezone systimestamp America New York $2 $3 $4 $5 $6 $7 $8 2023 04 21T12 32 27 327912Z E i q c p PGConnectionContext undersized receive buffer or someone is abusing protocol 2023 04 21T12 32 27 327922Z I pg server scheduling disconnect fd=7260 reason=7 2023 04 21T12 32 27 327961Z I pg server disconnected ip=127 0 0 1 fd=7260 src=queue ```

Super Richman · Answer

two binary maybe thats the problem

Super Richman · Answer

now it is acting like the data is inserted when actually it isn t confused only some is inserted and I don t have an indication for which ExecuteNonQuery returns 1

Bolek Ziobrowski · Answer

Regarding previous error can you create a reproducer I m not familiar with npgsql but I know that insert with positional bind variables does work As for the last remark data inserted with ```insert into values ``` statement isn t visible until transaction commit so please check how you handle transactions in the code