You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This situation occurred when I was using trino. Could you help me locate the problem?The following is the abnormal information of trino: 2022-11-01T07:37:18.504272214Z 2022-11-01T07:37:18.503Z ERROR SplitRunner-10-6234 io.trino.execution.executor.TaskExecutor Error processing Split 20221101_073501_01866_g7bbg.2.0.0-0 io.trino.plugin.jdbc.JdbcSplit@66ff90ef (start = 1.316493972043099E9, wall = 114698 ms, cpu = 2186 ms, wait = 90850 ms, calls = 20): JDBC_ERROR: Error retrieving record: Unexpected Exception: javax.net.ssl.SSLException message given: Tag mismatch! 2022-11-01T07:37:18.504338159Z 2022-11-01T07:37:18.504360551Z Nested Stack Trace: 2022-11-01T07:37:18.504363647Z 2022-11-01T07:37:18.504365350Z 2022-11-01T07:37:18.504367044Z ** BEGIN NESTED EXCEPTION ** 2022-11-01T07:37:18.504368787Z 2022-11-01T07:37:18.504370470Z javax.net.ssl.SSLException 2022-11-01T07:37:18.504372244Z MESSAGE: Tag mismatch! 2022-11-01T07:37:18.504373917Z 2022-11-01T07:37:18.504375590Z STACKTRACE: 2022-11-01T07:37:18.504377263Z 2022-11-01T07:37:18.504378866Z javax.net.ssl.SSLException: Tag mismatch! 2022-11-01T07:37:18.504380619Z at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:133) 2022-11-01T07:37:18.504382513Z at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:371) 2022-11-01T07:37:18.504384276Z at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:314) 2022-11-01T07:37:18.504386010Z at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:309) 2022-11-01T07:37:18.504387743Z at java.base/sun.security.ssl.SSLTransport.decode(SSLTransport.java:123) 2022-11-01T07:37:18.504389476Z at java.base/sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1508) 2022-11-01T07:37:18.504391220Z at java.base/sun.security.ssl.SSLSocketImpl.readApplicationRecord(SSLSocketImpl.java:1479) 2022-11-01T07:37:18.504392983Z at java.base/sun.security.ssl.SSLSocketImpl$AppInputStream.read(SSLSocketImpl.java:1064) 2022-11-01T07:37:18.504394746Z at java.base/java.io.FilterInputStream.read(FilterInputStream.java:132) 2022-11-01T07:37:18.504396480Z at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64) 2022-11-01T07:37:18.504398233Z at com.mysql.cj.protocol.a.SimplePacketReader.readMessage(SimplePacketReader.java:108) 2022-11-01T07:37:18.504399976Z at com.mysql.cj.protocol.a.SimplePacketReader.readMessage(SimplePacketReader.java:45) 2022-11-01T07:37:18.504401729Z at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readMessage(TimeTrackingPacketReader.java:57) 2022-11-01T07:37:18.504403503Z at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readMessage(TimeTrackingPacketReader.java:41) 2022-11-01T07:37:18.504406268Z at com.mysql.cj.protocol.a.MultiPacketReader.readMessage(MultiPacketReader.java:61) 2022-11-01T07:37:18.504408001Z at com.mysql.cj.protocol.a.MultiPacketReader.readMessage(MultiPacketReader.java:44) 2022-11-01T07:37:18.504409805Z at com.mysql.cj.protocol.a.ResultsetRowReader.read(ResultsetRowReader.java:75) 2022-11-01T07:37:18.504412790Z at com.mysql.cj.protocol.a.ResultsetRowReader.read(ResultsetRowReader.java:42) 2022-11-01T07:37:18.504416998Z at com.mysql.cj.protocol.a.NativeProtocol.read(NativeProtocol.java:1583) 2022-11-01T07:37:18.504418772Z at com.mysql.cj.protocol.a.result.ResultsetRowsStreaming.next(ResultsetRowsStreaming.java:193) 2022-11-01T07:37:18.504420525Z at com.mysql.cj.protocol.a.result.ResultsetRowsStreaming.next(ResultsetRowsStreaming.java:62) 2022-11-01T07:37:18.504422349Z at com.mysql.cj.jdbc.result.ResultSetImpl.next(ResultSetImpl.java:1738) 2022-11-01T07:37:18.504424092Z at io.trino.plugin.jdbc.JdbcRecordCursor.advanceNextPosition(JdbcRecordCursor.java:176) 2022-11-01T07:37:18.504425895Z at io.trino.$gen.CursorProcessor_20221101_064459_256.process(Unknown Source) 2022-11-01T07:37:18.504427639Z at io.trino.operator.ScanFilterAndProjectOperator$RecordCursorToPages.process(ScanFilterAndProjectOperator.java:348) 2022-11-01T07:37:18.504429442Z at io.trino.operator.WorkProcessorUtils$ProcessWorkProcessor.process(WorkProcessorUtils.java:391) 2022-11-01T07:37:18.504431205Z at io.trino.operator.WorkProcessorUtils.getNextState(WorkProcessorUtils.java:240) 2022-11-01T07:37:18.504432959Z at io.trino.operator.WorkProcessorUtils$YieldingProcess.process(WorkProcessorUtils.java:182) 2022-11-01T07:37:18.504434732Z at io.trino.operator.WorkProcessorUtils$ProcessWorkProcessor.process(WorkProcessorUtils.java:391) 2022-11-01T07:37:18.504436495Z at io.trino.operator.WorkProcessorUtils$3.process(WorkProcessorUtils.java:325) 2022-11-01T07:37:18.504438249Z at io.trino.operator.WorkProcessorUtils$ProcessWorkProcessor.process(WorkProcessorUtils.java:391) 2022-11-01T07:37:18.504440022Z at io.trino.operator.WorkProcessorUtils.lambda$flatten$7(WorkProcessorUtils.java:296) 2022-11-01T07:37:18.504441765Z at io.trino.operator.WorkProcessorUtils$3.process(WorkProcessorUtils.java:338) 2022-11-01T07:37:18.504443509Z at io.trino.operator.WorkProcessorUtils$ProcessWorkProcessor.process(WorkProcessorUtils.java:391) 2022-11-01T07:37:18.504445332Z at io.trino.operator.WorkProcessorUtils$3.process(WorkProcessorUtils.java:325) 2022-11-01T07:37:18.504447096Z at io.trino.operator.WorkProcessorUtils$ProcessWorkProcessor.process(WorkProcessorUtils.java:391) 2022-11-01T07:37:18.504448849Z at io.trino.operator.WorkProcessorUtils.getNextState(WorkProcessorUtils.java:240) 2022-11-01T07:37:18.504450602Z at io.trino.operator.WorkProcessorUtils.lambda$processStateMonitor$3(WorkProcessorUtils.java:219) 2022-11-01T07:37:18.504452366Z at io.trino.operator.WorkProcessorUtils$ProcessWorkProcessor.process(WorkProcessorUtils.java:391) 2022-11-01T07:37:18.504454129Z at io.trino.operator.WorkProcessorUtils.getNextState(WorkProcessorUtils.java:240) 2022-11-01T07:37:18.504456012Z at io.trino.operator.WorkProcessorUtils.lambda$finishWhen$4(WorkProcessorUtils.java:234) 2022-11-01T07:37:18.504457776Z at io.trino.operator.WorkProcessorUtils$ProcessWorkProcessor.process(WorkProcessorUtils.java:391) 2022-11-01T07:37:18.504459549Z at io.trino.operator.WorkProcessorSourceOperatorAdapter.getOutput(WorkProcessorSourceOperatorAdapter.java:150) 2022-11-01T07:37:18.504462906Z at io.trino.operator.Driver.processInternal(Driver.java:411) 2022-11-01T07:37:18.504464679Z at io.trino.operator.Driver.lambda$process$10(Driver.java:314) 2022-11-01T07:37:18.504466402Z at io.trino.operator.Driver.tryWithLock(Driver.java:706) 2022-11-01T07:37:18.504468115Z at io.trino.operator.Driver.process(Driver.java:306) 2022-11-01T07:37:18.504469829Z at io.trino.operator.Driver.processForDuration(Driver.java:277) 2022-11-01T07:37:18.504471562Z at io.trino.execution.SqlTaskExecution$DriverSplitRunner.processFor(SqlTaskExecution.java:736) 2022-11-01T07:37:18.504473335Z at io.trino.execution.executor.PrioritizedSplitRunner.process(PrioritizedSplitRunner.java:164) 2022-11-01T07:37:18.504475099Z at io.trino.execution.executor.TaskExecutor$TaskRunner.run(TaskExecutor.java:515) 2022-11-01T07:37:18.504476862Z at io.trino.$gen.Trino_400____20221101_063251_2.run(Unknown Source) 2022-11-01T07:37:18.504478595Z at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) 2022-11-01T07:37:18.504480349Z at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) 2022-11-01T07:37:18.504482112Z at java.base/java.lang.Thread.run(Thread.java:833) 2022-11-01T07:37:18.504483815Z Caused by: javax.crypto.AEADBadTagException: Tag mismatch! 2022-11-01T07:37:18.504485528Z at java.base/com.sun.crypto.provider.GaloisCounterMode$GCMDecrypt.doFinal(GaloisCounterMode.java:1486) 2022-11-01T07:37:18.504487312Z at java.base/com.sun.crypto.provider.GaloisCounterMode.engineDoFinal(GaloisCounterMode.java:447) 2022-11-01T07:37:18.504489125Z at java.base/javax.crypto.Cipher.doFinal(Cipher.java:2500) 2022-11-01T07:37:18.504490828Z at java.base/sun.security.ssl.SSLCipher$T12GcmReadCipherGenerator$GcmReadCipher.decrypt(SSLCipher.java:1659) 2022-11-01T07:37:18.504492662Z at java.base/sun.security.ssl.SSLSocketInputRecord.decodeInputRecord(SSLSocketInputRecord.java:260) 2022-11-01T07:37:18.504494475Z at java.base/sun.security.ssl.SSLSocketInputRecord.decode(SSLSocketInputRecord.java:181) 2022-11-01T07:37:18.504496229Z at java.base/sun.security.ssl.SSLTransport.decode(SSLTransport.java:111) 2022-11-01T07:37:18.504497982Z ... 50 more 2022-11-01T07:37:18.504499645Z 2022-11-01T07:37:18.504501258Z 2022-11-01T07:37:18.504502871Z ** END NESTED EXCEPTION **
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
This situation occurred when I was using trino. Could you help me locate the problem?The following is the abnormal information of trino:
2022-11-01T07:37:18.504272214Z 2022-11-01T07:37:18.503Z ERROR SplitRunner-10-6234 io.trino.execution.executor.TaskExecutor Error processing Split 20221101_073501_01866_g7bbg.2.0.0-0 io.trino.plugin.jdbc.JdbcSplit@66ff90ef (start = 1.316493972043099E9, wall = 114698 ms, cpu = 2186 ms, wait = 90850 ms, calls = 20): JDBC_ERROR: Error retrieving record: Unexpected Exception: javax.net.ssl.SSLException message given: Tag mismatch! 2022-11-01T07:37:18.504338159Z 2022-11-01T07:37:18.504360551Z Nested Stack Trace: 2022-11-01T07:37:18.504363647Z 2022-11-01T07:37:18.504365350Z 2022-11-01T07:37:18.504367044Z ** BEGIN NESTED EXCEPTION ** 2022-11-01T07:37:18.504368787Z 2022-11-01T07:37:18.504370470Z javax.net.ssl.SSLException 2022-11-01T07:37:18.504372244Z MESSAGE: Tag mismatch! 2022-11-01T07:37:18.504373917Z 2022-11-01T07:37:18.504375590Z STACKTRACE: 2022-11-01T07:37:18.504377263Z 2022-11-01T07:37:18.504378866Z javax.net.ssl.SSLException: Tag mismatch! 2022-11-01T07:37:18.504380619Z at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:133) 2022-11-01T07:37:18.504382513Z at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:371) 2022-11-01T07:37:18.504384276Z at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:314) 2022-11-01T07:37:18.504386010Z at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:309) 2022-11-01T07:37:18.504387743Z at java.base/sun.security.ssl.SSLTransport.decode(SSLTransport.java:123) 2022-11-01T07:37:18.504389476Z at java.base/sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1508) 2022-11-01T07:37:18.504391220Z at java.base/sun.security.ssl.SSLSocketImpl.readApplicationRecord(SSLSocketImpl.java:1479) 2022-11-01T07:37:18.504392983Z at java.base/sun.security.ssl.SSLSocketImpl$AppInputStream.read(SSLSocketImpl.java:1064) 2022-11-01T07:37:18.504394746Z at java.base/java.io.FilterInputStream.read(FilterInputStream.java:132) 2022-11-01T07:37:18.504396480Z at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64) 2022-11-01T07:37:18.504398233Z at com.mysql.cj.protocol.a.SimplePacketReader.readMessage(SimplePacketReader.java:108) 2022-11-01T07:37:18.504399976Z at com.mysql.cj.protocol.a.SimplePacketReader.readMessage(SimplePacketReader.java:45) 2022-11-01T07:37:18.504401729Z at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readMessage(TimeTrackingPacketReader.java:57) 2022-11-01T07:37:18.504403503Z at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readMessage(TimeTrackingPacketReader.java:41) 2022-11-01T07:37:18.504406268Z at com.mysql.cj.protocol.a.MultiPacketReader.readMessage(MultiPacketReader.java:61) 2022-11-01T07:37:18.504408001Z at com.mysql.cj.protocol.a.MultiPacketReader.readMessage(MultiPacketReader.java:44) 2022-11-01T07:37:18.504409805Z at com.mysql.cj.protocol.a.ResultsetRowReader.read(ResultsetRowReader.java:75) 2022-11-01T07:37:18.504412790Z at com.mysql.cj.protocol.a.ResultsetRowReader.read(ResultsetRowReader.java:42) 2022-11-01T07:37:18.504416998Z at com.mysql.cj.protocol.a.NativeProtocol.read(NativeProtocol.java:1583) 2022-11-01T07:37:18.504418772Z at com.mysql.cj.protocol.a.result.ResultsetRowsStreaming.next(ResultsetRowsStreaming.java:193) 2022-11-01T07:37:18.504420525Z at com.mysql.cj.protocol.a.result.ResultsetRowsStreaming.next(ResultsetRowsStreaming.java:62) 2022-11-01T07:37:18.504422349Z at com.mysql.cj.jdbc.result.ResultSetImpl.next(ResultSetImpl.java:1738) 2022-11-01T07:37:18.504424092Z at io.trino.plugin.jdbc.JdbcRecordCursor.advanceNextPosition(JdbcRecordCursor.java:176) 2022-11-01T07:37:18.504425895Z at io.trino.$gen.CursorProcessor_20221101_064459_256.process(Unknown Source) 2022-11-01T07:37:18.504427639Z at io.trino.operator.ScanFilterAndProjectOperator$RecordCursorToPages.process(ScanFilterAndProjectOperator.java:348) 2022-11-01T07:37:18.504429442Z at io.trino.operator.WorkProcessorUtils$ProcessWorkProcessor.process(WorkProcessorUtils.java:391) 2022-11-01T07:37:18.504431205Z at io.trino.operator.WorkProcessorUtils.getNextState(WorkProcessorUtils.java:240) 2022-11-01T07:37:18.504432959Z at io.trino.operator.WorkProcessorUtils$YieldingProcess.process(WorkProcessorUtils.java:182) 2022-11-01T07:37:18.504434732Z at io.trino.operator.WorkProcessorUtils$ProcessWorkProcessor.process(WorkProcessorUtils.java:391) 2022-11-01T07:37:18.504436495Z at io.trino.operator.WorkProcessorUtils$3.process(WorkProcessorUtils.java:325) 2022-11-01T07:37:18.504438249Z at io.trino.operator.WorkProcessorUtils$ProcessWorkProcessor.process(WorkProcessorUtils.java:391) 2022-11-01T07:37:18.504440022Z at io.trino.operator.WorkProcessorUtils.lambda$flatten$7(WorkProcessorUtils.java:296) 2022-11-01T07:37:18.504441765Z at io.trino.operator.WorkProcessorUtils$3.process(WorkProcessorUtils.java:338) 2022-11-01T07:37:18.504443509Z at io.trino.operator.WorkProcessorUtils$ProcessWorkProcessor.process(WorkProcessorUtils.java:391) 2022-11-01T07:37:18.504445332Z at io.trino.operator.WorkProcessorUtils$3.process(WorkProcessorUtils.java:325) 2022-11-01T07:37:18.504447096Z at io.trino.operator.WorkProcessorUtils$ProcessWorkProcessor.process(WorkProcessorUtils.java:391) 2022-11-01T07:37:18.504448849Z at io.trino.operator.WorkProcessorUtils.getNextState(WorkProcessorUtils.java:240) 2022-11-01T07:37:18.504450602Z at io.trino.operator.WorkProcessorUtils.lambda$processStateMonitor$3(WorkProcessorUtils.java:219) 2022-11-01T07:37:18.504452366Z at io.trino.operator.WorkProcessorUtils$ProcessWorkProcessor.process(WorkProcessorUtils.java:391) 2022-11-01T07:37:18.504454129Z at io.trino.operator.WorkProcessorUtils.getNextState(WorkProcessorUtils.java:240) 2022-11-01T07:37:18.504456012Z at io.trino.operator.WorkProcessorUtils.lambda$finishWhen$4(WorkProcessorUtils.java:234) 2022-11-01T07:37:18.504457776Z at io.trino.operator.WorkProcessorUtils$ProcessWorkProcessor.process(WorkProcessorUtils.java:391) 2022-11-01T07:37:18.504459549Z at io.trino.operator.WorkProcessorSourceOperatorAdapter.getOutput(WorkProcessorSourceOperatorAdapter.java:150) 2022-11-01T07:37:18.504462906Z at io.trino.operator.Driver.processInternal(Driver.java:411) 2022-11-01T07:37:18.504464679Z at io.trino.operator.Driver.lambda$process$10(Driver.java:314) 2022-11-01T07:37:18.504466402Z at io.trino.operator.Driver.tryWithLock(Driver.java:706) 2022-11-01T07:37:18.504468115Z at io.trino.operator.Driver.process(Driver.java:306) 2022-11-01T07:37:18.504469829Z at io.trino.operator.Driver.processForDuration(Driver.java:277) 2022-11-01T07:37:18.504471562Z at io.trino.execution.SqlTaskExecution$DriverSplitRunner.processFor(SqlTaskExecution.java:736) 2022-11-01T07:37:18.504473335Z at io.trino.execution.executor.PrioritizedSplitRunner.process(PrioritizedSplitRunner.java:164) 2022-11-01T07:37:18.504475099Z at io.trino.execution.executor.TaskExecutor$TaskRunner.run(TaskExecutor.java:515) 2022-11-01T07:37:18.504476862Z at io.trino.$gen.Trino_400____20221101_063251_2.run(Unknown Source) 2022-11-01T07:37:18.504478595Z at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) 2022-11-01T07:37:18.504480349Z at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) 2022-11-01T07:37:18.504482112Z at java.base/java.lang.Thread.run(Thread.java:833) 2022-11-01T07:37:18.504483815Z Caused by: javax.crypto.AEADBadTagException: Tag mismatch! 2022-11-01T07:37:18.504485528Z at java.base/com.sun.crypto.provider.GaloisCounterMode$GCMDecrypt.doFinal(GaloisCounterMode.java:1486) 2022-11-01T07:37:18.504487312Z at java.base/com.sun.crypto.provider.GaloisCounterMode.engineDoFinal(GaloisCounterMode.java:447) 2022-11-01T07:37:18.504489125Z at java.base/javax.crypto.Cipher.doFinal(Cipher.java:2500) 2022-11-01T07:37:18.504490828Z at java.base/sun.security.ssl.SSLCipher$T12GcmReadCipherGenerator$GcmReadCipher.decrypt(SSLCipher.java:1659) 2022-11-01T07:37:18.504492662Z at java.base/sun.security.ssl.SSLSocketInputRecord.decodeInputRecord(SSLSocketInputRecord.java:260) 2022-11-01T07:37:18.504494475Z at java.base/sun.security.ssl.SSLSocketInputRecord.decode(SSLSocketInputRecord.java:181) 2022-11-01T07:37:18.504496229Z at java.base/sun.security.ssl.SSLTransport.decode(SSLTransport.java:111) 2022-11-01T07:37:18.504497982Z ... 50 more 2022-11-01T07:37:18.504499645Z 2022-11-01T07:37:18.504501258Z 2022-11-01T07:37:18.504502871Z ** END NESTED EXCEPTION **
Here is the sql I executed:
insert into cdh_hive.stg_test.stg_chmed_aged_health_di select yin_defic_score, yin_defic_result, yin_chmedguide_desc, yin_chmedguide_code, yang_defic_score, yang_defic_result, yang_chmedguide_desc, yang_chmedguide_code, uuid, subvein_bruis_code, spirits_down_code, speak_unable_code, sleep_snor_code, skin_score_code, skin_eczema_code, skin_dry_code, shit_viscosity_code, shit_dry_code, qista_defic_score, qista_defic_result, qista_chmedguide_desc, qista_chmedguide_code, qi_defic_score, qi_defic_result, qi_chmedguide_desc, qi_chmedguide_code, psy_nervous_code, phr_id, phldam_defic_score, phldam_defic_result, phldam_chmedguide_desc, phldam_chmedguide_code, peaceful_defic_score, peaceful_defic_result, peaceful_chmedguide_desc, peaceful_chmedguide_code, oneself_name, mouth_dry_code, mouth_bitter_code, limb_numbness_code, life_lonely_code, last_update_dtime, intrin_defic_score, intrin_defic_result, intrin_chmedguide_desc, intrin_chmedguide_code, heavy_body_code, handsfeets_cold_code, fur_thick_code, fill_in_dtime, face_greasy_code, face_brownplaq_code, eatcold_unwell_code, easily_urtica_code, easily_tired_code, easily_runnose_code, easily_fear_code, easily_cold_code, easily_allergy_code, dry_eyes_code, dr_sgntr, delete_mark, daheat_defic_score, daheat_defic_result, daheat_chmedguide_desc, daheat_chmedguide_code, chmed_agedhealth_no, breath_short_code, body_cold_code, bloodsta_defic_score, bloodsta_defic_result, bloodsta_chmedguide_desc, bloodsta_chmedguide_code, befull_ofgo_code, bear_cold_code, appear_subhemo_code, abdo_hypertro_code, patient_uuid, format_datetime(biz_date,'yyyy-MM-dd 00:00:00') as biz_date, 'cs123456' as org_code from mysql_sz.platform_cd.chmed_aged_health where biz_date = date_parse('2022-11-01 00:00:00','%Y-%m-%d 00:00:00')
Beta Was this translation helpful? Give feedback.
All reactions