php-spx icon indicating copy to clipboard operation
php-spx copied to clipboard

Bad JSON response -- clear database?

Open SnakeO opened this issue 5 years ago • 2 comments

Something caused the JSON response to come back bad: https://wow-ss-from-2020.s3.amazonaws.com/Screen-Shot-2020-04-23-00-57-24.86.png

Here's the portion of the JSON that's broken:

,{
  "key": "spx-full-20200420_001139-Plesk.local-7103-603035188",
  "exec_ts": 1587312699,
  "host_name": "Plesk.local",
  "process_pid": 7103,
  "process_tid": 7103,
  "process_pwd": "/",
  "cli": 0,
  "cli_command_line": "n/a",
  "http_request_uri": "/wp-admin/admin-ajax.php?_fs_blog_admin=true",
  "http_method": "POST",
  "http_host": "www.tofusecret.com",
  "wall_time_ms": 2591144,
  "peak_memory_usage": 39636480,
  "called_function_count": 7615,
  "call_count": 704011,
  "recorded_call_count": 704011,
  "enabled_metrics": [
    "wt"
    ,"zm"
  ]
}
,,{
  "key": "spx-full-20200420_012204-Plesk.local-11168-1052982471",
  "exec_ts": 1587316924,
  "host_name": "Plesk.local",
  "process_pid": 11168,
  "process_tid": 11168,
  "process_pwd": "/",
  "cli": 0,
  "cli_command_line": "n/a",
  "http_request_uri": "/wp-content/plugins/woocommerce-products-filter/js/easy-autocomplete/easy-autocomplete.min.css.map",
  "http_method": "GET",
  "http_host": "www.tofusecret.com",
  "wall_time_ms": 4073337,
  "peak_memory_usage": 46941504,
  "called_function_count": 8084,
  "call_count": 1564880,
  "recorded_call_count": 1564880,
  "enabled_metrics": [
    "wt"
    ,"zm"
  ]
}

(there's a double comma there). I'm trying to figure out how to clear the database of results so I can start fresh..

SnakeO avatar Apr 22 '20 15:04 SnakeO

The database consists of a set of files stored in /tmp/spx by default so you just have to rm -rf /tmp/spx to clear all reports. This broken json seems to be caused by an empty metadata files.

NoiseByNorthwest avatar Apr 23 '20 21:04 NoiseByNorthwest

@SnakeO You should probably turn off file listing on that bucket. There seems to be private data in there including bank transaction receipts...

GrahamCampbell avatar Apr 23 '20 22:04 GrahamCampbell