Bulk update error

[XFFA.IR Bot]

I tried to update huge count of posts in transaction:
PHP:

            $finder = \XF::finder( 'XF:Post' );
            $db = \XF::db();

            /** @var Post[] $posts */
            $posts = $finder
                ->where( 'message_state', '=', 'visible' )
                ->fetch();

            // $posts contains over 1000 elements...

            $db->beginTransaction();
            foreach ( $posts as $post ) {
                $post->message = 'some updated message'...

Read more