alibaba / alibaba/wasp

入库的同时,查询报错,无法获取返回的数据

Open
#16 9 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
191
Forks
78
PR merge metrics
No merged PRs in 30d

Description

13/08/12 15:17:59 INFO jdbc.JdbcConnection: Connection conn = DriverManager.getConnection("jdbc:wasp:", "", "");
13/08/12 15:17:59 INFO zookeeper.ZooKeeper: Client environment:zookeeper.version=3.4.5-1392090, built on 09/30/2012 17:52 GMT
13/08/12 15:17:59 INFO zookeeper.ZooKeeper: Client environment:host.name=cstor
13/08/12 15:17:59 INFO zookeeper.ZooKeeper: Client environment:java.version=1.7.0_02
13/08/12 15:17:59 INFO zookeeper.ZooKeeper: Client environment:java.vendor=Oracle Corporation
13/08/12 15:17:59 INFO zookeeper.ZooKeeper: Client environment:java.home=C:\Program Files\Java\jre7
13/08/12 15:17:59 INFO zookeeper.ZooKeeper: Client environment:java.class.path=C:\Users\cstor\workspace\wasp-test\bin;C:\Users\cstor\workspace\wasp-test\lib\activation-1.1.jar;C:\Users\cstor\workspace\wasp-test\lib\aopalliance-1.0.jar;C:\Users\cstor\workspace\wasp-test\lib\asm-3.1.jar;C:\Users\cstor\workspace\wasp-test\lib\avro-1.5.3.jar;C:\Users\cstor\workspace\wasp-test\lib\avro-ipc-1.5.3.jar;C:\Users\cstor\workspace\wasp-test\lib\commons-beanutils-1.7.0.jar;C:\Users\cstor\workspace\wasp-test\lib\commons-beanutils-core-1.8.0.jar;C:\Users\cstor\workspace\wasp-test\lib\commons-cli-1.2.jar;C:\Users\cstor\workspace\wasp-test\lib\commons-codec-1.7.jar;C:\Users\cstor\workspace\wasp-test\lib\commons-collections-3.2.1.jar;C:\Users\cstor\workspace\wasp-test\lib\commons-configuration-1.6.jar;C:\Users\cstor\workspace\wasp-test\lib\commons-digester-1.8.jar;C:\Users\cstor\workspace\wasp-test\lib\commons-el-1.0.jar;C:\Users\cstor\workspace\wasp-test\lib\commons-httpclient-3.0.1.jar;C:\Users\cstor\workspace\wasp-test\lib\commons-io-2.4.jar;C:\Users\cstor\workspace\wasp-test\lib\commons-lang-2.6.jar;C:\Users\cstor\workspace\wasp-test\lib\commons-logging-1.1.1.jar;C:\Users\cstor\workspace\wasp-test\lib\commons-math-2.1.jar;C:\Users\cstor\workspace\wasp-test\lib\commons-net-1.4.1.jar;C:\Users\cstor\workspace\wasp-test\lib\core-3.1.1.jar;C:\Users\cstor\workspace\wasp-test\lib\druid-0.2.9.jar;C:\Users\cstor\workspace\wasp-test\lib\ftplet-api-1.0.0.jar;C:\Users\cstor\workspace\wasp-test\lib\ftpserver-core-1.0.0.jar;C:\Users\cstor\workspace\wasp-test\lib\ftpserver-deprecated-1.0.0-M2.jar;C:\Users\cstor\workspace\wasp-test\lib\guava-12.0.1.jar;C:\Users\cstor\workspace\wasp-test\lib\hadoop-core-1.0.3.jar;C:\Users\cstor\workspace\wasp-test\lib\hadoop-test-1.0.3.jar;C:\Users\cstor\workspace\wasp-test\lib\hamcrest-core-1.1.jar;C:\Users\cstor\workspace\wasp-test\lib\hbase-0.94.1-tests.jar;C:\Users\cstor\workspace\wasp-test\lib\hbase-0.94.1.jar;C:\Users\cstor\workspace\wasp-test\lib\high-scale-lib-1.1.1.jar;C:\Users\cstor\workspace\wasp-test\lib\hsqldb-1.8.0.10.jar;C:\Users\cstor\workspace\wasp-test\lib\htrace-1.49.jar;C:\Users\cstor\workspace\wasp-test\lib\httpclient-4.1.2.jar;C:\Users\cstor\workspace\wasp-test\lib\httpcore-4.1.3.jar;C:\Users\cstor\workspace\wasp-test\lib\jackson-core-asl-1.8.8.jar;C:\Users\cstor\workspace\wasp-test\lib\jackson-jaxrs-1.8.8.jar;C:\Users\cstor\workspace\wasp-test\lib\jackson-mapper-asl-1.8.8.jar;C:\Users\cstor\workspace\wasp-test\lib\jackson-xc-1.8.8.jar;C:\Users\cstor\workspace\wasp-test\lib\jamon-runtime-2.3.1.jar;C:\Users\cstor\workspace\wasp-test\lib\jasper-compiler-5.5.23.jar;C:\Users\cstor\workspace\wasp-test\lib\jasper-runtime-5.5.23.jar;C:\Users\cstor\workspace\wasp-test\lib\jaxb-api-2.1.jar;C:\Users\cstor\workspace\wasp-test\lib\jaxb-impl-2.2.3-1.jar;C:\Users\cstor\workspace\wasp-test\lib\jersey-core-1.8.jar;C:\Users\cstor\workspace\wasp-test\lib\jersey-json-1.8.jar;C:\Users\cstor\workspace\wasp-test\lib\jersey-server-1.8.jar;C:\Users\cstor\workspace\wasp-test\lib\jets3t-0.7.1.jar;C:\Users\cstor\workspace\wasp-test\lib\jettison-1.3.1.jar;C:\Users\cstor\workspace\wasp-test\lib\jetty-6.1.26.jar;C:\Users\cstor\workspace\wasp-test\lib\jetty-util-6.1.26.jar;C:\Users\cstor\workspace\wasp-test\lib\jruby-complete-1.6.8.jar;C:\Users\cstor\workspace\wasp-test\lib\jsp-2.1-6.1.14.jar;C:\Users\cstor\workspace\wasp-test\lib\jsp-api-2.1-6.1.14.jar;C:\Users\cstor\workspace\wasp-test\lib\jsr305-1.3.9.jar;C:\Users\cstor\workspace\wasp-test\lib\junit-4.10.jar;C:\Users\cstor\workspace\wasp-test\lib\kfs-0.3.jar;C:\Users\cstor\workspace\wasp-test\lib\libthrift-0.8.0.jar;C:\Users\cstor\workspace\wasp-test\lib\log4j-1.2.17.jar;C:\Users\cstor\workspace\wasp-test\lib\metrics-core-2.1.2.jar;C:\Users\cstor\workspace\wasp-test\lib\mina-core-2.0.0-M5.jar;C:\Users\cstor\workspace\wasp-test\lib\mockito-all-1.9.0.jar;C:\Users\cstor\workspace\wasp-test\lib\netty-3.2.4.Final.jar;C:\Users\cstor\workspace\wasp-test\lib\netty-3.5.0.Final.jar;C:\Users\cstor\workspace\wasp-test\lib\oro-2.0.8.jar;C:\Users\cstor\workspace\wasp-test\lib\protobuf-java-2.4.1.jar;C:\Users\cstor\workspace\wasp-test\lib\protobuf-java-format-1.2.jar;C:\Users\cstor\workspace\wasp-test\lib\protobuf-rpc-pro-demo-2.0.1.jar;C:\Users\cstor\workspace\wasp-test\lib\protobuf-rpc-pro-duplex-2.0.1.jar;C:\Users\cstor\workspace\wasp-test\lib\protobuf-streamer-pro-1.2.3.jar;C:\Users\cstor\workspace\wasp-test\lib\servlet-api-2.5-6.1.14.jar;C:\Users\cstor\workspace\wasp-test\lib\slf4j-api-1.4.3.jar;C:\Users\cstor\workspace\wasp-test\lib\slf4j-log4j12-1.4.3.jar;C:\Users\cstor\workspace\wasp-test\lib\snappy-java-1.0.3.2.jar;C:\Users\cstor\workspace\wasp-test\lib\spring-aop-3.0.5.RELEASE.jar;C:\Users\cstor\workspace\wasp-test\lib\spring-asm-3.0.5.RELEASE.jar;C:\Users\cstor\workspace\wasp-test\lib\spring-beans-3.0.5.RELEASE.jar;C:\Users\cstor\workspace\wasp-test\lib\spring-context-3.0.5.RELEASE.jar;C:\Users\cstor\workspace\wasp-test\lib\spring-core-3.0.5.RELEASE.jar;C:\Users\cstor\workspace\wasp-test\lib\spring-expression-3.0.5.RELEASE.jar;C:\Users\cstor\workspace\wasp-test\lib\stax-api-1.0.1.jar;C:\Users\cstor\workspace\wasp-test\lib\velocity-1.7.jar;C:\Users\cstor\workspace\wasp-test\lib\wasp-0.10.jar;C:\Users\cstor\workspace\wasp-test\lib\xmlenc-0.52.jar;C:\Users\cstor\workspace\wasp-test\lib\zookeeper-3.4.5.jar
13/08/12 15:17:59 INFO zookeeper.ZooKeeper: Client environment:java.library.path=C:\Program Files\Java\jre7\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\MinGW\bin;C:\Program Files (x86)\Git\bin;C:\tools\apache-maven-3.0.5\bin;C:\Program Files (x86)\Common Files\NetSarang;C:\Program Files (x86)\AMD APP\bin\x86_64;C:\Program Files (x86)\AMD APP\bin\x86;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files (x86)\Common Files\Ulead Systems\MPEG;C:\Program Files\Common Files\Lenovo;C:\SWTOOLS\ReadyApps;C:\Program Files (x86)\Intel\Services\IPT\;C:\Program Files (x86)\Common Files\Lenovo;C:\Program Files\TortoiseSVN\bin;C:\Program Files\MySQL\MySQL Server 5.5\bin;C:\Program Files (x86)\VisualSVN\bin;C:\Program Files (x86)\QuickTime\QTSystem\;.
13/08/12 15:17:59 INFO zookeeper.ZooKeeper: Client environment:java.io.tmpdir=C:\Users\cstor\AppData\Local\Temp\
13/08/12 15:17:59 INFO zookeeper.ZooKeeper: Client environment:java.compiler=
13/08/12 15:17:59 INFO zookeeper.ZooKeeper: Client environment:os.name=Windows 7
13/08/12 15:17:59 INFO zookeeper.ZooKeeper: Client environment:os.arch=amd64
13/08/12 15:17:59 INFO zookeeper.ZooKeeper: Client environment:os.version=6.1
13/08/12 15:17:59 INFO zookeeper.ZooKeeper: Client environment:user.name=cstor
13/08/12 15:17:59 INFO zookeeper.ZooKeeper: Client environment:user.home=C:\Users\cstor
13/08/12 15:17:59 INFO zookeeper.ZooKeeper: Client environment:user.dir=C:\Users\cstor\workspace\wasp-test
13/08/12 15:18:00 INFO zookeeper.ZooKeeper: Initiating client connection, connectString=192.168.6.154:2181,192.168.6.152:2181,192.168.6.156:2181,192.168.6.155:2181 sessionTimeout=180000 watcher=fclient:
13/08/12 15:18:00 INFO zookeeper.RecoverableZooKeeper: The identifier of this process is 7276@cstor
13/08/12 15:18:00 INFO zookeeper.ClientCnxn: Opening socket connection to server hx3/192.168.6.154:2181. Will not attempt to authenticate using SASL (unknown error)
13/08/12 15:18:00 INFO zookeeper.ClientCnxn: Socket connection established to hx3/192.168.6.154:2181, initiating session
13/08/12 15:18:00 INFO zookeeper.ClientCnxn: Session establishment complete on server hx3/192.168.6.154:2181, sessionid = 0x2407115b72e0022, negotiated timeout = 180000
1111
13/08/12 15:18:00 INFO ipc.NettyTransceiver: Successfully connected to bookie: hx2/192.168.6.156:50501
13/08/12 15:18:00 INFO client.FClientCallable: withRetries attempt 0 of 10 failed; retrying after sleep of 1000
13/08/12 15:18:01 INFO ipc.NettyTransceiver: Successfully connected to bookie: hx8/192.168.6.158:50501
13/08/12 15:18:02 INFO client.FClientCallable: withRetries attempt 1 of 10 failed; retrying after sleep of 1000
13/08/12 15:18:03 INFO client.FClientCallable: withRetries attempt 2 of 10 failed; retrying after sleep of 1000
13/08/12 15:18:04 INFO ipc.NettyTransceiver: Successfully connected to bookie: hx3/192.168.6.154:50501
13/08/12 15:18:04 INFO client.FClientCallable: withRetries attempt 3 of 10 failed; retrying after sleep of 2000
13/08/12 15:18:06 INFO client.FClientCallable: withRetries attempt 4 of 10 failed; retrying after sleep of 2000
13/08/12 15:18:08 INFO ipc.NettyTransceiver: Successfully connected to bookie: hx5/192.168.6.155:50501
13/08/12 15:18:08 INFO client.FClientCallable: withRetries attempt 5 of 10 failed; retrying after sleep of 4000
13/08/12 15:18:12 INFO client.FClientCallable: withRetries attempt 6 of 10 failed; retrying after sleep of 4000
13/08/12 15:18:16 INFO client.FClientCallable: withRetries attempt 7 of 10 failed; retrying after sleep of 8000
13/08/12 15:18:24 INFO client.FClientCallable: withRetries attempt 8 of 10 failed; retrying after sleep of 16000
13/08/12 15:18:40 INFO client.FClientCallable: withRetries attempt 9 of 10 failed; retrying after sleep of 32000
13/08/12 15:19:12 ERROR result.ResultRemote: FClinet execute sql error
com.alibaba.wasp.client.RetriesExhaustedException: Failed after attempts=10, exceptions:
Mon Aug 12 15:18:00 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:02 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:03 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:04 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:06 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:08 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:12 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:16 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:24 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:40 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException

