Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

mysql data field too small, data lost? #175

Closed
tfeige91 opened this issue Jun 6, 2023 · 7 comments
Closed

mysql data field too small, data lost? #175

tfeige91 opened this issue Jun 6, 2023 · 7 comments

Comments

@tfeige91
Copy link

tfeige91 commented Jun 6, 2023

Version of Experiment Factory:

Hi Vanessa,
I experienced when using a mysql database for storing experiment data, the data field was formatted as text, which was too small for me so I changed it manually to long-text. However in one test battery I forgot it and the data was truncated. Is there any chance to find this data in some log-files or so?

Thanks for your help!

@vsoch
Copy link
Member

vsoch commented Jun 6, 2023

I don't think so - I'm sorry about your data loss.

@tfeige91
Copy link
Author

tfeige91 commented Jun 6, 2023

Saving failed in that test battery and it would not move to the next test (which I understood just today...). There is no chance it saved csv files somewhere in the container instead, is there?

@vsoch
Copy link
Member

vsoch commented Jun 6, 2023

If you are saving data to a database proper, there shouldn't be any saving of text files. The logs for the container would only have a line that says they are taking / completing an experiment.

@tfeige91
Copy link
Author

tfeige91 commented Jun 6, 2023

Thanks for your help anyways!

@tfeige91 tfeige91 closed this as completed Jun 6, 2023
@tfeige91
Copy link
Author

tfeige91 commented Jun 7, 2023

I got pretty close to securing the data actually: In the expfactory.log the failed queries are being logged but unfortunately they are truncated :) Might there be any other place that might have logged the queries?

@tfeige91 tfeige91 reopened this Jun 7, 2023
@vsoch
Copy link
Member

vsoch commented Jun 7, 2023

@tfeige91 I don't have any new information for you.

@tfeige91
Copy link
Author

tfeige91 commented Jun 7, 2023

All right :)

@tfeige91 tfeige91 closed this as completed Jun 7, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants