DaanHoogland commented on PR #8136:
URL: https://github.com/apache/cloudstack/pull/8136#issuecomment-1948475804
I guess it kind of worked because
```
14:17:18.487 [main] ERROR com.cloud.usage.UsageSanityChecker - Error: Found
919 usage records with raw_usage > 24
```
after running
```
/usr/bin/java -Xmx2G -cp
/usr/share/cloudstack-usage/*:/usr/share/cloudstack-usage/lib/*:/usr/share/cloudstack-mysql-ha/lib/*:/etc/cloudstack/usage:/usr/share/java/mysql-connector-java.jar:/usr/share/cloudstack-common
com.cloud.usage.UsageSanityChecker
```
unfortunately I had to look up the issue in the code:
```
addCheckCase("SELECT count(*) FROM `cloud_usage`.`cloud_usage` cu
where usage_type not in (4,5) and raw_usage > "
+ aggregationHours,
"usage records with raw_usage > " + aggregationHours,
lastCheckId);
```
Out of scope for this PR but I think we can improve there, @winterhazel , cc
@vishesh92 .
@JoaoJandre are your concerns met?
--
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]
