Hi
We have a user (logging with Google accounts) that is having trouble with empty lists after out newest release. In the past, modifying the lists to NOT_CURRENT would trigger the update, but this time the trick is not working. Any other ideas on how can we solve the problem? We have a test user that seems fine, lists contain items after the update and they work fine too. Our production server is dedicated, and we build on another box, dump and load and just re-release the web app when there’s an updated. Any help appreciated Thanks Paulo _______________________________________________ dev mailing list [hidden email] https://lists.intermine.org/mailman/listinfo/dev |
Hello Paulo,
Look in the intermine_metadata table. Before you deploy the webapp, check that the values for the key 'serialNumber' are different in the mine and the userprofile db's. It's just a random string that is generated when the dbs are built. If these have different values, then global lists are recalculated when the web app starts and private lists are recalculated when a user logs in. The status setting is not enough to trigger regenerating the lists. You'll need to update the metadata table to make one different. Joe On 1/17/19 5:46 AM, Paulo Nuin wrote: > Hi > > We have a user (logging with Google accounts) that is having trouble with empty lists after out newest release. In the past, modifying the lists to NOT_CURRENT would trigger the update, but this time the trick is not working. Any other ideas on how can we solve the problem? We have a test user that seems fine, lists contain items after the update and they work fine too. > > Our production server is dedicated, and we build on another box, dump and load and just re-release the web app when there’s an updated. > > Any help appreciated > > Thanks > > Paulo > _______________________________________________ > dev mailing list > [hidden email] > https://lists.intermine.org/mailman/listinfo/dev dev mailing list [hidden email] https://lists.intermine.org/mailman/listinfo/dev |
Hi Joe
Thanks a lot. Looking at both, I see the same value serialNumber | 7724142468272166890 key | serialNumber value | 7724142468272166890 blob_value | I will change one and test. Thanks again Paulo > On Jan 17, 2019, at 9:29 AM, Joe Carlson <[hidden email]> wrote: > > Hello Paulo, > > Look in the intermine_metadata table. Before you deploy the webapp, check that the values for the key 'serialNumber' are different in the mine and the userprofile db's. It's just a random string that is generated when the dbs are built. > > If these have different values, then global lists are recalculated when the web app starts and private lists are recalculated when a user logs in. The status setting is not enough to trigger regenerating the lists. You'll need to update the metadata table to make one different. > > Joe > > On 1/17/19 5:46 AM, Paulo Nuin wrote: >> Hi >> >> We have a user (logging with Google accounts) that is having trouble with empty lists after out newest release. In the past, modifying the lists to NOT_CURRENT would trigger the update, but this time the trick is not working. Any other ideas on how can we solve the problem? We have a test user that seems fine, lists contain items after the update and they work fine too. >> >> Our production server is dedicated, and we build on another box, dump and load and just re-release the web app when there’s an updated. >> >> Any help appreciated >> >> Thanks >> >> Paulo >> _______________________________________________ >> dev mailing list >> [hidden email] >> https://lists.intermine.org/mailman/listinfo/dev _______________________________________________ dev mailing list [hidden email] https://lists.intermine.org/mailman/listinfo/dev |
Hi
I did change one of the serial numbers, from profile DB, and tested with our test user and actually saw the lists being upgraded. But the user is still complaining his lists are empty. Anything else I could do? Also, what would be the preferred way to change serial numbers? Thanks Paulo > On Jan 17, 2019, at 12:35 PM, Paulo Nuin <[hidden email]> wrote: > > Hi Joe > > Thanks a lot. Looking at both, I see the same value > > serialNumber | 7724142468272166890 > > key | serialNumber > value | 7724142468272166890 > blob_value | > > I will change one and test. > > Thanks again > > Paulo > > > > > > >> On Jan 17, 2019, at 9:29 AM, Joe Carlson <[hidden email]> wrote: >> >> Hello Paulo, >> >> Look in the intermine_metadata table. Before you deploy the webapp, check that the values for the key 'serialNumber' are different in the mine and the userprofile db's. It's just a random string that is generated when the dbs are built. >> >> If these have different values, then global lists are recalculated when the web app starts and private lists are recalculated when a user logs in. The status setting is not enough to trigger regenerating the lists. You'll need to update the metadata table to make one different. >> >> Joe >> >> On 1/17/19 5:46 AM, Paulo Nuin wrote: >>> Hi >>> >>> We have a user (logging with Google accounts) that is having trouble with empty lists after out newest release. In the past, modifying the lists to NOT_CURRENT would trigger the update, but this time the trick is not working. Any other ideas on how can we solve the problem? We have a test user that seems fine, lists contain items after the update and they work fine too. >>> >>> Our production server is dedicated, and we build on another box, dump and load and just re-release the web app when there’s an updated. >>> >>> Any help appreciated >>> >>> Thanks >>> >>> Paulo >>> _______________________________________________ >>> dev mailing list >>> [hidden email] >>> https://lists.intermine.org/mailman/listinfo/dev > _______________________________________________ dev mailing list [hidden email] https://lists.intermine.org/mailman/listinfo/dev |
On 1/20/19 7:50 PM, Paulo Nuin wrote: > Hi > > I did change one of the serial numbers, from profile DB, and tested with our test user and actually saw the lists being upgraded. But the user is still complaining his lists are empty. Anything else I could do? The intermine folks might have a better description of the list upgrade process, but my understanding of it is that the process is designed for case when a new mine is built. The step of making a new mine database generates a new random number for the serialNumber in the database. When the web app starts up, the serial numbers in the mine and userprofile databases are compared. If they are different, then the web app marks the lists as NOT_CURRENT and lists are upgraded on demand: public lists are upgraded right away and private lists upgraded as the users log in. You circumvented the process by manually setting the status to NOT_CURRENT. I honestly don't know what happens to the list upgrade processing when this happens. The thing to check is the osbid (objectstore bag id) in the userprofile database. Then look for values in the osbag_int table in the mine database with this value of the bag id. That should be your saved list. > > Also, what would be the preferred way to change serial numbers? In normal operation, you should not have to. A new mine will have a different value. If the cases I really needed to, I just appended a digit to the serial number with a manual SQL update. Joe > > Thanks > > Paulo > > > >> On Jan 17, 2019, at 12:35 PM, Paulo Nuin <[hidden email]> wrote: >> >> Hi Joe >> >> Thanks a lot. Looking at both, I see the same value >> >> serialNumber | 7724142468272166890 >> >> key | serialNumber >> value | 7724142468272166890 >> blob_value | >> >> I will change one and test. >> >> Thanks again >> >> Paulo >> >> >> >> >> >> >>> On Jan 17, 2019, at 9:29 AM, Joe Carlson <[hidden email]> wrote: >>> >>> Hello Paulo, >>> >>> Look in the intermine_metadata table. Before you deploy the webapp, check that the values for the key 'serialNumber' are different in the mine and the userprofile db's. It's just a random string that is generated when the dbs are built. >>> >>> If these have different values, then global lists are recalculated when the web app starts and private lists are recalculated when a user logs in. The status setting is not enough to trigger regenerating the lists. You'll need to update the metadata table to make one different. >>> >>> Joe >>> >>> On 1/17/19 5:46 AM, Paulo Nuin wrote: >>>> Hi >>>> >>>> We have a user (logging with Google accounts) that is having trouble with empty lists after out newest release. In the past, modifying the lists to NOT_CURRENT would trigger the update, but this time the trick is not working. Any other ideas on how can we solve the problem? We have a test user that seems fine, lists contain items after the update and they work fine too. >>>> >>>> Our production server is dedicated, and we build on another box, dump and load and just re-release the web app when there’s an updated. >>>> >>>> Any help appreciated >>>> >>>> Thanks >>>> >>>> Paulo >>>> _______________________________________________ >>>> dev mailing list >>>> [hidden email] >>>> https://lists.intermine.org/mailman/listinfo/dev > _______________________________________________ > dev mailing list > [hidden email] > https://lists.intermine.org/mailman/listinfo/dev dev mailing list [hidden email] https://lists.intermine.org/mailman/listinfo/dev |
Free forum by Nabble | Edit this page |