[GitHub] [trafficcontrol] zrhoffman opened a new issue, #7222: TO DB migrations: cannot cast jsonb string to type boolean

[GitBox <gi...@apache.org>]

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 security@trafficcontrol.apache.org 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 users-subscribe@trafficcontrol.apache.org 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: issues-unsubscribe@trafficcontrol.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [trafficcontrol] srijeet0406 closed issue #7222: TO DB migrations: cannot cast jsonb string to type boolean

[GitBox <gi...@apache.org>]

srijeet0406 closed issue #7222: TO DB migrations: cannot cast jsonb string to type boolean
URL: https://github.com/apache/trafficcontrol/issues/7222


-- 
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: issues-unsubscribe@trafficcontrol.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org