search

crowdsecurity / example-docker-compose

Example integration of crowdsec in docker-compose
114 stars 25 forks source link

Metabase: [SQLITE_CANTOPEN] Unable to open the database file #8

Closed OdinGitDat closed 1 year ago

OdinGitDat commented 2 years ago

I have set up my docker compose similar to the example, but Metabase is unable to show any dashboard resources citing the error "[SQLITE_CANTOPEN] Unable to open the database file"

Log:

Warning: environ value jdk-11.0.14+9 for key :java-version has been overwritten with 11.0.14
WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.
2022-02-16 09:50:58,925 INFO metabase.util :: Maximum memory available to JVM: 15.7 GB
2022-02-16 09:51:12,217 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance. 🔓 
 For more information, see https://metabase.com/docs/latest/operations-guide/encrypting-database-details-at-rest.html
2022-02-16 09:51:15,174 INFO driver.impl :: Registered abstract driver :sql  🚚
 ⮦ Load driver :sql took 699.2 ms
2022-02-16 09:51:15,185 INFO driver.impl :: Registered abstract driver :sql-jdbc (parents: [:sql]) 🚚
Load driver :sql-jdbc took 715.2 ms
2022-02-16 09:51:15,190 INFO driver.impl :: Registered driver :h2 (parents: [:sql-jdbc]) 🚚
2022-02-16 09:51:15,212 INFO driver.impl :: Registered driver :mysql (parents: [:sql-jdbc]) 🚚
2022-02-16 09:51:15,232 INFO driver.impl :: Registered driver :postgres (parents: [:sql-jdbc]) 🚚
2022-02-16 09:51:17,780 INFO metabase.core :: 
Metabase v0.42.0 (de1264e release-x.42.x) 

Copyright © 2022 Metabase, Inc. 

Metabase Enterprise Edition extensions are NOT PRESENT.
2022-02-16 09:51:17,790 INFO metabase.core :: Starting Metabase in STANDALONE mode
2022-02-16 09:51:17,833 INFO metabase.server :: Launching Embedded Jetty Webserver with config: 
 {:port 3000, :host "0.0.0.0"}

2022-02-16 09:51:17,871 INFO metabase.core :: Starting Metabase version v0.42.0 (de1264e release-x.42.x) ...
2022-02-16 09:51:17,912 INFO metabase.core :: System info:
 {"file.encoding" "UTF-8",
 "java.runtime.name" "OpenJDK Runtime Environment",
 "java.runtime.version" "11.0.14+9",
 "java.vendor" "Eclipse Adoptium",
 "java.vendor.url" "https://adoptium.net/",
 "java.version" "11.0.14",
 "java.vm.name" "OpenJDK 64-Bit Server VM",
 "java.vm.version" "11.0.14+9",
 "os.name" "Linux",
 "os.version" "5.13.19-2-pve",
 "user.language" "en",
 "user.timezone" "GMT"}

2022-02-16 09:51:17,913 INFO metabase.plugins :: Loading plugins in /plugins...
2022-02-16 09:51:18,122 INFO util.files :: Extract file /modules/googleanalytics.metabase-driver.jar -> /plugins/googleanalytics.metabase-driver.jar
2022-02-16 09:51:18,136 INFO util.files :: Extract file /modules/presto-jdbc.metabase-driver.jar -> /plugins/presto-jdbc.metabase-driver.jar
2022-02-16 09:51:18,216 INFO util.files :: Extract file /modules/redshift.metabase-driver.jar -> /plugins/redshift.metabase-driver.jar
2022-02-16 09:51:18,226 INFO util.files :: Extract file /modules/sparksql.metabase-driver.jar -> /plugins/sparksql.metabase-driver.jar
2022-02-16 09:51:18,603 INFO util.files :: Extract file /modules/oracle.metabase-driver.jar -> /plugins/oracle.metabase-driver.jar
2022-02-16 09:51:18,605 INFO util.files :: Extract file /modules/sqlite.metabase-driver.jar -> /plugins/sqlite.metabase-driver.jar
2022-02-16 09:51:18,627 INFO util.files :: Extract file /modules/vertica.metabase-driver.jar -> /plugins/vertica.metabase-driver.jar
2022-02-16 09:51:18,628 INFO util.files :: Extract file /modules/snowflake.metabase-driver.jar -> /plugins/snowflake.metabase-driver.jar
2022-02-16 09:51:18,829 INFO util.files :: Extract file /modules/presto-common.metabase-driver.jar -> /plugins/presto-common.metabase-driver.jar
2022-02-16 09:51:18,830 INFO util.files :: Extract file /modules/druid.metabase-driver.jar -> /plugins/druid.metabase-driver.jar
2022-02-16 09:51:18,835 INFO util.files :: Extract file /modules/google.metabase-driver.jar -> /plugins/google.metabase-driver.jar
2022-02-16 09:51:18,846 INFO util.files :: Extract file /modules/presto.metabase-driver.jar -> /plugins/presto.metabase-driver.jar
2022-02-16 09:51:18,848 INFO util.files :: Extract file /modules/mongo.metabase-driver.jar -> /plugins/mongo.metabase-driver.jar
2022-02-16 09:51:18,870 INFO util.files :: Extract file /modules/sqlserver.metabase-driver.jar -> /plugins/sqlserver.metabase-driver.jar
2022-02-16 09:51:18,881 INFO util.files :: Extract file /modules/bigquery.metabase-driver.jar -> /plugins/bigquery.metabase-driver.jar
2022-02-16 09:51:18,887 INFO util.files :: Extract file /modules/bigquery-cloud-sdk.metabase-driver.jar -> /plugins/bigquery-cloud-sdk.metabase-driver.jar
2022-02-16 09:51:19,160 INFO plugins.dependencies :: Metabase cannot initialize plugin Metabase Oracle Driver due to required dependencies. Metabase requires the Oracle JDBC driver in order to connect to Oracle databases, but we can't ship it as part of Metabase due to licensing restrictions. See https://metabase.com/docs/latest/administration-guide/databases/oracle.html for more details.

2022-02-16 09:51:19,162 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
2022-02-16 09:51:19,169 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Oracle Driver"]
2022-02-16 09:51:19,201 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :snowflake...
2022-02-16 09:51:19,202 INFO driver.impl :: Registered driver :snowflake (parents: [:sql-jdbc]) 🚚
2022-02-16 09:51:19,208 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlserver...
2022-02-16 09:51:19,209 INFO driver.impl :: Registered driver :sqlserver (parents: [:sql-jdbc]) 🚚
2022-02-16 09:51:19,214 INFO plugins.dependencies :: Metabase cannot initialize plugin Metabase Vertica Driver due to required dependencies. Metabase requires the Vertica JDBC driver in order to connect to Vertica databases, but we can't ship it as part of Metabase due to licensing restrictions. See https://metabase.com/docs/latest/administration-guide/databases/vertica.html for more details.

