ich hoffe mal hier kann mir geholfen werden. Ich glaube meine DB (mariadb, da auf RHEL) ist nicht mehr in Ordnung.
Es kam durch einen harten Shutdown wohl zu korrupten Table in der MariaDB.
Code: Alles auswählen
/var/log/messages-20220911:Sep  8 12:14:14 afb-app-ins-001 mariadbd: 2022-09-08 12:14:14 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_SYSTEM_SLOT' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_SYSTEM_SLOT'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_DEVICE_SYSTEM_SLOT' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_DEVICE_SYSTEM_SLOT'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_PCI_DEVICE' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_PCI_DEVICE'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_DEVICE_PCI_DEVICE' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_DEVICE_PCI_DEVICE'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_KEYBOARD' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_KEYBOARD'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_MEMORY_MODULE' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_MEMORY_MODULE'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_DEVICE_MEMORY_MODULE' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_DEVICE_MEMORY_MODULE'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_DISK_PARTITION' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_DISK_PARTITION'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_1394_CONTROLLER' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_1394_CONTROLLER'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_NETWORK_CONTROLLER' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_NETWORK_CONTROLLER'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_DEVICE_NETWORK_CONTROLLER' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_DEVICE_NETWORK_CONTROLLER'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_PRINTER' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_PRINTER'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_IDE_CONTROLLER' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_IDE_CONTROLLER'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_HARDDISK_DRIVE' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_HARDDISK_DRIVE'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_PROCESSOR' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_PROCESSOR'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_DEVICE_PROCESSOR' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_DEVICE_PROCESSOR'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_BIOS' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_BIOS'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_DEVICE_BIOS' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_DEVICE_BIOS'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_CACHE_MEMORY' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_CACHE_MEMORY'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_DEVICE_CACHE_MEMORY' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_DEVICE_CACHE_MEMORY'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_VIDEO_CONTROLLER' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_VIDEO_CONTROLLER'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_DEVICE_VIDEO_CONTROLLER' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_DEVICE_VIDEO_CONTROLLER'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_COMPUTER_SYSTEM' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_COMPUTER_SYSTEM'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_DEVICE_COMPUTER_SYSTEM' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_DEVICE_COMPUTER_SYSTEM'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_AUDIO_CONTROLLER' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_AUDIO_CONTROLLER'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_DEVICE_AUDIO_CONTROLLER' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_DEVICE_AUDIO_CONTROLLER'
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_PORT_CONNECTOR' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:15 afb-app-ins-001 mariadbd: 2022-09-08 12:14:15 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_PORT_CONNECTOR'
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_MEMORY_BANK' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_MEMORY_BANK'
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_USB_CONTROLLER' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_USB_CONTROLLER'
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [ERROR] mariadbd: Table './opsi/HARDWARE_DEVICE_USB_CONTROLLER' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [Warning] Checking table:   './opsi/HARDWARE_DEVICE_USB_CONTROLLER'
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_TPM' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_TPM'
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [ERROR] mariadbd: Table './opsi/HARDWARE_DEVICE_TPM' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [Warning] Checking table:   './opsi/HARDWARE_DEVICE_TPM'
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_BASE_BOARD' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_BASE_BOARD'
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [ERROR] mariadbd: Table './opsi/HARDWARE_DEVICE_BASE_BOARD' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [Warning] Checking table:   './opsi/HARDWARE_DEVICE_BASE_BOARD'
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_HDAUDIO_DEVICE' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_HDAUDIO_DEVICE'
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [ERROR] mariadbd: Table './opsi/HARDWARE_DEVICE_HDAUDIO_DEVICE' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [Warning] Checking table:   './opsi/HARDWARE_DEVICE_HDAUDIO_DEVICE'
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_MONITOR' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_MONITOR'
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_CHASSIS' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_CHASSIS'
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_OPTICAL_DRIVE' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_OPTICAL_DRIVE'
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_USB_DEVICE' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_USB_DEVICE'
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [ERROR] mariadbd: Table './opsi/HARDWARE_DEVICE_USB_DEVICE' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [Warning] Checking table:   './opsi/HARDWARE_DEVICE_USB_DEVICE'
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_POINTING_DEVICE' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_POINTING_DEVICE'
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [ERROR] mariadbd: Table './opsi/HARDWARE_CONFIG_SCSI_CONTROLLER' is marked as crashed and should be repaired
/var/log/messages-20220911:Sep  8 12:14:16 afb-app-ins-001 mariadbd: 2022-09-08 12:14:16 4 [Warning] Checking table:   './opsi/HARDWARE_CONFIG_SCSI_CONTROLLER'
/var/log/messages-20220911:Sep  8 12:40:44 afb-app-ins-001 mariadbd: 2022-09-08 12:40:44 3 [Warning] Aborted connection 3 to db: 'opsi' user: 'opsi' host: 'localhost' (Got an error reading communication packets)
/var/log/messages-20220911:Sep  8 12:41:00 afb-app-ins-001 mariadbd: 2022-09-08 12:41:00 4 [Warning] Aborted connection 4 to db: 'opsi' user: 'opsi' host: 'localhost' (Got an error reading communication packets)
Code: Alles auswählen
  928  mysqlcheck --repair --all-databases
  938  mysqlcheck --auto-repair -A
Ich kann z.B. die Treiber Check nicht mehr ausführen
Code: Alles auswählen
/var/lib/opsi/depot/win10-x64/show_drivers.py nb1000698.afb.lan
  File "/var/lib/opsi/depot/win10-x64/show_drivers.py", line 70
    raise Exception(f"Host '{hostId}' not found in opsi database")
                                                                ^
SyntaxError: invalid syntaxCode: Alles auswählen
/var/lib/opsi/depot/win10-x64/create_driver_links.py
  File "/var/lib/opsi/depot/win10-x64/create_driver_links.py", line 134
    raise Exception(f"No drivers found, please copy your drivers to {os.path.abspath('drivers')}")
                                                                                                ^
SyntaxError: invalid syntaxNun die Frage, wie kann ich die DB-Einträge reparieren oder neu erstellen?
ein
Code: Alles auswählen
  
  977  opsi-setup --init-current-config
  979  opsi-setup --update-mysql
Danke im Vorraus