Can't create folders or scripts - sql error
I have just installed Windmill in docker, and I don't seem to be able to create anything - I just get errors:
Sql error: error returned from database: new row violates row-level security policy for table "folder"
Error while saving the script as a draft: Sql error: error returned from database: new row violates row-level security policy for table "script"
I have created a new user (superadmin) and that doesn't work either.
I am using the EE image with a valid test key.
11 Replies
Hi @BennyP101 , what's your database ?
Postgres 16
Are you using RDS or another managed service?
Nope, it is a local docker image
You're using the stock docker-compose ?
I had it working fine a few weeks ago, but I moved to a new machine and changed to the EE image
It's a custom one, but the Windmill parts are copied from the stock one
I think there is something funky with how that db was setup
but you may be able to fix it using:
https://www.windmill.dev/docs/advanced/self_host#run-windmill-without-using-a-postgres-superuser
Self Host | Windmill
Self-host Windmill on your own infrastructure.
do you have 10mins to hop on a call so e investigate together quickly?
Interesting, I wonder if I forgot to save changes to my DB init scripts - I don't have the same bits as in https://raw.githubusercontent.com/windmill-labs/windmill/main/init-db-as-superuser.sql
And adding the missing parts in has made it work!
Sorry about that, but thanks for the quick reply and help! 🙂
glad you got it sorted 🎉