2022-02-16 09:51:19,215 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
2022-02-16 09:51:19,216 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Vertica Driver" "Metabase Oracle Driver"]
2022-02-16 09:51:19,221 INFO plugins.dependencies :: Plugin 'Metabase Presto Driver' depends on plugin 'Presto Common Driver'
2022-02-16 09:51:19,221 INFO plugins.dependencies :: Metabase Presto Driver dependency {:plugin Presto Common Driver} satisfied? false
2022-02-16 09:51:19,222 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Vertica Driver" "Metabase Oracle Driver" "Metabase Presto Driver"]
2022-02-16 09:51:19,225 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlite...
2022-02-16 09:51:19,226 INFO driver.impl :: Registered driver :sqlite (parents: [:sql-jdbc]) 🚚
2022-02-16 09:51:19,230 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto-common...
2022-02-16 09:51:19,230 INFO driver.impl :: Registered abstract driver :presto-common  🚚
2022-02-16 09:51:19,231 INFO plugins.dependencies :: Metabase Presto Driver dependency {:plugin Presto Common Driver} satisfied? true
2022-02-16 09:51:19,232 DEBUG plugins.initialize :: Dependencies satisfied; these plugins will now be loaded: ["Metabase Presto Driver"]
2022-02-16 09:51:19,233 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto...
2022-02-16 09:51:19,233 INFO driver.impl :: Registered driver :presto (parents: [:presto-common]) 🚚
2022-02-16 09:51:19,241 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :mongo...
2022-02-16 09:51:19,241 INFO driver.impl :: Registered driver :mongo  🚚
2022-02-16 09:51:19,246 INFO plugins.dependencies :: Plugin 'Metabase BigQuery Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
2022-02-16 09:51:19,246 INFO plugins.dependencies :: Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? false
2022-02-16 09:51:19,247 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Vertica Driver" "Metabase BigQuery Driver" "Metabase Oracle Driver"]
2022-02-16 09:51:19,250 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :google...
2022-02-16 09:51:19,250 INFO driver.impl :: Registered abstract driver :google  🚚
2022-02-16 09:51:19,251 INFO plugins.dependencies :: Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
2022-02-16 09:51:19,252 DEBUG plugins.initialize :: Dependencies satisfied; these plugins will now be loaded: ["Metabase BigQuery Driver"]
2022-02-16 09:51:19,253 WARN plugins.lazy-loaded-driver :: Warning: plugin manifest for :bigquery does not include connection properties
2022-02-16 09:51:19,253 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :bigquery...
2022-02-16 09:51:19,253 INFO driver.impl :: Registered driver :bigquery (parents: [:sql :google]) 🚚
2022-02-16 09:51:19,258 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :redshift...
2022-02-16 09:51:19,259 INFO driver.impl :: Registered driver :redshift (parents: [:postgres]) 🚚
2022-02-16 09:51:19,265 INFO plugins.dependencies :: Plugin 'Metabase Google Analytics Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
2022-02-16 09:51:19,266 INFO plugins.dependencies :: Metabase Google Analytics Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
2022-02-16 09:51:19,267 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :googleanalytics...
2022-02-16 09:51:19,268 INFO driver.impl :: Registered driver :googleanalytics (parents: [:google]) 🚚
2022-02-16 09:51:19,273 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :druid...
2022-02-16 09:51:19,273 INFO driver.impl :: Registered driver :druid  🚚
2022-02-16 09:51:19,312 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :hive-like...
2022-02-16 09:51:19,313 INFO driver.impl :: Registered abstract driver :hive-like (parents: [:sql-jdbc]) 🚚
2022-02-16 09:51:19,314 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sparksql...
2022-02-16 09:51:19,314 INFO driver.impl :: Registered driver :sparksql (parents: [:hive-like]) 🚚
2022-02-16 09:51:19,330 INFO plugins.dependencies :: Plugin 'Metabase Presto JDBC Driver' depends on plugin 'Presto Common Driver'
2022-02-16 09:51:19,331 INFO plugins.dependencies :: Metabase Presto JDBC Driver dependency {:plugin Presto Common Driver} satisfied? true
2022-02-16 09:51:19,331 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto-jdbc...
2022-02-16 09:51:19,332 INFO driver.impl :: Registered driver :presto-jdbc (parents: [:presto-common]) 🚚
2022-02-16 09:51:19,342 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :bigquery-cloud-sdk...
2022-02-16 09:51:19,343 INFO driver.impl :: Registered driver :bigquery-cloud-sdk (parents: [:sql]) 🚚
2022-02-16 09:51:19,344 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
2022-02-16 09:51:19,346 WARN db.env :: WARNING: Using Metabase with an H2 application database is not recommended for production deployments. For production deployments, we highly recommend using Postgres, MySQL, or MariaDB instead. If you decide to continue to use H2, please be sure to back up the database file regularly. For more information, see https://metabase.com/docs/latest/operations-guide/migrating-from-h2.html
2022-02-16 09:51:19,350 INFO db.setup :: Verifying h2 Database Connection ...
2022-02-16 09:51:19,696 INFO db.setup :: Successfully verified H2 1.4.197 (2018-03-18) application database connection. ✅
2022-02-16 09:51:19,696 INFO db.setup :: Running Database Migrations...
2022-02-16 09:51:19,698 INFO db.setup :: Setting up Liquibase...
2022-02-16 09:51:19,742 INFO db.setup :: Liquibase is ready.
2022-02-16 09:51:19,743 INFO db.liquibase :: Checking if Database has unrun migrations...
2022-02-16 09:51:21,510 INFO db.liquibase :: Database has unrun migrations. Waiting for migration lock to be cleared...
2022-02-16 09:51:21,538 INFO db.liquibase :: Migration lock is cleared. Running migrations...
2022-02-16 09:51:22,840 INFO db.setup :: Database Migrations Current ...  ✅
2022-02-16 09:51:22,862 INFO db.data-migrations :: Running all necessary data migrations, this may take a minute.
2022-02-16 09:51:22,874 INFO db.data-migrations :: Running data migration 'migrate-click-through'...
2022-02-16 09:51:22,892 INFO db.data-migrations :: Finished running data migrations.
Database setup took 3.5 s
2022-02-16 09:51:23,089 INFO metabase.events :: Starting events listener: :metabase.events.dependencies/Dependencies 👂
2022-02-16 09:51:23,096 INFO metabase.events :: Starting events listener: :metabase.events.activity-feed/ActivityFeed 👂
2022-02-16 09:51:23,098 INFO metabase.events :: Starting events listener: :metabase.events.last-login/LastLogin 👂
2022-02-16 09:51:23,099 INFO metabase.events :: Starting events listener: :metabase.events.notifications/Notifications 👂
2022-02-16 09:51:23,100 INFO metabase.events :: Starting events listener: :metabase.events.sync-database/Sync 👂
2022-02-16 09:51:23,101 INFO metabase.events :: Starting events listener: :metabase.events.driver-notifications/DriverNotifications 👂
2022-02-16 09:51:23,101 INFO metabase.events :: Starting events listener: :metabase.events.revision/Revisions 👂
2022-02-16 09:51:23,102 INFO metabase.events :: Starting events listener: :metabase.events.view-log/ViewLog 👂
2022-02-16 09:51:23,365 INFO metabase.task :: Initializing task SyncDatabases 📆
2022-02-16 09:51:23,482 INFO task.send-pulses :: Sending scheduled pulses...
2022-02-16 09:51:23,536 INFO models.database :: :sqlite Database 'Crowdsec' sync/analyze schedules have changed! 
 Sync metadata was: '0 0 * * * ? *' is now: '0 1 * * * ? *' 
 Cache FieldValues was: '0 0 0 * * ? *', is now: '0 0 0 * * ? *'
