Bug#581446: indexer[16908]: PQexecPrepared: ERROR: incorrect binary data format in bind parameter 2
Package: mnogosearch-pgsql
Version: 3.3.8-2+b1
Severity: important
I am getting the following error against both postgressql 8.3 and 8.4:
root@pawan:/var/log/postgresql# indexer -Eblob
indexer[16908]: Converting to blob
indexer[16908]: Loading URL list
indexer[16908]: Converting intag00
indexer[16908]: Converting intag01
indexer[16908]: Converting intag02
indexer[16908]: Converting intag03
indexer[16908]: Converting intag04
indexer[16908]: Converting intag05
indexer[16908]: Converting intag06
indexer[16908]: Converting intag07
indexer[16908]: Converting intag08
indexer[16908]: Converting intag09
indexer[16908]: Converting intag0A
indexer[16908]: Converting intag0B
indexer[16908]: Converting intag0C
indexer[16908]: Converting intag0D
indexer[16908]: Converting intag0E
indexer[16908]: Converting intag0F
indexer[16908]: Converting intag10
indexer[16908]: Converting intag11
indexer[16908]: Converting intag12
indexer[16908]: Converting intag13
indexer[16908]: Converting intag14
indexer[16908]: Converting intag15
indexer[16908]: Converting intag16
indexer[16908]: Converting intag17
indexer[16908]: Converting intag18
indexer[16908]: Converting intag19
indexer[16908]: Converting intag1A
indexer[16908]: Converting intag1B
indexer[16908]: Converting intag1C
indexer[16908]: Converting intag1D
indexer[16908]: Converting intag1E
indexer[16908]: Converting intag1F
indexer[16908]: Total converted: 0 records, 0 bytes
indexer[16908]: PQexecPrepared: ERROR: incorrect binary data format in
bind parameter 2
with this DBAddr in indexer.conf:
DBAddr pgsql://mnogosearch:mnogosearch@/mnogosearch/?dbmode=blob
Changing dbmode to single (or multi) does not change things for the
better:
root@pawan:/var/log/postgresql# indexer -Eblob
indexer[18746]: Converting to blob
indexer[18746]: Loading URL list
indexer[18746]: PQexecPrepared: ERROR: incorrect binary data format in
bind parameter 2
I tried setting array_null to on, off, backslash_quote to on, off, and
safe_encoding in postgresql.conf, restart, then rerunning indexer -Eblob
but did not see any difference.
-- System Information:
Debian Release: squeeze/sid
APT prefers unstable
APT policy: (500, 'unstable'), (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.33.2 (SMP w/8 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages mnogosearch-pgsql depends on:
ii libc6 2.10.2-8 Embedded GNU C Library: Shared lib
ii libpq5 8.4.3-1 PostgreSQL C client library
ii libssl0.9.8 0.9.8n-1 SSL shared libraries
ii mnogosearch-common 3.3.8-2 full-featured web search engine (c
ii postgresql-client 8.4.3-1 front-end programs for PostgreSQL
ii postgresql-client-8.4 [ 8.4.3-1 front-end programs for PostgreSQL
ii zlib1g 1:1.2.3.4.dfsg-3 compression library - runtime
mnogosearch-pgsql recommends no packages.
Versions of packages mnogosearch-pgsql suggests:
ii postgresql 8.4.3-1 object-relational SQL database (su
-- no debconf information
Reply to: