Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bug: Unable to load ycsb bench data after risingwave v0.19.0 #12781

Closed
huangjw806 opened this issue Oct 11, 2023 · 5 comments · Fixed by #12881
Closed

Bug: Unable to load ycsb bench data after risingwave v0.19.0 #12781

huangjw806 opened this issue Oct 11, 2023 · 5 comments · Fixed by #12881
Assignees
Labels
priority/high type/bug Something isn't working
Milestone

Comments

@huangjw806
Copy link
Contributor

huangjw806 commented Oct 11, 2023

YCSB bench load data success v0.18.0:

+ psql --host=benchmark-risingwave-frontend.jianwei-ycsb-test --username=root --port=4567 --dbname=dev '--command=CREATE TABLE usertable (YCSB_KEY TEXT,FIELD0 TEXT, FIELD1 TEXT, FIELD2 TEXT, FIELD3 TEXT,FIELD4 TEXT, FIELD5 TEXT, FIELD6 TEXT, FIELD7 TEXT,FIELD8 TEXT, FIELD9 TEXT,PRIMARY KEY (YCSB_KEY));'
CREATE_TABLE
+ ycsb load jdbc -P workloads/workloada -p db.driver=org.postgresql.Driver -p db.url=jdbc:postgresql://benchmark-risingwave-frontend.jianwei-ycsb-test:4567/dev -p db.user=root -p db.passwd= -p recordcount=1000 -p threadcount=4
/usr/lib/jvm/java-11-openjdk-amd64/bin/java -cp /opt/ycsb/jdbc-binding/conf:/opt/ycsb/conf:/opt/ycsb/lib/jackson-core-asl-1.9.4.jar:/opt/ycsb/lib/htrace-core4-4.1.0-incubating.jar:/opt/ycsb/lib/core-0.18.0-SNAPSHOT.jar:/opt/ycsb/lib/jackson-mapper-asl-1.9.4.jar:/opt/ycsb/lib/HdrHistogram-2.1.4.jar:/opt/ycsb/jdbc-binding/lib/postgresql-42.2.23.jar:/opt/ycsb/jdbc-binding/lib/openjpa-lib-2.1.1.jar:/opt/ycsb/jdbc-binding/lib/jdbc-binding-0.18.0-SNAPSHOT.jar:/opt/ycsb/jdbc-binding/lib/openjpa-jdbc-2.1.1.jar:/opt/ycsb/jdbc-binding/lib/geronimo-jms_1.1_spec-1.1.1.jar:/opt/ycsb/jdbc-binding/lib/commons-collections-3.2.1.jar:/opt/ycsb/jdbc-binding/lib/geronimo-jta_1.1_spec-1.1.1.jar:/opt/ycsb/jdbc-binding/lib/commons-pool-1.5.4.jar:/opt/ycsb/jdbc-binding/lib/commons-lang-2.4.jar:/opt/ycsb/jdbc-binding/lib/openjpa-kernel-2.1.1.jar:/opt/ycsb/jdbc-binding/lib/serp-1.13.1.jar site.ycsb.Client -db site.ycsb.db.JdbcDBClient -P workloads/workloada -p db.driver=org.postgresql.Driver -p db.url=jdbc:postgresql://benchmark-risingwave-frontend.jianwei-ycsb-test:4567/dev -p db.user=root -p db.passwd= -p recordcount=1000 -p threadcount=4 -load
Command line: -db site.ycsb.db.JdbcDBClient -P workloads/workloada -p db.driver=org.postgresql.Driver -p db.url=jdbc:postgresql://benchmark-risingwave-frontend.jianwei-ycsb-test:4567/dev -p db.user=root -p db.passwd= -p recordcount=1000 -p threadcount=4 -load
YCSB Client 0.18.0-SNAPSHOT

