pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dima Tkach <dmitry@openratings.com>
To: Dmitry Tkach <dmitry@openratings.com>
Subject: Re: Debugging C functions...
Date: Sat, 16 Mar 2002 00:26:52 -0500
Message-ID: <3C92D79C.9020306@openratings.com> (raw)
References: <3C92A827.6050409@openratings.com>

Ok, never mind - I got it :-)
I should be 8*sizeof(long) in the array declaration...
Ahh.. sorry for such a stupid question...

Dima

Dmitry Tkach wrote:
> Hi, everybody!
> 
> Here is me again, with my bitwise indexing troubles :-)
> (Refer to btree index extension topic from yesterday)...
> 
> I have, pretty much, given up the idea to make btrees (or rtrees) do 
> what I need... now I am trying to make it work with a GiST index (as Tom 
> Lane suggested earlier)... Because I am too stupid and too lazy to 
> figure out how to implement GiST from scratch, I am trying to use the 
> intarray code from contrib - it seems to do exactly what I need, except 
> it deals with _int4 arrays instead of bitsets.
> 
> So, I wrote a C function called pack (should be unpack really, but never 
> mind :-), that converts my bits into an array, and try to index my table:
> 
> create index bset_idx on bset using gist  (pack (flags));
> 
> this runs for a few minutes, and then the backend crashes. All I can see 
> in the log is:
> 
> ----
> Server process (pid 29372) exited with status 11 at Fri Mar 15 18:33:50 2002
> Terminating any active server processes...
> Server processes were terminated at Fri Mar 15 18:33:50 2002
> Reinitializing shared memory and semaphores
> The Data Base System is starting up
> ----
> 
> I assume, there must be some bug in the func. I wrote, that's causing 
> the crash... The question is - how do I debug it?
> Are there some techniques to do that (like attaching to the running 
> backend with a debugger, or something else, perhaps, somehow turning  
> more debug output on)?
> 
> Below is the entire C code I wrote (I am attaching it, hoping, that, 
> perhaps, somebody would be able to just spot the problem by looking at 
> it)... It creates one function, that takes an int4 (the bits) and a 
> second arg, being the maximum bit, that can be set (this is to be able 
> to work with both int2 and int4)...
> And then I have sql wrappers:
> 
> create function pack(int4) returns _int4 as 'select pack($1, 1<<31);' 
> language 'sql';
> create function pack(int2) returns _int4 as 'select pack($1::int4, 
> 1<<15);' language 'sql';
> 
> Here is the C source:
> 
> 
> #include "postgres.h"
> #include "utils/array.h"
> 
> ArrayType *pack(int,long);
> ArrayType *wrap_array(void *, int, int);
> 
> ArrayType *pack (int bits, long max)
> {
>   static int4 buff [sizeof (long)];
>   long b;
>   int count;
> 
>   for (b = 1, count = 0;  b <= max; b <<= 1)
>     if (bits & b)
>       buff [count++] = b;
>   return wrap_array (buff, count, sizeof(int4));
> }
> 
> ArrayType *wrap_array (void *ptr, int alen, int elen)
> {
>   int numbytes = alen*elen;
>   int sz = numbytes + ARR_OVERHEAD (1);
>   ArrayType *result = (ArrayType *) palloc (sz);
>   result -> size = sz;
>   result -> ndim = 1;
>   result -> flags = 0;
>   ARR_DIMS(result)[0] = alen;
>   ARR_LBOUND(result)[0] = 1;
>   memmove (ARR_DATA_PTR(result), ptr, numbytes);
>   return result;
> }
> 
> I compile it with:
> gcc -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -I. 
> -I../../src/include  -DPGSQL71  -c _bits.c -o _bits.o
> 
> I will greatly appreciate your responses...
> 
> Thanks a lot!
> 
> Dima
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 





view thread (2+ messages)

Message-ID: <3C92D79C.9020306@openratings.com>
Permalink:  ../3C92D79C.9020306@openratings.com/
Also on:    postgresql.org/message-id/3C92D79C.9020306@openratings.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: dmitry@openratings.com
  Subject: Re: Debugging C functions...
  In-Reply-To: <3C92D79C.9020306@openratings.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox