Users Table Slow in the Backend

Software Support
1

We are using 3.3.0.7 and the users table is too slow to operate. We only have 200 users with one journal. I have checked the forum and saw a suggestiong that Index might be created for user_settings table. We have this index already in the table. Before upgrading from 3.1.2-1, it was fine. This is the only area in the backend that we are having a problem.

Could anyone point me in the right direction?

Thanks.

2

Hi @fsekerli,

Do you see any relevant entries in the php error log that might to what the issue is? And, if so, could you post them here?

-Roger
PKP Team

4

Hi @rcgillis ,

Thanks for replying. This is what I find in the error_log.

2021-07-20 07:25:11.603008 [ERROR] [463086] [58.19.0.47:15904#…journal.com] [modcompress—] compressbuf in 1236, return -1 (written 0, flag in 0)
2021-07-20 07:29:46.206550 [ERROR] [463086] [58.19.0.47:16382#…journal.com] [modcompress—] compressbuf in 1236, return -1 (written 0, flag in 0)
2021-07-21 10:30:35.396873 [ERROR] [463086] [58.19.0.80:39087#…journal.com] [modcompress—] compressbuf in 1236, return -1 (written 0, flag in 0)
2021-07-21 12:33:36.332797 [ERROR] [463086] [58.19.0.80:28974#…journal.com] [modcompress—] compressbuf in 1236, return -1 (written 0, flag in 0)
2021-07-23 04:51:57.113683 [ERROR] [728078] [58.19.0.174:25876#…journal.com] [modcompress—] compressbuf in 1236, return -1 (written 0, flag in 0)
2021-07-23 05:54:04.306520 [ERROR] [728078] [58.19.0.174:26597#…journal.com] [modcompress—] compressbuf in 1236, return -1 (written 0, flag in 0)
2021-07-23 05:55:58.041766 [ERROR] [728079] [58.19.0.174:26502#…journal.com] [modcompress—] compressbuf in 1236, return -1 (written 0, flag in 0)
2021-07-26 12:40:39.305524 [ERROR] [916212] [58.19.0.174:26414#…journal.com] [modcompress—] compressbuf in 1236, return -1 (written 0, flag in 0)
2021-07-26 15:16:04.357659 [ERROR] [917469] [58.19.0.174:30380#…journal.com] [modcompress—] compressbuf in 1236, return -1 (written 0, flag in 0)
2021-07-28 19:21:40.811911 [ERROR] [26852] [58.19.1.219:22723#…journal.com] [modcompress—] compressbuf in 1236, return -1 (written 0, flag in 0)
2021-07-28 22:47:54.684933 [ERROR] [26852] [58.19.1.219:22883#…journal.com] [modcompress—] compressbuf in 1236, return -1 (written 0, flag in 0)
2021-07-29 03:43:49.138114 [ERROR] [26852] [58.19.1.219:22564#…journal.com] [modcompress—] compressbuf in 1236, return -1 (written 0, flag in 0)
2021-07-29 03:46:39.779887 [ERROR] [26852] [58.19.1.219:38992#…journal.com] [modcompress—] compressbuf in 1236, return -1 (written 0, flag in 0)
2021-07-29 11:25:53.691201 [ERROR] [26852] [58.19.0.44:37293#…journal.com] [modcompress—] compressbuf in 1236, return -1 (written 0, flag in 0)
2021-07-29 11:28:03.590296 [ERROR] [26852] [58.19.0.44:34505#…journal.com] [modcompress—] compressbuf in 1236, return -1 (written 0, flag in 0)
2021-08-16 20:59:58.080560 [ERROR] [650418] [58.19.0.243:19390#…journal.com] [modcompress—] compressbuf in 1236, return -1 (written 0, flag in 0)

5

Hi @fsekerli,

Great. Thank you for providing this additional information. I’ll see if our other team members can look at this and try to assist when they are available.

-Roger
PKP Team