Bug 1755154
| Summary: | postgresql-libs - Deadlocks occur when using SSL in a multi-threaded environment | ||
|---|---|---|---|
| Product: | Red Hat Enterprise Linux 7 | Reporter: | Matt Prahl <mprahl> |
| Component: | postgresql | Assignee: | Patrik Novotný <panovotn> |
| Status: | CLOSED ERRATA | QA Contact: | Vaclav Danek <vdanek> |
| Severity: | unspecified | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 7.7 | CC: | databases-maint, dgregor, fjanus, hhorak, pkubat, praiskup, vdanek |
| Target Milestone: | rc | Keywords: | Reproducer, TestCaseNeeded |
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | No Doc Update | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2020-03-31 20:11:03 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
| Bug Depends On: | |||
| Bug Blocks: | 1716961 | ||
| Attachments: | |||
|
Description
Matt Prahl
2019-09-24 21:42:30 UTC
Hi, I was trying to reproduce this bug on various version of RHEL(7.4,7.7,7.8) by using attached reproducer, but I am not able to attain deadlock. Are you able to add here Your configuration? (openssl package version and pg_hba.conf). Created attachment 1629194 [details]
A video showing the deadlock using the Python reproducer script
Created attachment 1629195 [details]
A modified version of the reproducer Python 2 script
Hi Filip, I attached a short video that shows the deadlock and I attached a slightly modified version of the Python 2 reproducer script that I used. It usually takes less than a couple of minutes for the deadlock to occur, but it took only a few seconds in the video I shared. We are currently using openssl-1.0.2k-16.el7_6.1.x86_64 on the server that ran the reproducer script and on the server with Postgresql. As for the contents of pg_hba.conf, there is nothing special. We have one `hostssl` entry for MBS to connect to using a password. Hi, thank You for Your advise but still I am not able to reproduce it. But I applied attached patch and build package. Here you can download it: http://download.eng.bos.redhat.com/brewroot/work/tasks/7480/24307480/postgresql-libs-9.2.24-2.el7_7.x86_64.rpm . Please are you able to test if deadlock occur after install new package? Hi Filip, That RPM installed fine and I can't reproduce the deadlock with it. Filip what environment do you have setup for testing the reproducer script? Filip, I created an environment using docker-compose that reproduces the issue. Please see the following repository: https://github.com/mprahl/rhbz1755154-reproducer Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHBA-2020:1182 |