How to fix InnoDB corruption cases for the MySQL databases on Plesk for Linux?

Follow

Comments

6 comments

  • Avatar
    Pedro Telmo

    Hi:

    What information must content the file /root/db_list.txt ?

    Regards

  • Avatar
    Artyom Baranov

    @Pedro Telmo,

    Hi! After executing the following command:

    # mysql -Ns -uadmin -p`cat /etc/psa/.psa.shadow` -e"SHOW DATABASES" > db_list.txt

    it should contain the names of all databases that are stored on MySQL server.

  • Avatar
    Pedro Telmo (Edited )

    Yes Artyom.

    Alisa Kasyanova add this line after my comment :)

    Thanks

  • Avatar
    Mskumar Blaze

    2018-02-21T14:59:14.908905Z 12 [ERROR] Plugin group_replication reported: 'Fatal error during the Recovery process of Group Replication. The server will leave the group.'

  • Avatar
    Mskumar Blaze

    I have some doubt I have configured innodb cluster (3 cluster) after I created I’ll be going to stop group replication in (cluster2) then I had to rejoin cluster2 after I rejoined cluster2 status as recovering after some times it’s going to show missing. My cluster1-(primary) log status Warning] Plugin group_replication reported: 'Members removed from the group: 608781bce352:3306'
    2018-02-21T14:59:16.115814Z 0 [Note] Plugin group_replication reported: 'Group membership changed to d5e07af19ef5:3306, 812606eb6abb:3306 on view 15191888786747824:12.'
    2018-02-21T15:00:13.434470Z 148 [Note] Aborted connection 148 to db: 'unconnected' user: 'mysql_innodb_cluster_r1721619408' host: 'cluster2.willing' (failed on flush_net())
    2018-02-21T15:16:48.046190Z 141 [Note] Aborted connection 141 to db: 'unconnected' user: 'root' host: 'd5e07af19ef5' (Got an error reading communication packets)

    My cluster2 log status Warning] Plugin group_replication reported: 'Members removed from the group: 608781bce352:3306'
    2018-02-21T14:59:16.115814Z 0 [Note] Plugin group_replication reported: 'Group membership changed to d5e07af19ef5:3306, 812606eb6abb:3306 on view 15191888786747824:12.'
    2018-02-21T15:00:13.434470Z 148 [Note] Aborted connection 148 to db: 'unconnected' user: 'mysql_innodb_cluster_r1721619408' host: 'cluster2.willing' (failed on flush_net())
    2018-02-21T15:16:48.046190Z 141 [Note] Aborted connection 141 to db: 'unconnected' user: 'root' host: 'd5e07af19ef5' (Got an error reading communication packets). I got confused kindly help me please...

  • Avatar
    Ivan Postnikov

    @Mskumar Blaze

    Hello!

    I would suggest contacting MySQL Technical Support regarding this issue as they are experts in their product.

Please sign in to leave a comment.

Have more questions? Submit a request