Re: psqlodbc 09.01.0200 - OS X 10.6 - memory leak ?

Hi,

I tried to reproduce the problem with basic C code.

Got the same problem after 17 millions inserts.

create table :
CREATE TABLE bug_127330 (urn integer,app varchar(2))

Note : I added this file to the project :
/Library/Frameworks/iODBC.framework/Versions/3.52/iODBC

//
// main.c
// odbctest
//
// Created by Bruno LEGAY on 05/04/13.
// Copyright 2013 A&C Consulting. All rights reserved.
//

#include <stdio.h>
#include <sql.h>
#include <sqlext.h>

/*
* see Retrieving ODBC Diagnostics
* for a definition of extract_error().
*/
static void extract_error(
char *fn,
SQLHANDLE handle,
SQLSMALLINT type);

int main (int argc, const char * argv[])
{
SQLHENV env;
SQLHDBC dbc;
SQLHSTMT stmt;
SQLRETURN ret;
SQLCHAR outstr[1024];
SQLSMALLINT outstrlen;

int iters;

/* Allocate an environment handle */
SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &env);

/* We want ODBC 3 support */
SQLSetEnvAttr(env, SQL_ATTR_ODBC_VERSION, (void *) SQL_OV_ODBC3, 0);

/* Allocate a connection handle */
SQLAllocHandle(SQL_HANDLE_DBC, env, &dbc);

/* Connect to the DSN oncdPostgreSQL_Unicode */
ret = SQLDriverConnect(dbc, NULL,
"DSN=oncdPostgreSQL_Unicode;UID=postgres;PWD=postgres;", SQL_NTS,
outstr, sizeof(outstr), &outstrlen,
SQL_DRIVER_COMPLETE);

if (SQL_SUCCEEDED(ret)) {
printf("Connected\n");

printf("Returned connection string was:\n\t%s\n", outstr);

if (ret == SQL_SUCCESS_WITH_INFO) {
printf("Driver reported the following diagnostics\n");
extract_error("SQLDriverConnect", dbc, SQL_HANDLE_DBC);
}

SQLCHAR* sqlStatement = "INSERT INTO bug_127330 (urn,app) VALUES
(?,'C')";

/* Allocate a statement handle */
ret = SQLAllocHandle(SQL_HANDLE_STMT, dbc, &stmt);

if (ret == SQL_SUCCESS || ret == SQL_SUCCESS_WITH_INFO) {
// infinite loop...
while (1) {

iters++;

// SQL FIXER PARAMETRE($vl_iters;SQL Paramètre entrée)
ret = SQLBindParameter(stmt, 1, SQL_PARAM_INPUT,
SQL_C_SLONG, SQL_INTEGER, 0, 0,
&iters, sizeof(iters), NULL);

// SQL EXECUTER($vt_sql)
ret = SQLPrepare(stmt, sqlStatement, SQL_NTS);
ret = SQLExecute(stmt);

// log
if(ret == SQL_SUCCESS || ret == SQL_SUCCESS_WITH_INFO) {
printf("Insert data OK : %d\n",iters);
}

// SQL ANNULER CHARGEMENT
ret = SQLFreeStmt(stmt, SQL_RESET_PARAMS);
}

SQLFreeHandle(SQL_HANDLE_STMT, stmt);

} else {
printf("Error Allocating Handle: %d\n", ret);
}

SQLDisconnect(dbc); /* disconnect from driver */

} else {
fprintf(stderr, "Failed to connect\n");
extract_error("SQLDriverConnect", dbc, SQL_HANDLE_DBC);
}
/* free up allocated handles */
SQLFreeHandle(SQL_HANDLE_DBC, dbc);
SQLFreeHandle(SQL_HANDLE_ENV, env);

return 0;
}

static void extract_error(
char *fn,
SQLHANDLE handle,
SQLSMALLINT type) {
SQLINTEGER i = 0;
SQLINTEGER native;
SQLCHAR state[ 7 ];
SQLCHAR text[256];
SQLSMALLINT len;
SQLRETURN ret;

fprintf(stderr,
"\n"
"The driver reported the following diagnostics whilst running "
"%s\n\n",
fn);

do
{
ret = SQLGetDiagRec(type, handle, ++i, state, &native, text,
sizeof(text), &len );
if (SQL_SUCCEEDED(ret))
printf("%s:%ld:%ld:%s\n", state, i, native, text);
}
while( ret == SQL_SUCCESS );
}

Process: Xcode [22709]
Path: /Developer/Applications/Xcode.app/Contents/MacOS/Xcode
Identifier: com.apple.dt.Xcode
Version: 4.1 (516)
Build Info: IDEApplication-5160000~33
Code Type: X86-64 (Native)
Parent Process: launchd [459]

Date/Time: 2013-04-06 05:54:36.667 +0200
OS Version: Mac OS X 10.6.8 (10K549)
Report Version: 6

Exception Type: EXC_BAD_ACCESS (SIGSEGV)
Exception Codes: KERN_INVALID_ADDRESS at 0x0000000000000000
Crashed Thread: 0 Dispatch queue: com.apple.main-thread

Application Specific Information:
ProductBuildVersion: 4B110f
NSCFDictionary
objc[22709]: garbage collection is ON

...

--
View this message in context: http://postgresql.1045698.n5.nabble.com/psqlodbc-09-01-0200-OS-X-10-6-memory-leak-tp5750832p5751040.html
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.