Rollout Issues

​

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"}'

​

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:
   Copy

   Ask AI

   -- 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:
     Copy

     Ask AI

     -- 006__fix_users_table.sql
     CREATE TABLE IF NOT EXISTS users (...);
     

4. Retry or create new rollout:
   Copy

   Ask AI

   # 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

​

Next Steps