Database user privileges revoked

Kanat · March 29, 2023, 3:48pm

Hi,

Experiencing some strange behavior. I have multiple views in postgres. When I execute api post requests somehow it changes privileges for that user to access some views and leaving access to other views.

Last one was when I created database using post api/database request.

Luiggi · March 29, 2023, 8:37pm

please post diagnostic info and reproduction steps

Kanat · March 30, 2023, 7:34am

[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:20+06:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 22.1 ms (1 DB calls) App DB connections: 1/4 Jetty threads: 6/50 (1 idle, 0 queued) (58 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:34+06:00 DEBUG metabase.server.middleware.log POST /api/session 200 99.4 ms (7 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (1 idle, 0 queued) (60 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:48+06:00 INFO metabase.task.sync-databases Scheduling sync/analyze for database 2: trigger: metabase.task.sync-and-analyze.trigger.2
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:48+06:00 INFO metabase.task.sync-databases Scheduling field-values for database 2: trigger: metabase.task.update-field-values.trigger.2
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:48+06:00 DEBUG metabase.server.middleware.log POST /api/database 200 64.2 ms (7 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (1 idle, 0 queued) (61 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:48+06:00 INFO metabase.sync.util STARTING: Sync metadata for postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:48+06:00 INFO metabase.sync.util STARTING: Sync postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:48+06:00 INFO metabase.sync.util STARTING: step 'sync-timezone' for postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:48+06:00 INFO metabase.sync.util FINISHED: step 'sync-timezone' for postgres Database 2 'iDempiere' (41.6 ms)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:48+06:00 INFO metabase.sync.util STARTING: step 'sync-tables' for postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:50+06:00 INFO metabase.sync.sync-metadata.tables Found new tables: (Table 'adempiere.bi_m_storage_on_hand' Table 'adempiere.bi_m_sales_order' Table 'adempiere.bi_m_material_receipt' Table 'adempiere.bi_m_purchase_order' Table 'adempiere.bi_m_material_shipment' Table 'adempiere.bi_m_sales_opportunity' Table 'adempiere.bi_m_lead' Table 'adempiere.bi_m_production')
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:50+06:00 INFO metabase.sync.sync-metadata.tables Updating description for tables: (Table 'adempiere.bi_m_sales_order' Table 'adempiere.bi_m_material_receipt' Table 'adempiere.bi_m_material_shipment' Table 'adempiere.bi_m_purchase_order' Table 'adempiere.bi_m_lead' Table 'adempiere.bi_m_sales_opportunity' Table 'adempiere.bi_m_storage_on_hand' Table 'adempiere.bi_m_production')
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:50+06:00 INFO metabase.sync.util FINISHED: step 'sync-tables' for postgres Database 2 'iDempiere' (1.8 s)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:50+06:00 INFO metabase.sync.util STARTING: step 'sync-fields' for postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:51+06:00 INFO metabase.sync.util FINISHED: step 'sync-fields' for postgres Database 2 'iDempiere' (470.5 ms)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:51+06:00 INFO metabase.sync.util STARTING: step 'sync-fks' for postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:51+06:00 INFO metabase.sync.util FINISHED: step 'sync-fks' for postgres Database 2 'iDempiere' (79.2 ms)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:51+06:00 INFO metabase.sync.util STARTING: step 'sync-metabase-metadata' for postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:55+06:00 INFO metabase.sync.util FINISHED: step 'sync-metabase-metadata' for postgres Database 2 'iDempiere' (4.2 s)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:55+06:00 INFO metabase.sync.util FINISHED: Sync metadata for postgres Database 2 'iDempiere' (6.6 s)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:55+06:00 INFO metabase.sync.util STARTING: Analyze data for postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:55+06:00 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:55+06:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [·············································] 12% Table 13 'adempiere.bi_m_material_shipment'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:55+06:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [·······································] 24% Table 14 'adempiere.bi_m_sales_opportunity'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:56+06:00 INFO metabase.sync.util FINISHED: step 'fingerprint-fields' for postgres Database 2 'iDempiere' (693.1 ms)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:56+06:00 INFO metabase.sync.util STARTING: step 'classify-fields' for postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:56+06:00 INFO metabase.sync.analyze classify-fields Analyzed [································] 36% Table 15 'adempiere.bi_m_lead'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:56+06:00 INFO metabase.sync.analyze classify-fields Analyzed [···························] 48% Table 16 'adempiere.bi_m_production'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:56+06:00 INFO metabase.sync.analyze classify-fields Analyzed [····················] 60% Table 10 'adempiere.bi_m_sales_order'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:56+06:00 INFO metabase.sync.util FINISHED: step 'classify-fields' for postgres Database 2 'iDempiere' (10.9 ms)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:56+06:00 INFO metabase.sync.util STARTING: step 'classify-tables' for postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:56+06:00 INFO metabase.sync.analyze classify-tables Analyzed [··············] 72% Table 11 'adempiere.bi_m_material_receipt'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:56+06:00 INFO metabase.sync.analyze classify-tables Analyzed [·········] 84% Table 12 'adempiere.bi_m_purchase_order'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:56+06:00 INFO metabase.sync.analyze classify-tables Analyzed [***********************···] 96% Table 9 'adempiere.bi_m_storage_on_hand'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:56+06:00 INFO metabase.sync.util FINISHED: step 'classify-tables' for postgres Database 2 'iDempiere' (23.8 ms)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:56+06:00 INFO metabase.sync.util FINISHED: Analyze data for postgres Database 2 'iDempiere' (756.8 ms)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:56+06:00 INFO metabase.sync.util STARTING: Cache field values in postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:56+06:00 INFO metabase.sync.util STARTING: step 'delete-expired-advanced-field-values' for postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:56+06:00 INFO metabase.sync.util FINISHED: step 'delete-expired-advanced-field-values' for postgres Database 2 'iDempiere' (330.9 ms)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:56+06:00 INFO metabase.sync.util STARTING: step 'update-field-values' for postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:56+06:00 INFO metabase.sync.util FINISHED: step 'update-field-values' for postgres Database 2 'iDempiere' (171.6 ms)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:56+06:00 INFO metabase.sync.util FINISHED: Cache field values in postgres Database 2 'iDempiere' (521.1 ms)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:33:56+06:00 INFO metabase.sync.util FINISHED: Sync postgres Database 2 'iDempiere' (7.9 s)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:34:01+06:00 DEBUG metabase.server.middleware.log GET /api/user/current 401 385.5 µs (0 DB calls)
"Unauthenticated"

[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:34:01+06:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 13.3 ms (1 DB calls) App DB connections: 0/4 Jetty threads: 7/50 (0 idle, 0 queued) (78 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:34:28+06:00 DEBUG metabase.server.middleware.log POST /api/session 200 95.0 ms (7 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (0 idle, 0 queued) (79 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:34:28+06:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 21.3 ms (9 DB calls) App DB connections: 1/4 Jetty threads: 6/50 (0 idle, 0 queued) (79 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:34:28+06:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 23.5 ms (8 DB calls) App DB connections: 0/4 Jetty threads: 6/50 (0 idle, 0 queued) (79 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:34:28+06:00 DEBUG metabase.server.middleware.log GET /api/database 200 12.8 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 8/50 (0 idle, 0 queued) (81 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:34:28+06:00 DEBUG metabase.server.middleware.log GET /api/bookmark 200 34.3 ms (1 DB calls) App DB connections: 3/4 Jetty threads: 10/50 (1 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:34:28+06:00 DEBUG metabase.server.middleware.log GET /api/collection/tree 200 36.9 ms (6 DB calls) App DB connections: 1/4 Jetty threads: 10/50 (1 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:34:28+06:00 DEBUG metabase.server.middleware.log GET /api/activity/recent_views 200 27.9 ms (2 DB calls) App DB connections: 0/4 Jetty threads: 8/50 (1 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:34:28+06:00 DEBUG metabase.server.middleware.log GET /api/activity/popular_items 200 32.0 ms (2 DB calls) App DB connections: 0/4 Jetty threads: 6/50 (1 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:34:29+06:00 DEBUG metabase.server.middleware.log GET /api/collection/root 200 190.1 ms (2 DB calls) App DB connections: 0/4 Jetty threads: 6/50 (2 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:34:29+06:00 DEBUG metabase.server.middleware.log GET /api/automagic-dashboards/database/2/candidates 200 251.0 ms (6 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (2 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:34:29+06:00 WARN metabase.email Failed to send email
clojure.lang.ExceptionInfo: SMTP host is not set. {:cause :smtp-host-not-set}
at metabase.email$fn__59887$send_message_or_throw_BANG___59892$fn__59896.invoke(email.clj:113)
at metabase.email$fn__59887$send_message_or_throw_BANG___59892.invoke(email.clj:107)
at metabase.email$send_message_BANG_.invokeStatic(email.clj:150)
at metabase.email$send_message_BANG_.doInvoke(email.clj:136)
at clojure.lang.RestFn.invoke(RestFn.java:619)
at metabase.email.messages$send_login_from_new_device_email_BANG_.invokeStatic(messages.clj:210)
at metabase.email.messages$send_login_from_new_device_email_BANG_.invoke(messages.clj:196)
at metabase.models.login_history$maybe_send_login_from_new_device_email$fn__60792.invoke(login_history.clj:77)
at clojure.core$binding_conveyor_fn$fn__5823.invoke(core.clj:2047)
at clojure.lang.AFn.call(AFn.java:18)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:34:36+06:00 DEBUG metabase.server.middleware.log GET /api/setting 200 19.1 ms (3 DB calls) App DB connections: 1/4 Jetty threads: 6/50 (3 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:34:36+06:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 18.2 ms (4 DB calls) App DB connections: 0/4 Jetty threads: 6/50 (3 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:34:36+06:00 DEBUG metabase.server.middleware.log GET /api/setup/admin_checklist 200 25.8 ms (13 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (3 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:34:43+06:00 DEBUG metabase.server.middleware.log GET /api/util/bug_report_details 200 3.5 ms (1 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (3 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:34:55+06:00 DEBUG metabase.server.middleware.log GET /api/database 200 4.0 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (3 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:34:56+06:00 DEBUG metabase.server.middleware.log GET /api/database/2 200 10.6 ms (7 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (3 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:01+06:00 DEBUG metabase.server.middleware.log POST /api/database/2/sync_schema 200 7.9 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (3 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:01+06:00 INFO metabase.sync.util STARTING: Sync metadata for postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:01+06:00 INFO metabase.sync.util STARTING: step 'sync-timezone' for postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:01+06:00 INFO metabase.sync.util FINISHED: step 'sync-timezone' for postgres Database 2 'iDempiere' (8.1 ms)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:01+06:00 INFO metabase.sync.util STARTING: step 'sync-tables' for postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:02+06:00 INFO metabase.sync.util STARTING: Cache field values in postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:02+06:00 DEBUG metabase.server.middleware.log POST /api/database/2/rescan_values 200 5.8 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (3 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:02+06:00 INFO metabase.sync.util STARTING: step 'delete-expired-advanced-field-values' for postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:02+06:00 INFO metabase.sync.sync-metadata.tables Marking tables as inactive: (Table 'adempiere.bi_m_storage_on_hand' Table 'adempiere.bi_m_sales_order' Table 'adempiere.bi_m_material_receipt' Table 'adempiere.bi_m_purchase_order' Table 'adempiere.bi_m_material_shipment' Table 'adempiere.bi_m_sales_opportunity' Table 'adempiere.bi_m_lead')
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:02+06:00 INFO metabase.sync.util FINISHED: step 'sync-tables' for postgres Database 2 'iDempiere' (853.8 ms)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:02+06:00 INFO metabase.sync.util STARTING: step 'sync-fields' for postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:02+06:00 INFO metabase.sync.util FINISHED: step 'sync-fields' for postgres Database 2 'iDempiere' (16.4 ms)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:02+06:00 INFO metabase.sync.util STARTING: step 'sync-fks' for postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:02+06:00 INFO metabase.sync.util FINISHED: step 'sync-fks' for postgres Database 2 'iDempiere' (8.8 ms)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:02+06:00 INFO metabase.sync.util STARTING: step 'sync-metabase-metadata' for postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:02+06:00 INFO metabase.sync.util FINISHED: step 'delete-expired-advanced-field-values' for postgres Database 2 'iDempiere' (275.0 ms)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:02+06:00 INFO metabase.sync.util STARTING: step 'update-field-values' for postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:02+06:00 INFO metabase.sync.util FINISHED: step 'update-field-values' for postgres Database 2 'iDempiere' (155.0 ms)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:02+06:00 INFO metabase.sync.util FINISHED: Cache field values in postgres Database 2 'iDempiere' (457.6 ms)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:03+06:00 INFO metabase.sync.util FINISHED: step 'sync-metabase-metadata' for postgres Database 2 'iDempiere' (986.6 ms)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:03+06:00 INFO metabase.sync.util FINISHED: Sync metadata for postgres Database 2 'iDempiere' (1.9 s)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:03+06:00 INFO metabase.sync.util STARTING: Analyze data for postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:03+06:00 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:03+06:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [······································] 25% Table 16 'adempiere.bi_m_production'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:03+06:00 INFO metabase.sync.util FINISHED: step 'fingerprint-fields' for postgres Database 2 'iDempiere' (59.9 ms)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:03+06:00 INFO metabase.sync.util STARTING: step 'classify-fields' for postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:03+06:00 INFO metabase.sync.analyze classify-fields Analyzed [·························] 50% Table 16 'adempiere.bi_m_production'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:03+06:00 INFO metabase.sync.util FINISHED: step 'classify-fields' for postgres Database 2 'iDempiere' (1.5 ms)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:03+06:00 INFO metabase.sync.util STARTING: step 'classify-tables' for postgres Database 2 'iDempiere'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:03+06:00 INFO metabase.sync.analyze classify-tables Analyzed [************************·············] 75% Table 16 'adempiere.bi_m_production'
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:03+06:00 INFO metabase.sync.util FINISHED: step 'classify-tables' for postgres Database 2 'iDempiere' (2.0 ms)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:03+06:00 INFO metabase.sync.util FINISHED: Analyze data for postgres Database 2 'iDempiere' (90.8 ms)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:07+06:00 DEBUG metabase.server.middleware.log GET /api/database/2 200 10.9 ms (7 DB calls) App DB connections: 1/4 Jetty threads: 7/50 (3 idle, 0 queued) (97 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:07+06:00 DEBUG metabase.server.middleware.log GET /api/search 200 24.4 ms (3 DB calls) App DB connections: 1/4 Jetty threads: 6/50 (3 idle, 0 queued) (97 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:07+06:00 DEBUG metabase.server.middleware.log GET /api/database/2/metadata 200 19.5 ms (7 DB calls) App DB connections: 1/4 Jetty threads: 6/50 (3 idle, 0 queued) (97 total active threads) Queries in flight: 0 (0 queued)
[645019af-4f4f-4b87-a493-de5f14c27ed0] 2023-03-30T13:35:10+06:00 DEBUG metabase.server.middleware.log GET /api/util/bug_report_details 200 2.2 ms (1 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (3 idle, 0 queued) (97 total active threads) Queries in flight: 0 (0 queued)

Kanat · March 30, 2023, 7:37am

curl --location --request POST 'http://localhost:3000/api/database'
--header 'Content-Type: application/json'
--header 'X-Metabase-Session: 772f3c8a-5b5f-4a65-bcfc-6504ef713c67'
--header 'Cookie: metabase.DEVICE=0d5b22ad-a273-4fa8-9510-4e4cd2a19d16; metabase.SESSION=772f3c8a-5b5f-4a65-bcfc-6504ef713c67; metabase.TIMEOUT=alive'
--data-raw '{
"engine": "postgres",
"name": "iDempiere",
"details": {
"host": "localhost",
"port": 5432,
"dbname": "idempiere",
"db": "idempiere",
"ssl": false,
"advanced-options": false,
"tunnel-enabled": false,
"schema-filters-type": "inclusion",
"schema-filters-patterns": "adempiere",
"user": "metabase",
"password": "metabase"
}
}'

Luiggi · March 30, 2023, 5:49pm

What’s your Metabase version?

Also can you post exact reproduction steps so we can check what might be going on? We need the steps from scratch

Kanat · April 1, 2023, 7:41am

I have created user

    PGPASSWORD=$DB_ADMIN_PASS psql -d $DB_NAME -h $DB_HOST -U postgres -c "CREATE USER $METABASE_DB_USER WITH PASSWORD '$METABASE_DB_PASS'"
    PGPASSWORD=$DB_ADMIN_PASS psql -d $DB_NAME -h $DB_HOST -U postgres -c "GRANT USAGE ON SCHEMA $DB_SCHEMA TO $METABASE_DB_USER";

where
DB_NAME = idempiere
DB_SCHEMA = adempiere
METABASE_DB_USER = metabase
METABASE_DB_PASS = metabase

Then using flyway migration tool, created views in idempiere database adempiere schema.
for each view grant access using place flyway.placeholders

echo "Flyway info"
flyway -schemas=$IDEMPIERE_DB_SCHEMA -locations=$IDEMPIERE_FLYWAY_LOCATIONS info
echo "Flyway migrate"
flyway -schemas=$IDEMPIERE_DB_SCHEMA
-locations=$IDEMPIERE_FLYWAY_LOCATIONS
-baselineOnMigrate=$IDEMPIERE_FLYWAY_BASELINE_ON_MIGRATE
-placeholders.idempiere_to_metabase_user=$METABASE_DB_USER
migrate

like this

create view adempiere.bi_m_production
as
select * from some_tables;

alter table adempiere.bi_m_production
owner to adempiere;

grant select on adempiere.bi_m_production to ${idempiere_to_metabase_user};

In addition gave access to views by adding

alter default privileges in schema adempiere grant select on tables to ${idempiere_to_metabase_user};

Then with metabse api
created first admin user
After that with metabase api added new database.

curl --location --request POST 'http://localhost:3000/api/database'
--header 'Content-Type: application/json'
--header 'X-Metabase-Session: 1cee8ce6-e743-4744-8e1e-0b7b0edac00f'
--header 'Cookie: metabase.DEVICE=afb91001-d2cc-4627-88a6-f607a1a27507; metabase.SESSION=1cee8ce6-e743-4744-8e1e-0b7b0edac00f; metabase.TIMEOUT=alive'
--data-raw '{
"engine": "postgres",
"name": "iDempiere",
"details": {
"host": "localhost",
"port": 5432,
"dbname": "idempiere",
"user": "metabase",
"password": "metabase",
"schema-filters-type": "inclusion",
"schema-filters-patterns": "adempiere",
"ssl": false,
"tunnel-enabled": false,
"advanced-options": true,
"json-unfolding": false,
"additional-options": null,
"let-user-control-scheduling": null
},
"auto_run_queries": false,
"refingerprint": null,
"is_full_sync": true
}'

So my problem is that on database sync/query it resets/revokes permission to views other than first created view.

before sync

[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:43+06:00 INFO metabase.core
Metabase v0.45.3 (070f57b release-x.45.x)

Metabase Enterprise Edition extensions are NOT PRESENT.
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:43+06:00 INFO metabase.core Starting Metabase in STANDALONE mode
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:43+06:00 INFO metabase.server Launching Embedded Jetty Webserver with config:
{:port 3000, :host "0.0.0.0"}

[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:43+06:00 INFO metabase.core Starting Metabase version v0.45.3 (070f57b release-x.45.x) ...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:43+06:00 INFO metabase.core System info:
{"file.encoding" "UTF-8",
"java.runtime.name" "OpenJDK Runtime Environment",
"java.runtime.version" "11.0.18+10",
"java.vendor" "Eclipse Adoptium",
"java.vendor.url" "https://adoptium.net/",
"java.version" "11.0.18",
"java.vm.name" "OpenJDK 64-Bit Server VM",
"java.vm.version" "11.0.18+10",
"os.name" "Linux",
"os.version" "5.19.0-38-generic",
"user.language" "en",
"user.timezone" "GMT"}

[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:43+06:00 INFO metabase.plugins Loading plugins in /plugins...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:43+06:00 INFO metabase.util.files Extract file /modules/sparksql.metabase-driver.jar -> /plugins/sparksql.metabase-driver.jar
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:43+06:00 INFO metabase.util.files Extract file /modules/athena.metabase-driver.jar -> /plugins/athena.metabase-driver.jar
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.util.files Extract file /modules/sqlserver.metabase-driver.jar -> /plugins/sqlserver.metabase-driver.jar
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.util.files Extract file /modules/presto-jdbc.metabase-driver.jar -> /plugins/presto-jdbc.metabase-driver.jar
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.util.files Extract file /modules/sqlite.metabase-driver.jar -> /plugins/sqlite.metabase-driver.jar
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.util.files Extract file /modules/vertica.metabase-driver.jar -> /plugins/vertica.metabase-driver.jar
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.util.files Extract file /modules/redshift.metabase-driver.jar -> /plugins/redshift.metabase-driver.jar
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.util.files Extract file /modules/presto.metabase-driver.jar -> /plugins/presto.metabase-driver.jar
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.util.files Extract file /modules/druid.metabase-driver.jar -> /plugins/druid.metabase-driver.jar
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.util.files Extract file /modules/mongo.metabase-driver.jar -> /plugins/mongo.metabase-driver.jar
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.util.files Extract file /modules/oracle.metabase-driver.jar -> /plugins/oracle.metabase-driver.jar
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.util.files Extract file /modules/snowflake.metabase-driver.jar -> /plugins/snowflake.metabase-driver.jar
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.util.files Extract file /modules/googleanalytics.metabase-driver.jar -> /plugins/googleanalytics.metabase-driver.jar
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.util.files Extract file /modules/bigquery-cloud-sdk.metabase-driver.jar -> /plugins/bigquery-cloud-sdk.metabase-driver.jar
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.util.files Extract file /modules/presto-common.metabase-driver.jar -> /plugins/presto-common.metabase-driver.jar
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :presto-common...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.driver.impl Registered abstract driver :presto-common
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :bigquery-cloud-sdk...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.driver.impl Registered driver :bigquery-cloud-sdk (parents: [:sql])
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :hive-like...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.driver.impl Registered abstract driver :hive-like (parents: [:sql-jdbc])
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :sparksql...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.driver.impl Registered driver :sparksql (parents: [:hive-like])
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.plugins.dependencies Plugin 'Metabase Presto JDBC Driver' depends on plugin 'Presto Common Driver'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :presto-jdbc...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.plugins.dependencies Metabase Presto JDBC Driver dependency {:plugin Presto Common Driver} satisfied? true
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.driver.impl Registered driver :presto-jdbc (parents: [:presto-common])
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.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 Redirecting… for more details.

[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.plugins.dependencies Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: ["Metabase Vertica Driver"]
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :athena...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.driver.impl Registered driver :athena (parents: [:sql-jdbc])
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.driver.impl Registered driver :sqlserver (parents: [:sql-jdbc])
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :sqlserver...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.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 Redirecting… for more details.

[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.plugins.dependencies Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: ["Metabase Vertica Driver" "Metabase Oracle Driver"]
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :druid...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.driver.impl Registered driver :druid
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :sqlite...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.driver.impl Registered driver :sqlite (parents: [:sql-jdbc])
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :redshift...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.driver.impl Registered driver :redshift (parents: [:postgres])
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.driver.impl Registered driver :googleanalytics
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :googleanalytics...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.plugins.dependencies Metabase Presto Driver dependency {:plugin Presto Common Driver} satisfied? true
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.plugins.dependencies Plugin 'Metabase Presto Driver' depends on plugin 'Presto Common Driver'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :presto...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.driver.impl Registered driver :presto (parents: [:presto-common])
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :snowflake...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.driver.impl Registered driver :snowflake (parents: [:sql-jdbc])
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :mongo...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.driver.impl Registered driver :mongo
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.core Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:44+06:00 INFO metabase.db.setup Verifying postgres Database Connection ...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:45+06:00 INFO metabase.db.setup Successfully verified PostgreSQL 13.10 (Debian 13.10-1.pgdg110+1) application database connection.
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:45+06:00 INFO metabase.db.setup Running Database Migrations...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:45+06:00 INFO metabase.db.setup Setting up Liquibase...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:45+06:00 INFO metabase.db.liquibase Checking if Database has unrun migrations...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:45+06:00 INFO metabase.db.setup Liquibase is ready.
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:46+06:00 INFO metabase.db.liquibase Database has unrun migrations. Waiting for migration lock to be cleared...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:47+06:00 INFO metabase.db.liquibase Migration lock is cleared. Running migrations...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.db.setup Database Migrations Current ...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.db.data-migrations Running all necessary data migrations, this may take a minute.
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.db.data-migrations Running data migration 'migrate-click-through'...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.db.data-migrations Running data migration 'migrate-remove-admin-from-group-mapping-if-needed'...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.db.data-migrations Finished running data migrations.
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.util Database setup took 8.8 s
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.util.i18n.impl Reading available locales from locales.clj...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.events Starting events listener: :metabase.events.activity-feed/ActivityFeed
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.events Starting events listener: :metabase.events.last-login/LastLogin
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.events Starting events listener: :metabase.events.persisted-info/PersistedInfo
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.events Starting events listener: :metabase.events.driver-notifications/DriverNotifications
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.events Starting events listener: :metabase.events.sync-database/Sync
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.events Starting events listener: :metabase.events.revision/Revisions
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.events Starting events listener: :metabase.events.view-log/ViewLog
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO org.quartz.impl.StdSchedulerFactory Using default implementation for ThreadExecutor
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO org.quartz.core.SchedulerSignalerImpl Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO org.quartz.core.QuartzScheduler Quartz Scheduler v.2.3.2 created.
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO org.quartz.impl.jdbcjobstore.JobStoreTX Using db table-based data access locking (synchronization).
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO org.quartz.impl.jdbcjobstore.JobStoreTX JobStoreTX initialized.
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO org.quartz.impl.StdSchedulerFactory Quartz scheduler 'MetabaseScheduler' initialized from default resource file in Quartz package: 'quartz.properties'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO org.quartz.impl.StdSchedulerFactory Quartz scheduler version: 2.3.2
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO org.quartz.core.QuartzScheduler Scheduler meta-data: Quartz Scheduler (v2.3.2) 'MetabaseScheduler' with instanceId 'qanat-System-Product-Name1680334793692'
Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
NOT STARTED.
Currently in standby mode.
Number of jobs executed: 0
Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads.
Using job-store 'org.quartz.impl.jdbcjobstore.JobStoreTX' - which supports persistence. and is clustered.

[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO org.quartz.core.QuartzScheduler Scheduler MetabaseScheduler_$_qanat-System-Product-Name1680334793692 paused.
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.task Task scheduler initialized into standby mode.
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.task Initializing task SyncDatabases
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.task Initializing task PersistRefresh
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.task.sync-databases Updated default schedules for 0 databases
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.task Initializing task CheckForNewVersions
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.task Initializing task PersistPrune
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.task Initializing task SendAnonymousUsageStats
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.task Initializing task RefreshSlackChannelsAndUsers
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.task Initializing task SendAbandomentEmails
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.task Initializing task SendPulses
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.task Initializing task SendFollowUpEmails
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.task Initializing task TaskHistoryCleanup
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.core Looks like this is a new installation ... preparing setup wizard
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.core Please use the following URL to setup your Metabase installation:

http://0.0.0.0:3000/setup/

[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:53+06:00 INFO metabase.sample-data Loading sample database
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:54+06:00 INFO metabase.util.files Extract file /sample-database.db.mv.db -> /plugins/sample-database.db.mv.db
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:54+06:00 INFO metabase.driver.impl Initializing driver :sql...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:54+06:00 INFO metabase.driver.impl Initializing driver :h2...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:54+06:00 INFO metabase.driver.impl Initializing driver :sql-jdbc...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:54+06:00 INFO metabase.task.sync-databases Scheduling sync/analyze for database 1: trigger: metabase.task.sync-and-analyze.trigger.1
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:54+06:00 INFO metabase.task.sync-databases Scheduling field-values for database 1: trigger: metabase.task.update-field-values.trigger.1
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:54+06:00 INFO metabase.sync.util STARTING: Sync h2 Database 1 'Sample Database'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:54+06:00 INFO metabase.sync.util STARTING: Sync metadata for h2 Database 1 'Sample Database'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:54+06:00 INFO metabase.sync.util STARTING: step 'sync-timezone' for h2 Database 1 'Sample Database'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:54+06:00 INFO metabase.sync.util FINISHED: step 'sync-timezone' for h2 Database 1 'Sample Database' (46.0 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:54+06:00 INFO metabase.sync.util STARTING: step 'sync-tables' for h2 Database 1 'Sample Database'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:54+06:00 INFO metabase.sync.sync-metadata.tables Found new tables: (Table 'PUBLIC.PRODUCTS' Table 'PUBLIC.ORDERS' Table 'PUBLIC.ANALYTIC_EVENTS' Table 'PUBLIC.FEEDBACK' Table 'PUBLIC.PEOPLE' Table 'PUBLIC.INVOICES' Table 'PUBLIC.ACCOUNTS' Table 'PUBLIC.REVIEWS')
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:54+06:00 INFO metabase.driver.impl Initializing driver :postgres...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:54+06:00 INFO metabase.sync.sync-metadata.tables Updating description for tables: (Table 'PUBLIC.ANALYTIC_EVENTS' Table 'PUBLIC.FEEDBACK' Table 'PUBLIC.PEOPLE' Table 'PUBLIC.REVIEWS' Table 'PUBLIC.ORDERS' Table 'PUBLIC.ACCOUNTS' Table 'PUBLIC.INVOICES' Table 'PUBLIC.PRODUCTS')
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:54+06:00 INFO metabase.sync.util FINISHED: step 'sync-tables' for h2 Database 1 'Sample Database' (129.1 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:54+06:00 INFO metabase.sync.util STARTING: step 'sync-fields' for h2 Database 1 'Sample Database'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:55+06:00 INFO metabase.sync.util FINISHED: step 'sync-fields' for h2 Database 1 'Sample Database' (693.9 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:55+06:00 INFO metabase.sync.util STARTING: step 'sync-fks' for h2 Database 1 'Sample Database'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:55+06:00 INFO metabase.sync.sync-metadata.fks Marking foreign key from Table 3 'PUBLIC.ANALYTIC_EVENTS' Field 21 'ACCOUNT_ID' -> Table 7 'PUBLIC.ACCOUNTS' Field 11 'ID'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:55+06:00 INFO metabase.sync.sync-metadata.fks Marking foreign key from Table 4 'PUBLIC.FEEDBACK' Field 27 'ACCOUNT_ID' -> Table 7 'PUBLIC.ACCOUNTS' Field 11 'ID'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:55+06:00 INFO metabase.sync.sync-metadata.fks Marking foreign key from Table 6 'PUBLIC.INVOICES' Field 35 'ACCOUNT_ID' -> Table 7 'PUBLIC.ACCOUNTS' Field 11 'ID'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:55+06:00 INFO metabase.sync.sync-metadata.fks Marking foreign key from Table 2 'PUBLIC.ORDERS' Field 43 'USER_ID' -> Table 5 'PUBLIC.PEOPLE' Field 49 'ID'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:55+06:00 INFO metabase.sync.sync-metadata.fks Marking foreign key from Table 2 'PUBLIC.ORDERS' Field 36 'PRODUCT_ID' -> Table 1 'PUBLIC.PRODUCTS' Field 59 'ID'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:55+06:00 INFO metabase.sync.sync-metadata.fks Marking foreign key from Table 8 'PUBLIC.REVIEWS' Field 68 'PRODUCT_ID' -> Table 1 'PUBLIC.PRODUCTS' Field 59 'ID'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:55+06:00 INFO metabase.sync.util FINISHED: step 'sync-fks' for h2 Database 1 'Sample Database' (108.0 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:55+06:00 INFO metabase.sync.util STARTING: step 'sync-metabase-metadata' for h2 Database 1 'Sample Database'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:55+06:00 INFO metabase.sync.util FINISHED: step 'sync-metabase-metadata' for h2 Database 1 'Sample Database' (277.9 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:56+06:00 INFO metabase.sync.util FINISHED: Sync metadata for h2 Database 1 'Sample Database' (1.8 s)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:56+06:00 INFO metabase.sync.util STARTING: Analyze data for h2 Database 1 'Sample Database'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:56+06:00 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for h2 Database 1 'Sample Database'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:58+06:00 INFO metabase.server.middleware.misc Setting Metabase site URL to localhost:3000
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:39:59+06:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [·············································] 12% Table 4 'PUBLIC.FEEDBACK'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:01+06:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [·······································] 24% Table 5 'PUBLIC.PEOPLE'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:02+06:00 INFO metabase.sync.util FINISHED: step 'fingerprint-fields' for h2 Database 1 'Sample Database' (5.9 s)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:02+06:00 INFO metabase.sync.util STARTING: step 'classify-fields' for h2 Database 1 'Sample Database'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:02+06:00 INFO metabase.sync.analyze classify-fields Analyzed [································] 36% Table 7 'PUBLIC.ACCOUNTS'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:02+06:00 INFO metabase.sync.analyze classify-fields Analyzed [···························] 48% Table 6 'PUBLIC.INVOICES'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:02+06:00 INFO metabase.sync.analyze classify-fields Analyzed [····················] 60% Table 1 'PUBLIC.PRODUCTS'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:02+06:00 INFO metabase.sync.util FINISHED: step 'classify-fields' for h2 Database 1 'Sample Database' (366.7 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:02+06:00 INFO metabase.sync.util STARTING: step 'classify-tables' for h2 Database 1 'Sample Database'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:02+06:00 INFO metabase.sync.analyze classify-tables Analyzed [··············] 72% Table 3 'PUBLIC.ANALYTIC_EVENTS'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:02+06:00 INFO metabase.sync.analyze classify-tables Analyzed [·········] 84% Table 2 'PUBLIC.ORDERS'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:02+06:00 INFO metabase.sync.analyze classify-tables Analyzed [***********************···] 96% Table 8 'PUBLIC.REVIEWS'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:02+06:00 INFO metabase.sync.util FINISHED: step 'classify-tables' for h2 Database 1 'Sample Database' (36.7 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:02+06:00 INFO metabase.sync.util FINISHED: Analyze data for h2 Database 1 'Sample Database' (6.4 s)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:02+06:00 INFO metabase.sync.util STARTING: Cache field values in h2 Database 1 'Sample Database'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:02+06:00 INFO metabase.sync.util STARTING: step 'delete-expired-advanced-field-values' for h2 Database 1 'Sample Database'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:02+06:00 INFO metabase.sync.util FINISHED: step 'delete-expired-advanced-field-values' for h2 Database 1 'Sample Database' (276.6 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:02+06:00 INFO metabase.sync.util STARTING: step 'update-field-values' for h2 Database 1 'Sample Database'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:03+06:00 INFO metabase.models.field-values Field BODY was previously automatically set to show a list widget, but now has 231 values. Switching Field to use a search widget instead.
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:03+06:00 INFO metabase.sync.util FINISHED: step 'update-field-values' for h2 Database 1 'Sample Database' (1.1 s)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:03+06:00 INFO metabase.sync.util FINISHED: Cache field values in h2 Database 1 'Sample Database' (1.4 s)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:03+06:00 INFO metabase.sync.util FINISHED: Sync h2 Database 1 'Sample Database' (9.8 s)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:03+06:00 INFO org.quartz.core.QuartzScheduler Scheduler MetabaseScheduler_$_qanat-System-Product-Name1680334793692 started.
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:03+06:00 INFO metabase.task Task scheduler started
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:03+06:00 INFO metabase.core Metabase Initialization COMPLETE
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:04+06:00 INFO metabase.task.refresh-slack-channel-user-cache Slack is not configured, not refreshing slack user/channel cache.
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:04+06:00 INFO metabase.util.fonts Reading available fonts from /frontend_client/app/fonts
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:04+06:00 WARN metabase.server.routes.index Locale 'us' not found.
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:05+06:00 DEBUG metabase.server.middleware.log GET /api/user/current 401 1.4 ms (0 DB calls)
"Unauthenticated"

[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:05+06:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 25.5 ms (2 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (3 idle, 0 queued) (60 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:19+06:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 15.3 ms (2 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (3 idle, 0 queued) (60 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:41+06:00 INFO metabase.models.user Adding User 1 to All Users permissions group...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:41+06:00 INFO metabase.models.user Adding User 1 to Admin permissions group...
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:41+06:00 DEBUG metabase.server.middleware.log POST /api/setup 200 268.7 ms (29 DB calls) App DB connections: 1/4 Jetty threads: 5/50 (3 idle, 0 queued) (61 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:40:49+06:00 DEBUG metabase.server.middleware.log POST /api/session 200 123.1 ms (7 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (3 idle, 0 queued) (61 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:29+06:00 INFO metabase.task.sync-databases Scheduling sync/analyze for database 2: trigger: metabase.task.sync-and-analyze.trigger.2
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:29+06:00 INFO metabase.task.sync-databases Scheduling field-values for database 2: trigger: metabase.task.update-field-values.trigger.2
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:29+06:00 INFO metabase.sync.util STARTING: Sync postgres Database 2 'iDempiere'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:29+06:00 DEBUG metabase.server.middleware.log POST /api/database 200 65.5 ms (7 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (3 idle, 0 queued) (60 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:31+06:00 INFO metabase.sync.util STARTING: Sync metadata for postgres Database 2 'iDempiere'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:31+06:00 INFO metabase.sync.util STARTING: step 'sync-timezone' for postgres Database 2 'iDempiere'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:31+06:00 INFO metabase.sync.util FINISHED: step 'sync-timezone' for postgres Database 2 'iDempiere' (23.7 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:31+06:00 INFO metabase.sync.util STARTING: step 'sync-tables' for postgres Database 2 'iDempiere'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:31+06:00 INFO metabase.sync.sync-metadata.tables Found new tables: (Table 'adempiere.bi_m_storage_on_hand' Table 'adempiere.bi_m_sales_order' Table 'adempiere.bi_m_material_receipt' Table 'adempiere.bi_m_purchase_order' Table 'adempiere.bi_m_material_shipment' Table 'adempiere.bi_m_sales_opportunity' Table 'adempiere.bi_m_lead' Table 'adempiere.bi_m_production')
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:32+06:00 INFO metabase.sync.sync-metadata.tables Updating description for tables: (Table 'adempiere.bi_m_sales_order' Table 'adempiere.bi_m_material_receipt' Table 'adempiere.bi_m_material_shipment' Table 'adempiere.bi_m_purchase_order' Table 'adempiere.bi_m_lead' Table 'adempiere.bi_m_sales_opportunity' Table 'adempiere.bi_m_storage_on_hand' Table 'adempiere.bi_m_production')
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:32+06:00 INFO metabase.sync.util FINISHED: step 'sync-tables' for postgres Database 2 'iDempiere' (135.6 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:32+06:00 INFO metabase.sync.util STARTING: step 'sync-fields' for postgres Database 2 'iDempiere'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:32+06:00 INFO metabase.sync.util FINISHED: step 'sync-fields' for postgres Database 2 'iDempiere' (939.4 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:32+06:00 INFO metabase.sync.util STARTING: step 'sync-fks' for postgres Database 2 'iDempiere'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:33+06:00 INFO metabase.sync.util FINISHED: step 'sync-fks' for postgres Database 2 'iDempiere' (115.0 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:33+06:00 INFO metabase.sync.util STARTING: step 'sync-metabase-metadata' for postgres Database 2 'iDempiere'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:33+06:00 INFO metabase.sync.util FINISHED: step 'sync-metabase-metadata' for postgres Database 2 'iDempiere' (808.0 µs)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:33+06:00 INFO metabase.sync.util FINISHED: Sync metadata for postgres Database 2 'iDempiere' (1.3 s)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:33+06:00 INFO metabase.sync.util STARTING: Analyze data for postgres Database 2 'iDempiere'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:33+06:00 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for postgres Database 2 'iDempiere'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:33+06:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [·············································] 12% Table 13 'adempiere.bi_m_material_shipment'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:33+06:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [·······································] 24% Table 14 'adempiere.bi_m_sales_opportunity'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:34+06:00 INFO metabase.sync.util FINISHED: step 'fingerprint-fields' for postgres Database 2 'iDempiere' (1.2 s)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:34+06:00 INFO metabase.sync.util STARTING: step 'classify-fields' for postgres Database 2 'iDempiere'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:34+06:00 INFO metabase.sync.analyze classify-fields Analyzed [································] 36% Table 15 'adempiere.bi_m_lead'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:34+06:00 INFO metabase.sync.analyze classify-fields Analyzed [···························] 48% Table 16 'adempiere.bi_m_production'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:34+06:00 INFO metabase.sync.analyze classify-fields Analyzed [····················] 60% Table 10 'adempiere.bi_m_sales_order'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:34+06:00 INFO metabase.sync.util FINISHED: step 'classify-fields' for postgres Database 2 'iDempiere' (18.4 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:34+06:00 INFO metabase.sync.util STARTING: step 'classify-tables' for postgres Database 2 'iDempiere'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:34+06:00 INFO metabase.sync.analyze classify-tables Analyzed [··············] 72% Table 11 'adempiere.bi_m_material_receipt'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:34+06:00 INFO metabase.sync.analyze classify-tables Analyzed [·········] 84% Table 12 'adempiere.bi_m_purchase_order'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:34+06:00 INFO metabase.sync.analyze classify-tables Analyzed [***********************···] 96% Table 9 'adempiere.bi_m_storage_on_hand'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:34+06:00 INFO metabase.sync.util FINISHED: step 'classify-tables' for postgres Database 2 'iDempiere' (43.6 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:34+06:00 INFO metabase.sync.util FINISHED: Analyze data for postgres Database 2 'iDempiere' (1.3 s)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:34+06:00 INFO metabase.sync.util STARTING: Cache field values in postgres Database 2 'iDempiere'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:34+06:00 INFO metabase.sync.util STARTING: step 'delete-expired-advanced-field-values' for postgres Database 2 'iDempiere'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:34+06:00 INFO metabase.sync.util FINISHED: step 'delete-expired-advanced-field-values' for postgres Database 2 'iDempiere' (522.7 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:34+06:00 INFO metabase.sync.util STARTING: step 'update-field-values' for postgres Database 2 'iDempiere'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:35+06:00 INFO metabase.sync.util FINISHED: step 'update-field-values' for postgres Database 2 'iDempiere' (294.9 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:35+06:00 INFO metabase.sync.util FINISHED: Cache field values in postgres Database 2 'iDempiere' (864.1 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:35+06:00 INFO metabase.sync.util FINISHED: Sync postgres Database 2 'iDempiere' (6.2 s)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:58+06:00 DEBUG metabase.server.middleware.log GET /api/user/current 401 489.7 µs (0 DB calls)
"Unauthenticated"

[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:41:58+06:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 26.2 ms (1 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (2 idle, 0 queued) (79 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:42:10+06:00 DEBUG metabase.server.middleware.log POST /api/session 200 113.8 ms (7 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (1 idle, 0 queued) (79 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:42:10+06:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 46.2 ms (8 DB calls) App DB connections: 3/4 Jetty threads: 6/50 (1 idle, 0 queued) (79 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:42:10+06:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 63.4 ms (9 DB calls) App DB connections: 0/6 Jetty threads: 5/50 (1 idle, 0 queued) (79 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:42:11+06:00 DEBUG metabase.server.middleware.log GET /api/collection/tree 200 79.9 ms (6 DB calls) App DB connections: 2/7 Jetty threads: 10/50 (0 idle, 0 queued) (81 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:42:11+06:00 DEBUG metabase.server.middleware.log GET /api/database 200 66.8 ms (3 DB calls) App DB connections: 1/7 Jetty threads: 10/50 (0 idle, 0 queued) (83 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:42:11+06:00 DEBUG metabase.server.middleware.log GET /api/bookmark 200 145.4 ms (1 DB calls) App DB connections: 0/7 Jetty threads: 9/50 (0 idle, 0 queued) (83 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:42:11+06:00 DEBUG metabase.server.middleware.log GET /api/activity/recent_views 200 31.4 ms (2 DB calls) App DB connections: 0/7 Jetty threads: 10/50 (0 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:42:11+06:00 DEBUG metabase.server.middleware.log GET /api/activity/popular_items 200 84.1 ms (2 DB calls) App DB connections: 0/7 Jetty threads: 9/50 (0 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:42:11+06:00 WARN metabase.email Failed to send email
clojure.lang.ExceptionInfo: SMTP host is not set. {:cause :smtp-host-not-set}
at metabase.email$fn__59964$send_message_or_throw_BANG___59969$fn__59973.invoke(email.clj:113)
at metabase.email$fn__59964$send_message_or_throw_BANG___59969.invoke(email.clj:107)
at metabase.email$send_message_BANG_.invokeStatic(email.clj:150)
at metabase.email$send_message_BANG_.doInvoke(email.clj:136)
at clojure.lang.RestFn.invoke(RestFn.java:619)
at metabase.email.messages$send_login_from_new_device_email_BANG_.invokeStatic(messages.clj:210)
at metabase.email.messages$send_login_from_new_device_email_BANG_.invoke(messages.clj:196)
at metabase.models.login_history$maybe_send_login_from_new_device_email$fn__60869.invoke(login_history.clj:77)
at clojure.core$binding_conveyor_fn$fn__5823.invoke(core.clj:2047)
at clojure.lang.AFn.call(AFn.java:18)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:42:11+06:00 DEBUG metabase.server.middleware.log GET /api/collection/root 200 694.4 ms (2 DB calls) App DB connections: 0/7 Jetty threads: 6/50 (1 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:42:12+06:00 DEBUG metabase.server.middleware.log GET /api/automagic-dashboards/database/2/candidates 200 727.4 ms (6 DB calls) App DB connections: 0/7 Jetty threads: 5/50 (1 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:42:28+06:00 DEBUG metabase.server.middleware.log GET /api/activity/recent_views 200 3.6 ms (2 DB calls) App DB connections: 2/7 Jetty threads: 7/50 (2 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:42:28+06:00 DEBUG metabase.server.middleware.log GET /api/activity 200 16.4 ms (2 DB calls) App DB connections: 0/7 Jetty threads: 6/50 (2 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:42:28+06:00 DEBUG metabase.server.middleware.log GET /api/setup/admin_checklist 200 49.7 ms (13 DB calls) App DB connections: 0/7 Jetty threads: 5/50 (2 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:42:37+06:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 32.2 ms (4 DB calls) App DB connections: 0/7 Jetty threads: 6/50 (2 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:42:37+06:00 DEBUG metabase.server.middleware.log GET /api/setting 200 40.1 ms (3 DB calls) App DB connections: 0/7 Jetty threads: 6/50 (2 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:42:37+06:00 DEBUG metabase.server.middleware.log GET /api/setup/admin_checklist 200 19.9 ms (13 DB calls) App DB connections: 0/7 Jetty threads: 5/50 (2 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:42:38+06:00 DEBUG metabase.server.middleware.log GET /api/util/bug_report_details 200 4.2 ms (1 DB calls) App DB connections: 0/7 Jetty threads: 5/50 (2 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:42:41+06:00 DEBUG metabase.server.middleware.log GET /api/task 200 12.8 ms (2 DB calls) App DB connections: 0/7 Jetty threads: 5/50 (2 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:42:42+06:00 DEBUG metabase.server.middleware.log GET /api/task/info 200 5.0 ms (0 DB calls) App DB connections: 0/7 Jetty threads: 5/50 (2 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)

After sync

[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:15+06:00 INFO metabase.sync.util STARTING: Sync metadata for postgres Database 2 'iDempiere'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:15+06:00 INFO metabase.sync.util STARTING: step 'sync-timezone' for postgres Database 2 'iDempiere'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:15+06:00 INFO metabase.sync.util FINISHED: step 'sync-timezone' for postgres Database 2 'iDempiere' (4.6 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:15+06:00 INFO metabase.sync.util STARTING: step 'sync-tables' for postgres Database 2 'iDempiere'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:15+06:00 INFO metabase.sync.sync-metadata.tables Marking tables as inactive: (Table 'adempiere.bi_m_sales_order' Table 'adempiere.bi_m_material_receipt' Table 'adempiere.bi_m_purchase_order' Table 'adempiere.bi_m_material_shipment' Table 'adempiere.bi_m_sales_opportunity' Table 'adempiere.bi_m_lead')
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:15+06:00 INFO metabase.sync.util FINISHED: step 'sync-tables' for postgres Database 2 'iDempiere' (281.7 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:15+06:00 INFO metabase.sync.util STARTING: step 'sync-fields' for postgres Database 2 'iDempiere'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:16+06:00 INFO metabase.sync.util FINISHED: step 'sync-fields' for postgres Database 2 'iDempiere' (64.2 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:16+06:00 INFO metabase.sync.util STARTING: step 'sync-fks' for postgres Database 2 'iDempiere'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:16+06:00 INFO metabase.sync.util FINISHED: step 'sync-fks' for postgres Database 2 'iDempiere' (22.0 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:16+06:00 INFO metabase.sync.util FINISHED: step 'sync-metabase-metadata' for postgres Database 2 'iDempiere' (340.2 µs)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:16+06:00 INFO metabase.sync.util STARTING: step 'sync-metabase-metadata' for postgres Database 2 'iDempiere'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:16+06:00 INFO metabase.sync.util FINISHED: Sync metadata for postgres Database 2 'iDempiere' (565.6 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:16+06:00 INFO metabase.sync.util STARTING: Analyze data for postgres Database 2 'iDempiere'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:16+06:00 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for postgres Database 2 'iDempiere'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:16+06:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [···········································] 14% Table 16 'adempiere.bi_m_production'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:16+06:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [····································] 29% Table 9 'adempiere.bi_m_storage_on_hand'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:16+06:00 INFO metabase.sync.util FINISHED: step 'fingerprint-fields' for postgres Database 2 'iDempiere' (128.6 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:16+06:00 INFO metabase.sync.util STARTING: step 'classify-fields' for postgres Database 2 'iDempiere'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:16+06:00 INFO metabase.sync.analyze classify-fields Analyzed [·····························] 43% Table 16 'adempiere.bi_m_production'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:16+06:00 INFO metabase.sync.analyze classify-fields Analyzed [*********************······················] 57% Table 9 'adempiere.bi_m_storage_on_hand'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:16+06:00 INFO metabase.sync.util FINISHED: step 'classify-fields' for postgres Database 2 'iDempiere' (2.9 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:16+06:00 INFO metabase.sync.util STARTING: step 'classify-tables' for postgres Database 2 'iDempiere'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:16+06:00 INFO metabase.sync.analyze classify-tables Analyzed [···············] 71% Table 16 'adempiere.bi_m_production'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:16+06:00 INFO metabase.sync.analyze classify-tables Analyzed [········] 86% Table 9 'adempiere.bi_m_storage_on_hand'
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:16+06:00 INFO metabase.sync.util FINISHED: step 'classify-tables' for postgres Database 2 'iDempiere' (3.4 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:16+06:00 INFO metabase.sync.util FINISHED: Analyze data for postgres Database 2 'iDempiere' (479.6 ms)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:19+06:00 DEBUG metabase.server.middleware.log GET /api/database/2 200 11.0 ms (7 DB calls) App DB connections: 1/7 Jetty threads: 7/50 (1 idle, 0 queued) (88 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:19+06:00 DEBUG metabase.server.middleware.log GET /api/search 200 31.7 ms (3 DB calls) App DB connections: 1/7 Jetty threads: 6/50 (1 idle, 0 queued) (88 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:19+06:00 DEBUG metabase.server.middleware.log GET /api/database/2/metadata 200 35.1 ms (8 DB calls) App DB connections: 0/7 Jetty threads: 6/50 (1 idle, 0 queued) (88 total active threads) Queries in flight: 0 (0 queued)
[1aa9268d-f5f2-4e5c-8ef3-428e1df2daf2] 2023-04-01T13:44:24+06:00 DEBUG metabase.server.middleware.log GET /api/util/bug_report_details 200 7.0 ms (1 DB calls) App DB connections: 0/7 Jetty threads: 5/50 (1 idle, 0 queued) (90 total active threads) Queries in flight: 0 (0 queued)

Kanat · April 1, 2023, 7:49am

Latest I guess

You can reproduce it

export DB_HOST=localhost
export DB_PORT=5432
export DB_NAME=idempiere
export DB_USER=adempiere
export DB_SCHEMA=adempiere
export DB_PASS=adempiere
export DB_ADMIN_PASS=postgres

export METABASE_DB_USER=metabase
export METABASE_DB_PASS=metabase

docker run -d --name postgres -p 5432:5432 -e POSTGRES_PASSWORD=postgres postgres:13

docker run -d --name custom-idempiere -p 8080:8080 --network host
-e DB_HOST=$DB_HOST
-e DB_PORT=$DB_PORT
-e DB_NAME=$DB_NAME
-e DB_SCHEMA=$DB_SCHEMA
-e DB_ADMIN_PASS=$DB_ADMIN_PASS
-e DB_USER=$DB_USER
-e DB_PASS=$DB_PASS
-e METABASE_URL=$METABASE_URL
-e METABASE_DB_USER=$METABASE_DB_USER
-e METABASE_DB_PASS=$METABASE_DB_PASS
idempiere/idempiere:8.2

rm app-version.json

docker run -d --name metabase -p 3000:3000 --network host
-e MB_SITE_NAME="Business Intelligence Solutions"
-e MB_SITE_LOCALE="us"
-e MB_DB_AUTOMIGRATE=true
-e MB_DB_CONNECTION_URI="jdbc:postgresql://$DB_HOST:$DB_PORT/$DB_NAME?user=postgres&password=postgres"
metabase/metabase

PGPASSWORD=$DB_ADMIN_PASS psql -d $DB_NAME -h $DB_HOST -U postgres -c "CREATE USER $METABASE_DB_USER WITH PASSWORD '$METABASE_DB_PASS'"
PGPASSWORD=$DB_ADMIN_PASS psql -d $DB_NAME -h $DB_HOST -U postgres -c "GRANT USAGE ON SCHEMA $DB_SCHEMA TO $METABASE_DB_USER";

There are couple of views available in adempiere scheme.

Kanat · April 1, 2023, 8:18am

So I found that. Idempiere it self resets/revokes user privileges on plugins upload.