Skip to content

oc_text_steps seems to not be cleanupped #9080

Description

@sistason

Describe the bug
In the database, oc_text_steps grows to ~3GB because it seems the cleanup does not run.
3GB is more than half my entire database size, so I expect it to become a bigger problem in the future.

I'd like to ask for hints to debug this.

Screenshots

It looks like the cleanup job runs and does "something". is there a way to get the logs of the job?

$ php occ background-job:list
| 87173              | OCA\Text\Cron\Cleanup              | 2026-08-19T15:15:02+00:00 | null   |
$ php occ background-job:execute 87173
[ ... ]
Last checked:         2026-08-19T15:20:02+00:00
Reserved at:          -
Last executed:        2026-08-19T15:15:02+00:00
Last duration:        23
Next execution:       2026-08-19T15:20:02+00:00

Job executed!

[...]

Last checked:         2026-08-19T15:20:02+00:00
Reserved at:          -
Last executed:        2026-08-19T15:22:57+00:00
Last duration:        21
Next execution:       2026-08-19T15:27:57+00:00

oc_text_steps does not seem to be cleanupped, even though the session_id/timestamps seem really old

select session_id,timestamp,length(data) from oc_text_steps where document_id=3212894;

+------------+------------+--------------+
| session_id | timestamp  | length(data) |
+------------+------------+--------------+
|     506062 | 1779201143 |           44 |
|     506064 | 1779201173 |           44 |
|     506064 | 1779201175 |        42730 |
|     506066 | 1779201223 |           57 |
|     506066 | 1779201225 |          117 |
[...]
|     527119 | 1787129951 |        12326 |
|     527119 | 1787129951 |        12327 |
+------------+------------+--------------+
49924 rows in set (2.088 sec)

+------------+------------+--------------+

the oc_text_sessions seem to be in order, though

select id,document_id,last_contact from oc_text_sessions limit 5;
+--------+-------------+--------------+
| id     | document_id | last_contact |
+--------+-------------+--------------+
| 514716 |      102771 |   1782251403 |
| 523501 |      102771 |   1785526060 |
| 524925 |      102771 |   1786194409 |
[...]
| 527117 |     3339234 |   1787145085 |
| 527174 |     3340247 |   1787152127 |
| 527168 |     3340247 |   1787152187 |
+--------+-------------+--------------+
2478 rows in set (0.006 sec)

The table is very big in general, the oc_text_steps.ibd is 2.7GB in size

select count(*) from oc_text_steps;
+----------+
| count(*) |
+----------+
|   585499 |
+----------+

SELECT table_name, round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB`  FROM information_schema.TABLES WHERE table_schema = 'nextcloud' AND table_name = 'oc_text_steps';
+---------------+------------+
| Table         | Size in MB |
+---------------+------------+
| oc_text_steps |    1242.22 |
+---------------+------------+

Server details:

  • Nextcloud version: 33.0.5
  • PHP Version: 8.4.22 (docker nextcloud:fpm)
  • Database: MariaDB 11.8.8

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions