2011-02-09 03:30 AM - edited 2015-12-18 12:47 AM
I am using SnapCreator 3.3.0 to perform Mysql db(lun snapshot)backup and integration with protection manager.SnapCreator Server installed on DFM4.0 and agents installed on Mysql DB servers(2 servers in cluster installed on RHEL 5.2).As per SC admin/install doc done the install and config but while trying to run SC snapshot we are getting below error:
26 [Thu Feb 3 16:21:24 2011] [192.168.2.219:9090(22.214.171.124)] INFO: Quiescing databases
27 [Thu Feb 3 16:21:24 2011] [192.168.2.219:9090(126.96.36.199)] INFO: Quiescing database mysql
28 [Thu Feb 3 16:21:24 2011] [192.168.2.219:9090(188.8.131.52)] DEBUG: Connection to mysql successfully established
29 [Thu Feb 3 16:21:24 2011] [192.168.2.219:9090(184.108.40.206)] DEBUG: Executing sql command 'flush tables with read lock' for database mysql
30 [Thu Feb 3 16:21:24 2011] [192.168.2.219:9090(220.127.116.11)] ERROR: #08S01Got packets out of order
31 [Thu Feb 3 17:21:12 2011] [192.168.2.219:9090(18.104.22.168)] ERROR: Application quiesce for plugin mysql failed with exit code 1, Exiting!
- Both source and destination arrays are running ONTAP 8.0.1
- SC 3.3.0 and DFM 4.0 (installed on same server)
Thanks in advance for any thoughts.
2011-02-09 03:47 AM
Please find the config details.Also i will attach the config files.
Configuration Name: DBbackup
Filer Name: 192.168.2.157
Filer User: ndmp
Filer Password: *****
Password Protection: yes
Snapshot Name: Scdb
Snapshot Policy Name: daily
Snapshot Policy Retention: 1
Snapshot Policy Retention Age: 30
Snapshot Policy Name Convention: Timestamp
Consistency Group: Yes
Consistency Group Timeout: medium
SnapVault Update: Yes
SnapVault Retention: 60
SnapVault Retention Age: 60
SnapVault Wait Time: 60
SnapVault Volumes: snap_Test
MySql Db:User/Password: snapdb:dfm/dfm123
Mysql Host: 192.168.2.219
Mysql Master Slave: No
Agent IP/DNS: 192.168.2.219
Agent Port: 9090
Server Timeout (secs): 1800
OM Host: 192.168.2.218
OM User: root
OM Password: *****
OM Port: 8088
OM Alerting: Yes
2011-02-09 03:51 AM
The config file is missing in the scdump zip file for some reason. Can you send it? I would recommend opening NGS support case, that is quickest way to get you help but we would be happy to take a look as well.
It seems like either a network issue or rights of the mysql user (I have seen this error before but dont remember what it was). One thing to try would be not to use the agent, the MySQL plugin can run agentless. So comment out SC_AGENT line and see what happens.
2011-02-09 04:03 AM
I have attached config details.We installed SC agent on db servers and SC server on DFM server.Where we need to comment SC_AGENT line.We are planning to install SC server on db servers and try to take sc snapshot.Is this will make any difference?
2011-02-09 04:05 AM
What do the following commands result with
mysql -u root -p (also try to log in remotely from scServer)
telnet 192.168.2.219 3306
Also what happens if you try things without agent so comment out SC_AGENT?
2011-02-09 04:11 AM
You comment out SC_AGENT line in config file
You can install scServer on DB host but why? You could just install scServer centrally. The scServer can talk to MySQL DB remotely or though agent, the agent is optional, depends on if port 3306 is open to scServer or not. If it isnt then you need scServer local or agent and then scServer central. If 3306 is open then you just need scServer central.
Again I would recommend opening a NGS support case.