Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save martinrayenglish/44f6622160d5dd533581f9d12f9c83d5 to your computer and use it in GitHub Desktop.
Save martinrayenglish/44f6622160d5dd533581f9d12f9c83d5 to your computer and use it in GitHub Desktop.
Solr xDB Index Troubleshooting Postman Collection
{
"info": {
"_postman_id": "ac487bbf-4bc0-498c-9b16-034706b6fc19",
"name": "Sitecore xDB",
"schema": "https://schema.getpostman.com/json/collection/v2.1.0/collection.json"
},
"item": [
{
"name": "xDB Contacts Count",
"request": {
"method": "GET",
"header": [],
"url": {
"raw": "{{solr_url}}/solr/{{xdb_index}}/select?q=x_type_s:contactdatarecord",
"host": [
"{{solr_url}}"
],
"path": [
"solr",
"{{xdb_index}}",
"select"
],
"query": [
{
"key": "q",
"value": "x_type_s:contactdatarecord"
},
{
"key": "id",
"value": "02c7f77d-bc04-3000-0000-0597590d718c",
"disabled": true
}
]
}
},
"response": []
},
{
"name": "xDB Interactions Count",
"request": {
"method": "GET",
"header": [],
"url": {
"raw": "{{solr_url}}/solr/{{xdb_index}}/select?q=x_type_s:interactiondatarecord",
"host": [
"{{solr_url}}"
],
"path": [
"solr",
"{{xdb_index}}",
"select"
],
"query": [
{
"key": "q",
"value": "x_type_s:interactiondatarecord"
}
]
}
},
"response": []
},
{
"name": "xDB Docs Count",
"request": {
"method": "GET",
"header": [],
"url": {
"raw": "{{solr_url}}/solr/{{xdb_index}}/select?q=*:*",
"host": [
"{{solr_url}}"
],
"path": [
"solr",
"{{xdb_index}}",
"select"
],
"query": [
{
"key": "q",
"value": "*:*"
}
]
}
},
"response": []
},
{
"name": "xDB Sync Token",
"request": {
"method": "GET",
"header": [],
"url": {
"raw": "{{solr_url}}/solr{{xdb_index}}/select?indent=on&q=id:%22xdb-index-token%22&wt=json",
"host": [
"{{solr_url}}"
],
"path": [
"solr{{xdb_index}}",
"select"
],
"query": [
{
"key": "indent",
"value": "on"
},
{
"key": "q",
"value": "id:%22xdb-index-token%22"
},
{
"key": "wt",
"value": "json"
}
]
}
},
"response": []
},
{
"name": "xDB Rebuild Status",
"request": {
"method": "GET",
"header": [],
"url": {
"raw": "{{solr_url}}/solr/{{xdb_index}}/select?q=id:\"xdb-rebuild-status\"",
"host": [
"{{solr_url}}"
],
"path": [
"solr",
"{{xdb_index}}",
"select"
],
"query": [
{
"key": "q",
"value": "id:\"xdb-rebuild-status\""
}
]
}
},
"response": []
},
{
"name": "xDB Schema Modifications",
"request": {
"method": "POST",
"header": [
{
"key": "Content-Type",
"name": "Content-Type",
"value": "application/json",
"type": "text"
}
],
"body": {
"mode": "raw",
"raw": "{\r\n \"replace-field-type\": [\r\n {\r\n \"name\": \"string\",\r\n \"class\": \"solr.StrField\",\r\n \"sortMissingLast\": true,\r\n \"docValues\": false\r\n }\r\n ],\r\n\r\n \"replace-dynamic-field\": [\r\n {\r\n \"name\": \"*_s\",\r\n \"type\": \"lowercase\",\r\n \"stored\": false,\r\n \"indexed\": true,\r\n \"omitNorms\": true\r\n },\r\n {\r\n \"name\": \"*_b\",\r\n \"type\": \"boolean\",\r\n \"stored\": false,\r\n \"indexed\": true,\r\n \"sortMissingLast\": false\r\n },\r\n {\r\n \"name\": \"*_l\",\r\n \"type\": \"plong\",\r\n \"stored\": false,\r\n \"indexed\": true\r\n },\r\n {\r\n \"name\": \"*_d\",\r\n \"type\": \"pdouble\",\r\n \"stored\": false,\r\n \"indexed\": true\r\n },\r\n {\r\n \"name\": \"*_dt\",\r\n \"type\": \"pdate\",\r\n \"stored\": false,\r\n \"indexed\": true\r\n },\r\n {\r\n \"name\": \"*_ss\",\r\n \"type\": \"lowercase\",\r\n \"multiValued\": \"true\",\r\n \"stored\": false,\r\n \"indexed\": true,\r\n \"omitNorms\": true\r\n },\r\n {\r\n \"name\": \"*_bs\",\r\n \"type\": \"boolean\",\r\n \"multiValued\": \"true\",\r\n \"stored\": false,\r\n \"indexed\": true\r\n },\r\n {\r\n \"name\": \"*_ls\",\r\n \"type\": \"plongs\",\r\n \"multiValued\": \"true\",\r\n \"stored\": false,\r\n \"indexed\": true\r\n },\r\n {\r\n \"name\": \"*_ds\",\r\n \"type\": \"pdoubles\",\r\n \"multiValued\": \"true\",\r\n \"stored\": false,\r\n \"indexed\": true\r\n },\r\n {\r\n \"name\": \"*_dts\",\r\n \"type\": \"pdate\",\r\n \"multiValued\": \"true\",\r\n \"stored\": false,\r\n \"indexed\": true\r\n }\r\n ],\r\n \"delete-field\": [\r\n { \"name\": \"contactid_s\" },\r\n { \"name\": \"xdbtokenbytes_s\" }\r\n ],\r\n \"add-field\": [\r\n {\r\n \"name\": \"contactid_s\",\r\n \"type\": \"string\",\r\n \"indexed\": true,\r\n \"stored\": true\r\n },\r\n {\r\n \"name\": \"xdbtokenbytes_s\",\r\n \"type\": \"string\",\r\n \"indexed\": false,\r\n \"stored\": true\r\n }\r\n ]\r\n}"
},
"url": {
"raw": "{{solr_url}}/solr/{{xdb_index}}/schema",
"host": [
"{{solr_url}}"
],
"path": [
"solr",
"{{xdb_index}}",
"schema"
]
},
"description": "Delete document(s) by ID"
},
"response": []
},
{
"name": "xDB Delete Interactions",
"request": {
"method": "POST",
"header": [
{
"key": "Content-Type",
"name": "Content-Type",
"value": "application/json",
"type": "text"
}
],
"body": {
"mode": "raw",
"raw": "{\n\t\"delete\": { \"query\":\"x_type_s:interactiondatarecord\" },\n \"commit\": {}\n}"
},
"url": {
"raw": "{{solr_url}}/solr/{{xdb_index}}/update/json",
"host": [
"{{solr_url}}"
],
"path": [
"solr",
"{{xdb_index}}",
"update",
"json"
]
}
},
"response": []
}
],
"event": [
{
"listen": "prerequest",
"script": {
"id": "559bd64b-1855-4ec6-8be6-ec1ce4e15a48",
"type": "text/javascript",
"exec": [
""
]
}
},
{
"listen": "test",
"script": {
"id": "850c050b-f124-4485-920c-8581555b1db5",
"type": "text/javascript",
"exec": [
""
]
}
}
],
"variable": [
{
"id": "993b6ddc-4557-4e18-b58a-0f78cacc6cc3",
"key": "solr_url",
"value": "https://martin.com",
"type": "string"
},
{
"id": "1ba751eb-055d-4893-b4d6-0a455229f1b7",
"key": "xdb_index",
"value": "xdb_internal",
"type": "string"
}
],
"protocolProfileBehavior": {}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment