json error (could not decode) (SOLVED)

[dkoch]

Try the basic things. Is Mysql running ? Can you connect to the database using the 'mysql' command? Maybe its corrupted.

[loggenk]

Thanks for reply.

Mysql isn't running.

When i try to start mysql error : Checking for corrupt, not cleanly closed and upgrade needing tables.

How can I solve this?

[dkoch]

Actually that is nothing to be solved. But give me the output of:

Code: Alles auswählen

mysqlrepair -A --auto-repair -p

[loggenk]

Now I see some innodb error messages:

root@opsi-nl-dev:~# mysqlrepair -A -p
Enter password:
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.servers OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
opsi.AUDIT_SOFTWARE_TO_LICENSE_POOL
Error : Unknown table engine 'InnoDB'
error : Corrupt
opsi.BOOT_CONFIGURATION
Error : Unknown table engine 'InnoDB'
error : Corrupt
opsi.CONFIG
Error : Unknown table engine 'InnoDB'
error : Corrupt
opsi.CONFIG_STATE
Error : Unknown table engine 'InnoDB'
error : Corrupt
opsi.CONFIG_VALUE
Error : Unknown table engine 'InnoDB'
error : Corrupt
opsi.GROUP
Error : Unknown table engine 'InnoDB'
error : Corrupt
opsi.HARDWARE_CONFIG_1394_CONTROLLER OK
opsi.HARDWARE_CONFIG_AUDIO_CONTROLLER OK
opsi.HARDWARE_CONFIG_BASE_BOARD OK
opsi.HARDWARE_CONFIG_BIOS OK
opsi.HARDWARE_CONFIG_CACHE_MEMORY OK
opsi.HARDWARE_CONFIG_CHASSIS OK
opsi.HARDWARE_CONFIG_COMPUTER_SYSTEM OK
opsi.HARDWARE_CONFIG_DISK_PARTITION OK
opsi.HARDWARE_CONFIG_FLOPPY_CONTROLLER OK
opsi.HARDWARE_CONFIG_FLOPPY_DRIVE OK
opsi.HARDWARE_CONFIG_HARDDISK_DRIVE OK
opsi.HARDWARE_CONFIG_HDAUDIO_DEVICE OK
opsi.HARDWARE_CONFIG_IDE_CONTROLLER OK
opsi.HARDWARE_CONFIG_KEYBOARD OK
opsi.HARDWARE_CONFIG_MEMORY_BANK OK
opsi.HARDWARE_CONFIG_MEMORY_MODULE OK
opsi.HARDWARE_CONFIG_MONITOR OK
opsi.HARDWARE_CONFIG_NETWORK_CONTROLLER OK
opsi.HARDWARE_CONFIG_OPTICAL_DRIVE OK
opsi.HARDWARE_CONFIG_PCI_DEVICE OK
opsi.HARDWARE_CONFIG_PCMCIA_CONTROLLER OK
opsi.HARDWARE_CONFIG_POINTING_DEVICE OK
opsi.HARDWARE_CONFIG_PORT_CONNECTOR OK
opsi.HARDWARE_CONFIG_PRINTER OK
opsi.HARDWARE_CONFIG_PROCESSOR OK
opsi.HARDWARE_CONFIG_SCSI_CONTROLLER OK
opsi.HARDWARE_CONFIG_SYSTEM_SLOT OK
opsi.HARDWARE_CONFIG_TAPE_DRIVE OK
opsi.HARDWARE_CONFIG_USB_CONTROLLER OK
opsi.HARDWARE_CONFIG_USB_DEVICE OK
opsi.HARDWARE_CONFIG_VIDEO_CONTROLLER OK
opsi.HARDWARE_DEVICE_1394_CONTROLLER OK
opsi.HARDWARE_DEVICE_AUDIO_CONTROLLER OK
opsi.HARDWARE_DEVICE_BASE_BOARD OK
opsi.HARDWARE_DEVICE_BIOS OK
opsi.HARDWARE_DEVICE_CACHE_MEMORY OK
opsi.HARDWARE_DEVICE_CHASSIS OK
opsi.HARDWARE_DEVICE_COMPUTER_SYSTEM OK
opsi.HARDWARE_DEVICE_DISK_PARTITION OK
opsi.HARDWARE_DEVICE_FLOPPY_CONTROLLER OK
opsi.HARDWARE_DEVICE_FLOPPY_DRIVE OK
opsi.HARDWARE_DEVICE_HARDDISK_DRIVE OK
opsi.HARDWARE_DEVICE_HDAUDIO_DEVICE OK
opsi.HARDWARE_DEVICE_IDE_CONTROLLER OK
opsi.HARDWARE_DEVICE_KEYBOARD OK
opsi.HARDWARE_DEVICE_MEMORY_BANK OK
opsi.HARDWARE_DEVICE_MEMORY_MODULE OK
opsi.HARDWARE_DEVICE_MONITOR OK
opsi.HARDWARE_DEVICE_NETWORK_CONTROLLER OK
opsi.HARDWARE_DEVICE_OPTICAL_DRIVE OK
opsi.HARDWARE_DEVICE_PCI_DEVICE OK
opsi.HARDWARE_DEVICE_PCMCIA_CONTROLLER OK
opsi.HARDWARE_DEVICE_POINTING_DEVICE OK
opsi.HARDWARE_DEVICE_PORT_CONNECTOR OK
opsi.HARDWARE_DEVICE_PRINTER OK
opsi.HARDWARE_DEVICE_PROCESSOR OK
opsi.HARDWARE_DEVICE_SCSI_CONTROLLER OK
opsi.HARDWARE_DEVICE_SYSTEM_SLOT OK
opsi.HARDWARE_DEVICE_TAPE_DRIVE OK
opsi.HARDWARE_DEVICE_USB_CONTROLLER OK
opsi.HARDWARE_DEVICE_USB_DEVICE OK
opsi.HARDWARE_DEVICE_VIDEO_CONTROLLER OK
opsi.HOST
Error : Unknown table engine 'InnoDB'
error : Corrupt
opsi.LICENSE_CONTRACT
Error : Unknown table engine 'InnoDB'
error : Corrupt
opsi.LICENSE_ON_CLIENT
Error : Unknown table engine 'InnoDB'
error : Corrupt
opsi.LICENSE_POOL
Error : Unknown table engine 'InnoDB'
error : Corrupt
opsi.OBJECT_TO_GROUP
Error : Unknown table engine 'InnoDB'
error : Corrupt
opsi.PRODUCT
Error : Unknown table engine 'InnoDB'
error : Corrupt
opsi.PRODUCT_DEPENDENCY
Error : Unknown table engine 'InnoDB'
error : Corrupt
opsi.PRODUCT_ID_TO_LICENSE_POOL
Error : Unknown table engine 'InnoDB'
error : Corrupt
opsi.PRODUCT_ON_CLIENT
Error : Unknown table engine 'InnoDB'
error : Corrupt
opsi.PRODUCT_ON_DEPOT
Error : Unknown table engine 'InnoDB'
error : Corrupt
opsi.PRODUCT_PROPERTY
Error : Unknown table engine 'InnoDB'
error : Corrupt
opsi.PRODUCT_PROPERTY_STATE
Error : Unknown table engine 'InnoDB'
error : Corrupt
opsi.PRODUCT_PROPERTY_VALUE
Error : Unknown table engine 'InnoDB'
error : Corrupt
opsi.SOFTWARE OK
opsi.SOFTWARE_CONFIG OK
opsi.SOFTWARE_LICENSE
Error : Unknown table engine 'InnoDB'
error : Corrupt
opsi.SOFTWARE_LICENSE_TO_LICENSE_POOL
Error : Unknown table engine 'InnoDB'
error : Corrupt
opsi.WINDOWS_SOFTWARE_ID_TO_PRODUCT
Error : Unknown table engine 'InnoDB'
error : Corrupt
phpmyadmin.pma_bookmark OK
phpmyadmin.pma_column_info OK
phpmyadmin.pma_designer_coords OK
phpmyadmin.pma_history OK
phpmyadmin.pma_pdf_pages OK
phpmyadmin.pma_relation OK
phpmyadmin.pma_table_coords OK
phpmyadmin.pma_table_info OK
phpmyadmin.pma_tracking OK
root@opsi-nl-dev:~# service mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
root@opsi-nl-dev:~#

[dkoch]

Looks like mysql i running now. Is it ?

[loggenk]

You're right!

So it seems its the innodb errors now!

[dkoch]

Try

Code: Alles auswählen

mysqlrepair -A --auto-repair -p

You might have broken memory or a broken harddisk. You should check this. Corruption is not usual. Even with mysql.

If that does not help delete the innodb logs:

Code: Alles auswählen

service mysql stop
cd /var/lib/mysql/
mkdir backup
mv /var/lib/mysql/ib_logfile* backup/
service mysql start

Restart mysql. It might be able to recover the innodb then.

[loggenk]

Great, mysql is running okay now.

Now I still have the initial json decode error

[loggenk]

Hi,

I had a recent backup. Restored it, now its running again without problems.

Thanks for the replies.

Greetings,

Kees......