caioq commented on PR #8405: URL: https://github.com/apache/incubator-devlake/pull/8405#issuecomment-2836001681
> Does the error disappear after this patch? I would recommend to use `db.Pluck` to fetch all ids at once instead of using `db.Cursor` Good idea, done https://github.com/apache/incubator-devlake/pull/8405/commits/a32009a2fdae230f3bdb50f3fdcc3e96f4f509ec Yes, I tested it locally and the error disappeared. I tested it with 8K Jira Issues and the following database configuration: ```yaml mysql: image: mysql:8 volumes: - mysql-storage:/var/lib/mysql restart: always ports: - 3306:3306 environment: MYSQL_ROOT_PASSWORD: admin MYSQL_DATABASE: lake MYSQL_USER: merico MYSQL_PASSWORD: merico TZ: UTC command: --character-set-server=utf8mb4 --collation-server=utf8mb4_bin --skip-log-bin --max_allowed_packet=9M --net_read_timeout=6 --net_write_timeout=6 ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@devlake.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
