starred/cloudbeaver
1
0
Fork 0
mirror of https://github.com/dbeaver/cloudbeaver.git synced 2026-04-25 13:46:02 +03:00
Code Issues 212 Projects Releases Packages Wiki Activity

[GH-ISSUE #627] Error when connect ck using read only model #174

New issue
Closed
opened 2026-03-07 20:45:41 +03:00 by kerem · 7 comments
kerem commented 2026-03-07 20:45:41 +03:00
Owner
Copy link

Originally created by @yubobo on GitHub (Jan 21, 2022).
Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/627

SQL Error [164]: ClickHouse exception, code: 164, host: cc-clickhouse.oppoer.me, port: 80; Code: 164, e.displayText() = DB::Exception: Cannot modify 'max_result_rows' setting in readonly mode (version 20.8.5.45)

how to modify this error？

Originally created by @yubobo on GitHub (Jan 21, 2022). Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/627 SQL Error [164]: ClickHouse exception, code: 164, host: cc-clickhouse.oppoer.me, port: 80; Code: 164, e.displayText() = DB::Exception: Cannot modify 'max_result_rows' setting in readonly mode (version 20.8.5.45) how to modify this error？
kerem 2026-03-07 20:45:41 +03:00
kerem commented 2026-03-07 20:45:42 +03:00
Author
Owner
Copy link

@yubobo commented on GitHub (Jan 24, 2022):

org.jkiss.dbeaver.model.sql.DBSQLException: SQL Error [164]: ClickHouse exception, code: 164, host: cc-clickhouse.oppoer.me, port: 80; Code: 164, e.displayText() = DB::Exception: Cannot modify 'max_result_rows' setting in readonly mode (version 20.8.5.45)

at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:133)
at org.jkiss.dbeaver.model.impl.jdbc.struct.JDBCTable.readData(JDBCTable.java:190)
at io.cloudbeaver.service.sql.WebSQLProcessor.lambda$2(WebSQLProcessor.java:232)
at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:171)
at io.cloudbeaver.service.sql.WebSQLProcessor.readDataFromContainer(WebSQLProcessor.java:229)
at io.cloudbeaver.service.sql.impl.WebServiceSQL$2.run(WebServiceSQL.java:340)
at io.cloudbeaver.model.session.WebSession$1.run(WebSession.java:591)
at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)

Caused by: ru.yandex.clickhouse.except.ClickHouseException: ClickHouse exception, code: 164, host: cc-clickhouse.oppoer.me, port: 80; Code: 164, e.displayText() = DB::Exception: Cannot modify 'max_result_rows' setting in readonly mode (version 20.8.5.45)

at ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.specify(ClickHouseExceptionSpecifier.java:59)
at ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.specify(ClickHouseExceptionSpecifier.java:29)
at ru.yandex.clickhouse.ClickHouseStatementImpl.checkForErrorAndThrow(ClickHouseStatementImpl.java:1099)
at ru.yandex.clickhouse.ClickHouseStatementImpl.getInputStream(ClickHouseStatementImpl.java:778)
at ru.yandex.clickhouse.ClickHouseStatementImpl.getLastInputStream(ClickHouseStatementImpl.java:692)
at ru.yandex.clickhouse.ClickHouseStatementImpl.executeQuery(ClickHouseStatementImpl.java:341)
at ru.yandex.clickhouse.ClickHouseStatementImpl.executeQuery(ClickHouseStatementImpl.java:325)
at ru.yandex.clickhouse.ClickHouseStatementImpl.executeQuery(ClickHouseStatementImpl.java:320)
at ru.yandex.clickhouse.ClickHouseStatementImpl.executeQuery(ClickHouseStatementImpl.java:315)
at ru.yandex.clickhouse.ClickHouseStatementImpl.execute(ClickHouseStatementImpl.java:446)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:330)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:130)
... 8 more

Caused by: java.lang.Throwable: Code: 164, e.displayText() = DB::Exception: Cannot modify 'max_result_rows' setting in readonly mode (version 20.8.5.45)

at ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.specify(ClickHouseExceptionSpecifier.java:54)
... 19 more
<!-- gh-comment-id:1019837146 --> @yubobo commented on GitHub (Jan 24, 2022): org.jkiss.dbeaver.model.sql.DBSQLException: SQL Error [164]: ClickHouse exception, code: 164, host: cc-clickhouse.oppoer.me, port: 80; Code: 164, e.displayText() = DB::Exception: Cannot modify 'max_result_rows' setting in readonly mode (version 20.8.5.45) at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:133) at org.jkiss.dbeaver.model.impl.jdbc.struct.JDBCTable.readData(JDBCTable.java:190) at io.cloudbeaver.service.sql.WebSQLProcessor.lambda$2(WebSQLProcessor.java:232) at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:171) at io.cloudbeaver.service.sql.WebSQLProcessor.readDataFromContainer(WebSQLProcessor.java:229) at io.cloudbeaver.service.sql.impl.WebServiceSQL$2.run(WebServiceSQL.java:340) at io.cloudbeaver.model.session.WebSession$1.run(WebSession.java:591) at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63) Caused by: ru.yandex.clickhouse.except.ClickHouseException: ClickHouse exception, code: 164, host: cc-clickhouse.oppoer.me, port: 80; Code: 164, e.displayText() = DB::Exception: Cannot modify 'max_result_rows' setting in readonly mode (version 20.8.5.45) at ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.specify(ClickHouseExceptionSpecifier.java:59) at ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.specify(ClickHouseExceptionSpecifier.java:29) at ru.yandex.clickhouse.ClickHouseStatementImpl.checkForErrorAndThrow(ClickHouseStatementImpl.java:1099) at ru.yandex.clickhouse.ClickHouseStatementImpl.getInputStream(ClickHouseStatementImpl.java:778) at ru.yandex.clickhouse.ClickHouseStatementImpl.getLastInputStream(ClickHouseStatementImpl.java:692) at ru.yandex.clickhouse.ClickHouseStatementImpl.executeQuery(ClickHouseStatementImpl.java:341) at ru.yandex.clickhouse.ClickHouseStatementImpl.executeQuery(ClickHouseStatementImpl.java:325) at ru.yandex.clickhouse.ClickHouseStatementImpl.executeQuery(ClickHouseStatementImpl.java:320) at ru.yandex.clickhouse.ClickHouseStatementImpl.executeQuery(ClickHouseStatementImpl.java:315) at ru.yandex.clickhouse.ClickHouseStatementImpl.execute(ClickHouseStatementImpl.java:446) at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:330) at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:130) ... 8 more Caused by: java.lang.Throwable: Code: 164, e.displayText() = DB::Exception: Cannot modify 'max_result_rows' setting in readonly mode (version 20.8.5.45) at ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.specify(ClickHouseExceptionSpecifier.java:54) ... 19 more
kerem commented 2026-03-07 20:45:42 +03:00
Author
Owner
Copy link

@kseniiaguzeeva commented on GitHub (Jan 24, 2022):

Can you connect to Clickhouse via another application (e.g. DBeaver)? It seems, that the issue is in Clickhouse configuration. Could you please try the advice from this ticket? Here is Clickhouse documentation.
I'm looking forward to your answer.