Loading workload...
Starting test.
Adding shard node URL: jdbc:postgresql://benchmark-risingwave-frontend.jianwei-ycsb-test:4567/dev
Adding shard node URL: jdbc:postgresql://benchmark-risingwave-frontend.jianwei-ycsb-test:4567/dev
Adding shard node URL: jdbc:postgresql://benchmark-risingwave-frontend.jianwei-ycsb-test:4567/dev
Adding shard node URL: jdbc:postgresql://benchmark-risingwave-frontend.jianwei-ycsb-test:4567/dev
Using shards: 1, batchSize:-1, fetchSize: -1
Using shards: 1, batchSize:-1, fetchSize: -1
Using shards: 1, batchSize:-1, fetchSize: -1
Using shards: 1, batchSize:-1, fetchSize: -1
DBWrapper: report latency for each error is false and specific error codes to track for latency are: []
[OVERALL], RunTime(ms), 374
[OVERALL], Throughput(ops/sec), 2673.7967914438505
[TOTAL_GCS_G1_Young_Generation], Count, 1
[TOTAL_GC_TIME_G1_Young_Generation], Time(ms), 8
[TOTAL_GC_TIME_%_G1_Young_Generation], Time(%), 2.13903743315508
[TOTAL_GCS_G1_Old_Generation], Count, 0
[TOTAL_GC_TIME_G1_Old_Generation], Time(ms), 0
[TOTAL_GC_TIME_%_G1_Old_Generation], Time(%), 0.0
[TOTAL_GCs], Count, 1
[TOTAL_GC_TIME], Time(ms), 8
[TOTAL_GC_TIME_%], Time(%), 2.13903743315508
[CLEANUP], Operations, 4
[CLEANUP], AverageLatency(us), 56.75
[CLEANUP], MinLatency(us), 22
[CLEANUP], MaxLatency(us), 111
[CLEANUP], 95thPercentileLatency(us), 111
[CLEANUP], 99thPercentileLatency(us), 111
[INSERT], Operations, 1000
[INSERT], AverageLatency(us), 995.727
[INSERT], MinLatency(us), 708
[INSERT], MaxLatency(us), 12679
[INSERT], 95thPercentileLatency(us), 1151
[INSERT], 99thPercentileLatency(us), 2229
[INSERT], Return=OK, 1000

YCSB bench load data failed v0.19.0:

+ psql --host=benchmark-risingwave-frontend.jianwei-ycsb-test --username=root --port=4567 --dbname=dev '--command=CREATE TABLE usertable (YCSB_KEY TEXT,FIELD0 TEXT, FIELD1 TEXT, FIELD2 TEXT, FIELD3 TEXT,FIELD4 TEXT, FIELD5 TEXT, FIELD6 TEXT, FIELD7 TEXT,FIELD8 TEXT, FIELD9 TEXT,PRIMARY KEY (YCSB_KEY));'
CREATE_TABLE
+ ycsb load jdbc -P workloads/workloada -p db.driver=org.postgresql.Driver -p db.url=jdbc:postgresql://benchmark-risingwave-frontend.jianwei-ycsb-test:4567/dev -p db.user=root -p db.passwd= -p recordcount=1000 -p threadcount=4
/usr/lib/jvm/java-11-openjdk-amd64/bin/java -cp /opt/ycsb/jdbc-binding/conf:/opt/ycsb/conf:/opt/ycsb/lib/jackson-core-asl-1.9.4.jar:/opt/ycsb/lib/htrace-core4-4.1.0-incubating.jar:/opt/ycsb/lib/core-0.18.0-SNAPSHOT.jar:/opt/ycsb/lib/jackson-mapper-asl-1.9.4.jar:/opt/ycsb/lib/HdrHistogram-2.1.4.jar:/opt/ycsb/jdbc-binding/lib/postgresql-42.2.23.jar:/opt/ycsb/jdbc-binding/lib/openjpa-lib-2.1.1.jar:/opt/ycsb/jdbc-binding/lib/jdbc-binding-0.18.0-SNAPSHOT.jar:/opt/ycsb/jdbc-binding/lib/openjpa-jdbc-2.1.1.jar:/opt/ycsb/jdbc-binding/lib/geronimo-jms_1.1_spec-1.1.1.jar:/opt/ycsb/jdbc-binding/lib/commons-collections-3.2.1.jar:/opt/ycsb/jdbc-binding/lib/geronimo-jta_1.1_spec-1.1.1.jar:/opt/ycsb/jdbc-binding/lib/commons-pool-1.5.4.jar:/opt/ycsb/jdbc-binding/lib/commons-lang-2.4.jar:/opt/ycsb/jdbc-binding/lib/openjpa-kernel-2.1.1.jar:/opt/ycsb/jdbc-binding/lib/serp-1.13.1.jar site.ycsb.Client -db site.ycsb.db.JdbcDBClient -P workloads/workloada -p db.driver=org.postgresql.Driver -p db.url=jdbc:postgresql://benchmark-risingwave-frontend.jianwei-ycsb-test:4567/dev -p db.user=root -p db.passwd= -p recordcount=1000 -p threadcount=4 -load
Command line: -db site.ycsb.db.JdbcDBClient -P workloads/workloada -p db.driver=org.postgresql.Driver -p db.url=jdbc:postgresql://benchmark-risingwave-frontend.jianwei-ycsb-test:4567/dev -p db.user=root -p db.passwd= -p recordcount=1000 -p threadcount=4 -load
YCSB Client 0.18.0-SNAPSHOT

