Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-17296

nuxeo-quota addon: initial computation of quotaStatsUpdater 'documentsSizeUpdater' does not work properly

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 6.0-HF13
    • Fix Version/s: 5.8.0-HF35, 6.0-HF15, 7.4
    • Component/s: Quotas

      Description

      Counters totalsize and innersize of documents (with blob and their parents) increase every time the initial computation of quotaStatsUpdater 'documentsSizeUpdater' is launch.

      How to reproduce:

      • empty database
      • install nuxeo-quota addon
      • start Nuxeo Platform
      • create a File with a file attached (file size 6611 bytes)
        SELECT * FROM public.documents_size_statistics;
                          id                  | maxsize | totalsize | sizetrash | sizeversions | innersize 
        --------------------------------------+---------+-----------+-----------+--------------+-----------
         2bc59b3f-b25b-4d69-9d47-e013382f1631 |      -1 |      6611 |         0 |            0 |         0
         3b1476e9-2906-4312-92be-a2c81a61c7b6 |      -1 |      6611 |         0 |            0 |         0
         1dd48779-ff5e-4893-8745-7c6dc22fcb72 |      -1 |      6611 |         0 |            0 |         0
         d92cfd4a-979c-4bc2-8507-a185191e437b |      -1 |      6611 |         0 |            0 |      6611
         6490e5d7-8c0b-4ec5-81ac-35de98ec7735 |      -1 |      6611 |         0 |            0 |         0
        (5 rows)
        
      • run Quota Updater, counter innnersize and totalsize of File document previously created increased (see table documents_size_statistics)
        SELECT * FROM public.documents_size_statistics;
                          id                  | maxsize | totalsize | sizetrash | sizeversions | innersize 
        --------------------------------------+---------+-----------+-----------+--------------+-----------
         0ce401df-abd3-4a8c-a326-f4005b40c092 |      -1 |         0 |         0 |            0 |         0
         3e2a0a82-12ea-49fa-be10-daae2be17fde |      -1 |         0 |         0 |            0 |         0
         df03f379-1f69-440b-be80-cdaa62bb2e18 |      -1 |         0 |         0 |            0 |         0
         1dd48779-ff5e-4893-8745-7c6dc22fcb72 |      -1 |     13222 |         0 |            0 |         0
         d92cfd4a-979c-4bc2-8507-a185191e437b |      -1 |     13222 |         0 |            0 |     13222
         47ff3f79-52fd-4eac-9b07-86f08c3a267a |      -1 |         0 |         0 |            0 |         0
         fd2a83bf-6438-4a94-ab27-3dff56b92cba |      -1 |         0 |         0 |            0 |         0
         06dc02ff-c215-4505-bf64-32f838df8ef9 |      -1 |         0 |         0 |            0 |         0
         8a9310e6-ba2f-4392-aab7-58b9322772a4 |      -1 |         0 |         0 |            0 |         0
         6fe18bc0-2cde-4033-adb3-a99a865ef9bc |      -1 |         0 |         0 |            0 |         0
         aa0d36aa-16c8-4aca-8ba6-e45208c4ee2b |      -1 |         0 |         0 |            0 |         0
         b3df4211-fe2d-4bb0-804f-6280b6253255 |      -1 |         0 |         0 |            0 |         0
         1b914623-6039-468e-aea2-5659f2e8ac7d |      -1 |         0 |         0 |            0 |         0
         b1600fd9-eb80-404f-a04c-9ebccd9173f9 |      -1 |         0 |         0 |            0 |         0
         b61892d7-1ae4-47b8-92f9-9e87f4898c14 |      -1 |         0 |         0 |            0 |         0
         8d6ffff5-075e-4025-b199-eb9989bcaaad |      -1 |         0 |         0 |            0 |         0
         19138ed0-8f63-4f55-9f11-238e1b14f291 |      -1 |         0 |         0 |            0 |         0
         5b70ae96-5adf-4830-9a2e-df1cb594c5cd |      -1 |         0 |         0 |            0 |         0
         c713e867-661c-4027-b1c5-d5d7fc7d2ac1 |      -1 |         0 |         0 |            0 |         0
         2af5c396-8d6f-4a8a-b270-d03d2ade9b67 |      -1 |         0 |         0 |            0 |         0
         4d4fe89e-2503-4e74-a064-2c550ae59515 |      -1 |         0 |         0 |            0 |         0
         e742f654-8ab3-4cb9-a547-e04794a82236 |      -1 |         0 |         0 |            0 |         0
         e04939e1-6ac9-4d47-b038-d9aabfe11e51 |      -1 |         0 |         0 |            0 |         0
         eee1b536-e5fa-433a-9434-32e7f6a4e818 |      -1 |         0 |         0 |            0 |         0
         b6c5da6e-fc3f-4a2c-be14-3818f75deece |      -1 |         0 |         0 |            0 |         0
         3d3082e4-dd79-4b25-a624-f7e1cff37ecf |      -1 |         0 |         0 |            0 |         0
         34074385-75f8-4b24-9bf2-cbfde9f1a4e8 |      -1 |         0 |         0 |            0 |         0
         c15f07bd-ac2f-4d52-87c1-412bc7fa4df8 |      -1 |         0 |         0 |            0 |         0
         f18eb927-6c2d-46ff-ada6-542b9d8ed59a |      -1 |         0 |         0 |            0 |         0
         cea2c949-74ea-4030-b6bd-7df31c2670d7 |      -1 |         0 |         0 |            0 |         0
         43f6bebb-72c0-4a12-8c46-4c7773cc867a |      -1 |         0 |         0 |            0 |         0
         8d5c9a3f-e5fb-4441-978f-99368ac7d434 |      -1 |         0 |         0 |            0 |         0
         2ed538b3-378d-4107-a2fc-b8daebdf19ea |      -1 |         0 |         0 |            0 |         0
         7825aba2-235f-4b2f-88d7-be0674c8534c |      -1 |         0 |         0 |            0 |         0
         1d54df7b-409a-4531-a8c8-13df020af12d |      -1 |         0 |         0 |            0 |         0
         276dd016-1dc7-4258-bc07-4182058756c1 |      -1 |         0 |         0 |            0 |         0
         d0cdf86a-932e-4884-912b-51334b0666c5 |      -1 |         0 |         0 |            0 |         0
         3f817172-30f7-4c9d-ab72-b7b80fcb558c |      -1 |         0 |         0 |            0 |         0
         1768d320-256a-4b50-82f0-2e44c1fd2127 |      -1 |         0 |         0 |            0 |         0
         ee6573b8-7d6b-4eca-acea-a4d5faca6eef |      -1 |         0 |         0 |            0 |         0
         cf1b5d94-cc10-44de-8d4d-96c26539b877 |      -1 |         0 |         0 |            0 |         0
         03499a5f-ee9d-4cce-b484-6c63095d495d |      -1 |         0 |         0 |            0 |         0
         600c9854-1db7-4191-bfeb-e45ba9d6e029 |      -1 |         0 |         0 |            0 |         0
         8fab61c4-4ef2-40d9-9e96-240ae42cee5d |      -1 |         0 |         0 |            0 |         0
         c4bff543-bf4e-488b-86cb-c9ee00b2413e |      -1 |         0 |         0 |            0 |         0
         8abeffb0-64c9-4af4-8e9f-db113d232317 |      -1 |         0 |         0 |            0 |         0
         ce6526c8-fd4c-4496-bdb3-b6bb5d67682a |      -1 |         0 |         0 |            0 |         0
         6490e5d7-8c0b-4ec5-81ac-35de98ec7735 |      -1 |     13222 |         0 |            0 |         0
         2bc59b3f-b25b-4d69-9d47-e013382f1631 |      -1 |     13222 |         0 |            0 |         0
         3b1476e9-2906-4312-92be-a2c81a61c7b6 |      -1 |     13222 |         0 |            0 |         0
         5005046c-6dd5-421e-aec2-c85fd3f82d02 |      -1 |         0 |         0 |            0 |         0
         38f37a8a-82ae-416c-82fa-29476556a060 |      -1 |         0 |         0 |            0 |         0
        (52 rows)
        

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: