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$eval43594$keystore__43599$fn__43600 invoke "core.clj" 733] [puppetlabs.ssl_utils.core$eval43594$keystore__43599 invoke "core.clj" 730] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50516$pem_ssl_config__GT_keystore_ssl_config__50521$fn__50525 invoke "jetty10_config.clj" 296] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50516$pem_ssl_config__GT_keystore_ssl_config__50521 invoke "jetty10_config.clj" 290] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50599$get_keystore_config_BANG___50604$fn__50605 invoke "jetty10_config.clj" 337] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50599$get_keystore_config_BANG___50604 invoke "jetty10_config.clj" 331] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50804$maybe_get_https_connector__50809$fn__50810 invoke "jetty10_config.clj" 423] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50804$maybe_get_https_connector__50809 invoke "jetty10_config.clj" 414] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50858$maybe_add_https_connector__50863$fn__50864 invoke "jetty10_config.clj" 445] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50858$maybe_add_https_connector__50863 invoke "jetty10_config.clj" 441] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50885$process_config__50890$fn__50891 invoke "jetty10_config.clj" 468] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50885$process_config__50890 invoke "jetty10_config.clj" 461] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52226$create_webserver__52231$fn__52232 invoke "jetty10_core.clj" 741] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52226$create_webserver__52231 invoke "jetty10_core.clj" 699] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52258$start_webserver_BANG___52263$fn__52264 invoke "jetty10_core.clj" 785] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52258$start_webserver_BANG___52263 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$eval52726$start_BANG___52731$fn__52732 invoke "jetty10_core.clj" 1137] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52726$start_BANG___52731 invoke "jetty10_core.clj" 1132] [puppetlabs.trapperkeeper.services.webserver.jetty10_service$reify__53138$service_fnk__24305__auto___positional$reify__53145 start "jetty10_service.clj" 53] [puppetlabs.trapperkeeper.services$eval24103$fn__24130$G__24093__24133 invoke "services.clj" 7] [puppetlabs.trapperkeeper.services$eval24103$fn__24130$G__24092__24137 invoke "services.clj" 7] [puppetlabs.trapperkeeper.internal$eval24707$run_lifecycle_fn_BANG___24714$fn__24715 invoke "internal.clj" 242] [puppetlabs.trapperkeeper.internal$eval24707$run_lifecycle_fn_BANG___24714 invoke "internal.clj" 225] [puppetlabs.trapperkeeper.internal$eval24737$run_lifecycle_fns__24742$fn__24743 invoke "internal.clj" 275] [puppetlabs.trapperkeeper.internal$eval24737$run_lifecycle_fns__24742 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$eval43594$keystore__43599$fn__43600 invoke "core.clj" 733] [puppetlabs.ssl_utils.core$eval43594$keystore__43599 invoke "core.clj" 730] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50516$pem_ssl_config__GT_keystore_ssl_config__50521$fn__50525 invoke "jetty10_config.clj" 296] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50516$pem_ssl_config__GT_keystore_ssl_config__50521 invoke "jetty10_config.clj" 290] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50599$get_keystore_config_BANG___50604$fn__50605 invoke "jetty10_config.clj" 337] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50599$get_keystore_config_BANG___50604 invoke "jetty10_config.clj" 331] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50804$maybe_get_https_connector__50809$fn__50810 invoke "jetty10_config.clj" 423] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50804$maybe_get_https_connector__50809 invoke "jetty10_config.clj" 414] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50858$maybe_add_https_connector__50863$fn__50864 invoke "jetty10_config.clj" 445] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50858$maybe_add_https_connector__50863 invoke "jetty10_config.clj" 441] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50885$process_config__50890$fn__50891 invoke "jetty10_config.clj" 468] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50885$process_config__50890 invoke "jetty10_config.clj" 461] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52226$create_webserver__52231$fn__52232 invoke "jetty10_core.clj" 741] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52226$create_webserver__52231 invoke "jetty10_core.clj" 699] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52258$start_webserver_BANG___52263$fn__52264 invoke "jetty10_core.clj" 785] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52258$start_webserver_BANG___52263 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$eval52726$start_BANG___52731$fn__52732 invoke "jetty10_core.clj" 1137] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52726$start_BANG___52731 invoke "jetty10_core.clj" 1132] [puppetlabs.trapperkeeper.services.webserver.jetty10_service$reify__53138$service_fnk__24305__auto___positional$reify__53145 start "jetty10_service.clj" 53] [puppetlabs.trapperkeeper.services$eval24103$fn__24130$G__24093__24133 invoke "services.clj" 7] [puppetlabs.trapperkeeper.services$eval24103$fn__24130$G__24092__24137 invoke "services.clj" 7] [puppetlabs.trapperkeeper.internal$eval24707$run_lifecycle_fn_BANG___24714$fn__24715 invoke "internal.clj" 242] [puppetlabs.trapperkeeper.internal$eval24707$run_lifecycle_fn_BANG___24714 invoke "internal.clj" 225] [puppetlabs.trapperkeeper.internal$eval24737$run_lifecycle_fns__24742$fn__24743 invoke "internal.clj" 275] [puppetlabs.trapperkeeper.internal$eval24737$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$eval43594$keystore__43599$fn__43600 invoke "core.clj" 733] [puppetlabs.ssl_utils.core$eval43594$keystore__43599 invoke "core.clj" 730] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50516$pem_ssl_config__GT_keystore_ssl_config__50521$fn__50525 invoke "jetty10_config.clj" 296] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50516$pem_ssl_config__GT_keystore_ssl_config__50521 invoke "jetty10_config.clj" 290] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50599$get_keystore_config_BANG___50604$fn__50605 invoke "jetty10_config.clj" 337] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50599$get_keystore_config_BANG___50604 invoke "jetty10_config.clj" 331] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50804$maybe_get_https_connector__50809$fn__50810 invoke "jetty10_config.clj" 423] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50804$maybe_get_https_connector__50809 invoke "jetty10_config.clj" 414] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50858$maybe_add_https_connector__50863$fn__50864 invoke "jetty10_config.clj" 445] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50858$maybe_add_https_connector__50863 invoke "jetty10_config.clj" 441] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50885$process_config__50890$fn__50891 invoke "jetty10_config.clj" 468] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50885$process_config__50890 invoke "jetty10_config.clj" 461] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52226$create_webserver__52231$fn__52232 invoke "jetty10_core.clj" 741] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52226$create_webserver__52231 invoke "jetty10_core.clj" 699] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52258$start_webserver_BANG___52263$fn__52264 invoke "jetty10_core.clj" 785] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52258$start_webserver_BANG___52263 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$eval52726$start_BANG___52731$fn__52732 invoke "jetty10_core.clj" 1137] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52726$start_BANG___52731 invoke "jetty10_core.clj" 1132] [puppetlabs.trapperkeeper.services.webserver.jetty10_service$reify__53138$service_fnk__24305__auto___positional$reify__53145 start "jetty10_service.clj" 53] [puppetlabs.trapperkeeper.services$eval24103$fn__24130$G__24093__24133 invoke "services.clj" 7] [puppetlabs.trapperkeeper.services$eval24103$fn__24130$G__24092__24137 invoke "services.clj" 7] [puppetlabs.trapperkeeper.internal$eval24707$run_lifecycle_fn_BANG___24714$fn__24715 invoke "internal.clj" 242] [puppetlabs.trapperkeeper.internal$eval24707$run_lifecycle_fn_BANG___24714 invoke "internal.clj" 225] [puppetlabs.trapperkeeper.internal$eval24737$run_lifecycle_fns__24742$fn__24743 invoke "internal.clj" 275] [puppetlabs.trapperkeeper.internal$eval24737$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$eval43594$keystore__43599$fn__43600 invoke "core.clj" 733] [puppetlabs.ssl_utils.core$eval43594$keystore__43599 invoke "core.clj" 730] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50516$pem_ssl_config__GT_keystore_ssl_config__50521$fn__50525 invoke "jetty10_config.clj" 296] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50516$pem_ssl_config__GT_keystore_ssl_config__50521 invoke "jetty10_config.clj" 290] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50599$get_keystore_config_BANG___50604$fn__50605 invoke "jetty10_config.clj" 337] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50599$get_keystore_config_BANG___50604 invoke "jetty10_config.clj" 331] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50804$maybe_get_https_connector__50809$fn__50810 invoke "jetty10_config.clj" 423] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50804$maybe_get_https_connector__50809 invoke "jetty10_config.clj" 414] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50858$maybe_add_https_connector__50863$fn__50864 invoke "jetty10_config.clj" 445] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50858$maybe_add_https_connector__50863 invoke "jetty10_config.clj" 441] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50885$process_config__50890$fn__50891 invoke "jetty10_config.clj" 468] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50885$process_config__50890 invoke "jetty10_config.clj" 461] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52226$create_webserver__52231$fn__52232 invoke "jetty10_core.clj" 741] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52226$create_webserver__52231 invoke "jetty10_core.clj" 699] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52258$start_webserver_BANG___52263$fn__52264 invoke "jetty10_core.clj" 785] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52258$start_webserver_BANG___52263 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$eval52726$start_BANG___52731$fn__52732 invoke "jetty10_core.clj" 1137] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52726$start_BANG___52731 invoke "jetty10_core.clj" 1132] [puppetlabs.trapperkeeper.services.webserver.jetty10_service$reify__53138$service_fnk__24305__auto___positional$reify__53145 start "jetty10_service.clj" 53] [puppetlabs.trapperkeeper.services$eval24103$fn__24130$G__24093__24133 invoke "services.clj" 7] [puppetlabs.trapperkeeper.services$eval24103$fn__24130$G__24092__24137 invoke "services.clj" 7] [puppetlabs.trapperkeeper.internal$eval24707$run_lifecycle_fn_BANG___24714$fn__24715 invoke "internal.clj" 242] [puppetlabs.trapperkeeper.internal$eval24707$run_lifecycle_fn_BANG___24714 invoke "internal.clj" 225] [puppetlabs.trapperkeeper.internal$eval24737$run_lifecycle_fns__24742$fn__24743 invoke "internal.clj" 275] [puppetlabs.trapperkeeper.internal$eval24737$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$eval43594$keystore__43599$fn__43600 invoke "core.clj" 733] [puppetlabs.ssl_utils.core$eval43594$keystore__43599 invoke "core.clj" 730] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50516$pem_ssl_config__GT_keystore_ssl_config__50521$fn__50525 invoke "jetty10_config.clj" 296] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50516$pem_ssl_config__GT_keystore_ssl_config__50521 invoke "jetty10_config.clj" 290] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50599$get_keystore_config_BANG___50604$fn__50605 invoke "jetty10_config.clj" 337] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50599$get_keystore_config_BANG___50604 invoke "jetty10_config.clj" 331] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50804$maybe_get_https_connector__50809$fn__50810 invoke "jetty10_config.clj" 423] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50804$maybe_get_https_connector__50809 invoke "jetty10_config.clj" 414] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50858$maybe_add_https_connector__50863$fn__50864 invoke "jetty10_config.clj" 445] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50858$maybe_add_https_connector__50863 invoke "jetty10_config.clj" 441] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50885$process_config__50890$fn__50891 invoke "jetty10_config.clj" 468] [puppetlabs.trapperkeeper.services.webserver.jetty10_config$eval50885$process_config__50890 invoke "jetty10_config.clj" 461] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52226$create_webserver__52231$fn__52232 invoke "jetty10_core.clj" 741] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52226$create_webserver__52231 invoke "jetty10_core.clj" 699] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52258$start_webserver_BANG___52263$fn__52264 invoke "jetty10_core.clj" 785] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52258$start_webserver_BANG___52263 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$eval52726$start_BANG___52731$fn__52732 invoke "jetty10_core.clj" 1137] [puppetlabs.trapperkeeper.services.webserver.jetty10_core$eval52726$start_BANG___52731 invoke "jetty10_core.clj" 1132] [puppetlabs.trapperkeeper.services.webserver.jetty10_service$reify__53138$service_fnk__24305__auto___positional$reify__53145 start "jetty10_service.clj" 53] [puppetlabs.trapperkeeper.services$eval24103$fn__24130$G__24093__24133 invoke "services.clj" 7] [puppetlabs.trapperkeeper.services$eval24103$fn__24130$G__24092__24137 invoke "services.clj" 7] [puppetlabs.trapperkeeper.internal$eval24707$run_lifecycle_fn_BANG___24714$fn__24715 invoke "internal.clj" 242] [puppetlabs.trapperkeeper.internal$eval24707$run_lifecycle_fn_BANG___24714 invoke "internal.clj" 225] [puppetlabs.trapperkeeper.internal$eval24737$run_lifecycle_fns__24742$fn__24743 invoke "internal.clj" 275] [puppetlabs.trapperkeeper.internal$eval24737$run_lifecycle_fns__24742 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]]}))