Loading workload...
Starting test.
Adding shard node URL: jdbc:postgresql://benchmark-risingwave-frontend.jianwei-ycsb-test:4567/dev
Adding shard node URL: jdbc:postgresql://benchmark-risingwave-frontend.jianwei-ycsb-test:4567/dev
Adding shard node URL: jdbc:postgresql://benchmark-risingwave-frontend.jianwei-ycsb-test:4567/dev
Adding shard node URL: jdbc:postgresql://benchmark-risingwave-frontend.jianwei-ycsb-test:4567/dev
Using shards: 1, batchSize:-1, fetchSize: -1
Using shards: 1, batchSize:-1, fetchSize: -1
Using shards: 1, batchSize:-1, fetchSize: -1
Using shards: 1, batchSize:-1, fetchSize: -1
DBWrapper: report latency for each error is false and specific error codes to track for latency are: []
Error in processing insert to table: usertableorg.postgresql.util.PSQLException: A result was returned when none was expected.
Error in processing insert to table: usertableorg.postgresql.util.PSQLException: A result was returned when none was expected.
Error in processing insert to table: usertableorg.postgresql.util.PSQLException: A result was returned when none was expected.
Error in processing insert to table: usertableorg.postgresql.util.PSQLException: A result was returned when none was expected.
Error inserting, not retrying any more. number of attempts: 1Insertion Retry Limit: 0
Error inserting, not retrying any more. number of attempts: 1Insertion Retry Limit: 0
Error inserting, not retrying any more. number of attempts: 1Insertion Retry Limit: 0
Error inserting, not retrying any more. number of attempts: 1Insertion Retry Limit: 0
[OVERALL], RunTime(ms), 164
[OVERALL], Throughput(ops/sec), 0.0
[TOTAL_GCS_G1_Young_Generation], Count, 0
[TOTAL_GC_TIME_G1_Young_Generation], Time(ms), 0
[TOTAL_GC_TIME_%_G1_Young_Generation], Time(%), 0.0
[TOTAL_GCS_G1_Old_Generation], Count, 0
[TOTAL_GC_TIME_G1_Old_Generation], Time(ms), 0
[TOTAL_GC_TIME_%_G1_Old_Generation], Time(%), 0.0
[TOTAL_GCs], Count, 0
[TOTAL_GC_TIME], Time(ms), 0
[TOTAL_GC_TIME_%], Time(%), 0.0
[CLEANUP], Operations, 4
[CLEANUP], AverageLatency(us), 162.75
[CLEANUP], MinLatency(us), 83
[CLEANUP], MaxLatency(us), 259
[CLEANUP], 95thPercentileLatency(us), 259
[CLEANUP], 99thPercentileLatency(us), 259
[INSERT], Operations, 0
[INSERT], AverageLatency(us), NaN
[INSERT], MinLatency(us), 9223372036854775807
[INSERT], MaxLatency(us), 0
[INSERT], 95thPercentileLatency(us), 0
[INSERT], 99thPercentileLatency(us), 0
[INSERT], Return=ERROR, 4
[INSERT-FAILED], Operations, 4
[INSERT-FAILED], AverageLatency(us), 30816.0
[INSERT-FAILED], MinLatency(us), 30800
[INSERT-FAILED], MaxLatency(us), 30831
[INSERT-FAILED], 95thPercentileLatency(us), 30831
[INSERT-FAILED], 99thPercentileLatency(us), 30831

