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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing

Post Details

Added on Feb 11 2019
5 comments
2,968 views