Skip to content

ccl/importccl: TestImportCSVStmt failed #44789

@cockroach-teamcity

Description

@cockroach-teamcity

(ccl/importccl).TestImportCSVStmt failed on master@51477991e358c2164b9f21c8cb46cdebb7dc4bfb:

I200206 02:05:43.028299 2038 sql/schema_changer.go:973  [n1,scExec] schema change on t (75 v2) mutation 0 starting execution...
I200206 02:05:43.029830 28032 storage/replica_command.go:396  [n1,split,s1,r164/1:/Table/7{3/3-5/1}] initiating a split of this range at key /Table/75 [r175] (zone config)
E200206 02:05:43.033708 27033 jobs/registry.go:770  [n1] job 527185814306324481: adoption completed with error Not enough memory available to create a BulkAdder. Try setting a higher --max-sql-memory.: root: memory budget exceeded: 33554432 bytes requested, 100683776 currently allocated, 134217728 bytes in budget
I200206 02:05:43.034197 2888 sql/schema_changer.go:973  [n2,scExec] schema change on t (75 v2) mutation 0 starting execution...
I200206 02:05:43.043478 3180 sql/schema_changer.go:973  [n3,scExec] schema change on t (75 v2) mutation 0 starting execution...
E200206 02:05:43.049495 27033 jobs/registry.go:776  [n1] job 527185814306324481: status failed after adoption finished
    --- FAIL: TestImportCSVStmt/schema-in-file-implicit-gzip (0.35s)
        import_stmt_test.go:1352: error scanning '&{0xc006c2b8c0 <nil>}': pq: Not enough memory available to create a BulkAdder. Try setting a higher --max-sql-memory.: root: memory budget exceeded: 33554432 bytes requested, 100683776 currently allocated, 134217728 bytes in budget
=== RUN   TestImportCSVStmt/schema-in-file-explicit-bzip
I200206 02:05:43.052898 3180 sql/schema_changer.go:973  [n3,scExec] schema change on t (75 v2) mutation 0 starting execution...
I200206 02:05:43.053802 2888 sql/schema_changer.go:973  [n2,scExec] schema change on t (75 v2) mutation 0 starting execution...
I200206 02:05:43.099681 4799 sql/event_log.go:132  [n1,client=127.0.0.1:53520,user=root] Event: "create_database", target: 76, info: {DatabaseName:csv12 Statement:CREATE DATABASE csv12 User:root}
I200206 02:05:43.147657 29006 jobs/registry.go:640  [n1] job 527185815572217857: stepping through state running with error <nil>
I200206 02:05:43.175854 29006 storage/replica_command.go:396  [n1,s1,r174/1:/{Table/75/3-Max}] initiating a split of this range at key /Table/77/1 [r176] (manual)
I200206 02:05:43.190241 29006 storage/replica_command.go:396  [n1,s1,r176/1:/{Table/77/1-Max}] initiating a split of this range at key /Table/77/2 [r177] (manual)
I200206 02:05:43.208637 29006 storage/replica_command.go:396  [n1,s1,r177/1:/{Table/77/2-Max}] initiating a split of this range at key /Table/77/3 [r178] (manual)
I200206 02:05:43.305306 29006 jobs/registry.go:640  [n1] job 527185815572217857: stepping through state reverting with error Not enough memory available to create a BulkAdder. Try setting a higher --max-sql-memory.: root: memory budget exceeded: 33554432 bytes requested, 100683776 currently allocated, 134217728 bytes in budget
I200206 02:05:43.315758 29006 jobs/registry.go:640  [n1] job 527185815572217857: stepping through state failed with error Not enough memory available to create a BulkAdder. Try setting a higher --max-sql-memory.: root: memory budget exceeded: 33554432 bytes requested, 100683776 currently allocated, 134217728 bytes in budget
I200206 02:05:43.320240 30298 storage/replica_command.go:396  [n1,split,s1,r174/1:/Table/7{5/3-7/1}] initiating a split of this range at key /Table/77 [r179] (zone config)
I200206 02:05:43.320402 3180 sql/schema_changer.go:973  [n3,scExec] schema change on t (77 v2) mutation 0 starting execution...
I200206 02:05:43.321077 2888 sql/schema_changer.go:973  [n2,scExec] schema change on t (77 v2) mutation 0 starting execution...
E200206 02:05:43.328370 29006 jobs/registry.go:770  [n1] job 527185815572217857: adoption completed with error Not enough memory available to create a BulkAdder. Try setting a higher --max-sql-memory.: root: memory budget exceeded: 33554432 bytes requested, 100683776 currently allocated, 134217728 bytes in budget
E200206 02:05:43.344154 29006 jobs/registry.go:776  [n1] job 527185815572217857: status failed after adoption finished
I200206 02:05:43.344304 3180 sql/schema_changer.go:973  [n3,scExec] schema change on t (77 v2) mutation 0 starting execution...
    --- FAIL: TestImportCSVStmt/schema-in-file-explicit-bzip (0.29s)
        import_stmt_test.go:1352: error scanning '&{0xc006a4c7e0 <nil>}': pq: Not enough memory available to create a BulkAdder. Try setting a higher --max-sql-memory.: root: memory budget exceeded: 33554432 bytes requested, 100683776 currently allocated, 134217728 bytes in budget