<!-- gh-comment-id:1019873758 --> @kseniiaguzeeva commented on GitHub (Jan 24, 2022): Can you connect to Clickhouse via another application (e.g. DBeaver)? It seems, that the issue is in Clickhouse configuration. Could you please try the advice from [this ticket](https://github.com/enqueue/metabase-clickhouse-driver/issues/20)? Here is [Clickhouse documentation](https://clickhouse.com/docs/en/operations/settings/permissions-for-queries/#settings_readonly). I'm looking forward to your answer.
kerem commented 2026-03-07 20:45:42 +03:00
Author
Owner
Copy link

@yubobo commented on GitHub (Jan 24, 2022):

I use DataGrip to connect to CK successfully. read only mode.
image

<!-- gh-comment-id:1020015542 --> @yubobo commented on GitHub (Jan 24, 2022): I use DataGrip to connect to CK successfully. read only mode. ![image](https://user-images.githubusercontent.com/4443390/150777782-2067fd14-89b0-42e9-82eb-b39ee66d4ed9.png)
kerem commented 2026-03-07 20:45:42 +03:00
Author
Owner
Copy link

@kseniiaguzeeva commented on GitHub (Jan 26, 2022):

Thank you for the report. It will be fixed.

<!-- gh-comment-id:1022151063 --> @kseniiaguzeeva commented on GitHub (Jan 26, 2022): Thank you for the report. It will be fixed.
kerem commented 2026-03-07 20:45:42 +03:00
Author
Owner
Copy link

@simsicon commented on GitHub (Jan 28, 2022):

@kseniiaguzeeva I can confirm that I am experiencing the same problem with dbeaver/cloudbeaver:21.3.3 docker built. Looking forward to the fix, thank you for your work.

<!-- gh-comment-id:1023823316 --> @simsicon commented on GitHub (Jan 28, 2022): @kseniiaguzeeva I can confirm that I am experiencing the same problem with dbeaver/cloudbeaver:21.3.3 docker built. Looking forward to the fix, thank you for your work.
kerem commented 2026-03-07 20:45:42 +03:00
Author
Owner
Copy link

@kseniiaguzeeva commented on GitHub (Jan 28, 2022):

Thank you for the report. We are going to fix it in 22.0.0 release.

<!-- gh-comment-id:1023930780 --> @kseniiaguzeeva commented on GitHub (Jan 28, 2022): Thank you for the report. We are going to fix it in 22.0.0 release.
kerem commented 2026-03-07 20:45:42 +03:00
Author
Owner
Copy link

@kseniiaguzeeva commented on GitHub (Mar 10, 2022):

The issue is fixed in the latest release.

<!-- gh-comment-id:1064052572 --> @kseniiaguzeeva commented on GitHub (Mar 10, 2022): The issue is fixed in the latest release.
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
devel
dbeaver/cloudbeaver#4120-support-token-header
dbeaver/pro#8978-advanced-paste
dbeaver/pro#5680-add-generation-rest-api-for-te
8961-cb-checkboxes-are-not-clickable-in-main-toolbar-dropdown-menu
dbeaver/pro#9047-cb-explain-execution-plan-ai
8328-cb-sql-query-generation-add-settings-for-the-generated-sql-window
8473-ai-confirmation
8107-cb-increase-the-contrast-of-some-elements
dbeaver/cloudbeaver#4249-session-id-rotation
dbeaver/pro#8234-udbt-only-for-admins
dbeaver/pro#9061-NPE-on-starting-RM-and-QM-applications
dbeaver/pro#8707-remove-folder-feature
dbeaver/pro#8766-migrate-to-junit5
dbeaver/pro#8711-sql-executation-plan-improvments
9048-cb-deadlock
release_26_0_3
dbeaver/pro#8044-add-api-for-database-user-preference
8839-entraid-not-working-from-within-myappsmicrosoftcom
8559-te-launch-redesign
8670-cb-multi-paste-support-in-data-editor-3
8943-cb-bump-npm-dependencies
dbeaver/pro#8655-cb-ai-functions-support
dbeaver/pro#8746-oauth
dbeaver/pro#8824-Unify-file-lock-handling-for-local-and-shared-fs
7912-db-oauth-in-te
dbeaver/pro#4158-tree-advanced-filter
dbeaver/dbeaver-devops#1604-non-root-user-25-2
dbeaver/pro#5124-fix-case-insensetive-username-in-import
3815-ctrl-z-is-unstable-lib-523-version
8894-ai-assistant-cache
dbeaver/pro#8896-Remove-added-h2_server_v3
release_26_0_2
dbeaver/pro#8392-Add-H2-driver-with-the-newest-version
8065-lsp-front-end
release_26_0_1
dbeaver/pro#7844-cb-lsp-server
dbeaver/pro#7530-csp-protection
release_26_0_0
release_25_3_5
release_25_3_4
release_25_3_3
7953-cb-ability-to-pin-rows-in-the-data-editor
devops-2221-base-java-repo
7923-cb-ws-events-are-misconfigured
release_25_3_2
release_25_3_1
release_25_3_0
release_25_2_5
dbeaver/pro#5267/auth-providers-refactoring
dbeaver/pro#6364-add-option-to-set-default-view-for-project
release_25_2_4
dbeaver/pro#5476-task-scheduler-refactor
release_25_2_3
7128-remove-deprecated-api
release_25_2_0
release_25_2_1
release_25_2_2
4569-cb-3681-use-something-better-than-md5-hash-to-pass-local-user-passwords
dbeaver/dbeaver-devops#1604-non-root-user-without-user-in-image
dbeaver/pro#6976-logging-poc
dbeaver/pro#6324-cursor-sync
dbeaver/pro#5630-add-cache-for-queries
dbeaver/pro#5574/fix/multi-query-vqb
dbeaver/pro#5802/feat/table-api
5664-cb-vscode-value-panel-support-text-format
CB-6291-build-local-script-do-not-clone-all-required-repos-for-successful-build
4288-core-fix-critical-cve-2022-0839-and-cve-2022-0839-in-liquibase-bundle
3944-model-data
4207-core-duplicate-cb-session-id-in-dc-side
chore/update-vite-assets-plugin
25.1.5
25.1.4
25.1.3
25.1.2
25.1.1
25.1.0
25.0.5
25.0.4
25.0.3
25.0.2
25.0.1
25.0.0
24.3.5
24.3.4
24.3.3
24.3.2
24.3.0
24.3.1
24.2.5
24.2.4
24.2.3
24.2.2
24.2.1
24.2.0
24.1.5
24.1.4
24.1.3
24.1.2
24.1.0
24.1.1
24.0.5
24.0.4
24.0.3
24.0.2
24.0.1
24.0.0
23.3.5
23.3.4
23.3.3
23.3.2
23.3.1
23.3.0
23.2.5
23.2.4
23.2.3
23.2.2
23.2.1
23.2.0
23.1.5
23.1.4
23.1.3
23.1.2
23.1.1
v23.1.0
v23_0_5
21.3.3
21.2.4
1.2.0
1.1.0
1.0.4
1.0.3
1.0.1b
1.0.2
1.0.1
1.0.0
Labels
Clear labels   
AS

   
can't reproduce

   
can't reproduce

   
deployment

   
development

   
documentation

   
duplicate

   
duplicate

   
ee

   
enhancement

   
external

   
new driver

   
performance

   
pull-request

Mirrored from GitHub Pull Request

  
third party issue

   
wait for response

   
wait for review

   
wontfix

   
x:Oracle

   
x:cassandra

   
x:clickhouse

   
x:db2

   
x:duckdb

   
x:greenplum

   
x:h2

   
x:h2gis

   
x:hana

   
x:hive

   
x:intersystems

   
x:kyuubi

   
x:maria

   
x:mongo

   
x:mysql

   
x:postgresql

   
x:presto

   
x:sql server

   
x:sqlite

   
x:teradata

   
x:trino

   
xf:accessibility

   
xf:administration

   
xf:ai

   
xf:authentication

   
xf:aws

   
xf:commit-mode

   
xf:connection

   
xf:dark theme

   
xf:data editor

   
xf:datatransfer

   
xf:dba

   
xf:driver management

   
xf:erd

   
xf:filters

   
xf:i18n

   
xf:i18n

   
xf:installer

   
xf:json

   
xf:kerberos

   
xf:ldap

   
xf:local config

   
xf:log viewer

   
xf:metadata

   
xf:metadata editor

   
xf:navigator

   
xf:okta

   
xf:query manager

   
xf:resource manager

   
xf:scripts

   
xf:sql editor

   
xf:tasks

   
xf:ui/uix

   
xo: Firefox

   
xo:eclipse

   
xo:internet explorer

   
xo:macos

   
xp:major

   
xrn:internal
No labels
AS
can't reproduce
can't reproduce
deployment
development
documentation
duplicate
duplicate
ee
enhancement
external
new driver
performance
pull-request
third party issue
wait for response
wait for review
wontfix
x:Oracle
x:cassandra
x:clickhouse
x:db2
x:duckdb
x:greenplum
x:h2
x:h2gis
x:hana
x:hive
x:intersystems
x:kyuubi
x:maria
x:mongo
x:mysql
x:postgresql
x:presto
x:sql server
x:sqlite
x:teradata
x:trino
xf:accessibility
xf:administration
xf:ai
xf:authentication
xf:aws
xf:commit-mode
xf:connection
xf:dark theme
xf:data editor
xf:datatransfer
xf:dba
xf:driver management
xf:erd
xf:filters
xf:i18n
xf:i18n
xf:installer
xf:json
xf:kerberos
xf:ldap
xf:local config
xf:log viewer
xf:metadata
xf:metadata editor
xf:navigator
xf:okta
xf:query manager
xf:resource manager
xf:scripts
xf:sql editor
xf:tasks
xf:ui/uix
xo: Firefox
xo:eclipse
xo:internet explorer
xo:macos
xp:major
xrn:internal
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/cloudbeaver#174
No description provided.