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

Hi,

Allan Wind wrote:
> On 2010-06-19T08:40:37, Alexander Barkov wrote:
>> I suggest to try this workaround:
>> https://fedoraproject.org/wiki/Infrastructure/Search
> 
> Unfortunately I do not have a 32 bit machine available to 
> cross-compile on.
> 
>> Or please send send the information I requested in the previous e-mail.
> 
> Sorry, what information was it that you requested again?  I must 
> have overlooked it.
> 
> 
> /Allan


This is a quotation from my letter:

> 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].