Analytics error

Support - Assistance technique
1

Greeting team

I am trying to run analytics but I get the following error.

org.postgresql.util.PSQLException: ERROR: could not extend file “base/28039/3075745”: wrote only 4096 of 8192 bytes at block 472 Hint: Check free disk space.

I have cleared some log files and the server has space, but I am still getting the error.

Could you please assist

Regards

2

Hi Ngoni,
From the error message, you still do not have enough disk space.

Analytics uses a large amount of disk space during regeneration because it effectively creates a copy of of the analytics tables. These tables can get very large, so its important to be sure you have enough disk space.

You can get a good estimate of your disk usage using one of the queries listed here https://wiki.postgresql.org/wiki/Disk_Usage.

In my case, the output looks like this:

dhis2-# LIMIT 20;

name | owner | size

···

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

3

Thanks a lot Jason

I will try all the options

Regards

···

Hi Ngoni,

From the error message, you still do not have enough disk space.

Analytics uses a large amount of disk space during regeneration because it effectively creates a copy of of the analytics tables. These tables can get very large, so its important to be sure you have enough disk space.

You can get a good estimate of your disk usage using one of the queries listed here https://wiki.postgresql.org/wiki/Disk_Usage.

In my case, the output looks like this:

dhis2-# LIMIT 20;

name | owner | size

-----------±---------±--------

training | postgres | 73 GB

Usually, the analytics tables occupies a large part of the disk space, so I generally would want to be sure I have at least 150 GB free disk space before I attempt to do a full run of analytics.

The simplest way to solve this problem is just to ensure you have enough disk space, but if that is not an option you can

  1. Drop all analytics tables prior to a full regeneration.

  2. Perform a partial analytics regeneration (like the last two years) and see if that works.

Best regards,

Jason

On Mon, Aug 6, 2018 at 10:57 AM Ngoni Manika nmanika@hotmail.com wrote:

Greeting team

I am trying to run analytics but I get the following error.

org.postgresql.util.PSQLException: ERROR: could not extend file “base/28039/3075745”: wrote only 4096 of 8192 bytes at block 472 Hint: Check free disk space.

I have cleared some log files and the server has space, but I am still getting the error.

Could you please assist

Regards

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–

Jason P. Pickering

email: jason.p.pickering@gmail.com

tel:+46764147049