Messages

1

Hardware and Performance / Re: High CPU-load caused by two sqlite3-processes

« on: May 04, 2021, 08:41:36 am »

Right, will do! Actually, for my TrueNAS-VM as well :-)

I totally agree with Ricardo: we should document your input somehow, so it's easier to find. I'd be happy to contribute, if you instruct me.

2

Hardware and Performance / Re: High CPU-load caused by two sqlite3-processes

« on: May 03, 2021, 10:20:46 pm »

Hi.

The only alternative I have to i440fx is q35, which is even older. So I stick to i440fx for now.

I changed the network adapter to VMware vmxnet3 and will monitor if this helps. If the network is more reliable now, we know for sure what caused it. I will report back to you.

Thanks again!

3

Hardware and Performance / Re: High CPU-load caused by two sqlite3-processes

« on: May 01, 2021, 04:36:38 pm »

I really appreciate that you spend so much time on this.

See the screenshot attched.
The em1 has a cat5e cable with rj45-connector (1000Mbit), to a router from my ISP, switching to fiber there:

Code: [Select]

Status up
DHCP
up   
MAC address
MTU 1500
IPv4 address
IPv4 gateway
IPv6 link-local
DNS servers 109.247.114.4
92.220.228.70
Media 1000baseT <full-duplex>
In/out packets 156306529 / 156761362 (206.97 GB / 27.24 GB)
In/out packets (pass) 156101589 / 156761362 (206.96 GB / 27.24 GB)
In/out packets (block) 3403990 / 0 (200 KB / 0 bytes)
In/out errors 0 / 0
Collisions 0
Interrupts
irq device total rate
irq11 em1:irq0++ 147233016 877 

Code: [Select]

root@OPNsense:~ # vmstat -i
interrupt                          total       rate
irq1: atkbd0                         199          0
irq10: em0:irq0                126321288        743
irq11: em1:irq0++              147666702        869
irq14: ata0                     72743347        428
cpu0:timer                       9987002         59
cpu1:timer                       7230780         43
cpu2:timer                      10365342         61
cpu3:timer                       6961074         41
Total                          381275734       2243

The underlying physical storage... unsure what you want to know... a local SSD, SCSI controller

4

Hardware and Performance / Re: High CPU-load caused by two sqlite3-processes

« on: April 30, 2021, 08:25:38 am »

Second image...

5

Hardware and Performance / Re: High CPU-load caused by two sqlite3-processes

« on: April 30, 2021, 08:23:38 am »

Find 2 screenshots below. The first one is with netflow disabled, the second has netflow enabled.

Is this system pushing a lot of traffic?

I've been uploading 100Gb to Nextcloud yesterday (using Nextclouds web-interface), from a PC outside the LAN. Other than that, It was mostly just browsing or streaming some music. I am unexperienced when it comes to network, but I don't believe that this cause a higher CPU load. It's a home network with very limited amount of users.

6

Hardware and Performance / Re: High CPU-load caused by two sqlite3-processes

« on: April 29, 2021, 09:07:18 pm »

Please see the screenshot below.
Of course, now that the doctor is here, the pain vannishes: CPU is down to 25%. I am not aware of any changes in my network that could cause this. I will keep an eye on it a run the command again, when the CPU-load rises again.

7

Hardware and Performance / Re: High CPU-load caused by two sqlite3-processes

« on: April 29, 2021, 06:52:41 pm »

Adding a screenshot of system resources, including CPU-load...

8

Hardware and Performance / High CPU-load caused by two sqlite3-processes

« on: April 29, 2021, 06:49:16 pm »

Hi all!

I am worried about the CPU loadin OPNsense, which is in average about 60%. Even if there is little traffic going on.
"top" tells me, that two sqlite3-processes use about 50% of my CPU. Shouldn't be like that, should it?

I would be very grateful if someone could help me troubleshooting this. Thanks in advance.

dejhost
---

My  Setup:

• OPNsense v. 21.1.5-amd64, FreeBSD 12.1-RELEASE-p16-HBSD, OpenSSL 1.1.1k 25 Mar 2021.
• OPNsense is a VM within Proxmox, PVE Manager Version pve-manager/6.4-4/337d6701.
• Hardware: Lenovo Thinkserver (https://support.lenovo.com/cy/en/solutions/pd014761), with CPU(s) 8 x Intel(R) Xeon(R) CPU E3-1240 V2 @ 3.40GHz.
• The OPNsense-VM has 2Gb of RAM, 4 Cores Type Sandybridge. The last 4 CPU-flags in Proxmox are disabled - please see image attached.