huge memory leak with prepared statements

[volkmarbuehringer]

my program runs with postgres-driver with prepared statements and a footprint of 8 MB
(standard database/sql without any other libraries )

( db.Prepare and then execute stmt.Query very often )

after switching to oracle it has a huge memory leak

without prepared statements it runs fine on oracle ( db.Query )

are prepared statements not supported ?

Another issue is with "insert into returning "
with postgres I execute this Statement with Query and fetch the returned data

with your driver I need to execute with Exec (and additional binds ) and I don't know how to get the returned data

(always database/sql standard library )

[tgulacsi]

What do you mean by "huge memory leak"? As in #160, ten times the memory of PostgreSQL is not uncommon.

Do you close the prepared statements?

On return: Oracle supports returning only one record, the specified fields. What do you try precisely?

[volkmarbuehringer]

it is exhausting memory very fast ( 8GB )
1 prepare and many executions of the same statement (works fine with postgres )

therefore I try to work with your driver directly in your style if postgres style doesn't work

[volkmarbuehringer]

this is an example:

func (m *SQLStatement) SelectID(tab string, id int) (rows *sql.Rows, err error) {
if m.sqlID == nil {
sqls := fmt.Sprintf("select %s from %s where %s %s order by %s", strings.Join(m.ColumnsAllType, ","), tab, m.PK[0], EqBindVar+"1", strings.Join(m.PK, ","))
if m.sqlID, err = DB.Prepare(sqls); err != nil {
return
}
}
rows, err = m.sqlID.Query(id)

return

[tgulacsi]

Where do you Close the prepared statement? And the Rows? volkmarbuehringer <notifications@github.com> ezt írta (időpont: 2017. márc. 10., P 16:07):

…

this is an example: func (m *SQLStatement) SelectID(tab string, id int) (rows *sql.Rows, err error) { if m.sqlID == nil { sqls := fmt.Sprintf("select %s from %s where %s %s order by %s", strings.Join(m.ColumnsAllType, ","), tab, m.PK[0], EqBindVar+"1", strings.Join(m.PK, ",")) if m.sqlID, err = DB.Prepare(sqls); err != nil { return } } rows, err = m.sqlID.Query(id) return — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#170 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAPoSqKEcrKuqwO388zA1y703CiWMUqTks5rkWccgaJpZM4MYPrT> .

[volkmarbuehringer]

the rows are closed every time after fetch
func (m *SQLStatement) Fetcher(rows *sql.Rows) (gesamte RowMaps, err error) {
defer rows.Close()

the statement is never closed because it is waiting for executions until end ( which works in postgres )

[tgulacsi]

Please Close the statement.
(I do use Prepare and Query in a for cycle, but haven't met with such behaviour yet).

Do you SELECT DATE typed columns?