segmentation fault (core dumped) ubuntu - Githubissues

Percona-Lab / sysbench-tpcc

Sysbench scripts to generate a tpcc-like workload for MySQL and PostgreSQL

Apache License 2.0

292 stars 104 forks source link

segmentation fault (core dumped) ubuntu #47

Open alexeevo opened 2 years ago

alexeevo commented 2 years ago

Hi, I am running sysbench tpc-c 1.0.20 on PostgreSQL 14.

During the "prepare" I get the following error: segmentation fault (core dumped) ubuntu

On "Ubuntu 20.04.3 LTS" and "Ubuntu 18.04.6 LTS" I have the same issue.

In the syslog have: labxxxx kernel: [12728.541831] sysbench[32695]: segfault at 0 ip 00007f762213f461 sp 00007f761c0eb918 error 4 in libc-2.27.so[7f7621fb1000+1e7000]

The workaround was to limit PostgreSQL buffer pool memory from 300GB to 20GB, but this is not a realistic setting. Since I have 512GB of RAM.

siddjain commented 1 year ago

512 GB RAM! you must be rich to afford a machine like that. same error here:

$ tail -f /var/log/messages
Feb  1 05:05:34 clickhouse-1 kernel: [9464263.071423] sysbench[1745710]: segfault at 0 ip 00007f74ca349a19 sp 00007f74c91a1778 error 4 in libc-2.31.so[7f74ca200000+15a000]

what causes this? my buffer pool is already much lower.