{"id":41105,"date":"2026-08-27T10:14:05","date_gmt":"2026-08-27T07:14:05","guid":{"rendered":"https:\/\/profelis.com.tr\/?p=41105"},"modified":"2026-08-27T10:24:20","modified_gmt":"2026-08-27T07:24:20","slug":"felaket-kurtarma-tatbikati-nasil-soruna-donusebilir-postgresql-restore-surecinde-sessiz-kilitlenme-bug-19490","status":"publish","type":"post","link":"https:\/\/profelis.com.tr\/en\/2026\/08\/27\/felaket-kurtarma-tatbikati-nasil-soruna-donusebilir-postgresql-restore-surecinde-sessiz-kilitlenme-bug-19490\/","title":{"rendered":"How Can a Disaster Recovery Drill Turn into a Problem? Silent Lockup During the PostgreSQL Restore Process (Bug #19490)"},"content":{"rendered":"
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

The Quietly Lurking Danger: When Everything Seems Fine...<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

For system administrators, disaster recovery (DR) tests are usually routine and predictable processes. At least, you might think so. You took a backup of your production environment and transferred it to your test server. The base backup opened without any issues, and everything looks fine. Now comes the turn of applying (replaying) the WAL (Write-Ahead Log) files, which will process the transactions that occurred after the backup into the database.<\/span><\/p>

You are monitoring the logs; WAL files are being pulled from the archive one by one, processed... And then suddenly everything stops.<\/span><\/p>

At first, you might think this is a large transaction block and the system is busy writing it to disk. Five minutes pass, ten minutes pass, it becomes half an hour\u2026 You check the server's resource usage; the CPU is relaxed, disk I\/O is almost zero. However, the recovery process never ends, and the database just won't start up and give the \u201cdatabase system is ready to accept connections\u201d message. Gigabytes of WAL files waiting to be processed are lined up outside, but no one inside is touching them. The most frustrating part of the job is that the error logs are spotless. There are no crashes, no error messages; just silence and a frozen startup process.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t

The Real Problem Itself: MultiXactOffsetSLRU<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Since the logs aren't telling you anything, let's drop down to the operating system level. When you examine what the hanging PostgreSQL startup process (PID) is waiting for, you might encounter this scenario: The process is a <\/span>futex_wait<\/span> has entered the (OS-level deadlock) state. With PostgreSQL's own internal monitoring tools (or if hot standby is enabled pg_stat_activity<\/span> When you look through, you see the wait event it is stuck on:<\/span><\/p>

LWLock: MultiXactOffsetSLRU<\/b><\/span><\/p>

The system requested a lock for a MultiXact operation, but this lock has deadlocked in an infinite loop. Data cannot be read, written, and naturally, the remaining WAL files cannot be processed.<\/span><\/p>

While investigating the root cause, if you browse through the PostgreSQL community error logs (pgsql-bugs), you will find exactly this scenario described <\/span>Bug #19490<\/b><\/span> You can face the truth.<\/span><\/p>

So why did this crash happen to you out of the blue? The answer is hidden in the seemingly innocent difference in \u201cversions.\u201d For example, your production server <\/span>16.8<\/b><\/span> when working on the version, because your backup server on which you performed the restore test is newly installed <\/span>16.14<\/b><\/span> version. You might think, \u201cAnyway, it's just a minor version difference, it is backward compatible.\u201d. However, in PostgreSQL 16.12 <\/strong><\/span>The code change added to the SimpleLruWriteAll() function triggers this latent deadlock bug during WAL replay operations across minor versions.<\/strong><\/p>

If you also experience the issue where WAL files suddenly stop processing in the middle of a restore operation and the system silently hangs, You are not alone.<\/strong> Let's see how you can get out of this deadlock and get the database running.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t

Searching for a Temporary Solution: Downgrading<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

After identifying the issue, the first thing that might come to mind is to bring the PostgreSQL version on the test server to the same level as production, that is, to 16.8 (or to 16.11 where the bug does not yet exist). It is theoretically possible to downgrade only the binary files without touching the data directory. However, dealing with package downgrades and trying to resolve operating system dependencies is the last thing you would want to do. You need a much cleaner and more permanent solution.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t\t

Rescuer Process: PostgreSQL 16.15<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Fortunately, the PostgreSQL community recognized this issue (Bug #19490) and took action. <\/span>August 13, 2026<\/b><\/span> published on the date of <\/span>PostgreSQL 16.15<\/b><\/span> its version has become the solution for those suffering precisely from this problem. Reviewing the release notes, it is seen that the deadlock on SLRU locks during WAL replay has been resolved.<\/strong><\/span><\/p>

All you need to do is move the server forward. Since this is a \u201cminor\u201d version update, you do not need to deal with database files or complex migration scenarios:<\/span><\/p>

  1. Stop the locked PostgreSQL service on the test server.<\/span><\/li>
  2. via your operating system's package manager (apt\/yum etc.) <\/span>postgresql-16<\/span> by updating your package <\/span>16.15<\/b><\/span> Downgrade to version.<\/span><\/li>
  3. Restart the service.<\/span><\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t\t

    Breaking the Silence and Happy Ending<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    After starting the PostgreSQL service, observe the log file. And that moment of resolution will come\u2026 Gigabytes of WAL files, waiting untouched for hours, will begin to be processed in seconds. <\/span>pg_stat_slru<\/span> It will be reset and wait events will return completely to normal. There will be no deadlocks and no hanging. Within just a few minutes, you will see the expected line in the log file:<\/span><\/p>

    LOG: database system is ready to accept connections<\/span><\/p>

    Your database will start up healthily, full data consistency will be ensured, and your stressfully started restore test will conclude successfully.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t

    \n\t\t\t\t\t

    Lessons to be Learned (Best Practices)<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    These kinds of restore tests serve as a reminder of a few golden rules regarding database management:<\/span><\/p>

    1. Don't Underestimate Minor Versions:<\/b> \u201c16.x and 16.y are the same anyway\u201d<\/span><\/i> Do not say that. In the database world, small code changes can lead to unpredictably large effects, especially in low-level kernel mechanisms like WAL replay and SLRU.<\/span><\/li>
    2. Version Synchronization is Required:<\/b> Compare the versions of the servers where you perform restore tests or keep as Disaster Recovery (DR) with your production servers. <\/span>on the exact same minor version<\/b> Make sure to keep holding it.<\/span><\/li>
    3. Stay Up to Date:<\/b> If version differences are inevitable or you are setting up a brand new server, always upgrade to the latest known stable version announced by the PostgreSQL community (in our case, 16.15).<\/span><\/li><\/ol>

      If your restore process is freezing for no reason and the logs aren't telling you anything, maybe in the background waiting quietly and silently <\/span><\/span>MultiXactOffsetSLRU<\/span> the lock<\/span> exists. The solution is not very far away; your server <\/span>Update to 16.15<\/b><\/span> and sit back and watch the logs flow.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"

      Explore the cause of the silent lockup during the PostgreSQL restore process, Bug #19490, and the solution introduced in PostgreSQL 16.15, along with the technical details.<\/p>","protected":false},"author":16,"featured_media":41111,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[45,75,129],"tags":[60,50],"class_list":["post-41105","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-yazi","category-postgresql","category-veritabani","tag-postgresql","tag-veritabani"],"_links":{"self":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/41105","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/comments?post=41105"}],"version-history":[{"count":15,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/41105\/revisions"}],"predecessor-version":[{"id":41127,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/41105\/revisions\/41127"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/media\/41111"}],"wp:attachment":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/media?parent=41105"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/categories?post=41105"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/tags?post=41105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}