August 2024 - Hpcoatmeal - Comm.Collab.Science.Gc.Ca

[Execution failed] Job clean-logs finished in 29.005783709s

by gdb_scheduler＠science.gc.ca

8 months

1
0
0 / 0

[Execution failed] Job clean-logs finished in 29.006425211s

by gdb_scheduler＠science.gc.ca

8 months

1
0
0 / 0

[Execution failed] Job clean-logs finished in 24.843616813s

by gdb_scheduler＠science.gc.ca

8 months

1
0
0 / 0

[Execution failed] Job check-partition-size finished in 52.594708ms

by gdb_scheduler＠science.gc.ca

8 months

1
0
0 / 0

[Execution failed] Job clean-logs finished in 8m19.752376292s

by gdb_scheduler＠science.gc.ca

8 months, 1 week

1
0
0 / 0

Job table memory clean-up

by root

Date: 2024-08-28 00:00:00 The total memory size is: 32861736. A cleanup has been performed on the following partitions: Partition: hpco_gdb.job_cluster_gpsc5 hpco_gdb.job_cluster_gpsc5 size is: 637919232 bytes. It exceeds the threshold of 27932475 bytes. Backup created for hpco_gdb.job_cluster_gpsc5: /gpfs/fs5/ssc/ssc_hpco/gdb_operation/gdb/warehouse/ofelia_memory_check/backup_2024-08-28_hpco_gdb.job_cluster_gpsc5.sql Average row size for hpco_gdb.job_cluster_gpsc5: 838 bytes per row. Total number of rows before cleanup: 643959. Number of rows to be deleted: 628274. Total number of rows after clean-up: 15685. Partition size after cleanup: 234283008 bytes. Partition: hpco_gdb.job_cluster_gpsc6 hpco_gdb.job_cluster_gpsc6 size is: 488161280 bytes. It exceeds the threshold of 27932475 bytes. Backup created for hpco_gdb.job_cluster_gpsc6: /gpfs/fs5/ssc/ssc_hpco/gdb_operation/gdb/warehouse/ofelia_memory_check/backup_2024-08-28_hpco_gdb.job_cluster_gpsc6.sql Average row size for hpco_gdb.job_cluster_gpsc6: 934 bytes per row. Total number of rows before cleanup: 476719. Number of rows to be deleted: 462646. Total number of rows after clean-up: 14073. Partition size after cleanup: 11231232 bytes. Partition: hpco_gdb.job_cluster_gpsc7 hpco_gdb.job_cluster_gpsc7 size is: 2963611648 bytes. It exceeds the threshold of 27932475 bytes. Backup created for hpco_gdb.job_cluster_gpsc7: /gpfs/fs5/ssc/ssc_hpco/gdb_operation/gdb/warehouse/ofelia_memory_check/backup_2024-08-28_hpco_gdb.job_cluster_gpsc7.sql Average row size for hpco_gdb.job_cluster_gpsc7: 756 bytes per row. Total number of rows before cleanup: 2584113. Number of rows to be deleted: 2566726. Total number of rows after clean-up: 17387. Partition size after cleanup: 11427840 bytes. Partition: hpco_gdb.job_cluster_gpsc8 hpco_gdb.job_cluster_gpsc8 size is: 2276794368 bytes. It exceeds the threshold of 27932475 bytes. Backup created for hpco_gdb.job_cluster_gpsc8: /gpfs/fs5/ssc/ssc_hpco/gdb_operation/gdb/warehouse/ofelia_memory_check/backup_2024-08-28_hpco_gdb.job_cluster_gpsc8.sql Average row size for hpco_gdb.job_cluster_gpsc8: 662 bytes per row. Total number of rows before cleanup: 2130562. Number of rows to be deleted: 2110706. Total number of rows after clean-up: 19856. Partition size after cleanup: 14737408 bytes. Partition: hpco_gdb.job_cluster_gpscc3 hpco_gdb.job_cluster_gpscc3 size is: 232464384 bytes. It exceeds the threshold of 27932475 bytes. Backup created for hpco_gdb.job_cluster_gpscc3: /gpfs/fs5/ssc/ssc_hpco/gdb_operation/gdb/warehouse/ofelia_memory_check/backup_2024-08-28_hpco_gdb.job_cluster_gpscc3.sql Average row size for hpco_gdb.job_cluster_gpscc3: 898 bytes per row. Total number of rows before cleanup: 176670. Number of rows to be deleted: 162033. Total number of rows after clean-up: 14637. Partition size after cleanup: 10051584 bytes. Partition: hpco_gdb.job_cluster_ppp5 hpco_gdb.job_cluster_ppp5 size is: 1133346816 bytes. It exceeds the threshold of 27932475 bytes. Backup created for hpco_gdb.job_cluster_ppp5: /gpfs/fs5/ssc/ssc_hpco/gdb_operation/gdb/warehouse/ofelia_memory_check/backup_2024-08-28_hpco_gdb.job_cluster_ppp5.sql Average row size for hpco_gdb.job_cluster_ppp5: 0 bytes per row. Total number of rows before cleanup: 0. Number of rows to be deleted: . Total number of rows after clean-up: 0. Partition size after cleanup: 57344 bytes. Partition: hpco_gdb.job_cluster_ppp6 hpco_gdb.job_cluster_ppp6 size is: 525516800 bytes. It exceeds the threshold of 27932475 bytes. Backup created for hpco_gdb.job_cluster_ppp6: /gpfs/fs5/ssc/ssc_hpco/gdb_operation/gdb/warehouse/ofelia_memory_check/backup_2024-08-28_hpco_gdb.job_cluster_ppp6.sql Average row size for hpco_gdb.job_cluster_ppp6: 0 bytes per row. Total number of rows before cleanup: 0. Number of rows to be deleted: . Total number of rows after clean-up: 0. Partition size after cleanup: 57344 bytes. Partition: hpco_gdb.job_cluster_robert hpco_gdb.job_cluster_robert size is: 3449520128 bytes. It exceeds the threshold of 27932475 bytes. Backup created for hpco_gdb.job_cluster_robert: /gpfs/fs5/ssc/ssc_hpco/gdb_operation/gdb/warehouse/ofelia_memory_check/backup_2024-08-28_hpco_gdb.job_cluster_robert.sql Average row size for hpco_gdb.job_cluster_robert: 553 bytes per row. Total number of rows before cleanup: 3668353. Number of rows to be deleted: 3644584. Total number of rows after clean-up: 23778. Partition size after cleanup: 7307264 bytes. Partition: hpco_gdb.job_cluster_underhill hpco_gdb.job_cluster_underhill size is: 1893154816 bytes. It exceeds the threshold of 27932475 bytes. Backup created for hpco_gdb.job_cluster_underhill: /gpfs/fs5/ssc/ssc_hpco/gdb_operation/gdb/warehouse/ofelia_memory_check/backup_2024-08-28_hpco_gdb.job_cluster_underhill.sql Average row size for hpco_gdb.job_cluster_underhill: 554 bytes per row. Total number of rows before cleanup: 2829083. Number of rows to be deleted: 2805357. Total number of rows after clean-up: 23732. Partition size after cleanup: 8134656 bytes.

8 months, 1 week