Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n22fM-0006TE-Fe for pgsql-hackers@arkaria.postgresql.org; Tue, 28 Dec 2021 02:56:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n22fL-0006OG-Ak for pgsql-hackers@arkaria.postgresql.org; Tue, 28 Dec 2021 02:56:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n22fK-0006O7-NO for pgsql-hackers@lists.postgresql.org; Tue, 28 Dec 2021 02:56:43 +0000 Received: from mail-pl1-x62d.google.com ([2607:f8b0:4864:20::62d]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1n22fI-0001jJ-9i for pgsql-hackers@lists.postgresql.org; Tue, 28 Dec 2021 02:56:41 +0000 Received: by mail-pl1-x62d.google.com with SMTP id j13so12611124plx.4 for ; Mon, 27 Dec 2021 18:56:40 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=tGaZYPPj3DrR8Mi6OKCnbiJJOdxLmwwtlznjrO9bXvU=; b=ZOeuypkCsheEfEJu6RtRGq2k5pulUiqr9oq2DUuraWC4i/QWLvvuhELErIJ7azHJik tzYYV0qtJ0E1ecA05TvzBBD7c9njStwl0EBz/0tETGDirrYFnK5OzOz7kG5PHzr5kFBl mtnYaYq5h9rLOaBzs8p933tRYKyGoRgtW7fUwGC/2hcVaxdL9w7ddc0Yin4AcImjtPQB k9sCY2nYA3/h48He3+PjIiJQEap4GhruVK2OU/SzZ00NnfYsUnpP8nwJqdlJ1yF5SIBt cdkWF0+QWugQkZCnXZPoru30h9x92XGAqi2WymjG5NuxXs6CKto4Z/DVS2pXqli9vEYB mDAA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=tGaZYPPj3DrR8Mi6OKCnbiJJOdxLmwwtlznjrO9bXvU=; b=Bciqf+S58rt49F9zKvrcwl4qJ/r2JoulOk4frLRqMeS3mDeG8XCFV4SZydO7IKulMg 8ksZImRlCE4Qqm3D7BReZkeCM19SWbEqsenZFNSbActWZnFDzRYYGmjTmEyjOtVe6l6I PplxL4T+noclxkhRcjCVmwxk9KBy4isJw0kGD70UNsQQu68jvFE7E5dVgEjTZ5X0g0Sx iAaFyAWV9JbsHrMWHFfQIO27ZWFa12MSZ/yZ14k0zuEWydpUu2jpp4kPZ4bPfwJr7uvC 2csKmHxqAIOfs2InnpJ+XKkwFN7q4Bxu59ENJUK0rQdZ6TmcQyzNmFPOy8vaCllmXqxZ G2QQ== X-Gm-Message-State: AOAM531qstM1n0qbraAT3G9gsZe3rCCU33RWsuWAB05koY574xjvNCMv hGLY7P/PdEkKbolaqtFlaNa9xcUbW5fTYyugL9U= X-Google-Smtp-Source: ABdhPJxnHlEOGbrEnqvHMvin4VF2OLVXVHVF+J0JnJYO//zbLGyWd+c8dGPcVE+gH19E1OInJF5RJ7AdNA27e0S9PMQ= X-Received: by 2002:a17:90b:3014:: with SMTP id hg20mr24349381pjb.69.1640660199078; Mon, 27 Dec 2021 18:56:39 -0800 (PST) MIME-Version: 1.0 References: <20211224.145134.1164706994861031206.horikyota.ntt@gmail.com> In-Reply-To: From: Bharath Rupireddy Date: Tue, 28 Dec 2021 08:26:28 +0530 Message-ID: Subject: Re: Add checkpoint and redo LSN to LogCheckpointEnd log message To: Michael Paquier Cc: Kyotaro Horiguchi , PostgreSQL Hackers Content-Type: multipart/mixed; boundary="0000000000005d13b805d42bf8ba" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000005d13b805d42bf8ba Content-Type: text/plain; charset="UTF-8" On Fri, Dec 24, 2021 at 5:54 PM Bharath Rupireddy wrote: > > On Fri, Dec 24, 2021 at 5:42 PM Michael Paquier wrote: > > > > On Fri, Dec 24, 2021 at 02:51:34PM +0900, Kyotaro Horiguchi wrote: > > > I thougt about something like the following, but your proposal may be > > > clearer. > > > > + "LSN=%X/%X, REDO LSN=%X/%X", > > This could be rather confusing for the average user, even if I agree > > that this is some information that only an advanced user could > > understand. Could it be possible to define those fields in a more > > deterministic way? For one, it is hard to understand the relationship > > between both fields without looking at the code, particulary if both > > share the same value. It is at least rather.. Well, mostly, easy to > > guess what each other field means in this context, which is not the > > case of what you are proposing here. One idea could be use also > > "start point" for REDO, for example. > > How about "location=%X/%X, REDO start location=%X/%X"? The entire log > message can look like below: > > 2021-12-24 12:20:19.140 UTC [1977834] LOG: checkpoint > complete:location=%X/%X, REDO start location=%X/%X; wrote 7 buffers > (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.005 s, > sync=0.007 s, total=0.192 s; sync files=5, longest=0.005 s, > average=0.002 s; distance=293 kB, estimate=56584 kB > > Another variant: > 2021-12-24 12:20:19.140 UTC [1977834] LOG: checkpoint completed at > location=%X/%X with REDO start location=%X/%X: wrote 7 buffers (0.0%); > 0 WAL file(s) added, 0 removed, 0 recycled; write=0.005 s, sync=0.007 > s, total=0.192 s; sync files=5, longest=0.005 s, average=0.002 s; > distance=293 kB, estimate=56584 kB > 2021-12-24 12:20:19.140 UTC [1977834] LOG: restartpoint completed at > location=%X/%X with REDO start location=%X/%X: wrote 7 buffers (0.0%); > 0 WAL file(s) added, 0 removed, 0 recycled; write=0.005 s, sync=0.007 > s, total=0.192 s; sync files=5, longest=0.005 s, average=0.002 s; > distance=293 kB, estimate=56584 kB Here are the 2 patches. one(v2-1-XXX.patch) adding the info as: 2021-12-28 02:44:34.870 UTC [2384386] LOG: checkpoint complete: location=0/1B03040, REDO start location=0/1B03008; wrote 466 buffers (2.8%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.014 s, sync=0.038 s, total=0.072 s; sync files=21, longest=0.022 s, average=0.002 s; distance=6346 kB, estimate=6346 kB another(v2-2-XXX.patch) adding the info as: 2021-12-28 02:52:24.464 UTC [2394396] LOG: checkpoint completed at location=0/212FFC8 with REDO start location=0/212FF90: wrote 451 buffers (2.8%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.012 s, sync=0.032 s, total=0.071 s; sync files=6, longest=0.022 s, average=0.006 s; distance=6272 kB, estimate=6272 kB attaching v1-0001-XXX from the initial mail again just for the sake of completion: 2021-12-23 14:58:54.714 UTC [1965649] LOG: checkpoint complete: wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.025 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=0 kB; LSN=0/14D0AD0, REDO LSN=0/14D0AD0 Thoughts? Regards, Bharath Rupireddy. --0000000000005d13b805d42bf8ba Content-Type: application/octet-stream; name="v2-1-Add-checkpoint-and-redo-LSN-to-LogCheckpointEnd-l.patch" Content-Disposition: attachment; filename="v2-1-Add-checkpoint-and-redo-LSN-to-LogCheckpointEnd-l.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kxpimfgi0 RnJvbSA5OTljZmQ1M2NlNGUxNmNjZmZmOTRjMDAyMmNkODBmZThmZjg0YmU1IE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBCaGFyYXRoIFJ1cGlyZWRkeSA8YmhhcmF0aC5ydXBpcmVkZHlm b3Jwb3N0Z3Jlc0BnbWFpbC5jb20+CkRhdGU6IFR1ZSwgMjggRGVjIDIwMjEgMDI6NDU6NTEgKzAw MDAKU3ViamVjdDogW1BBVENIIHYyXSBBZGQgY2hlY2twb2ludCBhbmQgcmVkbyBMU04gdG8gTG9n Q2hlY2twb2ludEVuZCBsb2cKIG1lc3NhZ2UKCkl0IGlzIHVzZWZ1bCAoZm9yIGRlYnVnZ2luZyBw dXJwb3NlcykgaWYgdGhlIGNoZWNrcG9pbnQgZW5kIG1lc3NhZ2UKaGFzIHRoZSBjaGVja3BvaW50 IExTTiBhbmQgUkVETyBMU04uIEl0IGdpdmVzIG1vcmUgY29udGV4dCB3aGlsZQphbmFseXppbmcg Y2hlY2twb2ludC1yZWxhdGVkIGlzc3Vlcy4gVGhlIHBnX2NvbnRyb2xkYXRhIGdpdmVzIHRoZQps YXN0IGNoZWNrcG9pbnQgTFNOIGFuZCBSRURPIExTTiwgYnV0IGhhdmluZyB0aGlzIGluZm8gYWxv bmdzaWRlCnRoZSBsb2cgbWVzc2FnZSBoZWxwcyBhbmFseXplIGlzc3VlcyB0aGF0IGhhcHBlbmVk IHByZXZpb3VzbHksCmNvbm5lY3QgdGhlIGRvdHMgYW5kIGlkZW50aWZ5IHRoZSByb290IGNhdXNl LgotLS0KIHNyYy9iYWNrZW5kL2FjY2Vzcy90cmFuc2FtL3hsb2cuYyB8IDEwICsrKysrKysrLS0K IDEgZmlsZSBjaGFuZ2VkLCA4IGluc2VydGlvbnMoKyksIDIgZGVsZXRpb25zKC0pCgpkaWZmIC0t Z2l0IGEvc3JjL2JhY2tlbmQvYWNjZXNzL3RyYW5zYW0veGxvZy5jIGIvc3JjL2JhY2tlbmQvYWNj ZXNzL3RyYW5zYW0veGxvZy5jCmluZGV4IDFlMWZiZTk1N2YuLjI2ZWIyYTIyZjMgMTAwNjQ0Ci0t LSBhL3NyYy9iYWNrZW5kL2FjY2Vzcy90cmFuc2FtL3hsb2cuYworKysgYi9zcmMvYmFja2VuZC9h Y2Nlc3MvdHJhbnNhbS94bG9nLmMKQEAgLTg5MjAsMTEgKzg5MjAsMTQgQEAgTG9nQ2hlY2twb2lu dEVuZChib29sIHJlc3RhcnRwb2ludCkKIAogCWlmIChyZXN0YXJ0cG9pbnQpCiAJCWVyZXBvcnQo TE9HLAotCQkJCShlcnJtc2coInJlc3RhcnRwb2ludCBjb21wbGV0ZTogd3JvdGUgJWQgYnVmZmVy cyAoJS4xZiUlKTsgIgorCQkJCShlcnJtc2coInJlc3RhcnRwb2ludCBjb21wbGV0ZTogbG9jYXRp b249JVgvJVgsIFJFRE8gc3RhcnQgbG9jYXRpb249JVgvJVg7ICIKKwkJCQkJCSJ3cm90ZSAlZCBi dWZmZXJzICglLjFmJSUpOyAiCiAJCQkJCQkiJWQgV0FMIGZpbGUocykgYWRkZWQsICVkIHJlbW92 ZWQsICVkIHJlY3ljbGVkOyAiCiAJCQkJCQkid3JpdGU9JWxkLiUwM2Qgcywgc3luYz0lbGQuJTAz ZCBzLCB0b3RhbD0lbGQuJTAzZCBzOyAiCiAJCQkJCQkic3luYyBmaWxlcz0lZCwgbG9uZ2VzdD0l bGQuJTAzZCBzLCBhdmVyYWdlPSVsZC4lMDNkIHM7ICIKIAkJCQkJCSJkaXN0YW5jZT0lZCBrQiwg ZXN0aW1hdGU9JWQga0IiLAorCQkJCQkJTFNOX0ZPUk1BVF9BUkdTKENvbnRyb2xGaWxlLT5jaGVj a1BvaW50KSwKKwkJCQkJCUxTTl9GT1JNQVRfQVJHUyhDb250cm9sRmlsZS0+Y2hlY2tQb2ludENv cHkucmVkbyksCiAJCQkJCQlDaGVja3BvaW50U3RhdHMuY2twdF9idWZzX3dyaXR0ZW4sCiAJCQkJ CQkoZG91YmxlKSBDaGVja3BvaW50U3RhdHMuY2twdF9idWZzX3dyaXR0ZW4gKiAxMDAgLyBOQnVm ZmVycywKIAkJCQkJCUNoZWNrcG9pbnRTdGF0cy5ja3B0X3NlZ3NfYWRkZWQsCkBAIC04OTQwLDEx ICs4OTQzLDE0IEBAIExvZ0NoZWNrcG9pbnRFbmQoYm9vbCByZXN0YXJ0cG9pbnQpCiAJCQkJCQko aW50KSAoQ2hlY2tQb2ludERpc3RhbmNlRXN0aW1hdGUgLyAxMDI0LjApKSkpOwogCWVsc2UKIAkJ ZXJlcG9ydChMT0csCi0JCQkJKGVycm1zZygiY2hlY2twb2ludCBjb21wbGV0ZTogd3JvdGUgJWQg YnVmZmVycyAoJS4xZiUlKTsgIgorCQkJCShlcnJtc2coImNoZWNrcG9pbnQgY29tcGxldGU6IGxv Y2F0aW9uPSVYLyVYLCBSRURPIHN0YXJ0IGxvY2F0aW9uPSVYLyVYOyAiCisJCQkJCQkid3JvdGUg JWQgYnVmZmVycyAoJS4xZiUlKTsgIgogCQkJCQkJIiVkIFdBTCBmaWxlKHMpIGFkZGVkLCAlZCBy ZW1vdmVkLCAlZCByZWN5Y2xlZDsgIgogCQkJCQkJIndyaXRlPSVsZC4lMDNkIHMsIHN5bmM9JWxk LiUwM2QgcywgdG90YWw9JWxkLiUwM2QgczsgIgogCQkJCQkJInN5bmMgZmlsZXM9JWQsIGxvbmdl c3Q9JWxkLiUwM2QgcywgYXZlcmFnZT0lbGQuJTAzZCBzOyAiCiAJCQkJCQkiZGlzdGFuY2U9JWQg a0IsIGVzdGltYXRlPSVkIGtCIiwKKwkJCQkJCUxTTl9GT1JNQVRfQVJHUyhDb250cm9sRmlsZS0+ Y2hlY2tQb2ludCksCisJCQkJCQlMU05fRk9STUFUX0FSR1MoQ29udHJvbEZpbGUtPmNoZWNrUG9p bnRDb3B5LnJlZG8pLAogCQkJCQkJQ2hlY2twb2ludFN0YXRzLmNrcHRfYnVmc193cml0dGVuLAog CQkJCQkJKGRvdWJsZSkgQ2hlY2twb2ludFN0YXRzLmNrcHRfYnVmc193cml0dGVuICogMTAwIC8g TkJ1ZmZlcnMsCiAJCQkJCQlDaGVja3BvaW50U3RhdHMuY2twdF9zZWdzX2FkZGVkLAotLSAKMi4y NS4xCgo= --0000000000005d13b805d42bf8ba Content-Type: application/octet-stream; name="v2-2-Add-checkpoint-and-redo-LSN-to-LogCheckpointEnd-l.patch" Content-Disposition: attachment; filename="v2-2-Add-checkpoint-and-redo-LSN-to-LogCheckpointEnd-l.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kxpimhnu1 RnJvbSBjMjMwMTBjNjdhNjZkZDIxZTMxOGFlNGQ0NzVlZTBkODVjNWMxZDA4IE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBCaGFyYXRoIFJ1cGlyZWRkeSA8YmhhcmF0aC5ydXBpcmVkZHlm b3Jwb3N0Z3Jlc0BnbWFpbC5jb20+CkRhdGU6IFR1ZSwgMjggRGVjIDIwMjEgMDI6NTI6NDkgKzAw MDAKU3ViamVjdDogW1BBVENIIHYyXSBBZGQgY2hlY2twb2ludCBhbmQgcmVkbyBMU04gdG8gTG9n Q2hlY2twb2ludEVuZCBsb2cKIG1lc3NhZ2UKCkl0IGlzIHVzZWZ1bCAoZm9yIGRlYnVnZ2luZyBw dXJwb3NlcykgaWYgdGhlIGNoZWNrcG9pbnQgZW5kIG1lc3NhZ2UKaGFzIHRoZSBjaGVja3BvaW50 IExTTiBhbmQgUkVETyBMU04uIEl0IGdpdmVzIG1vcmUgY29udGV4dCB3aGlsZQphbmFseXppbmcg Y2hlY2twb2ludC1yZWxhdGVkIGlzc3Vlcy4gVGhlIHBnX2NvbnRyb2xkYXRhIGdpdmVzIHRoZQps YXN0IGNoZWNrcG9pbnQgTFNOIGFuZCBSRURPIExTTiwgYnV0IGhhdmluZyB0aGlzIGluZm8gYWxv bmdzaWRlCnRoZSBsb2cgbWVzc2FnZSBoZWxwcyBhbmFseXplIGlzc3VlcyB0aGF0IGhhcHBlbmVk IHByZXZpb3VzbHksCmNvbm5lY3QgdGhlIGRvdHMgYW5kIGlkZW50aWZ5IHRoZSByb290IGNhdXNl LgotLS0KIHNyYy9iYWNrZW5kL2FjY2Vzcy90cmFuc2FtL3hsb2cuYyB8IDEwICsrKysrKysrLS0K IDEgZmlsZSBjaGFuZ2VkLCA4IGluc2VydGlvbnMoKyksIDIgZGVsZXRpb25zKC0pCgpkaWZmIC0t Z2l0IGEvc3JjL2JhY2tlbmQvYWNjZXNzL3RyYW5zYW0veGxvZy5jIGIvc3JjL2JhY2tlbmQvYWNj ZXNzL3RyYW5zYW0veGxvZy5jCmluZGV4IDFlMWZiZTk1N2YuLmNkM2ZjZTZhMmMgMTAwNjQ0Ci0t LSBhL3NyYy9iYWNrZW5kL2FjY2Vzcy90cmFuc2FtL3hsb2cuYworKysgYi9zcmMvYmFja2VuZC9h Y2Nlc3MvdHJhbnNhbS94bG9nLmMKQEAgLTg5MjAsMTEgKzg5MjAsMTQgQEAgTG9nQ2hlY2twb2lu dEVuZChib29sIHJlc3RhcnRwb2ludCkKIAogCWlmIChyZXN0YXJ0cG9pbnQpCiAJCWVyZXBvcnQo TE9HLAotCQkJCShlcnJtc2coInJlc3RhcnRwb2ludCBjb21wbGV0ZTogd3JvdGUgJWQgYnVmZmVy cyAoJS4xZiUlKTsgIgorCQkJCShlcnJtc2coInJlc3RhcnRwb2ludCBjb21wbGV0ZWQgYXQgbG9j YXRpb249JVgvJVggd2l0aCBSRURPIHN0YXJ0IGxvY2F0aW9uPSVYLyVYOiAiCisJCQkJCQkid3Jv dGUgJWQgYnVmZmVycyAoJS4xZiUlKTsgIgogCQkJCQkJIiVkIFdBTCBmaWxlKHMpIGFkZGVkLCAl ZCByZW1vdmVkLCAlZCByZWN5Y2xlZDsgIgogCQkJCQkJIndyaXRlPSVsZC4lMDNkIHMsIHN5bmM9 JWxkLiUwM2QgcywgdG90YWw9JWxkLiUwM2QgczsgIgogCQkJCQkJInN5bmMgZmlsZXM9JWQsIGxv bmdlc3Q9JWxkLiUwM2QgcywgYXZlcmFnZT0lbGQuJTAzZCBzOyAiCiAJCQkJCQkiZGlzdGFuY2U9 JWQga0IsIGVzdGltYXRlPSVkIGtCIiwKKwkJCQkJCUxTTl9GT1JNQVRfQVJHUyhDb250cm9sRmls ZS0+Y2hlY2tQb2ludCksCisJCQkJCQlMU05fRk9STUFUX0FSR1MoQ29udHJvbEZpbGUtPmNoZWNr UG9pbnRDb3B5LnJlZG8pLAogCQkJCQkJQ2hlY2twb2ludFN0YXRzLmNrcHRfYnVmc193cml0dGVu LAogCQkJCQkJKGRvdWJsZSkgQ2hlY2twb2ludFN0YXRzLmNrcHRfYnVmc193cml0dGVuICogMTAw IC8gTkJ1ZmZlcnMsCiAJCQkJCQlDaGVja3BvaW50U3RhdHMuY2twdF9zZWdzX2FkZGVkLApAQCAt ODk0MCwxMSArODk0MywxNCBAQCBMb2dDaGVja3BvaW50RW5kKGJvb2wgcmVzdGFydHBvaW50KQog CQkJCQkJKGludCkgKENoZWNrUG9pbnREaXN0YW5jZUVzdGltYXRlIC8gMTAyNC4wKSkpKTsKIAll bHNlCiAJCWVyZXBvcnQoTE9HLAotCQkJCShlcnJtc2coImNoZWNrcG9pbnQgY29tcGxldGU6IHdy b3RlICVkIGJ1ZmZlcnMgKCUuMWYlJSk7ICIKKwkJCQkoZXJybXNnKCJjaGVja3BvaW50IGNvbXBs ZXRlZCBhdCBsb2NhdGlvbj0lWC8lWCB3aXRoIFJFRE8gc3RhcnQgbG9jYXRpb249JVgvJVg6ICIK KwkJCQkJCSJ3cm90ZSAlZCBidWZmZXJzICglLjFmJSUpOyAiCiAJCQkJCQkiJWQgV0FMIGZpbGUo cykgYWRkZWQsICVkIHJlbW92ZWQsICVkIHJlY3ljbGVkOyAiCiAJCQkJCQkid3JpdGU9JWxkLiUw M2Qgcywgc3luYz0lbGQuJTAzZCBzLCB0b3RhbD0lbGQuJTAzZCBzOyAiCiAJCQkJCQkic3luYyBm aWxlcz0lZCwgbG9uZ2VzdD0lbGQuJTAzZCBzLCBhdmVyYWdlPSVsZC4lMDNkIHM7ICIKIAkJCQkJ CSJkaXN0YW5jZT0lZCBrQiwgZXN0aW1hdGU9JWQga0IiLAorCQkJCQkJTFNOX0ZPUk1BVF9BUkdT KENvbnRyb2xGaWxlLT5jaGVja1BvaW50KSwKKwkJCQkJCUxTTl9GT1JNQVRfQVJHUyhDb250cm9s RmlsZS0+Y2hlY2tQb2ludENvcHkucmVkbyksCiAJCQkJCQlDaGVja3BvaW50U3RhdHMuY2twdF9i dWZzX3dyaXR0ZW4sCiAJCQkJCQkoZG91YmxlKSBDaGVja3BvaW50U3RhdHMuY2twdF9idWZzX3dy aXR0ZW4gKiAxMDAgLyBOQnVmZmVycywKIAkJCQkJCUNoZWNrcG9pbnRTdGF0cy5ja3B0X3NlZ3Nf YWRkZWQsCi0tIAoyLjI1LjEKCg== --0000000000005d13b805d42bf8ba Content-Type: application/octet-stream; name="v1-0001-Add-checkpoint-and-redo-LSN-to-LogCheckpointEnd-l.patch" Content-Disposition: attachment; filename="v1-0001-Add-checkpoint-and-redo-LSN-to-LogCheckpointEnd-l.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kxpinthl2 RnJvbSBhNjQxZDgyZThlYjRmYTk1ODJhMGY4M2E2ZjhkYTVmZjQ2OGQxNzEwIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBCaGFyYXRoIFJ1cGlyZWRkeSA8YmhhcmF0aC5ydXBpcmVkZHlm b3Jwb3N0Z3Jlc0BnbWFpbC5jb20+CkRhdGU6IFRodSwgMjMgRGVjIDIwMjEgMTU6MDM6MzAgKzAw MDAKU3ViamVjdDogW1BBVENIIHYxXSBBZGQgY2hlY2twb2ludCBhbmQgcmVkbyBMU04gdG8gTG9n Q2hlY2twb2ludEVuZCBsb2cKIG1lc3NhZ2UKCkl0IGlzIHVzZWZ1bCAoZm9yIGRlYnVnZ2luZyBw dXJwb3NlcykgaWYgdGhlIGNoZWNrcG9pbnQgZW5kIG1lc3NhZ2UKaGFzIHRoZSBjaGVja3BvaW50 IExTTiBhbmQgUkVETyBMU04uIEl0IGdpdmVzIG1vcmUgY29udGV4dCB3aGlsZQphbmFseXppbmcg Y2hlY2twb2ludC1yZWxhdGVkIGlzc3Vlcy4gVGhlIHBnX2NvbnRyb2xkYXRhIGdpdmVzIHRoZQps YXN0IGNoZWNrcG9pbnQgTFNOIGFuZCBSRURPIExTTiwgYnV0IGhhdmluZyB0aGlzIGluZm8gYWxv bmdzaWRlCnRoZSBsb2cgbWVzc2FnZSBoZWxwcyBhbmFseXplIGlzc3VlcyB0aGF0IGhhcHBlbmVk IHByZXZpb3VzbHksCmNvbm5lY3QgdGhlIGRvdHMgYW5kIGlkZW50aWZ5IHRoZSByb290IGNhdXNl LgotLS0KIHNyYy9iYWNrZW5kL2FjY2Vzcy90cmFuc2FtL3hsb2cuYyB8IDE0ICsrKysrKysrKyst LS0tCiAxIGZpbGUgY2hhbmdlZCwgMTAgaW5zZXJ0aW9ucygrKSwgNCBkZWxldGlvbnMoLSkKCmRp ZmYgLS1naXQgYS9zcmMvYmFja2VuZC9hY2Nlc3MvdHJhbnNhbS94bG9nLmMgYi9zcmMvYmFja2Vu ZC9hY2Nlc3MvdHJhbnNhbS94bG9nLmMKaW5kZXggMWUxZmJlOTU3Zi4uOTgxNmY3ZDMyOCAxMDA2 NDQKLS0tIGEvc3JjL2JhY2tlbmQvYWNjZXNzL3RyYW5zYW0veGxvZy5jCisrKyBiL3NyYy9iYWNr ZW5kL2FjY2Vzcy90cmFuc2FtL3hsb2cuYwpAQCAtODkyNCw3ICs4OTI0LDggQEAgTG9nQ2hlY2tw b2ludEVuZChib29sIHJlc3RhcnRwb2ludCkKIAkJCQkJCSIlZCBXQUwgZmlsZShzKSBhZGRlZCwg JWQgcmVtb3ZlZCwgJWQgcmVjeWNsZWQ7ICIKIAkJCQkJCSJ3cml0ZT0lbGQuJTAzZCBzLCBzeW5j PSVsZC4lMDNkIHMsIHRvdGFsPSVsZC4lMDNkIHM7ICIKIAkJCQkJCSJzeW5jIGZpbGVzPSVkLCBs b25nZXN0PSVsZC4lMDNkIHMsIGF2ZXJhZ2U9JWxkLiUwM2QgczsgIgotCQkJCQkJImRpc3RhbmNl PSVkIGtCLCBlc3RpbWF0ZT0lZCBrQiIsCisJCQkJCQkiZGlzdGFuY2U9JWQga0IsIGVzdGltYXRl PSVkIGtCOyAiCisJCQkJCQkiTFNOPSVYLyVYLCBSRURPIExTTj0lWC8lWCIsCiAJCQkJCQlDaGVj a3BvaW50U3RhdHMuY2twdF9idWZzX3dyaXR0ZW4sCiAJCQkJCQkoZG91YmxlKSBDaGVja3BvaW50 U3RhdHMuY2twdF9idWZzX3dyaXR0ZW4gKiAxMDAgLyBOQnVmZmVycywKIAkJCQkJCUNoZWNrcG9p bnRTdGF0cy5ja3B0X3NlZ3NfYWRkZWQsCkBAIC04OTM3LDE0ICs4OTM4LDE3IEBAIExvZ0NoZWNr cG9pbnRFbmQoYm9vbCByZXN0YXJ0cG9pbnQpCiAJCQkJCQlsb25nZXN0X21zZWNzIC8gMTAwMCwg KGludCkgKGxvbmdlc3RfbXNlY3MgJSAxMDAwKSwKIAkJCQkJCWF2ZXJhZ2VfbXNlY3MgLyAxMDAw LCAoaW50KSAoYXZlcmFnZV9tc2VjcyAlIDEwMDApLAogCQkJCQkJKGludCkgKFByZXZDaGVja1Bv aW50RGlzdGFuY2UgLyAxMDI0LjApLAotCQkJCQkJKGludCkgKENoZWNrUG9pbnREaXN0YW5jZUVz dGltYXRlIC8gMTAyNC4wKSkpKTsKKwkJCQkJCShpbnQpIChDaGVja1BvaW50RGlzdGFuY2VFc3Rp bWF0ZSAvIDEwMjQuMCksCisJCQkJCQlMU05fRk9STUFUX0FSR1MoQ29udHJvbEZpbGUtPmNoZWNr UG9pbnQpLAorCQkJCQkJTFNOX0ZPUk1BVF9BUkdTKENvbnRyb2xGaWxlLT5jaGVja1BvaW50Q29w eS5yZWRvKSkpKTsKIAllbHNlCiAJCWVyZXBvcnQoTE9HLAogCQkJCShlcnJtc2coImNoZWNrcG9p bnQgY29tcGxldGU6IHdyb3RlICVkIGJ1ZmZlcnMgKCUuMWYlJSk7ICIKIAkJCQkJCSIlZCBXQUwg ZmlsZShzKSBhZGRlZCwgJWQgcmVtb3ZlZCwgJWQgcmVjeWNsZWQ7ICIKIAkJCQkJCSJ3cml0ZT0l bGQuJTAzZCBzLCBzeW5jPSVsZC4lMDNkIHMsIHRvdGFsPSVsZC4lMDNkIHM7ICIKIAkJCQkJCSJz eW5jIGZpbGVzPSVkLCBsb25nZXN0PSVsZC4lMDNkIHMsIGF2ZXJhZ2U9JWxkLiUwM2QgczsgIgot CQkJCQkJImRpc3RhbmNlPSVkIGtCLCBlc3RpbWF0ZT0lZCBrQiIsCisJCQkJCQkiZGlzdGFuY2U9 JWQga0IsIGVzdGltYXRlPSVkIGtCOyAiCisJCQkJCQkiTFNOPSVYLyVYLCBSRURPIExTTj0lWC8l WCIsCiAJCQkJCQlDaGVja3BvaW50U3RhdHMuY2twdF9idWZzX3dyaXR0ZW4sCiAJCQkJCQkoZG91 YmxlKSBDaGVja3BvaW50U3RhdHMuY2twdF9idWZzX3dyaXR0ZW4gKiAxMDAgLyBOQnVmZmVycywK IAkJCQkJCUNoZWNrcG9pbnRTdGF0cy5ja3B0X3NlZ3NfYWRkZWQsCkBAIC04OTU3LDcgKzg5NjEs OSBAQCBMb2dDaGVja3BvaW50RW5kKGJvb2wgcmVzdGFydHBvaW50KQogCQkJCQkJbG9uZ2VzdF9t c2VjcyAvIDEwMDAsIChpbnQpIChsb25nZXN0X21zZWNzICUgMTAwMCksCiAJCQkJCQlhdmVyYWdl X21zZWNzIC8gMTAwMCwgKGludCkgKGF2ZXJhZ2VfbXNlY3MgJSAxMDAwKSwKIAkJCQkJCShpbnQp IChQcmV2Q2hlY2tQb2ludERpc3RhbmNlIC8gMTAyNC4wKSwKLQkJCQkJCShpbnQpIChDaGVja1Bv aW50RGlzdGFuY2VFc3RpbWF0ZSAvIDEwMjQuMCkpKSk7CisJCQkJCQkoaW50KSAoQ2hlY2tQb2lu dERpc3RhbmNlRXN0aW1hdGUgLyAxMDI0LjApLAorCQkJCQkJTFNOX0ZPUk1BVF9BUkdTKENvbnRy b2xGaWxlLT5jaGVja1BvaW50KSwKKwkJCQkJCUxTTl9GT1JNQVRfQVJHUyhDb250cm9sRmlsZS0+ Y2hlY2tQb2ludENvcHkucmVkbykpKSk7CiB9CiAKIC8qCi0tIAoyLjI1LjEKCg== --0000000000005d13b805d42bf8ba--