```
at com.alibaba.wasp.client.ServerCallable.withRetries(ServerCallable.java:181)
at com.alibaba.wasp.client.FClient.execute(FClient.java:104)
at com.alibaba.wasp.jdbc.result.ResultRemote.fetchRows(ResultRemote.java:228)
at com.alibaba.wasp.jdbc.result.ResultRemote.(ResultRemote.java:89)
at com.alibaba.wasp.jdbc.command.CommandRemote.executeQuery(CommandRemote.java:119)
at com.alibaba.wasp.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:91)
at com.Select.main(Select.java:32)
```

Exception in thread "main" java.lang.RuntimeException: com.alibaba.wasp.client.RetriesExhaustedException: Failed after attempts=10, exceptions:
Mon Aug 12 15:18:00 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:02 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:03 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:04 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:06 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:08 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:12 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:16 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:24 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:40 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException

```
at com.alibaba.wasp.jdbc.result.ResultRemote.fetchRows(ResultRemote.java:243)
at com.alibaba.wasp.jdbc.result.ResultRemote.(ResultRemote.java:89)
at com.alibaba.wasp.jdbc.command.CommandRemote.executeQuery(CommandRemote.java:119)
at com.alibaba.wasp.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:91)
at com.Select.main(Select.java:32)
```

Caused by: com.alibaba.wasp.client.RetriesExhaustedException: Failed after attempts=10, exceptions:
Mon Aug 12 15:18:00 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:02 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:03 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:04 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:06 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:08 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:12 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:16 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:24 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException
Mon Aug 12 15:18:40 CST 2013, com.alibaba.wasp.client.FClientCallable@437ef115, java.io.IOException: java.lang.NullPointerException

```
at com.alibaba.wasp.client.ServerCallable.withRetries(ServerCallable.java:181)
at com.alibaba.wasp.client.FClient.execute(FClient.java:104)
at com.alibaba.wasp.jdbc.result.ResultRemote.fetchRows(ResultRemote.java:228)
... 4 more
```

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with Select.main at line 32 and reproduce the query immediately after insertion. Trace the failing path through ResultRemote.fetchRows, CommandRemote.executeQuery, FClient.execute, and ServerCallable.withRetries, focusing on the reported NullPointerException. Done means the query returns its data without exhausting retries.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
databases, distributed-systems
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.