Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Already on GitHub? Sign in to your account

Random segfaults #7

Open
michalf opened this Issue Dec 30, 2011 · 0 comments

Comments

Projects
None yet
1 participant

michalf commented Dec 30, 2011

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.

koizumistr added a commit to koizumistr/postgresql-plruby that referenced this issue Jul 4, 2017

Merge pull request #7 from koizumistr/bit_or_and
bit_or/and for PostgreSQL 9.1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment