ADA not able to execute/complete the Offline Backup
search cancel

ADA not able to execute/complete the Offline Backup

book

Article ID: 7570

calendar_today

Updated On:

Products

CA Application Delivery Analysis MTP (NetQoS / ADA)

Issue/Introduction

Backup with error:

Backing up 201 tables from super to D:\CA\ADABackup.
 82% [==================================================            ]ETA  17:33m
ysqldump: Couldn't execute 'SHOW TRIGGERS LIKE 'runs1'': Can't create/write to f
ile 'C:\Windows\TEMP\#sql828_33aa_a.MYI' (Errcode: 22) (1)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_343b_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show create table `runs1_ipv6`': File 'C:\Windows\T
EMP\psyFB29.tmp' not found (Errcode: 22) (29)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_343c_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show create table `runs2`': File 'C:\Windows\TEMP\p
syFB68.tmp' not found (Errcode: 22) (29)
 84% [====================================================          ]ETA  17:46m
ysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_343d_2.MYI
' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show create table `runs2_ipv6`': Out of memory; res
tart server and try again (needed 2 bytes) (1037)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_343e_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show create table `scope_types`': Can't find file:
'.\super\scope_types.frm' (errno: 22) (1017)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_343f_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show fields from `servers`': Can't create/write to
file 'C:\Windows\TEMP\#sql828_343f_5.MYI' (Errcode: 22) (1)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_3440_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show fields from `servers_ipv6`': Can't create/writ
e to file 'C:\Windows\TEMP\#sql828_3440_5.MYI' (Errcode: 22) (1)
 86% [=====================================================         ]ETA  17:42m
ysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_3441_2.MYI
' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show fields from `server_episodes`': Can't create/w
rite to file 'C:\Windows\TEMP\#sql828_3441_5.MYI' (Errcode: 22) (1)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_3442_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show create table `server_episodes_durations`': Got
 error 22 from storage engine (1030)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_3443_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show create table `server_episode_email`': Can't fi
nd file: '.\super\server_episode_email.frm' (errno: 22) (1017)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_3444_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show fields from `server_probe_feed_history`': Can'
t create/write to file 'C:\Windows\TEMP\#sql828_3444_5.MYI' (Errcode: 22) (1)
 88% [======================================================        ]ETA  17:39m
ysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_3445_2.MYI
' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show fields from `server_probe_feed_summary`': Can'
t create/write to file 'C:\Windows\TEMP\#sql828_3445_5.MYI' (Errcode: 22) (1)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_3446_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show create table `severity`': Can't find file: '.\
super\severity.frm' (errno: 22) (1017)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_3447_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show fields from `sources`': Can't create/write to
file 'C:\Windows\TEMP\#sql828_3447_5.MYI' (Errcode: 22) (1)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_3448_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show fields from `sources_to_probes`': Can't create
/write to file 'C:\Windows\TEMP\#sql828_3448_5.MYI' (Errcode: 22) (1)
 90% [=======================================================       ]ETA  17:35m
ysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_3449_2.MYI
' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show fields from `source_sets`': Can't create/write
 to file 'C:\Windows\TEMP\#sql828_3449_5.MYI' (Errcode: 22) (1)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_344a_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show create table `source_sets_i18n`': Can't find f
ile: '.\super\source_sets_i18n.frm' (errno: 22) (1017)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_344b_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show fields from `source_sets_to_servers`': Can't c
reate/write to file 'C:\Windows\TEMP\#sql828_344b_5.MYI' (Errcode: 22) (1)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_344c_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show fields from `special_apps`': Can't create/writ
e to file 'C:\Windows\TEMP\#sql828_344c_5.MYI' (Errcode: 22) (1)
 92% [=========================================================     ]ETA  17:32m
ysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_344d_2.MYI
' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show create table `strings_i18n`': Can't find file:
 '.\super\strings_i18n.frm' (errno: 22) (1017)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_344e_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show fields from `subnets`': Can't create/write to
file 'C:\Windows\TEMP\#sql828_344e_5.MYI' (Errcode: 22) (1)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_344f_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show create table `subnets_ipv6`': Can't find file:
 '.\super\subnets_ipv6.frm' (errno: 22) (1017)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_3450_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show create table `subnet_types`': Can't find file:
 '.\super\subnet_types.frm' (errno: 22) (1017)
 94% [==========================================================    ]8m43s Leftm
ysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_3451_2.MYI
' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show fields from `synchronize`': Can't create/write
 to file 'C:\Windows\TEMP\#sql828_3451_5.MYI' (Errcode: 22) (1)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_3452_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show fields from `tasks`': Can't create/write to fi
le 'C:\Windows\TEMP\#sql828_3452_5.MYI' (Errcode: 22) (1)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_3453_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show create table `timezones`': Can't find file: '.
\super\timezones.frm' (errno: 22) (1017)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_3454_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show create table `timezones_i18n`': Can't find fil
e: '.\super\timezones_i18n.frm' (errno: 22) (1017)
 96% [===========================================================   ]5m42s Leftm
ysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_3455_2.MYI
' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show create table `users`': Got error 22 from stora
ge engine (1030)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_3456_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show create table `users_i18n`': Can't find file: '
.\super\users_i18n.frm' (errno: 22) (1017)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_3457_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show create table `user_settings`': Can't find file
: '.\super\user_settings.frm' (errno: 22) (1017)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_3458_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show create table `user_settings_items`': Can't fin
d file: '.\super\user_settings_items.frm' (errno: 22) (1017)
 98% [============================================================  ]2m47s Leftm
ysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_3459_2.MYI
' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show create table `user_source_instances`': Can't f
ind file: '.\super\user_source_instances.frm' (errno: 22) (1017)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_345a_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show fields from `vlan_feed_map`': Can't create/wri
te to file 'C:\Windows\TEMP\#sql828_345a_5.MYI' (Errcode: 22) (1)
mysqldump: Error: 'Can't create/write to file 'C:\Windows\TEMP\#sql828_345b_2.MY
I' (Errcode: 22)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show create table `websvc_versions`': Can't find fi
le: '.\super\websvc_versions.frm' (errno: 22) (1017)
100% [==============================================================]D 2h16m48s
D:\CA\BackupTools>

Environment

ADA 10.1Windows 2008

Cause

Database Corruption and Missing Files

Resolution

Repairing the entire database

First, you should check all tables and try a first-level repair of ones that are corrupt. To do this:

  • Stop all NetQoS Services.
  • Restart only the NetQoS MySQL51 service.
  • Open a command prompt. (Start -> Run -> cmd )
  • Run the command

    mysqlcheck --auto-repair -A
  • If any tables are shown to be corrupted, re-run the above command and see if the table(s) still shows as corrupt.

 

Execute the Backup

 

 

Additional Information

https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.TEC591743.html

Powered by Wolken Software