Bootstrap function in plugin "users-permissions" failed

[merijnponzo]

Hello,

When I upgraded from 3.0.0-beta.13 to beta.16.7 I got errors when I try to reconnect my database - on a clean installation, after strapi develop. So it won't boot

error Bootstrap function in plugin "users-permissions" failed
error error: duplicate key value violates unique constraint "users-permissions_permission_pkey"

and

Bootstrap function in plugin "content-manager" failed
duplicate key value violates unique constraint "core_store_pkey"

1. create strapi-app my-project
2. make sure a new strapi app install is working
3. copy your api, config and extensions folder to your new install
   (make sure to install any extra plugins like strapi-graphql)
   (make sure this app is a few versions behind, and already has content, edited permissions etc)
4. strapi develop

My strapi application is a bit behind, but I would expect that the latest version would work with my database from 3.0.0-beta.13

NodeJs v12.11.1
NPM 6.11.3
Strapi beta.16.7
Database:Postgres
Operating system:Mac

Another upgrade method I tried is simply replace 3.0.0-beta.13 to 3.0.0-beta.16.7 in my package.json, remove my package-lock and node_modules and npm install. But this gave me the same error

[lauriejim]

Hello! Did you follow this migration guide?
https://strapi.io/documentation/3.0.0-beta.x/migration-guide/migration-guide-beta.15-to-beta.16.html

[merijnponzo]

Hello Laurie, thank you for your reply.

I updated from 13 to 15 first, then my app still works. Then I update from 15 to 16 and the error above occurs.

• I did a rebuild, first. I dont use custom bootstraps or hooks.
• I dont return toJSON() directly in my custom controller

I don't think the WYSIWYG is causing this problem.

error Bootstrap function in plugin "users-permissions" failed
[2019-10-08T06:33:28.031Z] error error: duplicate key value violates unique constraint "users-permissions_permission_pkey"
    at Connection.parseE (/Applications/AMPPS/www/puppyplaza/puppyplaza_postdev_beta5.0/node_modules/pg/lib/connection.js:604:11)
    at Connection.parseMessage (/Applications/AMPPS/www/puppyplaza/puppyplaza_postdev_beta5.0/node_modules/pg/lib/connection.js:401:19)
    at Socket.<anonymous> (/Applications/AMPPS/www/puppyplaza/puppyplaza_postdev_beta5.0/node_modules/pg/lib/connection.js:121:22)
    at Socket.emit (events.js:210:5)
    at addChunk (_stream_readable.js:308:12)
    at readableAddChunk (_stream_readable.js:289:11)
    at Socket.Readable.push (_stream_readable.js:223:10)
    at TCP.onStreamRead (internal/stream_base_commons.js:182:23)

[derrickmehaffy]

@merijnponzo can you confirm that you also don't have any carrots in your strapi package version ^ or ~

Based on the error something is going on with permissions trying to set a duplicate key. You may want to try backing up then purging that table in the database.

[merijnponzo]

Hi derrick, Only lodash and typy

 "dependencies": {
    "knex": "latest",
    "lodash": "^4.17.5",
    "pg": "latest",
    "strapi": "3.0.0-beta.16",
    "strapi-admin": "3.0.0-beta.16",
    "strapi-hook-bookshelf": "3.0.0-beta.16",
    "strapi-hook-knex": "3.0.0-beta.16",
    "strapi-plugin-content-manager": "3.0.0-beta.16",
    "strapi-plugin-content-type-builder": "3.0.0-beta.16",
    "strapi-plugin-email": "3.0.0-beta.16",
    "strapi-plugin-graphql": "3.0.0-beta.16",
    "strapi-plugin-settings-manager": "3.0.0-beta.16",
    "strapi-plugin-upload": "3.0.0-beta.16",
    "strapi-plugin-users-permissions": "3.0.0-beta.16",
    "strapi-utils": "3.0.0-beta.16",
    "typy": "^3.1.0"
  },

[derrickmehaffy]

@merijnponzo I would suggest you skip beta.16 directly and go straight to beta.16.8

