[JIRA] Commented: (SSPCPP-473) occasional shibd crashes when using MySQL ODBC storage service on RHEL6

[Sebastien Otto Korner (JIRA)]

    [ https://issues.shibboleth.net/jira/browse/SSPCPP-473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14561#comment-14561 ] 

Sebastien Otto Korner commented on SSPCPP-473:
----------------------------------------------

An update. We have not had a shibd crash of the type I described when filing this bug since early July (RHEL6, libmyodbc implicated). There were no updates by RH to mysql-connector-odbc or unixODBC around that time, so exactly what changed is unclear.  It is worth noting, as Brian stated, we can still replicate the problem with Debian 6.

We are observing a different, very infrequent, shibd crash mode on our RHEL6 systems now. The frequency is around once every 1-2 months. I will attach an example stack trace (shibd-crash-mode-3.txt).

We hadn't explored alternate versions of the driver or of unixODBC, as the RHEL6 problem frequency had dropped to almost inconsequential.  However, we have an interest in using this functionality on our Debian systems (different SP), so we will likely explore.

> occasional shibd crashes when using MySQL ODBC storage service on RHEL6
> -----------------------------------------------------------------------
>
>                 Key: SSPCPP-473
>                 URL: https://issues.shibboleth.net/jira/browse/SSPCPP-473
>             Project: Shibboleth SP - C++
>          Issue Type: Bug
>      Security Level: Standard(Standard bug, may impact functionality but does not represent a security vulnerability ) 
>    Affects Versions: 2.4.3
>         Environment: RHEL6, Apache 2.2, SP 2.4.3 from RPM, and MySQL for storage service. Using RH supplied unixODBC and mysql-connector-odbc packages with default odbcinst.ini.
>            Reporter: Sebastien Otto Korner
>            Assignee: Scott Cantor
>         Attachments: shibd-crash-mode-1.txt, shibd-crash-mode-2.txt
>
>
> When using the ODBC storage service with MySQL on RHEL6 shibd crashes periodically.  Our web servers are 1/2 RHEL5 and 1/2 RHEL6, with load spread equally between them.  The shibd on RHEL5 never crashes.  Without using the ODBC storage service shibd never crashes on any server.
> The crash frequency in terms of session creation is about once every thousand.  It does not appear to be a regular occurrence based on number of sessions since the last crash though.  For approximately half the crashes another crash follows within 30 minutes.
> Investigating the core files indicates two different failure modes, with MySQL use implicated in both.  Attached are traces representing the two failure modes.
> Let me know if you require more information.
> Thanks.
> Sebastien

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira