[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=14264#comment-14264 ] 

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

I didn't mean to imply I'm 100% sure it's not my bug, but if it is, it's most likely one of those undocumented things you have to do with ODBC to fix problem X in driver Y, so it's kind of a black art.

But it doesn't look like one, and the effort to find out would be significant relative to the chances it is and could be fixed, so it's not a front burner work item. I don't like leaving people with a sense that I might fix it in a day.

It would be great to hear back if you get different results with newer or older versions.



> 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