[opencms-dev] OpenCMS bug? Delete content everywhere, DB is still too large (10GB+)

[gleb makarov]

Hi Deiverson,

Thanks for your reply.

I know that this issue was announced as fixed, but as I wrote we still have
it. So I`d like to understand whether it is our local problem, or not.

2011/7/28 Deiverson Silveira <deiverson at solutioncms.com>

> Hi,
>
> In version 7.5.4, is fixed this problem:
> * Fixed issue #1949: Database size does not decrease after (completely)
> deleting resources
>
> Regards,
>
> Deiverson Silveira
>
>
> 2011/7/28 gleb makarov <gleb.a.makarov at gmail.com>
>
>> Hello everyone,
>>
>> We were trying to reduce the size of the DB by deleting the content and
>> history versions, but its size wasn`t decreased. We had the same problem on
>> 7.5.2 version, and tried to clean up the DB after upgrading to 7.5.4, but
>> still couldn`t reduce its size.
>>
>> Does someone still has the same problem on 7.5.4?
>>
>> 2011/3/11 Mario Jäger <m.jaeger at alkacon.com>
>>
>>> Hello,
>>>
>>> FYI: This issue is fixed in the CVS Head now:
>>> http://bugzilla.opencms.org/show_bug.cgi?id=1949
>>>
>>> Kind Regards,
>>> Mario.
>>>
>>> Am 11.02.2011 11:11, schrieb Michael Emmerich:
>>> > Hello Ignacio,
>>> >
>>> > I made a little test here to try to reproduce this (on OpenCms 7.5.3)
>>> >
>>> > 1) Copy a complete site and publish it
>>> >
>>> > ->  Number of entries in CMS_CONTENTS table increases as expected
>>> >
>>> > 2) Touch the copied site (including rewrite content)
>>> >
>>> > ->   Number of entries in CMS_CONTENTS table increases as expected
>>> >
>>> > 3) Delete the copied site and publish it
>>> >
>>> > ->   Number of entries in CMS_CONTENTS table increases, this seems
>>> > strange and I would not have expected this
>>> >
>>> > 4) Cleanup History tables, keep one version, delete al deleted
>>> >
>>> > ->  Number of entries in CMS_CONTENTS stays the same as in 3), this
>>> seems
>>> > to be not correct.
>>> >
>>> > So steps 3 and 4 bring up results that must be investigated.
>>> >
>>> > We will take a look at this for the OpenCms 8 release, it would be good
>>> > if you could add a enty in bugzilla.opencms.org.
>>> >
>>> > Kind Regards,
>>> > Michael
>>> >
>>> >
>>> >
>>> >
>>> > Am 10.02.2011 21:10, schrieb Ignacio Martelli:
>>> >> Hi,
>>> >>
>>> >> I found something strange while trying to reduce the size of a big
>>> >> (13GB+) OpenCMS 7.5.2 instance by deleting old content. I first tried
>>> >> to delete the content in the server, but the DB did not decrease it's
>>> >> size. In order to do the process correctly I copied the entire server
>>> >> into a dev VM, and tried to delete ALL the content. Here is what I
>>> >> did:
>>> >>
>>> >> - Delete all the contents of /sites/MySite
>>> >> - In "Administration ->   File History ->   History Settings": change
>>> >> settings to leave 1 stored version and not keep deleted resources.
>>> >> - In "Administration ->   File History ->   Clear History": Cleared
>>> all
>>> >> history including all versions of deleted files, left only 1 file
>>> >> versions of normal content.
>>> >> - In MySql: Optimized all tables to reclaim hard disk space.
>>> >>
>>> >> After doing all these steps, I checked the DB size, and found it still
>>> >> weights at over 10GB! Looking at table sizes, the table CMS_CONTENTS
>>> >> is taking 90% of that space.
>>> >>
>>> >> I checked the contents of that table and found content linked only to
>>> >> CMS_HISTORY_RESOURCES and CMS_PUBLISH_HISTORY but not linked to
>>> >> CMS_ONLINE_RESOURCES, CMS_HISTORY_RESOURCES, CMS_ONLINE_STRUCTURE or
>>> >> CMS_HISTORY_STRUCTURE.
>>> >>
>>> >> Checking the CMS_PUBLISH_HISTORY table I found that the path of said
>>> >> content was in a subfolder of /sites/MySite. I see no way to access
>>> >> that path from the workplace.
>>> >>
>>> >>
>>> >> If I understand correctly I have content that I cannot access from the
>>> >> workplace (because it has no resources or structure associated with
>>> >> it). Shouldn't that content have been deleted?????? Is this a bug, or
>>> >> is the content necessary?
>>> >>
>>> >>
>>> >> Regards,
>>> >> IM
>>> >>
>>> >> _______________________________________________
>>> >> This mail is sent to you from the opencms-dev mailing list
>>> >> To change your list options, or to unsubscribe from the list, please
>>> visit
>>> >> http://lists.opencms.org/mailman/listinfo/opencms-dev
>>> >
>>>
>>>
>>> --
>>> -------------------
>>> Mario Jäger
>>>
>>> Visit OpenCms Days 2011 Conference and Expo
>>> May 9 to May 10 2011 in Cologne, Germany
>>> http://www.opencms-days.org
>>>
>>> Alkacon Software GmbH  - The OpenCms Experts
>>> http://www.alkacon.com - http://www.opencms.org
>>>
>>> _______________________________________________
>>> This mail is sent to you from the opencms-dev mailing list
>>> To change your list options, or to unsubscribe from the list, please
>>> visit
>>> http://lists.opencms.org/mailman/listinfo/opencms-dev
>>>
>>
>>
>>
>> --
>> Best regards,
>> Gleb Makarov
>>
>>
>> _______________________________________________
>> This mail is sent to you from the opencms-dev mailing list
>> To change your list options, or to unsubscribe from the list, please visit
>> http://lists.opencms.org/mailman/listinfo/opencms-dev
>>
>
>
>
> --
> *
> www.solutioncms.com
>  The Brazilian
> Official Provider OpenCms
> *
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
>



-- 
Best regards,
Gleb Makarov
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20110728/14163f3e/attachment.htm>