Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Mysql innodb cluster node stucked on "RECOVERING"

3837224Feb 11 2019 — edited Mar 24 2019

Dear All,

I'm having some trouble on creating a new cluster after dissolving the old one.

I have recreated successfully the cluster, but one of the nodes is still blocked in status "RECOVERING".

MySQL  mysql-cluster-1.ferrarigroup.net:3306 ssl  JS > c.status()

{

    "clusterName": "clustermysql",

    "defaultReplicaSet": {

        "name": "default",

        "primary": "mysql-cluster-1.ferrarigroup.net:3306",

        "ssl": "REQUIRED",

        "status": "OK_NO_TOLERANCE",

        "statusText": "Cluster is NOT tolerant to any failures.",

        "topology": {

            "mysql-cluster-1.ferrarigroup.net:3306": {

                "address": "mysql-cluster-1.ferrarigroup.net:3306",

                "mode": "R/W",

                "readReplicas": {},

                "role": "HA",

                "status": "ONLINE"

            },

            "mysql-cluster-2.ferrarigroup.net:3306": {

                "address": "mysql-cluster-2.ferrarigroup.net:3306",

                "mode": "n/a",

                "readReplicas": {},

                "role": "HA",

                "status": "RECOVERING"

            }

        },

        "topologyMode": "Single-Primary"

    },

    "groupInformationSourceMember": "mysql-cluster-1.ferrarigroup.net:3306"

}

Even if I rejoin the node, the status is still blocked in recovering.

How can I check why the node cannot complete the recovery?

The DB is empty, no schema has been added.

Best regards,

Andrea

This post has been answered by User_IHT8W on Mar 23 2019
Jump to Answer

Comments

Alex Keh-Oracle

Looks like it's a known issue. You can try the recommended steps in the thread to make sure you have updated all your dependencies.

User_2SBJ9

@bjarne-callewaert do you get any successful answer to fix this issue ? I would like to use the same cache library however I'm getting the same error

1 - 2

Post Details

Added on Feb 11 2019
5 comments
3,077 views