ADA not able to execute/complete the Offline Backup

Document ID : KB000007570
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:
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