This message was deleted.

When I’m trying to look into traces section I have an error in query service

2022-08-04T09:56:37.275Z	DEBUG	clickhouseReader/reader.go:1285	Error in processing sql query: code: 47, message: Missing columns: 'responseStatusCode' 'rpcMethod' while processing query: 'SELECT timestamp, spanID, traceID, serviceName, name, durationNano, httpCode, gRPCCode, gRPCMethod, httpMethod, rpcMethod, responseStatusCode FROM signoz_traces.signoz_index_v2 WHERE (timestamp >= '1659605196978000000') AND (timestamp <= '1659606966978000000') LIMIT 10', required columns: 'timestamp' 'rpcMethod' 'httpCode' 'serviceName' 'spanID' 'name' 'gRPCCode' 'gRPCMethod' 'durationNano' 'responseStatusCode' 'traceID' 'httpMethod', maybe you meant: ['timestamp','gRPCMethod','httpCode','serviceName','spanID','name','gRPCCode','gRPCMethod','durationNano','traceID','httpMethod']
2022-08-04T09:56:37.275Z	ERROR	app/http_handler.go:1835	HTTP handler, Internal Server Error{error 26 0  Error in processing sql query}
<http://go.signoz.io/query-service/app.(*APIHandler).handleError|go.signoz.io/query-service/app.(*APIHandler).handleError>
	/go/src/github.com/signoz/signoz/pkg/query-service/app/http_handler.go:1835
<http://go.signoz.io/query-service/app.(*APIHandler).getFilteredSpans|go.signoz.io/query-service/app.(*APIHandler).getFilteredSpans>
	/go/src/github.com/signoz/signoz/pkg/query-service/app/http_handler.go:1292
<http://go.signoz.io/query-service/app.ViewAccess.func1|go.signoz.io/query-service/app.ViewAccess.func1>
	/go/src/github.com/signoz/signoz/pkg/query-service/app/http_handler.go:224
net/http.HandlerFunc.ServeHTTP
	/usr/local/go/src/net/http/server.go:2047
<http://go.signoz.io/query-service/app.loggingMiddleware.func1|go.signoz.io/query-service/app.loggingMiddleware.func1>
	/go/src/github.com/signoz/signoz/pkg/query-service/app/server.go:187
net/http.HandlerFunc.ServeHTTP
	/usr/local/go/src/net/http/server.go:2047
<http://go.signoz.io/query-service/app.(*Server).analyticsMiddleware.func1|go.signoz.io/query-service/app.(*Server).analyticsMiddleware.func1>
	/go/src/github.com/signoz/signoz/pkg/query-service/app/server.go:226
net/http.HandlerFunc.ServeHTTP
	/usr/local/go/src/net/http/server.go:2047
<http://go.signoz.io/query-service/app.setTimeoutMiddleware.func1|go.signoz.io/query-service/app.setTimeoutMiddleware.func1>
	/go/src/github.com/signoz/signoz/pkg/query-service/app/server.go:243
net/http.HandlerFunc.ServeHTTP
	/usr/local/go/src/net/http/server.go:2047
<http://github.com/gorilla/mux.(*Router).ServeHTTP|github.com/gorilla/mux.(*Router).ServeHTTP>
	/go/pkg/mod/github.com/gorilla/mux@v1.8.0/mux.go:210
<http://github.com/rs/cors.(*Cors).Handler.func1|github.com/rs/cors.(*Cors).Handler.func1>
	/go/pkg/mod/github.com/rs/cors@v1.7.0/cors.go:219
net/http.HandlerFunc.ServeHTTP
	/usr/local/go/src/net/http/server.go:2047
<http://github.com/gorilla/handlers.CompressHandlerLevel.func1|github.com/gorilla/handlers.CompressHandlerLevel.func1>
	/go/pkg/mod/github.com/gorilla/handlers@v1.5.1/compress.go:141
net/http.HandlerFunc.ServeHTTP
	/usr/local/go/src/net/http/server.go:2047
net/http.serverHandler.ServeHTTP
	/usr/local/go/src/net/http/server.go:2879
net/http.(*conn).serve
	/usr/local/go/src/net/http/server.go:1930

You also raised similar problem in Github. You are running into lot of migrations related issues. I think there is something wrong how you are running the signoz. Can you share what all did you do?

no problem, I’ll collect info in several minutes

```- otel-collector version: '0.45.1-1.0'

- otel-collector-metrics version: '0.45.1-1.0'```

They should be

v0.45.1-1.1

for signoz release

0.10.0

.

Copy code

ClickHouse server version 22.7.2 revision 54457

This should be

22.3

at least and

22.4

we are running in docker

ok, I’ll try to change versions