2022-02-16 09:51:23,569 INFO task.sync-databases :: Scheduling sync/analyze for database 2: trigger: metabase.task.sync-and-analyze.trigger.2
2022-02-16 09:51:23,576 INFO driver.impl :: Initializing driver :sql...
2022-02-16 09:51:23,577 INFO driver.impl :: Initializing driver :sql-jdbc...
2022-02-16 09:51:23,578 INFO driver.impl :: Initializing driver :h2...
2022-02-16 09:51:23,602 INFO metabase.task :: Initializing task CheckForNewVersions 📆
2022-02-16 09:51:23,616 INFO metabase.task :: Initializing task SendAnonymousUsageStats 📆
2022-02-16 09:51:23,624 INFO metabase.task :: Initializing task SendAbandomentEmails 📆
2022-02-16 09:51:23,633 INFO metabase.task :: Initializing task SendPulses 📆
2022-02-16 09:51:23,640 INFO metabase.task :: Initializing task SendFollowUpEmails 📆
2022-02-16 09:51:23,648 INFO metabase.task :: Initializing task TaskHistoryCleanup 📆
2022-02-16 09:51:23,658 INFO metabase.core :: Metabase Initialization COMPLETE
2022-02-16 09:51:42,415 DEBUG middleware.log :: POST /api/dataset 401 4.2 ms (0 DB calls) 
"Unauthenticated"

