{"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":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-12-14T11:47:39Z","updated_at":"2018-12-14T15:01:40Z","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/447350791","html_url":"https://github.com/yandex/ClickHouse/issues/3829#issuecomment-447350791","issue_url":"https://api.github.com/repos/yandex/ClickHouse/issues/3829","id":447350791,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0NzM1MDc5MQ==","user":{"login":"kotoyants","id":38683400,"node_id":"MDQ6VXNlcjM4NjgzNDAw","avatar_url":"https://avatars2.githubusercontent.com/u/38683400?v=4","gravatar_id":"","url":"https://api.github.com/users/kotoyants","html_url":"https://github.com/kotoyants","followers_url":"https://api.github.com/users/kotoyants/followers","following_url":"https://api.github.com/users/kotoyants/following{/other_user}","gists_url":"https://api.github.com/users/kotoyants/gists{/gist_id}","starred_url":"https://api.github.com/users/kotoyants/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kotoyants/subscriptions","organizations_url":"https://api.github.com/users/kotoyants/orgs","repos_url":"https://api.github.com/users/kotoyants/repos","events_url":"https://api.github.com/users/kotoyants/events{/privacy}","received_events_url":"https://api.github.com/users/kotoyants/received_events","type":"User","site_admin":false},"created_at":"2018-12-14T15:01:40Z","updated_at":"2018-12-14T15:01:40Z","author_association":"NONE","body":"+1"}}
{"actor":{"display_login":"kotoyants"}}