Can not found source database when do pscale create branch on github actions

[ytnobody]

I encountered below error on a github actions workflow.

Run pscale branch create my_app_db ci-10c37bc4a798cca3b[2](https://github.com/my-org/my-app/actions/runs/6502530552/job/17661921839#step:13:2)5f78ca36a83ab64fb51106 --org my-org --wait 
  pscale branch create my_app_db ci-10c37bc4a798cca3b25f78ca36a83ab64fb51106 --org my-org --wait 
  shell: /usr/bin/bash -e {0}
  env:
    PLANETSCALE_SERVICE_TOKEN_ID: ***
    PLANETSCALE_SERVICE_TOKEN: ***
Creating branch from my_app_db...
Error: source database my_app_db does not exist in organization my-org
Error: Process completed with exit code 2.

And, this is a github workflow setting yml file.

name: "check-server"

on:
  push:
    branches:
      - main
  pull_request:
    types: [opened, synchronize, reopened, closed]

jobs:
  build:
    runs-on: ${{ matrix.os }}
    timeout-minutes: 15

    strategy:
      matrix:
        node-version: [18.x]
        os: [ubuntu-latest]
      fail-fast: false

    steps:
      - name: Checkout
        uses: actions/checkout@v3

      - name: Setup pscale
        uses: planetscale/setup-pscale-action@v1

      - name: Create a branch on PlanetScale
        env:
          PLANETSCALE_SERVICE_TOKEN_ID: ${{ secrets.PLANETSCALE_SERVICE_TOKEN_ID }}
          PLANETSCALE_SERVICE_TOKEN: ${{ secrets.PLANETSCALE_SERVICE_TOKEN }}
        run: |
          pscale branch create my_app_db ci-${{ github.sha }} --org my-org --wait 

        ...

And conditions is below.

• Database my_app_db exists in organization my-org.
• Plan of my_app_db is Hobby.
• A service token has below permissions with database my_app_db.
  • connect_branch
  • create_branch
  • delete_branch
  • read_branch
  • read_database
  • write_database

What can I do to resolve this error?

[orware]

Hello @ytnobody,

Since I see the usage of the pscale CLI as part of the workflow settings file information you shared, would it be possible to give one of our official GitHub Actions a try as well to compare the behavior/results:
https://planetscale.com/blog/announcing-the-planetscale-github-actions

Overall, from what you've shared though it seems like the process would work so the error about my_app_db not existing within my_org seems weird.

One extra question I have, since this is a Hobby plan database, is whether it only has a main branch currently? Hobby plans can only have one production branch and one development branch, but I would expect if you are already using both of those up the error message would be different so I wouldn't expect this to be the issue.

[lsha0730]

Hey, in your planetscale settings, you need to goto service token settings, click on the service token being used, and give it permissions to access the database, make branches and such.

[ytnobody]

Hello everyone, I do not know the cause, but I have not been able to reproduce this problem for more than 6 months.
Therefore, I am going to close this discussion once and for all.

What is clear is that authority or authorization was not the cause. Because no one on the team made any changes to the authority or authorization, yet the problem was solved.

Thank you.