Hi.
I am setting up SOGo on my fresh Ubuntu 20.04 server. While going
through the set up I found this in the logs:
—
Dec 05 22:44:28 sogod [60235]: <0x0x558239378840[WOWatchDog]> child
spawned with pid 60248
Dec 05 22:44:28 sogod [60248]: |SOGo| table 'sogo_user_profile'
successfully created!
Dec 05 22:44:28 sogod [60247]: |SOGo| table 'sogo_user_profile' creation
failed! Reason: <PostgreSQL72Exception: 0x5582393d78d0>
NAME:PostgreSQL72FatalError REASON:fatal pgsql error
(channel=<0x0x558239420900[PostgreSQL72Channel]:
connection=<0x0x5582394a8e30[PGConnection]:
connection=0x0x558239466bb0>>): ERROR: duplicate key value violates
unique constraint "pg_type_typname_nsp_index"
DETAIL: Key (typname, typnamespace)=(sogo_user_profile, 2200) already
exists.
Dec 05 22:44:28 sogod [60246]: |SOGo| table 'sogo_user_profile' creation
failed! Reason: <PostgreSQL72Exception: 0x5582393d75c0>
NAME:PostgreSQL72FatalError REASON:fatal pgsql error
(channel=<0x0x558239420900[PostgreSQL72Channel]:
connection=<0x0x5582393aea50[PGConnection]:
connection=0x0x558239466bb0>>): ERROR: duplicate key value violates
unique constraint "pg_type_typname_nsp_index"
DETAIL: Key (typname, typnamespace)=(sogo_user_profile, 2200) already
exists.
—
Googling for it didn’t help much. I found one entry where stoping
sogo, deleting the table in question (here sogo_user_profile) and then
starting sogo again might help. But this only reproduces above entry.
The PostgreSQL logs are not really helpful either:
—
2020-12-05 22:44:28.722 CET [60249] sogo@sogo ERROR: duplicate key
value violates unique constraint "pg_type_typname_nsp_index"
2020-12-05 22:44:28.722 CET [60249] sogo@sogo DETAIL: Key (typname,
typnamespace)=(sogo_user_profile, 2200) already exists.
2020-12-05 22:44:28.722 CET [60249] sogo@sogo STATEMENT: --
-- (C) 2004-2005 SKYRIX Software AG
-- (C) 2006-2007 Inverse inc.
--
CREATE TABLE sogo_user_profile (
c_uid VARCHAR(255) NOT NULL PRIMARY KEY,
c_defaults TEXT,
c_settings TEXT
);
—
Any ideas?
Thanks,
Holger
--
[email protected]
https://inverse.ca/sogo/lists
