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

[Scott Cantor (JIRA)]

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

Scott Cantor commented on SSPCPP-473:
-------------------------------------

I'll look at the sections of code involved, but both of those crashes look like bugs in the driver (likely race conditions given the frequency). So yes, I would say MySQL is implicated, directly.

I can't trap that kind of error. If you're set on running it (I wouldn't, obviously), then the most you could do is add the catchAll flag to the OutOfProcess element to forcibly catch all errors. It obviously masks internal bugs in other code like this, so it isn't something you do by default, but if you have to use it, that's about all you can do. But that probably will end up detablizing it, since the driver's internals will probably be corrupt.

> 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