Project

General

Profile

Actions

Bug #17542

open

Ninja Forms plugin can write many "_wp_session" entries into the options table

Added by Raymond Hoh about 1 year ago.

Status:
New
Priority name:
Normal
Assignee:
Category name:
Performance
Target version:
-
Start date:
2023-01-23
Due date:
% Done:

0%

Estimated time:
Deployment actions:

Description

While looking a bit into #17522, I looked at the options database table for the ILETC site and found 51,000 entries for options beginning with "_wp_session":

mysql> select count(*) from wp_1185_options where option_name like '_wp_session%';
+----------+
| count(*) |
+----------+
|    51084 |
+----------+
1 row in set (0.02 sec)

I searched through our plugins to see what might be causing this and the options comes from the Ninja Forms plugin. Specifically, the use of the WP_Session library: https://github.com/cuny-academic-commons/cac/blob/master/wp-content/plugins/ninja-forms/includes/Session.php. Sometime in the past, Ninja Forms was activated on the ILETC site, but it isn't currently active.

Next, I decided to look through current sites with Ninja Forms active. Out of the current sites with Ninja Forms active, I came across the GC Digital Fellows website, which had ~150,000 "_wp_session" options:

mysql> select count(*) from wp_1120_options where option_name like '_wp_session%';
+----------+
| count(*) |
+----------+
|   154139 |
+----------+
1 row in set (0.35 sec)

The other sites with Ninja Forms active did not have this issue. I just deleted the "_wp_session" options for both ILETC and GC Digital Fellows and cleared the options object cache for both sites.

Perhaps this is an older bug in Ninja Forms that might have been fixed in a more, recent version, but thought it would be worth documenting in a ticket.


Related issues

Related to CUNY Academic Commons - Feature #17522: Strategies for reducing database sizeDuplicate2023-01-20

Actions
Actions #1

Updated by Raymond Hoh about 1 year ago

  • Related to Feature #17522: Strategies for reducing database size added
Actions

Also available in: Atom PDF