Ok, any SQL issued from maas seems to fail:

$ maas createadmin --username test1 --password test2 --email
t...@test.com

leads to

root@f-pgdebug:/# 2021-08-16 14:35:39.130 GMT [13818] ERROR:  could not load 
library "/usr/lib/postgresql/12/lib/plpgsql.so": 
/usr/lib/postgresql/12/lib/plpgsql.so: undefined symbol: 
EnsurePortalSnapshotExists
2021-08-16 14:35:39.130 GMT [13818] STATEMENT:  INSERT INTO "auth_user" 
("password", "last_login", "is_superuser", "username", "first_name", 
"last_name", "email", "is_staff", "is_active", "date_joined") VALUES 
('pbkdf2_sha256$150000$gaKm5YLS0YzY$j0n8Tv4yaj+BTHRd+il0Ko/iMK4rKV5KtgkZ9YMnI7U=',
 NULL, true, 'test1', '', '', 't...@test.com', true, true, 
'2021-08-16T14:35:39.051899'::timestamp) RETURNING "auth_user"."id"


The question is how could I do the same from inside an 
  $ snap run --shell maas
I want to take that apart to become only a SQL request.
I guess that goes through the snaps python libs - is that right?

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1939898

Title:
  Unnatended postgresql-12 upgrade caused MAAS internal error

To manage notifications about this bug go to:
https://bugs.launchpad.net/maas/+bug/1939898/+subscriptions


-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to