Set this issue to high-priority as we are requested to compare performance of batch serving queries with Redis/Cassandra

@github-actions github-actions bot added this to the release-1.4 milestone Oct 11, 2023
@huangjw806
Copy link
Contributor Author

huangjw806 commented Oct 11, 2023

ycsb load command:

ycsb load jdbc -P workloads/workloada -p db.driver=org.postgresql.Driver -p db.url=jdbc:postgresql://benchmark-risingwave-frontend.jianwei-ycsb-test:4567/dev -p db.user=root -p db.passwd= -p recordcount=1000 -p threadcount=4

v0.18.0 insert all records:

dev=> SELECT COUNT(*) from usertable;
 count
-------
  1000
(1 row)

v0.19.0 only insert 4 records:

dev=> SELECT COUNT(*) from usertable;
 count
-------
  4
(1 row)

@huangjw806
Copy link
Contributor Author

huangjw806 commented Oct 11, 2023

It seems that there is a conflict in the insert data on new version. It seems that only the number of records with the same threadcount data can be inserted.

@lmatz lmatz added type/bug Something isn't working priority/high labels Oct 11, 2023
@huangjw806
Copy link
Contributor Author

query.log:

root@benchmark-risingwave-frontend-f-664d6496b6-sn8fn:/# cat query.log
2023-10-16T07:27:58.849544735Z risingwave-main ThreadId(07) mode=(simple query) session=0 status=ok time=26ms sql=CREATE TABLE usertable (YCSB_KEY TEXT,FIELD0 TEXT, FIELD1 TEXT, FIELD2 TEXT, FIELD3 TEXT,FIELD4 TEXT, FIELD5 TEXT, FIELD6 TEXT, FIELD7 TEXT,FIELD8 TEXT, FIELD9 TEXT,PRIMARY KEY (YCSB_KEY));
2023-10-16T07:27:59.098835553Z risingwave-main ThreadId(02) mode=(extended query parse) session=1 status=ok time=0ms sql=SET extra_float_digits = 3
2023-10-16T07:27:59.098835912Z risingwave-main ThreadId(05) mode=(extended query parse) session=2 status=ok time=0ms sql=SET extra_float_digits = 3
2023-10-16T07:27:59.098835916Z risingwave-main ThreadId(06) mode=(extended query parse) session=4 status=ok time=0ms sql=SET extra_float_digits = 3
2023-10-16T07:27:59.098870718Z risingwave-main ThreadId(08) mode=(extended query parse) session=3 status=ok time=0ms sql=SET extra_float_digits = 3
2023-10-16T07:27:59.09897371Z risingwave-main ThreadId(02) mode=(extended query execute) session=1 status=ok time=0ms sql=SET extra_float_digits = 3
2023-10-16T07:27:59.098981454Z risingwave-main ThreadId(06) mode=(extended query execute) session=4 status=ok time=0ms sql=SET extra_float_digits = 3
2023-10-16T07:27:59.098987312Z risingwave-main ThreadId(05) mode=(extended query execute) session=2 status=ok time=0ms sql=SET extra_float_digits = 3
2023-10-16T07:27:59.098992269Z risingwave-main ThreadId(08) mode=(extended query execute) session=3 status=ok time=0ms sql=SET extra_float_digits = 3
2023-10-16T07:27:59.099387764Z risingwave-main ThreadId(05) mode=(extended query parse) session=2 status=ok time=0ms sql=SET application_name = 'PostgreSQL JDBC Driver'
2023-10-16T07:27:59.099395912Z risingwave-main ThreadId(06) mode=(extended query parse) session=1 status=ok time=0ms sql=SET application_name = 'PostgreSQL JDBC Driver'
2023-10-16T07:27:59.099385817Z risingwave-main ThreadId(07) mode=(extended query parse) session=3 status=ok time=0ms sql=SET application_name = 'PostgreSQL JDBC Driver'
2023-10-16T07:27:59.099400293Z risingwave-main ThreadId(02) mode=(extended query parse) session=4 status=ok time=0ms sql=SET application_name = 'PostgreSQL JDBC Driver'
2023-10-16T07:27:59.099444534Z risingwave-main ThreadId(02) mode=(extended query execute) session=4 status=ok time=0ms sql=SET application_name = 'PostgreSQL JDBC Driver'
2023-10-16T07:27:59.099447634Z risingwave-main ThreadId(06) mode=(extended query execute) session=1 status=ok time=0ms sql=SET application_name = 'PostgreSQL JDBC Driver'
2023-10-16T07:27:59.099452677Z risingwave-main ThreadId(05) mode=(extended query execute) session=2 status=ok time=0ms sql=SET application_name = 'PostgreSQL JDBC Driver'
2023-10-16T07:27:59.099479363Z risingwave-main ThreadId(07) mode=(extended query execute) session=3 status=ok time=0ms sql=SET application_name = 'PostgreSQL JDBC Driver'
2023-10-16T07:27:59.141062777Z risingwave-main ThreadId(07) mode=(extended query parse) session=3 status=ok time=0ms sql=INSERT INTO usertable (YCSB_KEY,field1,field0,field7,field6,field9,field8,field3,field2,field5,field4) VALUES($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
2023-10-16T07:27:59.141062837Z risingwave-main ThreadId(02) mode=(extended query parse) session=4 status=ok time=0ms sql=INSERT INTO usertable (YCSB_KEY,field1,field0,field7,field6,field9,field8,field3,field2,field5,field4) VALUES($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
2023-10-16T07:27:59.141063063Z risingwave-main ThreadId(06) mode=(extended query parse) session=2 status=ok time=0ms sql=INSERT INTO usertable (YCSB_KEY,field1,field0,field7,field6,field9,field8,field3,field2,field5,field4) VALUES($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
2023-10-16T07:27:59.141063058Z risingwave-main ThreadId(05) mode=(extended query parse) session=1 status=ok time=0ms sql=INSERT INTO usertable (YCSB_KEY,field1,field0,field7,field6,field9,field8,field3,field2,field5,field4) VALUES($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
2023-10-16T07:27:59.145718207Z risingwave-main ThreadId(02) mode=(extended query execute) session=4 status=ok time=4ms sql=INSERT INTO usertable (YCSB_KEY, field1, field0, field7, field6, field9, field8, field3, field2, field5, field4) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11), params = Some([Some(Utf8("user6284781860667377211")), Some(Utf8("8N5)/4 %((7(59$(4(158<52,&j;-f*A3=_#480%=n2J?(]-/',0Q)-_\u{7f}>Y#+L15_w:Cw#Ig/Mw??&-5<00`06j7-(+.n'3t0I%,")), Some(Utf8("6P#=(8!$j'J9+Bu?%h5Y5(Zy,R/ >4%Xg.E1:1~7F9:;85<r&Eu2O97To+2\"(J?$N':\\5-&$(&~6E9%=`7U7>+6$_5?Ew&'x!,>=")), Some(Utf8("*Z;-X3'.24V}75|/10$%$0C5:Du#G9<:~2\\133d3(8?#*<G=+.v2_w&&r2@w%32=32)?4%#r9B31=p'%*,6|!F{\"-8<Bg3Ca6 <)")), Some(Utf8("(9*$C!6#  [m&-*!S'1., Lu6K+$1\"9+8$H++)(-Nc:+,5>l$2<<Q=(- !J7;@/%28&'n;<:(>445z*.>1E7#>*4V56>n;S/8$f*")), Some(Utf8("2Bq?0n=L}&Xu$2p?)t,7`';p&Rq>Vo<'f.Zg05r&=r'8.<\\q<J?4;n)Hm?':04j#4j>=,(>\";T35Y=!Wa\"-6$6b'Ni9^==$`#Ag>")), Some(Utf8("6.b6W=&4|#7<',`&7.2_)%S/\"?<1I#+Ae3P=53d\"\\o6)d+]=?06( 6.?n:S76Mu7Qm-Xq7\\a?De2H'!\\%-0`,$l&\"f(Fq>R1)E=$")), Some(Utf8("*Cc\"0:!+61>r7041G5-H5,9z!;.(/~/ 25E}%2p3<22%<<\\)-N;(2:,=\" ^%(H35!&;X}*=80...(truncated)
2023-10-16T07:27:59.145762033Z risingwave-main ThreadId(05) mode=(extended query execute) session=3 status=ok time=4ms sql=INSERT INTO usertable (YCSB_KEY, field1, field0, field7, field6, field9, field8, field3, field2, field5, field4) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11), params = Some([Some(Utf8("user8517097267634966620")), Some(Utf8(">(65V=.'~#S)7 `7&$!Q3 Q+(9p'^m=8:-\\a?I+%Vm'\\=8G/:Zo#16'A5$$0,#:1(n>\"~&6z;Io6P}4<|.D%2Tm6A-*C}6$l7A3!")), Some(Utf8("(6j&64,P;5,>;Ao/Ys%O-,3&4R#!L7?A}75f4*|#3~9<61=v?Ok::r+/,)48?N#-V=<84)Qq8%r\"[}-Y+!.|>Kc'Q# N) A{!,b:")), Some(Utf8(",F5-@%)1253h>&n&7,#1 )Dg%2x&#p4<2=R{-+<,-<>&685l!#`3&f 3:,$$ U- ;p0=<!=x4P%4V{%<(([{\"[==D12M98)d5(h7")), Some(Utf8("9&4< $=;j3^7)8d.Du>Va3Lq(:j3?\".[c*0 2_u;$j3$j'Hq!V=<X}:.v*T}!+j*#45Em?L1*I% /\"?]m#Lw?Um#.h?*t;Fw+320")), Some(Utf8("#@;4[a1N=9;:)\"n/Zw*I788:8 `.)v:B+-[1,X-4:j>U!$ ~;Ek.P},%p'#~.0.%U35/z\"0,'[5%J3!;d.H12:t# $'V-$Lk22j.")), Some(Utf8(")0t.Vg*W#4L'4Vo*9r1(&%D%17j&;h0A3 C3+\\\u{7f}*K+-@s3=~8^\u{7f}>P!!/h+H+&Ao./|+2254r$W31Ty,5f7#2;Ks.)|-'2!]\u{7f},R3(")), Some(Utf8("9Uk&\\=;E-,Y->0f\"26=Mq>Y)3\">(*0:Xy>D\u{7f}:Am77<76p>)v&L#!!n4I-0@q/_...(truncated)
2023-10-16T07:27:59.145789318Z risingwave-main ThreadId(02) mode=(extended query execute) session=1 status=ok time=4ms sql=INSERT INTO usertable (YCSB_KEY, field1, field0, field7, field6, field9, field8, field3, field2, field5, field4) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11), params = Some([Some(Utf8("user1820151046732198393")), Some(Utf8("?L)1'\")Ti/Mw/3j3D3-B1!H-.Rg>G5 -(4N!=+n.]#8Oe:'4+M\u{7f}>=j4_'8_y3-l#4r+X/,&\"6O))&.23x+Di:(x.9|;+.=1&70t+")), Some(Utf8(" W=-.`:K'$*b\"3n3Sy)9z*Kc/K7-$|2Hs;I3#+<=4v:Qk;I18? !#281p.-d1 z*245[!= 8!F;5#j,9x'\"~=^'03l*B}3Ui!I!)")), Some(Utf8("(965[m)-|>*\"3':5Qi4&d\"V?),t+C5)-`7Zw.De*2 )9l/3t\"#\"5+v09,8Bq8;v7Sg0.0(\"l+S'0Uw4Mq*((&S9)Ik.8~#Rc5U/=")), Some(Utf8("/8`;#t$)x'<p5\"f&;0>Lc/%~?,$4$>,Nq.0b>8t>=j0S;4Xg4!x+E+\">p.Ai62|'P#),.$=4\"K?0=~\"*0(X-6Ra'9|&4~3O' #(9")), Some(Utf8("5M#4L?%'0(-62*n6F{)P79Z9($:,)l#Nw?Q%0_%!Ta!2l6\\y&D'0,6+-&5F=2'<(6x49 4Pc;Gw7 $/:h6 l?M!(>&;Zo&3.?= 0")), Some(Utf8(">8.1#43)b7I967.%=22&25^i2Ui:Ya))6 D7+?0 Fc&A%$=b=?,59 <X%,#4&Bs&^)$^/)/4;@/-#n$M59:`&_c&Gu$*6)9b), =")), Some(Utf8("7140-b.N{?$| Z{22r';: 2t+=08Q}43d;Lw 5<!'t?W-8P-7> 4Io?%v.$r#9v*M=<R#4A=24`+...(truncated)
2023-10-16T07:27:59.1458087Z risingwave-main ThreadId(05) mode=(extended query execute) session=2 status=ok time=4ms sql=INSERT INTO usertable (YCSB_KEY, field1, field0, field7, field6, field9, field8, field3, field2, field5, field4) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11), params = Some([Some(Utf8("user4052466453699787802")), Some(Utf8(":2n';j>808O? T=0[7>D18/\"+Xu6T)-1 ($*6K))?x!C\u{7f}6>(.(20$v&<r#7:85x6Km$-0%= \"Do+2`-Fs2A7$J=99h/^-0@c2O\u{7f}6")), Some(Utf8("!$\"<Oi;N%9 :>@w'P!;L\u{7f}*%z! 80Ti?):<J9 '6%5v :`'#*1N'(_%1V=-Ok2Fk?Di&J-812$:>0\\o5[5,=p\"!z2/n=Gg;(~ Ym>")), Some(Utf8("248522?E;8P7&/.(:t#Z7$1n;&h7)( +`6E#+8|'Uu(A!4Ow5=~&S9#V11%x6K?%_-5* 8(2<,:$;|;Dq7?.4J'-P+'Ae.)~-@m#")), Some(Utf8("/-t*O}=5x6&>(Qg*Q{0Uw3Wo6T)!1`:)&!?\">(z3S}*X'5J-+;h.*l3I-=A)/S)1;l<<`70d9&p/S?>:4)My,7x*Jk8[s6*>5*2,")), Some(Utf8("+6j#Iy&48 5,0 &55:;S)$Zo-$v*]{(M1-Q?1A1,8:62x/*j-4f35<<Es*#|\"1`#$6 5.15 6)2%:4/3j2+d8,:4A)<V!0R97_=4")), Some(Utf8("6,21\".$2*=?`#>j\"*`<W;!26&A{&N3<R1(H{#_}*Cg!!l\"D++\"l35&>-x>B54K+$.f2),83f-[7<+8;V-(Lq7B/!58$1,%5.:U)%")), Some(Utf8(";Ya7Yg8A14/~ \"v?:.4]{&Fe3,f?V9/60 Ho3-b'Zc*7:(Q;0Ki'Nm+ b+0b7845Bc=4...(truncated)
2023-10-16T07:27:59.230515739Z risingwave-main ThreadId(06) mode=(simple query) session=5 status=ok time=4ms sql=SELECT COUNT(*) from usertable;
2023-10-16T07:27:59.256562317Z risingwave-main ThreadId(02) mode=(simple query) session=6 status=ok time=2ms sql=SELECT * from usertable LIMIT 1;

@chenzl25
Copy link
Contributor

Where did you find v0.19.0 and v0.18.0? It seems the latest version is 0.17.0? https://github.com/brianfrankcooper/YCSB

@huangjw806
Copy link
Contributor Author

Where did you find v0.19.0 and v0.18.0? It seems the latest version is 0.17.0? https://github.com/brianfrankcooper/YCSB

v0.19.0 and v0.18.0 refers to the risingwave version

@huangjw806 huangjw806 changed the title Bug: Unable to load ycsb bench data after version v0.19.0 Bug: Unable to load ycsb bench data after risingwave v0.19.0 Oct 16, 2023
@chenzl25 chenzl25 self-assigned this Oct 16, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
priority/high type/bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants