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 syntax
Code: 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 syntax
Nun 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