Re: [MonetDB-users] MAPI interface error

23 Dec 2010

      Hi again,

I made a bit of some roundabout progress. So maybe it will help you diagnose
the issue (if it is a global one...as I don't think I am doing anything
incorrect at least).

I am sending a total of 125,000 INSERT statements (of the same format I sent
in the previous email). And I would receive the error/crash after
approximately 10,000 inserts. So to get around the error, I paused my
program after 10,000 inserts, then stopped and started the database using
"monetdb stop/start dbname" and the continue my program for another 10,000
inserts.

I am not sure what this means, but clearly a reset of the DB is correcting
the issue.
Maybe this will help diagnose the issue.

I think my permanent solution will be to get this running on another
computer (I'll try a windows machine this time), and hope for the best.

Thanks for your help,
Brett

On Thu, Dec 23, 2010 at 3:52 AM, Brett Spurrier wrote:
...
The log file is still being filtered out.
Here is my dropbox link to the log file:
http://dl.dropbox.com/u/4402291/merovingian.log
Many thanks,
Brett
On Thu, Dec 23, 2010 at 3:49 AM, Brett Spurrier wrote:
...
Looks like the log file didn't attach. Here it is.
-Brett
On Thu, Dec 23, 2010 at 3:48 AM, Brett Spurrier 
...
wrote:
...
Hi Stefan and Fabian,
I'll try to answer both of you here. (By the way, I really appreciate
your help).
I am using "MonetDB server v5.22.3 (64-bit), based on kernel v1.40.3
(64-bit oids)" on my Mac OSX 10.6.
The DB schema looks as follows:
Columns
------------------------------
title VARCHAR(200)
guid VARCHAR(50)
D0 FLOAT
D1 FLOAT
...
D63 FLOAT
An example INSERT statement looks as follows:
INSERT INTO imagesignatures VALUES ('BK-2000000105000.png',
'9e5a1c52-6dd7-4b29-8c88-db1a67b73b6e', 0.0012992, -0.00648533, 0.0160408,
0.0194895, -0.00426406, -0.00972571, 0.0160934, 0.0273353, 0.0011832,
-0.00841318, 0.00864345, 0.0160668, -0.000174525, -0.0103183, 0.0114333,
0.0213318, -0.0123529, 0.117436, 0.0747747, 0.169459, 0.00168713, 0.237856,
0.196901, 0.293636, -0.00689568, 0.172451, 0.144271, 0.207795, 0.00808731,
0.0852854, 0.0685582, 0.251899, 0.0527458, -0.00125575, 0.108289, 0.100469,
-0.0694842, 0.0841492, 0.32303, 0.199593, -0.0168043, -0.00444074, 0.423218,
0.137524, -0.0467394, 0.00776669, 0.151014, 0.19008, 0.0505521, 0.00327318,
0.0949606, 0.125157, -0.0277652, -0.0367558, 0.108567, 0.11868, -0.0942212,
-0.000443912, 0.189012, 0.177837, 0.0256825, -0.0204917, 0.112957,
0.111767);
I have attached the LOG file (merovingian.log). I'm not sure what I am
looking for in there, but there doesn't seem to be any major errors sticking
out.
Any thoughts? The set up is "out of the box" as is.
Thanks a million,
Brett
On Thu, Dec 23, 2010 at 3:10 AM, Fabian Groffen wrote:
...
On 23-12-2010 03:04:37 -0500, Brett Spurrier wrote:
...
No, I don't get any distinguishable messages from the server. However,
I am
using merovingian, so everything is in the background. The merovingian
log
file however, is empty.
I guess you mean it doesn't show anything special for you.  This log
should always contain some chattering about when connections are being
made and more.
...
Any other thoughts? At a loss here.
You may hit a stack limit, and get disconnected without warning.
How does INSERT_INTO_STATEMENT look like?
...
MapiHdl query(Mapi dbh, char *q)
{
    MapiHdl ret = NULL;
    if ((ret = mapi_query(dbh, q)) == NULL || mapi_error(dbh) != MOK)
        die(dbh, ret);
    return(ret);
}
void update(Mapi dbh, char *q)
{
    MapiHdl ret = query(dbh, q);
    if (mapi_close_handle(ret) != MOK)
        die(dbh, ret);
}
void main() {
    dbh = mapi_connect("localhost", 50000, "monetdb", "monetdb",
"sql",
"dbname");
    if (mapi_error(dbh)) {
        die(dbh, hdl);
    }
for (int i=0; i< 2500; i++) {
        char *p = INSERT_INTO_STATEMENT;
        update(dbh, p);
    }
}
Does anyone see any reason that the MAPI would choke mid way through
the
For
loop?
Any help would be majorly appreciated. I am at a loss.
------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows
customers
to consolidate database storage, standardize their database environment,
and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users