Discuz! Info: MySQLQueryError_MySQL

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.