On Thu, Dec 23, 2010 at 2:58 AM, Fabian Groffen <Fabian.Groffen@cwi.nl> wrote:

On 23-12-2010 02:43:05 -0500, Brett Spurrier wrote:
> Hi all,
> I am having a bit of trouble and I am hoping a seasoned MonetDB expert can
> lend some advice.
>
> I am using the MAPI interface in my C/C++ application to talk to my MonetDB
> instance.
> I have a recursive INSERT INTO statement which populates the database, and
> it initially works pretty well.
>
> However, as I populate more (past 200 inserts in my case), I get a MAPI
> error (exampled by: mapi_explain_result()):
>
> MAPI = monetdb@localhost:50000
> ACTION= mapi_start_talking
> ERROR = !Connection terminated
>
> No real reason as to why. Has anyone seen this before?

Are there any messages from the server? You get disconnected here. It
may be that the server is kicking you out somehow.

> My code:
>
> 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