Starysn
05/22/2025, 6:37 AMXiang Fu
Xiang Fu
Starysn
05/26/2025, 6:27 AMStarysn
05/26/2025, 6:43 AMXiang Fu
Starysn
05/27/2025, 1:34 AMXiang Fu
Xiang Fu
Starysn
05/28/2025, 1:35 AMStarysn
05/28/2025, 2:47 AMXiang Fu
-Xms32G -Xmx32GStarysn
05/30/2025, 2:36 AMError Code: 427
1 servers [server3_R] not responded
Error Code: 200
QueryExecutionError:
Received error query execution result block: {250=ExecutionTimeoutError
ProcessingException(errorCode:250, message:ExecutionTimeoutError)
at org.apache.pinot.common.exception.QueryException.clinit(QueryException.java:116)
at org.apache.pinot.common.response.broker.BrokerResponseNative.clinit(BrokerResponseNative.java:61)
at org.apache.pinot.core.query.reduce.BrokerReduceService.reduceOnDataTable(BrokerReduceService.java:73)
at org.apache.pinot.broker.requesthandler.SingleConnectionBrokerRequestHandler.processBrokerRequest(SingleConnectionBrokerRequestHandler.java:149)}
org.apache.pinot.query.service.dispatch.QueryDispatcher.runReducer(QueryDispatcher.java:462)
org.apache.pinot.query.service.dispatch.QueryDispatcher.submitAndReduce(QueryDispatcher.java:133)
org.apache.pinot.broker.requesthandler.MultiStageBrokerRequestHandler.handleRequest(MultiStageBrokerRequestHandler.java:255)
org.apache.pinot.broker.requesthandler.BaseBrokerRequestHandler.handleRequest(BaseBrokerRequestHandler.java:168)Xiang Fu
Xiang Fu
Starysn
05/30/2025, 3:35 AMXiang Fu
Xiang Fu
SET timeoutMs=20000;
Select xxxxxStarysn
05/30/2025, 9:25 AMError Code: 427
1 servers [server3_R] not respondedXiang Fu
Starysn
06/02/2025, 1:50 AMERROR [BaseCombineOperator] [query-runner-on-41833-2-thread-92] Caught serious error while processing query: QueryContext{...}
java.lang.OutOfMemoryError: Java heap space
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler
ERROR [OpChainSchedulerService] [query-runner-on-41833-2-thread-91] (OpChain{1690742341000000008_0_2}): Completed erroneously null {200=QueryExecutionError:
java.lang.OutOfMemoryError: Java heap space}Xiang Fu
Xiang Fu
-Xms32G -Xmx32GStarysn
06/03/2025, 1:31 AMdocker-compose.yml. I edit the yml then restart the container, it should've apply the edited yml right?Xiang Fu
ps wuax to check the jvm parametersStarysn
06/03/2025, 2:48 AMXiang Fu
Starysn
06/03/2025, 4:31 AMERROR [BaseCombineOperator] [pqr-64] Timed out while polling results block, numBlocksMerged: 33 (query: QueryContext{_tableName='c_orderline_REALTIME', _subquery=null, _selectExpressions=[a_asset_id, ad_client_id, ad_org_id, ad_orgtrx_id, alasandiskonest, altquantity2, c_activity_id, c_bpartner_id, c_bpartner_location_id, c_campaign_id, c_charge_id, c_currency_id, c_order_id, c_orderline_id, c_orderline_uu, c_project_id, c_projectphase_id, c_projecttask_id, c_tax_id, c_uom_id, completerealisasi, created, createdby, createproduction, createshipment, datedelivered, dateinvoiced, dateordered, datepromised, description, discount, discountamt, discountamtest, discounttype, freightamt, gl_account_id, grade, isactive, isdescription, line, linenetamt, link_orderline_id, m_attributesetinstance_id, m_product_id, m_promotion_id, m_shipper_id, m_warehouse_id, pp_cost_collector_id, ppnincluded, priceactual, pricecost, priceentered, pricelimit, pricelist, processed, qtydelivered, qtyentered, qtyinvoiced, qtylostsales, qtyordered, qtyreserved, recordTimestamp, ref_orderline_id, rramt, rrstartdate, s_resourceassignment_id, second_lowest_price, updated, updatedby, user1_id, user2_id, vendorcategory, z_abw_est, z_abw_real, z_age, z_alasan_mundur, z_diskon_per_kg, z_grade_telur, z_harga_estimasi, z_harga_pricelist_est, z_harga_realisasi, z_hargapasar, z_hargapasarrealisasi, z_kondisi, z_lokasi, z_pricelist_estimasi, z_qty_ekor_est, z_qty_ekor_real, z_qty_kg_est, z_qty_kg_real, z_sapprice, z_savings, z_tbl_alasandiskon_id, z_umur_ayam, z_week_ayam], _distinct=false, _aliasList=[null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null], _filter=null, _groupByExpressions=null, _havingFilter=null, _orderByExpressions=null, _limit=16800000, _offset=0, _queryOptions={serverReturnFinalResult=true, timeoutMs=10000}, _expressionOverrideHints={}, _explain=NONE})
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "pqw-62"
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "pqw-70"
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "pqw-100"
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "ParticipantHealthReportTimerTask"
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "pqw-80"
Exception in thread "ad_org__0__1__20250530T0513Z" java.lang.OutOfMemoryError: Java heap space
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "pqw-59"
Exception in thread "ad_orginfo__0__1__20250530T0515Z" java.lang.OutOfMemoryError: Java heap space
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "pqw-83"
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "pqw-82"
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "pool-26-thread-1"
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "pqw-121"
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "pqw-107"
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "ad_orgtype__0__1__20250530T0415Z"
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "c_orderline__0__61__20250602T2030Z"
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "grizzly-nio-kernel(38) SelectorRunner"
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "grizzly-nio-kernel(1) SelectorRunner"
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "Start a Pinot [SERVER]-SendThread(zookeeper:2181)"
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "metrics-meter-tick-thread-2"
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "grizzly-http-server-40"
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "metrics-meter-tick-thread-1"Xiang Fu
Xiang Fu
Xiang Fu
Starysn
06/03/2025, 6:32 AMXiang Fu
select * from table order by xxx, limit 1Starysn
06/03/2025, 7:15 AMXiang Fu
Starysn
06/03/2025, 7:20 AMXiang Fu
Starysn
06/04/2025, 1:43 AM