Hi Robby,

sorry, a very late (probably too late) answer:

On Thu, Oct 10, 2013 at 11:22:26AM -0500, Robby Workman wrote:
> Okay, I'm probably missing something obvious, but any ideas on this?

I don't think you are missing something obvious. On the contrary, I
can't think of a rational reason why this error should occur. It's
definitely not a typical problem you run into...

One possibly related issue I find in Google is this one:
https://bugzilla.redhat.com/show_bug.cgi?id=993532
which is miscompilation of PostgreSQL. There is also a similar report in
a Gentoo forum. 

See comment #8 from Tom Lane:
https://bugzilla.redhat.com/show_bug.cgi?id=993532#c8

Other than that, no idea... But I suppose it's the above issue.

Did you find a solution?
Peter

> mirrorbrain@harrier:~$ mb
> Traceback (most recent call last):
>   File "/usr/bin/mb", line 1645, in <module>
>     r = mirrordoctor.main()
>   File "/usr/lib64/python2.7/site-packages/cmdln.py", line 249, in main
>     self.postoptparse()
>   File "/usr/bin/mb", line 79, in postoptparse
>     self.conn = mb.conn.Conn(self.config.dbconfig, debug = self.options.debug)
>   File "/usr/lib64/python2.7/site-packages/mb/conn.py", line 124, in __init__
>     class Server(SQLObject):
>   File "/usr/lib64/python2.7/site-packages/sqlobject/declarative.py", line 
> 92, in __new__
>     cls.__classinit__(cls, new_attrs)
>   File "/usr/lib64/python2.7/site-packages/sqlobject/main.py", line 789, in 
> __classinit__
>     sqlmeta.addColumnsFromDatabase()
>   File "/usr/lib64/python2.7/site-packages/sqlobject/main.py", line 442, in 
> addColumnsFromDatabase
>     for columnDef in conn.columnsFromSchema(sqlmeta.table, soClass):
>   File 
> "/usr/lib64/python2.7/site-packages/sqlobject/postgres/pgconnection.py", line 
> 279, in columnsFromSchema
>     keyData = self.queryAll(keyQuery % self.sqlrepr(tableName))
>   File "/usr/lib64/python2.7/site-packages/sqlobject/dbconnection.py", line 
> 427, in queryAll
>     return self._runWithConnection(self._queryAll, s)
>   File "/usr/lib64/python2.7/site-packages/sqlobject/dbconnection.py", line 
> 327, in _runWithConnection
>     val = meth(conn, *args)
>   File "/usr/lib64/python2.7/site-packages/sqlobject/dbconnection.py", line 
> 420, in _queryAll
>     self._executeRetry(conn, c, s)
>   File 
> "/usr/lib64/python2.7/site-packages/sqlobject/postgres/pgconnection.py", line 
> 170, in _executeRetry
>     raise InternalError(ErrorMessage(e))
> sqlobject.dberrors.InternalError: wrong number of index expressions
> 
> 
> root@harrier:~# tail -n 2 /var/log/postgresql
> ERROR:  wrong number of index expressions
> STATEMENT:  PREPARE mirrorbrain_dbd_65 (varchar) AS SELECT id, identifier, 
> region, country, lat, lng, asn, prefix, score, baseurl, region_only, 
> country_only, as_only, prefix_only, other_countries, file_maxsize FROM server 
> WHERE id::smallint = any((SELECT mirrors FROM filearr WHERE path = 
> $1)::smallint[]) AND enabled AND status_baseurl AND score > 0
> 
> 
> This is mirrorbrain 2.16.1, for what it's worth.  
> 
> -RW

Attachment: signature.asc
Description: Digital signature

Reply via email to