OpenEuphoria

Re: odbc resources

• Posted by Craig Welch <craig at singmail.com> Nov 17, 2005
• 488 views

Next ...

I'm trying to stress test, and have run up the number of inserts to 500,000

When the program ends, it crashes on the final freeHandleODBC(), called 
from cleanUpODBC( )

Edited ex.err:

C:\EUPHORIA\odbc\odbc.e:1258 in procedure freeHandleODBC()
Your program has run out of memory.
One moment please...
    id = 2
    handle = <no value>
    ix = <no value>
    parent = <no value>
    i = <no value>

... called from C:\EUPHORIA\odbc\odbc.e:1264 in procedure freeHandleODBC()  
    id = 1
    handle = 8917664
    ix = <no value>
    parent = <no value>
    i = 1

... called from C:\EUPHORIA\odbc\odbc.e:1264 in procedure freeHandleODBC()  
    id = 2
    handle = 8917832
    ix = <no value>
    parent = <no value>
    i = 1
--------------------------------------
CW Note: The line numbers in my odbc.e are
now different to yours. My line 1264 is:
freeHandleODBC( handle_children[id][i] )
--------------------------------------

<snip many, many such lines>

... (skipping 12058519 levels)

Global & Local Variables

 C:\EUPHORIA\include\machine.e:
    mem = 701392
    check_calls = 1

  C:\EUPHORIA\odbc\odbc.e:
    odbc32 = 1949433856
    kernel32 = 2088763392
    xlstrlen = 0
    henv = 1
    current_handle = 0
    max_records = 1
    VOID = 0
    last_datatype = {}
    handle_odbc = {8917664,8917832,-1}
    handle_children = {
                        {2},
                        {-1},
                        {}
                      }
    handle_type = {1,2,3}
    handle_parent = {0,1,2}
    handle_params = {
                      {{},{}},
                      {{},{}},
                      {{},{}}
                    }
    handle_cols = {{},{},{}}
    last_connect_string = {}


 C:\EUPHORIA\odbc\test_odbc.exw:
    lNextLine = -1
    hconn = 2
    void = {{}}
    sql = {73'I',78'N',83'S',69'E',82'R',84'T',32' ',116't',115's',117'u',
110'n',97'a',109'm',105'i',32' ',86'V',65'A',76'L',85'U',69'E',83'S',40'(',
39''',32' ',51'3',48'0',48'0',48'0',48'0',39''',44',',39''',71'G',82'R',
65'A',78'N',65'A',84'T',72'H',32' ',32' ',32' ',32' ',32' ',32' ',32' ',
32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',39''',44',',
39''',66'B',82'R',69'E',84'T',84'T',32' ',32' ',32' ',32' ',32' ',32' ',
32' ',32' ',32' ',32' ',32' ',32' ',32' ',78'N',39''',44',',39''',54'6',
55'7',52'4',50'2',32' ',87'W',32' ',83'S',73'I',71'G',72'H',84'T',73'I',
78'N',71'G',32' ',84'T',82'R',32' ',32' ',32' ',32' ',32' ',32' ',32' ',
32' ',32' ',32' ',32' ',32' ',39''',44',',39''',70'F',76'L',79'O',82'R',
69'E',78'N',67'C',69'E',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',
39''',44',',39''',75'K',89'Y',52'4',49'1',48'0',52'4',50'2',32' ',32' ',
32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',
32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',
32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',
32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',
32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',
32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',
32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',
32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',32' ',
39''',41')'}
    data = 3
    fh = 3
    counter = 510000
    ok = <no value>
    hstmt = 3
    time1 = 421.55
    time2 = 421.55
    calc = 23.72197841

Any thoughts?

-- 
Craig