While running analytics, error occurs No space left on device

Implementation - Implémentation
,
1

Our system has 750 GB assigned for Postgres, and while running the data analytics of system, the following error occured : No space left on device Hint: Check free disk space.

The complete log message of analytics is as follows :

2023-09-23 16:15:19 Analytics table update process started
2023-09-23 16:15:19 Validating Analytics Table DATA_VALUE
2023-09-23 16:23:50 Performing pre-create table work
2023-09-23 16:23:50 Dropping temp tables (if any) DATA_VALUE
2023-09-23 16:23:59 Creating analytics tables DATA_VALUE
2023-09-23 16:24:00 Populating analytics tables DATA_VALUE
2023-09-23 17:07:25 Invoking analytics table hooks DATA_VALUE
2023-09-23 17:07:26 Applying aggregation level 5 DATA_VALUE
2023-09-23 17:08:38 Vacuuming tables DATA_VALUE
2023-09-23 17:09:04 Creating indexes DATA_VALUE
2023-09-23 19:32:51 StatementCallback; SQL [create index in_quarterly_ax_2023_RMK3X on analytics_temp_2023 using btree (quarterly);]; ERROR: could not extend file base/277686/33568382: No space left on device Hint: Check free disk space.; nested exception is org.postgresql.util.PSQLException: ERROR: could not extend file base/277686/33568382: No space left on device Hint: Check free disk space.
2023-09-23 19:32:51 StatementCallback; SQL [create index in_pe_ax_2023_PlnT6 on analytics_temp_2023 using btree (pe);]; ERROR: could not extend file base/277686/33568385: wrote only 4096 of 8192 bytes at block 93925 Hint: Check free disk space.; nested exception is org.postgresql.util.PSQLException: ERROR: could not extend file base/277686/33568385: wrote only 4096 of 8192 bytes at block 93925 Hint: Check free disk space.
2023-09-23 19:32:52 StatementCallback; SQL [create index in_LE67HDu2K9N_ax_2022_qxTm0 on analytics_temp_2022 using btree (LE67HDu2K9N);]; ERROR: could not extend file base/277686/33568384: No space left on device Hint: Check free disk space.; nested exception is org.postgresql.util.PSQLException: ERROR: could not extend file base/277686/33568384: No space left on device Hint: Check free disk space.
2023-09-23 19:32:52 StatementCallback; SQL [create index in_oulevel_ax_2022_oIxmA on analytics_temp_2022 using btree (oulevel);]; ERROR: could not extend file base/277686/33568383: No space left on device Hint: Check free disk space.; nested exception is org.postgresql.util.PSQLException: ERROR: could not extend file base/277686/33568383: No space left on device Hint: Check free disk space.
2023-09-23 19:32:52 StatementCallback; SQL [create index in_hw3uupbT4gU_ax_2022_IVaAV on analytics_temp_2022 using btree (hw3uupbT4gU);]; ERROR: could not write to file base/pgsql_tmp/pgsql_tmp3971.9.sharedfileset/0.0: No space left on device; nested exception is org.postgresql.util.PSQLException: ERROR: could not write to file base/pgsql_tmp/pgsql_tmp3971.9.sharedfileset/0.0: No space left on device
2023-09-23 19:32:52 StatementCallback; SQL [create index in_uidlevel3_ax_2022_xpH5R on analytics_temp_2022 using btree (uidlevel3);]; ERROR: could not write to file base/pgsql_tmp/pgsql_tmp3982.11.sharedfileset/0.0: No space left on device; nested exception is org.postgresql.util.PSQLException: ERROR: could not write to file base/pgsql_tmp/pgsql_tmp3982.11.sharedfileset/0.0: No space left on device
2023-09-23 19:34:11 processing aborted: cancelled parallel processing
2023-09-23 19:34:11 Process failed: java.util.concurrent.CancellationException
2023-09-23 19:34:11 Process failed: java.util.concurrent.CancellationException
2

Hi @ahmed685

Is there a chance to increase disk space? The analytics temp tables are generated when running analytics tables export for the apps to retrieve the latest information. It appears that the amount of data in the instance requires more storage space. I would like to hear your input.

Thanks!

3

How did you sort it out? @ahmed685