Process completed with exit code 1.

error: puppetlabs.puppetdb.command-broadcast-test/cmd-broadcast expected: nil actual: #error { :cause "BCFKS KeyStore not available" :via [{:type java.security.KeyStoreException :message "BCFKS not found" :at [java.security.KeyStore getInstance "KeyStore.java" 871]} {:type java.security.NoSuchAlgorithmException :message "BCFKS KeyStore not available" :at [sun.security.jca.GetInstance getInstance "GetInstance.java" 159]}] :trace [[sun.security.jca.GetInstance getInstance "GetInstance.java" 159] [java.security.Security getImpl "Security.java" 676] [java.security.KeyStore getInstance "KeyStore.java" 868] [com.puppetlabs.ssl_utils.SSLUtils createKeyStore "SSLUtils.java" 623] [puppetlabs.ssl_utils.core$eval43585$keystore__43590$fn__43591 invoke "core.clj" 733] [puppetlabs.ssl_utils.core$eval43585$keystore__43590 invoke "core.clj" 730] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50507$pem_ssl_config__GT_keystore_ssl_config__50512$fn__50516 invoke "jetty10_config.clj" 296] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50507$pem_ssl_config__GT_keystore_ssl_config__50512 invoke "jetty10_config.clj" 290] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50590$get_keystore_config_BANG___50595$fn__50596 invoke "jetty10_config.clj" 337] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50590$get_keystore_config_BANG___50595 invoke "jetty10_config.clj" 331] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50795$maybe_get_https_connector__50800$fn__50801 invoke "jetty10_config.clj" 423] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50795$maybe_get_https_connector__50800 invoke "jetty10_config.clj" 414] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50849$maybe_add_https_connector__50854$fn__50855 invoke "jetty10_config.clj" 445] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50849$maybe_add_https_connector__50854 invoke "jetty10_config.clj" 441] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50876$process_config__50881$fn__50882 invoke "jetty10_config.clj" 468] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50876$process_config__50881 invoke "jetty10_config.clj" 461] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52217$create_webserver__52222$fn__52223 invoke "jetty10_core.clj" 741] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52217$create_webserver__52222 invoke "jetty10_core.clj" 699] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52249$start_webserver_BANG___52254$fn__52255 invoke "jetty10_core.clj" 785] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52249$start_webserver_BANG___52254 invoke "jetty10_core.clj" 780] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$start_server_single_default invokeStatic "jetty10_core.clj" 1037] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$start_server_single_default invoke "jetty10_core.clj" 1034] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52717$start_BANG___52722$fn__52723 invoke "jetty10_core.clj" 1137] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52717$start_BANG___52722 invoke "jetty10_core.clj" 1132] [puppetlabs.trapperkeeper.services.webserver.jetty10_service$reify__53129$service_fnk__24296__auto___positional$reify__53136 start "jetty10_service.clj" 53] [puppetlabs.trapperkeeper.services$eval24094$fn__24121$G__24084__24124 invoke "services.clj" 7] [puppetlabs.trapperkeeper.services$eval24094$fn__24121$G__24083__24128 invoke "services.clj" 7] [puppetlabs.trapperkeeper.internal$eval24698$run_lifecycle_fn_BANG___24705$fn__24706 invoke "internal.clj" 242] [puppetlabs.trapperkeeper.internal$eval24698$run_lifecycle_fn_BANG___24705 invoke "internal.clj" 225] [puppetlabs.trapperkeeper.internal$eval24728$run_lifecycle_fns__24733$fn__24734 invoke "internal.clj" 275] [puppetlabs.trapperkeeper.internal$eval24728$run_lifecycle_fns__24733 inv

