[Systems] mirrorbrain - sugarlabs - sql lookup error

[David Farning]

Peter, I installed mirror brain on our production server yesterday.  I
did not realize that it is blend of 8.10 and 9.04 package.

Judging form the log files it looks like either mod_mirrorbrain of the
is chopping the several character form the beginning of the string it
is searching in the database.  (below are sample snippets from a
broken installation and from a good test installation.


Doing mb fileprobe from the command line works correctly

mirrorbrain at sunjammer:/var/log/apache2$ mb probefile
/beagleboard/libhippocanvas-1-0_0.3.0-r0_armv7a.ipk
.
1 download2
http://download2.sugarlabs.org/beagleboard/libhippocanvas-1-0_0.3.0-r0_armv7a.ipk
http=200
Found: 1


thanks
david

---- snippet from error_log on broken installation----
[Sun Oct 11 12:46:08 2009] [warn] [client 207.118.255.6]
[mod_mirrorbrain] MirrorBrainEngine On, mirror_base
'/var/www-sugarlabs/download/'
[Sun Oct 11 12:46:08 2009] [warn] [client 207.118.255.6]
[mod_mirrorbrain] URI:
'/beagleboard/libhippocanvas-1-0_0.3.0-r0_armv7a.ipk?mirrorlist'
[Sun Oct 11 12:46:08 2009] [warn] [client 207.118.255.6]
[mod_mirrorbrain] filename:
'/var/www-sugarlabs/download/beagleboard/libhippocanvas-1-0_0.3.0-r0_armv7>
[Sun Oct 11 12:46:08 2009] [error] [client 207.118.255.6]
[mod_mirrorbrain] could not resolve continent
[Sun Oct 11 12:46:08 2009] [warn] [client 207.118.255.6]
[mod_mirrorbrain] Country 'US', Continent '--'
[Sun Oct 11 12:46:08 2009] [warn] [client 207.118.255.6]
[mod_mirrorbrain] AS '--', Prefix '--'
[Sun Oct 11 12:46:08 2009] [warn] [client 207.118.255.6]
[mod_mirrorbrain] Successfully acquired database connection.
[Sun Oct 11 12:46:08 2009] [warn] [client 207.118.255.6]
[mod_mirrorbrain] SQL lookup for (canonicalized)
'ippocanvas-1-0_0.3.0-r0_armv7a.ipk'
[Sun Oct 11 12:46:08 2009] [info] [client 207.118.255.6]
[mod_mirrorbrain] no mirrors found for
ippocanvas-1-0_0.3.0-r0_armv7a.ipk
[Sun Oct 11 12:46:08 2009] [warn] [client 207.118.255.6]
[mod_mirrorbrain] empty mirrorlist


---- snippet from error_log on good installation----
[Sun Oct 11 12:07:09 2009] [warn] [client 207.118.255.6]
[mod_mirrorbrain] MirrorBrainEngine On, mirror_base
'/var/www/downloads/'
[Sun Oct 11 12:07:09 2009] [warn] [client 207.118.255.6]
[mod_mirrorbrain] URI:
'/beagleboard/libhippocanvas-1-0_0.3.0-r0_armv7a.ipk?mirrorlist'
[Sun Oct 11 12:07:09 2009] [warn] [client 207.118.255.6]
[mod_mirrorbrain] filename:
'/var/www/downloads/beagleboard/libhippocanvas-1-0_0.3.0-r0_armv7a.ipk'
[Sun Oct 11 12:07:09 2009] [warn] [client 207.118.255.6]
[mod_mirrorbrain] Country 'US', Continent 'NA'
[Sun Oct 11 12:07:09 2009] [warn] [client 207.118.255.6]
[mod_mirrorbrain] AS '--', Prefix '--'
[Sun Oct 11 12:07:09 2009] [warn] [client 207.118.255.6]
[mod_mirrorbrain] Successfully acquired database connection.
[Sun Oct 11 12:07:09 2009] [warn] [client 207.118.255.6]
[mod_mirrorbrain] SQL lookup for (canonicalized)
'beagleboard/libhippocanvas-1-0_0.3.0-r0_armv7a.ipk'
[Sun Oct 11 12:07:09 2009] [warn] [client 207.118.255.6]
[mod_mirrorbrain] Found 2 mirrors
[Sun Oct 11 12:07:09 2009] [warn] [client 207.118.255.6]
[mod_mirrorbrain] same country: download2.sugarlabs.org        (score
100) (rank    7372869)
[Sun Oct 11 12:07:09 2009] [warn] [client 207.118.255.6]
[mod_mirrorbrain] same country: download.sugarlabs.org         (score
100) (rank    7813338)
[Sun Oct 11 12:07:09 2009] [warn] [client 207.118.255.6]
[mod_mirrorbrain] Found 2 mirrors: 0 prefix, 0 AS, 2 country, 0
region, 0 elsewhere
[Sun Oct 11 12:07:09 2009] [warn] [client 207.118.255.6]
[mod_mirrorbrain] Sending mirrorlist