{"action":"created","issue":{"url":"https://api.github.com/repos/yandex/ClickHouse/issues/3829","repository_url":"https://api.github.com/repos/yandex/ClickHouse","labels_url":"https://api.github.com/repos/yandex/ClickHouse/issues/3829/labels{/name}","comments_url":"https://api.github.com/repos/yandex/ClickHouse/issues/3829/comments","events_url":"https://api.github.com/repos/yandex/ClickHouse/issues/3829/events","html_url":"https://github.com/yandex/ClickHouse/issues/3829","id":391079523,"node_id":"MDU6SXNzdWUzOTEwNzk1MjM=","number":3829,"title":"Dictionaries didn't updated in v.18.14.18","user":{"login":"angeldestroyer","id":9303266,"node_id":"MDQ6VXNlcjkzMDMyNjY=","avatar_url":"https://avatars2.githubusercontent.com/u/9303266?v=4","gravatar_id":"","url":"https://api.github.com/users/angeldestroyer","html_url":"https://github.com/angeldestroyer","followers_url":"https://api.github.com/users/angeldestroyer/followers","following_url":"https://api.github.com/users/angeldestroyer/following{/other_user}","gists_url":"https://api.github.com/users/angeldestroyer/gists{/gist_id}","starred_url":"https://api.github.com/users/angeldestroyer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/angeldestroyer/subscriptions","organizations_url":"https://api.github.com/users/angeldestroyer/orgs","repos_url":"https://api.github.com/users/angeldestroyer/repos","events_url":"https://api.github.com/users/angeldestroyer/events{/privacy}","received_events_url":"https://api.github.com/users/angeldestroyer/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"alesapin","id":3684697,"node_id":"MDQ6VXNlcjM2ODQ2OTc=","avatar_url":"https://avatars1.githubusercontent.com/u/3684697?v=4","gravatar_id":"","url":"https://api.github.com/users/alesapin","html_url":"https://github.com/alesapin","followers_url":"https://api.github.com/users/alesapin/followers","following_url":"https://api.github.com/users/alesapin/following{/other_user}","gists_url":"https://api.github.com/users/alesapin/gists{/gist_id}","starred_url":"https://api.github.com/users/alesapin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alesapin/subscriptions","organizations_url":"https://api.github.com/users/alesapin/orgs","repos_url":"https://api.github.com/users/alesapin/repos","events_url":"https://api.github.com/users/alesapin/events{/privacy}","received_events_url":"https://api.github.com/users/alesapin/received_events","type":"User","site_admin":false},"assignees":[{"login":"alesapin","id":3684697,"node_id":"MDQ6VXNlcjM2ODQ2OTc=","avatar_url":"https://avatars1.githubusercontent.com/u/3684697?v=4","gravatar_id":"","url":"https://api.github.com/users/alesapin","html_url":"https://github.com/alesapin","followers_url":"https://api.github.com/users/alesapin/followers","following_url":"https://api.github.com/users/alesapin/following{/other_user}","gists_url":"https://api.github.com/users/alesapin/gists{/gist_id}","starred_url":"https://api.github.com/users/alesapin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alesapin/subscriptions","organizations_url":"https://api.github.com/users/alesapin/orgs","repos_url":"https://api.github.com/users/alesapin/repos","events_url":"https://api.github.com/users/alesapin/events{/privacy}","received_events_url":"https://api.github.com/users/alesapin/received_events","type":"User","site_admin":false}],"milestone":null,"comments":18,"created_at":"2018-12-14T11:47:39Z","updated_at":"2018-12-18T09:24:35Z","closed_at":null,"author_association":"NONE","body":"Clickhouse version 18.14.18. I have several odbc dictionaries (mssql, postgres) with\r\n```xml\r\n...\r\n<lifetime>\r\n    <min> 300 </min>\r\n    <max> 360 </max>\r\n</lifetime>\r\n<layout>\r\n    <complex_key_hashed />\r\n</layout>\r\n...\r\n```\r\nData in mssql/postgres updated every 5-10 minutes.\r\nHowever, dictionary updates are not performed.\r\n\r\nIf i execute: ``` SYSTEM RELOAD DICTIONARY testdict; ```\r\nreturn: long wait and ```<Error> ExternalDictionaries: Cannot update external dictionary 'testdict', leaving old version: Poco::Exception. Code: 1000, e.code() = 11, e.displayText() = Timeout, e.what() = Timeout``` in clickhouse-server.err.log\r\n\r\nIn clickhouse-server.log:\r\n```\r\n2018.12.14 13:44:49.330725 [ 3037651 ] {cc4c7f10-42be-4cdb-8360-ed633f09ef37} <Debug> executeQuery: (from 127.0.0.1:37228) system reload dictionary testdict\r\n```\r\n```\r\nSELECT *\r\nFROM system.query_log\r\nWHERE query_id = 'cc4c7f10-42be-4cdb-8360-ed633f09ef37'\r\n\r\nOk.\r\n\r\n0 rows in set. Elapsed: 0.178 sec. Processed 59.33 million rows, 2.67 GB (333.32 million rows/s., 15.00 GB/s.)\r\n```\r\n```\r\nSELECT *\r\nFROM system.query_thread_log\r\nWHERE query_id = 'cc4c7f10-42be-4cdb-8360-ed633f09ef37'\r\n\r\nOk.\r\n\r\n0 rows in set. Elapsed: 0.124 sec. Processed 12.71 million rows, 571.94 MB (102.32 million rows/s., 4.60 GB/s.)\r\n```\r\n```\r\nSELECT\r\n    creation_time,\r\n    last_exception\r\nFROM system.dictionaries\r\nWHERE name = 'testdict'\r\n\r\n┌───────creation_time─┬─last_exception────────────────────────────────────────────────────────────────────────────┐\r\n│ 2018-12-06 12:31:52 │ Poco::Exception. Code: 1000, e.code() = 11, e.displayText() = Timeout, e.what() = Timeout │\r\n└─────────────────────┴───────────────────────────────────────────────────────────────────────────────────────────┘\r\n\r\n```\r\n\r\n\r\nIn version 18.14.9 everything works well.\r\n"},"comment":{"url":"https://api.github.com/repos/yandex/ClickHouse/issues/comments/448153244","html_url":"https://github.com/yandex/ClickHouse/issues/3829#issuecomment-448153244","issue_url":"https://api.github.com/repos/yandex/ClickHouse/issues/3829","id":448153244,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0ODE1MzI0NA==","user":{"login":"angeldestroyer","id":9303266,"node_id":"MDQ6VXNlcjkzMDMyNjY=","avatar_url":"https://avatars2.githubusercontent.com/u/9303266?v=4","gravatar_id":"","url":"https://api.github.com/users/angeldestroyer","html_url":"https://github.com/angeldestroyer","followers_url":"https://api.github.com/users/angeldestroyer/followers","following_url":"https://api.github.com/users/angeldestroyer/following{/other_user}","gists_url":"https://api.github.com/users/angeldestroyer/gists{/gist_id}","starred_url":"https://api.github.com/users/angeldestroyer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/angeldestroyer/subscriptions","organizations_url":"https://api.github.com/users/angeldestroyer/orgs","repos_url":"https://api.github.com/users/angeldestroyer/repos","events_url":"https://api.github.com/users/angeldestroyer/events{/privacy}","received_events_url":"https://api.github.com/users/angeldestroyer/received_events","type":"User","site_admin":false},"created_at":"2018-12-18T09:24:35Z","updated_at":"2018-12-18T09:24:35Z","author_association":"NONE","body":"I tried to \"enable\" dictionaries from small to large.\r\nUp to this point, everything was fine:\r\n```\r\n┌─type─────────────┬─key──────┬─element_count─┬─formatReadableSize(bytes_allocated)─┬───────creation_time─┬─last_exception─┐\r\n│ ComplexKeyHashed │ (String) │             2 │ 18.37 KiB                           │ 2018-12-18 12:14:17 │                │\r\n│ ComplexKeyHashed │ (Int64)  │             3 │ 18.37 KiB                           │ 2018-12-18 12:14:17 │                │\r\n│ Hashed           │ UInt64   │           995 │ 156.35 KiB                          │ 2018-12-18 12:14:15 │                │\r\n│ ComplexKeyHashed │ (String) │          9853 │ 6.25 MiB                            │ 2018-12-18 12:14:17 │                │\r\n│ Hashed           │ UInt64   │          5744 │ 9.96 MiB                            │ 2018-12-18 12:14:15 │                │\r\n│ Hashed           │ UInt64   │        327974 │ 16.00 MiB                           │ 2018-12-18 12:14:17 │                │\r\n│ ComplexKeyHashed │ (String) │          5744 │ 19.57 MiB                           │ 2018-12-18 12:14:17 │                │\r\n└──────────────────┴──────────┴───────────────┴─────────────────────────────────────┴─────────────────────┴────────────────┘\r\n```\r\nWhen I tried to add a ~410MB dictionary  - problem repeated\r\n```SQL\r\n## from another CH v18.14.9\r\n┌─type───┬─key────┬─element_count─┬─size───────┬───────creation_time─┬─last_exception─┐\r\n│ Hashed │ UInt64 │        462892 │ 409.22 MiB │ 2018-12-18 12:17:22 │                │\r\n└────────┴────────┴───────────────┴────────────┴─────────────────────┴────────────────┘\r\n```"}}
{"actor":{"display_login":"angeldestroyer"}}