error: puppetlabs.puppetdb.command-broadcast-test/cmd-broadcast-with-one-pg-down expected: nil actual: #error { :cause "BCFKS KeyStore not available" :via [{:type java.security.KeyStoreException :message "BCFKS not found" :at [java.security.KeyStore getInstance "KeyStore.java" 871]} {:type java.security.NoSuchAlgorithmException :message "BCFKS KeyStore not available" :at [sun.security.jca.GetInstance getInstance "GetInstance.java" 159]}] :trace [[sun.security.jca.GetInstance getInstance "GetInstance.java" 159] [java.security.Security getImpl "Security.java" 676] [java.security.KeyStore getInstance "KeyStore.java" 868] [com.puppetlabs.ssl_utils.SSLUtils createKeyStore "SSLUtils.java" 623] [puppetlabs.ssl_utils.core$eval43585$keystore__43590$fn__43591 invoke "core.clj" 733] [puppetlabs.ssl_utils.core$eval43585$keystore__43590 invoke "core.clj" 730] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50507$pem_ssl_config__GT_keystore_ssl_config__50512$fn__50516 invoke "jetty10_config.clj" 296] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50507$pem_ssl_config__GT_keystore_ssl_config__50512 invoke "jetty10_config.clj" 290] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50590$get_keystore_config_BANG___50595$fn__50596 invoke "jetty10_config.clj" 337] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50590$get_keystore_config_BANG___50595 invoke "jetty10_config.clj" 331] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50795$maybe_get_https_connector__50800$fn__50801 invoke "jetty10_config.clj" 423] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50795$maybe_get_https_connector__50800 invoke "jetty10_config.clj" 414] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50849$maybe_add_https_connector__50854$fn__50855 invoke "jetty10_config.clj" 445] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50849$maybe_add_https_connector__50854 invoke "jetty10_config.clj" 441] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50876$process_config__50881$fn__50882 invoke "jetty10_config.clj" 468] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50876$process_config__50881 invoke "jetty10_config.clj" 461] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52217$create_webserver__52222$fn__52223 invoke "jetty10_core.clj" 741] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52217$create_webserver__52222 invoke "jetty10_core.clj" 699] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52249$start_webserver_BANG___52254$fn__52255 invoke "jetty10_core.clj" 785] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52249$start_webserver_BANG___52254 invoke "jetty10_core.clj" 780] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$start_server_single_default invokeStatic "jetty10_core.clj" 1037] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$start_server_single_default invoke "jetty10_core.clj" 1034] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52717$start_BANG___52722$fn__52723 invoke "jetty10_core.clj" 1137] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52717$start_BANG___52722 invoke "jetty10_core.clj" 1132] [puppetlabs.trapperkeeper.services.webserver.jetty10_service$reify__53129$service_fnk__24296__auto___positional$reify__53136 start "jetty10_service.clj" 53] [puppetlabs.trapperkeeper.services$eval24094$fn__24121$G__24084__24124 invoke "services.clj" 7] [puppetlabs.trapperkeeper.services$eval24094$fn__24121$G__24083__24128 invoke "services.clj" 7] [puppetlabs.trapperkeeper.internal$eval24698$run_lifecycle_fn_BANG___24705$fn__24706 invoke "internal.clj" 242] [puppetlabs.trapperkeeper.internal$eval24698$run_lifecycle_fn_BANG___24705 invoke "internal.clj" 225] [puppetlabs.trapperkeeper.internal$eval24728$run_lifecycle_fns__24733$fn__24734 invoke "internal.clj" 275] [puppetlabs.trapperkeeper.internal$eval24728$run_lifecyc

