-
Bug
-
Resolution: Done
-
Medium
-
Casablanca Release
From: FORSYTH, JAMES jf2512@att.com
Sent: Friday, 21 December 2018 13:45
To: PLATANIA, MARCO <platania@research.att.com>; HERNANDEZ-HERRERO, JORGE <jh1730@att.com>; MOKRY, MICHAEL A <mm117s@att.com>; DRAGOSH, PAM <pdragosh@research.att.com>
Cc: KAJUR, HARISH V <vk250x@att.com>; AGGARWAL, MANISHA <amanisha@att.com>; Keong Lim <Keong.Lim@huawei.com>; pavel.paroulek@orange.com; BLIMKIE, STEVEN <steven.blimkie@amdocs.com>; LEE, TIAN <tianl@amdocs.com>
Subject: Re: Guard Testing - SO Request Issue
Hi, Marco,
I reset the database, put the schema in correctly and re-ran the PUT on the named-queries – so performace is better and the named-query is fixed. However – the data you had in there is gone. There is probably a way to recover the data; as far as I can tell the data snapshot util overwrites with what’s in the graphson file which means the schema stuff is lost and there are objects with wrong types in the graphson data (since they were created in a schemaless environment)
I saved the data to /root on the rancher node, so it isn’t lost permanently.
If you can re-add the data via robot somehow that would probably be your fastest option; I can continue to look at it and try to restore the data.
I think we need to make a failure on createDbSchema more visible and stop aai from reporting ready until it exits successfully, I opened a ticket for it https://jira.onap.org/browse/AAI-239
Let me know if you need more work done on this, I’ll try to get Harish to send me some instructions tomorrow (and document them on wiki)
Thanks,
jimmy
From: "FORSYTH, JAMES" <jf2512@att.com>
Date: Thursday, December 20, 2018 at 8:14 PM
To: "PLATANIA, MARCO" <platania@research.att.com>, "HERNANDEZ-HERRERO, JORGE" <jh1730@att.com>, "MOKRY, MICHAEL A" <mm117s@att.com>, "DRAGOSH, PAM" <pdragosh@research.att.com>
Cc: HARISH V KAJUR <vk250x@att.com>, "AGGARWAL, MANISHA" <amanisha@att.com>, "keong.lim@huawei.com" <keong.lim@huawei.com>, "pavel.paroulek@orange.com" <pavel.paroulek@orange.com>, "BLIMKIE, STEVEN" <steven.blimkie@amdocs.com>, "LEE, TIAN" <tianl@amdocs.com>
Subject: Re: Guard Testing - SO Request Issue
Something is really weird in that environment – I’m out for the rest of the year so I won’t be able to do any more troubleshooting (unless it’s urgent)
What I observed is that the property-collect-list on that named-query – even though it is specified in the json that builds the named-query – is not building a list in the graph.
OH – I think the schema didn’t get built properly because of that node failure. And that’s why performance is terrible. Yeah, that’s it.
Let me see if I can fix it.
Thanks,
jimmy