Re: PQexecPrepared: ERROR: incorrect binary data format in bind parameter 2

Hi Allan,

Allan Wind wrote:
> postgres@pawan:~$ /usr/sbin/indexer -Eblob
> indexer[11912]: Converting to blob
> indexer[11912]: Loading URL list
> indexer[11912]: Converting intag00
> indexer[11912]: PQexecPrepared: ERROR:  incorrect binary data 
> format in bind parameter 2
> 
> and here is the postgres log event:
> 
> 2010-06-08 04:08:10 UTC ERROR:  incorrect binary data format in 
> bind parameter 2
> 2010-06-08 04:08:10 UTC STATEMENT:  INSERT INTO bdict (word, 
> secno, intag) VALUES($1, $2::integer, $3)
> 2010-06-08 04:08:10 UTC LOG:  unexpected EOF on client connection
> 
> This is with mnogosearch 3.3.8 against postgres 8.4.4.  Any 
> ideas?

Thanks for reporting!

I need some more information:

- What is your OS?

I found this information on
https://fedoraproject.org/wiki/Infrastructure/Search

 >On x86_64 architecture, the x86_64 binary fails when indexing a crawl
 >with the error "indexer[21272]: PQexecPrepared: ERROR: incorrect binary
 >data format in bind parameter 2." The tarball refuses to cross-compile
 >to 32-bit architecture, despite tweaking the ./configure options.
 >Compiling on a 32-bit machine and moving the binaries to the 64-bit
 >machine works.

Are you using x86_64 binary? If so, can you please try this suggestion?

- What is "indexer -S" output?

- Please add DebugSQL=yes into your DBAddr command, so it looks about
   like this:
   DBAddr pgsql://root@/dbname/?DebugSQL=yes
   or
   DBAddr pgsql://root@/dbname/?DBMode=blob&DebugSQL=yes

   then run "indexer -Eblob -v6 &>LOG.txt"

   and send LOG.txt output to [email protected].

Thanks!

> 
> 
> /Allan