django-daiquiri / daiquiri

A framework for the publication of scientific databases
https://escience.aip.de/daiquiri
Apache License 2.0
26 stars 8 forks source link

BUG: Empty download files #103

Open andonij opened 2 years ago

andonij commented 2 years ago

After upgrading the daiquiri version, query downloads are generated with no data. This apparently only happens for some of the old users (created before upgrading daiquiri). Newly created users seem to work correctly.

The query is correctly executed, but when downloading the result (csv, fits) only the header (column names) is generated. No errors are shown in the log files.

For some reason if the username is changed (to a different one, ex. john -> john1) on the database, and the query is repeated, the download will work with no issue.

agy-why commented 1 year ago

Dear @andonij thank you for this feed back!

This is new to me. Can you confirm that this is still the case with the new release? It could be that the exporter are broken in some exotic cases. We found an issue this week, so it is not excluded that we still miss something.

please let me know,

Yori

andonij commented 1 year ago

Installed the current master branch (as of 10/03/2023) but that didn't solve the problem.

Creating a new from scratch database from scratch for the app and migrating the data solved the issue.

I have no clue what the problems was, but it seems that it had to do with something corrupted on the app database. I previously hard copied the database to another system with a newer daiquiri version so its possible something broke in the database then.

So I guess it has nothing to do with daiquiri.