From Jon Brandenburg, 3 Years ago, written in Plain Text.
Embed
  1. librenms@sclibrenms:~$ ./validate.php
  2. ====================================
  3. Component | Version
  4. --------- | -------
  5. LibreNMS  | 21.3.0-57-g6616727a9
  6. DB Schema | 2021_03_11_003713_rename_printer_columns (204)
  7. PHP       | 7.4.3
  8. Python    | 3.8.5
  9. MySQL     | 10.3.25-MariaDB-0ubuntu0.20.04.1
  10. RRDTool   | 1.7.2
  11. SNMP      | NET-SNMP 5.8
  12. ====================================
  13.  
  14. [OK]    Composer Version: 2.0.11
  15. [OK]    Dependencies up-to-date.
  16. [OK]    Database connection successful
  17. [FAIL]  Your database is out of date!
  18.         [FIX]:
  19.         ./lnms migrate
  20. librenms@sclibrenms:~$ ./lnms migrate
  21. **************************************
  22. *     Application In Production!     *
  23. **************************************
  24.  
  25.  Do you really wish to run this command? (yes/no) [no]:
  26.  > yes
  27.  
  28. Migrating: 2021_02_09_122930_migrate_to_utf8mb4
  29.  
  30. In Connection.php line 678:
  31.  
  32.   SQLSTATE[HY000]: General error: 1206 The total number of locks exceeds the lock table size (SQL: ALTER TABLE `syslog`
  33.                       MODIFY `facility`
  34.                       varchar(10)
  35.                       CHARACTER SET utf8mb4
  36.                       COLLATE utf8mb4_unicode_ci
  37.                       NULL ;)
  38.  
  39.  
  40. In Exception.php line 18:
  41.  
  42.   SQLSTATE[HY000]: General error: 1206 The total number of locks exceeds the lock table size
  43.  
  44.  
  45. In PDOConnection.php line 52:
  46.  
  47.   SQLSTATE[HY000]: General error: 1206 The total number of locks exceeds the lock table size
  48.  
  49.  
  50. librenms@sclibrenms:~$
  51.