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

[Deiverson Silveira]

Hi Gleb,

I did not pay attention to the Mario´s mail about fixed, sorry!

Regards,

Deiverson Silveira

2011/7/28 gleb makarov <gleb.a.makarov at gmail.com>

> 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
>
>
> _______________________________________________
> 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
*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20110728/c321c0be/attachment.htm>