Comments (5)
[09:53:24] : [Run stress] "ops": [
[09:53:24] : [Run stress] "BEGIN",
[09:53:24] : [Run stress] {
[09:53:24] : [Run stress] "sql": "CREATE TABLE IF NOT EXISTS schema94.table138 (col138_139 TIMETZ NOT NULL, \"c\"\"ol138_140\" GEOGRAPHY NOT NULL, col138_̍141 STRING NOT NULL AS (lower(CAST(\"c\"\"ol138_140\" AS STRING))) STORED, PRIMARY KEY (col138_̍141 DESC, col138_139 ASC), INVERTED INDEX (col138_139 ASC, \"c\"\"ol138_140\" ASC), UNIQUE (col138_139) PARTITION BY LIST (col138_139) (PARTITION \"tabl%v\u000ce.138_part0\" VALUES IN (('06:54:32.117977+12:14':::TIMETZ,), ('13:50:18.124429+07:34':::TIMETZ,), ('08:45:17.345718+14:24':::TIMETZ,), ('00:00:00+15:59':::TIMETZ,), ('12:13:22.488142-04:34':::TIMETZ,), ('07:22:55.511178+10:42':::TIMETZ,), ('12:49:06.86441+13:51':::TIMETZ,), ('08:06:51.205748+14:14':::TIMETZ,), ('06:51:22.237421+11:19':::TIMETZ,), ('19:18:16.099026+11:39':::TIMETZ,)), PARTITION \"tabl%v\u000ce.138_part1\" VALUES IN (('22:01:06.663344+02:07':::TIMETZ,), ('20:21:07.8428-06:30':::TIMETZ,), ('07:48:30.637859-00:06':::TIMETZ,), ('10:51:48.563201-10:24':::TIMETZ,), ('09:00:24.830411-08:35':::TIMETZ,), ('21:29:55.993221+07:50':::TIMETZ,), ('22:01:24.499246-08:38':::TIMETZ,), ('13:45:07.111059+10:16':::TIMETZ,)), PARTITION \" tabl%v\u000ce.138_part2\" VALUES IN (('20:40:24.299015-09:04':::TIMETZ,), ('13:27:55.601432-03:13':::TIMETZ,), ('21:28:06.848321-04:03':::TIMETZ,), ('01:33:38.936892-00:25':::TIMETZ,), ('16:16:02.21742+00:18':::TIMETZ,), ('17:28:13.442698+05:36':::TIMETZ,), ('10:39:41.700359-07:23':::TIMETZ,), ('15:01:05.587797-08:23':::TIMETZ,), ('12:19:11.642014+10:17':::TIMETZ,), ('13:55:39.290238-06:06':::TIMETZ,)), PARTITION \"tabl%v\u000ce.13\\\\u14A98_part3\" VALUES IN (('18:31:23.54022+04:08':::TIMETZ,), ('14:07:20.492883-09:50':::TIMETZ,), ('19:49:05.400843+01:11':::TIMETZ,), ('15:49:12.640369+13:20':::TIMETZ,), ('19:44:24.427476+09:34':::TIMETZ,), ('23:44:02.144031+06:14':::TIMETZ,), ('12:45:16.118595-04:41':::TIMETZ,), ('10:44:12.784846+14:40':::TIMETZ,), ('18:54:23.5826-11:49':::TIMETZ,), ('06:58:35.552749-07:27':::TIMETZ,)), PARTITION \"tab%ql%v͟\u000ce.\u000c138_part4\" VALUES IN (('24:00:00-15:59':::TIMETZ,), ('01:20:14.658119+14:05':::TIMETZ,), ('21:18:17.026124-02:59':::TIMETZ,), ('13:44:43.514168-13:23':::TIMETZ,), ('09:37:29.114052-06:48':::TIMETZ,), ('19:02:11.553491-11:03':::TIMETZ,), ('03:34:17.002174+09:12':::TIMETZ,), ('05:56:13.435201-11:46':::TIMETZ,), ('17:31:06.292618-02:54':::TIMETZ,), ('20:17:00.440181-06:19':::TIMETZ,)), PARTITION \"tabl%v\u000ce.138_part5\" VALUES IN (('14:31:17.835267+07:07':::TIMETZ,), ('22:27:12.491258+06:50':::TIMETZ,), ('23:19:14.775148+08:11':::TIMETZ,), ('01:31:35.337727+06:13':::TIMETZ,), ('16:43:15.593532+12:27':::TIMETZ,), ('19:05:32.96531-00:24':::TIMETZ,), ('06:31:52.439796+02:16':::TIMETZ,), ('08:02:07.7745+08:15':::TIMETZ,)), PARTITION \"tabl%v\u000ce.138_part6\" VALUES IN (('15:20:23.226133-01:21':::TIMETZ,), ('21:37:33.852406-01:14':::TIMETZ,), ('19:26:24.012104+06:48':::TIMETZ,), ('06:14:54.756564+04:56':::TIMETZ,), ('21:30:15.803244+11:36':::TIMETZ,), ('21:43:43.585041+13:58':::TIMETZ,), ('10:46:03.191457+10:58':::TIMETZ,), ('02:40:11.687384-08:45':::TIMETZ,)), PARTITION \"tabl%v\u000ce.138_part7\" VALUES IN (('03:33:46.286728-12:51':::TIMETZ,), ('14:15:37.823084-02:44':::TIMETZ,), ('11:16:56.482795-02:29':::TIMETZ,), ('08:20:40.394301-02:57':::TIMETZ,), ('01:24:21.109918+01:51':::TIMETZ,), ('08:34:12.114139+09:17':::TIMETZ,), ('20:40:18.725999+07:37':::TIMETZ,), ('06:44:54.270869+13:02':::TIMETZ,)), PARTITION \"DEFAULT\" VALUES IN ((DEFAULT,))), UNIQUE (col138_̍141 DESC, col138_139), UNIQUE (col138_139), INDEX (col138_139 ASC) STORING (\"c\"\"ol138_140\"), UNIQUE (col138_̍141 ASC), INDEX (lower(CAST(col138_139 AS STRING))) STORING (\"c\"\"ol138_140\"))"
[09:53:24] : [Run stress] },
[09:53:24] : [Run stress] {
[09:53:24] : [Run stress] "sql": "CREATE TABLE schema94.table138 (\"coL138_142\" TSVECTOR NULL, \"co/l1-38_143\" INT8, col138_144 DECIMAL NOT NULL, \"col\"\"138_145\" TSQUERY NOT NULL, col138_146 BOX2D NOT NULL, \"col) 138_147\" INT2 NULL, col138_148 INT2, co l138_149 INTERVAL NOT NULL, \"col1.38_150\" DATE NOT NULL, col138_151 REGTYPE, \"c o|l138_152\" BYTES NOT NULL, col138_153 DATE NOT NULL, \"col 138_154\" CHAR NOT NULL, col138_155 REGTYPE NULL, \"Col138_156\" STRING NOT NULL AS (CASE WHEN co l138_149 IS NULL THEN e'0$\\x18':::STRING ELSE e'n\\x12\"L':::STRING END) VIRTUAL, \"*co\"\"l138_157\" STRING NULL AS (lower(CAST(\"coL138_142\" AS STRING))) VIRTUAL, INVERTED INDEX (col138_146 ASC, col138_148 DESC, \"*co\"\"l138_157\" gin_trgm_ops), INDEX (\"c o|l138_152\", \"col1.38_150\") STORING (\"coL138_142\", \"co/l1-38_143\", \"col\"\"138_145\", \"col) 138_147\", col138_148, co l138_149, col138_153), INDEX (\"co/l1-38_143\" ASC, col138_151 ASC, col138_148 ASC) STORING (\"coL138_142\", col138_144, \"col\"\"138_145\", \"col) 138_147\", \"col1.38_150\", col138_153) PARTITION BY LIST (\"co/l1-38_143\") (PARTITION ta̛ble138_part0 VALUES IN ((353856714755150228:::INT8,), ((-44200730688370300):::INT8,), ((-4341291220561756237):::INT8,), ((-3767990807326665378):::INT8,), ((-3195100197495390880):::INT8,), ((-2085930967353126957):::INT8,), (8098049807310931691:::INT8,)), PARTITION ta̛ble138_part1 VALUES IN ((2528689941935795959:::INT8,), (466619195203416801:::INT8,), (4363196455702246385:::INT8,), ((-32768):::INT8,), ((-1336612476858700898):::INT8,), (1:::INT8,), ((-6350205289057944912):::INT8,)), PARTITION ta̛ble138_part2 VALUES IN (((-3037538045340875534):::INT8,), ((-981706827538009218):::INT8,), (2810682051705483733:::INT8,), (3424348582958710731:::INT8,), (32767:::INT8,), ((-5890612915821357104):::INT8,)), PARTITION ta̛ble138_part3 VALUES IN (((-8698375929588161538):::INT8,), (2310726962294324519:::INT8,), ((-9223372036854775807):::INT8,), ((-4908536747623284376):::INT8,), ((-6514610377398179272):::INT8,), (2916305646468186954:::INT8,), ((-6036693796557913401):::INT8,)), PARTITION \"ta ̛ble138_part4\" VALUES IN ((5006591316687756122:::INT8,), (697370274777417980:::INT8,), (7392507121918041697:::INT8,), (7127085268119412726:::INT8,), (4464404319386392980:::INT8,), ((-2080311302534647145):::INT8,)), PARTITION \"ta̛ble13 8_part5\" VALUES IN ((312878705746774777:::INT8,), (7195481334518850459:::INT8,), (127:::INT8,), (0:::INT8,), (7010794864306445427:::INT8,), (3894291389595446631:::INT8,), (2796747415563668332:::INT8,)), PARTITION \"ta̛ble138_part\\g6\" VALUES IN (((-1332797615592862948):::INT8,), (1896161038689834613:::INT8,), ((-8885202651444772188):::INT8,), ((-2147483648):::INT8,), ((-7474293302868587512):::INT8,), ((-7393040294401015787):::INT8,), (4585862759093840370:::INT8,)), PARTITION \"DEFAULT\" VALUES IN ((DEFAULT,))) NOT VISIBLE)",
[09:53:24] : [Run stress] "expectedExecErr": "42P07",
[09:53:24] : [Run stress] "potentialExecErr": "0A000,42601"
[09:53:24] : [Run stress] }
[09:53:24] : [Run stress] ],
[09:53:24] : [Run stress] "expectedExecErrors": "42P07",
[09:53:24] : [Run stress] "expectedCommitErrors": "",
[09:53:24] : [Run stress] "message": "***UNEXPECTED ERROR; Received an unexpected execution error.: ERROR: unexpected value: raw_bytes:\"\\337(\\2478\\001\\236\\002\" timestamp:\u003c\u003e (SQLSTATE XXUUU)",
from cockroach.
root@localhost:26257/defaultdb> select decode('\337(\2478\001\236\002', 'escape');
decode
--------------------
\xdf28a738019e02
(1 row)
root@localhost:26257/defaultdb> select crdb_internal.pretty_value(decode('\337(\2478\001\236\002', 'escape'));
crdb_internal.pretty_value
------------------------------
/INT/143
(1 row)
We think that this means it was trying to create a descriptor with ID 143, but there was already one there. Not sure how this can happen.
from cockroach.
We have seen this behaviour before:
#102799
from cockroach.
pkg/ccl/testccl/workload/schemachange/schemachange_test.TestWorkload failed with artifacts on release-23.1 @ e193b16db630466b4f6d329fedf97e0f719055b9:
1, 29, reports_meta, 28
1, 29, role_id_seq, 48
1, 29, role_members, 23
1, 29, role_options, 33
1, 29, scheduled_jobs, 37
1, 29, settings, 6
1, 29, span_configurations, 47
1, 29, span_stats_buckets, 55
1, 29, span_stats_samples, 56
1, 29, span_stats_tenant_boundaries, 57
1, 29, span_stats_unique_keys, 54
1, 29, sql_instances, 46
1, 29, sqlliveness, 39
1, 29, statement_activity, 60
1, 29, statement_bundle_chunks, 34
1, 29, statement_diagnostics, 36
1, 29, statement_diagnostics_requests, 35
1, 29, statement_statistics, 42
1, 29, table_statistics, 20
1, 29, task_payloads, 58
1, 29, tenant_id_seq, 62
1, 29, tenant_settings, 50
1, 29, tenant_tasks, 59
1, 29, tenant_usage, 45
1, 29, tenants, 8
1, 29, transaction_activity, 61
1, 29, transaction_statistics, 43
1, 29, ui, 14
1, 29, users, 4
1, 29, web_sessions, 19
1, 29, zones, 5
100, 0, public, 101
102, 0, public, 103
104, 0, public, 105
104, 0, schema131, 130
104, 105, _enum21, 109
104, 105, _enum26, 111
104, 105, _enum52, 116
104, 105, enum21, 108
104, 105, enum26, 110
104, 105, enum52, 115
104, 105, seq179, 145
104, 105, table152, 138
104, 130, _enum140, 136
104, 130, enum140, 135
104, 130, table162, 143
schema_change_external_test.go:80: backup in /artifacts/tmp/_tmp/fcba020ca7cb44bf8385bd0e13bcbe2d/logTestWorkload3301471067
panic.go:522: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/fcba020ca7cb44bf8385bd0e13bcbe2d/logTestWorkload3301471067
--- FAIL: TestWorkload (13.94s)
Parameters:
TAGS=bazel,gss
This test on roachdash | Improve this report!
from cockroach.
I'm closing this as unreproducible. We've also lost the artifacts from the recent failure.
from cockroach.
Related Issues (20)
- rpc: TestRemoteOffsetUnhealthy failed HOT 1
- pkg/jobs/jobsprofiler/jobsprofiler_test: TestTraceRecordingOnResumerCompletion failed
- kv/kvserver/liveness: TestScanNodeVitalityFromKV failed HOT 1
- ccl/changefeedccl: TestNoBackfillAfterNonTargetColumnDrop failed
- kv/kvnemesis: TestKVNemesisMultiNode failed HOT 1
- ccl/multiregionccl: TestRegionAddDropWithConcurrentBackupOps failed
- Failed to construct index entries during backfill: overflow during Encode HOT 2
- jobs: add crdb_internal.scheduled_jobs built in
- sql/stmtdiagnostics: TestDiagnosticsRequest failed
- Sentry: txn.go:1234: GetLeafTxnInputState() called on leaf txn (1) attached stack trace -- stack trace: | github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn.func1 | github.com/cockroa... HOT 2
- sql/privileges: add a unit test to ensure no system privilege is introduced without a equivalent read-only privilege
- sql/schemachanger: support ALTER COLUMN ... SET TYPE in declarative schema changer
- pkg/sql/logictest/tests/cockroach-go-testserver-23.1/cockroach-go-testserver-23_1_test: TestLogic_mixed_version_udf_execute_privileges failed HOT 1
- acceptance: TestDockerCLI_test_replication_protocol failed [unable to apply cgroup configuration] HOT 1
- ui: add on demand debug info to sql activity pages
- kv: improve deadlock observability
- Sentry: logical_props_builder.go:1699: comparison overload not found (×, ×, ×) (1) assertion failure Wraps: (2) attached stack trace -- stack trace: | github.com/cockroachdb/cockroach/pkg/sql/o... HOT 2
- Sentry: logical_props_builder.go:1699: comparison overload not found (×, ×, ×) (1) assertion failure Wraps: (2) attached stack trace -- stack trace: | github.com/cockroachdb/cockroach/pkg/sql/o... HOT 1
- util/log: TestMessageReceived failed HOT 1
- util/log: TestHTTPSinkHeadersAndCompression failed HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from cockroach.