# Database Connection Management - 20251123-080448
== Connection pool settings ==
No pool configuration found - using defaults (potential issue)

== rows.Close() calls (resource cleanup) ==
20
 rows.Close() calls found

== Missing defer rows.Close() (potential leak) ==
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go:449:	rows, err := db.Query(query, args...)
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go-450-	if err != nil {
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go-451-		log.Println("Database error:", err)
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go-452-		respondError(w, http.StatusInternalServerError, "Failed to fetch questions")
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go-453-		return
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go-454-	}
--
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go:506:	err = db.QueryRow(`SELECT id, title, content, author_id, author_name, tags, upvotes, downvotes,
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go-507-		answer_count, view_count, accepted_answer_id, status, created_at, updated_at
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go-508-		FROM forum_questions WHERE id = $1`, id).
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go-509-		Scan(&q.ID, &q.Title, &q.Content, &q.AuthorID, &q.AuthorName, &tags,
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go-510-			&q.Upvotes, &q.Downvotes, &q.AnswerCount, &q.ViewCount, &acceptedID, &q.Status,
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go-511-			&q.CreatedAt, &q.UpdatedAt)
--
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go:527:	rows, err := db.Query(`SELECT id, question_id, content, author_id, author_name, upvotes, downvotes,
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go-528-		is_accepted, is_verified, verified_by, verified_at, created_at, updated_at
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go-529-		FROM forum_answers WHERE question_id = $1 ORDER BY is_accepted DESC, (upvotes - downvotes) DESC, created_at ASC`, id)
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go-530-	if err != nil {
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go-531-		respondError(w, http.StatusInternalServerError, "Failed to fetch answers")
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go-532-		return
--
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go:582:	err := db.QueryRow(`INSERT INTO forum_questions (title, content, author_id, author_name, tags)
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go-583-		VALUES ($1, $2, $3, $4, $5) RETURNING id, created_at, updated_at`,
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go-584-		req.Title, req.Content, userID, userName, tagsToPostgres(req.Tags)).
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go-585-		Scan(&q.ID, &q.CreatedAt, &q.UpdatedAt)
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go-586-	if err != nil {
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go-587-		log.Println("Database error:", err)
--
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go:619:	err = db.QueryRow("SELECT author_id FROM forum_questions WHERE id = $1", id).Scan(&authorID)
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go-620-	if err == sql.ErrNoRows {

== Transaction handling ==
/home/administrator/projects/coppertone.tech/backend/functions/auth-service/main.go:415:	tx, err := db.Begin()
/home/administrator/projects/coppertone.tech/backend/functions/auth-service/main.go:420:	defer tx.Rollback()
/home/administrator/projects/coppertone.tech/backend/functions/auth-service/main.go:458:	if err = tx.Commit(); err != nil {
/home/administrator/projects/coppertone.tech/backend/functions/auth-service/main.go:530:	tx, err := db.Begin()
/home/administrator/projects/coppertone.tech/backend/functions/auth-service/main.go:535:	defer tx.Rollback()
/home/administrator/projects/coppertone.tech/backend/functions/auth-service/main.go:573:	if err = tx.Commit(); err != nil {
/home/administrator/projects/coppertone.tech/backend/functions/auth-service/main.go:1671:	tx, err := db.Begin()
/home/administrator/projects/coppertone.tech/backend/functions/auth-service/main.go:1677:	defer tx.Rollback()
/home/administrator/projects/coppertone.tech/backend/functions/auth-service/main.go:1723:	if err = tx.Commit(); err != nil {