为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8开发版
【操作系统】:centos 8
【CPU】:
【问题描述】*:使用jdbc连接数据库作压测时,偶尔出现Caused by: java.net.SocketException: Connection reset的错误,请问是哪里的参数设置错误了吗
本次压测的参数值为:
{‘AUTO_STAT_OBJ’: 2, ‘BTR_SPLIT_MODE’: 0, ‘CIND_CHECK_DUP’: 0, ‘CKPT_DIRTY_PAGES’: 50, ‘CKPT_FLUSH_PAGES’: 7823, ‘CKPT_FLUSH_RATE’: 48.050746891268005, ‘CKPT_INTERVAL’: 616, ‘CKPT_RLOG_SIZE’: 512, ‘CKPT_WAIT_PAGES’: 8581, ‘CLOB_MAX_IFUN_LEN’: 52368922, ‘COMMIT_WRITE’: 1, ‘CONCURRENT_DELAY’: 14, ‘CSEK2_CHECK_LOCK’: 0, ‘CTAB_MUST_PART’: 1, ‘CTAB_SEL_WITH_CONS’: 1, ‘CTAB_WITH_LONG_ROW’: 1, ‘DBLINK_LOB_LEN’: 76, ‘DEADLOCK_CHECK_INTERVAL’: 2819, ‘DEFAULT_FILLFACTOR’: 92, ‘DPC_DCT_REFRESH_POLICY’: 1, ‘DPC_TABLESPACE_BALANCE’: 0, ‘DUAL_ENABLE_SELECT’: 1, ‘DYN_SQL_CAN_CACHE’: 1, ‘ENABLE_DIST_VIEW_UPDATE’: 1, ‘ENABLE_FLASHBACK’: 0, ‘ENABLE_HUGE_SECIND’: 1, ‘ENABLE_SEC_RPTR’: 1, ‘ENABLE_TMP_TAB_ROLLBACK’: 0, ‘ENET_SESS_CHECK_INTERVAL’: 75, ‘FAST_EXTEND_WITH_DS’: 0, ‘FAST_RELEASE_SLOCK’: 0, ‘FAST_START_MTTR_TARGET’: 1620, ‘FBACK_HASH_SIZE’: 11908, ‘FILL_COL_DESC_FLAG’: 1, ‘FIL_CHECK_INTERVAL’: 41, ‘FIRST_ROWS’: 965, ‘FLDR_LOCK_RETRY_TIMES’: 56, ‘FORCE_FLUSH_PAGES’: 62, ‘GEN_SQL_MEM_RECLAIM’: 0, ‘HAGR_BUF_GLOBAL_SIZE’: 17841, ‘HANDLE_WARN_RATE’: 37, ‘HFINS_MAX_THRD_NUM’: 13, ‘HFINS_PARALLEL_FLAG’: 1, ‘HFS_CACHE_SIZE’: 1269, ‘HJ_BUF_GLOBAL_SIZE’: 8441, ‘HLDR_BUF_SIZE’: 18, ‘HLDR_BUF_TOTAL_SIZE’: 1617582699, ‘HLDR_FORCE_COLUMN_STORAGE’: 0, ‘HLDR_FORCE_COLUMN_STORAGE_PERCENT’: 58, ‘HLDR_HOLD_RATE’: 4.498659849404673, ‘HLDR_MAX_RATE’: 10, ‘HLDR_REPAIR_FLAG’: 0, ‘HP_STAT_SAMPLE_COUNT’: 466, ‘HUGEPAGE_THRESHOLD’: 52, ‘HUGE_ACID’: 2, ‘HUGE_DEFAULT_FILE_SIZE’: 365, ‘HUGE_DEFAULT_SECTION_SIZE’: 27231, ‘HUGE_ENABLE_DEL_UPD’: 1, ‘INDEX_PARALLEL_FILL’: 40, ‘INI_SYNC’: 136, ‘LIKE_PATTERN_NUM’: 1906, ‘LIST_TABLE_BRANCH’: 53, ‘LIST_TABLE_NON_BRANCH’: 55, ‘LOAD_BINDED_PLN’: 0, ‘LOB_MAX_INROW_LEN’: 6817, ‘LOB_MVCC’: 0, ‘LOCK_TID_MODE’: 1, ‘LOCK_TID_UPGRADE’: 0, ‘LOGIN_FAIL_TRIGGER’: 0, ‘MAX_CONCURRENT_TRX’: 308, ‘MAX_SQL_LEVEL’: 656, ‘MAX_UNCOMPRESS_LENGTH’: 1436, ‘MAX_UNCOMPRESS_RATIO’: 643, ‘MEMORY_LEAK_CHECK’: 0, ‘MEMORY_TARGET’: 29704, ‘MMT_GLOBAL_SIZE’: 18298, ‘MONITOR_MODIFICATIONS’: 0, ‘MON_CHECK_INTERVAL’: 3824, ‘MTAB_MEM_SIZE’: 31, ‘MVCC_PAGE_OPT’: 1, ‘NESTED_C_STYLE_COMMENT’: 1, ‘NTYPE_MAX_OBJ_NUM’: 6970450, ‘PAGE_CHECK_POLICY’: 1, ‘PRELOAD_EXTENT_NUM’: 31, ‘PRELOAD_SCAN_NUM’: 40, ‘PSEG_RECV’: 0, ‘PURGE_WAIT_TIME’: 1199, ‘RAISE_CASE_NOT_FOUND’: 0, ‘REDOS_PAGE_CRC_CHECK’: 0, ‘REDOS_PRE_LOAD’: 0, ‘RLOG_APPEND_LOGIC’: 1, ‘RLOG_APPEND_SYSTAB_LOGIC’: 0, ‘RLOG_IGNORE_TABLE_SET’: 1, ‘RLOG_RESERVE_THRESHOLD’: 96, ‘ROLL_ON_ERR’: 1, ‘RS_PRE_FETCH’: 1, ‘RT_HEAP_TARGET’: 78978, ‘SAVEPOINT_LIMIT’: 2589, ‘SELECT_LOCK_MODE’: 1, ‘SESS_POOL_SIZE’: 154, ‘SESS_POOL_TARGET’: 19484, ‘SORT_BUF_GLOBAL_SIZE’: 8255, ‘TIMER_TRIG_CHECK_INTERVAL’: 13, ‘TMP_DEL_OPT’: 1, ‘TRUNC_CHECK_MODE’: 2, ‘TRX_DICT_LOCK_NUM’: 189, ‘TSMV_FILE_COPY_PLL’: 11, ‘TSMV_SEND_BUF_SIZE’: 36, ‘TSORT_OPT’: 0, ‘UNDO_BATCH_FAST’: 0, ‘UNDO_RETENTION’: 115.28372546887606, ‘VM_MEM_HEAP’: 3, ‘XA_TRX_IDLE_TIME’: 71}
您好,你这边是直接对数据库压测还是压测应用后java抛出的报错。