[Fwd: bug ? get_groname: group 0 not found]

Started by Spirouover 26 years ago3 messages
#1Spirou
spirou@carolo.net

I posted this message in pgsql-novice, but got no answer.
I dare forward it to pgsql-hackers, though I fear it could be a misuse
of that list.

Could you post an answer on novice since I've not subscribed to hackers.
(Too high level for me, I think)

Spirou wrote:

I can't find my classes anymore (cf below ...) !

I send you a few SQL commands, you'll understand what I mean :

---------------------------
INSERT INTO pg_group VALUES ('http_user')
CREATE USER "www-data" IN GROUP http_user;
CREATE USER nobody IN GROUP http_user;

mybase=> select * from pg_group;
groname |grosysid|grolist
---------+--------+-------
http_user| |
(1 row)

mybase=> \z
NOTICE: get_groname: group 0 not found
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.

mybase=> select * from pg_class;
NOTICE: get_groname: group 0 not found
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
We have lost the connection to the backend, so further processing is
impossible. Terminating.

----------------------------

Perhaps is it worth to mention I had created a first group,
whose name was 'http' then I deleted this one and created
the new one called 'http_user'.

Is it a bug or a bad use ?
Could you tell what you think of it ?

Thanks

--
Spirou

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Spirou (#1)
Re: [HACKERS] [Fwd: bug ? get_groname: group 0 not found]

Spirou <spirou@carolo.net> writes:

I can't find my classes anymore (cf below ...) !
mybase=> \z
NOTICE: get_groname: group 0 not found
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.

Yup, that's a bug alright. I recall having heard of these symptoms
before --- try searching the pghackers archives for mention of
'get_groname'. I think this may be fixed in the latest release
(what version are you running, anyway?)

regards, tom lane

#3Zeugswetter Andreas IZ5
ZeugswetterA@wien.spardat.at
In reply to: Tom Lane (#2)
AW: [HACKERS] [Fwd: bug ? get_groname: group 0 not found]

I posted this message in pgsql-novice, but got no answer.
I dare forward it to pgsql-hackers, though I fear it could be a misuse
of that list.

I think it is a good question for the hackers list.

Spirou wrote:

I can't find my classes anymore (cf below ...) !

---------------------------
INSERT INTO pg_group VALUES ('http_user')
CREATE USER "www-data" IN GROUP http_user;
CREATE USER nobody IN GROUP http_user;

Last time I used groups successfully I had to create the group as
a unix group, then insert the unix group id into the grosysid column.
Actually any id that shows in /etc/groups is ok, (but imho a bug).
I think it is also a requirement, that the group id is not used as a
user id in pg_shadow.
I am not sure that anyone knows the initially intended architecture.
Please speak up anybody, if you know the intended/wanted design.

Andreas