moosh icon indicating copy to clipboard operation
moosh copied to clipboard

sudo -u www-data moosh db-stats - error

Open caiadogithub opened this issue 2 years ago • 0 comments

  • moosh version: 1.5
  • moodle version: 3.11.6+
    • database: PostgreSQL 12
  • php version: 7.43
  • operating system: Ubuntu 20.04

Actual behaviour

Default exception handler: Erro ao ler a base de dados Debug: ERROR: syntax error at or near "'table'" LINE 1: SELECT table_name AS 'table', ^ SELECT table_name AS 'table', ROUND(((data_length + index_length))) AS 'size' FROM information_schema.TABLES WHERE table_schema = 'db_mooc-nce' ORDER BY (data_length + index_length) DESC [array ( )] Error code: dmlreadexception

  • line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
  • line 329 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
  • line 977 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
  • line 25 of /usr/share/moosh/Moosh/Command/Moodle39/Report/DbStats.php: call to pgsql_native_moodle_database->get_records_sql()
  • line 361 of /usr/bin/moosh: call to Moosh\Command\Moodle39\Report\DbStats->execute()

!!! Erro ao ler a base de dados !!!

Expected behaviour

Shows the total size of the Moodle database and the biggest tables.

Steps to reproduce

sudo -u www-data moosh db-stats

caiadogithub avatar Apr 12 '22 18:04 caiadogithub