Re: [mirrorbrain] wrong number of index expressions ?

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_at_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_at_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


_______________________________________________
mirrorbrain mailing list
Archive: http://mirrorbrain.org/archive/mirrorbrain/

Note: To remove yourself from this mailing list, send a mail with the content
 	unsubscribe
to the address mirrorbrain-request_at_mirrorbrain.org