Hi All, We fixed the error by creating a composite index on (user_id,billing_run)
On 12/5/07, Ananda Kumar <[EMAIL PROTECTED]> wrote: > > 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 r epair 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 >