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

Hi Alexander,

Thanks again for your help and patience.

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

 
/Allan
-- 
Allan Wind
Life Integrity, LLC
<http://lifeintegrity.com>