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

[Hardie, Andrew]

It means a MySQL privilege, not a CQPweb one.

GRANT PROCESS ON *.* TO (CQPweb account specified here)

Is the sql syntax if I recall correctly (but do check the manual!)

Note this is an experimental and untested tool. I should prob have labelled it as such....

Andrew.
________________________________
From: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> on behalf of Scott Sadowsky <ssadowsky at gmail.com>
Sent: Friday, June 14, 2019 5:04:07 PM
To: Open source development of the Corpus WorkBench
Subject: [CWB] [CQPweb] Tablespace fragmentation control requires "PROCESS privilege(s)"?

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 name      Theoretical size        Size on disk    Ratio   Optimise

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/20190615/595a3a00/attachment.html>