return query linux

[RafaelIngenium]

I'm in a strange situation. I made an integration with firebird (which I don't have access to configure it) where I look for the viq query information and insert it in another database. When run via windows it works normally. When I run via linux (compiled on linux OS) it doesn't work. I receive the following feedback:" sql: no rows in result set"
The interesting thing is that this integration is for two clients where one is working perfectly and the other is having this difficulty. Has anyone ever experienced this? I believe it's something in the firebird configuration more, as I don't have access I have to make sure which configuration is missing.

[ljluestc]

package main

import (
	"database/sql"
	"fmt"
	"log"
	"os"
	"time"

	_ "github.com/lib/pq"
	"github.com/nakagami/firebirdsql"
)

func main() {
	// Configure logging
	logFile, err := os.OpenFile("integration.log", os.O_CREATE|os.O_WRONLY|os.O_APPEND, 0666)
	if err != nil {
		log.Fatalf("Failed to open log file: %v", err)
	}
	defer logFile.Close()
	log.SetOutput(logFile)
	log.SetFlags(log.LstdFlags | log.Lshortfile)

	// Firebird connection parameters
	fbConnStr := "SYSDBA:masterkey@192.168.1.50:3050//var/lib/firebird/2.5/data/database.fdb?charset=UTF8"
	// PostgreSQL connection parameters
	pgConnStr := "host=localhost port=5432 user=postgres password=secret dbname=target_db sslmode=disable"

	// Connect to Firebird
	fbDB, err := sql.Open("firebirdsql", fbConnStr)
	if err != nil {
		log.Fatalf("Failed to connect to Firebird: %v", err)
	}
	defer fbDB.Close()

	// Test Firebird connection
	if err := fbDB.Ping(); err != nil {
		log.Fatalf("Firebird ping failed: %v", err)
	}
	log.Println("Connected to Firebird successfully")

	// Connect to PostgreSQL
	pgDB, err := sql.Open("postgres", pgConnStr)
	if err != nil {
		log.Fatalf("Failed to connect to PostgreSQL: %v", err)
	}
	defer pgDB.Close()

	// Test PostgreSQL connection
	if err := pgDB.Ping(); err != nil {
		log.Fatalf("PostgreSQL ping failed: %v", err)
	}
	log.Println("Connected to PostgreSQL successfully")

	// Set Firebird transaction isolation level
	_, err = fbDB.Exec("SET TRANSACTION READ COMMITTED")
	if err != nil {
		log.Printf("Failed to set transaction: %v", err)
	}

	// Query Firebird
	query := "SELECT id, name, created_at FROM viq WHERE active = 1"
	rows, err := fbDB.Query(query)
	if err != nil {
		log.Fatalf("Firebird query failed: %v", err)
	}
	defer rows.Close()

	// Check if rows are returned
	columns, err := rows.Columns()
	if err != nil {
		log.Fatalf("Failed to get columns: %v", err)
	}
	log.Printf("Query returned columns: %v", columns)

	rowCount := 0
	for rows.Next() {
		rowCount++
		var id int
		var name string
		var createdAt time.Time

		if err := rows.Scan(&id, &name, &createdAt); err != nil {
			log.Printf("Failed to scan row: %v", err)
			continue
		}
		log.Printf("Row %d: id=%d, name=%s, created_at=%v", rowCount, id, name, createdAt)

		// Insert into PostgreSQL
		_, err = pgDB.Exec(
			"INSERT INTO viq_copy (id, name, created_at) VALUES ($1, $2, $3)",
			id, name, createdAt,
		)
		if err != nil {
			log.Printf("Failed to insert into PostgreSQL: %v", err)
			continue
		}
	}

	if err := rows.Err(); err != nil {
		log.Printf("Row iteration error: %v", err)
	}

	if rowCount == 0 {
		log.Println("No rows returned from Firebird query")
		fmt.Println("sql: no rows in result set")
	} else {
		log.Printf("Processed %d rows", rowCount)
		fmt.Printf("Processed %d rows successfully\n", rowCount)
	}
}