From: | Vincent Lachenal <vincent(dot)lachenal(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #14897: Segfault on statitics SQL request |
Date: | 2017-11-10 19:47:12 |
Message-ID: | CAA2tJ7o-VK+ghsxifDAszFN5fikmG6U3sWHCEvc9nAVOypfjAw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Sorry. I didn't find the way to create an attachment in the interface.
You can find the database dump as attachment.
I didn't tweak database. I use default Archlinux configuration (which
should be PostgreSQL default configuration).
I will try to get a stack trace.
Regards.
Vincent
Le ven. 10 nov. 2017 à 20:08, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> a écrit :
> vincent(dot)lachenal(at)gmail(dot)com writes:
> > But one of the resquest I use causes segmentation fault to server
> process.
>
> > The request is :
> > SELECT
> > s.protocol,
> > s.mapper,
> > c.method,
> > s.nb_threads,
> > avg(c.client_end - c.client_start) / 1000000 AS total,
> > avg(c.server_end - c.server_start) / 1000000 AS server,
> > avg(c.server_start - c.client_start) / 1000000 AS client_to_server,
> > avg(c.client_end - c.server_end) / 1000000 AS server_to_client
> > FROM testsuite s
> > INNER JOIN testcall c ON s.id = c.test_suite_id
> > GROUP BY (s.protocol, s.mapper, c.method, s.nb_threads)
> > ORDER BY s.nb_threads, c.method, s.mapper, s.protocol;
>
> The query alone doesn't help us much. Can you put together a
> self-contained test case, including table declarations and some
> sample data? Also, are you using any non-default configuration
> settings?
>
> Alternatively, if you can get a stack trace from the crash,
> that might be enough info to diagnose it (no promises though).
>
>
> https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend
>
> regards, tom lane
>
Attachment | Content-Type | Size |
---|---|---|
dump.tar.xz | application/x-xz | 2.1 MB |
From | Date | Subject | |
---|---|---|---|
Next Message | Vincent Lachenal | 2017-11-10 19:54:04 | Re: BUG #14897: Segfault on statitics SQL request |
Previous Message | Tom Lane | 2017-11-10 19:08:11 | Re: BUG #14897: Segfault on statitics SQL request |