cannot run "c_parser" on AWS EC2 instance (ubuntu trusty 14.4 amd64)

[yuanl...@gmail.com]

Dear Sir, 

I have followed this URL: 

https://twindb.com/how-to-recover-innodb-dictionary/

to try to recover a table that I accidentally deleted. 

When I came to run this command as root: "./c_parser -4f pages-ibdata1/FIL_PAGE_INDEX/0000000000000001.page -t dictionary/SYS_TABLES.sql > dumps/default/SYS_TABLES 2> dumps/default/SYS_TABLES.sql", the command quickly returned "Killed" and did not run succssfully. 

Because of this, I could'nt continue with the rest of steps. 

Appreciate for your helps!

Alan Wu

[Aleksandr Kuzminsky]

Hi Alan,

This is because c_parser needs 256M+ memory to start. I guess your instance doesn't have that much free memory.
You should add more swap space or launch bigger instance.

[Alan W.]

Hi Alsksandr, 

Thanks for replying to me.

I added a swap file and checked the swap space. Here is the output of command free:

root@ip-10-167-12-12:~/alan/projs/undrop-for-innodb# free

                        total       used         free     shared    buffers     cached

Mem:        544664     538324       6340        228       1028     347108

-/+ buffers/cache:     190188     354476

Swap:       524284          0         524284

After that, I ran the same command and I got the same error/message: "Killed". 

I'll try using a big size instance. 

Thanks!

Alan

[Alan W.]

Hi Alsksandr, 

Using a bigger size instance (6x more memory than my previous one) worked. Thanks a lot for your tip!

Alan