Discuz! Info: MySQLQueryError Forum mysql1020 problem solving
This problem often occurs in forums.
Discuz! Info: MySQL Query Error
User: admin
Time:
Script:/club/index. php
SQL: SELECT uid, username, groupid, invisible, action, lastactivity, fid FROM [Table] sessions WHERE uid <> 0 ORDER BY uid DESC LIMIT 500
Error: Record has changed since last read in table '[Table] session'
Errno.: 1020
Similar error report has beed dispatched to administrator before.
This method can be used for a simple solution. upgrade the database in the background.
Delete from cdb_sessions;
For more information, see
Errno.: 1020 service provider Reply
Hello:
You are welcome to use the Q & A System. your answer is as follows:
This problem occurs because Discuz uses the Heap table method to store sessions, while the mysql4 heap table has the read/write lock synchronization bug. we have made a hotfix, check whether the problem will occur again in the near future. if you have any questions, contact us as soon as possible.
Thank you for your support. if you have any questions, please contact us.