Bug 1461445 - Test case failure: /CoreOS/mysql/Regression/bz1045401-mysqld-safe-removes-socket-of-other-running-server
Summary: Test case failure: /CoreOS/mysql/Regression/bz1045401-mysqld-safe-removes-soc...
Keywords:
Status: CLOSED EOL
Alias: None
Product: Red Hat Software Collections
Classification: Red Hat
Component: mysql
Version: rh-mysql57
Hardware: Unspecified
OS: Linux
unspecified
unspecified
Target Milestone: ---
: 3.1
Assignee: Michal Schorm
QA Contact: Karel Volný
URL:
Whiteboard:
Depends On:
Blocks: 1466477 1552126 1558112
TreeView+ depends on / blocked
 
Reported: 2017-06-14 13:09 UTC by Karel Volný
Modified: 2019-12-02 12:19 UTC (History)
4 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
: 1466477 (view as bug list)
Environment:
Last Closed: 2019-12-02 12:19:18 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Karel Volný 2017-06-14 13:09:28 UTC
Filed from caserun https://tcms.engineering.redhat.com/run/311469/#caserun_15765069

Version-Release number of selected component (if applicable):
RHEL-6

Steps to Reproduce: 
run the test

Actual results: 
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
:: [   LOG    ] :: stale-socket
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

:: [   PASS   ] :: File /var/lib/mysql/mysql.sock should exist 
:: [  BEGIN   ] :: Running 'rlServiceStart "rh-mysql57-mysqld"'
rh-mysql57-mysqld is stopped
Socket file /var/lib/mysql/mysql.sock exists.
Not enough permission to write to the socket file /var/lib/mysql/mysql.sock, which is suspicious.
Please, remove /var/lib/mysql/mysql.sock manually to start the service.
:: [ 19:05:50 ] :: [ ERROR   ] :: rlServiceStart: Starting service rh-mysql57-mysqld failed
:: [ 19:05:51 ] :: [ ERROR   ] :: Status of the failed service:
:: [ 19:05:51 ] ::   rh-mysql57-mysqld is stopped
:: [   FAIL   ] :: Command 'rlServiceStart "rh-mysql57-mysqld"' (Expected 0, got 1)


Expected results:
if the socket is not in use, mysql should remove it byitself

Comment 7 Karel Volný 2017-12-08 14:48:04 UTC
chm, now it fails on RHEL7 and I'm really not sure why ...

::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
:: [   LOG    ] :: stale-socket
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

:: [   PASS   ] :: File /var/lib/mysql/mysql.sock should exist 
:: [  ERROR   ] :: rlServiceStart: Starting service rh-mysql57-mysqld failed
:: [  ERROR   ] :: Status of the failed service:
:: [   LOG    ] ::   Redirecting to /bin/systemctl status rh-mysql57-mysqld.service
:: [   LOG    ] ::   ● rh-mysql57-mysqld.service - MySQL 5.7 database server
:: [   LOG    ] ::   Loaded: loaded (/usr/lib/systemd/system/rh-mysql57-mysqld.service; disabled; vendor preset: disabled)
:: [   LOG    ] ::   Active: activating (start-pre) since Pá 2017-12-08 09:32:36 EST; 1ms ago
:: [   LOG    ] ::   Process: 10977 ExecStartPre=/usr/bin/scl enable $RH_MYSQL57_SCLS_ENABLED -- /opt/rh/rh-mysql57/root/usr/libexec/mysql-check-socket (code=exited, status=1/FAILURE)
:: [   LOG    ] ::   Control: 11034 (systemd)
:: [   LOG    ] ::   CGroup: /system.slice/rh-mysql57-mysqld.service
:: [   LOG    ] ::   └─control
:: [   LOG    ] ::   └─11034 /usr/lib/systemd/systemd --switched-root --system --deserialize 22
:: [   LOG    ] ::   
:: [   LOG    ] ::   pro 08 09:32:36 qeos-22.lab.eng.rdu2.redhat.com systemd[1]: Starting MySQL 5.7 database server...
:: [   FAIL   ] :: Command 'rlServiceStart "rh-mysql57-mysqld"' (Expected 0, got 1)
:: [   FAIL   ] :: Command 'service rh-mysql57-mysqld status' (Expected 0, got 3)
:: [   FAIL   ] :: rh-mysql57-mysqld should be running (Expected 0, got 3)
:: [   FAIL   ] :: Sockets opened by mysql should contain /var/lib/mysql/mysql.sock (Expected 0, got 1)
:: [   FAIL   ] :: The socket owner should be mysql (Assert: 'root' should equal 'mysql')
:: [   FAIL   ] :: File /var/lib/mysql/mysql.sock should not exist 
:: [   LOG    ] :: Duration: 21s
:: [   LOG    ] :: Assertions: 1 good, 6 bad
:: [   FAIL   ] :: RESULT: stale-socket

Comment 17 Joe Orton 2019-12-02 12:19:18 UTC
In accordance with the Red Hat Software Collections Product Life Cycle, the support period for this collection has ended.

New bug fix, enhancement, and security errata updates, as well as technical support services will no longer be made available for this collection.

Customers are encouraged to upgrade to a later release.

Please contact Red Hat Support if you have further questions, or refer to the support lifecycle page for more information. https://access.redhat.com/support/policy/updates/rhscl/


Note You need to log in before you can comment on or make changes to this bug.