Rollout Issues

Documentation Index

Fetch the complete documentation index at: https://docs.bytebase.com/llms.txt

Use this file to discover all available pages before exploring further.

​

All Tasks Skipped

# Check revisions on target database
curl -X GET "$BB_URL/v1/instances/prod/databases/app_db/revisions"

1. Create migrations with new version numbers
2. Create new release
3. Create new plan/rollout

​

Task Stuck in PENDING_APPROVAL

1. Rollout policy requires manual approval
2. No authorized users have approved

curl -X POST "$BB_URL/v1/projects/my-project/rollouts/rollout-123/stages/stage-1/tasks/task-1:approve" \
  -H "Authorization: Bearer $BB_TOKEN" \
  -d '{"comment": "Approved for deployment"}'

curl -X GET "$BB_URL/v1/projects/my-project/environments/prod" \
  -H "Authorization: Bearer $BB_TOKEN"

{
  "rollout_policy": {
    "automatic": false,
    "issue_roles": ["roles/projectOwner", "roles/projectDBA"]
  }
}

curl -X PATCH "$BB_URL/v1/projects/my-project/environments/prod" \
  -H "Authorization: Bearer $BB_TOKEN" \
  -d '{
    "rollout_policy": {
      "automatic": true
    }
  }'

​

Task Fails with SQL Error

ERROR: syntax error at or near "CRATE"

1. Identify problematic file:
   • Check task logs for error location
   • Identify which migration file failed
2. Fix syntax error:
   -- Wrong:
   CRATE TABLE users (...);
   
   -- Correct:
   CREATE TABLE users (...);
   
3. Create new release:
   • Don’t modify original file if already released
   • Create new migration with fix:
     -- 006__fix_users_table.sql
     CREATE TABLE IF NOT EXISTS users (...);
     
4. Retry or create new rollout:
   # Option 1: Retry failed task (if file was corrected before execution)
   curl -X POST "$BB_URL/v1/projects/my-project/rollouts/rollout-123/stages/stage-1/tasks:batchRun" \
     -d '{"tasks": ["task-1"]}'
   
   # Option 2: Create new rollout with corrected release
   curl -X POST "$BB_URL/v1/projects/my-project/rollouts" \
     -d '{"plan": "projects/my-project/plans/plan-new"}'
   

​

Permission Denied Error

ERROR: permission denied to create table "users"

-- PostgreSQL
GRANT CREATE, ALTER, DROP ON DATABASE app_db TO bytebase_user;
GRANT ALL ON SCHEMA public TO bytebase_user;

-- MySQL
GRANT CREATE, ALTER, DROP, INDEX ON app_db.* TO 'bytebase_user'@'%';

-- PostgreSQL
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO bytebase_user;

-- MySQL
GRANT SELECT, INSERT, UPDATE, DELETE ON app_db.* TO 'bytebase_user'@'%';

curl -X PATCH "$BB_URL/v1/instances/prod-mysql" \
  -d '{
    "username": "bytebase_admin",
    "password": "new_password"
  }'

-- PostgreSQL: Check grants
SELECT grantee, privilege_type
FROM information_schema.role_table_grants
WHERE grantee = 'bytebase_user';

-- MySQL: Show grants
SHOW GRANTS FOR 'bytebase_user'@'%';

​

Connection Timeout

Connection timeout after 30 seconds

1. Database server down
2. Network connectivity issues
3. Firewall blocking connection
4. Incorrect connection parameters

# PostgreSQL
pg_isready -h prod-mysql -p 5432

# MySQL
mysqladmin -h prod-mysql -u user -p ping

# Test connection
telnet prod-mysql 5432

# Or with nc
nc -zv prod-mysql 5432

# Test from Bytebase server
docker exec bytebase nc -zv prod-mysql 5432

curl -X GET "$BB_URL/v1/instances/prod-mysql"

​

Next Steps