Hi Rajendra, We are using VID version 8 and other components including mariadb with version 7. When we set this flag "lower_case_table_names=1" in mariadb version 7, all the tables are created in upper case. Now the other pods like SO referring to lower case tablename fails to recognize the tables with upper case.
I believe some components being version 7 and other being version 8 will not work. Please let us know if any alternative solution for this issue. Regards, Bhagyalakshmi .R On Fri, Apr 30, 2021 at 7:13 PM Vishal Sharma <[email protected]> wrote: > Hi Rajendra, > > Thanks for the update, we are looking into it now. In master branch this > lower case value is coming while not present in Guilin release. > > Will update you shortly after the changes are made. > > BR// > Vishal Sharma > > > > > > On Fri, 30 Apr 2021, 18:12 Rajendra P Mishra (RP), < > [email protected]> wrote: > >> Hi Vishal, >> I used to face a similar issue in VID when moving it to common DB. >> >> "Table '*vid_openecomp_epsdk.VID_JOB' doesn't exist"* >> >> The above error is due to VID expecting "case-insensitiveness" in the DB. >> More info here ( >> https://mariadb.com/docs/reference/mdb/system-variables/lower_case_table_names/ >> ) >> >> As a part of the change, I moved mariadb to use "lower_case_table_names=1" >> in the mariadb-galera/values.yaml >> <https://gerrit.onap.org/r/c/oom/+/113597/15/kubernetes/common/mariadb-galera/values.yaml> >> >> This option can be set only at init time of the DB and not at runtime. >> >> Can you check if this is set in your DB instance running. Without it VID >> will not work. >> >> The above link has details on how to check it in a running DB (by logging >> into one of the DB instance pod) >> >> In case it is not set, then you need to set it to "1" and re-deploy ONAP. >> >> thanks, >> -RP >> >> >> >> >> >> >> >> >> On Fri, Apr 30, 2021 at 1:48 PM <[email protected]> wrote: >> >>> >>> >>> We are facing issue when deploying VID component in Guilin release also >>> from Master branch but facing issues, due to this we are totally stuck to >>> run vFW demo. Below the background given: >>> >>> >>> >>> *Background*: We are setting up the ONAP components (from the Guilin >>> release) on the OKD cluster and able to setup all the components except VID. >>> >>> We tried with various VID releases, but none of them is working for one >>> or another reason. >>> >>> >>> >>> *Option1*: Tried to setup the VID from the Guilin release 7.0.0, but >>> the vid pod is crashing with below error. >>> >>> >>> >>> >>> >>> >>> *Localizing the VID quartz configurationERROR: Could not process >>> template file >>> /usr/local/tomcat/webapps/vid/WEB-INF/conf/quartz_template.properties into >>> /usr/local/tomcat/webapps/vid/WEB-INF/conf/quartz.propertiessed: -e >>> expression #5, char 27: unknown option to `s'[t974240@chdcovh01 >>> /appl/codebase/testrepo/oom/kubernetes]$* >>> >>> >>> >>> *Option2*: Installed VID from the master branch. Though, Pods are up >>> and running but seeing DB errors in the vid pod logs and VID UI is not >>> coming up due to these errors (Details are available in the ticket). >>> >>> >>> >>> Raised ticket https://jira.onap.org/browse/VID-983 >>> <https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fjira.onap.org%2Fbrowse%2FVID-983&data=04%7C01%7CVishal.Sharma%40spark.co.nz%7Cc90b499a86ab427ea8d208d90b16b75f%7Cf6b3cec6a8624a409ab400d6e11e6f0f%7C0%7C0%7C637553014520805602%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=r0vpc9o8ejI%2FvcOfUJtiAmekbQsuoxib37M0ffjMETE%3D&reserved=0> >>> but not getting any response. >>> >>> >>> >>> >> >> -- >> >> *CRN Top 10 Coolest Edge Computing Startups of 2020 >> <https://www.crn.com/slide-shows/networking/the-10-coolest-edge-computing-startups-of-2020/2>* >> > > > -=-=-=-=-=-=-=-=-=-=-=- Links: You receive all messages sent to this group. View/Reply Online (#23188): https://lists.onap.org/g/onap-discuss/message/23188 Mute This Topic: https://lists.onap.org/mt/82476408/21656 Mute #vid:https://lists.onap.org/g/onap-discuss/mutehashtag/vid Group Owner: [email protected] Unsubscribe: https://lists.onap.org/g/onap-discuss/unsub [[email protected]] -=-=-=-=-=-=-=-=-=-=-=-
