Giter VIP home page Giter VIP logo

Comments (5)

annrpom avatar annrpom commented on July 24, 2024
[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.

rafiss avatar rafiss commented on July 24, 2024
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.

fqazi avatar fqazi commented on July 24, 2024

We have seen this behaviour before:
#102799

from cockroach.

cockroach-teamcity avatar cockroach-teamcity commented on July 24, 2024

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
Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

from cockroach.

rafiss avatar rafiss commented on July 24, 2024

I'm closing this as unreproducible. We've also lost the artifacts from the recent failure.

from cockroach.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.