The subversion number in this case are hotfixes for beta.16.

[merijnponzo]

I guess when building it's trying to create new keys like 'users-permissions_permission_pkey' to my permissions table.

So I updated to 16.8, but still:

[2019-10-08T06:55:59.777Z] error Bootstrap function in plugin "users-permissions" failed
[2019-10-08T06:55:59.778Z] error error: duplicate key value violates unique constraint "users-permissions_permission_pkey"
    at Connection.parseE (/Applications/AMPPS/www/puppyplaza/puppyplaza_postdev_beta5.0/node_modules/pg/lib/connection.js:604:11)
    at Connection.parseMessage (/Applications/AMPPS/www/puppyplaza/puppyplaza_postdev_beta5.0/node_modules/pg/lib/connection.js:401:19)
    at Socket.<anonymous> (/Applications/AMPPS/www/puppyplaza/puppyplaza_postdev_beta5.0/node_modules/pg/lib/connection.js:121:22)

[derrickmehaffy]

@mtringuyen yeah like I said there must be something that got messed up during the upgrade. Do a backup of the table (or your entire DB) purge that permissions table and restart.

[merijnponzo]

Okey removed my user-permissions_permission table
changed cb() in bootstrap to

module.exports = {
  defaults: {},
  async initialize(cb) {
    await cb();
  }
};

Now I got

 TypeError: fn is not a function
    at execBootstrap (/Applications/AMPPS/www/puppyplaza/puppyplaza_postdev_beta16.8/node_modules/strapi/lib/Strapi.js:381:15)
    at Strapi.runBootstrapFunctions (/Applications/AMPPS/www/puppyplaza/puppyplaza_postdev_beta16.8/node_modules/strapi/lib/Strapi.js:399:12)

[merijnponzo]

I changed the cb() to

module.exports = () => {};

Now it works again -

I will add my permissions manually just like the good old strapi-alpha times ;-)

This is a bug right? Not a 'help wanted'

Thanks!

[derrickmehaffy]

@merijnponzo I believe the migration guide states that all the cb() need to be removed but there was some issues with permissions that likely your jump to beta.16 directly caused

I believe that if you jumped from beta.x to beta.16.8 this issue wouldn't have happened directly. Either way glad you solved it, going to mark this is as closed unless someone else has the same problem.

[merijnponzo]

Hello,
I'm using 3.0.0-beta.17.4 for a while

NodeJs v12.11.1
NPM 6.11.3
Strapi beta.16.7
Database:Postgres
Operating system:Mac

If I import a copy of my production database to my local, strapi develop boots okay
But when I create a new content-type,

the error is back

[2019-12-05T07:44:59.909Z] error Bootstrap function in plugin "users-permissions" failed
[2019-12-05T07:44:59.910Z] error error: duplicate key value violates unique constraint "users-permissions_permission_pkey"
    at Connection.parseE (/Applications/www/puppyplaza/puppyplaza_backend/node_modules/pg/lib/connection.js:604:11)
    at Connection.parseMessage (/Applications/www/puppyplaza/puppyplaza_backend/node_modules/pg/lib/connection.js:401:19)
    at Socket.<anonymous> (/Applications/www/puppyplaza/puppyplaza_backend/node_modules/pg/lib/connection.js:121:22)
    at Socket.emit (events.js:210:5)
    at Socket.EventEmitter.emit (domain.js:476:20)
    at addChunk (_stream_readable.js:308:12)
    at readableAddChunk (_stream_readable.js:289:11)
    at Socket.Readable.push (_stream_readable.js:223:10)
    at TCP.onStreamRead (internal/stream_base_commons.js:182:23)

my bootstrap.js is still

module.exports = () => {};

I also already tried it with clearing my core_store. But this doesnt help

[lauriejim]

Make sure you well update your sequence values.
Because when you import data, you have to set all your tables' sequences to the last ID value of the table.

[merijnponzo]

Thanks laurie,
Is this postgres specific?

ALTER SEQUENCE users-permissions_permission RESTART WITH last_id_of_table;