error: puppetlabs.puppetdb.command-broadcast-test/multiple-db-migrations expected: nil actual: #error { :cause "BCFKS KeyStore not available" :via [{:type java.security.KeyStoreException :message "BCFKS not found" :at [java.security.KeyStore getInstance "KeyStore.java" 871]} {:type java.security.NoSuchAlgorithmException :message "BCFKS KeyStore not available" :at [sun.security.jca.GetInstance getInstance "GetInstance.java" 159]}] :trace [[sun.security.jca.GetInstance getInstance "GetInstance.java" 159] [java.security.Security getImpl "Security.java" 676] [java.security.KeyStore getInstance "KeyStore.java" 868] [com.puppetlabs.ssl_utils.SSLUtils createKeyStore "SSLUtils.java" 623] [puppetlabs.ssl_utils.core$eval43585$keystore__43590$fn__43591 invoke "core.clj" 733] [puppetlabs.ssl_utils.core$eval43585$keystore__43590 invoke "core.clj" 730] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50507$pem_ssl_config__GT_keystore_ssl_config__50512$fn__50516 invoke "jetty10_config.clj" 296] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50507$pem_ssl_config__GT_keystore_ssl_config__50512 invoke "jetty10_config.clj" 290] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50590$get_keystore_config_BANG___50595$fn__50596 invoke "jetty10_config.clj" 337] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50590$get_keystore_config_BANG___50595 invoke "jetty10_config.clj" 331] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50795$maybe_get_https_connector__50800$fn__50801 invoke "jetty10_config.clj" 423] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50795$maybe_get_https_connector__50800 invoke "jetty10_config.clj" 414] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50849$maybe_add_https_connector__50854$fn__50855 invoke "jetty10_config.clj" 445] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50849$maybe_add_https_connector__50854 invoke "jetty10_config.clj" 441] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50876$process_config__50881$fn__50882 invoke "jetty10_config.clj" 468] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50876$process_config__50881 invoke "jetty10_config.clj" 461] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52217$create_webserver__52222$fn__52223 invoke "jetty10_core.clj" 741] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52217$create_webserver__52222 invoke "jetty10_core.clj" 699] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52249$start_webserver_BANG___52254$fn__52255 invoke "jetty10_core.clj" 785] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52249$start_webserver_BANG___52254 invoke "jetty10_core.clj" 780] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$start_server_single_default invokeStatic "jetty10_core.clj" 1037] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$start_server_single_default invoke "jetty10_core.clj" 1034] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52717$start_BANG___52722$fn__52723 invoke "jetty10_core.clj" 1137] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52717$start_BANG___52722 invoke "jetty10_core.clj" 1132] [puppetlabs.trapperkeeper.services.webserver.jetty10_service$reify__53129$service_fnk__24296__auto___positional$reify__53136 start "jetty10_service.clj" 53] [puppetlabs.trapperkeeper.services$eval24094$fn__24121$G__24084__24124 invoke "services.clj" 7] [puppetlabs.trapperkeeper.services$eval24094$fn__24121$G__24083__24128 invoke "services.clj" 7] [puppetlabs.trapperkeeper.internal$eval24698$run_lifecycle_fn_BANG___24705$fn__24706 invoke "internal.clj" 242] [puppetlabs.trapperkeeper.internal$eval24698$run_lifecycle_fn_BANG___24705 invoke "internal.clj" 225] [puppetlabs.trapperkeeper.internal$eval24728$run_lifecycle_fns__24733$fn__24734 invoke "internal.clj" 275] [puppetlabs.trapperkeeper.internal$eval24728$run_lifecycle_fns__

