PostgreSQL crashes while running perf with static tracepoints

From: Wei Shan <weishan(dot)ang(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: PostgreSQL crashes while running perf with static tracepoints
Date: 2018-10-03 18:17:21
Message-ID: CAFe9ZTpTjQ5UVb-FkAHE9GHmrb1myGvob=nxGi5d2vOnfmmryA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all!

I'm doing some testing recently with perf_events(3.10) and postgresql 10.5
on centos 7.5 with kernel 3.10.0-862.3.2.el7.x86_64

- On 1 terminal, I'm running pgbench against a postgresql 10.5 server
- /usr/pgsql-10/bin/pgbench -c 1 -j 1 -T 10000 test -P 5
- On another terminal, I'm getting the stats for static probes in
postgresql with the following command.
- perf stat -e
sdt_postgresql:transaction__start,sdt_postgresql:transaction__commit
-a --
sleep 60
- postgres will crash upon running the perf stat command above
- I have used gdb to try and capture the stack trace as below against
the server process. I did try and attach to the postmaster process but it
didn't generated any stack trace

*Program received signal SIGILL, Illegal instruction.*
*0x00007f61b75ecca1 in __libc_send (fd=11, buf=buf(at)entry=0x2128038,
n=n(at)entry=18, flags=flags(at)entry=0) at
../sysdeps/unix/sysv/linux/x86_64/send.c:27*
*27 return INLINE_SYSCALL (sendto, 6, fd, buf, n, flags, NULL, (size_t)
0);*

I'm not sure what went wrong here.

Any help or suggestion is appreciated!

Thanks!

--
Regards,
Ang Wei Shan

Browse pgsql-admin by date

  From Date Subject
Next Message priyanka chatterjee 2018-10-04 05:06:05 Re: Regarding Google Code In 2018 Mentor
Previous Message benoit.rey 2018-10-03 18:02:56 pgAdmin4 Failed to launch