akvo / akvo-lumen

Make sense of your data

https://akvo.org/akvo-lumen

GNU Affero General Public License v3.0

63 stars 18 forks source link

Failed to transform: ERROR: temporary file size exceeds temp_file_limit #3158

Closed tangrammer closed 1 year ago

tangrammer commented 3 years ago

Context

we are facing here a current DB limit error here "Error: “temporary file size exceeds temp_file_limit”" ... seems related with the amount of data-groups/tables that this dataset contains: 30, and that every visualisation needs to join to make the necessary view to aggregate

Problem or idea

What is the cause?

Solution or next step

How could we solve it?

tangrammer commented 2 years ago

adding https://github.com/akvo/akvo-lumen/commit/de5a9e1fd7b61b0179df184bd1a09910c7f559df to temp fix the problem. Better approach should be to include in the postgres view only the data-groups related. This is a more advanced dynamic solution that will require proper approach/design/feature-flag?

stale[bot] commented 1 year ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.