Re: UUID generation problem

On Mon, October 5, 2020 12:06, Tom Lane wrote:
> "James B. Byrne" <byrnejb(at)harte-lyne(dot)ca> writes:
>> On Mon, October 5, 2020 10:53, Tom Lane wrote:
>>> I continue to suspect that you are somehow
>>> confusing yourself by testing in different databases and/or
>>> with different user accounts.
>
>> Possibly. I do not make any definitive claims at this point. However, the
>> application properties of the DB connection are:
>
>> Connection=xyzCConnection[name\=accounting.harte-lyne.ca
>> {localhost-idempiere-idempiere_dbadmin},
>> AppsHost\=accounting.harte-lyne.ca,
>> WebPort\=8080,
>> SSLPort\=8443,
>> type\=PostgreSQL,
>> DBhost\=localhost,
>> DBport\=5432,
>> DBname\=idempiere,
>> BQ\=false,
>> FW\=false,
>> FWhost\=,
>> FWport\=0,
>> UID\=idempiere_dbadmin,
>> PWD\=xxxxxxxxxxxxxxxx]
>
> Hm, is "UID" really how they spell "database user name"? Doesn't seem
> terribly consistent with the other field names you show here.

That is extracted directly from the properties file created by the install
process, excepting that the password has been edited.
>
>> [root(at)accounting-2 ~ (master)]# psql --dbname=idempiere
>> --username=idempiere_dbadmin
>
> psql, by default, is going to try to connect to a Unix socket.
> I wonder if you've got two postmasters on that machine and the
> other one is what's answering TCP port 5432. . .

I see only one master process

[root(at)accounting-2 ~ (master)]# ps -auwx | grep postgres
postgres 19108 0.0 0.2 177972 30540 - IsJ 11:58 0:00.01 postgres:
idempiere_dbadmin idempiere 127.0.88.1(52228) (postgres)
postgres 19109 0.0 0.2 178608 36876 - IsJ 11:58 0:00.03 postgres:
idempiere_dbadmin idempiere 127.0.88.1(52229) (postgres)
postgres 19110 0.0 0.3 182712 51688 - IsJ 11:58 0:00.09 postgres:
idempiere_dbadmin idempiere 127.0.88.1(52230) (postgres)
postgres 20028 0.0 0.2 178676 37624 - IsJ 12:18 0:00.03 postgres:
idempiere_dbadmin idempiere 127.0.88.1(22758) (postgres)
postgres 20029 0.0 0.2 178728 36784 - IsJ 12:18 0:00.03 postgres:
idempiere_dbadmin idempiere 127.0.88.1(22759) (postgres)
postgres 68949 0.0 0.2 175504 34656 - IsJ Fri18 0:00.85 postgres:
checkpointer (postgres)
postgres 68950 0.0 0.1 175468 23420 - SsJ Fri18 0:00.82 postgres:
background writer (postgres)
postgres 68951 0.0 0.1 175468 23416 - SsJ Fri18 0:01.48 postgres:
walwriter (postgres)
postgres 68952 0.0 0.1 175800 23800 - SsJ Fri18 0:04.95 postgres:
autovacuum launcher (postgres)
postgres 68953 0.0 0.1 32012 14076 - SsJ Fri18 0:18.87 postgres:
stats collector (postgres)
postgres 68954 0.0 0.1 175644 23644 - IsJ Fri18 0:00.08 postgres:
logical replication launcher (postgres)
root 20522 0.0 0.0 11348 2216 2 S+J 12:32 0:00.00 grep
--color=auto postgres
postgres 68947 0.0 0.1 175468 23408 2 SJ Fri18 0:19.13
/usr/local/bin/postgres -D /var/db/postgres/data11

[root(at)accounting-2 ~ (master)]# service postgresql status
pg_ctl: server is running (PID: 68947)
/usr/local/bin/postgres "-D" "/var/db/postgres/data11"

>. . . You might try
> explicitly saying "--host=localhost" here.
>
> regards, tom lane
>

[root(at)accounting-2 ~ (master)]# psql --dbname=idempiere
--username=idempiere_dbadmin --host=localhost
Password for user idempiere_dbadmin:
psql (11.8)
Type "help" for help.

idempiere=# select current_schemas(true);
current_schemas
------------------------
{adempiere,pg_catalog}
(1 row)

idempiere=# select uuid_generate_v4();
ERROR: function uuid_generate_v4() does not exist
LINE 1: select uuid_generate_v4();
^
HINT: No function matches the given name and argument types. You might need to
add explicit type casts.
idempiere=# select public.uuid_generate_v4();
uuid_generate_v4
--------------------------------------
5ba19b69-ec8e-4d8e-8968-7c84eccc4351
(1 row)

--
*** e-Mail is NOT a SECURE channel ***
Do NOT transmit sensitive data via e-Mail
Unencrypted messages have no legal claim to privacy
Do NOT open attachments nor follow links sent by e-Mail

James B. Byrne mailto:ByrneJB(at)Harte-Lyne(dot)ca
Harte & Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3