Re: pgAdmin4: Random failure of FTS test cases due to improper random string creation

From: Dave Page <dave(dot)page(at)enterprisedb(dot)com>
To: Navnath Gadakh <navnath(dot)gadakh(at)enterprisedb(dot)com>
Cc: Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>, pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>, Kanchan Mohitey <kanchan(dot)mohitey(at)enterprisedb(dot)com>
Subject: Re: pgAdmin4: Random failure of FTS test cases due to improper random string creation
Date: 2017-08-25 08:33:00
Message-ID: CA+OCxoxmKRy1izeNTefNK5v9Km7BWj1RHMuX0dEXf6+=W_qwRg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Thanks, patch applied.

On Fri, Aug 25, 2017 at 6:47 AM, Navnath Gadakh <
navnath(dot)gadakh(at)enterprisedb(dot)com> wrote:

> Hi Dave,
>
> Please find the attached patch. The code added to tear down the FTS
> related objects. As this issue was random, I have tested this patch on all
> 12 servers (pg/ppas) with multiple time and got no errors.
>
> Thanks.
>
>
> On Fri, Aug 18, 2017 at 1:35 PM, Dave Page <dave(dot)page(at)enterprisedb(dot)com>
> wrote:
>
>>
>>
>> On Fri, Aug 18, 2017 at 4:54 AM, Ashesh Vashi <
>> ashesh(dot)vashi(at)enterprisedb(dot)com> wrote:
>>
>>> On Fri, Aug 11, 2017 at 1:24 PM, Navnath Gadakh <
>>> navnath(dot)gadakh(at)enterprisedb(dot)com> wrote:
>>>
>>>> Hi Dave,
>>>>
>>>> Please find the attached patch for UUID creation issues with
>>>> test objects for FTS configurations, FTS dictionaries and FTS parsers.
>>>> Previously(refer email with subject "Build failed in Jenkins:
>>>> pgadmin4-master-python27 #279" and "Build failed in Jenkins:
>>>> pgadmin4-master-python33 #207"), test cases were randomly failing due to
>>>> repetitions of the test object names.
>>>>
>>>> In the old code we used some part of the string for creating a UUID
>>>> string, but it seems that at some point that created string gets repeated
>>>> and due to which test cases were failing as this was a random behavior, now
>>>> it is fixed.
>>>>
>>> Navnath,
>>>
>>> We're still not removing the temporary objects, created by test-cases,
>>> in the tear-down function.
>>> We should have removed them in the tear-down function to fix the issue
>>> in proper way.
>>>
>>> Dave - thoughts?
>>>
>>
>> Right - it only seems to be FTS and FDW related objects that suffer from
>> this problem from what I can see, so I assume we're getting it right for
>> everything else by removing objects in the tear-down.
>>
>> --
>> Dave Page
>> VP, Chief Architect, Tools & Installers
>> EnterpriseDB: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>
>
>
> --
> Regards,
> Navnath Gadakh
>
> EnterpriseDB Corporation
> The Enterprise PostgreSQL Company
>
>
>

--
Dave Page
VP, Chief Architect, Tools & Installers
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2017-08-25 08:34:28 Re: Next release
Previous Message Dave Page 2017-08-25 08:32:49 pgAdmin 4 commit: Properly cleanup after running the FTS test cases.