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@sss.pgh.pa.us> a écrit :
vincent.lachenal@gmail.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).