project-tsurugi / tsubakuro Goto Github PK

View Code? Open in Web Editor NEW

1.0 7.0 1.0 3.58 MB

java communication library for tsurugidb

License: Apache License 2.0

Java 95.19% CMake 0.16% C++ 4.66%

database-access-library java tsurugidb

tsubakuro's People

Contributors

Stargazers

Watchers

Forkers

mackey0225

tsubakuro's Issues

Backupを廃止し、BackupDetailに統一する

https://github.com/project-tsurugi/tsubakuro/blob/master/modules/session/src/main/java/com/tsurugidb/tsubakuro/datastore/Backup.java
を廃止し、
https://github.com/project-tsurugi/tsubakuro/blob/master/modules/session/src/main/java/com/tsurugidb/tsubakuro/datastore/BackupDetail.java
に統一する。
https://github.com/project-tsurugi/belayer
の対応が必要

unknown code mapping: UNRECOGNIZED

Tsubakuroの実行時に、以下のワーニングが表示されます。今のところ実動作上は問題になっていません。

[WARN] SqlServiceCode - unknown code mapping: com.tsurugidb.jogasaki.proto.StatusProtos$Status.UNRECOGNIZED

SqlServiceException occured when using LoadBuilder#build() with Style.OVERWRITE

SqlServiceException thrown when call loadBuilder.build(sqlClient).await() with Style.OVERWRITE.

Caused by: com.tsurugidb.tsubakuro.sql.SqlServiceException: SQL--0003: parsing statement failed: mismatched input 'OR' expecting IDENTIFIER (<input>:1:7)
    at com.tsurugidb.tsubakuro.sql.impl.SqlServiceStub$StatementPrepareProcessor.process(SqlServiceStub.java:192) ~[tsubakuro-session-0.0.1-SNAPSHOT.jar!/:na]
    at com.tsurugidb.tsubakuro.sql.impl.SqlServiceStub$StatementPrepareProcessor.process(SqlServiceStub.java:180) ~[tsubakuro-session-0.0.1-SNAPSHOT.jar!/:na]
    at com.tsurugidb.tsubakuro.channel.common.connection.wire.MainResponseProcessor$1.process(MainResponseProcessor.java:45) ~[tsubakuro-common-0.0.1-SNAPSHOT.jar!/:na]
    at com.tsurugidb.tsubakuro.channel.common.connection.ForegroundFutureResponse.processResult(ForegroundFutureResponse.java:108) ~[tsubakuro-common-0.0.1-SNAPSHOT.jar!/:na]
    at com.tsurugidb.tsubakuro.channel.common.connection.ForegroundFutureResponse.get(ForegroundFutureResponse.java:57) ~[tsubakuro-common-0.0.1-SNAPSHOT.jar!/:na]
    at com.tsurugidb.tsubakuro.util.MappedFutureResponse.get(MappedFutureResponse.java:52) ~[tsubakuro-common-0.0.1-SNAPSHOT.jar!/:na]
    at com.tsurugidb.tsubakuro.util.FutureResponse.await(FutureResponse.java:93) ~[tsubakuro-common-0.0.1-SNAPSHOT.jar!/:na]
    at com.tsurugidb.belayer.webapi.service.tsubakuro.TsubakuroServiceImpl.loadFile(TsubakuroServiceImpl.java:320) ~[classes!/:na]

The generated query by LoadBuilder#buildQuery is below.

UPDATE OR INSERT INTO demo (pk, col2, col3, col4, col5, cal6, col7) VALUES (:p0_pk, :p1_col2, :p2_col3, :p3_col4, :p4_col5, :p5_cal6, :p6_col7)

The parquet file that used in this case is attached here. demo.zip

This file is created by dump API Transaction#executeDump() in Tsubakuro.
The specified table demo is created by this DDL.

create table demo(pk int primary key, col2 bigint, col3 float, col4 double, col5 char(4), cal6 varchar(10), col7 varchar(3))

受信スレッドを廃止する

foregournd処理がFutureに対してget()しに行ったときにresponseメッセージを取りに行くようにして、受信スレッドを廃止する。

port "add `Session.updateCredential()`."

see https://github.com/project-tsurugi/sandbox-tsubakuro/commit/3e22284fd64055f24d457f72c763e8c1a52d98d5.

BackupDetailImplのclose()やkeepAlive()を実装する

tsubakuro/modules/session/src/main/java/com/tsurugidb/tsubakuro/datastore/impl/BackupDetailImpl.java

Line 145 in 0cb87e9

// FIXME impl

を実装する

PKをupdateすると1レコードに全件分の更新がかかる

from https://nautilus-technologies.app.box.com/file/1041826174057

