Lists: | pgsql-bugs |
---|
From: | "nicoanto" <na(at)mnm-consulting(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows |
Date: | 2008-05-14 14:40:18 |
Message-ID: | 200805141440.m4EEeIrV022444@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4167
Logged by: nicoanto
Email address: na(at)mnm-consulting(dot)com
PostgreSQL version: 8.3.1.0
Operating system: Windows
Description: When generating UUID using UUID-OSSP module, UUIDs are
not unique on Windows
Details:
Hi all,
I am using the 8.3.1 version of PostgreSQL. I wrote a simple function on
order to generate UUID values using the UUID-OSSP module
The code of the function is the following one :
CREATE FUNCTION uuidgen() RETURNS CHAR(36) AS $$
BEGIN
RETURN uuid_generate_v4()::CHAR(36);
END;
$$ LANGUAGE 'plpgsql';
When using it in a loop, I have got 2 different behaviors :
* on an Ubuntu platform, the generated UUID values are unique
* on a Windows platform, the generated UUID values are not unique most of
the time.
Do you have any idea on how to fix that bug on a Windows platform ?
Regards,
Nicoanto
From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Cc: | "nicoanto" <na(at)mnm-consulting(dot)com> |
Subject: | Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows |
Date: | 2008-05-14 15:34:49 |
Message-ID: | 200805141734.51653.peter_e@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
Am Mittwoch, 14. Mai 2008 schrieb nicoanto:
> I am using the 8.3.1 version of PostgreSQL. I wrote a simple function on
> order to generate UUID values using the UUID-OSSP module
> The code of the function is the following one :
>
> CREATE FUNCTION uuidgen() RETURNS CHAR(36) AS $$
> BEGIN
> RETURN uuid_generate_v4()::CHAR(36);
> END;
> $$ LANGUAGE 'plpgsql';
>
>
>
> When using it in a loop, I have got 2 different behaviors :
> * on an Ubuntu platform, the generated UUID values are unique
> * on a Windows platform, the generated UUID values are not unique most of
> the time.
>
> Do you have any idea on how to fix that bug on a Windows platform ?
Congratulations, you have just independently rediscovered the Debian OpenSSL
vulnerability, see http://www.debian.org/security/2008/dsa-1571. Get a new
libssl package from the Ubuntu security repository. It's not a Windows bug;
the numbers are supposed to be different.
From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | pgsql-bugs(at)postgresql(dot)org, nicoanto <na(at)mnm-consulting(dot)com> |
Subject: | Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows |
Date: | 2008-05-14 15:44:42 |
Message-ID: | 20080514154442.GJ5521@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
Peter Eisentraut wrote:
> Am Mittwoch, 14. Mai 2008 schrieb nicoanto:
> > I am using the 8.3.1 version of PostgreSQL. I wrote a simple function on
> > order to generate UUID values using the UUID-OSSP module
> > The code of the function is the following one :
> >
> > CREATE FUNCTION uuidgen() RETURNS CHAR(36) AS $$
> > BEGIN
> > RETURN uuid_generate_v4()::CHAR(36);
> > END;
> > $$ LANGUAGE 'plpgsql';
> >
> >
> >
> > When using it in a loop, I have got 2 different behaviors :
> > * on an Ubuntu platform, the generated UUID values are unique
> > * on a Windows platform, the generated UUID values are not unique most of
> > the time.
> >
> > Do you have any idea on how to fix that bug on a Windows platform ?
>
> Congratulations, you have just independently rediscovered the Debian OpenSSL
> vulnerability, see http://www.debian.org/security/2008/dsa-1571. Get a new
> libssl package from the Ubuntu security repository. It's not a Windows bug;
> the numbers are supposed to be different.
Hmm, surely the problem is unrelated? He gets the same numbers on
_Windows_, whereas Ubuntu shows the good behavior.
Also, OOSP-UUID does not depend on OpenSSL AFAIR.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
From: | "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com> |
---|---|
To: | "Peter Eisentraut" <peter_e(at)gmx(dot)net> |
Cc: | <pgsql-bugs(at)postgresql(dot)org>, "nicoanto" <na(at)mnm-consulting(dot)com> |
Subject: | Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows |
Date: | 2008-05-14 15:45:41 |
Message-ID: | 482B0925.407@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
Peter Eisentraut wrote:
> Am Mittwoch, 14. Mai 2008 schrieb nicoanto:
>> I am using the 8.3.1 version of PostgreSQL. I wrote a simple function on
>> order to generate UUID values using the UUID-OSSP module
>> The code of the function is the following one :
>>
>> CREATE FUNCTION uuidgen() RETURNS CHAR(36) AS $$
>> BEGIN
>> RETURN uuid_generate_v4()::CHAR(36);
>> END;
>> $$ LANGUAGE 'plpgsql';
>>
>>
>>
>> When using it in a loop, I have got 2 different behaviors :
>> * on an Ubuntu platform, the generated UUID values are unique
>> * on a Windows platform, the generated UUID values are not unique most of
>> the time.
>>
>> Do you have any idea on how to fix that bug on a Windows platform ?
>
> Congratulations, you have just independently rediscovered the Debian OpenSSL
> vulnerability, see http://www.debian.org/security/2008/dsa-1571. Get a new
> libssl package from the Ubuntu security repository. It's not a Windows bug;
> the numbers are supposed to be different.
I doubt that. There's no dependency from uuid library to openssl. And if
that was related, I would've expected to see non-unique values on
Ubuntu, not Windows.
Seems rather like a weakness in the Windows port of the ossp-uuid
library to me.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, nicoanto <na(at)mnm-consulting(dot)com> |
Subject: | Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows |
Date: | 2008-05-14 15:57:43 |
Message-ID: | 200805141757.44153.peter_e@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
Am Mittwoch, 14. Mai 2008 schrieb Alvaro Herrera:
> Hmm, surely the problem is unrelated? He gets the same numbers on
> _Windows_, whereas Ubuntu shows the good behavior.
Oh, I read it backwards. So then the random number generator on Windows is
the problem in this case.
> Also, OOSP-UUID does not depend on OpenSSL AFAIR.
Written by the same guy anyway. :-/
From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | pgsql-bugs(at)postgresql(dot)org, nicoanto <na(at)mnm-consulting(dot)com> |
Subject: | Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows |
Date: | 2008-05-14 16:10:20 |
Message-ID: | 20080514161020.GA9838@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
Peter Eisentraut wrote:
> Am Mittwoch, 14. Mai 2008 schrieb Alvaro Herrera:
> > Hmm, surely the problem is unrelated? He gets the same numbers on
> > _Windows_, whereas Ubuntu shows the good behavior.
>
> Oh, I read it backwards. So then the random number generator on Windows is
> the problem in this case.
Right.
Actually what I would suggest is using the Windows API for generating
UUIDs instead of OOSP-UUID.
> > Also, OOSP-UUID does not depend on OpenSSL AFAIR.
>
> Written by the same guy anyway. :-/
Oh, right ...
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | pgsql-bugs(at)postgresql(dot)org, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, nicoanto <na(at)mnm-consulting(dot)com> |
Subject: | Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows |
Date: | 2008-05-14 16:14:20 |
Message-ID: | 20735.1210781660@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Am Mittwoch, 14. Mai 2008 schrieb Alvaro Herrera:
>> Hmm, surely the problem is unrelated? He gets the same numbers on
>> _Windows_, whereas Ubuntu shows the good behavior.
> Oh, I read it backwards. So then the random number generator on Windows is
> the problem in this case.
>> Also, OOSP-UUID does not depend on OpenSSL AFAIR.
> Written by the same guy anyway. :-/
Well, in any case this is surely a bug in the Windows port of
libossp-uuid, and so needs to be reported to them not us.
regards, tom lane
From: | "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp> |
---|---|
To: | "Peter Eisentraut" <peter_e(at)gmx(dot)net>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-bugs(at)postgresql(dot)org>, "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "nicoanto" <na(at)mnm-consulting(dot)com> |
Subject: | Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows |
Date: | 2008-05-15 03:35:49 |
Message-ID: | 039e01c8b63c$d0c95e90$60096cdb@IBMC9A0F63B40D |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
Hi
Ahhh, This problem is reproduced. :-(
Sorry, I neglect it. Then, the following is considered as management.
http://winpg.jp/~saito/pg_work/OSSP_win32/getrand.c
I will consult to Ralf-san tonight. or weekend...
Regards,
Hiroshi Saito
----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
>> Am Mittwoch, 14. Mai 2008 schrieb Alvaro Herrera:
>>> Hmm, surely the problem is unrelated? He gets the same numbers on
>>> _Windows_, whereas Ubuntu shows the good behavior.
>
>> Oh, I read it backwards. So then the random number generator on Windows is
>> the problem in this case.
>
>>> Also, OOSP-UUID does not depend on OpenSSL AFAIR.
>
>> Written by the same guy anyway. :-/
>
> Well, in any case this is surely a bug in the Windows port of
> libossp-uuid, and so needs to be reported to them not us.
>
> regards, tom lane
From: | Nicolas ANTONINI <nicolas(dot)antonini(at)mnm-consulting(dot)com> |
---|---|
To: | Hiroshi Saito <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp> |
Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, nicoanto <na(at)mnm-consulting(dot)com> |
Subject: | Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows |
Date: | 2008-07-03 13:03:48 |
Message-ID: | 486CCE34.1020902@mnm-consulting.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
Any news about a fix for this bug ?
Regards,
Nicolas ANTONINI
Hiroshi Saito a écrit :
> Hi
>
> Ahhh, This problem is reproduced. :-(
> Sorry, I neglect it. Then, the following is considered as management.
> http://winpg.jp/~saito/pg_work/OSSP_win32/getrand.c
> I will consult to Ralf-san tonight. or weekend...
>
> Regards,
> Hiroshi Saito
>
> ----- Original Message ----- From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>
>
>> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
>>> Am Mittwoch, 14. Mai 2008 schrieb Alvaro Herrera:
>>>> Hmm, surely the problem is unrelated? He gets the same numbers on
>>>> _Windows_, whereas Ubuntu shows the good behavior.
>>
>>> Oh, I read it backwards. So then the random number generator on
>>> Windows is the problem in this case.
>>
>>>> Also, OOSP-UUID does not depend on OpenSSL AFAIR.
>>
>>> Written by the same guy anyway. :-/
>>
>> Well, in any case this is surely a bug in the Windows port of
>> libossp-uuid, and so needs to be reported to them not us.
>>
>> regards, tom lane
>
>
--
Nicolas ANTONINI
Directeur Technique
MNM Consulting
98, rue de Sèvres
75007 PARIS
T : + 33 (0)3 85 55 36 64
P : + 33 (0)6 23 71 85 24
From: | "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp> |
---|---|
To: | "Nicolas ANTONINI" <nicolas(dot)antonini(at)mnm-consulting(dot)com> |
Cc: | "Peter Eisentraut" <peter_e(at)gmx(dot)net>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-bugs(at)postgresql(dot)org>, "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "nicoanto" <na(at)mnm-consulting(dot)com> |
Subject: | Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows |
Date: | 2008-07-03 17:26:14 |
Message-ID: | 014601c8dd31$e526a430$0b01a8c0@IBMC9A0F63B40D |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
Hi.
Sorry, late reaction....Now, private time has only a few.
I will investigate at a weekend again.
Regards,
Hiroshi Saito
----- Original Message -----
From: "Nicolas ANTONINI" <nicolas(dot)antonini(at)mnm-consulting(dot)com>
> Any news about a fix for this bug ?
>
> Regards,
>
> Nicolas ANTONINI
>
> Hiroshi Saito a écrit :
>> Hi
>>
>> Ahhh, This problem is reproduced. :-(
>> Sorry, I neglect it. Then, the following is considered as management.
>> http://winpg.jp/~saito/pg_work/OSSP_win32/getrand.c
>> I will consult to Ralf-san tonight. or weekend...
>>
>> Regards,
>> Hiroshi Saito
>>
>> ----- Original Message ----- From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>>
>>
>>> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
>>>> Am Mittwoch, 14. Mai 2008 schrieb Alvaro Herrera:
>>>>> Hmm, surely the problem is unrelated? He gets the same numbers on
>>>>> _Windows_, whereas Ubuntu shows the good behavior.
>>>
>>>> Oh, I read it backwards. So then the random number generator on Windows is the problem
>>>> in this case.
>>>
>>>>> Also, OOSP-UUID does not depend on OpenSSL AFAIR.
>>>
>>>> Written by the same guy anyway. :-/
>>>
>>> Well, in any case this is surely a bug in the Windows port of
>>> libossp-uuid, and so needs to be reported to them not us.
>>>
>>> regards, tom lane
>>
>>
>
>
> --
> Nicolas ANTONINI
> Directeur Technique
> MNM Consulting
> 98, rue de Sèvres
> 75007 PARIS
> T : + 33 (0)3 85 55 36 64
> P : + 33 (0)6 23 71 85 24
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs