ClickHouse DB::Exception: Code: 60, e.displayText() = DB::Exception: Table is read-only

The table is set to read-only mode.

Understanding ClickHouse

ClickHouse is a columnar database management system (DBMS) designed for online analytical processing (OLAP) of queries. It is known for its high performance and efficiency in handling large volumes of data. ClickHouse is widely used for real-time analytics and is capable of processing billions of rows and petabytes of data per second.

Identifying the Symptom

While working with ClickHouse, you might encounter the following error message: DB::Exception: Code: 60, e.displayText() = DB::Exception: Table is read-only. This error indicates that an attempt to modify a table has failed because the table is in read-only mode.

Explaining the Issue

Understanding Error Code 60

Error Code 60 in ClickHouse is associated with operations that are not permitted due to the table being in a read-only state. This can occur when the table's settings have been configured to prevent any write operations, which is useful in scenarios where data integrity must be preserved or when the table is used for reporting purposes only.

Why Tables Become Read-Only

Tables may be set to read-only mode intentionally by database administrators to prevent accidental data modifications. This setting is often applied to critical datasets or during maintenance windows. Additionally, certain configurations or system settings might inadvertently set tables to read-only mode.

Steps to Resolve the Issue

Check Table Settings

First, verify the current settings of the table to confirm its read-only status. You can do this by executing the following query:

SHOW CREATE TABLE your_table_name;

Review the output to identify any settings that enforce read-only mode.

Modify Table Settings

If you have confirmed that the table is indeed set to read-only, you can change its settings to allow write operations. Use the following query to alter the table settings:

ALTER TABLE your_table_name MODIFY SETTING readonly = 0;

This command changes the table's setting to allow write operations. Ensure you have the necessary permissions to execute this command.

Verify Changes

After modifying the table settings, verify that the changes have been applied successfully. Attempt a write operation to ensure that the table is no longer in read-only mode.

Additional Resources

For more information on managing ClickHouse tables and settings, refer to the official ClickHouse Documentation. Additionally, explore the Settings section for detailed explanations of various configuration options.

Master

ClickHouse

in Minutes — Grab the Ultimate Cheatsheet

(Perfect for DevOps & SREs)

Most-used commands
Real-world configs/examples
Handy troubleshooting shortcuts
Your email is safe with us. No spam, ever.

Thankyou for your submission

We have sent the cheatsheet on your email!
Oops! Something went wrong while submitting the form.

ClickHouse

Cheatsheet

(Perfect for DevOps & SREs)

Most-used commands
Your email is safe with us. No spam, ever.

Thankyou for your submission

We have sent the cheatsheet on your email!
Oops! Something went wrong while submitting the form.

MORE ISSUES

ClickHouse DB::Exception: Code: 36, e.displayText() = DB::Exception: Division by zero
An attempt to divide by zero in a query.
ClickHouse DB::Exception: Code: 1038, e.displayText() = DB::Exception: Cannot execute function
The system cannot execute the specified function, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1037, e.displayText() = DB::Exception: Cannot drop function
The system cannot drop the specified function, possibly due to permissions or function locks.
ClickHouse DB::Exception: Code: 1036, e.displayText() = DB::Exception: Cannot create function
The system cannot create the specified function, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1035, e.displayText() = DB::Exception: Cannot remove role
The system cannot remove the specified role, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1029, e.displayText() = DB::Exception: Cannot drop user
The system cannot drop the specified user, possibly due to permissions or user locks.
ClickHouse DB::Exception: Code: 1034, e.displayText() = DB::Exception: Cannot assign role
The system cannot assign the specified role, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1033, e.displayText() = DB::Exception: Cannot drop role
The system cannot drop the specified role, possibly due to permissions or role locks.
ClickHouse DB::Exception: Code: 1032, e.displayText() = DB::Exception: Cannot create role
The system cannot create the specified role, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1031, e.displayText() = DB::Exception: Cannot revoke privileges
The system cannot revoke the specified privileges, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1027, e.displayText() = DB::Exception: Cannot drop index
The system cannot drop the specified index, possibly due to permissions or index locks.
ClickHouse DB::Exception: Code: 1030, e.displayText() = DB::Exception: Cannot grant privileges
The system cannot grant the specified privileges, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1028, e.displayText() = DB::Exception: Cannot create user
The system cannot create the specified user, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1026, e.displayText() = DB::Exception: Cannot create index
The system cannot create the specified index, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1025, e.displayText() = DB::Exception: Cannot drop view
The system cannot drop the specified view, possibly due to permissions or view locks.
ClickHouse DB::Exception: Code: 1024, e.displayText() = DB::Exception: Cannot create view
The system cannot create the specified view, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1023, e.displayText() = DB::Exception: Cannot detach table
The system cannot detach the specified table, possibly due to permissions or table locks.
ClickHouse DB::Exception: Code: 1022, e.displayText() = DB::Exception: Cannot attach table
The system cannot attach the specified table, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1021, e.displayText() = DB::Exception: Cannot drop database
The system cannot drop the specified database, possibly due to permissions or database locks.
ClickHouse DB::Exception: Code: 1016, e.displayText() = DB::Exception: Cannot delete data
The system cannot delete data from the table, possibly due to permissions.
ClickHouse DB::Exception: Code: 1020, e.displayText() = DB::Exception: Cannot create database
The system cannot create the specified database, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1018, e.displayText() = DB::Exception: Cannot optimize table
The system cannot optimize the specified table, possibly due to permissions or table locks.
ClickHouse DB::Exception: Code: 1019, e.displayText() = DB::Exception: Cannot alter table
The system cannot alter the specified table, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1017, e.displayText() = DB::Exception: Cannot truncate table
The system cannot truncate the specified table, possibly due to permissions or table locks.
ClickHouse DB::Exception: Code: 48, e.displayText() = DB::Exception: Unknown function
The function used in the query is not recognized by ClickHouse.
ClickHouse DB::Exception: Code: 1015, e.displayText() = DB::Exception: Cannot update data
The system cannot update data in the table, possibly due to schema mismatch or permissions.
ClickHouse DB::Exception: Code: 1011, e.displayText() = DB::Exception: Cannot authenticate
Authentication to the ClickHouse server failed, possibly due to incorrect credentials.
ClickHouse DB::Exception: Code: 1014, e.displayText() = DB::Exception: Cannot insert data
The system cannot insert data into the table, possibly due to schema mismatch or permissions.
ClickHouse DB::Exception: Code: 1013, e.displayText() = DB::Exception: Cannot drop table
The system cannot drop the specified table, possibly due to permissions or table locks.
ClickHouse DB::Exception: Code: 1012, e.displayText() = DB::Exception: Cannot create table
The system cannot create the specified table, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1010, e.displayText() = DB::Exception: Cannot connect to server
The client cannot connect to the ClickHouse server, possibly due to network issues or incorrect server address.
ClickHouse DB::Exception: Code: 1009, e.displayText() = DB::Exception: Cannot execute command
The system cannot execute the specified command, possibly due to permissions or incorrect command.
ClickHouse DB::Exception: Code: 1007, e.displayText() = DB::Exception: Cannot read directory
The system cannot read the specified directory, possibly due to permissions.
ClickHouse DB::Exception: Code: 1008, e.displayText() = DB::Exception: Cannot write to directory
The system cannot write to the specified directory, possibly due to permissions.
ClickHouse DB::Exception: Code: 1006, e.displayText() = DB::Exception: Cannot remove directory
The system cannot remove the specified directory, possibly due to permissions or it is not empty.
ClickHouse DB::Exception: Code: 1005, e.displayText() = DB::Exception: Cannot create directory
The system cannot create the specified directory, possibly due to permissions.
ClickHouse DB::Exception: Code: 1003, e.displayText() = DB::Exception: Cannot delete file
The system cannot delete the specified file, possibly due to permissions.
ClickHouse DB::Exception: Code: 1004, e.displayText() = DB::Exception: Cannot rename file
The system cannot rename the specified file, possibly due to permissions or file locks.
ClickHouse DB::Exception: Code: 1002, e.displayText() = DB::Exception: Cannot write to file
The system cannot write to the specified file, possibly due to permissions or disk space.
ClickHouse DB::Exception: Code: 47, e.displayText() = DB::Exception: Unknown identifier
The query references an identifier that does not exist.
ClickHouse DB::Exception: Code: 1000, e.displayText() = DB::Exception: Cannot open file
The specified file cannot be opened, possibly due to permissions or it does not exist.
ClickHouse DB::Exception: Code: 32, e.displayText() = DB::Exception: Syntax error
There is a syntax error in the SQL query.
ClickHouse DB::Exception: Code: 159, e.displayText() = DB::Exception: Limit for number of columns exceeded
The number of columns in the query exceeds the maximum allowed limit.
ClickHouse DB::Exception: Code: 1001, e.displayText() = DB::Exception: Cannot read all data
The data source is incomplete or corrupted.
ClickHouse DB::Exception: Code: 202, e.displayText() = DB::Exception: Cannot parse JSON
The JSON data is malformed or contains errors.
ClickHouse DB::Exception: Code: 241, e.displayText() = DB::Exception: Cannot lock file
The file is locked by another process.
ClickHouse DB::Exception: Cannot parse input: expected 'x', got 'y'
The input data format does not match the expected format.
ClickHouse DB::Exception: Not enough space
The disk space is insufficient for the operation.
ClickHouse DB::Exception: Memory limit (for query) exceeded
The query is consuming more memory than the allocated limit.
ClickHouse DB::Exception: Received from localhost:9000. DB::Exception: Table default.table_name doesn't exist.
The specified table does not exist in the database.
ClickHouse DB::Exception: Too many parts (300). Merges are processing significantly slower than inserts
The number of parts in a table exceeds the optimal threshold, causing slow merges.
ClickHouse DB::Exception: Code: 60, e.displayText() = DB::Exception: Table is read-only
The table is set to read-only mode.

Backed by

Resources

DocumentationFun For DevsBlog

Contact

Contact UsAbout UsCareersTerms and ConditionsPrivacy PolicyShipping & and Delivery PolicyCancellation & Refund Policy

Platform

AI OpsAlert Grouping & De-DuplicationPlayBooksKubernetes Bot

Connect

Slack CommunityGithubLinkedInX (Twitter)
Made with ❤️ in Bangalore & San Francisco 🏢

Doctor Droid