Search Engine: Elastic

Article ID: 119483, created on Jan 5, 2014, last review on May 10, 2018

  • Applies to:
  • Operations Automation 7.1
  • Operations Automation 6.0
  • Operations Automation 5.5
  • Operations Automation 5.4

Symptoms

MySQL database backup task failed with "Couldn't execute 'show create table object_2': SHOW VIEW command denied to user 'root'@'IP' for table 'object_2' (1142)":

Task name       Backup '<DB_NAME>' into group '<GROUP>'
Last execution output   Destination host '<HOST>' (#27), IP '<IP>' : Internal error: /bin/sh /bin/sh -c /usr/local/pem/bin/mysql_backup.sh 'root' '' <IP> 3306 '<DB_NAME>' '/usr/local/pem/Backups/database/backup_data' failed with code 2 saying: STDOUT: '' STDERR 'mysqldump: Couldn't execute 'show create table `object_2`': SHOW VIEW command denied to user 'root'@'<IP>' for table 'object_2' (1142)

Cause

On <HOST> "Show_view_priv" is not allowed for "root" user on the mysql side.

Resolution

Please contact Odin Technical Support to fix the issue.

ac82ce33439a9c1feec4ff4f2f638899 caea8340e2d186a540518d08602aa065 5356b422f65bdad1c3e9edca5d74a1ae 2554725ed606193dd9bbce21365bed4e e12cea1d47a3125d335d68e6d4e15e07 5b048d9bddf8048a00aba7e0bdadef37 0efe2234e2ce513f2186f26c68447702 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 8c199f0ee4305da1a577740620df4a51 1941880841f714e458ae4dc3d9f3062d 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0

Email subscription for changes to this article
Save as PDF