Almalinux 8.8.0 standard kvm
Cpanel 112.0.7
I see high cpu user for: /usr/sbin/nft --json list ruleset
cPHulk has lots of records for One-day Blocks
Narrowed it down to cPHulk database issues, hope someone can explain.
[root@buy ~]# /usr/local/cpanel/3rdparty/bin/sqlite3 /var/cpanel/hulkd/cphulk.sqlite
SQLite version 3.38.5 2022-05-06 15:25:27
Enter ".help" for usage hints.
sqlite> select count(*) from ip_lists;
391987
sqlite> .quit
If you want to see how senseless those records are see this:
[root@buy ~]# /usr/local/cpanel/3rdparty/bin/sqlite3 /var/cpanel/hulkd/cphulk.sqlite
SQLite version 3.38.5 2022-05-06 15:25:27
Enter ".help" for usage hints.
sqlite> select * from ip_lists limit 50;
||4|AD
||4|AD
||4|AD
||4|AD
||4|AD
etc
Cpanel 112.0.7
I see high cpu user for: /usr/sbin/nft --json list ruleset
cPHulk has lots of records for One-day Blocks
Narrowed it down to cPHulk database issues, hope someone can explain.
[root@buy ~]# /usr/local/cpanel/3rdparty/bin/sqlite3 /var/cpanel/hulkd/cphulk.sqlite
SQLite version 3.38.5 2022-05-06 15:25:27
Enter ".help" for usage hints.
sqlite> select count(*) from ip_lists;
391987
sqlite> .quit
If you want to see how senseless those records are see this:
[root@buy ~]# /usr/local/cpanel/3rdparty/bin/sqlite3 /var/cpanel/hulkd/cphulk.sqlite
SQLite version 3.38.5 2022-05-06 15:25:27
Enter ".help" for usage hints.
sqlite> select * from ip_lists limit 50;
||4|AD
||4|AD
||4|AD
||4|AD
||4|AD
etc
|
Last edited by a moderator: