brocaar opened a new issue, #1493:
URL: https://github.com/apache/answer/issues/1493
## Describe the bug
After leaving Answer for some time (days?) running, the CPU usage jumps and
stays at around 99%, even when it is not serving any requests. The
web-interface is still responsive enough to keep it functional, but after a
restart (I have to kill the process) it hardly consumes any CPU.
## To Reproduce
I'm not sure how to reproduce / trigger this. It happens after a couple of
days running. I noticed web-requests take slightly longer and I inspected the
CPU usage. This already happened a few times in a row.
## Expected behavior
CPU usage stays stable.
## Logs
```
Feb 02 10:32:48 chirpstack-support answer[2067003]: 2026-02-02 10:32:48.045
ERROR activity_common/vote.go:60 pq: invalid input syntax
for type bigint: ""
Feb 02 10:32:48 chirpstack-support answer[2067003]: 2026-02-02 10:32:48.288
ERROR activity_common/vote.go:60 pq: invalid input syntax
for type bigint: ""
Feb 02 10:32:48 chirpstack-support answer[2067003]: 2026-02-02 10:32:48.429
ERROR activity_common/vote.go:60 pq: invalid input syntax
for type bigint: ""
Feb 02 10:36:25 chirpstack-support answer[2067003]: 2026-02-02 10:36:25.605
ERROR activity_common/vote.go:60 pq: invalid input syntax
for type bigint: ""
Feb 02 10:36:25 chirpstack-support answer[2067003]: 2026-02-02 10:36:25.767
ERROR activity_common/vote.go:60 pq: invalid input syntax
for type bigint: ""
Feb 02 10:40:00 chirpstack-support answer[2067003]: 2026-02-02 10:40:00.025
INFO cron/cron.go:88 checking expired user suspensions
Feb 02 10:45:16 chirpstack-support answer[2067003]: 2026-02-02 10:45:16.946
ERROR activity_common/vote.go:60 pq: invalid input syntax
for type bigint: ""
Feb 02 10:45:31 chirpstack-support answer[2067003]: 2026-02-02 10:45:31.729
ERROR activity_common/vote.go:60 pq: invalid input syntax
for type bigint: ""
Feb 02 10:45:31 chirpstack-support answer[2067003]: 2026-02-02 10:45:31.870
ERROR activity_common/vote.go:60 pq: invalid input syntax
for type bigint: ""
Feb 02 10:45:32 chirpstack-support answer[2067003]: 2026-02-02 10:45:32.032
ERROR activity_common/vote.go:60 pq: invalid input syntax
for type bigint: ""
```
There is nothing special in the logs. I will restart the process with
`LOG_LEVEL=DEBUG` to gather more log-output.
## Platform
- OS: Linux AMD64
- Version: v1.7.1
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
