cancel
Showing results for 
Search instead for 
Did you mean: 

index_event table has been truncated

SOLVED

index_event table has been truncated

We had an incident with our clients Magnto 1.9 shop this friday.

Somehow product index failed and products vanished from the shop.

My question is ... how is it possible for table index_event to become truncated ... all data missing?

Can Magento empty/truncate this table by itself?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: index_event table has been truncated

I've never come across this table being truncated automatically. It's commonly a table that is truncated manually to clean up database space though by developers/sys admins. 

 

index_events table being empty shouldn't be stopping products from being indexed though. Have you managed to find out any more info on this since you posted?

 

I recommend setting up indexing based on cron (manual update rather than update on save) to cover your bases here. 

----
If you've found one of my answers useful, please give "Kudos" or "Accept as Solution" as appropriate. Thanks!

View solution in original post

1 REPLY 1

Re: index_event table has been truncated

I've never come across this table being truncated automatically. It's commonly a table that is truncated manually to clean up database space though by developers/sys admins. 

 

index_events table being empty shouldn't be stopping products from being indexed though. Have you managed to find out any more info on this since you posted?

 

I recommend setting up indexing based on cron (manual update rather than update on save) to cover your bases here. 

----
If you've found one of my answers useful, please give "Kudos" or "Accept as Solution" as appropriate. Thanks!