Seite 2 von 2
Re: json error (could not decode)
Verfasst: 16 Mär 2015, 10:24
von dkoch
Try the basic things. Is Mysql running ? Can you connect to the database using the 'mysql' command? Maybe its corrupted.
Re: json error (could not decode)
Verfasst: 16 Mär 2015, 10:49
von 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?
Re: json error (could not decode)
Verfasst: 16 Mär 2015, 11:00
von dkoch
Actually that is nothing to be solved. But give me the output of:
Re: json error (could not decode)
Verfasst: 16 Mär 2015, 11:03
von 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:~#
Re: json error (could not decode)
Verfasst: 16 Mär 2015, 11:04
von dkoch
Looks like mysql i running now. Is it ?
Re: json error (could not decode)
Verfasst: 16 Mär 2015, 11:06
von loggenk
You're right!
So it seems its the innodb errors now!
Re: json error (could not decode)
Verfasst: 16 Mär 2015, 11:08
von dkoch
Try
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.
Re: json error (could not decode)
Verfasst: 16 Mär 2015, 11:55
von loggenk
Great, mysql is running okay now.
Now I still have the initial json decode error
Re: json error (could not decode) (SOLVED)
Verfasst: 17 Mär 2015, 10:08
von loggenk
Hi,
I had a recent backup. Restored it, now its running again without problems.
Thanks for the replies.
Greetings,
Kees......