Keeping DB clean

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Keeping DB clean

Yuet Chuen Ip
All,

Has anybody worked out definitively what should be in a script to ensure a clean state post processing of sessions expiry?
By this I mean that, MFC and the maintenance gem do not seem to be managing to get rid of all the component instances....
(no matter how long I leave the maintenance gem to run without further http connections and no matter how many MFCs I run, post waiting)

(1) If you think you have such a script - then have you checked for instances that should no longer reside in your database?
        - that is, for example:

                    System abortTransaction.
                    WASession allInstances

                    System abortTransaction.
                    WAValueHolder allInstances.

                    System abortTransaction.
                    xyzComponent allInstances

(2) Do you have a variation of such a script to just expire ALL sessions (right now) - then go on with the rest of the clean up process?


(3) For me, the excessive numbers of objects only disappear after the contents of the class variables on ObjectLogEntry are removed, MFC run  and reclaim finished.
      Is this normal? Or am I missing something (again)?


Regards,

Yuet



===== Backtrace end =============================================
13 April 2012 2:33:17 pm

Client VM: Win32 - a SmalltalkImage
Client Image: Pharo-1.0 [Latest update: #10517]
GemTools Client: >=1.0-beta.8.7 [ConfigurationOfGemTools]
GLASS: 1.0-beta.8.7.1

===== GLASS Version Report ============================================
1. ConfigurationOfGLASS    1.0-beta.8.7.1    #'release'
2. ConfigurationOfGofer    1.0.5.1    #'release'
3. ConfigurationOfGoferProjectLoader    1.0-alpha2.2    #'development'
4. ConfigurationOfGrease    1.0.6.4    #'release'
5. ConfigurationOfGsCore    0.245.2    #'development'
6. ConfigurationOfGsFastCGI    0.235    #'release'
7. ConfigurationOfGsMisc    0.240    #'release'
8. ConfigurationOfGsMonticello    0.242    #'release'
9. ConfigurationOfGsOB    0.242    #'release'
10. ConfigurationOfGsSqueakCommon    0.9.2    #'release'
11. ConfigurationOfJQueryWidgetBox    2.4    #'development'
12. ConfigurationOfMagritte2    2.0.6.1    #'development'
13. ConfigurationOfMetacello    1.0-beta.31.1    #'release'
14. ConfigurationOfPier2    2.0.7.1    #'development'
15. ConfigurationOfPierAddOns2    2.0.7.1    #'development'
16. ConfigurationOfSeaside30    3.0.6.3    #'release'
17. ConfigurationOfSwazoo2    2.2.0.4    #'development'
18. ConfigurationOfXMLSupport    1.0.5    #'stable'
19. ConfigurationOfZincHTTPComponents    1.1    #'release'

===== Client Version Report ============================================
cpuArchitecture: X86
cpuKind: Intel CPU
gsBuildArchitecture: Pentium/Windows_NT
gsBuildDate: Mon Jun 21 17:24:04 2010
gsBuildSerialNum: gss64_2_4_x_branch-23693
gsRelease: 2.4.4
gsVersion: 2.4.4
nodeName: per131pc7
osName: Windows NT
osRelease: 6.1
osVersion: build 7601 Service Pack 1
processId: 6492
processorCount: 4

===== Stone Version Report ===========================================
cpuArchitecture: x86-64
cpuKind: x86_64
gsBuildArchitecture: x86-64 (Linux)
gsBuildDate: Thu Dec  1 12:39:22 2011
gsBuildSerialNum: gss64_2_4_x_branch-27418
gsRelease: 2.4.5
gsVersion: 2.4.5
nodeName: yuet
osName: Linux
osRelease: 2.6.32.36-0.5-default
osVersion: #1 SMP 2011-04-14 10:12:31 +0200
processId: 13501
processorCount: 2

===== Preferences ============================================
annotationPanes=false
mercuryPanel=true
optionalButtons=true
syntaxHighlightingAsYouType=true




--
Yuet Ip,

Yuet Ip,
CCK Financial Solutions Ltd.,
Level 3, 12 St.Georges Terrace,
Perth,
WA 6000,
Australia.

Tel: +618 9223 7617
Fax: +618 9223 7699
email: [hidden email]

==============================================================================
CONFIDENTIALITY: The contents of this e-mail (and attachments) may be confidential, may be privileged and may contain copyright material of CCK Financial Solutions Ltd or third parties. You should only reproduce or distribute the material if you are expressly authorised by us to do so. If you are not the intended recipient, any use, disclosure or copying of this e-mail is unauthorised. If you have received this e-mail in error, please immediately notify the sender via e-mail.

VIRUSES: CCK Financial Solutions Ltd does not represent or warrant that files attached to this e-mail are free from computer viruses or other defects. Any attached files are provided, and may only be used, on the basis that the user assumes all responsibility for any loss or damage resulting directly or indirectly from such use. The liability of CCK Financial Solutions Ltd or related parties is limited in any event to either the resupply of the attached files or the cost of having the attached files resupplied.

Reply | Threaded
Open this post in threaded view
|

Keeping DB clean

Yuet Chuen Ip
Duh!

Only just noticed the default lines in the GemTools workspace  referencing the ObjectLogEntry....  (why does that always happens?).
Anyway - I guess only some of the previous email is still relevant.

Regards,

Yuet



-------- Original Message --------
Subject: [GS/SS Beta] Keeping DB clean
Date: Fri, 13 Apr 2012 15:11:30 +0800
From: Yuet Chuen Ip [hidden email]
Reply-To: GemStone Seaside beta discussion [hidden email]
To: [hidden email]


All,

Has anybody worked out definitively what should be in a script to ensure a clean state post processing of sessions expiry?
By this I mean that, MFC and the maintenance gem do not seem to be managing to get rid of all the component instances....
(no matter how long I leave the maintenance gem to run without further http connections and no matter how many MFCs I run, post waiting)

(1) If you think you have such a script - then have you checked for instances that should no longer reside in your database?
        - that is, for example:

                    System abortTransaction.
                    WASession allInstances

                    System abortTransaction.
                    WAValueHolder allInstances.

                    System abortTransaction.
                    xyzComponent allInstances

(2) Do you have a variation of such a script to just expire ALL sessions (right now) - then go on with the rest of the clean up process?


(3) For me, the excessive numbers of objects only disappear after the contents of the class variables on ObjectLogEntry are removed, MFC run  and reclaim finished.
      Is this normal? Or am I missing something (again)?


Regards,

Yuet



===== Backtrace end =============================================
13 April 2012 2:33:17 pm

Client VM: Win32 - a SmalltalkImage
Client Image: Pharo-1.0 [Latest update: #10517]
GemTools Client: >=1.0-beta.8.7 [ConfigurationOfGemTools]
GLASS: 1.0-beta.8.7.1

===== GLASS Version Report ============================================
1. ConfigurationOfGLASS    1.0-beta.8.7.1    #'release'
2. ConfigurationOfGofer    1.0.5.1    #'release'
3. ConfigurationOfGoferProjectLoader    1.0-alpha2.2    #'development'
4. ConfigurationOfGrease    1.0.6.4    #'release'
5. ConfigurationOfGsCore    0.245.2    #'development'
6. ConfigurationOfGsFastCGI    0.235    #'release'
7. ConfigurationOfGsMisc    0.240    #'release'
8. ConfigurationOfGsMonticello    0.242    #'release'
9. ConfigurationOfGsOB    0.242    #'release'
10. ConfigurationOfGsSqueakCommon    0.9.2    #'release'
11. ConfigurationOfJQueryWidgetBox    2.4    #'development'
12. ConfigurationOfMagritte2    2.0.6.1    #'development'
13. ConfigurationOfMetacello    1.0-beta.31.1    #'release'
14. ConfigurationOfPier2    2.0.7.1    #'development'
15. ConfigurationOfPierAddOns2    2.0.7.1    #'development'
16. ConfigurationOfSeaside30    3.0.6.3    #'release'
17. ConfigurationOfSwazoo2    2.2.0.4    #'development'
18. ConfigurationOfXMLSupport    1.0.5    #'stable'
19. ConfigurationOfZincHTTPComponents    1.1    #'release'

===== Client Version Report ============================================
cpuArchitecture: X86
cpuKind: Intel CPU
gsBuildArchitecture: Pentium/Windows_NT
gsBuildDate: Mon Jun 21 17:24:04 2010
gsBuildSerialNum: gss64_2_4_x_branch-23693
gsRelease: 2.4.4
gsVersion: 2.4.4
nodeName: per131pc7
osName: Windows NT
osRelease: 6.1
osVersion: build 7601 Service Pack 1
processId: 6492
processorCount: 4

===== Stone Version Report ===========================================
cpuArchitecture: x86-64
cpuKind: x86_64
gsBuildArchitecture: x86-64 (Linux)
gsBuildDate: Thu Dec  1 12:39:22 2011
gsBuildSerialNum: gss64_2_4_x_branch-27418
gsRelease: 2.4.5
gsVersion: 2.4.5
nodeName: yuet
osName: Linux
osRelease: 2.6.32.36-0.5-default
osVersion: #1 SMP 2011-04-14 10:12:31 +0200
processId: 13501
processorCount: 2

===== Preferences ============================================
annotationPanes=false
mercuryPanel=true
optionalButtons=true
syntaxHighlightingAsYouType=true




--
Yuet Ip,

Yuet Ip,
CCK Financial Solutions Ltd.,
Level 3, 12 St.Georges Terrace,
Perth,
WA 6000,
Australia.

Tel: +618 9223 7617
Fax: +618 9223 7699
email: [hidden email]

==============================================================================
CONFIDENTIALITY: The contents of this e-mail (and attachments) may be confidential, may be privileged and may contain copyright material of CCK Financial Solutions Ltd or third parties. You should only reproduce or distribute the material if you are expressly authorised by us to do so. If you are not the intended recipient, any use, disclosure or copying of this e-mail is unauthorised. If you have received this e-mail in error, please immediately notify the sender via e-mail.

VIRUSES: CCK Financial Solutions Ltd does not represent or warrant that files attached to this e-mail are free from computer viruses or other defects. Any attached files are provided, and may only be used, on the basis that the user assumes all responsibility for any loss or damage resulting directly or indirectly from such use. The liability of CCK Financial Solutions Ltd or related parties is limited in any event to either the resupply of the attached files or the cost of having the attached files resupplied.

Reply | Threaded
Open this post in threaded view
|

Re: Keeping DB clean

Dale Henrichs
Yuet,

If you are seeing expired sessions living a long time, then you might be running into Issue #136[1]. So you should try this setting in your system.config:

  GEM_TEMPOBJ_POMGEN_PRUNE_ON_VOTE=90;

After setting this in your config, you should recycle your server gems so the pick up the new setting ...

The problem had to do with the fact that a gem (especially an idle gem) may have references to dead session state in its head and as long as the gem is referencing that session state it will not be garbage collected.

GEM_TEMPOBJ_POMGEN_PRUNE_ON_VOTE tells the gem to unconditionally flush 90% of the persitent objects out of its head after an MFC and this appears to have resolved the problem for other folks who have noticed a problem similar to yours

Dale

[1] http://code.google.com/p/glassdb/issues/detail?id=136


----- Original Message -----
| From: "Yuet Chuen Ip" <[hidden email]>
| To: [hidden email]
| Sent: Friday, April 13, 2012 12:21:17 AM
| Subject: [GS/SS Beta]  Keeping DB clean
|
| Duh!
|
| Only just noticed the default lines in the GemTools workspace
| referencing the ObjectLogEntry.... (why does that always happens?).
| Anyway - I guess only some of the previous email is still relevant.
|
| Regards,
|
| Yuet
|
|
|
| -------- Original Message --------
| Subject: [GS/SS Beta] Keeping DB clean
| Date: Fri, 13 Apr 2012 15:11:30 +0800
| From: Yuet Chuen Ip <[hidden email]>
| Reply-To: GemStone Seaside beta discussion
| <[hidden email]>
| To: [hidden email]
|
| All,
|
| Has anybody worked out definitively what should be in a script to
| ensure a clean state post processing of sessions expiry?
| By this I mean that, MFC and the maintenance gem do not seem to be
| managing to get rid of all the component instances....
| (no matter how long I leave the maintenance gem to run without
| further http connections and no matter how many MFCs I run, post
| waiting)
|
| (1) If you think you have such a script - then have you checked for
| instances that should no longer reside in your database?
| - that is, for example:
|
| System abortTransaction.
| WASession allInstances
|
| System abortTransaction.
| WAValueHolder allInstances.
|
| System abortTransaction.
| xyz Component allInstances
|
| (2) Do you have a variation of such a script to just expire ALL
| sessions (right now) - then go on with the rest of the clean up
| process?
|
|
| (3) For me, the excessive numbers of objects only disappear after the
| contents of the class variables on ObjectLogEntry are removed, MFC
| run and reclaim finished.
| Is this normal? Or am I missing something (again)?
|
|
| Regards,
|
| Yuet
|
|
|
| ===== Backtrace end =============================================
| 13 April 2012 2:33:17 pm
|
| Client VM: Win32 - a SmalltalkImage
| Client Image: Pharo-1.0 [Latest update: #10517]
| GemTools Client: >=1.0-beta.8.7 [ConfigurationOfGemTools]
| GLASS: 1.0-beta.8.7.1
|
| ===== GLASS Version Report
| ============================================
| 1. ConfigurationOfGLASS 1.0-beta.8.7.1 #'release'
| 2. ConfigurationOfGofer 1.0.5.1 #'release'
| 3. ConfigurationOfGoferProjectLoader 1.0-alpha2.2 #'development'
| 4. ConfigurationOfGrease 1.0.6.4 #'release'
| 5. ConfigurationOfGsCore 0.245.2 #'development'
| 6. ConfigurationOfGsFastCGI 0.235 #'release'
| 7. ConfigurationOfGsMisc 0.240 #'release'
| 8. ConfigurationOfGsMonticello 0.242 #'release'
| 9. ConfigurationOfGsOB 0.242 #'release'
| 10. ConfigurationOfGsSqueakCommon 0.9.2 #'release'
| 11. ConfigurationOfJQueryWidgetBox 2.4 #'development'
| 12. ConfigurationOfMagritte2 2.0.6.1 #'development'
| 13. ConfigurationOfMetacello 1.0-beta.31.1 #'release'
| 14. ConfigurationOfPier2 2.0.7.1 #'development'
| 15. ConfigurationOfPierAddOns2 2.0.7.1 #'development'
| 16. ConfigurationOfSeaside30 3.0.6.3 #'release'
| 17. ConfigurationOfSwazoo2 2.2.0.4 #'development'
| 18. ConfigurationOfXMLSupport 1.0.5 #'stable'
| 19. ConfigurationOfZincHTTPComponents 1.1 #'release'
|
| ===== Client Version Report
| ============================================
| cpuArchitecture: X86
| cpuKind: Intel CPU
| gsBuildArchitecture: Pentium/Windows_NT
| gsBuildDate: Mon Jun 21 17:24:04 2010
| gsBuildSerialNum: gss64_2_4_x_branch-23693
| gsRelease: 2.4.4
| gsVersion: 2.4.4
| nodeName: per131pc7
| osName: Windows NT
| osRelease: 6.1
| osVersion: build 7601 Service Pack 1
| processId: 6492
| processorCount: 4
|
| ===== Stone Version Report
| ===========================================
| cpuArchitecture: x86-64
| cpuKind: x86_64
| gsBuildArchitecture: x86-64 (Linux)
| gsBuildDate: Thu Dec 1 12:39:22 2011
| gsBuildSerialNum: gss64_2_4_x_branch-27418
| gsRelease: 2.4.5
| gsVersion: 2.4.5
| nodeName: yuet
| osName: Linux
| osRelease: 2.6.32.36-0.5-default
| osVersion: #1 SMP 2011-04-14 10:12:31 +0200
| processId: 13501
| processorCount: 2
|
| ===== Preferences ============================================
| annotationPanes=false
| mercuryPanel=true
| optionalButtons=true
| syntaxHighlightingAsYouType=true
|
|
|
|
|
| --
| Yuet Ip,
|
|
| Yuet Ip,
| CCK Financial Solutions Ltd.,
| Level 3, 12 St.Georges Terrace,
| Perth,
| WA 6000,
| Australia.
|
| Tel: +618 9223 7617
| Fax: +618 9223 7699
| email: [hidden email]
|
| ==============================================================================
| CONFIDENTIALITY: The contents of this e-mail (and attachments) may be
| confidential, may be privileged and may contain copyright material
| of CCK Financial Solutions Ltd or third parties. You should only
| reproduce or distribute the material if you are expressly authorised
| by us to do so. If you are not the intended recipient, any use,
| disclosure or copying of this e-mail is unauthorised. If you have
| received this e-mail in error, please immediately notify the sender
| via e-mail.
|
| VIRUSES: CCK Financial Solutions Ltd does not represent or warrant
| that files attached to this e-mail are free from computer viruses or
| other defects. Any attached files are provided, and may only be
| used, on the basis that the user assumes all responsibility for any
| loss or damage resulting directly or indirectly from such use. The
| liability of CCK Financial Solutions Ltd or related parties is
| limited in any event to either the resupply of the attached files or
| the cost of having the attached files resupplied.
Reply | Threaded
Open this post in threaded view
|

Re: Keeping DB clean

Dale Henrichs
I've added this config parameter to the default system.conf up on the github glassdb site[1]

[1] https://github.com/glassdb/glass/blob/master/data/system.conf#L14-16

----- Original Message -----
| From: "Dale Henrichs" <[hidden email]>
| To: "GemStone Seaside beta discussion" <[hidden email]>
| Sent: Friday, April 13, 2012 9:08:39 AM
| Subject: Re: [GS/SS Beta]  Keeping DB clean
|
| Yuet,
|
| If you are seeing expired sessions living a long time, then you might
| be running into Issue #136[1]. So you should try this setting in
| your system.config:
|
|   GEM_TEMPOBJ_POMGEN_PRUNE_ON_VOTE=90;
|
| After setting this in your config, you should recycle your server
| gems so the pick up the new setting ...
|
| The problem had to do with the fact that a gem (especially an idle
| gem) may have references to dead session state in its head and as
| long as the gem is referencing that session state it will not be
| garbage collected.
|
| GEM_TEMPOBJ_POMGEN_PRUNE_ON_VOTE tells the gem to unconditionally
| flush 90% of the persitent objects out of its head after an MFC and
| this appears to have resolved the problem for other folks who have
| noticed a problem similar to yours
|
| Dale
|
| [1] http://code.google.com/p/glassdb/issues/detail?id=136
|
|
| ----- Original Message -----
| | From: "Yuet Chuen Ip" <[hidden email]>
| | To: [hidden email]
| | Sent: Friday, April 13, 2012 12:21:17 AM
| | Subject: [GS/SS Beta]  Keeping DB clean
| |
| | Duh!
| |
| | Only just noticed the default lines in the GemTools workspace
| | referencing the ObjectLogEntry.... (why does that always happens?).
| | Anyway - I guess only some of the previous email is still relevant.
| |
| | Regards,
| |
| | Yuet
| |
| |
| |
| | -------- Original Message --------
| | Subject: [GS/SS Beta] Keeping DB clean
| | Date: Fri, 13 Apr 2012 15:11:30 +0800
| | From: Yuet Chuen Ip <[hidden email]>
| | Reply-To: GemStone Seaside beta discussion
| | <[hidden email]>
| | To: [hidden email]
| |
| | All,
| |
| | Has anybody worked out definitively what should be in a script to
| | ensure a clean state post processing of sessions expiry?
| | By this I mean that, MFC and the maintenance gem do not seem to be
| | managing to get rid of all the component instances....
| | (no matter how long I leave the maintenance gem to run without
| | further http connections and no matter how many MFCs I run, post
| | waiting)
| |
| | (1) If you think you have such a script - then have you checked for
| | instances that should no longer reside in your database?
| | - that is, for example:
| |
| | System abortTransaction.
| | WASession allInstances
| |
| | System abortTransaction.
| | WAValueHolder allInstances.
| |
| | System abortTransaction.
| | xyz Component allInstances
| |
| | (2) Do you have a variation of such a script to just expire ALL
| | sessions (right now) - then go on with the rest of the clean up
| | process?
| |
| |
| | (3) For me, the excessive numbers of objects only disappear after
| | the
| | contents of the class variables on ObjectLogEntry are removed, MFC
| | run and reclaim finished.
| | Is this normal? Or am I missing something (again)?
| |
| |
| | Regards,
| |
| | Yuet
| |
| |
| |
| | ===== Backtrace end =============================================
| | 13 April 2012 2:33:17 pm
| |
| | Client VM: Win32 - a SmalltalkImage
| | Client Image: Pharo-1.0 [Latest update: #10517]
| | GemTools Client: >=1.0-beta.8.7 [ConfigurationOfGemTools]
| | GLASS: 1.0-beta.8.7.1
| |
| | ===== GLASS Version Report
| | ============================================
| | 1. ConfigurationOfGLASS 1.0-beta.8.7.1 #'release'
| | 2. ConfigurationOfGofer 1.0.5.1 #'release'
| | 3. ConfigurationOfGoferProjectLoader 1.0-alpha2.2 #'development'
| | 4. ConfigurationOfGrease 1.0.6.4 #'release'
| | 5. ConfigurationOfGsCore 0.245.2 #'development'
| | 6. ConfigurationOfGsFastCGI 0.235 #'release'
| | 7. ConfigurationOfGsMisc 0.240 #'release'
| | 8. ConfigurationOfGsMonticello 0.242 #'release'
| | 9. ConfigurationOfGsOB 0.242 #'release'
| | 10. ConfigurationOfGsSqueakCommon 0.9.2 #'release'
| | 11. ConfigurationOfJQueryWidgetBox 2.4 #'development'
| | 12. ConfigurationOfMagritte2 2.0.6.1 #'development'
| | 13. ConfigurationOfMetacello 1.0-beta.31.1 #'release'
| | 14. ConfigurationOfPier2 2.0.7.1 #'development'
| | 15. ConfigurationOfPierAddOns2 2.0.7.1 #'development'
| | 16. ConfigurationOfSeaside30 3.0.6.3 #'release'
| | 17. ConfigurationOfSwazoo2 2.2.0.4 #'development'
| | 18. ConfigurationOfXMLSupport 1.0.5 #'stable'
| | 19. ConfigurationOfZincHTTPComponents 1.1 #'release'
| |
| | ===== Client Version Report
| | ============================================
| | cpuArchitecture: X86
| | cpuKind: Intel CPU
| | gsBuildArchitecture: Pentium/Windows_NT
| | gsBuildDate: Mon Jun 21 17:24:04 2010
| | gsBuildSerialNum: gss64_2_4_x_branch-23693
| | gsRelease: 2.4.4
| | gsVersion: 2.4.4
| | nodeName: per131pc7
| | osName: Windows NT
| | osRelease: 6.1
| | osVersion: build 7601 Service Pack 1
| | processId: 6492
| | processorCount: 4
| |
| | ===== Stone Version Report
| | ===========================================
| | cpuArchitecture: x86-64
| | cpuKind: x86_64
| | gsBuildArchitecture: x86-64 (Linux)
| | gsBuildDate: Thu Dec 1 12:39:22 2011
| | gsBuildSerialNum: gss64_2_4_x_branch-27418
| | gsRelease: 2.4.5
| | gsVersion: 2.4.5
| | nodeName: yuet
| | osName: Linux
| | osRelease: 2.6.32.36-0.5-default
| | osVersion: #1 SMP 2011-04-14 10:12:31 +0200
| | processId: 13501
| | processorCount: 2
| |
| | ===== Preferences ============================================
| | annotationPanes=false
| | mercuryPanel=true
| | optionalButtons=true
| | syntaxHighlightingAsYouType=true
| |
| |
| |
| |
| |
| | --
| | Yuet Ip,
| |
| |
| | Yuet Ip,
| | CCK Financial Solutions Ltd.,
| | Level 3, 12 St.Georges Terrace,
| | Perth,
| | WA 6000,
| | Australia.
| |
| | Tel: +618 9223 7617
| | Fax: +618 9223 7699
| | email: [hidden email]
| |
| | ==============================================================================
| | CONFIDENTIALITY: The contents of this e-mail (and attachments) may
| | be
| | confidential, may be privileged and may contain copyright material
| | of CCK Financial Solutions Ltd or third parties. You should only
| | reproduce or distribute the material if you are expressly
| | authorised
| | by us to do so. If you are not the intended recipient, any use,
| | disclosure or copying of this e-mail is unauthorised. If you have
| | received this e-mail in error, please immediately notify the sender
| | via e-mail.
| |
| | VIRUSES: CCK Financial Solutions Ltd does not represent or warrant
| | that files attached to this e-mail are free from computer viruses
| | or
| | other defects. Any attached files are provided, and may only be
| | used, on the basis that the user assumes all responsibility for any
| | loss or damage resulting directly or indirectly from such use. The
| | liability of CCK Financial Solutions Ltd or related parties is
| | limited in any event to either the resupply of the attached files
| | or
| | the cost of having the attached files resupplied.
|
Reply | Threaded
Open this post in threaded view
|

Re: Keeping DB clean

Yuet Chuen Ip
Thanks Dale, will give that a try and see what happens.  Will keep you posted on the outcome.

Regards,

Yuet

On 14/04/2012 12:12 AM, Dale Henrichs wrote:
I've added this config parameter to the default system.conf up on the github glassdb site[1]

[1] https://github.com/glassdb/glass/blob/master/data/system.conf#L14-16

----- Original Message -----
| From: "Dale Henrichs" [hidden email]
| To: "GemStone Seaside beta discussion" [hidden email]
| Sent: Friday, April 13, 2012 9:08:39 AM
| Subject: Re: [GS/SS Beta]  Keeping DB clean
| 
| Yuet,
| 
| If you are seeing expired sessions living a long time, then you might
| be running into Issue #136[1]. So you should try this setting in
| your system.config:
| 
|   GEM_TEMPOBJ_POMGEN_PRUNE_ON_VOTE=90;
| 
| After setting this in your config, you should recycle your server
| gems so the pick up the new setting ...
| 
| The problem had to do with the fact that a gem (especially an idle
| gem) may have references to dead session state in its head and as
| long as the gem is referencing that session state it will not be
| garbage collected.
| 
| GEM_TEMPOBJ_POMGEN_PRUNE_ON_VOTE tells the gem to unconditionally
| flush 90% of the persitent objects out of its head after an MFC and
| this appears to have resolved the problem for other folks who have
| noticed a problem similar to yours
| 
| Dale
| 
| [1] http://code.google.com/p/glassdb/issues/detail?id=136
| 
| 
| ----- Original Message -----
| | From: "Yuet Chuen Ip" [hidden email]
| | To: [hidden email]
| | Sent: Friday, April 13, 2012 12:21:17 AM
| | Subject: [GS/SS Beta]  Keeping DB clean
| | 
| | Duh!
| | 
| | Only just noticed the default lines in the GemTools workspace
| | referencing the ObjectLogEntry.... (why does that always happens?).
| | Anyway - I guess only some of the previous email is still relevant.
| | 
| | Regards,
| | 
| | Yuet
| | 
| | 
| | 
| | -------- Original Message --------
| | Subject: 	[GS/SS Beta] Keeping DB clean
| | Date: 	Fri, 13 Apr 2012 15:11:30 +0800
| | From: 	Yuet Chuen Ip [hidden email]
| | Reply-To: 	GemStone Seaside beta discussion
| | [hidden email]
| | To: 	[hidden email]
| | 
| | All,
| | 
| | Has anybody worked out definitively what should be in a script to
| | ensure a clean state post processing of sessions expiry?
| | By this I mean that, MFC and the maintenance gem do not seem to be
| | managing to get rid of all the component instances....
| | (no matter how long I leave the maintenance gem to run without
| | further http connections and no matter how many MFCs I run, post
| | waiting)
| | 
| | (1) If you think you have such a script - then have you checked for
| | instances that should no longer reside in your database?
| | - that is, for example:
| | 
| | System abortTransaction.
| | WASession allInstances
| | 
| | System abortTransaction.
| | WAValueHolder allInstances.
| | 
| | System abortTransaction.
| | xyz Component allInstances
| | 
| | (2) Do you have a variation of such a script to just expire ALL
| | sessions (right now) - then go on with the rest of the clean up
| | process?
| | 
| | 
| | (3) For me, the excessive numbers of objects only disappear after
| | the
| | contents of the class variables on ObjectLogEntry are removed, MFC
| | run and reclaim finished.
| | Is this normal? Or am I missing something (again)?
| | 
| | 
| | Regards,
| | 
| | Yuet
| | 
| | 
| | 
| | ===== Backtrace end =============================================
| | 13 April 2012 2:33:17 pm
| | 
| | Client VM: Win32 - a SmalltalkImage
| | Client Image: Pharo-1.0 [Latest update: #10517]
| | GemTools Client: >=1.0-beta.8.7 [ConfigurationOfGemTools]
| | GLASS: 1.0-beta.8.7.1
| | 
| | ===== GLASS Version Report
| | ============================================
| | 1. ConfigurationOfGLASS 1.0-beta.8.7.1 #'release'
| | 2. ConfigurationOfGofer 1.0.5.1 #'release'
| | 3. ConfigurationOfGoferProjectLoader 1.0-alpha2.2 #'development'
| | 4. ConfigurationOfGrease 1.0.6.4 #'release'
| | 5. ConfigurationOfGsCore 0.245.2 #'development'
| | 6. ConfigurationOfGsFastCGI 0.235 #'release'
| | 7. ConfigurationOfGsMisc 0.240 #'release'
| | 8. ConfigurationOfGsMonticello 0.242 #'release'
| | 9. ConfigurationOfGsOB 0.242 #'release'
| | 10. ConfigurationOfGsSqueakCommon 0.9.2 #'release'
| | 11. ConfigurationOfJQueryWidgetBox 2.4 #'development'
| | 12. ConfigurationOfMagritte2 2.0.6.1 #'development'
| | 13. ConfigurationOfMetacello 1.0-beta.31.1 #'release'
| | 14. ConfigurationOfPier2 2.0.7.1 #'development'
| | 15. ConfigurationOfPierAddOns2 2.0.7.1 #'development'
| | 16. ConfigurationOfSeaside30 3.0.6.3 #'release'
| | 17. ConfigurationOfSwazoo2 2.2.0.4 #'development'
| | 18. ConfigurationOfXMLSupport 1.0.5 #'stable'
| | 19. ConfigurationOfZincHTTPComponents 1.1 #'release'
| | 
| | ===== Client Version Report
| | ============================================
| | cpuArchitecture: X86
| | cpuKind: Intel CPU
| | gsBuildArchitecture: Pentium/Windows_NT
| | gsBuildDate: Mon Jun 21 17:24:04 2010
| | gsBuildSerialNum: gss64_2_4_x_branch-23693
| | gsRelease: 2.4.4
| | gsVersion: 2.4.4
| | nodeName: per131pc7
| | osName: Windows NT
| | osRelease: 6.1
| | osVersion: build 7601 Service Pack 1
| | processId: 6492
| | processorCount: 4
| | 
| | ===== Stone Version Report
| | ===========================================
| | cpuArchitecture: x86-64
| | cpuKind: x86_64
| | gsBuildArchitecture: x86-64 (Linux)
| | gsBuildDate: Thu Dec 1 12:39:22 2011
| | gsBuildSerialNum: gss64_2_4_x_branch-27418
| | gsRelease: 2.4.5
| | gsVersion: 2.4.5
| | nodeName: yuet
| | osName: Linux
| | osRelease: 2.6.32.36-0.5-default
| | osVersion: #1 SMP 2011-04-14 10:12:31 +0200
| | processId: 13501
| | processorCount: 2
| | 
| | ===== Preferences ============================================
| | annotationPanes=false
| | mercuryPanel=true
| | optionalButtons=true
| | syntaxHighlightingAsYouType=true
| | 
| | 
| | 
| | 
| | 
| | --
| | Yuet Ip,
| | 
| | 
| | Yuet Ip,
| | CCK Financial Solutions Ltd.,
| | Level 3, 12 St.Georges Terrace,
| | Perth,
| | WA 6000,
| | Australia.
| | 
| | Tel: +618 9223 7617
| | Fax: +618 9223 7699
| | email: [hidden email]
| | 
| | ==============================================================================
| | CONFIDENTIALITY: The contents of this e-mail (and attachments) may
| | be
| | confidential, may be privileged and may contain copyright material
| | of CCK Financial Solutions Ltd or third parties. You should only
| | reproduce or distribute the material if you are expressly
| | authorised
| | by us to do so. If you are not the intended recipient, any use,
| | disclosure or copying of this e-mail is unauthorised. If you have
| | received this e-mail in error, please immediately notify the sender
| | via e-mail.
| | 
| | VIRUSES: CCK Financial Solutions Ltd does not represent or warrant
| | that files attached to this e-mail are free from computer viruses
| | or
| | other defects. Any attached files are provided, and may only be
| | used, on the basis that the user assumes all responsibility for any
| | loss or damage resulting directly or indirectly from such use. The
| | liability of CCK Financial Solutions Ltd or related parties is
| | limited in any event to either the resupply of the attached files
| | or
| | the cost of having the attached files resupplied.
| 




--
Yuet Ip,

Yuet Ip,
CCK Financial Solutions Ltd.,
Level 3, 12 St.Georges Terrace,
Perth,
WA 6000,
Australia.

Tel: +618 9223 7617
Fax: +618 9223 7699
email: [hidden email]

==============================================================================
CONFIDENTIALITY: The contents of this e-mail (and attachments) may be confidential, may be privileged and may contain copyright material of CCK Financial Solutions Ltd or third parties. You should only reproduce or distribute the material if you are expressly authorised by us to do so. If you are not the intended recipient, any use, disclosure or copying of this e-mail is unauthorised. If you have received this e-mail in error, please immediately notify the sender via e-mail.

VIRUSES: CCK Financial Solutions Ltd does not represent or warrant that files attached to this e-mail are free from computer viruses or other defects. Any attached files are provided, and may only be used, on the basis that the user assumes all responsibility for any loss or damage resulting directly or indirectly from such use. The liability of CCK Financial Solutions Ltd or related parties is limited in any event to either the resupply of the attached files or the cost of having the attached files resupplied.