Optimizing PgBench for CockroachDB Section 3

pgbench (16.1 (Debian 16.1-1.pgdg120+1), server 13.0.0)
pgbench: caution: scale possibility overlooked, the use of depend from pgbench_branches desk (10)
pgbench: consumer 5 were given an error in command 8 (SQL) of script 0; ERROR:  restart transaction: TransactionRetryWithProtoRefreshError: WriteTooOldError: write for key /Desk/110/5/5/0 at timestamp 1701374364.725565161,1 too previous; will have to write at or above 1701374364.783286327,1: "sql txn" meta={identity=fe1456c4 key=/Desk/109/5/569793/0 iso=Serializable pri=0.00522733 epo=0 ts=1701374364.783286327,1 min=1701374364.518938744,0 seq=2} lock=true stat=PENDING rts=1701374364.725565161,1 wto=false gul=1701374365.018938744,0
HINT:  See: https://www.cockroachlabs.com/medical doctors/v23.2/transaction-retry-error-reference.html
pgbench: consumer 5 repeats the transaction after the mistake (take a look at 1/3)
pgbench: consumer 4 were given an error in command 8 (SQL) of script 0; ERROR:  restart transaction: TransactionRetryWithProtoRefreshError: WriteTooOldError: write for key /Desk/110/5/3/0 at timestamp 1701374364.881843744,1 too previous; will have to write at or above 1701374364.902487702,1: "sql txn" meta={identity=1eb035c5 key=/Desk/109/5/110840/0 iso=Serializable pri=0.00276957 epo=0 ts=1701374364.902487702,1 min=1701374364.803162244,0 seq=2} lock=true stat=PENDING rts=1701374364.881843744,1 wto=false gul=1701374365.303162244,0
HINT:  See: https://www.cockroachlabs.com/medical doctors/v23.2/transaction-retry-error-reference.html
pgbench: consumer 4 repeats the transaction after the mistake (take a look at 1/3)
pgbench: consumer 6 were given an error in command 8 (SQL) of script 0; ERROR:  restart transaction: TransactionRetryWithProtoRefreshError: WriteTooOldError: write for key /Desk/110/5/1/0 at timestamp 1701374365.916704036,1 too previous; will have to write at or above 1701374365.933405161,1: "sql txn" meta={identity=cf8b382e key=/Desk/109/5/279511/0 iso=Serializable pri=0.00573224 epo=0 ts=1701374365.933405161,1 min=1701374365.839919870,0 seq=2} lock=true stat=PENDING rts=1701374365.916704036,1 wto=false gul=1701374366.339919870,0
HINT:  See: https://www.cockroachlabs.com/medical doctors/v23.2/transaction-retry-error-reference.html
pgbench: consumer 6 repeats the transaction after the mistake (take a look at 1/3)
pgbench: consumer 3 were given an error in command 8 (SQL) of script 0; ERROR:  restart transaction: TransactionRetryWithProtoRefreshError: WriteTooOldError: write for key /Desk/110/5/9/0 at timestamp 1701374367.028168703,1 too previous; will have to write at or above 1701374367.082025953,1: "sql txn" meta={identity=b37541b7 key=/Desk/109/5/43919/0 iso=Serializable pri=0.01583132 epo=0 ts=1701374367.082025953,1 min=1701374366.918740453,0 seq=2} lock=true stat=PENDING rts=1701374367.028168703,1 wto=false gul=1701374367.418740453,0
HINT:  See: https://www.cockroachlabs.com/medical doctors/v23.2/transaction-retry-error-reference.html
pgbench: consumer 3 repeats the transaction after the mistake (take a look at 1/3)
growth: 5.0 s, 238.8 tps, lat 33.228 ms stddev 23.762, 0 failed, 4 retried, 4 retries
pgbench: consumer 1 were given an error in command 8 (SQL) of script 0; ERROR:  restart transaction: TransactionRetryWithProtoRefreshError: WriteTooOldError: write for key /Desk/110/5/7/0 at timestamp 1701374371.162224122,1 too previous; will have to write at or above 1701374371.200365997,1: "sql txn" meta={identity=9b00388b key=/Desk/109/5/173940/0 iso=Serializable pri=0.01393375 epo=0 ts=1701374371.200365997,1 min=1701374370.906479830,0 seq=2} lock=true stat=PENDING rts=1701374371.162224122,1 wto=false gul=1701374371.406479830,0
HINT:  See: https://www.cockroachlabs.com/medical doctors/v23.2/transaction-retry-error-reference.html
pgbench: consumer 1 repeats the transaction after the mistake (take a look at 1/3)
pgbench: consumer 2 were given an error in command 8 (SQL) of script 0; ERROR:  restart transaction: TransactionRetryWithProtoRefreshError: WriteTooOldError: write for key /Desk/110/5/7/0 at timestamp 1701374371.200365997,1 too previous; will have to write at or above 1701374371.221628122,1: "sql txn" meta={identity=cecdb1ab key=/Desk/109/5/548267/0 iso=Serializable pri=0.00346401 epo=0 ts=1701374371.221628122,1 min=1701374370.973058997,0 seq=2} lock=true stat=PENDING rts=1701374371.200365997,1 wto=false gul=1701374371.473058997,0
HINT:  See: https://www.cockroachlabs.com/medical doctors/v23.2/transaction-retry-error-reference.html
pgbench: consumer 2 repeats the transaction after the mistake (take a look at 1/3)
pgbench: consumer 1 were given an error in command 8 (SQL) of script 0; ERROR:  restart transaction: TransactionRetryWithProtoRefreshError: WriteTooOldError: write for key /Desk/110/5/7/0 at timestamp 1701374371.308297414,2 too previous; will have to write at or above 1701374371.385186164,1: "sql txn" meta={identity=98bf761d key=/Desk/109/5/173940/0 iso=Serializable pri=0.00580461 epo=0 ts=1701374371.385186164,1 min=1701374371.234436747,0 seq=2} lock=true stat=PENDING rts=1701374371.308297414,2 wto=false gul=1701374371.734436747,0
HINT:  See: https://www.cockroachlabs.com/medical doctors/v23.2/transaction-retry-error-reference.html
pgbench: consumer 1 repeats the transaction after the mistake (take a look at 2/3)
pgbench: consumer 4 were given an error in command 8 (SQL) of script 0; ERROR:  restart transaction: TransactionRetryWithProtoRefreshError: WriteTooOldError: write for key /Desk/110/5/3/0 at timestamp 1701374373.132044165,1 too previous; will have to write at or above 1701374373.157914498,1: "sql txn" meta={identity=8def4300 key=/Desk/109/5/477477/0 iso=Serializable pri=0.00196323 epo=0 ts=1701374373.157914498,1 min=1701374373.001536956,0 seq=2} lock=true stat=PENDING rts=1701374373.132044165,1 wto=false gul=1701374373.501536956,0
HINT:  See: https://www.cockroachlabs.com/medical doctors/v23.2/transaction-retry-error-reference.html
pgbench: consumer 4 repeats the transaction after the mistake (take a look at 1/3)
growth: 10.0 s, 225.6 tps, lat 35.522 ms stddev 30.196, 0 failed, 3 retried, 4 retries
growth: 15.0 s, 238.0 tps, lat 33.552 ms stddev 20.915, 0 failed, 0 retried, 0 retries
pgbench: consumer 3 were given an error in command 8 (SQL) of script 0; ERROR:  restart transaction: TransactionRetryWithProtoRefreshError: WriteTooOldError: write for key /Desk/110/5/6/0 at timestamp 1701374380.138378168,2 too previous; will have to write at or above 1701374380.184955710,1: "sql txn" meta={identity=c6ab1fec key=/Desk/109/5/796957/0 iso=Serializable pri=0.00219624 epo=0 ts=1701374380.184955710,1 min=1701374379.949286210,0 seq=2} lock=true stat=PENDING rts=1701374380.138378168,2 wto=false gul=1701374380.449286210,0
HINT:  See: https://www.cockroachlabs.com/medical doctors/v23.2/transaction-retry-error-reference.html
pgbench: consumer 3 repeats the transaction after the mistake (take a look at 1/3)
pgbench: consumer 4 were given an error in command 8 (SQL) of script 0; ERROR:  restart transaction: TransactionRetryWithProtoRefreshError: WriteTooOldError: write for key /Desk/110/5/9/0 at timestamp 1701374381.532448085,1 too previous; will have to write at or above 1701374381.532448085,2: "sql txn" meta={identity=ab78ff5d key=/Desk/109/5/129631/0 iso=Serializable pri=0.02671145 epo=0 ts=1701374381.532448085,2 min=1701374381.403506460,0 seq=2} lock=true stat=PENDING rts=1701374381.532448085,1 wto=false gul=1701374381.903506460,0
HINT:  See: https://www.cockroachlabs.com/medical doctors/v23.2/transaction-retry-error-reference.html
pgbench: consumer 4 repeats the transaction after the mistake (take a look at 1/3)
pgbench: consumer 7 were given an error in command 8 (SQL) of script 0; ERROR:  restart transaction: TransactionRetryWithProtoRefreshError: WriteTooOldError: write for key /Desk/110/5/10/0 at timestamp 1701374381.970990086,1 too previous; will have to write at or above 1701374382.002286294,1: "sql txn" meta={identity=a3720795 key=/Desk/109/5/796844/0 iso=Serializable pri=0.01176172 epo=0 ts=1701374382.002286294,1 min=1701374381.842546002,0 seq=2} lock=true stat=PENDING rts=1701374381.970990086,1 wto=false gul=1701374382.342546002,0
HINT:  See: https://www.cockroachlabs.com/medical doctors/v23.2/transaction-retry-error-reference.html
pgbench: consumer 7 repeats the transaction after the mistake (take a look at 1/3)
growth: 20.0 s, 215.8 tps, lat 36.918 ms stddev 26.072, 0 failed, 3 retried, 3 retries
growth: 25.0 s, 216.2 tps, lat 37.140 ms stddev 25.942, 0 failed, 0 retried, 0 retries
pgbench: consumer 1 were given an error in command 8 (SQL) of script 0; ERROR:  restart transaction: TransactionRetryWithProtoRefreshError: WriteTooOldError: write for key /Desk/110/5/9/0 at timestamp 1701374390.624237798,1 too previous; will have to write at or above 1701374390.675212798,1: "sql txn" meta={identity=1e77e781 key=/Desk/109/5/487347/0 iso=Serializable pri=0.01765513 epo=0 ts=1701374390.675212798,1 min=1701374390.436830756,0 seq=2} lock=true stat=PENDING rts=1701374390.624237798,1 wto=false gul=1701374390.936830756,0
HINT:  See: https://www.cockroachlabs.com/medical doctors/v23.2/transaction-retry-error-reference.html
pgbench: consumer 1 repeats the transaction after the mistake (take a look at 1/3)
pgbench: consumer 3 were given an error in command 8 (SQL) of script 0; ERROR:  restart transaction: TransactionRetryWithProtoRefreshError: WriteTooOldError: write for key /Desk/110/5/10/0 at timestamp 1701374391.884443715,1 too previous; will have to write at or above 1701374391.909561465,1: "sql txn" meta={identity=1c27478f key=/Desk/109/5/424569/0 iso=Serializable pri=0.03662449 epo=0 ts=1701374391.909561465,1 min=1701374391.702494549,0 seq=2} lock=true stat=PENDING rts=1701374391.884443715,1 wto=false gul=1701374392.202494549,0
HINT:  See: https://www.cockroachlabs.com/medical doctors/v23.2/transaction-retry-error-reference.html
pgbench: consumer 3 repeats the transaction after the mistake (take a look at 1/3)
pgbench: consumer 7 were given an error in command 8 (SQL) of script 0; ERROR:  restart transaction: TransactionRetryWithProtoRefreshError: WriteTooOldError: write for key /Desk/110/5/3/0 at timestamp 1701374393.572487549,1 too previous; will have to write at or above 1701374393.572487549,2: "sql txn" meta={identity=fdacfb83 key=/Desk/109/5/730699/0 iso=Serializable pri=0.03673262 epo=0 ts=1701374393.572487549,2 min=1701374393.376278716,0 seq=2} lock=true stat=PENDING rts=1701374393.572487549,1 wto=false gul=1701374393.876278716,0
HINT:  See: https://www.cockroachlabs.com/medical doctors/v23.2/transaction-retry-error-reference.html
pgbench: consumer 7 repeats the transaction after the mistake (take a look at 1/3)
growth: 30.0 s, 209.0 tps, lat 38.151 ms stddev 31.989, 0 failed, 3 retried, 3 retries
growth: 35.0 s, 195.0 tps, lat 40.949 ms stddev 28.077, 0 failed, 0 retried, 0 retries
pgbench: consumer 1 were given an error in command 8 (SQL) of script 0; ERROR:  restart transaction: TransactionRetryWithProtoRefreshError: WriteTooOldError: write for key /Desk/110/5/4/0 at timestamp 1701374399.887792969,1 too previous; will have to write at or above 1701374399.911607302,1: "sql txn" meta={identity=855e0eca key=/Desk/109/5/165844/0 iso=Serializable pri=0.01764135 epo=0 ts=1701374399.911607302,1 min=1701374399.542153677,0 seq=2} lock=true stat=PENDING rts=1701374399.887792969,1 wto=false gul=1701374400.042153677,0
HINT:  See: https://www.cockroachlabs.com/medical doctors/v23.2/transaction-retry-error-reference.html
pgbench: consumer 1 repeats the transaction after the mistake (take a look at 1/3)
growth: 40.0 s, 145.6 tps, lat 54.621 ms stddev 38.881, 0 failed, 1 retried, 1 retries
pgbench: consumer 2 were given an error in command 8 (SQL) of script 0; ERROR:  restart transaction: TransactionRetryWithProtoRefreshError: WriteTooOldError: write for key /Desk/110/5/2/0 at timestamp 1701374408.252897556,1 too previous; will have to write at or above 1701374408.252897556,2: "sql txn" meta={identity=3c1d5707 key=/Desk/109/5/271506/0 iso=Serializable pri=0.00554444 epo=0 ts=1701374408.252897556,2 min=1701374408.060554931,0 seq=2} lock=true stat=PENDING rts=1701374408.252897556,1 wto=false gul=1701374408.560554931,0
HINT:  See: https://www.cockroachlabs.com/medical doctors/v23.2/transaction-retry-error-reference.html
pgbench: consumer 2 repeats the transaction after the mistake (take a look at 1/3)
growth: 45.0 s, 204.8 tps, lat 39.241 ms stddev 36.493, 0 failed, 1 retried, 1 retries
pgbench: consumer 3 were given an error in command 8 (SQL) of script 0; ERROR:  restart transaction: TransactionRetryWithProtoRefreshError: WriteTooOldError: write for key /Desk/110/5/2/0 at timestamp 1701374413.178464892,1 too previous; will have to write at or above 1701374413.221088309,1: "sql txn" meta={identity=f1f5cf8b key=/Desk/109/5/382061/0 iso=Serializable pri=0.00426220 epo=0 ts=1701374413.221088309,1 min=1701374413.072555142,0 seq=2} lock=true stat=PENDING rts=1701374413.178464892,1 wto=false gul=1701374413.572555142,0
HINT:  See: https://www.cockroachlabs.com/medical doctors/v23.2/transaction-retry-error-reference.html
pgbench: consumer 3 repeats the transaction after the mistake (take a look at 1/3)
growth: 50.0 s, 227.0 tps, lat 35.512 ms stddev 26.517, 0 failed, 1 retried, 1 retries
pgbench: consumer 4 were given an error in command 8 (SQL) of script 0; ERROR:  restart transaction: TransactionRetryWithProtoRefreshError: WriteTooOldError: write for key /Desk/110/5/9/0 at timestamp 1701374417.439743852,1 too previous; will have to write at or above 1701374417.512724644,1: "sql txn" meta={identity=ceae42c3 key=/Desk/109/5/647391/0 iso=Serializable pri=0.00061239 epo=0 ts=1701374417.512724644,1 min=1701374417.170008102,0 seq=2} lock=true stat=PENDING rts=1701374417.439743852,1 wto=false gul=1701374417.670008102,0
HINT:  See: https://www.cockroachlabs.com/medical doctors/v23.2/transaction-retry-error-reference.html
pgbench: consumer 4 repeats the transaction after the mistake (take a look at 1/3)
pgbench: consumer 5 were given an error in command 8 (SQL) of script 0; ERROR:  restart transaction: TransactionRetryWithProtoRefreshError: WriteTooOldError: write for key /Desk/110/5/9/0 at timestamp 1701374417.557735311,1 too previous; will have to write at or above 1701374417.583758061,1: "sql txn" meta={identity=921ad19c key=/Desk/109/5/292793/0 iso=Serializable pri=0.01234524 epo=0 ts=1701374417.583758061,1 min=1701374417.337672519,0 seq=2} lock=true stat=PENDING rts=1701374417.557735311,1 wto=false gul=1701374417.837672519,0
HINT:  See: https://www.cockroachlabs.com/medical doctors/v23.2/transaction-retry-error-reference.html
pgbench: consumer 5 repeats the transaction after the mistake (take a look at 1/3)
growth: 55.0 s, 227.2 tps, lat 35.162 ms stddev 26.932, 0 failed, 2 retried, 2 retries
pgbench: consumer 3 were given an error in command 8 (SQL) of script 0; ERROR:  restart transaction: TransactionRetryWithProtoRefreshError: WriteTooOldError: write for key /Desk/110/5/9/0 at timestamp 1701374420.093249854,1 too previous; will have to write at or above 1701374420.125789020,1: "sql txn" meta={identity=254d2603 key=/Desk/109/5/924387/0 iso=Serializable pri=0.01254729 epo=0 ts=1701374420.125789020,1 min=1701374419.940787687,0 seq=2} lock=true stat=PENDING rts=1701374420.093249854,1 wto=false gul=1701374420.440787687,0
HINT:  See: https://www.cockroachlabs.com/medical doctors/v23.2/transaction-retry-error-reference.html
pgbench: consumer 3 repeats the transaction after the mistake (take a look at 1/3)
pgbench: consumer 2 were given an error in command 8 (SQL) of script 0; ERROR:  restart transaction: TransactionRetryWithProtoRefreshError: WriteTooOldError: write for key /Desk/110/5/2/0 at timestamp 1701374421.256457729,1 too previous; will have to write at or above 1701374421.285648938,1: "sql txn" meta={identity=8a6584e6 key=/Desk/109/5/931266/0 iso=Serializable pri=0.00333353 epo=0 ts=1701374421.285648938,1 min=1701374421.081633729,0 seq=2} lock=true stat=PENDING rts=1701374421.256457729,1 wto=false gul=1701374421.581633729,0
HINT:  See: https://www.cockroachlabs.com/medical doctors/v23.2/transaction-retry-error-reference.html
pgbench: consumer 2 repeats the transaction after the mistake (take a look at 1/3)
growth: 60.0 s, 232.0 tps, lat 34.473 ms stddev 23.692, 0 failed, 2 retried, 2 retries
transaction kind: <builtin: TPC-B (type of)>
scaling issue: 10
question mode: easy
collection of purchasers: 8
collection of threads: 8
most collection of tries: 3
length: 60 s
collection of transactions in reality processed: 12883
collection of failed transactions: 0 (0.000%)
collection of serialization disasters: 0 (0.000%)
collection of impasse disasters: 0 (0.000%)
collection of transactions retried: 20 (0.155%)
overall collection of retries: 21
latency moderate = 37.261 ms
latency stddev = 28.630 ms
preliminary connection time = 22.223 ms
tps = 214.593890 (with out preliminary connection time)

You May Also Like

More From Author

+ There are no comments

Add yours