Hi,
Does anybody encounter this kind of error in PURCHASE ORDER? We tried to remove or update the item but it giving us the error:
pymysql.err.InternalError:(144,“Table’./1bd3e0294da19198/__global_search’ is marked as crashed and last (automatic?) repair failed”)
ERPNext v12.24.0
@Renshed_O , Please try below command.
cd /var/lib/mysql
mysqlcheck -uroot -p --repair --all-databases
For Single Table
REPAIR TABLE `<table name>`;
Hi Suresh,
When i execute the command mysqlcheck, i got this error:
1bd3e0294da19198.tabVolunteer Skill
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabVolunteer Type
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWarehouse
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWarehouse Type
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWarranty Card Issued
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWarranty Claim
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWater Analysis
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWater Analysis Criteria
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWeather
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWeather Parameter
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWeb Form
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWeb Form Field
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWeb Page
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWebhook
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWebhook Data
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWebhook Header
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWebsite Attribute
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWebsite Filter Field
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWebsite Item Group
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWebsite Meta Tag
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWebsite Route Meta
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWebsite Route Redirect
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWebsite Sidebar
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWebsite Sidebar Item
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWebsite Slideshow
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWebsite Slideshow Item
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWebsite Theme
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWork Order
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWork Order Item
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWork Order Operation
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWorkflow
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWorkflow Action
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWorkflow Action Master
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWorkflow Document State
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWorkflow State
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWorkflow Transition
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWorkstation
note : The storage engine for the table doesn’t support repair
1bd3e0294da19198.tabWorkstation Working Hour
note : The storage engine for the table doesn’t support repair
mysql.column_stats OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.gtid_slave_pos
note : The storage engine for the table doesn’t support repair
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.index_stats OK
mysql.innodb_index_stats
note : The storage engine for the table doesn’t support repair
mysql.innodb_table_stats
note : The storage engine for the table doesn’t support repair
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.roles_mapping OK
mysql.servers OK
mysql.table_stats 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
The InnoDB storage engine is quite stable; thus, repairs are rarely needed.
it can be resolved by restarting mysql services. For more info Source Link
sudo systemctl restart mysql.service
Thanks