51 lines
5.0 KiB
Plaintext
51 lines
5.0 KiB
Plaintext
# 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 {
|