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

Hi Allan,

Allan Wind wrote:
> Hi Alexander,
> 
> Thanks again for your help and patience.

Thank you for your patience too.


> 
> On 2010-06-25T11:58:22, Alexander Barkov wrote:
>>> - What is your OS?
> 
> Debian Linux (unstable)
> 
> allan@pawan:~$ cat /etc/debian_version 
> squeeze/sid
> 
> allan@pawan:~$ uname -a
> Linux pawan 2.6.33.2 #1 SMP Thu Apr 8 03:28:55 UTC 2010 x86_64 
> GNU/Linux
> 
>>> Are you using x86_64 binary? If so, can you please try this suggestion?
> 
> Yes:
> 
> root@pawan:/home/allan# file /usr/sbin/indexer 
> /usr/sbin/indexer: ELF 64-bit LSB executable, x86-64, version 1 
> (SYSV), dynamically linked (uses shared libs), for GNU/Linux 
> 2.6.18, stripped
> 
>>> - What is "indexer -S" output?
> 
> # indexer -Edrop
> # indexer -Ecreate
> # indexer -Eblob
> ...
> indexer[10207]: Converting to blob
> indexer[10207]: Loading URL list
> indexer[10207]: Converting intag00
> indexer[10207]: Converting intag01
> indexer[10207]: Converting intag02
> indexer[10207]: Converting intag03
> indexer[10207]: Converting intag04
> indexer[10207]: Converting intag05
> indexer[10207]: Converting intag06
> indexer[10207]: Converting intag07
> indexer[10207]: Converting intag08
> indexer[10207]: Converting intag09
> indexer[10207]: Converting intag0A
> indexer[10207]: Converting intag0B
> indexer[10207]: Converting intag0C
> indexer[10207]: Converting intag0D
> indexer[10207]: Converting intag0E
> indexer[10207]: Converting intag0F
> indexer[10207]: Converting intag10
> indexer[10207]: Converting intag11
> indexer[10207]: Converting intag12
> indexer[10207]: Converting intag13
> indexer[10207]: Converting intag14
> indexer[10207]: Converting intag15
> indexer[10207]: Converting intag16
> indexer[10207]: Converting intag17
> indexer[10207]: Converting intag18
> indexer[10207]: Converting intag19
> indexer[10207]: Converting intag1A
> indexer[10207]: Converting intag1B
> indexer[10207]: Converting intag1C
> indexer[10207]: Converting intag1D
> indexer[10207]: Converting intag1E
> indexer[10207]: Converting intag1F
> indexer[10207]: Total converted: 0 records, 0 bytes
> indexer[10207]: PQexecPrepared: ERROR:  incorrect binary data format in bind parameter 2
> # indexer -S
> root@pawan:/home/allan# indexer -S
> 
>           Database statistics [2010-06-25 12:11:56]
> 
>     Status    Expired      Total
>    -----------------------------
>    -----------------------------
>      Total          0          0
> 
>>> - 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
> 
> Did the latter.
> 
>>>  then run "indexer -Eblob -v6 &>LOG.txt"
>>>
>>>  and send LOG.txt output to [email protected].
> 
> It does not look that interesting but I will send that off in a sec:
> 
> indexer[10262]: Writting '#ts'
> indexer[10262]: PQexecPrepared: ERROR:  incorrect binary data format in bind parameter 2


Can you please rebuild mnogosearch with additional --with-debug flag to 
configure?

So the new build commands will look about like this:
./configure --with-pgsql --with-debug
make
make install


Then please run "indexer -Eblob -v6 &>LOG.txt" again,
it will print all SQL queries to the LOG file,
so we'll see which query generates this error.


I think this is a small bug which will be easy to fix.

Thanks!

> 
>  
> /Allan