Why auto increment post id without created Post/Page

[sumitsingh]

Hey,

I am trying to create page/post and then i don’t want to create then go back and come again to create Page/Post then automatically increase post ID.

Here quick video-

​https://www.loom.com/share/26ee0a4301ad4e3cb1027d92268c764e

[sumitsingh]

I have checked and also updated in database without saved page?
​https://www.loom.com/share/33d4915703704147b4433c04d3340fd9

[costdev]

Removing trunk as the Version as this behaviour exists in 4.0.35 (I haven't tested with earlier versions).

[sumitsingh]

Hi @costdev ,

I have checked 5.9 version and there also heppning same things and auomatically increase post ID number on database.

i think we need to resolve this things ASP.

[costdev]

@sumitsingh That's correct about WordPress 5.9. I have observed this behaviour in all WordPress versions from 4.0.35 to 6.0-RC4, but haven't tested this in versions earlier than 4.0.35.

[sumitsingh]

@costdev I have observed becuase i have one big blog site with Multi langugae there there almost 100k blog but Post ID is very long on DB. Becuase daily lot's of guys author come for add post on site then he close without created post then increasing post by on DB.

Replying to costdev:

@sumitsingh That's correct about WordPress 5.9. I have observed this behaviour in all WordPress versions from 4.0.35 to 6.0-RC4, but haven't tested this in versions earlier than 4.0.35.

[SergeyBiryukov]

Hi there, thanks for the ticket!

This has come up a few times before: #14588, #18800, #19079, #19310, #29431, most recently in #33764.

Auto-incrementing post IDs is intended functionality and an integral part of WordPress' auto-draft implementation since WordPress 3.0: [12987] / #11889. The goal is to always have a post ID to work with and avoid race conditions.

Quoting the explanations from an ​old wp-hackers thread, via comment:1:ticket:33764:

Auto-drafts exist because of the fact that multiple users can create new posts at the same time. If two people enter post-new at roughly the same moment, then have their first autosaves occur nearly simultaneously, then there is a race condition that can cause one of them to get back the wrong post ID, which will cause a post to be overwritten/lost when they then continue editing the post.

The auto-draft creates the post and gets the ID of the new post before the editing screen is displayed, thus preventing two simultaneous authors from accidentally having the same post ID in the data in their browser.

Furthermore:

Auto-drafts are automatically deleted after 7 days of going unused. They're self-cleaning, basically. No need to worry about them.

They also go away when the first auto-save occurs while writing a new post.

Reference: ​How to: Avoid a bunch of useless Auto Draft ID entries related in posts table and disable autosave feature in 'post-new.php'?