DB korrupt?!
Verfasst: 19 Sep 2022, 15:15
				
				Hallo Leute,
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.
habe dann diese mit SQL Boardmitteln versucht die DB zu retten
laut Checker passt auch alles wieder, aber ich denke die Daten in den Tabellen sind kaput 
Ich kann z.B. die Treiber Check nicht mehr ausführen
oder neue Links setzen:
Die treiber selbst liegen noch alle im FS
Nun die Frage, wie kann ich die DB-Einträge reparieren oder neu erstellen?
ein
brachte keine Besserung.
Danke im Vorraus
			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