Purging db of removed accounts?

[jordanurbs]

Using the Discourse SSO plug-in, which works great except that the same email/username can't be used again if the account was already deleted on PeerTube. Doesn't seem to affect Discourse in any way.

Not a huge issue in the long run but something I would like to remedy right now, as I'm in need of that username...

Any idea how I can use the CLI to take care of this?

For what it's worth, the log error:

warn[12/3/2020, 1:54:44 PM] Login error.

{
  "err": {
    "statusCode": 400,
    "status": 400,
    "code": 400,
    "message": "Cannot create such user: an actor with that name already exists.",
    "name": "access_denied",
    "stack": "access_denied: Cannot create such user: an actor with that name already exists.\n    at new AccessDeniedError (/app/code/server/node_modules/oauth2-server/lib/errors/access-denied-error.js:25:14)\n    at Object.<anonymous> (/app/code/server/dist/server/lib/oauth-model.js:97:23)\n    at Generator.next (<anonymous>)\n    at fulfilled (/app/code/server/node_modules/tslib/tslib.js:111:62)"
  }
}

[girish]

@jordanurbs I guess https://github.com/Chocobozzz/PeerTube/issues/1042 ? There seems to be SQL query in the end of that issue which solved the issue for some user. Also referenced from https://github.com/Chocobozzz/PeerTube/issues/1572 and https://github.com/Chocobozzz/PeerTube/issues/870

[jordanurbs]

@girish said in Purging db of removed accounts?:

@jordanurbs I guess https://github.com/Chocobozzz/PeerTube/issues/1042 ? There seems to be SQL query in the end of that issue which solved the issue for some user. Also referenced from https://github.com/Chocobozzz/PeerTube/issues/1572 and https://github.com/Chocobozzz/PeerTube/issues/870

Thanks @girish!