fix: 1. 修复dev_local_backend报错问题 2.由于内存占用过高，直接去除opensearch

backend/src/main/java/com/openisle/controller/PostController.java

@@ -217,7 +217,11 @@ public class PostController {
     //            userVisitService.recordVisit(auth.getName());
     //        }
 
-    return postMapper.toListDtos(postService.defaultListPosts(ids, tids, page, pageSize));
+    return postService
+      .defaultListPosts(ids, tids, page, pageSize)
+      .stream()
+      .map(postMapper::toSummaryDto)
+      .collect(Collectors.toList());
   }
 
   @GetMapping("/recent")
@@ -265,7 +269,11 @@ public class PostController {
     //            userVisitService.recordVisit(auth.getName());
     //        }
 
-    return postMapper.toListDtos(postService.listPostsByViews(ids, tids, page, pageSize));
+    return postService
+      .listPostsByViews(ids, tids, page, pageSize)
+      .stream()
+      .map(postMapper::toSummaryDto)
+      .collect(Collectors.toList());
   }
 
   @GetMapping("/latest-reply")
@@ -297,7 +305,8 @@ public class PostController {
     //            userVisitService.recordVisit(auth.getName());
     //        }
 
-    return postMapper.toListDtos(postService.listPostsByLatestReply(ids, tids, page, pageSize));
+    List<Post> posts = postService.listPostsByLatestReply(ids, tids, page, pageSize);
+    return posts.stream().map(postMapper::toSummaryDto).collect(Collectors.toList());
   }
 
   @GetMapping("/featured")
@@ -324,6 +333,10 @@ public class PostController {
     //        if (auth != null) {
     //            userVisitService.recordVisit(auth.getName());
     //        }
-    return postMapper.toListDtos(postService.listFeaturedPosts(ids, tids, page, pageSize));
+    return postService
+      .listFeaturedPosts(ids, tids, page, pageSize)
+      .stream()
+      .map(postMapper::toSummaryDto)
+      .collect(Collectors.toList());
   }
 }

backend/src/main/java/com/openisle/mapper/PostMapper.java

@@ -48,38 +48,6 @@ public class PostMapper {
     return dto;
   }
 
