I have 4 golang backend services that hit the same database but different table. However, some of them are succeed and some of them failed. The golang services only perform a simple SELECT statement. There are 4 tables and have 1-3mil rows average 12-80 columns.
Code
Here is the golang service code below:
sql := fmt.Sprintf(`SELECT * FROM [%s].[dbo].[%s] WITH (NOLOCK)`, viper.GetString("SQL_SERVER_DBNAME"), viper.GetString("SQL_SERVER_TABLE"))
repository.logger.Infof(sql)
rows, err := repository.sqlServerConnection.Query(sql)
if err != nil {
return nil, err
}
defer rows.Close()
var dataList []Order
for rows.Next() {
var data Order
err := rows.Scan(....)
if err != nil {
return nil, err
}
dataList= append(dataList, data )
}
if rows.Err() != nil {
return nil, rows.Err()
}
return dataList, nil
Issue
I have 4 golang backend services that hit the same database but different table. However, some of them are succeed and some of them failed. The golang services only perform a simple
SELECT
statement. There are 4 tables and have 1-3mil rows average 12-80 columns.Code
Here is the golang service code below:
Error Log
This is the error log I got:
I need some insight about what causing the issue above.