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

pull request for hmfs collections #55

Open
JohnCremona opened this issue Aug 21, 2017 · 17 comments
Open

pull request for hmfs collections #55

JohnCremona opened this issue Aug 21, 2017 · 17 comments

Comments

@JohnCremona
Copy link
Member

I'm about to copy hmfs.forms.search and hmfs.forms.search.rand to the cloud. Later hmfs.forms.search.stats will follow (still being created). I'll do these myself. These are fairly small (mongodump bson file is 124M) and already exist on the cloud so this is simple.

After this at some point soon I'll want to copy hmfs.hecke to the cloud -- a new collection not there yet -- which is a bigger item (bson dump is >75G). It will replace hmfs.forms but for a short time we'll need to have both in place.

The only collections which are larger, as measured by their bson dump files, are
modularforms2.vector_on_basis: 132G
modularforms2.ap.chunks: 260G
Lfunctions.Lfunctions: 206G

@JohnCremona
Copy link
Member Author

OK so I just discovered that the update script is unhappy about a collection name not listed in db-collections.txt, which is reasonable, and I can add forms.search.rand to that but I can see that this file is part of the git repository lmfdb-gce so rather than edit my copy (in my home dir on ms) I have cloned the lmfdb-gce repo there and will use that.

Please will someone install emacs on ms?! I don't want to clone this repo on a machine of my own just for this...

@JohnCremona
Copy link
Member Author

...OK, so I had a clone already so I updated the hmfs collections names. I'll make a PR to the lmfdb-gce repository. Meanwhile I did what I said I would for the forms.search (including .rand and .stats which are now in the list), checked all was well and deleted forms.search.old.

@JohnCremona
Copy link
Member Author

Just started copying hmfs.hecke after checking with @edgarcosta that there was enough space (~85G). After the open PR's on lmfdb code are merged it will be possible to delete hmfs.forms. Of course we'll try that out on beta first (and not literally delete it at first).

@JohnCremona
Copy link
Member Author

Finished copying hecke collection.

@JohnCremona
Copy link
Member Author

Question for either @AndrewVSutherland ot @edgarcosta : Can I find out from the cloud when each collection was last updated? I know we talked about keeping a log of runs of the update script, but it would also be nice to be able to get a list of collections on the production database and when they were last updated. (I am not saying that I have forgotten which I have or not updated....honestly)

@JohnCremona
Copy link
Member Author

I suppose that was too good to be true. beta is working fine but when I renamed hmfs.forms to hmfs.forms.bak it wasn't. I renamed it back again and will see what I did wrong.

@AndrewVSutherland
Copy link
Member

@JohnCremona Regarding your question, short of scrolling through the mongo db log-file I don't know of an easy way to determine when a collection was last updated.

@edgarcosta
Copy link
Member

edgarcosta commented Aug 23, 2017 via email

@JohnCremona
Copy link
Member Author

JohnCremona commented Aug 23, 2017 via email

@JohnCremona
Copy link
Member Author

OK so now on beta there is no collection hmfs.forms (it is renamed as hmfs.forms.bak; I did not use forms.old since that notation comes with an expectation that there is another collection without the '.old' suffix). All HMF pages on beta are working normally (please check).
Next step is to push the latest code change to prod; then it will be safe to actually delete the hmfs.forms on prod since hmfs.hecke is already there. I'll do the code push now and check that it's OK on the hour...

@edgarcosta
Copy link
Member

edgarcosta commented Aug 24, 2017 via email

@JohnCremona
Copy link
Member Author

Thanks. I missed 1400 (my time) and any moment now...yes, new code now running on prod.
@edgarcosta I'm sure you can more easily than me rename the hmfs.forms collection on the cloud (prod database), say to hmfs.form.bak? If you do that and the pages all still work then that collection can be deleted.

@edgarcosta
Copy link
Member

edgarcosta commented Aug 24, 2017 via email

@JohnCremona
Copy link
Member Author

Yes it looks good to me (even the L-functions). You can delete forms.bak from the prod database. For a while let's keep it on beta though, though it can be reconstructed from the union (in effect) of forms.search and hecke.

@edgarcosta
Copy link
Member

edgarcosta commented Aug 24, 2017 via email

@JohnCremona
Copy link
Member Author

Thanks. I'll comment on an issue in LMFDB/lmfdb so that others notice (e.g. JV & DY).

@JohnCremona
Copy link
Member Author

I think this issue can be closed but have not checked thoroughly.

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

3 participants