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 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