Error on insert xml

Started by Михаил Яремчукover 7 years ago3 messagesbugsgeneral
Jump to latest
#1Михаил Яремчук
mihail.yaremchuk@gmail.com
bugsgeneral

When I insert this data in the column with type xml, I get an error "SSL
SYSCALL error: EOF detected" and the gap of all current connections. When I
insert a simpler xml, but larger everything is ok.
version: PostgreSQL 9.6.11 on x86_64-pc-linux-gnu (Ubuntu
9.6.11-1.pgdg16.04+1), compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.10)
5.4.0 20160609, 64-bit

Attachments:

a.zipapplication/zip; name=a.zipDownload+18-17
#2Shulgin, Oleksandr
oleksandr.shulgin@zalando.de
In reply to: Михаил Яремчук (#1)
bugsgeneral
Re: Error on insert xml

On Wed, Dec 19, 2018 at 1:38 PM Михаил Яремчук <mihail.yaremchuk@gmail.com>
wrote:

When I insert this data in the column with type xml, I get an error "SSL
SYSCALL error: EOF detected" and the gap of all current connections. When
I insert a simpler xml, but larger everything is ok.
version: PostgreSQL 9.6.11 on x86_64-pc-linux-gnu (Ubuntu
9.6.11-1.pgdg16.04+1), compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.10)
5.4.0 20160609, 64-bit

(-bugs, +general)

Assuming the server is running remotely, maybe you should check link's MTU
on the client? Or does the server backend crash when you run the
query--did you check the server logs?

Regards,
--
Alex

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Михаил Яремчук (#1)
bugsgeneral
Re: Error on insert xml

=?UTF-8?B?0JzQuNGF0LDQuNC7INCv0YDQtdC80YfRg9C6?= <mihail.yaremchuk@gmail.com> writes:

When I insert this data in the column with type xml, I get an error "SSL
SYSCALL error: EOF detected" and the gap of all current connections. When I
insert a simpler xml, but larger everything is ok.

What I see is a segfault down inside libxml2. I suggest reporting this
problem to them.

http://xmlsoft.org/bugs.html

Also, possibly try a newer version of libxml2 ...

regards, tom lane