-  public List<PostSummaryDto> toListDtos(List<Post> posts) {
-    if (posts == null || posts.isEmpty()) {
-      return List.of();
-    }
-    Map<Long, List<User>> participantsMap = commentService.getParticipantsForPosts(posts, 5);
-    return posts
-      .stream()
-      .map(post -> {
-        PostSummaryDto dto = new PostSummaryDto();
-        applyListFields(post, dto);
-        List<User> participants = participantsMap.get(post.getId());
-        if (participants != null) {
-          dto.setParticipants(
-            participants.stream().map(userMapper::toAuthorDto).collect(Collectors.toList())
-          );
-        } else {
-          dto.setParticipants(List.of());
-        }
-        dto.setReactions(List.of());
-        return dto;
-      })
-      .collect(Collectors.toList());
-  }
-
-  public PostSummaryDto toListDto(Post post) {
-    PostSummaryDto dto = new PostSummaryDto();
-    applyListFields(post, dto);
-    dto.setParticipants(List.of());
-    dto.setReactions(List.of());
-    return dto;
-  }
-
   public PostDetailDto toDetailDto(Post post, String viewer) {
     PostDetailDto dto = new PostDetailDto();
     applyCommon(post, dto);
@@ -93,25 +61,6 @@ public class PostMapper {
     return dto;
   }
 
-  private void applyListFields(Post post, PostSummaryDto dto) {
-    dto.setId(post.getId());
-    dto.setTitle(post.getTitle());
-    dto.setContent(post.getContent());
-    dto.setCreatedAt(post.getCreatedAt());
-    dto.setAuthor(userMapper.toAuthorDto(post.getAuthor()));
-    dto.setCategory(categoryMapper.toDto(post.getCategory()));
-    dto.setTags(post.getTags().stream().map(tagMapper::toDto).collect(Collectors.toList()));
-    dto.setViews(post.getViews());
-    dto.setCommentCount(post.getCommentCount());
-    dto.setStatus(post.getStatus());
-    dto.setPinnedAt(post.getPinnedAt());
-    dto.setLastReplyAt(post.getLastReplyAt());
-    dto.setRssExcluded(post.getRssExcluded() == null || post.getRssExcluded());
-    dto.setClosed(post.isClosed());
-    dto.setVisibleScope(post.getVisibleScope());
-    dto.setType(post.getType());
-  }
-
   private void applyCommon(Post post, PostSummaryDto dto) {
     dto.setId(post.getId());
     dto.setTitle(post.getTitle());

backend/src/main/java/com/openisle/repository/CommentRepository.java

@@ -25,13 +25,6 @@ public interface CommentRepository extends JpaRepository<Comment, Long> {
     @org.springframework.data.repository.query.Param("post") Post post
   );
 
-  @org.springframework.data.jpa.repository.Query(
-    "SELECT DISTINCT c.post.id, c.author FROM Comment c WHERE c.post.id IN :postIds"
-  )
-  java.util.List<Object[]> findDistinctAuthorsByPostIds(
-    @org.springframework.data.repository.query.Param("postIds") java.util.List<Long> postIds
-  );
-
   @org.springframework.data.jpa.repository.Query(
     "SELECT MAX(c.createdAt) FROM Comment c WHERE c.post = :post"
   )

backend/src/main/java/com/openisle/repository/PostRepository.java

@@ -19,8 +19,6 @@ public interface PostRepository extends JpaRepository<Post, Long> {
   List<Post> findByStatusOrderByCreatedAtDesc(PostStatus status, Pageable pageable);
   List<Post> findByStatusOrderByViewsDesc(PostStatus status);
   List<Post> findByStatusOrderByViewsDesc(PostStatus status, Pageable pageable);
-  List<Post> findByStatusOrderByPinnedAtDescViewsDesc(PostStatus status, Pageable pageable);
-  List<Post> findByStatusOrderByPinnedAtDescLastReplyAtDesc(PostStatus status, Pageable pageable);
   List<Post> findByStatusAndCreatedAtGreaterThanEqualOrderByCreatedAtDesc(
     PostStatus status,
     LocalDateTime createdAt
@@ -45,16 +43,6 @@ public interface PostRepository extends JpaRepository<Post, Long> {
     PostStatus status,
     Pageable pageable
   );
-  List<Post> findByCategoryInAndStatusOrderByPinnedAtDescViewsDesc(
-    List<Category> categories,
-    PostStatus status,
-    Pageable pageable
-  );
-  List<Post> findByCategoryInAndStatusOrderByPinnedAtDescLastReplyAtDesc(
-    List<Category> categories,
-    PostStatus status,
-    Pageable pageable
-  );
   List<Post> findDistinctByTagsInAndStatus(List<Tag> tags, PostStatus status);
   List<Post> findDistinctByTagsInAndStatus(List<Tag> tags, PostStatus status, Pageable pageable);
   List<Post> findDistinctByTagsInAndStatusOrderByCreatedAtDesc(List<Tag> tags, PostStatus status);
@@ -144,26 +132,6 @@ public interface PostRepository extends JpaRepository<Post, Long> {
     Pageable pageable
   );
 
-  @Query(
-    "SELECT p FROM Post p JOIN p.tags t WHERE t IN :tags AND p.status = :status GROUP BY p.id HAVING COUNT(DISTINCT t.id) = :tagCount ORDER BY p.pinnedAt DESC, p.views DESC"
-  )
-  List<Post> findByAllTagsOrderByPinnedAtDescViewsDesc(
-    @Param("tags") List<Tag> tags,
-    @Param("status") PostStatus status,
-    @Param("tagCount") long tagCount,
-    Pageable pageable
-  );
-
-  @Query(
-    "SELECT p FROM Post p JOIN p.tags t WHERE t IN :tags AND p.status = :status GROUP BY p.id HAVING COUNT(DISTINCT t.id) = :tagCount ORDER BY p.pinnedAt DESC, p.lastReplyAt DESC"
-  )
-  List<Post> findByAllTagsOrderByPinnedAtDescLastReplyAtDesc(
-    @Param("tags") List<Tag> tags,
-    @Param("status") PostStatus status,
-    @Param("tagCount") long tagCount,
-    Pageable pageable
-  );
-
   @Query(
     "SELECT p FROM Post p JOIN p.tags t WHERE p.category IN :categories AND t IN :tags AND p.status = :status GROUP BY p.id HAVING COUNT(DISTINCT t.id) = :tagCount"
   )
@@ -206,28 +174,6 @@ public interface PostRepository extends JpaRepository<Post, Long> {
     Pageable pageable
   );
 
-  @Query(
-    "SELECT p FROM Post p JOIN p.tags t WHERE p.category IN :categories AND t IN :tags AND p.status = :status GROUP BY p.id HAVING COUNT(DISTINCT t.id) = :tagCount ORDER BY p.pinnedAt DESC, p.views DESC"
-  )
-  List<Post> findByCategoriesAndAllTagsOrderByPinnedAtDescViewsDesc(
-    @Param("categories") List<Category> categories,
-    @Param("tags") List<Tag> tags,
-    @Param("status") PostStatus status,
-    @Param("tagCount") long tagCount,
-    Pageable pageable
-  );
-
-  @Query(
-    "SELECT p FROM Post p JOIN p.tags t WHERE p.category IN :categories AND t IN :tags AND p.status = :status GROUP BY p.id HAVING COUNT(DISTINCT t.id) = :tagCount ORDER BY p.pinnedAt DESC, p.lastReplyAt DESC"
-  )
-  List<Post> findByCategoriesAndAllTagsOrderByPinnedAtDescLastReplyAtDesc(
-    @Param("categories") List<Category> categories,
-    @Param("tags") List<Tag> tags,
-    @Param("status") PostStatus status,
-    @Param("tagCount") long tagCount,
-    Pageable pageable
-  );
-
   @Query(
     "SELECT p FROM Post p JOIN p.tags t WHERE p.category IN :categories AND t IN :tags AND p.status = :status GROUP BY p.id HAVING COUNT(DISTINCT t.id) = :tagCount ORDER BY p.createdAt DESC"
   )

backend/src/main/java/com/openisle/service/CommentService.java

@@ -21,12 +21,8 @@ import com.openisle.service.NotificationService;
 import com.openisle.service.PointService;
 import com.openisle.service.SubscriptionService;
 import java.time.LocalDateTime;
-import java.util.ArrayList;
-import java.util.HashMap;
 import java.util.HashSet;
-import java.util.LinkedHashSet;
 import java.util.List;
-import java.util.Map;
 import java.util.Set;
 import java.util.stream.Collectors;
 import lombok.RequiredArgsConstructor;
@@ -320,37 +316,6 @@ public class CommentService {
     return result;
   }
 
-  public Map<Long, List<User>> getParticipantsForPosts(List<Post> posts, int limit) {
-    if (posts == null || posts.isEmpty()) {
-      return Map.of();
-    }
-    Map<Long, LinkedHashSet<User>> map = new HashMap<>();
-    List<Long> postIds = new ArrayList<>(posts.size());
-    for (Post post : posts) {
-      postIds.add(post.getId());
-      LinkedHashSet<User> set = new LinkedHashSet<>();
-      set.add(post.getAuthor());
-      map.put(post.getId(), set);
-    }
-    for (Object[] row : commentRepository.findDistinctAuthorsByPostIds(postIds)) {
-      Long postId = (Long) row[0];
-      User author = (User) row[1];
-      LinkedHashSet<User> set = map.get(postId);
-      if (set != null) {
-        set.add(author);
-      }
-    }
-    Map<Long, List<User>> result = new HashMap<>(map.size());
-    for (Map.Entry<Long, LinkedHashSet<User>> entry : map.entrySet()) {
-      List<User> list = new ArrayList<>(entry.getValue());
-      if (list.size() > limit) {
-        list = list.subList(0, limit);
-      }
-      result.put(entry.getKey(), list);
-    }
-    return result;
-  }
-
   public java.util.List<Comment> getCommentsByIds(java.util.List<Long> ids) {
     log.debug("getCommentsByIds called for ids {}", ids);
     java.util.List<Comment> comments = commentRepository.findAllById(ids);

backend/src/main/java/com/openisle/service/PostService.java

@@ -339,7 +339,6 @@ public class PostService {
     post.setCategory(category);
     post.setTags(new HashSet<>(tags));
     post.setStatus(publishMode == PublishMode.REVIEW ? PostStatus.PENDING : PostStatus.PUBLISHED);
-    post.setLastReplyAt(LocalDateTime.now());
 
     // 什么都没设置的情况下，默认为ALL
     if (Objects.isNull(postVisibleScopeType)) {
@@ -810,10 +809,9 @@ public class PostService {
     boolean hasTags = tagIds != null && !tagIds.isEmpty();
 
     java.util.List<Post> posts;
-    Pageable pageable = buildPageable(page, pageSize);
 
     if (!hasCategories && !hasTags) {
-      posts = postRepository.findByStatusOrderByPinnedAtDescViewsDesc(PostStatus.PUBLISHED, pageable);
+      posts = postRepository.findByStatusOrderByViewsDesc(PostStatus.PUBLISHED);
     } else if (hasCategories) {
       java.util.List<Category> categories = categoryRepository.findAllById(categoryIds);
       if (categories.isEmpty()) {
@@ -824,18 +822,16 @@ public class PostService {
         if (tags.isEmpty()) {
           return java.util.List.of();
         }
-        posts = postRepository.findByCategoriesAndAllTagsOrderByPinnedAtDescViewsDesc(
+        posts = postRepository.findByCategoriesAndAllTagsOrderByViewsDesc(
           categories,
           tags,
           PostStatus.PUBLISHED,
-          tags.size(),
-          pageable
+          tags.size()
         );
       } else {
-        posts = postRepository.findByCategoryInAndStatusOrderByPinnedAtDescViewsDesc(
+        posts = postRepository.findByCategoryInAndStatusOrderByViewsDesc(
           categories,
-          PostStatus.PUBLISHED,
-          pageable
+          PostStatus.PUBLISHED
         );
       }
     } else {
@@ -843,15 +839,10 @@ public class PostService {
       if (tags.isEmpty()) {
         return java.util.List.of();
       }
-      posts = postRepository.findByAllTagsOrderByPinnedAtDescViewsDesc(
-        tags,
-        PostStatus.PUBLISHED,
-        tags.size(),
-        pageable
-      );
+      posts = postRepository.findByAllTagsOrderByViewsDesc(tags, PostStatus.PUBLISHED, tags.size());
     }
 
-    return posts;
+    return paginate(sortByPinnedAndViews(posts), page, pageSize);
   }
 
   public List<Post> listPostsByLatestReply(Integer page, Integer pageSize) {
@@ -868,13 +859,9 @@ public class PostService {
     boolean hasTags = tagIds != null && !tagIds.isEmpty();
 
     java.util.List<Post> posts;
-    Pageable pageable = buildPageable(page, pageSize);
 
     if (!hasCategories && !hasTags) {
-      posts = postRepository.findByStatusOrderByPinnedAtDescLastReplyAtDesc(
-        PostStatus.PUBLISHED,
-        pageable
-      );
+      posts = postRepository.findByStatusOrderByCreatedAtDesc(PostStatus.PUBLISHED);
     } else if (hasCategories) {
       java.util.List<Category> categories = categoryRepository.findAllById(categoryIds);
       if (categories.isEmpty()) {
@@ -885,18 +872,16 @@ public class PostService {
         if (tags.isEmpty()) {
           return java.util.List.of();
         }
-        posts = postRepository.findByCategoriesAndAllTagsOrderByPinnedAtDescLastReplyAtDesc(
+        posts = postRepository.findByCategoriesAndAllTagsOrderByCreatedAtDesc(
           categories,
           tags,
           PostStatus.PUBLISHED,
-          tags.size(),
-          pageable
+          tags.size()
         );
       } else {
-        posts = postRepository.findByCategoryInAndStatusOrderByPinnedAtDescLastReplyAtDesc(
+        posts = postRepository.findByCategoryInAndStatusOrderByCreatedAtDesc(
           categories,
-          PostStatus.PUBLISHED,
-          pageable
+          PostStatus.PUBLISHED
         );
       }
     } else {
@@ -904,15 +889,14 @@ public class PostService {
       if (tags.isEmpty()) {
         return new ArrayList<>();
       }
-      posts = postRepository.findByAllTagsOrderByPinnedAtDescLastReplyAtDesc(
+      posts = postRepository.findByAllTagsOrderByCreatedAtDesc(
         tags,
         PostStatus.PUBLISHED,
-        tags.size(),
-        pageable
+        tags.size()
       );
     }
 
-    return posts;
+    return paginate(sortByPinnedAndLastReply(posts), page, pageSize);
   }
 
   public List<Post> listPostsByCategories(
@@ -1410,13 +1394,6 @@ public class PostService {
       .toList();
   }
 
-  private Pageable buildPageable(Integer page, Integer pageSize) {
-    if (page == null || pageSize == null) {
-      return Pageable.unpaged();
-    }
-    return PageRequest.of(page, pageSize);
-  }
-
   private List<Post> paginate(List<Post> posts, Integer page, Integer pageSize) {
     if (page == null || pageSize == null) {
       return posts;

backend/src/main/resources/db/migration/V10__backfill_post_last_reply_at.sql

@@ -1,4 +0,0 @@
--- Backfill last_reply_at for posts without comments to preserve latest-reply ordering
-UPDATE posts
-SET last_reply_at = created_at
-WHERE last_reply_at IS NULL;

docker/docker-compose.yaml

@@ -30,62 +30,62 @@ services:
       - dev_local_backend
       - prod
 
-  # OpenSearch Service
-  opensearch:
-    user: "1000:1000"
-    build:
-      context: .
-      dockerfile: opensearch.Dockerfile
-    container_name: ${COMPOSE_PROJECT_NAME}-opensearch
-    environment:
-      - cluster.name=os-single
-      - node.name=os-node-1
-      - discovery.type=single-node
-      - bootstrap.memory_lock=true
-      - OPENSEARCH_JAVA_OPTS=-Xms1g -Xmx1g
-      - DISABLE_SECURITY_PLUGIN=true
-      - cluster.blocks.create_index=false
-    ulimits:
-      memlock: { soft: -1, hard: -1 }
-      nofile: { soft: 65536, hard: 65536 }
-    volumes:
-      - opensearch-data:/usr/share/opensearch/data
-      - opensearch-snapshots:/snapshots
-    ports:
-      - "${OPENSEARCH_PORT:-9200}:9200"
-      - "${OPENSEARCH_METRICS_PORT:-9600}:9600"
-    restart: unless-stopped
-    healthcheck:
-      test:
-        - CMD-SHELL
-        - curl -fsS http://127.0.0.1:9200/_cluster/health >/dev/null
-      interval: 10s
-      timeout: 5s
-      retries: 30
-      start_period: 60s
-    networks:
-      - openisle-network
-    profiles:
-      - dev
-      - dev_local_backend
+  # # OpenSearch Service
+  # opensearch:
+  #   user: "1000:1000"
+  #   build:
+  #     context: .
+  #     dockerfile: opensearch.Dockerfile
+  #   container_name: ${COMPOSE_PROJECT_NAME}-opensearch
+  #   environment:
+  #     - cluster.name=os-single
+  #     - node.name=os-node-1
+  #     - discovery.type=single-node
+  #     - bootstrap.memory_lock=true
+  #     - OPENSEARCH_JAVA_OPTS=-Xms1g -Xmx1g
+  #     - DISABLE_SECURITY_PLUGIN=true
+  #     - cluster.blocks.create_index=false
+  #   ulimits:
+  #     memlock: { soft: -1, hard: -1 }
+  #     nofile: { soft: 65536, hard: 65536 }
+  #   volumes:
+  #     - opensearch-data:/usr/share/opensearch/data
+  #     - opensearch-snapshots:/snapshots
+  #   ports:
+  #     - "${OPENSEARCH_PORT:-9200}:9200"
+  #     - "${OPENSEARCH_METRICS_PORT:-9600}:9600"
+  #   restart: unless-stopped
+  #   healthcheck:
+  #     test:
+  #       - CMD-SHELL
+  #       - curl -fsS http://127.0.0.1:9200/_cluster/health >/dev/null
+  #     interval: 10s
+  #     timeout: 5s
+  #     retries: 30
+  #     start_period: 60s
+  #   networks:
+  #     - openisle-network
+  #   profiles:
+  #     - dev
+  #     - dev_local_backend
 
-  dashboards:
-    image: opensearchproject/opensearch-dashboards:3.0.0
-    container_name: ${COMPOSE_PROJECT_NAME}-os-dashboards
-    environment:
-      OPENSEARCH_HOSTS: '["http://opensearch:9200"]'
-      DISABLE_SECURITY_DASHBOARDS_PLUGIN: "true"
-    ports:
-      - "${OPENSEARCH_DASHBOARDS_PORT:-5601}:5601"
-    depends_on:
-      - opensearch
-    restart: unless-stopped
-    networks:
-      - openisle-network
-    profiles:
-      - dev
-      - dev_local_backend
-      - prod
+  # dashboards:
+  #   image: opensearchproject/opensearch-dashboards:3.0.0
+  #   container_name: ${COMPOSE_PROJECT_NAME}-os-dashboards
+  #   environment:
+  #     OPENSEARCH_HOSTS: '["http://opensearch:9200"]'
+  #     DISABLE_SECURITY_DASHBOARDS_PLUGIN: "true"
+  #   ports:
+  #     - "${OPENSEARCH_DASHBOARDS_PORT:-5601}:5601"
+  #   depends_on:
+  #     - opensearch
+  #   restart: unless-stopped
+  #   networks:
+  #     - openisle-network
+  #   profiles:
+  #     - dev
+  #     - dev_local_backend
+  #     - prod
 
   rabbitmq:
     image: rabbitmq:3.13-management
@@ -200,7 +200,6 @@ services:
       - openisle-network
     profiles:
       - dev
-      - dev_local_backend
       - prod