kudu-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Wolf <nickwo...@gmail.com>
Subject Query failures in KUDU
Date Thu, 28 Jan 2016 22:24:48 GMT
Hi KUDU Team,

We have been experimenting KUDU for a while and noticing inserts and
selects are failing intermittently with following JDBC exception.

java.sql.SQLException: [Simba][ImpalaJDBCDriver](500051) ERROR processing
> query/statement. Error Code: ERROR_STATE, SQL state: null, Query: insert
> into temp select * from delta_table;.
> at com.cloudera.hivecommon.api.HS2Client.executeStatementInternal(Unknown
> Source)
> at com.cloudera.hivecommon.api.HS2Client.executeStatement(Unknown Source)
> at
> com.cloudera.hivecommon.dataengine.HiveJDBCNativeQueryExecutor.execute(Unknown
> Source)
> at com.cloudera.jdbc.common.SStatement.executeNoParams(Unknown Source)
> at com.cloudera.jdbc.common.SStatement.executeUpdate(Unknown Source)
> at weblogic.jdbc.wrapper.Statement.executeUpdate(Statement.java:530)
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
> at java.util.concurrent.FutureTask.run(FutureTask.java:138)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> Caused by: com.cloudera.support.exceptions.GeneralException:
> [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error
> Code: ERROR_STATE, SQL state: null, Query: insert into temp select * from
> delta_table; ... 14 more
> ... 14 more



We have observed following warnings in KUDU logs which seems to be too
technical for users. Can someone determine what is going on?

W0126 11:29:01.108304 13392 log.cc:514] Time spent Append to log took a
> long time: real 0.053s user 0.000s sys 0.000s
> W0126 13:07:31.910331  8271 env_posix.cc:820] Time spent sync call for
> /var/lib/kudu/tserver/data/8c053de02f844f8fbbea0509cc7cc1d5.data: real
> 1.053s user 0.001s sys 0.000s
> W0126 13:10:48.706079 44714 log.cc:514] Time spent Append to log took a
> long time: real 0.071s user 0.000s sys 0.000s
> W0126 13:10:48.706204  9916 log.cc:514] Time spent Append to log took a
> long time: real 0.072s user 0.000s sys 0.000s
> W0126 13:19:57.760201 44563 log.cc:514] Time spent Append to log took a
> long time: real 0.083s user 0.000s sys 0.000s
> W0127 10:06:04.007073 8271 compaction.cc:712] Found REINSERT REDO
> truncating row history for Source Row: (string
> pk=84220108ac17201b390b5b7ea23b86a4, string PARENT_NAME=PARENT00001, int32
> LEVEL_ID=NULL, double value=NULL) Redo Mutations: [@5955247507797458944(SET
> value=0), @5955247517553405952(SET value=0), @5955247518720282624(SET
> LEVEL_ID=0), @5955247628213231616(DELETE), @5955247633470758912(REINSERT
> (string pk=84220108ac17201b390b5b7ea23b86a4, string
> PARENT_NAME=PARENT00001, int32 LEVEL_ID=NULL, double value=NULL)),
> @5955247649014562816(SET value=0), @5955247658627330048(SET LEVEL_ID=0)]
> Undo Mutations: [@5955247497295126528(DELETE)]
> Dest Row: (string pk=84220108ac17201b390b5b7ea23b86a4, string
> PARENT_NAME=PARENT00001, int32 LEVEL_ID=NULL, double value=NULL) Redo
> Mutations: [] Undo Mutations: [@5955247633470758912(DELETE)] Note: this
> warning will appear only for the first truncated row
> W0127 10:06:04.007308 8271 compaction.cc:832] Total 10 rows lost some
> history due to REINSERT after DELETE

Mime
View raw message