Hi Bhagyalakshmi,
I hope I understood your question correctly.
I just checked, and it looks like VID is not sharing the DB in guilin.
VID uses its own private DB in Guilin. So we should have no issues with
that.
Now if you want to deploy version 8 of VID on Guilin, just change the image
version to 8 and try that.
If you copy the VID helm charts from master to guilin it will fail as
master has shared DB.
As far as "lower_case_table_names" is concerned, it is a DB property and
should not impact VID or SO.
As per the link on mariadb doc (
https://mariadb.com/docs/reference/mdb/system-variables/lower_case_table_names/
)
"The lower_case_table_names system variable determines whether table names,
table aliases, and database names are compared in a case-sensitive manner,
and whether tablespace files are stored on disk in a case-sensitive manner.:
-
When set to 0 (the default on Unix-based systems), table names, table
aliases, and database names are compared in a case-sensitive manner.
-
When set to 1 (the default on Windows), table names and database names
are stored in lowercase and compared in a case-insensitive manner."
As we see above setting it to 1 will make the comparison "case-insensitive"
which means SO or any other utility can pass the name in CAPITAL or small
letters.
So if I understand correctly, there should be no change in behaviour of SO
or VID. Unless of course, SO or other components use two different table/db
names differentiated only by their case (e.g. TABLE1 and table1 are two
different tables).
thanks,
-RP
On Thu, May 6, 2021 at 3:41 PM Bhagyalakshmi R <[email protected]> wrote:
> 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>*
>>>
>>
>>
>>
--
*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 (#23189): https://lists.onap.org/g/onap-discuss/message/23189
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]]
-=-=-=-=-=-=-=-=-=-=-=-
