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(18.104.22.168)] INFO: Quiescing databases
27 [Thu Feb 3 16:21:24 2011] [192.168.2.219:9090(22.214.171.124)] INFO: Quiescing database mysql
28 [Thu Feb 3 16:21:24 2011] [192.168.2.219:9090(126.96.36.199)] DEBUG: Connection to mysql successfully established
29 [Thu Feb 3 16:21:24 2011] [192.168.2.219:9090(188.8.131.52)] 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(184.108.40.206)] ERROR: #08S01Got packets out of order
31 [Thu Feb 3 17:21:12 2011] [192.168.2.219:9090(220.127.116.11)] ERROR: Application quiesce for plugin mysql failed with exit code 1, Exiting!
- Both source and destination arrays are running ONTAP 8.0.1
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.
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?
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.
Yes its happening.We tried with root and dfm login.both are working.NGS told that it is issue with mysql.But customer dont have sql admin to resolve this issue.Not This is new setup(mysqldb/snapcreator).
MySQL Enterprise Server 5.1.30 MySQL Enterprise Server 5.1.31 MySQL Enterprise Server 5.1.32 MySQL Enterprise Server 5.1.33 MySQL Enterprise Server 5.1.34 MySQL Enterprise Server 5.1.35 MySQL Enterprise Server 5.1.36 MySQL Enterprise Server 5.1.37 MySQL Enterprise Server 5.1.38 MySQL Enterprise Server 5.1.39 MySQL Enterprise Server 5.1.40 MySQL Enterprise Server 5.1.41 MySQL Enterprise Server 5.1.42 MySQL Enterprise Server 5.1.43 MySQL Enterprise Server 5.1.44 MySQL Enterprise Server 5.1.45 MySQL Enterprise Server 5.1.46 MySQL Enterprise Server 5.1.47 MySQL Enterprise Server 5.1.48 MySQL Enterprise Server 5.1.49 MySQL Enterprise Server 5.1.50 MySQL Enterprise Server 5.1.51 MySQL Enterprise Server 5.1.52
Other's have also had problems with 5.0.x with SC. It appears that there are some incompadibility issues w/Net::MySQL and the MySQL client libs.
A workaround solution to this problem is simply not use MYSQL plugin.
You can try using mysql command
APP_QUIESCE_CMD01=mysql <arguments> <sql query=flush tables with read lock>