・PKをupdateすると1レコードに全件分の更新がかかる
DbUpdateTest.updatePK()

Futureのget(long timeout, TimeUnit unit)でtimeoutしない

tateyama-serverがクラッシュした時などで永遠と待ってしまい、CIとして実行する際にはCIジョブがハングアップみたいな動きになってしまうので、timeoutをしかけてCIジョブ自体は完走させたい。

PKをnullにしてinsertしてもエラーにならない

from https://nautilus-technologies.app.box.com/file/1041826174057

・PKをnullにしてinsertしてもエラーにならない
DbInsertErrorTest.insertNullToPK()

port "add `Transction.batch()`."

please see https://github.com/project-tsurugi/sandbox-tsubakuro/commit/28bd2ef4cee4dfe02cee3d5591674fba2977e76c.

SqlServiceException occured when using LoadBuilder#build() with Style.ERROR

SqlServiceException thrown when call loadBuilder.build(sqlClient).await() with Style.ERROR(Simply INSERT mode).

I0927 01:17:11.386144   783 service.cpp:834] load processing file: /usr/lib/tsurugi-webapp/storage/user1/load2/demo.parquet

Caused by: com.tsurugidb.tsubakuro.sql.SqlServiceException: SQL--0010: load failed with the statement position:0 status:err_illegal_operation with message ""
    at com.tsurugidb.tsubakuro.sql.impl.SqlServiceStub$LoadProcessor.process(SqlServiceStub.java:524) ~[tsubakuro-session-0.0.1-SNAPSHOT.jar!/:na]
    at com.tsurugidb.tsubakuro.sql.impl.SqlServiceStub$LoadProcessor.process(SqlServiceStub.java:512) ~[tsubakuro-session-0.0.1-SNAPSHOT.jar!/:na]
    at com.tsurugidb.tsubakuro.channel.common.connection.wire.MainResponseProcessor$1.process(MainResponseProcessor.java:45) ~[tsubakuro-common-0.0.1-SNAPSHOT.jar!/:na]
    at com.tsurugidb.tsubakuro.channel.common.connection.ForegroundFutureResponse.processResult(ForegroundFutureResponse.java:108) ~[tsubakuro-common-0.0.1-SNAPSHOT.jar!/:na]
    at com.tsurugidb.tsubakuro.channel.common.connection.ForegroundFutureResponse.get(ForegroundFutureResponse.java:57) ~[tsubakuro-common-0.0.1-SNAPSHOT.jar!/:na]
    at com.tsurugidb.tsubakuro.util.FutureResponse.await(FutureResponse.java:93) ~[tsubakuro-common-0.0.1-SNAPSHOT.jar!/:na]
    at com.tsurugidb.belayer.webapi.service.tsubakuro.TsubakuroServiceImpl.loadFile(TsubakuroServiceImpl.java:321) ~[classes!/:na]

The generated query by LoadBuilder#buildQuery is below.

INSERT INTO demo (pk, col2, col3, col4, col5, cal6, col7) VALUES (:p0_pk, :p1_col2, :p2_col3, :p3_col4, :p4_col5, :p5_cal6, :p6_col7)

The parquet file that used in this case is attached here. demo.zip

This file is created by dump API Transaction#executeDump() in Tsubakuro.
The specified table demo is created by this DDL.

create table demo(pk int primary key, col2 bigint, col3 float, col4 double, col5 char(4), cal6 varchar(10), col7 varchar(3))

Tsubakuro version: 03cba0447ff8
Tsurugi Docker Image: ghcr.io/project-tsurugi/tsurugi:latest ad5716e4335f

port "add independent auth mechanism."

see https://github.com/project-tsurugi/sandbox-tsubakuro/commit/453b2f054ef1021048e970fa76d5618e287d2261.

`oltp shutdown` がタイムアウトで失敗する

oltp start 実行後、なにかテストケースを実行した後に oltp shutdown を実行すると、以下メッセージが表示されコマンドが失敗(Exit Codeに 1 が変える)します。

failed to shutdown, the server may still be alive

`JSR-305` library should be fetched as `api`.

The following dependency description (in build.gradle) should be api instead of compileOnly.

compileOnly 'com.google.code.findbugs:jsr305:3.0.2'

It will be used in annotation processors via reflection.

PKをnullにupdateできてしまう

from https://nautilus-technologies.app.box.com/file/1041826174057

・PKをnullにupdateできてしまう
DbUpdateErrorTest.updatePKNull()

project-tsurugi / tsubakuro Goto Github PK

tsubakuro's People

Contributors

Stargazers

Watchers

Forkers

tsubakuro's Issues

Recommend Projects

Recommend Topics

Recommend Org