CHAT_OUTPUT_BEGIN
COMMAND_ID=SUPPORT-260909-GRAM-XF-FLEET-FOOTER-UI-PREFLIGHT-RCA-102R2
STATUS=OK
RC=0
HOST=pve01
MODE=read-only
COMPONENT=gram-support-footer-ui-preflight-db-query-rca
REFERENCE_REGISTER_CHECK=OK
REFERENCE_SHA256=5a3d8e5154c41cb582a4e0aca68090be1f0138918bf82131a948df326f9d8d66
ERROR_REGISTER_CHECK=OK
ERROR_REGISTER_SHA256=3b09a553ec0f527ed3afeed4753f52a74ee3036045bbfb3c685e9f8af4ba7ba0
COMMAND_SHA256=4b2181cfe84f2c82d0850ea5208c566246bff1c3cade754d48991d9e37075bd3
DUPLICATE_FAILED_COMMAND_BLOCKED=false
EXECUTION_STARTED=true
CHANGE_DECLARED=false
RESULT_CONTRACT_VALID=true
RESULT_CONTRACT_STATUS=NOT_APPLICABLE
RESULT_CONTRACT_ERROR=NONE
COMMAND_RC=0
CHANGES_MADE=false
ROLLBACK_STARTED=false
ROLLBACK_RESTORED=null
MUTATION_OUTCOME=NO_MUTATION
SANITIZED=yes
SECRETS_INCLUDED=no
PRIVATE_ADDRESSES_INCLUDED=no
RAW_EVIDENCE_SHA256=4efe02d3b4a5a1bcc8ae8236d7d95753725d8a1559244437abc38003c400caa1
SANITIZED_OUTPUT_SHA256=4efe02d3b4a5a1bcc8ae8236d7d95753725d8a1559244437abc38003c400caa1
OUTPUT_BEGIN
GRAM_FIX8_PREFLIGHT_RCA2_BEGIN
COMMAND_ID=SUPPORT-260909-GRAM-XF-FLEET-FOOTER-UI-PREFLIGHT-RCA-102R2
GRAM_FIX8_RCA2_TOPOLOGY={"name":"newfi-staging","node":"pve03","status":"running","type":"qemu"}
GRAM_FIX8_RCA2_STAGING={"transport":"COMPLETE","exitcode":0,"result":{"ok":true,"command_id":"SUPPORT-260909-GRAM-XF-FLEET-FOOTER-UI-PREFLIGHT-RCA-102R2","target":"newfi-staging","root":"/var/www/forums/newfi/public","app_user":"xfp_newfi","config_stat":{"uid":0,"gid":994,"mode":"0o640"},"readable":{"xfp_newfi":{"src/config.php":true,"cmd.php":true,"src/XF.php":true}},"services":{"mariadb":true,"nginx":true,"php8.3-fpm":true},"app_probe":{"rc":0,"stdout":{"bytes":1489,"sha256":"210054d3b9bad368abf918d5d146743f7e5d0941d398e0030317234ec4d3145e","line_count":1,"kind":"OTHER","first":["{\"ok\":false,\"steps\":{\"xf_start\":{\"ok\":true},\"setup_app\":{\"ok\":true,\"class\":\"XF\\\\Pub\\\\App\"},\"db\":{\"ok\":true,\"class\":\"XF\\\\Db\\\\Mysqli\\\\Adapter\"}},\"schema\":{\"xf_addon\":{\"ok\":true,\"columns\":[\"addon_id\",\"title\",\"version_string\",\"version_id\",\"json"],"last":["{\"ok\":false,\"steps\":{\"xf_start\":{\"ok\":true},\"setup_app\":{\"ok\":true,\"class\":\"XF\\\\Pub\\\\App\"},\"db\":{\"ok\":true,\"class\":\"XF\\\\Db\\\\Mysqli\\\\Adapter\"}},\"schema\":{\"xf_addon\":{\"ok\":true,\"columns\":[\"addon_id\",\"title\",\"version_string\",\"version_id\",\"json"]},"stderr":{"bytes":0,"sha256":"e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855","line_count":0,"kind":"EMPTY","first":[],"last":[]},"json":{"ok":false,"steps":{"xf_start":{"ok":true},"setup_app":{"ok":true,"class":"XF\\Pub\\App"},"db":{"ok":true,"class":"XF\\Db\\Mysqli\\Adapter"}},"schema":{"xf_addon":{"ok":true,"columns":["addon_id","title","version_string","version_id","json_hash","active","is_legacy","is_processing","last_pending_action"]},"xf_template":{"ok":true,"columns":["template_id","type","title","style_id","template","template_parsed","addon_id","version_id","version_string","last_edit_date"]},"xf_template_modification":{"ok":true,"columns":["modification_id","addon_id","type","template","modification_key","description","execution_order","enabled","action","find","replace"]},"xf_option":{"ok":true,"columns":["option_id","option_value","default_value","edit_format","edit_format_params","data_type","sub_options","validation_class","validation_method","advanced","addon_id"]},"xf_error_log":{"ok":true,"columns":["error_id","exception_date","user_id","ip_address","exception_type","message","filename","line","trace_string","request_state"]}},"queries":{"addon":{"ok":true,"row_present":true},"templates":{"ok":true,"row_count":13},"mods":{"ok":false,"error":{"class":"XF\\Db\\InvalidQueryException","code":1064,"message_sha256":"e8ed4c221538a96e327e5adbcfd84f916a50cf477c5b5072e0d0c482480b95ea","message_bytes":266,"classes":[],"known_tokens":["addon_id","template","enabled","xf_template","xf_template_modification"]}},"options":{"ok":true,"row_count":2},"error_max":{"ok":true,"scalar_type":"string"}}}},"root_probe":{"rc":0,"stdout":{"bytes":1489,"sha256":"210054d3b9bad368abf918d5d146743f7e5d0941d398e0030317234ec4d3145e","line_count":1,"kind":"OTHER","first":["{\"ok\":false,\"steps\":{\"xf_start\":{\"ok\":true},\"setup_app\":{\"ok\":true,\"class\":\"XF\\\\Pub\\\\App\"},\"db\":{\"ok\":true,\"class\":\"XF\\\\Db\\\\Mysqli\\\\Adapter\"}},\"schema\":{\"xf_addon\":{\"ok\":true,\"columns\":[\"addon_id\",\"title\",\"version_string\",\"version_id\",\"json"],"last":["{\"ok\":false,\"steps\":{\"xf_start\":{\"ok\":true},\"setup_app\":{\"ok\":true,\"class\":\"XF\\\\Pub\\\\App\"},\"db\":{\"ok\":true,\"class\":\"XF\\\\Db\\\\Mysqli\\\\Adapter\"}},\"schema\":{\"xf_addon\":{\"ok\":true,\"columns\":[\"addon_id\",\"title\",\"version_string\",\"version_id\",\"json"]},"stderr":{"bytes":0,"sha256":"e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855","line_count":0,"kind":"EMPTY","first":[],"last":[]},"json":{"ok":false,"steps":{"xf_start":{"ok":true},"setup_app":{"ok":true,"class":"XF\\Pub\\App"},"db":{"ok":true,"class":"XF\\Db\\Mysqli\\Adapter"}},"schema":{"xf_addon":{"ok":true,"columns":["addon_id","title","version_string","version_id","json_hash","active","is_legacy","is_processing","last_pending_action"]},"xf_template":{"ok":true,"columns":["template_id","type","title","style_id","template","template_parsed","addon_id","version_id","version_string","last_edit_date"]},"xf_template_modification":{"ok":true,"columns":["modification_id","addon_id","type","template","modification_key","description","execution_order","enabled","action","find","replace"]},"xf_option":{"ok":true,"columns":["option_id","option_value","default_value","edit_format","edit_format_params","data_type","sub_options","validation_class","validation_method","advanced","addon_id"]},"xf_error_log":{"ok":true,"columns":["error_id","exception_date","user_id","ip_address","exception_type","message","filename","line","trace_string","request_state"]}},"queries":{"addon":{"ok":true,"row_present":true},"templates":{"ok":true,"row_count":13},"mods":{"ok":false,"error":{"class":"XF\\Db\\InvalidQueryException","code":1064,"message_sha256":"e8ed4c221538a96e327e5adbcfd84f916a50cf477c5b5072e0d0c482480b95ea","message_bytes":266,"classes":[],"known_tokens":["addon_id","template","enabled","xf_template","xf_template_modification"]}},"options":{"ok":true,"row_count":2},"error_max":{"ok":true,"scalar_type":"string"}}}},"app_cli":{"rc":0,"stdout":{"bytes":15431,"sha256":"4d2a6aa6164da903bb08cf965450face3616797b6661476fa5ce6f8e9c4a6b16","line_count":168,"kind":"OTHER","first":["completion                                   Dump the shell completion script","help                                         Display help for a command"],"last":["xf-rebuild:xfrm-resource-items               Rebuilds resource item counters.","xf-rebuild:xfrm-user-resource-counts         Rebuilds resource related user counters."]},"stderr":{"bytes":0,"sha256":"e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855","line_count":0,"kind":"EMPTY","first":[],"last":[]},"commands":{"xf:addon-upgrade":true,"xf:addon-rebuild":true,"xf-addon:sync-json":true}},"root_cli":{"rc":0,"stdout":{"bytes":15431,"sha256":"4d2a6aa6164da903bb08cf965450face3616797b6661476fa5ce6f8e9c4a6b16","line_count":168,"kind":"OTHER","first":["completion                                   Dump the shell completion script","help                                         Display help for a command"],"last":["xf-rebuild:xfrm-resource-items               Rebuilds resource item counters.","xf-rebuild:xfrm-user-resource-counts         Rebuilds resource related user counters."]},"stderr":{"bytes":0,"sha256":"e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855","line_count":0,"kind":"EMPTY","first":[],"last":[]},"commands":{"xf:addon-upgrade":true,"xf:addon-rebuild":true,"xf-addon:sync-json":true}}},"outer_rc":0}
GRAM_FIX8_RCA2_CLASSIFICATION={"kind":"QUERY_FAILURE_CAPTURED","app_failed_queries":["mods"],"root_failed_queries":["mods"]}
GRAM_FIX8_RCA2_MUTATION_SCOPE="NONE_READ_ONLY"
GRAM_FIX8_PREFLIGHT_RCA2_END

OUTPUT_END
CHAT_OUTPUT_END
