zrhoffman opened a new issue, #7222: URL: https://github.com/apache/trafficcontrol/issues/7222
<!-- ************ STOP!! ************ If this issue identifies a security vulnerability, DO NOT submit it! Instead, contact the Apache Traffic Control Security Team at [email protected] and follow the guidelines at https://apache.org/security regarding vulnerability disclosure. - For *SUPPORT QUESTIONS*, use the #traffic-control channel on the ASF slack (https://s.apache.org/tc-slack-request) or the Traffic Control Users mailing list (send an email to [email protected] to subscribe). - Before submitting, please **SEARCH GITHUB** for a similar issue or PR * https://github.com/apache/trafficcontrol/issues * https://github.com/apache/trafficcontrol/pulls --> <!-- Do not submit security vulnerabilities or support requests here - see above --> ## This Bug Report affects these Traffic Control components: <!-- delete all those that don't apply --> - Traffic Ops ## Current behavior: <!-- Describe how the bug happens --> If the `delivery_service_requests` table is non-empty, running the `2022110908494015_ds_active_flag.up.sql` migration will fail. ``` (details: pq: cannot cast jsonb string to type boolean) exit status 1 ``` ## Expected behavior: <!-- Describe what the behavior would be without the bug --> All migrations should run successfully. ## Steps to reproduce: <!-- If the current behavior is a bug, please provide the *STEPS TO REPRODUCE* and include the applicable TC version. --> 1. Checkout the commit before #7099 ```shell git checkout 822092f26a~ ``` 2. Cherry-pick #7209 so that Dev CiaB works ```shell git checkout 09039af182 ``` 3. Enable Delivery Service Requests in `traffic_portal_properties.json` ```shell file=traffic_portal/app/src/traffic_portal_properties.json echo "$(<"$file" jq '.properties.dsRequests.enabled = true')" >"$file" ``` 4. Start CDN in a Box for Developers ```shell docker-compose up ``` 5. Go to https://localhost:444/#!/delivery-services/1?dsType=HTTP 6. Set *Display Name* to *new-display-name* 7. Press *Update* 8. Choose *Submit Request for Review and Deployment*, enter *My text* as your comment, and press *Submit* 9. Checkout the Apache master branch 10. Try to run database migrations ```shell cd traffic_ops/app go run ./db -c ../../dev/traffic_ops/dbconf.yml up ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
