Adding a column

Manya · May 6, 2024, 9:34pm

after adding a column to scylla table , we are getting this error in app
gocql: not enough columns to scan into: have 7 want 8

tzach · May 20, 2024, 10:19am

Which gocql are you using?
A similar issue was sloved many years ago

github.com/scylladb/scylladb

ScyllaDB with golang driver

opened 02:02PM - 16 Feb 16 UTC

closed 12:43PM - 24 Feb 16 UTC

indykish

user request

I tried the gocassa driver(https://github.com/megamsys/gocassa) built on top of … github.com/gocql/gocql with scylladb. **Cassandra 2.1.8** In cassandra a query is performed on inside the code `github.com/gocql/gocql` for this query. SELECT data_center, rack, host_id, tokens, release_version FROM system.local WHERE key='local' I received the results ``` Enter code here...&gocql.Iter{err:error(nil), pos:0, meta:gocql.resultMetadata{flags:1, pagingState:[]uint8(nil), columns:[]gocql.ColumnInfo{gocql.ColumnInfo{Keyspace:"system", Table:"local", Name:"data_center", TypeInfo:gocql.NativeType{proto:0x3, typ:13, custom:""}}, gocql.ColumnInfo{Keyspace:"system", Table:"local", Name:"rack", TypeInfo:gocql.NativeType{proto:0x3, typ:13, custom:""}}, gocql.ColumnInfo{Keyspace:"system", Table:"local", Name:"host_id", TypeInfo:gocql.NativeType{proto:0x3, typ:12, custom:""}}, gocql.ColumnInfo{Keyspace:"system", Table:"local", Name:"tokens", TypeInfo:gocql.CollectionType{NativeType:gocql.NativeType{proto:0x3, typ:34, custom:""}, Key:gocql.TypeInfo(nil), Elem:gocql.NativeType{proto:0x3, typ:13, custom:""}}}, gocql.ColumnInfo{Keyspace:"system", Table:"local", Name:"release_version", TypeInfo:gocql.NativeType{proto:0x3, typ:13, custom:""}}}, colCount:5, actualColCount:5}, numRows:1, next:(*gocql.nextIter)(nil), host:(*gocql.HostInfo)(nil), framer:(*gocql.framer)(0xc8200d80b0), once:sync.Once{m:sync.Mutex{state:0, sema:0x0}, done:0x0}} ``` and it works **In ScyllaDB 0.17** The same query returns back with no info from `github.com/gocql/gocql` ``` &gocql.Iter{err:error(nil), pos:0, meta:gocql.resultMetadata{flags:4, pagingState:[]uint8(nil), columns:[]gocql.ColumnInfo(nil), colCount:0, actualColCount:0}, numRows:1, next:(*gocql.nextIter)(nil), host:(*gocql.HostInfo)(nil), framer:(*gocql.framer)(0xc820094370), once:sync.Once{m:sync.Mutex{state:0, sema:0x0}, done:0x0}} ``` `unable to fetch host info for 127.0.0.1: gocql: not enough columns to scan into: have 5 want 0` I tried using `cqlsh to scylladb` and ran the same query, but it works. Can somebody throw light on what i can do in `github.com/gocql/gocql` to fix this problem ?