Old version upgrade steps

[satomic]

How to know the version?

The version is defined in the docker container, you can use this command

docker exec -it cpuad cat version

# this is the output
20250404

Old version (<=20250220) upgrade steps

Prerequest

• Download lastest source code in your Grafana server.

Steps

1. Update index copilot_usage_breakdown

check its current status

curl localhost:9200/copilot_usage_breakdown/_mapping?pretty

if it does not have the model field, that means the version is too old. update with command, then check it again.

curl -X PUT "http://localhost:9200/copilot_usage_breakdown/_mapping" \
     -H 'Content-Type: application/json' \
     -d '{
       "properties": {
         "model": {
           "type": "keyword"
         }
       }
     }'

2. Update copilot_usage_breakdown historical data

Add value default to the model field added to the historical data

curl -X POST "http://localhost:9200/copilot_usage_breakdown/_update_by_query?conflicts=proceed" \
     -H "Content-Type: application/json" \
     -d '{
       "script": {
         "source": "if (ctx._source.model == null) { ctx._source.model = params.defaultValue }",
         "params": {
           "defaultValue": "default"
         }
       }
     }'

3. Update index copilot_usage_total

check its current status

curl localhost:9200/copilot_usage_total/_mapping?pretty

if it does not have the total_chat_copy_events & total_chat_insertion_events field, that means the version is too old. update with command, then check it again.

curl -X PUT "http://localhost:9200/copilot_usage_total/_mapping" \
     -H 'Content-Type: application/json' \
     -d '{
       "properties": {
         "total_chat_copy_events" : {
         "type" : "long"
         },
         "total_chat_insertion_events" : {
         "type" : "long"
         }
       }
     }'

4. Create new index copilot_usage_breakdown_chat

curl -X PUT "http://localhost:9200/copilot_usage_breakdown_chat" -H 'Content-Type: application/json' -d @mapping/copilot_usage_breakdown_chat_mapping.json

5. Create a new data source in Grafana

• Access Grafana in the browser and create a new data source: elasticsearch-breakdown-chat
• 

6. Generate Dashboard Json

Generate Dashboard Json Model again, and import to the Grafana.

7. Run the latest CPUAD image

docker pull satomic/cpuad-updater:20250222

and run it again.

[satomic]

Old version (20250220<= your version <=20250404) upgrade steps

Prerequest

• Download lastest source code in your Grafana server.

Steps

1. Delete all data in index copilot_seat_assignments

curl -X POST "http://localhost:9200/copilot_seat_assignments/_delete_by_query" \
-H "Content-Type: application/json" \
-d '{
  "query": {
    "match_all": {}
  }
}'

2. Update index copilot_seat_assignments

check its current status

curl localhost:9200/copilot_seat_assignments/_mapping?pretty

if it does not have the is_active_today field, that means the version is too old. update with command, then check it again.

curl -X PUT "http://localhost:9200/copilot_seat_assignments/_mapping" \
     -H 'Content-Type: application/json' \
     -d '{
       "properties": {
         "is_active_today": {
           "type": "long"
         }
       }
     }'

3. Set default value for the new field

Set value 0 as the default value of is_active_today field

curl -X POST "http://localhost:9200/copilot_seat_assignments/_update_by_query?conflicts=proceed" \
     -H "Content-Type: application/json" \
     -d '{
       "script": {
         "source": "if (ctx._source.is_active_today == null) { ctx._source.is_active_today = params.defaultValue }",
         "params": {
           "defaultValue": 0
         }
       }
     }'

4. Generate Dashboard Json

Generate Dashboard Json Model again, and import to the Grafana.

5. Run the latest CPUAD image

docker pull satomic/cpuad-updater

and run it again.

6. Check dashboard

These are the new Visualizations you shoud have now.