[CWB] [CQPweb] Tablespace fragmentation control requires "PROCESS privilege(s)"?

[Scott Sadowsky]

I'm trying to use the *Tablespace fragmentation control* function, but it
throws an error about me not having "(at least one of) the PROCESS
privilege(s)" (see below).

I've granted myself every logical privilege that's available (the ones I
haven't granted myself are illogical, e.g. restricted and normal corpus
access when I already have full access).

So what privileges do you need to use this function, and how do you create
and/or grant them?

Thanks in advance!
Scott

Tablespace fragmentation control

MySQL InnoDB database tables are stored in tablespace files. These files
can become fragmented, in which case they will begin to occupy more disk
space than they theoretically ought to. This can cause the cache to
overflow.

Using the "Optimise" command can reduce the space occupied by a tablespace
file so that it does not overflow.

The display below lists all CQPweb cache-database tablefiles, in order of
how fragmented they appear to be.
Table nameTheoretical sizeSize on diskRatioOptimise

An SQL query did not run successfully!

Original query: select `NAME` from
`INFORMATION_SCHEMA`.`INNODB_SYS_TABLESPACES` limit 1 /* from User: scott |
Function: can_get_sql_real_size() | 2019-Jun-14 12:46 */

Error # 1227: Access denied; you need (at least one of) the PROCESS
privilege(s) for this operation
PHP debugging backtrace

array(6) {
  [1]=>
  array(4) {
    ["file"]=>
    string(42) "/var/www/html/cqpweb/lib/exiterror-lib.php"
    ["line"]=>
    int(300)
    ["function"]=>
    string(9) "exiterror"
    ["args"]=>
    array(3) {
      [0]=>
      array(3) {
        [0]=>
        string(38) "An SQL query did not run successfully!"
        [1]=>
        string(173) "Original query:

select `NAME` from `INFORMATION_SCHEMA`.`INNODB_SYS_TABLESPACES` limit 1
	/* from User: scott | Function: can_get_sql_real_size() | 2019-Jun-14 12:46 */

"
        [2]=>
        string(100) "Error # 1227: Access denied; you need (at least
one of) the PROCESS privilege(s) for this operation "
      }
      [1]=>
      NULL
      [2]=>
      NULL
    }
  }
  [2]=>
  array(4) {
    ["file"]=>
    string(36) "/var/www/html/cqpweb/lib/sql-lib.php"
    ["line"]=>
    int(198)
    ["function"]=>
    string(20) "exiterror_mysqlquery"
    ["args"]=>
    array(3) {
      [0]=>
      int(1227)
      [1]=>
      string(85) "Access denied; you need (at least one of) the
PROCESS privilege(s) for this operation"
      [2]=>
      string(153) "select `NAME` from
`INFORMATION_SCHEMA`.`INNODB_SYS_TABLESPACES` limit 1
	/* from User: scott | Function: can_get_sql_real_size() | 2019-Jun-14 12:46 */"
    }
  }
  [3]=>
  array(4) {
    ["file"]=>
    string(36) "/var/www/html/cqpweb/lib/sql-lib.php"
    ["line"]=>
    int(906)
    ["function"]=>
    string(12) "do_sql_query"
    ["args"]=>
    array(1) {
      [0]=>
      string(153) "select `NAME` from
`INFORMATION_SCHEMA`.`INNODB_SYS_TABLESPACES` limit 1
	/* from User: scott | Function: can_get_sql_real_size() | 2019-Jun-14 12:46 */"
    }
  }
  [4]=>
  array(4) {
    ["file"]=>
    string(53) "/var/www/html/cqpweb/lib/admin-cachecontrol-forms.php"
    ["line"]=>
    int(1217)
    ["function"]=>
    string(21) "can_get_sql_real_size"
    ["args"]=>
    array(0) {
    }
  }
  [5]=>
  array(4) {
    ["file"]=>
    string(38) "/var/www/html/cqpweb/lib/adminhome.php"
    ["line"]=>
    int(358)
    ["function"]=>
    string(30) "printquery_innodbfragmentation"
    ["args"]=>
    array(0) {
    }
  }
  [6]=>
  array(4) {
    ["file"]=>
    string(34) "/var/www/html/cqpweb/adm/index.php"
    ["line"]=>
    int(1)
    ["args"]=>
    array(1) {
      [0]=>
      string(38) "/var/www/html/cqpweb/lib/adminhome.php"
    }
    ["function"]=>
    string(7) "require"
  }
}
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20190614/2838c403/attachment-0001.html>