error: puppetlabs.puppetdb.command-broadcast-test/cmd-broadcast-with-all-pgs-down expected: nil actual: #error { :cause "BCFKS KeyStore not available" :via [{:type java.security.KeyStoreException :message "BCFKS not found" :at [java.security.KeyStore getInstance "KeyStore.java" 871]} {:type java.security.NoSuchAlgorithmException :message "BCFKS KeyStore not available" :at [sun.security.jca.GetInstance getInstance "GetInstance.java" 159]}] :trace [[sun.security.jca.GetInstance getInstance "GetInstance.java" 159] [java.security.Security getImpl "Security.java" 676] [java.security.KeyStore getInstance "KeyStore.java" 868] [com.puppetlabs.ssl_utils.SSLUtils createKeyStore "SSLUtils.java" 623] [puppetlabs.ssl_utils.core$eval43585$keystore__43590$fn__43591 invoke "core.clj" 733] [puppetlabs.ssl_utils.core$eval43585$keystore__43590 invoke "core.clj" 730] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50507$pem_ssl_config__GT_keystore_ssl_config__50512$fn__50516 invoke "jetty10_config.clj" 296] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50507$pem_ssl_config__GT_keystore_ssl_config__50512 invoke "jetty10_config.clj" 290] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50590$get_keystore_config_BANG___50595$fn__50596 invoke "jetty10_config.clj" 337] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50590$get_keystore_config_BANG___50595 invoke "jetty10_config.clj" 331] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50795$maybe_get_https_connector__50800$fn__50801 invoke "jetty10_config.clj" 423] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50795$maybe_get_https_connector__50800 invoke "jetty10_config.clj" 414] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50849$maybe_add_https_connector__50854$fn__50855 invoke "jetty10_config.clj" 445] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50849$maybe_add_https_connector__50854 invoke "jetty10_config.clj" 441] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50876$process_config__50881$fn__50882 invoke "jetty10_config.clj" 468] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50876$process_config__50881 invoke "jetty10_config.clj" 461] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52217$create_webserver__52222$fn__52223 invoke "jetty10_core.clj" 741] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52217$create_webserver__52222 invoke "jetty10_core.clj" 699] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52249$start_webserver_BANG___52254$fn__52255 invoke "jetty10_core.clj" 785] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52249$start_webserver_BANG___52254 invoke "jetty10_core.clj" 780] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$start_server_single_default invokeStatic "jetty10_core.clj" 1037] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$start_server_single_default invoke "jetty10_core.clj" 1034] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52717$start_BANG___52722$fn__52723 invoke "jetty10_core.clj" 1137] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52717$start_BANG___52722 invoke "jetty10_core.clj" 1132] [puppetlabs.trapperkeeper.services.webserver.jetty10_service$reify__53129$service_fnk__24296__auto___positional$reify__53136 start "jetty10_service.clj" 53] [puppetlabs.trapperkeeper.services$eval24094$fn__24121$G__24084__24124 invoke "services.clj" 7] [puppetlabs.trapperkeeper.services$eval24094$fn__24121$G__24083__24128 invoke "services.clj" 7] [puppetlabs.trapperkeeper.internal$eval24698$run_lifecycle_fn_BANG___24705$fn__24706 invoke "internal.clj" 242] [puppetlabs.trapperkeeper.internal$eval24698$run_lifecycle_fn_BANG___24705 invoke "internal.clj" 225] [puppetlabs.trapperkeeper.internal$eval24728$run_lifecycle_fns__24733$fn__24734 invoke "internal.clj" 275] [puppetlabs.trapperkeeper.internal$eval24728$run_lifecy

error: puppetlabs.puppetdb.cli.services-test/cert-allowlists expected: nil actual: #error { :cause "BCFKS KeyStore not available" :via [{:type java.security.KeyStoreException :message "BCFKS not found" :at [java.security.KeyStore getInstance "KeyStore.java" 871]} {:type java.security.NoSuchAlgorithmException :message "BCFKS KeyStore not available" :at [sun.security.jca.GetInstance getInstance "GetInstance.java" 159]}] :trace [[sun.security.jca.GetInstance getInstance "GetInstance.java" 159] [java.security.Security getImpl "Security.java" 676] [java.security.KeyStore getInstance "KeyStore.java" 868] [com.puppetlabs.ssl_utils.SSLUtils createKeyStore "SSLUtils.java" 623] [puppetlabs.ssl_utils.core$eval43585$keystore__43590$fn__43591 invoke "core.clj" 733] [puppetlabs.ssl_utils.core$eval43585$keystore__43590 invoke "core.clj" 730] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50507$pem_ssl_config__GT_keystore_ssl_config__50512$fn__50516 invoke "jetty10_config.clj" 296] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50507$pem_ssl_config__GT_keystore_ssl_config__50512 invoke "jetty10_config.clj" 290] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50590$get_keystore_config_BANG___50595$fn__50596 invoke "jetty10_config.clj" 337] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50590$get_keystore_config_BANG___50595 invoke "jetty10_config.clj" 331] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50795$maybe_get_https_connector__50800$fn__50801 invoke "jetty10_config.clj" 423] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50795$maybe_get_https_connector__50800 invoke "jetty10_config.clj" 414] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50849$maybe_add_https_connector__50854$fn__50855 invoke "jetty10_config.clj" 445] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50849$maybe_add_https_connector__50854 invoke "jetty10_config.clj" 441] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50876$process_config__50881$fn__50882 invoke "jetty10_config.clj" 468] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50876$process_config__50881 invoke "jetty10_config.clj" 461] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52217$create_webserver__52222$fn__52223 invoke "jetty10_core.clj" 741] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52217$create_webserver__52222 invoke "jetty10_core.clj" 699] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52249$start_webserver_BANG___52254$fn__52255 invoke "jetty10_core.clj" 785] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52249$start_webserver_BANG___52254 invoke "jetty10_core.clj" 780] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$start_server_single_default invokeStatic "jetty10_core.clj" 1037] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$start_server_single_default invoke "jetty10_core.clj" 1034] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52717$start_BANG___52722$fn__52723 invoke "jetty10_core.clj" 1137] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52717$start_BANG___52722 invoke "jetty10_core.clj" 1132] [puppetlabs.trapperkeeper.services.webserver.jetty10_service$reify__53129$service_fnk__24296__auto___positional$reify__53136 start "jetty10_service.clj" 53] [puppetlabs.trapperkeeper.services$eval24094$fn__24121$G__24084__24124 invoke "services.clj" 7] [puppetlabs.trapperkeeper.services$eval24094$fn__24121$G__24083__24128 invoke "services.clj" 7] [puppetlabs.trapperkeeper.internal$eval24698$run_lifecycle_fn_BANG___24705$fn__24706 invoke "internal.clj" 242] [puppetlabs.trapperkeeper.internal$eval24698$run_lifecycle_fn_BANG___24705 invoke "internal.clj" 225] [puppetlabs.trapperkeeper.internal$eval24728$run_lifecycle_fns__24733$fn__24734 invoke "internal.clj" 275] [puppetlabs.trapperkeeper.internal$eval24728$run_lifecycle_fns__24733 invoke

fail: puppetlabs.puppetdb.query-eng-test/joins-dropped-for-extract-deps-operator-field-clause expected: (= {:left-join []} (compiled-selects q :drop-joins)) actual: (not (= {:left-join []} {:select [:certname :environment_id :key :value], :left-join []}))

fail: puppetlabs.puppetdb.query-eng-test/joins-dropped-for-extract-deps-operator-field-clause expected: (= normal-facts-joins (compiled-selects q nil)) actual: (not (= {:left-join [[:environments :env] [:= :fs.environment_id :env.id]]} {:select [:certname :environment_id :key :value], :left-join [[:environments :env] [:= :fs.environment_id :env.id]]}))

fail: puppetlabs.puppetdb.query-eng-test/reports-not-dropped-from-nodes-for-latest-report-status expected: (= {:left-join [:reports [:and [:= :certnames.certname :reports.certname] [:= :certnames.latest_report_id :reports.id]] :report_statuses [:= :reports.status_id :report_statuses.id]]} (compiled-selects q :drop-joins)) actual: (not (= {:left-join [:reports [:and [:= :certnames.certname :reports.certname] [:= :certnames.latest_report_id :reports.id]] :report_statuses [:= :reports.status_id :report_statuses.id]]} {:left-join [:certnames [:= :certnames_status.certname :certnames.certname] :reports_latest [:= :certnames.certname :reports_latest.certname] :report_statuses [:= :reports_latest.status_id :report_statuses.id]]}))

