postgresql-plruby icon indicating copy to clipboard operation
postgresql-plruby copied to clipboard

Random segfaults

Open michalf opened this issue 13 years ago • 0 comments

Hi,

I am getting random Ruby process segfaults leading to PostgreSQL restart

Here is a fragment of the log file:

/usr/local/rvm/rubies/ruby-1.8.7-p352/lib/ruby/1.8/yaml.rb:133: [BUG] Segmentation fault ruby 1.8.7 (2011-06-30 patchlevel 352) [x86_64-linux] 2011-12-28 14:19:56 UTC LOG: server process (PID 32359) was terminated by signal 6: Aborted 2011-12-28 14:19:56 UTC HINT: In a moment you should be able to reconnect to the database and repeat your command. 2011-12-28 14:19:56 UTC WARNING: terminating connection because of crash of another server process 2011-12-28 14:19:56 UTC DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2011-12-28 14:19:56 UTC HINT: In a moment you should be able to reconnect to the database and repeat your command. 2011-12-28 14:19:56 UTC FATAL: the database system is in recovery mode

This happens every few hours on a very busy server. PostgreSQL 9.0.6 on Debian 6.0, Ruby 1.8.7-p352 from RVM.

I would be glad to help diagnose the problem, but no idea how to debug this thing. Any hints welcomed.

michalf avatar Dec 30 '11 10:12 michalf