HANA Server at AWS: Disk full

[kkoetter]

Dear all,

unfortunately the disk of our HANA server developer edition at AWS ist full...

imdbhdb:~ # df -lh

Filesystem            Size  Used Avail Use% Mounted on

/dev/sda1             9.9G  1.3G  8.1G  14% /

devtmpfs               18G   84K   18G   1% /dev

tmpfs                  18G     0   18G   0% /dev/shm

/dev/md0              119G  113G     0 100% /sap

Has anybody handled this situation before?

What can I do, how can I extend the volume?

Thanks in advance & best regards,

Karsten

[former_member190455 · Accepted solution]

Hi Karsten,

It may not be full. Maybe it needs to be defragmented.
I am not sure if you can/should extend volumes on dev editions from AWS.

I once saw this command being used by someone who faced a similar problem and it worked.
http://help.sap.com/hana/html/sql_alter_system_reclaim_datavolume.html

I am not sure if it will work, but if your HANA Studio is still up and running, you can try this.
If your HANA Studio is not running, at least is your instance and HANA DB running? Maybe you can try the command using hdbsql.

Regards

Suneet

P.S. Again, I have not tried any of this, but it might be worth a try.

[kkoetter · Accepted solution]

Dear Suneet,

the database server does not start completely, processes hdbnameserver and hdbdaemon are trying to initialize, there rest is scheduled.

So, your suggestion is therefore unfortunately not an option...

Any other idea?

Thanks & Best regards,

Karsten

[kkoetter · Accepted solution]

Dear All,

opening SQLConsole with Administrator was somehow possible.

After

ALTER SYSTEM RECLAIM LOG

ALTER SYSTEM RECLAIM DATAVOLUME 120 DEFRAGMENT

and then (tataa!):

imdbhdb:~ # df -h

Filesystem            Size  Used Avail Use% Mounted on

/dev/sda1             9.9G  1.3G  8.1G  14% /

devtmpfs               18G   84K   18G   1% /dev

tmpfs                  18G     0   18G   0% /dev/shm

/dev/md0              119G   89G   24G  79% /sap

So 24G of disk space was free'ed up!

Best regards,

Karsten