Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

cf_client_data duplicating and not deleting

Description

We are seeing two issues with our new Lucee 5.3.8.189 implementation.

1) Duplicate entries in the cf_client_data. One entry with the appropriate Application Name (as defined in Application.cfm), and a 2nd entry (that looks identical) but has Name = Null.

2) We've set our session variables (including Client) to expire in 1 hour. After 4 days, we have 130,000 records in this table. An inspection of the "expires" variable shows that data is not being deleted.

Background: https://dev.lucee.org/t/client-variables-database-millions-of-entries/8520/5

Environment

Lucee 5.3.8.189
Apache Tomcat/9.0.35
11.0.7 (AdoptOpenJDK) 64bit
Linux (4.18.0-305.7.1.el8_4.x86_64) 64bit / CentOS Linux 8.4.2105

Attachments

2
  • 22 Jan 2022, 01:58 pm
  • 11 Jul 2021, 09:59 pm

Activity

Show:

Adam Stetzer 23 January 2022 at 14:58

Thanks for your help Zac.

After studying it some more this morning, I noticed two context defined in Lucee Admin. One from our application, and one from /opt/lucee/tomcat/webapps/ROOT (maybe a default?)…

I’m wondering if the null values are coming from there - which would be a configuration issue on our end.

Zac Spitzer 22 January 2022 at 19:34

I can only reproduce this by using an Application.cfc without a name, as Terry commented on the mailing list

https://dev.lucee.org/t/client-variables-database-millions-of-entries/8520/37?u=zackster

Adam Stetzer 22 January 2022 at 13:58
Edited

Lucee 5.3.8.206

Apache Tomcat/9.0.35

Linux (4.18.0-348.7.1.el8_5.x86_64) 64bit

 

Following up on this. The fix definitely stopped the table from growing endlessly. Records are now being purged again hourly (as they should be).

However, I still see double-entries in the cf_client_data table. One with the appropriate Application Name - and a 2nd entry with a NULL value for the Application Name. This is causing performance issues for our very high volume application.

 

Zac Spitzer 7 August 2021 at 16:41

Yep

Adam Stetzer 7 August 2021 at 12:14

Hey guys - If I update to 5.3.8.201, is this fix included?

Fixed

Details

Assignee

Reporter

Priority

Labels

Fix versions

New Issue warning screen

Before you create a new Issue, please post to the mailing list first https://dev.lucee.org

Once the issue has been verified, one of the Lucee team will ask you to file an issue

Affects versions

Created 11 July 2021 at 21:59
Updated 23 January 2022 at 14:58
Resolved 13 July 2021 at 19:53

Flag notifications