=== RUN   TestImportCSVStmt/schema-in-file-auto-bzip
I200206 02:05:43.352451 4799 sql/event_log.go:132  [n1,client=127.0.0.1:53520,user=root] Event: "create_database", target: 78, info: {DatabaseName:csv13 Statement:CREATE DATABASE csv13 User:root}
I200206 02:05:43.378154 31619 jobs/registry.go:640  [n1] job 527185816332894209: stepping through state running with error <nil>
I200206 02:05:43.404697 31619 storage/replica_command.go:396  [n1,s1,r178/1:/{Table/77/3-Max}] initiating a split of this range at key /Table/79/1 [r180] (manual)
I200206 02:05:43.419723 31619 storage/replica_command.go:396  [n1,s1,r180/1:/{Table/79/1-Max}] initiating a split of this range at key /Table/79/2 [r181] (manual)
I200206 02:05:43.445796 31619 storage/replica_command.go:396  [n1,s1,r181/1:/{Table/79/2-Max}] initiating a split of this range at key /Table/79/3 [r182] (manual)
I200206 02:05:43.502328 32775 storage/replica_command.go:396  [n1,s1,r180/1:/Table/79/{1-2}] initiating a split of this range at key /Table/79/1/0 [r183] (manual)
I200206 02:05:43.546187 32860 storage/replica_command.go:396  [n1,s1,r181/1:/Table/79/{2-3}] initiating a split of this range at key /Table/79/2/"A"/0 [r184] (manual)
I200206 02:05:43.547138 26064 jobs/registry.go:640  [n1] job 527185798297583617: stepping through state succeeded with error <nil>
I200206 02:05:43.560391 2038 sql/schema_changer.go:1263  [n1,scExec] waiting for a single version of table 75...
I200206 02:05:43.560781 2038 sql/schema_changer.go:1265  [n1,scExec] waiting for a single version of table 75... done (at v 0)
W200206 02:05:43.560861 2038 sql/schema_changer.go:2128  [n1] Error executing schema change: descriptor not found
W200206 02:05:43.561288 2038 sql/schema_changer.go:2128  [n1] Error executing schema change: descriptor not found
E200206 02:05:43.561561 26064 jobs/registry.go:776  [n1] job 527185798297583617: status succeeded after adoption finished
I200206 02:05:43.565912 33652 storage/replica_command.go:396  [n1,split,s1,r178/1:/Table/7{7/3-9/1}] initiating a split of this range at key /Table/79 [r185] (zone config)
I200206 02:05:43.566573 2038 sql/schema_changer.go:973  [n1,scExec] schema change on t (77 v2) mutation 0 starting execution...
I200206 02:05:43.720319 31619 jobs/registry.go:640  [n1] job 527185816332894209: stepping through state reverting with error Not enough memory available to create a BulkAdder. Try setting a higher --max-sql-memory.: root: memory budget exceeded: 33554432 bytes requested, 100857856 currently allocated, 134217728 bytes in budget
I200206 02:05:43.740459 31619 jobs/registry.go:640  [n1] job 527185816332894209: stepping through state failed with error Not enough memory available to create a BulkAdder. Try setting a higher --max-sql-memory.: root: memory budget exceeded: 33554432 bytes requested, 100857856 currently allocated, 134217728 bytes in budget
I200206 02:05:43.743918 2038 sql/schema_changer.go:973  [n1,scExec] schema change on t (79 v2) mutation 0 starting execution...
E200206 02:05:43.752614 31619 jobs/registry.go:770  [n1] job 527185816332894209: adoption completed with error Not enough memory available to create a BulkAdder. Try setting a higher --max-sql-memory.: root: memory budget exceeded: 33554432 bytes requested, 100857856 currently allocated, 134217728 bytes in budget
I200206 02:05:43.754015 3180 sql/schema_changer.go:973  [n3,scExec] schema change on t (79 v2) mutation 0 starting execution...
E200206 02:05:43.756273 31619 jobs/registry.go:776  [n1] job 527185816332894209: status failed after adoption finished
    --- FAIL: TestImportCSVStmt/schema-in-file-auto-bzip (0.41s)
        import_stmt_test.go:1352: error scanning '&{0xc003aebd40 <nil>}': pq: Not enough memory available to create a BulkAdder. Try setting a higher --max-sql-memory.: root: memory budget exceeded: 33554432 bytes requested, 100857856 currently allocated, 134217728 bytes in budget

More

Parameters:

  • GOFLAGS=-json
make stressrace TESTS=TestImportCSVStmt PKG=./pkg/ccl/importccl TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

See this test on roachdash
powered by pkg/cmd/internal/issues

Metadata

Metadata

Assignees

Labels

C-test-failureBroken test (automatically or manually discovered).O-robotOriginated from a bot.branch-masterFailures and bugs on the master branch.

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions