Search Engine: Elastic

Article ID: 131031, created on Jun 21, 2017, last review on Jun 23, 2017

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

Symptoms

Collect databases diskspace usage task fails with the following output:

Task ID 123456
Queue name  dbm_diskusage_52
Task name Collect databases diskspace usage for service 52
Task description    Collect databases diskspace usage for service 52
Parent task ID  4781901
Queue status Failed
Start not earlier than  Oct-29-2015 17:27
Method name taskExecuteServerOperation on SCREF:db.manager:0
Last execution output   
MySQL API error: SELECT command denied to user 'dbuser_100100'@'%' for column 'test_column' in table 'test_table'.

The following messages appear in osscore log:

Oct 29 17:27:44 mn.domain.tld : DBG [task:123456:232375 1:13534:b20ffb70 MySQL 1861467989]: [ MySQL] 10.10.0.10:mysql SELECT sum(data_length+index_length) AS total FROM information_schema.tables WHERE table_schema = 'db_100100'
Oct 29 17:27:44 mn.domain.tld : DBG [task:123456:232375 1:13534:b20ffb70 lib 1861467989]: [ MySQL] {module_id="Databases"; code="610"} MySQL API error: SELECT command denied to user 'dbuser_100100'@'%' for column 'test_column' in table 'test_table'.

Running the following command on the MySQL server fails:

mysql> SELECT * FROM information_schema.tables limit 1;
ERROR 1143 (42000): SELECT command denied to user 'dbuser_100100'@'%' for column 'test_column' in table 'test_table'

Cause

The behavior is recognized as POA-111804 (Views with incorrect SQL security context in mySQL lead to failed "Collect databases diskspace usage" task).

Resolution

In order to workaround the issue, the following actions should be performed:

  1. Check table status on the MySQL server

    mysql> use db_100100;
    mysql> show table status;
    ERROR 1143 (42000): SELECT command denied to user 'dbuser_100100'@'%' for column 'test_column' in table 'test_table'
    
  2. List views of the database

    mysql> show full tables in db_100100 where table_type not like '%table%';
    +---------------------+------------+
    | Tables_in_db_100100 | Table_type |
    +---------------------+------------+
    | test_view           | VIEW       |
    +---------------------+------------+
    
  3. Check the view

    mysql> select * From test_view;
    ERROR 1356 (HY000): View 'db_100100.test_view' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
    
  4. If case of the same error as in point 4, please follow 113106 KB-article

5b048d9bddf8048a00aba7e0bdadef37 caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 5356b422f65bdad1c3e9edca5d74a1ae 2554725ed606193dd9bbce21365bed4e 0871c0b47b3b86ae3b1af4c2942cd0ce 1941880841f714e458ae4dc3d9f3062d 8c199f0ee4305da1a577740620df4a51 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0

Email subscription for changes to this article
Save as PDF