skyline return (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)' when toten has expired sometimes

Bug #2042812 reported by lance
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
skyline apiserver
Fix Released
Undecided
Unassigned

Bug Description

1 we installed the openstack Z version on k8s platform ,and use the latest skyline version in pod.
2 but when we run the skyline after an hour, it start to show err about "(2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)", but the skyline logs have nothing related logs about this
3 when we use the expired token to curl the api/openstack/skyline/api/v1/profile , "(2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)" will appear for a while, and "The token has expired. : Signature has expired" will appear for a while.

4 after we login the skyline for a while , it will automaticlly logout by the "(2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)" error, but when we restart the skyline pod ,it can be used again abgout an hour or less

Tags: k8s
lance (lance5890)
tags: added: k8s
Revision history for this message
lance (lance5890) wrote :

we should add mysql config just like the other components do

Changed in skyline-apiserver:
status: New → In Progress
Revision history for this message
Shuai Qian (iauhsnaiq) wrote :

I just pushed a patch, update your skyline image after it is merged.

lance (lance5890)
Changed in skyline-apiserver:
assignee: nobody → lance (lance5890)
assignee: lance (lance5890) → nobody
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to skyline-apiserver (master)

Reviewed: https://review.opendev.org/c/openstack/skyline-apiserver/+/900570
Committed: https://opendev.org/openstack/skyline-apiserver/commit/99f557e19c461ab4d41fc3f4074ff2510b3ac2c9
Submitter: "Zuul (22348)"
Branch: master

commit 99f557e19c461ab4d41fc3f4074ff2510b3ac2c9
Author: iauhsnaiq <qs_cloudnative@163.com>
Date: Fri Nov 10 09:55:01 2023 +0800

    fix: modify database connection way

    modify parallelDatabase as Database

    Bug: 2042812
    Change-Id: I33f282e69e7383a51c3e69b4c8e9273609fb988d

Changed in skyline-apiserver:
status: In Progress → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.