Hi All,
I am getting below error when i am updating a table
ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql_5dc3_0.MYI'; try
to repair it
Its a myisam engine,
mysql> update user_hist t,testprod.user_tory y set
-> t.billing_plan=y.billing_plan, t.referrer_info=y.referrer_info,
t.storefr
-> t.crm_billing_plan=y.crm_billing_plan,
t.wmark_billing_plan=y.wmark_billin
-> t.gallery_billing_plan=y.gallery_billing_plan,
t.tickets_billing_plan=y.ti
-> t.ihost_billing_plan=y.ihost_billing_plan,
t.reports_billing_plan=y.repor
-> t.revise_billing_plan=y.revise_billing_plan,
t.syn_billing_plan=y.syn_bill
an,
-> t.checkout_billing_plan=y.checkout_billing_plan,
t.counters_billing_plan=y
-> t.analyzer_billing_plan=y.analyzer_billing_plan,
t.research_billing_plan=
-> t.hot_billing_plan=y.hot_billing_plan,
t.suppliers_billing_plan=y.supplier
-> t.autos_billing_plan=y.autos_billing_plan,
t.contract_billing_plan=y.contr
-> where t.user_id=y.user_id
-> and t.billing_run=y.billing_run;
commit;
how do i fix it, out /tmp file system has 16GB of space.
regards
anandkl
