Subscribe

Snapcreator 3.3.0 for Mysql 5.1.51

[ Edited ]

Hi,

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(3.3.0.1)] INFO: Quiescing databases

27 [Thu Feb  3 16:21:24 2011] [192.168.2.219:9090(3.3.0.1)] INFO: Quiescing database mysql

28 [Thu Feb  3 16:21:24 2011] [192.168.2.219:9090(3.3.0.1)] DEBUG: Connection to mysql successfully established

29 [Thu Feb  3 16:21:24 2011] [192.168.2.219:9090(3.3.0.1)] 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(3.3.0.1)] ERROR: #08S01Got packets out of order

31 [Thu Feb  3 17:21:12 2011] [192.168.2.219:9090(3.3.0.1)] ERROR: Application quiesce for plugin mysql failed with exit code 1, Exiting!

Environment:

- 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.

-Raj

Re: Snapcreator for Mysql 3.3.0

Config file please….

Thanks

Karthikeyan.N

Re: Snapcreator for Mysql 3.3.0

Hi Karthik,

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

Volumes: snap_Test

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
Database: MySql
MySql Db:User/Password: snapdb:dfm/dfm123
Mysql Host: 192.168.2.219
Mysql Port:3306
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

Re: Snapcreator for Mysql 3.3.0

Hi Raj,

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.

Regards,

Keith

Re: Snapcreator for Mysql 3.3.0

Hi,

Please find the config files.Created 2 files but for both we are getting same error.

Thanks,

Raj

Re: Snapcreator for Mysql 3.3.0

Can you please upload the config file so we can see it, feel free to remove passwords with "xxxxxx" if you arent using encrypted passwords.

Keith

Re: Snapcreator for Mysql 3.3.0

Keith,

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?

Thanks,

Raj

Re: Snapcreator for Mysql 3.3.0

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?

Regards,

Keith

Re: Snapcreator for Mysql 3.3.0

You comment out SC_AGENT line in config file

#SC_AGENT=host:port

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.

Regards,

kEITH

Re: Snapcreator for Mysql 3.3.0

Can you able to login to the mysql using

“Mysql –h 192.168.2.219 –Dsnapdb –udfm –Pdfm123 –port 3306” from where you are trying to take the backup.

Thanks

Karthikeyan.N