Metabase application is getting crashed need help

1

java -jar /opt/metabase/prod/current/metabase.jar >> /tmp/metabase/prod/metabase.out &

java -Duser.timezone="Asia/Kolkata" -verbose:gc -Xmn4096m -Xms8192m -Xmx22384m -XX:+UseG1GC -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/tmp/metabase/ -Dlog4j.configurationFile=file:/home/metabase/metabase/log4j2.xml -Dlog4j2.formatMsgNoLookups=true -jar /home/metabase/metabase/current/metabase.jar 1>> /home/metabase/logs/metabase/metabase-date +%y-%m-%d.out 2>&1 &
echo "$!" > pid
~

Above are my configurations, can anyone suggest, if these configurations are ok? My server RAM size is 32gb and we are spooling data from MySQL and redshift both

2

you need to attach logs to see why Metabase is crashing

3

2024-02-04 00:00:00,012 [MetabaseScheduler_Worker-5] INFO metabase.task.send-pulses - Sending scheduled pulses...
2024-02-04 00:00:00,028 [MetabaseScheduler_Worker-4] INFO metabase.task.sync-databases - Starting sync task for Database 3.
2024-02-04 00:00:00,031 [MetabaseScheduler_Worker-4] INFO metabase.sync.util - STARTING: Sync metadata for mysql Database 3 'VTrans Prod Analytics OLTP'
2024-02-04 00:00:00,032 [MetabaseScheduler_Worker-4] INFO metabase.sync.util - STARTING: step 'sync-timezone' for mysql Database 3 'VTrans Prod Analytics OLTP'
2024-02-04 00:00:00,041 [MetabaseScheduler_Worker-4] INFO metabase.sync.util - FINISHED: step 'sync-timezone' for mysql Database 3 'VTrans Prod Analytics OLTP' (8.6 ms)
2024-02-04 00:00:00,041 [MetabaseScheduler_Worker-4] INFO metabase.sync.util - STARTING: step 'sync-tables' for mysql Database 3 'VTrans Prod Analytics OLTP'
2024-02-04 00:00:00,052 [MetabaseScheduler_Worker-8] INFO metabase.task.sync-databases - Update Field values task triggered for Database 3.
2024-02-04 00:00:00,053 [MetabaseScheduler_Worker-8] INFO metabase.task.sync-databases - Skipping update, automatic Field value updates are disabled for Database 3.
2024-02-04 00:00:00,463 [MetabaseScheduler_Worker-4] INFO metabase.sync.util - FINISHED: step 'sync-tables' for mysql Database 3 'VTrans Prod Analytics OLTP' (422.1 ms)
2024-02-04 00:00:00,463 [MetabaseScheduler_Worker-4] INFO metabase.sync.util - STARTING: step 'sync-fields' for mysql Database 3 'VTrans Prod Analytics OLTP'
2024-02-04 00:00:06,631 [MetabaseScheduler_Worker-4] INFO metabase.sync.util - FINISHED: step 'sync-fields' for mysql Database 3 'VTrans Prod Analytics OLTP' (6.2 s)
2024-02-04 00:00:06,631 [MetabaseScheduler_Worker-4] INFO metabase.sync.util - STARTING: step 'sync-fks' for mysql Database 3 'VTrans Prod Analytics OLTP'
2024-02-04 00:00:07,159 [MetabaseScheduler_Worker-4] INFO metabase.sync.util - FINISHED: step 'sync-fks' for mysql Database 3 'VTrans Prod Analytics OLTP' (528.0 ms)
2024-02-04 00:00:07,160 [MetabaseScheduler_Worker-4] INFO metabase.sync.util - STARTING: step 'sync-metabase-metadata' for mysql Database 3 'VTrans Prod Analytics OLTP'
2024-02-04 00:00:07,444 [MetabaseScheduler_Worker-4] INFO metabase.sync.util - FINISHED: step 'sync-metabase-metadata' for mysql Database 3 'VTrans Prod Analytics OLTP' (284.3 ms)
2024-02-04 00:00:07,455 [MetabaseScheduler_Worker-4] INFO metabase.sync.util - FINISHED: Sync metadata for mysql Database 3 'VTrans Prod Analytics OLTP' (7.4 s)
2024-02-04 01:00:00,011 [MetabaseScheduler_Worker-1] INFO metabase.task.send-pulses - Sending scheduled pulses...
2024-02-04 01:00:00,023 [MetabaseScheduler_Worker-7] INFO metabase.task.sync-databases - Starting sync task for Database 2.
2024-02-04 01:00:00,025 [MetabaseScheduler_Worker-7] INFO metabase.sync.util - STARTING: Sync metadata for redshift Database 2 'VTrans Prod DWH'
2024-02-04 01:00:00,026 [MetabaseScheduler_Worker-7] INFO metabase.sync.util - STARTING: step 'sync-timezone' for redshift Database 2 'VTrans Prod DWH'
2024-02-04 01:00:03,825 [MetabaseScheduler_Worker-7] INFO metabase.sync.util - FINISHED: step 'sync-timezone' for redshift Database 2 'VTrans Prod DWH' (3.8 s)
2024-02-04 01:00:03,825 [MetabaseScheduler_Worker-7] INFO metabase.sync.util - STARTING: step 'sync-tables' for redshift Database 2 'VTrans Prod DWH'
2024-02-04 01:00:18,090 [MetabaseScheduler_Worker-7] INFO metabase.sync.util - FINISHED: step 'sync-tables' for redshift Database 2 'VTrans Prod DWH' (14.3 s)
2024-02-04 01:00:18,091 [MetabaseScheduler_Worker-7] INFO metabase.sync.util - STARTING: step 'sync-fields' for redshift Database 2 'VTrans Prod DWH'
2024-02-04 01:00:41,409 [MetabaseScheduler_Worker-7] INFO metabase.sync.util - FINISHED: step 'sync-fields' for redshift Database 2 'VTrans Prod DWH' (23.3 s)
2024-02-04 01:00:41,409 [MetabaseScheduler_Worker-7] INFO metabase.sync.util - STARTING: step 'sync-fks' for redshift Database 2 'VTrans Prod DWH'
2024-02-04 01:01:00,581 [MetabaseScheduler_Worker-7] INFO metabase.sync.util - FINISHED: step 'sync-fks' for redshift Database 2 'VTrans Prod DWH' (19.2 s)
2024-02-04 01:01:00,582 [MetabaseScheduler_Worker-7] INFO metabase.sync.util - STARTING: step 'sync-metabase-metadata' for redshift Database 2 'VTrans Prod DWH'
2024-02-04 01:01:13,524 [MetabaseScheduler_Worker-7] INFO metabase.sync.util - FINISHED: step 'sync-metabase-metadata' for redshift Database 2 'VTrans Prod DWH' (12.9 s)
2024-02-04 01:01:13,538 [MetabaseScheduler_Worker-7] INFO metabase.sync.util - FINISHED: Sync metadata for redshift Database 2 'VTrans Prod DWH' (1.2 mins)
2024-02-04 01:01:13,538 [MetabaseScheduler_Worker-7] INFO metabase.sync.util - STARTING: Analyze data for redshift Database 2 'VTrans Prod DWH'
2024-02-04 01:01:13,540 [MetabaseScheduler_Worker-7] INFO metabase.sync.util - STARTING: step 'fingerprint-fields' for redshift Database 2 'VTrans Prod DWH'
2024-02-04 01:01:13,552 [MetabaseScheduler_Worker-7] INFO metabase.sync.analyze - fingerprint-fields Analyzed [·············································] :cry: 11% Table 400 'prod_vtrans.crm_team'
2024-02-04 01:01:15,162 [MetabaseScheduler_Worker-7] INFO metabase.sync.analyze - fingerprint-fields Analyzed [········································] :unamused: 22% Table 326 'prod_vtrans.invoice_detail'
2024-02-04 01:01:15,169 [MetabaseScheduler_Worker-7] INFO metabase.sync.analyze - fingerprint-fields Analyzed [··································] :confused: 32% Table 321 'prod_vtrans.transport_order_cost_revenues'
2024-02-04 01:01:15,169 [MetabaseScheduler_Worker-7] INFO metabase.sync.util - FINISHED: step 'fingerprint-fields' for redshift Database 2 'VTrans Prod DWH' (1.6 s)
2024-02-04 01:01:15,170 [MetabaseScheduler_Worker-7] INFO metabase.sync.util - STARTING: step 'classify-fields' for redshift Database 2 'VTrans Prod DWH'
2024-02-04 01:01:15,176 [MetabaseScheduler_Worker-7] INFO metabase.sync.analyze - classify-fields Analyzed [·····························] :neutral_face: 43% Table 400 'prod_vtrans.crm_team'
2024-02-04 01:01:15,179 [MetabaseScheduler_Worker-7] INFO metabase.sync.analyze - classify-fields Analyzed [·······················] :grimacing: 54% Table 326 'prod_vtrans.invoice_detail'
2024-02-04 01:01:15,181 [MetabaseScheduler_Worker-7] INFO metabase.sync.analyze - classify-fields Analyzed [··················] :smirk: 65% Table 321 'prod_vtrans.transport_order_cost_revenues'
2024-02-04 01:01:15,181 [MetabaseScheduler_Worker-7] INFO metabase.sync.util - FINISHED: step 'classify-fields' for redshift Database 2 'VTrans Prod DWH' (11.7 ms)
2024-02-04 01:01:15,182 [MetabaseScheduler_Worker-7] INFO metabase.sync.util - STARTING: step 'classify-tables' for redshift Database 2 'VTrans Prod DWH'
2024-02-04 01:01:15,185 [MetabaseScheduler_Worker-7] INFO metabase.sync.analyze - classify-tables Analyzed [·············] :yum: 76% Table 400 'prod_vtrans.crm_team'
2024-02-04 01:01:15,188 [MetabaseScheduler_Worker-7] INFO metabase.sync.analyze - classify-tables Analyzed [·······] :blush: 86% Table 326 'prod_vtrans.invoice_detail'
2024-02-04 01:01:15,190 [MetabaseScheduler_Worker-7] INFO metabase.sync.analyze - classify-tables Analyzed [***************************··] :sunglasses: 97% Table 321 'prod_vtrans.transport_order_cost_revenues'
2024-02-04 01:01:15,191 [MetabaseScheduler_Worker-7] INFO metabase.sync.util - FINISHED: step 'classify-tables' for redshift Database 2 'VTrans Prod DWH' (8.9 ms)
2024-02-04 01:01:15,205 [MetabaseScheduler_Worker-7] INFO metabase.sync.util - FINISHED: Analyze data for redshift Database 2 'VTrans Prod DWH' (1.7 s)

Above are the logs

4

Please help us to come out of this problem. We are using Metabase 0.37.6 version.