> Source: [sk181977](https://support.checkpoint.com/results/sk/sk181977)

# sk181977 - Database revision purge stuck at "0% Purging data (stage 1/3)"

| Property | Value |
|----------|-------|
| Solution ID | sk181977 |
| Date Created | 2024-02-18 |
| Last Modified | 2024-02-18 |
| Technical Level | General |
| Products | Security Management Server |
| Versions | R81.20, R81.10 (EOS), R81 (EOS) |
| OS | Gaia |

## Symptoms

- * The policy revision purge stops with `"0% Purging data (stage 1/3)"` for several hours when purge either multiple or single revision.
* When perform the solution from [sk151514](https://support.checkpoint.com/results/sk/sk151514), in step 6 the query returned a row (not 0 row):  

  `cpm=# select domainid,last_version_to_delete from pending_purge_operations ;`  
  ` domainid | last_version_to_delete `  
  `--------------------------------------+------------------------`  
  ` 41e821a0-3720-11e3-aa6e-0800200c9fde | 12012`  
  `(1 row)`  

  `cpm=# `  
  `cpm=# select * from objectstoresessionentity where domainid='41e821a0-3720-11e3-aa6e-0800200c9fde' and version=12012;`  
  ` rowid | creationtime | description | domainid `  
  ` | id | open | version `  
  `----------------+-------------------+-----------------+--------------------+--------+------+---------`  
  ` a7ccb88d-7aa6-4807-9344-9b53946987cd | 2023-11-24 09:48:17.02 | App name: WEB_API Admin name:davidlin Session ModeREGULAR | 41e821a0-3720-11e3-aa6e-080`  
  `0200c9fde | -32768 | f | 12012`  
  `(1 row)`
* The `$PGDIR/data/postgresql.conf` file on the Management Server is empty:  
  `[Expert@SMS:0]# ls -l $PGDIR/data/postgresql.conf`  
  `
  -rw--- 1 cp_postgres root 0 Jan 29 16:26 /opt/CPshrd-R81/database/postgresql/data/postgresql.conf`

## Solution

[Contact Check Point Support](https://www.checkpoint.com/support-services/contact-support/) to get a Hotfix for this issue.

A Support Engineer will make sure the Hotfix is compatible with your environment before providing it.  
For faster resolution and verification, collect these files:

1. [CPinfo](https://support.checkpoint.com/results/sk/sk92739) file from the Management Server involved in the case.
2. CPM Doctor report from the Management Server.

---

# Agent Instructions

This content is from the Check Point Support Center (https://support.checkpoint.com), the official knowledge base for Check Point cybersecurity products.

## Navigating This Knowledge Base

- **Complete index**: [llms.txt](https://support.checkpoint.com/llms.txt)
- **All SK articles**: [SecureKnowledge Sitemap](https://support.checkpoint.com/sitemaps/secureknowledge-sitemap-index.xml)
- **SK article URL pattern**: `https://support.checkpoint.com/results/sk/{skId}`
- **Markdown responses**: AI bot User-Agents automatically receive `text/markdown` content