You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by "sbrueseke (via GitHub)" <gi...@apache.org> on 2026/08/04 07:45:04 UTC
Re: [I] Usage Server repeatedly reprocesses historical usage and creates duplicate cloud_usage records for usage_type=1 [cloudstack]
sbrueseke commented on issue #13399:
URL: https://github.com/apache/cloudstack/issues/13399#issuecomment-5176070498
@DaanHoogland we run into it again. Here is the output of the database. Andy idea where to look to find the root cause? Something started at 2026-08-03 16:02:43.
`mysql> SELECT id, type, resource_id, created, processed FROM cloud_usage.usage_event WHERE processed = 0;
+--------+---------------------+-------------+---------------------+-----------+
| id | type | resource_id | created | processed |
+--------+---------------------+-------------+---------------------+-----------+
| 817825 | BACKUP.USAGE.METRIC | 1381 | 2026-08-03 16:02:43 | 0 |
| 817826 | BACKUP.USAGE.METRIC | 1258 | 2026-08-03 16:02:43 | 0 |
| 817827 | BACKUP.USAGE.METRIC | 1394 | 2026-08-03 16:02:43 | 0 |
| 817828 | BACKUP.USAGE.METRIC | 1398 | 2026-08-03 16:02:43 | 0 |
| 817829 | BACKUP.USAGE.METRIC | 1532 | 2026-08-03 16:02:43 | 0 |
| 817830 | BACKUP.USAGE.METRIC | 1536 | 2026-08-03 16:02:43 | 0 |
| 817831 | BACKUP.USAGE.METRIC | 1665 | 2026-08-03 16:02:43 | 0 |
| 817832 | BACKUP.USAGE.METRIC | 1411 | 2026-08-03 16:02:43 | 0 |
| 817833 | BACKUP.USAGE.METRIC | 1797 | 2026-08-03 16:02:43 | 0 |
| 817834 | BACKUP.USAGE.METRIC | 1670 | 2026-08-03 16:02:43 | 0 |
| 817835 | BACKUP.USAGE.METRIC | 1556 | 2026-08-03 16:02:43 | 0 |
| 817836 | BACKUP.USAGE.METRIC | 1560 | 2026-08-03 16:02:43 | 0 |
| 817837 | BACKUP.USAGE.METRIC | 1563 | 2026-08-03 16:02:43 | 0 |
| 817838 | BACKUP.USAGE.METRIC | 1693 | 2026-08-03 16:02:43 | 0 |
| 817839 | BACKUP.USAGE.METRIC | 1567 | 2026-08-03 16:02:43 | 0 |
| 817840 | BACKUP.USAGE.METRIC | 1568 | 2026-08-03 16:02:43 | 0 |
| 817841 | BACKUP.USAGE.METRIC | 1569 | 2026-08-03 16:02:43 | 0 |
| 817842 | BACKUP.USAGE.METRIC | 1570 | 2026-08-03 16:02:43 | 0 |
| 817843 | BACKUP.USAGE.METRIC | 1485 | 2026-08-03 16:02:43 | 0 |
| 817844 | BACKUP.USAGE.METRIC | 1381 | 2026-08-03 16:07:44 | 0 |
| 817845 | BACKUP.USAGE.METRIC | 1258 | 2026-08-03 16:07:44 | 0 |
| 817846 | BACKUP.USAGE.METRIC | 1394 | 2026-08-03 16:07:44 | 0 |
| 817847 | BACKUP.USAGE.METRIC | 1398 | 2026-08-03 16:07:44 | 0 |
| 817848 | BACKUP.USAGE.METRIC | 1532 | 2026-08-03 16:07:44 | 0 |
| 817849 | BACKUP.USAGE.METRIC | 1536 | 2026-08-03 16:07:44 | 0 |
| 817850 | BACKUP.USAGE.METRIC | 1665 | 2026-08-03 16:07:44 | 0 |
| 817851 | BACKUP.USAGE.METRIC | 1411 | 2026-08-03 16:07:44 | 0 |
| 817852 | BACKUP.USAGE.METRIC | 1797 | 2026-08-03 16:07:44 | 0 |
| 817853 | BACKUP.USAGE.METRIC | 1670 | 2026-08-03 16:07:44 | 0 |
| 817854 | BACKUP.USAGE.METRIC | 1556 | 2026-08-03 16:07:44 | 0 |
| 817855 | BACKUP.USAGE.METRIC | 1560 | 2026-08-03 16:07:44 | 0 |
| 817856 | BACKUP.USAGE.METRIC | 1563 | 2026-08-03 16:07:44 | 0 |
| 817857 | BACKUP.USAGE.METRIC | 1693 | 2026-08-03 16:07:44 | 0 |
| 817858 | BACKUP.USAGE.METRIC | 1567 | 2026-08-03 16:07:44 | 0 |
| 817859 | BACKUP.USAGE.METRIC | 1568 | 2026-08-03 16:07:44 | 0 |
| 817860 | BACKUP.USAGE.METRIC | 1569 | 2026-08-03 16:07:44 | 0 |
| 817861 | BACKUP.USAGE.METRIC | 1570 | 2026-08-03 16:07:44 | 0 |
| 817862 | BACKUP.USAGE.METRIC | 1485 | 2026-08-03 16:07:44 | 0 |
| 817863 | BACKUP.USAGE.METRIC | 1381 | 2026-08-03 16:12:44 | 0 |
| 817864 | BACKUP.USAGE.METRIC | 1258 | 2026-08-03 16:12:44 | 0 |
| 817865 | BACKUP.USAGE.METRIC | 1394 | 2026-08-03 16:12:44 | 0 |
| 817866 | BACKUP.USAGE.METRIC | 1398 | 2026-08-03 16:12:44 | 0 |
| 817867 | BACKUP.USAGE.METRIC | 1532 | 2026-08-03 16:12:44 | 0 |
| 817868 | BACKUP.USAGE.METRIC | 1536 | 2026-08-03 16:12:44 | 0 |
| 817869 | BACKUP.USAGE.METRIC | 1665 | 2026-08-03 16:12:44 | 0 |
| 817870 | BACKUP.USAGE.METRIC | 1411 | 2026-08-03 16:12:44 | 0 |
| 817871 | BACKUP.USAGE.METRIC | 1797 | 2026-08-03 16:12:44 | 0 |
| 817872 | BACKUP.USAGE.METRIC | 1670 | 2026-08-03 16:12:44 | 0 |
| 817873 | BACKUP.USAGE.METRIC | 1556 | 2026-08-03 16:12:44 | 0 |
| 817874 | BACKUP.USAGE.METRIC | 1560 | 2026-08-03 16:12:44 | 0 |
| 817875 | BACKUP.USAGE.METRIC | 1563 | 2026-08-03 16:12:44 | 0 |
| 817876 | BACKUP.USAGE.METRIC | 1693 | 2026-08-03 16:12:44 | 0 |
| 817877 | BACKUP.USAGE.METRIC | 1567 | 2026-08-03 16:12:44 | 0 |
| 817878 | BACKUP.USAGE.METRIC | 1568 | 2026-08-03 16:12:44 | 0 |
| 817879 | BACKUP.USAGE.METRIC | 1569 | 2026-08-03 16:12:44 | 0 |
| 817880 | BACKUP.USAGE.METRIC | 1570 | 2026-08-03 16:12:44 | 0 |
| 817881 | BACKUP.USAGE.METRIC | 1485 | 2026-08-03 16:12:44 | 0 |
| 817882 | BACKUP.USAGE.METRIC | 1381 | 2026-08-03 16:17:44 | 0 |
| 817883 | BACKUP.USAGE.METRIC | 1258 | 2026-08-03 16:17:44 | 0 |
| 817884 | BACKUP.USAGE.METRIC | 1394 | 2026-08-03 16:17:44 | 0 |
| 817885 | BACKUP.USAGE.METRIC | 1398 | 2026-08-03 16:17:44 | 0 |
| 817886 | BACKUP.USAGE.METRIC | 1532 | 2026-08-03 16:17:44 | 0 |
| 817887 | BACKUP.USAGE.METRIC | 1536 | 2026-08-03 16:17:44 | 0 |
| 817888 | BACKUP.USAGE.METRIC | 1665 | 2026-08-03 16:17:44 | 0 |
| 817889 | BACKUP.USAGE.METRIC | 1411 | 2026-08-03 16:17:44 | 0 |
| 817890 | BACKUP.USAGE.METRIC | 1797 | 2026-08-03 16:17:44 | 0 |
| 817891 | BACKUP.USAGE.METRIC | 1670 | 2026-08-03 16:17:44 | 0 |
| 817892 | BACKUP.USAGE.METRIC | 1556 | 2026-08-03 16:17:44 | 0 |
| 817893 | BACKUP.USAGE.METRIC | 1560 | 2026-08-03 16:17:44 | 0 |
| 817894 | BACKUP.USAGE.METRIC | 1563 | 2026-08-03 16:17:44 | 0 |
| 817895 | BACKUP.USAGE.METRIC | 1693 | 2026-08-03 16:17:44 | 0 |
| 817896 | BACKUP.USAGE.METRIC | 1567 | 2026-08-03 16:17:44 | 0 |
| 817897 | BACKUP.USAGE.METRIC | 1568 | 2026-08-03 16:17:44 | 0 |
| 817898 | BACKUP.USAGE.METRIC | 1569 | 2026-08-03 16:17:44 | 0 |
| 817899 | BACKUP.USAGE.METRIC | 1570 | 2026-08-03 16:17:44 | 0 |
| 817900 | BACKUP.USAGE.METRIC | 1485 | 2026-08-03 16:17:44 | 0 |
| 817901 | NETWORK.CREATE | 411 | 2026-08-03 16:22:08 | 0 |
| 817902 | NET.IPASSIGN | 30 | 2026-08-03 16:22:08 | 0 |
| 817903 | NETWORK.UPDATE | 411 | 2026-08-03 16:22:39 | 0 |
| 817904 | VOLUME.CREATE | 2003 | 2026-08-03 16:22:40 | 0 |
+--------+---------------------+-------------+---------------------+-----------+
`
--
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: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org