Modify trove instance status from database

Due to the test mysql5.5 replication function, the default trove using Gtid,instance is in Backup state, trove Reset-status cannot be run in Backup state, modify the database manually

Modify the status_id field in the Service_statuses table to 0x16, 22 for decimal

Status Code View File

# trove/common/instance.py 97 line Class servicestatuses (object):     running  = servicestatus (0x01,  ' running ',  ' ACTIVE ')     BLOCKED =  ServiceStatus (0x02,  ' blocked ',  ' blocked ')     paused = servicestatus ( 0x03,  ' paused ',  ' SHUTDOWN ')     shutdown = servicestatus (0x04,  ' Shutdown ',  ' shutdown ')     crashed = servicestatus (0x06,  ' CRASHED '),   ' SHUTDOWN ')     failed = servicestatus (0x08,  ' failed to  Spawn ',  ' FAILED ')     building = servicestatus (0x09,  ' BUILDING ',  ' BUILD ')     promoting = servicestatus (0x10,  ' Promoting replica ',  ' PROMOTE ')     ejecting = servicestatus (0x11,  ' ejecting replica  SOURCE ',  ' EJECT ')  &nbsP;  logging = servicestatus (0x12,  ' transferring guest logs ',  ' LOGGING ' )     unknown = servicestatus (0x16,  ' UNKNOWN ',  ' ERROR ')      new = servicestatus (0x17,  ' new ',  ' new ')     deleted =  servicestatus (0x05,  ' deleted ',  ' deleted ')     failed_timeout_guestagent  = servicestatus (0x18,  ' Guestagent error ',                                                  ' ERROR ')     instance_ready = servicestatus (0x19,  ' INSTANCE  ready ',  ' BUILD ')     restart_required = servicestatus (0x20,  ' Restart required ',  &NBsp;                                     ' Restart_required ')

This article is from the "Wuling Grassland" blog, please make sure to keep this source http://penguintux.blog.51cto.com/3021117/1911721

Modify trove instance status from database