cherry-pick fix(stream): use database barrier interval for now (#27118) to branch release-2.8

Cherry picking #27118 onto branch release-2.8

Original-PR: risingwavelabs/risingwave#27118 ,

This PR/issue was created by cherry-pick action from commit a04fb0488535eaf3cf041d1840a547f3f7b44606.,

Instructions for Jarvis

Run git cherry-pick a04fb0488535eaf3cf041d1840a547f3f7b44606 first, then resolve any conflicts. Avoid unnecessary improvements and keep the diff as close to the original commit as possible. Target branch: release-2.8.