fail: puppetlabs.puppetdb.query-eng-test/reports-not-dropped-from-nodes-for-latest-report-status expected: (= normal-nodes-joins (compiled-selects q nil)) actual: (not (= {:left-join [:catalogs [:= :catalogs.certname :certnames.certname] [:factsets :fs] [:= :certnames.certname :fs.certname] :reports [:and [:= :certnames.certname :reports.certname] [:= :certnames.latest_report_id :reports.id]] [:environments :catalog_environment] [:= :catalog_environment.id :catalogs.environment_id] :report_statuses [:= :reports.status_id :report_statuses.id] [:environments :facts_environment] [:= :facts_environment.id :fs.environment_id] [:environments :reports_environment] [:= :reports_environment.id :reports.environment_id]]} {:left-join [:certnames [:= :certnames_status.certname :certnames.certname] :catalogs [:= :certnames_status.certname :catalogs.certname] [:factsets :fs] [:= :certnames_status.certname :fs.certname] :reports_latest [:= :certnames.certname :reports_latest.certname] [:environments :catalog_environment] [:= :catalog_environment.id :catalogs.environment_id] :report_statuses [:= :reports_latest.status_id :report_statuses.id] [:environments :facts_environment] [:= :facts_environment.id :fs.environment_id] [:environments :reports_environment] [:= :reports_environment.id :reports_latest.environment_id]]}))

fail: puppetlabs.puppetdb.query-eng-test/joins-dropped-for-nodes-count-and-extract-query-with-factset-subuery expected: (= {:left-join [:reports [:and [:= :certnames.certname :reports.certname] [:= :certnames.latest_report_id :reports.id]] :report_statuses [:= :reports.status_id :report_statuses.id]]} (compiled-selects q :drop-joins)) actual: (not (= {:left-join [:reports [:and [:= :certnames.certname :reports.certname] [:= :certnames.latest_report_id :reports.id]] :report_statuses [:= :reports.status_id :report_statuses.id]]} {:left-join [:certnames [:= :certnames_status.certname :certnames.certname] :reports_latest [:= :certnames.certname :reports_latest.certname] :report_statuses [:= :reports_latest.status_id :report_statuses.id]]}))

fail: puppetlabs.puppetdb.query-eng-test/joins-dropped-for-nodes-count-and-extract-query-with-factset-subuery expected: (= normal-nodes-joins (compiled-selects q nil)) actual: (not (= {:left-join [:catalogs [:= :catalogs.certname :certnames.certname] [:factsets :fs] [:= :certnames.certname :fs.certname] :reports [:and [:= :certnames.certname :reports.certname] [:= :certnames.latest_report_id :reports.id]] [:environments :catalog_environment] [:= :catalog_environment.id :catalogs.environment_id] :report_statuses [:= :reports.status_id :report_statuses.id] [:environments :facts_environment] [:= :facts_environment.id :fs.environment_id] [:environments :reports_environment] [:= :reports_environment.id :reports.environment_id]]} {:left-join [:certnames [:= :certnames_status.certname :certnames.certname] :catalogs [:= :certnames_status.certname :catalogs.certname] [:factsets :fs] [:= :certnames_status.certname :fs.certname] :reports_latest [:= :certnames.certname :reports_latest.certname] [:environments :catalog_environment] [:= :catalog_environment.id :catalogs.environment_id] :report_statuses [:= :reports_latest.status_id :report_statuses.id] [:environments :facts_environment] [:= :facts_environment.id :fs.environment_id] [:environments :reports_environment] [:= :reports_environment.id :reports_latest.environment_id]]}))

