cartodb: Error while creating development user CartoDB

While creating development user I get this error:

[pool] Found a connection for localhost:cartodb_dev_user_ec9cc5c4-2863-4fc6-acbf-95bcb52ea902_db:5432:postgres:sequel (4)
(0.000178s) BEGIN
PG::Error: ERROR:  role "cdb_org_member_cd4c6486da97f514ce4aaec5338e2296" does not exist
CONTEXT:  SQL statement "GRANT "cdb_org_member_cd4c6486da97f514ce4aaec5338e2296" TO "development_cartodb_user_ec9cc5c4-2863-4fc6-acbf-95bcb52ea902""
PL/pgSQL function cdb_organization_create_member(text) line 3 at EXECUTE statement: SELECT cartodb.CDB_Organization_Create_Member('development_cartodb_user_ec9cc5c4-2863-4fc6-acbf-95bcb52ea902');
(0.000228s) ROLLBACK
(0.000848s) ROLLBACK
rake aborted!
PG::Error: ERROR:  role "cdb_org_member_cd4c6486da97f514ce4aaec5338e2296" does not exist
CONTEXT:  SQL statement "GRANT "cdb_org_member_cd4c6486da97f514ce4aaec5338e2296" TO "development_cartodb_user_ec9cc5c4-2863-4fc6-acbf-95bcb52ea902""
PL/pgSQL function cdb_organization_create_member(text) line 3 at EXECUTE statement

End all process is revoked. Any idea what could be the issue?

About this issue

  • Original URL
  • State: closed
  • Created 8 years ago
  • Comments: 16 (7 by maintainers)

Most upvoted comments

I’ve encountered the same error, I found this advice to be useful: https://gis.stackexchange.com/a/245410/114640. The ‘cartodb’ extension must not be enabled on the postgis_template database.