Data Backup and Recovery

SnapCreator 3.5 mysql plugin. not able to quiesce

wolfsonmicro
7,623 Views

Hi

I am having problem to make it work 😕

I am not able to quiesce  MySql database even from the host.

########## Application quiesce ##########
[Mon Jan 23 14:30:46 2012] DEBUG: Timeout of authentication at /</NetApp_Snap_Creator_Framework3.5.0-Linux64/scServer3.5.0/snapcreator>SnapCreator/MOD/MYSQL.pm line 112

[Mon Jan 23 14:30:46 2012] INFO: Quiescing databases
[Mon Jan 23 14:30:46 2012] ERROR: [mys-00001] Database connection does not exist
[Mon Jan 23 14:30:46 2012] ERROR: [scf-00053] Application quiesce for plugin mysql failed with exit code 1, Exiting!

at the beginnig I thought my problem could be relative to my network , so I ran the commande line directly from my Mysql server.

./snapcreator --action quiesce --profile macas --verbose --debug

everytime I have 

root@alain macas]# cat macas.debug.20120123143046.log
[Mon Jan 23 14:30:46 2012] DEBUG: GMT - Mon Jan 23 14:30:46 2012
[Mon Jan 23 14:30:46 2012] DEBUG: Version: NetApp Snap Creator Framework 3.5.0
[Mon Jan 23 14:30:46 2012] DEBUG: Profile: macas
[Mon Jan 23 14:30:46 2012] DEBUG: Config Type: STANDARD
[Mon Jan 23 14:30:46 2012] DEBUG: Action: quiesce
[Mon Jan 23 14:30:46 2012] DEBUG: Application Plugin: mysql
[Mon Jan 23 14:30:46 2012] DEBUG: File System Plugin: null
[Mon Jan 23 14:30:46 2012] DEBUG: Policy: null
[Mon Jan 23 14:30:46 2012] DEBUG: Snapshot Name: null
[Mon Jan 23 14:30:46 2012] INFO: Logfile timestamp: 20120123143046
[Mon Jan 23 14:30:46 2012] DEBUG: Timeout of authentication at /</NetApp_Snap_Creator_Framework3.5.0-Linux64/scServer3.5.0/snapcreator>SnapCreator/MOD/MYSQL.pm line 112


########## Parsing Environment Parameters ##########
[Mon Jan 23 14:30:46 2012] DEBUG: Parsing VOLUMES - controller: mercury volume: cdump
[Mon Jan 23 14:30:46 2012] DEBUG: Parsing NTAP_USERS - controller: mercury user: root
[Mon Jan 23 14:30:46 2012] DEBUG: Parsing NTAP_SNAPSHOT_RETENTIONS - policy: daily retention: 3

########## Application quiesce ##########
[Mon Jan 23 14:30:46 2012] DEBUG: Timeout of authentication at /</NetApp_Snap_Creator_Framework3.5.0-Linux64/scServer3.5.0/snapcreator>SnapCreator/MOD/MYSQL.pm line 112

[Mon Jan 23 14:30:46 2012] INFO: Quiescing databases
[Mon Jan 23 14:30:46 2012] ERROR: [mys-00001] Database connection does not exist
[Mon Jan 23 14:30:46 2012] ERROR: [scf-00053] Application quiesce for plugin mysql failed with exit code 1, Exiting!

########## Application unquiesce ##########
[Mon Jan 23 14:30:46 2012] DEBUG: Timeout of authentication at /</NetApp_Snap_Creator_Framework3.5.0-Linux64/scServer3.5.0/snapcreator>SnapCreator/MOD/MYSQL.pm line 112

[Mon Jan 23 14:30:46 2012] INFO: Unquiescing databases
[Mon Jan 23 14:30:46 2012] ERROR: [mys-00004] Database connection does not exist
[Mon Jan 23 14:30:46 2012] ERROR: [scf-00054] Application unquiesce for plugin mysql failed with exit code 1, Exiting!

########## PRE EXIT COMMANDS ##########
[Mon Jan 23 14:30:46 2012] INFO: No commands defined

########## PRE EXIT COMMANDS FINISHED SUCCESSFULLY ##########
[Mon Jan 23 14:30:46 2012] DEBUG: Exiting with error code - 2

looks like the authentification to my Mysql databse does not work

I created a new REDHAT VM and install MySql on. I use root to connect to the database for the test but unfortunatly I still have the same issue.

could be the problem be it in a VM? what setting(s) should I check ?

I am not using SSL

I attached configuration file(named mysql.conf)

Many thanks in advanced

Alain

1 ACCEPTED SOLUTION

ktenzer
7,622 Views

It looks like SC cant get a database connection. Below are your settings:

MYSQL_DATABASES=mysql:root/53616c7465645f5f9b57ab314e02617d65cf27adbba602ed266987370e53704f

HOST=172.20.20.192

PORTS=mysql:3306

MASTER_SLAVE=N

I would change HOST=localhost

I would verify is DB really running on 3306? Do a
"telnet localhost 3306"

I would check the database connection: mysql -uUsername -pPassword

Do you get a connection using same user running SC with password SC is using for mysql?

I would not use --action quiesce, the --action snap is better, it will run quiesce as well.

Finally what version of SC do you have? The latest version on NOW is 3.5, if you have 3.3 or something old, I would get 3.5.

Let me know if this helps?

Regards,

Keith

View solution in original post

12 REPLIES 12
Public