fail: puppetlabs.puppetdb.query-eng-test/joins-not-dropped-for-nodes-avg-query expected: (= normal-nodes-joins (compiled-selects q :drop-joins)) actual: (not (= {:left-join [:catalogs [:= :catalogs.certname :certnames.certname] [:factsets :fs] [:= :certnames.certname :fs.certname] :reports [:and [:= :certnames.certname :reports.certname] [:= :certnames.latest_report_id :reports.id]] [:environments :catalog_environment] [:= :catalog_environment.id :catalogs.environment_id] :report_statuses [:= :reports.status_id :report_statuses.id] [:environments :facts_environment] [:= :facts_environment.id :fs.environment_id] [:environments :reports_environment] [:= :reports_environment.id :reports.environment_id]]} {:left-join [:certnames [:= :certnames_status.certname :certnames.certname] :catalogs [:= :certnames_status.certname :catalogs.certname] [:factsets :fs] [:= :certnames_status.certname :fs.certname] :reports_latest [:= :certnames.certname :reports_latest.certname] [:environments :catalog_environment] [:= :catalog_environment.id :catalogs.environment_id] :report_statuses [:= :reports_latest.status_id :report_statuses.id] [:environments :facts_environment] [:= :facts_environment.id :fs.environment_id] [:environments :reports_environment] [:= :reports_environment.id :reports_latest.environment_id]]}))

fail: puppetlabs.puppetdb.query-eng-test/joins-not-dropped-for-nodes-avg-query expected: (= normal-nodes-joins (compiled-selects q nil)) actual: (not (= {:left-join [:catalogs [:= :catalogs.certname :certnames.certname] [:factsets :fs] [:= :certnames.certname :fs.certname] :reports [:and [:= :certnames.certname :reports.certname] [:= :certnames.latest_report_id :reports.id]] [:environments :catalog_environment] [:= :catalog_environment.id :catalogs.environment_id] :report_statuses [:= :reports.status_id :report_statuses.id] [:environments :facts_environment] [:= :facts_environment.id :fs.environment_id] [:environments :reports_environment] [:= :reports_environment.id :reports.environment_id]]} {:left-join [:certnames [:= :certnames_status.certname :certnames.certname] :catalogs [:= :certnames_status.certname :catalogs.certname] [:factsets :fs] [:= :certnames_status.certname :fs.certname] :reports_latest [:= :certnames.certname :reports_latest.certname] [:environments :catalog_environment] [:= :catalog_environment.id :catalogs.environment_id] :report_statuses [:= :reports_latest.status_id :report_statuses.id] [:environments :facts_environment] [:= :facts_environment.id :fs.environment_id] [:environments :reports_environment] [:= :reports_environment.id :reports_latest.environment_id]]}))

fail: puppetlabs.puppetdb.query-eng-test/joins-dropped-for-extract-deps-subquery-clause expected: (= normal-nodes-joins (compiled-selects q nil)) actual: (not (= {:left-join [:catalogs [:= :catalogs.certname :certnames.certname] [:factsets :fs] [:= :certnames.certname :fs.certname] :reports [:and [:= :certnames.certname :reports.certname] [:= :certnames.latest_report_id :reports.id]] [:environments :catalog_environment] [:= :catalog_environment.id :catalogs.environment_id] :report_statuses [:= :reports.status_id :report_statuses.id] [:environments :facts_environment] [:= :facts_environment.id :fs.environment_id] [:environments :reports_environment] [:= :reports_environment.id :reports.environment_id]]} {:left-join [:certnames [:= :certnames_status.certname :certnames.certname] :catalogs [:= :certnames_status.certname :catalogs.certname] [:factsets :fs] [:= :certnames_status.certname :fs.certname] :reports_latest [:= :certnames.certname :reports_latest.certname] [:environments :catalog_environment] [:= :catalog_environment.id :catalogs.environment_id] :report_statuses [:= :reports_latest.status_id :report_statuses.id] [:environments :facts_environment] [:= :facts_environment.id :fs.environment_id] [:environments :reports_environment] [:= :reports_environment.id :reports_latest.environment_id]]}))