{"action":"closed","issue":{"url":"https://api.github.com/repos/antirez/redis/issues/3415","repository_url":"https://api.github.com/repos/antirez/redis","labels_url":"https://api.github.com/repos/antirez/redis/issues/3415/labels{/name}","comments_url":"https://api.github.com/repos/antirez/redis/issues/3415/comments","events_url":"https://api.github.com/repos/antirez/redis/issues/3415/events","html_url":"https://github.com/antirez/redis/issues/3415","id":167535603,"number":3415,"title":"Urgent issue with production - Redis deletes all keys on sporadic saves","user":{"login":"DanielMunch","id":5372702,"avatar_url":"https://avatars.githubusercontent.com/u/5372702?v=3","gravatar_id":"","url":"https://api.github.com/users/DanielMunch","html_url":"https://github.com/DanielMunch","followers_url":"https://api.github.com/users/DanielMunch/followers","following_url":"https://api.github.com/users/DanielMunch/following{/other_user}","gists_url":"https://api.github.com/users/DanielMunch/gists{/gist_id}","starred_url":"https://api.github.com/users/DanielMunch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DanielMunch/subscriptions","organizations_url":"https://api.github.com/users/DanielMunch/orgs","repos_url":"https://api.github.com/users/DanielMunch/repos","events_url":"https://api.github.com/users/DanielMunch/events{/privacy}","received_events_url":"https://api.github.com/users/DanielMunch/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-07-26T07:08:26Z","updated_at":"2016-07-26T08:36:36Z","closed_at":"2016-07-26T08:36:36Z","body":"We are experiencing an urgent issue in production, where \"* DB saved on disk\" deletes all stored keys in the rdb file. The background save / fork seems for run as expected.\r\n\r\n[932] 10 Jun 15:08:11.082 # Granting read/write access to 'NT AUTHORITY\\NetworkService' on: \"C:\\Trackunit\\redis\\Service\" \"c:\\trackunit\\redis\\dump\\\" \r\n[932] 10 Jun 15:08:11.082 # Redis successfully installed as a service.\r\nRedis 3.0.501 (00000000/0) 64 bit\r\nRunning in standalone mode\r\nPort: 6379\r\nPID: 4836\r\n\r\n[4836] 13 Jun 09:31:45.417 # Server started, Redis version 3.0.501\r\n[4836] 13 Jun 09:32:21.747 * DB loaded from disk: 36.319 seconds\r\n[4836] 13 Jun 09:32:21.747 * The server is now ready to accept connections on port 6379\r\n[4836] 13 Jun 09:32:22.419 - DB 0: 10440383 keys (10440383 volatile) in 25165824 slots HT.\r\n[4836] 13 Jun 09:32:22.419 - DB 1: 544146 keys (544146 volatile) in 1572864 slots HT.\r\n\r\nConfig is set to SAVE 3600 1, and this is triggering ok, as far as I can see there are no issues here. ie;\r\n\r\n[1400] 13 Jun 13:02:33.292 - DB 0: 10156611 keys (10156611 volatile) in 16777216 slots HT.\r\n[1400] 13 Jun 13:02:33.292 - DB 1: 528267 keys (528267 volatile) in 1048576 slots HT.\r\n[1400] 13 Jun 13:02:33.292 - 2 clients connected (0 slaves), 2947733928 bytes in use\r\n[1400] 13 Jun 13:02:34.710 # fork operation complete\r\n[1400] 13 Jun 13:02:35.085 * Background saving terminated with success\r\n[1400] 13 Jun 13:02:39.132 - DB 0: 10156593 keys (10156593 volatile) in 16777216 slots HT.\r\n[1400] 13 Jun 13:02:39.132 - DB 1: 528259 keys (528259 volatile) in 1048576 slots HT.\r\n\r\nThen I see every few days there are saves made with a different log entry, and this save WIPES the stored keys in production, this is a disaster.\r\n\r\n[1400] 24 Jul 15:50:50.118 - DB 0: 1215196 keys (1215195 volatile) in 2097152 slots HT.\r\n[1400] 24 Jul 15:50:50.118 - DB 1: 57829 keys (57829 volatile) in 65536 slots HT.\r\n[1400] 24 Jul 15:50:50.118 - 36 clients connected (0 slaves), 356430096 bytes in use\r\n[1400] 24 Jul 15:50:54.106 - Accepted 89.248.172.9:47362\r\n[1400] 24 Jul 15:50:56.280 * DB saved on disk\r\n[1400] 24 Jul 15:50:56.296 - Client closed connection\r\n[1400] 24 Jul 15:50:56.312 - Accepted 89.248.172.9:47417\r\n[1400] 24 Jul 15:50:56.327 - Client closed connection\r\n[1400] 24 Jul 15:50:56.343 - Accepted 89.248.172.9:47419\r\n[1400] 24 Jul 15:50:56.374 - Client closed connection\r\n[1400] 24 Jul 15:50:57.704 - DB 0: 197 keys (196 volatile) in 256 slots HT.\r\n[1400] 24 Jul 15:50:57.704 - DB 1: 17 keys (17 volatile) in 32 slots HT.\r\n[1400] 24 Jul 15:50:57.704 - 36 clients connected (0 slaves), 2533672 bytes in use\r\n\r\nand..\r\n\r\n[1400] 23 Jul 19:05:57.861 - DB 0: 1065461 keys (1065460 volatile) in 2097152 slots HT.\r\n[1400] 23 Jul 19:05:57.861 - DB 1: 46469 keys (46469 volatile) in 65536 slots HT.\r\n[1400] 23 Jul 19:05:57.861 - 36 clients connected (0 slaves), 314862440 bytes in use\r\n[1400] 23 Jul 19:06:01.768 - Accepted 89.248.172.9:42046\r\n[1400] 23 Jul 19:06:03.550 * DB saved on disk\r\n[1400] 23 Jul 19:06:03.565 - Client closed connection\r\n[1400] 23 Jul 19:06:03.581 - Accepted 89.248.172.9:42212\r\n[1400] 23 Jul 19:06:03.597 - Client closed connection\r\n[1400] 23 Jul 19:06:03.628 - Accepted 89.248.172.9:42215\r\n[1400] 23 Jul 19:06:03.643 - Client closed connection\r\n[1400] 23 Jul 19:06:05.081 - DB 0: 197 keys (196 volatile) in 256 slots HT.\r\n[1400] 23 Jul 19:06:05.081 - DB 1: 10 keys (10 volatile) in 16 slots HT.\r\n[1400] 23 Jul 19:06:05.081 - 36 clients connected (0 slaves), 2347040 bytes in use\r\n\r\nI have the entire 170 mb log file available if needed.\r\n\r\ncli INFO;\r\n\r\n127.0.0.1:6379> info\r\n# Server\r\nredis_version:3.0.501\r\nredis_git_sha1:00000000\r\nredis_git_dirty:0\r\nredis_build_id:ba05b51e58eb9205\r\nredis_mode:standalone\r\nos:Windows\r\narch_bits:64\r\nmultiplexing_api:WinSock_IOCP\r\nprocess_id:1400\r\nrun_id:c8de48e2f3416548a36e58fe697709773a82a863\r\ntcp_port:6379\r\nuptime_in_seconds:3703193\r\nuptime_in_days:42\r\nhz:10\r\nlru_clock:9896997\r\nconfig_file:C:\\Trackunit\\redis\\Service\\redis.windows.conf\r\n\r\n# Clients\r\nconnected_clients:37\r\nclient_longest_output_list:0\r\nclient_biggest_input_buf:0\r\nblocked_clients:0\r\n\r\n# Memory\r\nused_memory:640185160\r\nused_memory_human:610.53M\r\nused_memory_rss:640147376\r\nused_memory_peak:3443551960\r\nused_memory_peak_human:3.21G\r\nused_memory_lua:36864\r\nmem_fragmentation_ratio:1.00\r\nmem_allocator:jemalloc-3.6.0\r\n\r\n# Persistence\r\nloading:0\r\nrdb_changes_since_last_save:134473\r\nrdb_bgsave_in_progress:0\r\nrdb_last_save_time:1469512303\r\nrdb_last_bgsave_status:ok\r\nrdb_last_bgsave_time_sec:9\r\nrdb_current_bgsave_time_sec:-1\r\naof_enabled:0\r\naof_rewrite_in_progress:0\r\naof_rewrite_scheduled:0\r\naof_last_rewrite_time_sec:-1\r\naof_current_rewrite_time_sec:-1\r\naof_last_bgrewrite_status:ok\r\naof_last_write_status:ok\r\n\r\n# Stats\r\ntotal_connections_received:174\r\ntotal_commands_processed:822433029\r\ninstantaneous_ops_per_sec:314\r\ntotal_net_input_bytes:40841658928\r\ntotal_net_output_bytes:76599625112\r\ninstantaneous_input_kbps:18.45\r\ninstantaneous_output_kbps:24.64\r\nrejected_connections:0\r\nsync_full:0\r\nsync_partial_ok:0\r\nsync_partial_err:0\r\nexpired_keys:45162957\r\nevicted_keys:0\r\nkeyspace_hits:595121785\r\nkeyspace_misses:84083202\r\npubsub_channels:0\r\npubsub_patterns:0\r\nlatest_fork_usec:49037\r\nmigrate_cached_sockets:0\r\n\r\n# Replication\r\nrole:master\r\nconnected_slaves:0\r\nmaster_repl_offset:0\r\nrepl_backlog_active:0\r\nrepl_backlog_size:1048576\r\nrepl_backlog_first_byte_offset:0\r\nrepl_backlog_histlen:0\r\n\r\n# CPU\r\nused_cpu_sys:24808.31\r\nused_cpu_user:18698.80\r\nused_cpu_sys_children:0.00\r\nused_cpu_user_children:0.00\r\n\r\n# Cluster\r\ncluster_enabled:0\r\n\r\n# Keyspace\r\ndb0:keys=2102643,expires=2102642,avg_ttl=568353539\r\ndb1:keys=105136,expires=105136,avg_ttl=563796227\r\n127.0.0.1:6379>\r\n\r\n[redis.windows.config.txt](https://github.com/antirez/redis/files/383211/redis.windows.config.txt)\r\n\r\nConfig attached."}}
{"actor":{"display_login":"DanielMunch"}}