mysql 执行 INSERT INTO method_access sql时时间长效率低

[ziyekudeng]

mysql 执行 INSERT INTO method_access sql时时间长效率低

[phodal]

看日志的结果，好像是结束了，能再往上看看吗？

[ziyekudeng]

再次重新执行 日志中发现了这几行错误，我再找找其它的

2022-10-14 20:24:26.904 [pool-2-thread-2] INFO c.t.a.infrastructure.DBIStore - org.jdbi.v3.core.statement.UnableToExecuteStatementException: java.sql.BatchUpdateException: Data truncated for column 'loc' at row 59 [statement:"null", arguments:{positional:{}, named:{}, finder:[]}]

2022-10-14 20:24:26.904 [pool-2-thread-2] INFO c.t.a.i.task.SqlExecuteRunnable - thread-code_ref_class_fields0 is running

2022-10-14 20:24:27.234 [pool-2-thread-4] INFO c.t.a.i.task.SqlExecuteRunnable - thread-code_ref_class_methods0 is running

2022-10-14 20:24:27.669 [pool-2-thread-1] INFO c.t.a.i.task.SqlExecuteRunnable - thread-code_ref_class_parent0 is running

2022-10-14 20:24:27.760 [pool-2-thread-5] INFO c.t.a.i.task.SqlExecuteRunnable - thread-code_ref_class_fields0 is running

2022-10-14 20:24:28.696 [pool-2-thread-1] INFO c.t.a.i.task.SqlExecuteRunnable - thread-code_ref_method_callees0 is running

2022-10-14 20:24:29.329 [pool-2-thread-2] INFO c.t.a.infrastructure.DBIStore - org.jdbi.v3.core.statement.UnableToExecuteStatementException: java.sql.BatchUpdateException: Duplicate entry '17bec3e8-3e50-4c50-81c6-78b4aa2620e6' for key 'code_ref_class_fields.PRIMARY' [statement:"null", arguments:{positional:{}, named:{}, finder:[]}]

2022-10-14 20:24:29.329 [pool-2-thread-2] INFO c.t.a.i.task.SqlExecuteRunnable - thread-code_ref_class_dependencies0 is running

2022-10-14 20:24:29.330 [pool-2-thread-5] INFO c.t.a.infrastructure.DBIStore - org.jdbi.v3.core.statement.UnableToExecuteStatementException: java.sql.BatchUpdateException: Duplicate entry '17bec3e8-3e50-4c50-81c6-78b4aa2620e6' for key 'code_ref_class_fields.PRIMARY' [statement:"null", arguments:{positional:{}, named:{}, finder:[]}]

[ziyekudeng]

请问正常执行扫描，可以在前端查看结果情况下的最后一行日志，是显示什么？

[phodal]

有时候可能没数据，可以参考一下线上环境：http://ec2-68-79-38-105.cn-northwest-1.compute.amazonaws.com.cn/analysis/home

[ziyekudeng]

找到原因了，mysql 执行 INSERT INTO method_access sql时时间长效率低。每秒大约插入100多条。建议增加一个扫描进度条。