Hi Brian, running the following command : time mysql -h sdnc-dbhost.onap -P 3306 -u sdnctl -p -e 'show tables;' sdnctl the results are very different based on the identity of container making the query: 1) from dev-sdnc-sdnc-portal real 0m13.002s user 0m0.016s sys 0m0.008s 2) from dev-sdnc-sdnc-0 real 0m1.202s user 0m0.020s sys 0m0.004s 3) from dev-sdnc-sdnc-db-o real 0m0.807s user 0m0.008s sys 0m0.004s 4) from dev-robot real 0m11.766s user 0m0.004s sys 0m0.004s The trace of the command (from dev-sdnc-sdnc-portal container) shows that the container making the request/query, waits for about 10 seconds (function recvfrom) before receiving data from mysql container. The long time spent in waiting db response probably is the cause for the error "Unable to get database connection. Error: Handshake inactivity timeout" in SDNC-admin-Portal
It's important to note that the host for dev-sdnc-sdnc-portal and dev-sdnc-sdnc-0 is the same We also tested DNS resolution from either sdnc-sdnc-db-o and sdnc-sdnc-portal and all is OK do you have any suggestion ? -=-=-=-=-=-=-=-=-=-=-=- Links: You receive all messages sent to this group. View/Reply Online (#15547): https://lists.onap.org/g/onap-discuss/message/15547 Mute This Topic: https://lists.onap.org/mt/29665079/21656 Group Owner: [email protected] Unsubscribe: https://lists.onap.org/g/onap-discuss/unsub [[email protected]] -=-=-=-=-=-=-=-=-=-=-=-