2022-02-16 09:51:55,473 DEBUG middleware.log :: POST /api/session 200 1.3 s (7 DB calls) App DB connections: 0/7 Jetty threads: 6/50 (1 idle, 0 queued) (39 total active threads) Queries in flight: 0 (0 queued)
2022-02-16 09:51:55,579 INFO i18n.impl :: Reading available locales from locales.clj...
2022-02-16 09:51:55,617 DEBUG middleware.log :: GET /api/session/properties 200 89.0 ms (13 DB calls) App DB connections: 0/7 Jetty threads: 7/50 (0 idle, 0 queued) (39 total active threads) Queries in flight: 0 (0 queued)
2022-02-16 09:51:55,817 DEBUG middleware.log :: GET /api/user/current 200 304.3 ms (4 DB calls) App DB connections: 0/7 Jetty threads: 6/50 (1 idle, 0 queued) (40 total active threads) Queries in flight: 0 (0 queued)
2022-02-16 09:52:04,883 INFO driver.impl :: Initializing driver :sqlite...
2022-02-16 09:52:04,885 INFO plugins.classloader :: Added URL file:/plugins/sqlite.metabase-driver.jar to classpath
2022-02-16 09:52:04,885 DEBUG plugins.init-steps :: Loading plugin namespace metabase.driver.sqlite...
2022-02-16 09:52:04,892 INFO driver.impl :: Registered driver :sqlite (parents: [:sql-jdbc]) 🚚
2022-02-16 09:52:04,913 DEBUG plugins.jdbc-proxy :: Registering JDBC proxy driver for org.sqlite.JDBC...
Load lazy loading driver :sqlite took 28.6 ms
2022-02-16 09:52:36,073 ERROR middleware.catch-exceptions :: Error processing query: null
{:database_id 2,
 :started_at #t "2022-02-16T09:52:04.853145Z[GMT]",
 :via
 [{:status :failed,
   :class com.mchange.v2.resourcepool.CannotAcquireResourceException,
   :error "A ResourcePool could not acquire a resource from its primary factory or source.",
   :stacktrace
   ["com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1507)"
    "com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)"
    "com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)"
    "com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)"
    "com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685)"
    "com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)"
    "--> driver.sqlite$fn__95428.invokeStatic(sqlite.clj:355)"
    "driver.sqlite$fn__95428.invoke(sqlite.clj:353)"
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:499)"
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)"
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:496)"
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)"
    "driver.sql_jdbc$fn__81915.invokeStatic(sql_jdbc.clj:54)"
    "driver.sql_jdbc$fn__81915.invoke(sql_jdbc.clj:52)"
    "query_processor.context$executef.invokeStatic(context.clj:59)"
    "query_processor.context$executef.invoke(context.clj:48)"
    "query_processor.context.default$default_runf.invokeStatic(default.clj:68)"
    "query_processor.context.default$default_runf.invoke(default.clj:66)"
    "query_processor.context$runf.invokeStatic(context.clj:45)"
    "query_processor.context$runf.invoke(context.clj:39)"
    "query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
    "query_processor.reducible$pivot.invoke(reducible.clj:31)"
    "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__49659.invoke(mbql_to_native.clj:25)"
    "query_processor.middleware.check_features$check_features$fn__50405.invoke(check_features.clj:42)"
    "query_processor.middleware.limit$limit$fn__48032.invoke(limit.clj:37)"
    "query_processor.middleware.cache$maybe_return_cached_results$fn__50788.invoke(cache.clj:204)"
    "query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__51821.invoke(optimize_temporal_filters.clj:204)"
    "query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__51865.invoke(validate_temporal_bucketing.clj:50)"
    "query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__49716.invoke(auto_parse_filter_values.clj:43)"
    "query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__39821.invoke(wrap_value_literals.clj:161)"
    "query_processor.middleware.annotate$add_column_info$fn__44587.invoke(annotate.clj:659)"
    "query_processor.middleware.permissions$check_query_permissions$fn__46329.invoke(permissions.clj:108)"
    "query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__51010.invoke(pre_alias_aggregations.clj:40)"
    "query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__46725.invoke(cumulative_aggregations.clj:60)"
    "query_processor.middleware.visualization_settings$update_viz_settings$fn__46663.invoke(visualization_settings.clj:63)"
    "query_processor.middleware.fix_bad_references$fix_bad_references_middleware$fn__50975.invoke(fix_bad_references.clj:91)"
    "query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47610.invoke(resolve_joined_fields.clj:111)"
    "query_processor.middleware.resolve_joins$resolve_joins$fn__51591.invoke(resolve_joins.clj:176)"
    "query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__51133.invoke(add_implicit_joins.clj:202)"
    "query_processor.middleware.large_int_id$convert_id_to_string$fn__47629.invoke(large_int_id.clj:59)"
    "query_processor.middleware.format_rows$format_rows$fn__51185.invoke(format_rows.clj:74)"
    "query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__46997.invoke(add_default_temporal_unit.clj:23)"
    "query_processor.middleware.desugar$desugar$fn__46636.invoke(desugar.clj:21)"
    "query_processor.middleware.binning$update_binning_strategy$fn__39550.invoke(binning.clj:229)"
    "query_processor.middleware.resolve_fields$resolve_fields$fn__45971.invoke(resolve_fields.clj:34)"
    "query_processor.middleware.add_dimension_projections$add_remapping$fn__50342.invoke(add_dimension_projections.clj:487)"
    "query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__50636.invoke(add_implicit_clauses.clj:164)"
    "query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__48017.invoke(upgrade_field_literals.clj:117)"
    "query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__47374.invoke(add_source_metadata.clj:125)"
    "query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__50887.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)"
    "query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__48974.invoke(auto_bucket_datetimes.clj:147)"
    "query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45952.invoke(resolve_source_table.clj:45)"
    "query_processor.middleware.parameters$substitute_parameters$fn__48628.invoke(parameters.clj:111)"
    "query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__46025.invoke(resolve_referenced.clj:79)"
    "query_processor.middleware.expand_macros$expand_macros$fn__52249.invoke(expand_macros.clj:184)"
    "query_processor.middleware.add_timezone_info$add_timezone_info$fn__48407.invoke(add_timezone_info.clj:15)"
    "query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__51200.invoke(splice_params_in_response.clj:32)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50647$fn__50652.invoke(resolve_database_and_driver.clj:35)"
    "driver$do_with_driver.invokeStatic(driver.clj:60)"
    "driver$do_with_driver.invoke(driver.clj:56)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50647.invoke(resolve_database_and_driver.clj:34)"
    "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46571.invoke(fetch_source_query.clj:286)"
    "query_processor.middleware.store$initialize_store$fn__46762$fn__46763.invoke(store.clj:11)"
    "query_processor.store$do_with_store.invokeStatic(store.clj:44)"
    "query_processor.store$do_with_store.invoke(store.clj:38)"
    "query_processor.middleware.store$initialize_store$fn__46762.invoke(store.clj:10)"
    "query_processor.middleware.validate$validate_query$fn__50982.invoke(validate.clj:10)"
    "query_processor.middleware.normalize_query$normalize$fn__50989.invoke(normalize_query.clj:22)"
    "query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__48353.invoke(add_rows_truncated.clj:35)"
    "query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49645.invoke(results_metadata.clj:82)"
    "query_processor.middleware.constraints$add_default_userland_constraints$fn__48371.invoke(constraints.clj:42)"
    "query_processor.middleware.process_userland_query$process_userland_query$fn__50923.invoke(process_userland_query.clj:146)"
    "query_processor.middleware.catch_exceptions$catch_exceptions$fn__51280.invoke(catch_exceptions.clj:169)"
    "query_processor.reducible$async_qp$qp_STAR___43323$thunk__43324.invoke(reducible.clj:103)"
    "query_processor.reducible$async_qp$qp_STAR___43323.invoke(reducible.clj:109)"
    "query_processor.reducible$sync_qp$qp_STAR___43332$fn__43335.invoke(reducible.clj:135)"
    "query_processor.reducible$sync_qp$qp_STAR___43332.invoke(reducible.clj:134)"
    "query_processor$process_userland_query.invokeStatic(query_processor.clj:245)"
    "query_processor$process_userland_query.doInvoke(query_processor.clj:241)"
    "query_processor$fn__52297$process_query_and_save_execution_BANG___52306$fn__52309.invoke(query_processor.clj:256)"
    "query_processor$fn__52297$process_query_and_save_execution_BANG___52306.invoke(query_processor.clj:249)"
    "query_processor$fn__52341$process_query_and_save_with_max_results_constraints_BANG___52350$fn__52353.invoke(query_processor.clj:268)"
    "query_processor$fn__52341$process_query_and_save_with_max_results_constraints_BANG___52350.invoke(query_processor.clj:261)"
    "api.dataset$run_query_async$fn__65276.invoke(dataset.clj:69)"
    "query_processor.streaming$streaming_response_STAR_$fn__38459$fn__38460.invoke(streaming.clj:162)"
    "query_processor.streaming$streaming_response_STAR_$fn__38459.invoke(streaming.clj:161)"
    "async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:65)"
    "async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:63)"
    "async.streaming_response$do_f_async$task__26889.invoke(streaming_response.clj:84)"]}
  {:status :failed,
   :class java.sql.SQLException,
   :error "Connections could not be acquired from the underlying database!",
   :stacktrace
   ["com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)"
    "com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692)"
    "com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)"
    "--> driver.sqlite$fn__95428.invokeStatic(sqlite.clj:355)"
    "driver.sqlite$fn__95428.invoke(sqlite.clj:353)"
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:499)"
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)"
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:496)"
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)"
    "driver.sql_jdbc$fn__81915.invokeStatic(sql_jdbc.clj:54)"
    "driver.sql_jdbc$fn__81915.invoke(sql_jdbc.clj:52)"
    "query_processor.context$executef.invokeStatic(context.clj:59)"
    "query_processor.context$executef.invoke(context.clj:48)"
    "query_processor.context.default$default_runf.invokeStatic(default.clj:68)"
    "query_processor.context.default$default_runf.invoke(default.clj:66)"
    "query_processor.context$runf.invokeStatic(context.clj:45)"
    "query_processor.context$runf.invoke(context.clj:39)"
    "query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
    "query_processor.reducible$pivot.invoke(reducible.clj:31)"
    "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__49659.invoke(mbql_to_native.clj:25)"
    "query_processor.middleware.check_features$check_features$fn__50405.invoke(check_features.clj:42)"
    "query_processor.middleware.limit$limit$fn__48032.invoke(limit.clj:37)"
    "query_processor.middleware.cache$maybe_return_cached_results$fn__50788.invoke(cache.clj:204)"
    "query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__51821.invoke(optimize_temporal_filters.clj:204)"
    "query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__51865.invoke(validate_temporal_bucketing.clj:50)"
    "query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__49716.invoke(auto_parse_filter_values.clj:43)"
    "query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__39821.invoke(wrap_value_literals.clj:161)"
    "query_processor.middleware.annotate$add_column_info$fn__44587.invoke(annotate.clj:659)"
    "query_processor.middleware.permissions$check_query_permissions$fn__46329.invoke(permissions.clj:108)"
    "query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__51010.invoke(pre_alias_aggregations.clj:40)"
    "query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__46725.invoke(cumulative_aggregations.clj:60)"
    "query_processor.middleware.visualization_settings$update_viz_settings$fn__46663.invoke(visualization_settings.clj:63)"
    "query_processor.middleware.fix_bad_references$fix_bad_references_middleware$fn__50975.invoke(fix_bad_references.clj:91)"
    "query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47610.invoke(resolve_joined_fields.clj:111)"
    "query_processor.middleware.resolve_joins$resolve_joins$fn__51591.invoke(resolve_joins.clj:176)"
    "query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__51133.invoke(add_implicit_joins.clj:202)"
    "query_processor.middleware.large_int_id$convert_id_to_string$fn__47629.invoke(large_int_id.clj:59)"
    "query_processor.middleware.format_rows$format_rows$fn__51185.invoke(format_rows.clj:74)"
    "query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__46997.invoke(add_default_temporal_unit.clj:23)"
    "query_processor.middleware.desugar$desugar$fn__46636.invoke(desugar.clj:21)"
    "query_processor.middleware.binning$update_binning_strategy$fn__39550.invoke(binning.clj:229)"
    "query_processor.middleware.resolve_fields$resolve_fields$fn__45971.invoke(resolve_fields.clj:34)"
    "query_processor.middleware.add_dimension_projections$add_remapping$fn__50342.invoke(add_dimension_projections.clj:487)"
    "query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__50636.invoke(add_implicit_clauses.clj:164)"
    "query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__48017.invoke(upgrade_field_literals.clj:117)"
    "query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__47374.invoke(add_source_metadata.clj:125)"
    "query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__50887.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)"
    "query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__48974.invoke(auto_bucket_datetimes.clj:147)"
    "query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45952.invoke(resolve_source_table.clj:45)"
    "query_processor.middleware.parameters$substitute_parameters$fn__48628.invoke(parameters.clj:111)"
    "query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__46025.invoke(resolve_referenced.clj:79)"
    "query_processor.middleware.expand_macros$expand_macros$fn__52249.invoke(expand_macros.clj:184)"
    "query_processor.middleware.add_timezone_info$add_timezone_info$fn__48407.invoke(add_timezone_info.clj:15)"
    "query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__51200.invoke(splice_params_in_response.clj:32)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50647$fn__50652.invoke(resolve_database_and_driver.clj:35)"
    "driver$do_with_driver.invokeStatic(driver.clj:60)"
    "driver$do_with_driver.invoke(driver.clj:56)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50647.invoke(resolve_database_and_driver.clj:34)"
    "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46571.invoke(fetch_source_query.clj:286)"
    "query_processor.middleware.store$initialize_store$fn__46762$fn__46763.invoke(store.clj:11)"
    "query_processor.store$do_with_store.invokeStatic(store.clj:44)"
    "query_processor.store$do_with_store.invoke(store.clj:38)"
    "query_processor.middleware.store$initialize_store$fn__46762.invoke(store.clj:10)"
    "query_processor.middleware.validate$validate_query$fn__50982.invoke(validate.clj:10)"
    "query_processor.middleware.normalize_query$normalize$fn__50989.invoke(normalize_query.clj:22)"
    "query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__48353.invoke(add_rows_truncated.clj:35)"
    "query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49645.invoke(results_metadata.clj:82)"
    "query_processor.middleware.constraints$add_default_userland_constraints$fn__48371.invoke(constraints.clj:42)"
    "query_processor.middleware.process_userland_query$process_userland_query$fn__50923.invoke(process_userland_query.clj:146)"
    "query_processor.middleware.catch_exceptions$catch_exceptions$fn__51280.invoke(catch_exceptions.clj:169)"
    "query_processor.reducible$async_qp$qp_STAR___43323$thunk__43324.invoke(reducible.clj:103)"
    "query_processor.reducible$async_qp$qp_STAR___43323.invoke(reducible.clj:109)"
    "query_processor.reducible$sync_qp$qp_STAR___43332$fn__43335.invoke(reducible.clj:135)"
    "query_processor.reducible$sync_qp$qp_STAR___43332.invoke(reducible.clj:134)"
    "query_processor$process_userland_query.invokeStatic(query_processor.clj:245)"
    "query_processor$process_userland_query.doInvoke(query_processor.clj:241)"
    "query_processor$fn__52297$process_query_and_save_execution_BANG___52306$fn__52309.invoke(query_processor.clj:256)"
    "query_processor$fn__52297$process_query_and_save_execution_BANG___52306.invoke(query_processor.clj:249)"
    "query_processor$fn__52341$process_query_and_save_with_max_results_constraints_BANG___52350$fn__52353.invoke(query_processor.clj:268)"
    "query_processor$fn__52341$process_query_and_save_with_max_results_constraints_BANG___52350.invoke(query_processor.clj:261)"
    "api.dataset$run_query_async$fn__65276.invoke(dataset.clj:69)"
    "query_processor.streaming$streaming_response_STAR_$fn__38459$fn__38460.invoke(streaming.clj:162)"
    "query_processor.streaming$streaming_response_STAR_$fn__38459.invoke(streaming.clj:161)"
    "async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:65)"
    "async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:63)"
    "async.streaming_response$do_f_async$task__26889.invoke(streaming_response.clj:84)"],
   :state nil}],

the-lazy-fox commented 2 years ago

Hello @OdinGitDat Did you solve it? I have the same issue. Thank you!

OdinGitDat commented 2 years ago

Unfortunately not, I gave up.

the-lazy-fox commented 2 years ago

OK I've found the solution. You need to run the same GID/MGID on crowsec service and dashboard. I've used 1000, cleaned all files and restarted and now it works.