主要看了一下,说的是jdbc在提交任务的时候出现了问题,并且驱动未收到服务端的数据包。
【问题原因分析】数据库默认锁等待时间为 0 秒,如果执行语句存在锁等待过长会执行失败
07-09 23:31:54 (EsMiniDaansouDataInfoWithBLOBsUtil.java:80) java.net.SocketTimeoutException: 30,000 milliseconds TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: java.net.SocketTimeoutException: 30,000 milliseconds
**6.25(Convert milliseconds to hours, minutes, and seconds)Write a method that converts milliseconds Write a test program that prompts the user to enter a long integer for milliseconds and displays a string
<= 2 milliseconds 99.96% <= 3 milliseconds 99.98% <= 4 milliseconds 99.98% <= 6 milliseconds 99.98% 99.97% <= 2 milliseconds 99.98% <= 4 milliseconds 100.00% <= 5 milliseconds 100.00% <= 5 milliseconds 99.73% <= 2 milliseconds 99.89% <= 3 milliseconds 99.93% <= 4 milliseconds 99.96% <= 5 milliseconds 99.97% <= 6 milliseconds 99.97% <= 8 milliseconds 99.97% <= 9 milliseconds 99.99% <= 14 milliseconds 99.72% <= 2 milliseconds 99.90% <= 3 milliseconds 99.96% <= 4 milliseconds 100.00% <= 4 milliseconds
99.81% <= 2 milliseconds 99.90% <= 3 milliseconds 99.93% <= 4 milliseconds 99.94% <= 5 milliseconds 99.88% <= 2 milliseconds 99.99% <= 3 milliseconds 100.00% <= 3 milliseconds 54555.38 requests per second 99.09% <= 2 milliseconds 99.89% <= 3 milliseconds 99.92% <= 5 milliseconds 99.95% <= 7 milliseconds 99.95% <= 8 milliseconds 99.95% <= 9 milliseconds 100.00% <= 9 milliseconds 53390.28 requests per second 99.95% <= 2 milliseconds 99.98% <= 3 milliseconds 99.99% <= 4 milliseconds 100.00% <= 4 milliseconds
99.69% <= 2 milliseconds 99.76% <= 3 milliseconds 99.90% <= 4 milliseconds 99.90% <= 5 milliseconds 76.90% <= 2 milliseconds 98.08% <= 3 milliseconds 99.79% <= 4 milliseconds 99.93% <= 5 milliseconds <= 6 milliseconds 99.85% <= 7 milliseconds 99.89% <= 8 milliseconds 99.94% <= 9 milliseconds 99.96% <= 6 milliseconds 99.71% <= 7 milliseconds 99.81% <= 8 milliseconds 99.90% <= 9 milliseconds 99.97% 98.67% <= 2 milliseconds 99.71% <= 3 milliseconds 99.89% <= 4 milliseconds 100.00% <= 5 milliseconds
98.37% <= 2 milliseconds 99.45% <= 3 milliseconds 99.59% <= 4 milliseconds 99.75% <= 5 milliseconds <= 10 milliseconds 99.87% <= 22 milliseconds 99.89% <= 23 milliseconds 99.91% <= 30 milliseconds 99.94% <= 2 milliseconds 98.54% <= 3 milliseconds 99.04% <= 4 milliseconds 99.38% <= 5 milliseconds 99.58% <= 6 milliseconds 99.68% <= 7 milliseconds 99.73% <= 8 milliseconds 99.78% <= 10 milliseconds 99.80% 97.34% <= 2 milliseconds 98.72% <= 3 milliseconds 99.17% <= 4 milliseconds 99.30% <= 5 milliseconds
97.35% <= 3 milliseconds 98.41% <= 4 milliseconds 99.02% <= 5 milliseconds 99.23% <= 6 milliseconds 99.46% <= 7 milliseconds 99.96% <= 8 milliseconds 99.97% <= 9 milliseconds 100.00% <= 9 milliseconds 84.10% <= 2 milliseconds 90.96% <= 3 milliseconds 94.19% <= 4 milliseconds 95.72% <= 5 milliseconds <= 2 milliseconds 98.33% <= 3 milliseconds 98.92% <= 6 milliseconds 98.94% <= 7 milliseconds 98.95% <= 9 milliseconds 99.04% <= 10 milliseconds 99.48% <= 12 milliseconds 99.61% <= 14 milliseconds 99.62%
50 parallel clients 3 bytes payload keep alive: 1 79.00% <= 1 milliseconds 100.00% <= 1 milliseconds 55.00% <= 2 milliseconds 89.00% <= 3 milliseconds 100.00% <= 3 milliseconds 16666.67 requests per second 28.00% <= 2 milliseconds 66.00% <= 3 milliseconds 86.00% <= 4 milliseconds 100.00% <= 5 milliseconds 12.00% <= 2 milliseconds 43.00% <= 3 milliseconds 67.00% <= 4 milliseconds 80.00% <= 5 milliseconds 96.00% <= 6 milliseconds 100.00% <= 6 milliseconds 9090.91 requests per second ====== MSET (10 keys
(cumulative count 8)50.000% <= 0.343 milliseconds (cumulative count 50319)75.000% <= 0.399 milliseconds (cumulative count 75102)87.500% <= 0.431 milliseconds (cumulative count 88783)93.750% <= 0.447 milliseconds count 8)1.338% <= 0.207 milliseconds (cumulative count 1338)35.037% <= 0.303 milliseconds (cumulative (cumulative count 9)50.000% <= 0.263 milliseconds (cumulative count 52284)75.000% <= 0.319 milliseconds count 34)24.823% <= 0.207 milliseconds (cumulative count 24823)70.395% <= 0.303 milliseconds (cumulative
(cumulative count 13) 50.000% <= 0.287 milliseconds (cumulative count 52749) 75.000% <= 0.343 milliseconds count 16) 13.574% <= 0.207 milliseconds (cumulative count 13574) 59.956% <= 0.303 milliseconds (cumulative (cumulative count 1) 50.000% <= 0.255 milliseconds (cumulative count 51084) 75.000% <= 0.311 milliseconds of latencies: 0.052% <= 0.103 milliseconds (cumulative count 52) 27.094% <= 0.207 milliseconds (cumulative count 99954) 99.981% <= 2.007 milliseconds (cumulative count 99981) 100.000% <= 2.103 milliseconds (
(cumulative count 13)50.000% <= 0.287 milliseconds (cumulative count 52749)75.000% <= 0.343 milliseconds (cumulative count 77482)87.500% <= 0.367 milliseconds (cumulative count 88051)93.750% <= 0.383 milliseconds count 16)13.574% <= 0.207 milliseconds (cumulative count 13574)59.956% <= 0.303 milliseconds (cumulative (cumulative count 1)50.000% <= 0.255 milliseconds (cumulative count 51084)75.000% <= 0.311 milliseconds of latencies:0.052% <= 0.103 milliseconds (cumulative count 52)27.094% <= 0.207 milliseconds (cumulative
(cumulative count 8) 50.000% <= 0.343 milliseconds (cumulative count 50319) 75.000% <= 0.399 milliseconds count 8) 1.338% <= 0.207 milliseconds (cumulative count 1338) 35.037% <= 0.303 milliseconds (cumulative (cumulative count 9) 50.000% <= 0.263 milliseconds (cumulative count 52284) 75.000% <= 0.319 milliseconds count 34) 24.823% <= 0.207 milliseconds (cumulative count 24823) 70.395% <= 0.303 milliseconds (cumulative count 99966) 99.993% <= 1.407 milliseconds (cumulative count 99993) 100.000% <= 1.503 milliseconds (
99.47% <= 2 milliseconds 99.84% <= 3 milliseconds 99.91% <= 4 milliseconds 99.93% <= 5 milliseconds 99.93% <= 6 milliseconds 99.94% <= 8 milliseconds 99.95% <= 9 milliseconds 99.98% <= 10 milliseconds 99.98% <= 11 milliseconds 99.99% <= 12 milliseconds 99.99% <= 13 milliseconds 99.99% <= 14 milliseconds 99.99% <= 15 milliseconds 99.99% <= 32 milliseconds 100.00% <= 37 milliseconds 100.00% <= 69 milliseconds 100.00% <= 70 milliseconds 100.00% <= 70 milliseconds 52271.18 requests per second [root@h102 src]
requests completed in 0.28 seconds 50 parallel clients 3 bytes payload keep alive: 1 30.19% <= 1 milliseconds 95.13% <= 2 milliseconds 98.26% <= 3 milliseconds 98.97% <= 4 milliseconds 99.51% <= 7 milliseconds 100.00% <= 7 milliseconds 36101.08 requests per second [root@h102 src]# ---- 使用10000个随机元素填充一个列表 [root 98.58% <= 2 milliseconds 98.94% <= 3 milliseconds 99.08% <= 5 milliseconds 99.47% <= 6 milliseconds 99.51% <= 12 milliseconds 99.75% <= 13 milliseconds 100.00% <= 13 milliseconds 52910.05 requests per
PASS|Time: 931563 milliseconds TEST CASE RESULT|Module: graph|sssp.sql_in|PASS|Time: 18174 milliseconds : 2836 milliseconds TEST CASE RESULT|Module: pmml|table_to_pmml.sql_in|PASS|Time: 34508 milliseconds |PASS|Time: 19777 milliseconds TEST CASE RESULT|Module: svm|svm.sql_in|PASS|Time: 205677 milliseconds |PASS|Time: 6757 milliseconds TEST CASE RESULT|Module: knn|knn.sql_in|PASS|Time: 9835 milliseconds TEST 18780 milliseconds TEST CASE RESULT|Module: glm|inverse_gaussian.sql_in|PASS|Time: 20931 milliseconds
<= 2 milliseconds92.06% <= 3 milliseconds96.72% <= 4 milliseconds97.89% <= 5 milliseconds98.40% <= 6 milliseconds98.70% <= 7 milliseconds98.93% <= 8 milliseconds99.00% <= 9 milliseconds99.07% <= 10 milliseconds99.08% <= 11 milliseconds99.22% <= 12 milliseconds99.27% <= 13 milliseconds99.30% <= 14 milliseconds99.31% milliseconds99.91% <= 46 milliseconds99.95% <= 47 milliseconds99.97% <= 48 milliseconds99.98% <= 49 milliseconds100.00% milliseconds98.58% <= 7 milliseconds98.84% <= 8 milliseconds99.04% <= 9 milliseconds99.25% <= 10 milliseconds99.35%
99.95% <= 2 milliseconds 99.96% <= 3 milliseconds 99.99% <= 4 milliseconds 100.00% <= 4 milliseconds 99.78% <= 2 milliseconds 99.94% <= 3 milliseconds 99.98% <= 4 milliseconds 100.00% <= 5 milliseconds 83.91% <= 2 milliseconds 99.93% <= 3 milliseconds 99.97% <= 4 milliseconds 99.98% <= 5 milliseconds 62.47% <= 2 milliseconds 98.11% <= 3 milliseconds 99.86% <= 4 milliseconds 99.94% <= 5 milliseconds 99.97% <= 6 milliseconds 99.98% <= 7 milliseconds 100.00% <= 8 milliseconds 100.00% <= 8 milliseconds