Re: [Sqlgrey-users] sqlgrey segmentation fault!

[Marco F. <fa...@cs...>]

Lionel Bouton wrote:
> Marco Favero a écrit, le 07/11/2008 01:43 PM :
>> Hi all,
>> I run daemon sqlgrey 1.6.8 with Mysql DBMS. DB access is "sync", not
>> "async".
>>
>> I have just installed it in test environment with no connections:
>>
>> Red Hat Enterprise Linux Server release 5.2
>> Linux vm-greylist1 2.6.18-92.el5 #1 SMP Tue Apr 29 13:16:15 EDT 2008 
>> x86_64 x86_64 x86_64 GNU/Linux
>>
>> I start sqlgrey and it works fine. I make SMTP session: it's ok, like 
>> expected.
>> After a day, I made another smtp session: sqlgrey segfault! This is the 
>> only log written:
>>
>> kernel:<6>sqlgrey[9861]: segfault at 0000000000000008 rip 
>> 0000003d2ca489d5 rsp 00007fff031e68e0 error 4
>>
>> Could you help me?
>>   
> 
> It's most probably hardware related. Segfaults happen when a process 
> tries to access memory at an address it hasn't access too. SQLgrey is 
> coded in Perl and doesn't deal with memory access at all leaving it to 
> the Perl interpreter. So there's really two possible sources :
> - Buggy perl interpreter or native library (the DBD MySQL driver for 
> example is probably coded with both Perl and C to interface with the 
> MySQL client library),
> - Dodgy hardware.
> 
> As you are the first to report such a problem it's far more likely that 
> it's a problem specific to your installation : RedHat being used widely 
> the only remaining possibility is the hardware.
> 
> Running memtest86+ might confirm the problem.
> 
> Lionel

I tried with memtest, but I exclude hardware problem - I have same 
segmentation on two identical hardware.

My systems are:
perl 5.8.8

Modules installed:
IO::Multiplex is up to date (1.09)
Net::Server is up to date (0.97)
DBD::mysql is up to date (4.007)
DBI is up to date (1.605)

Mysql local to DBD and sqlgrey is:
mysql.x86_64      5.0.22-2.1.0.1
but db_host is not localhost: remote DBMS could be another subversion.

I don't known what thinking about...
For debugging purpose I also tried to reduce db_cleandelay to few 
seconds, but it is useless. Segmentation fault happens only after 
several hours from sqlgrey start, I notice after a day during first 
connection I make.

Maybe it's useful to know which versions of module above surely works 
together?

I notice this problem only with sqlgrey, so I've tried to ask here.
Thank you very much again
Marco