Package: whohas
Version: 0.23-2
Severity: important

For some queries whohas causes my machine (with 1.5GB RAM) to enter swap
hell. As an example it uses over a gigabyte of ram for 'whohas sqlite'.

$ top -cb | grep -v grep | grep whohas
13853 pabs      20   0  535m 133m 2388 S   63  8.9   0:01.91 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  541m 151m 2568 S   16 10.1   0:02.38 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  541m 152m 2576 S    8 10.2   0:02.62 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  702m 282m 2576 S   50 18.8   0:04.12 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0 1125m 462m 2576 S   60 30.8   0:05.93 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0 1125m 462m 2576 S    4 30.9   0:06.05 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0 1125m 462m 2576 S    4 30.9   0:06.18 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0 1125m 462m 2576 S    4 30.9   0:06.29 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0 1125m 462m 2576 S    1 30.9   0:06.32 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0 1294m 541m 2576 S   36 36.1   0:07.40 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0 1183m 547m 2576 S   26 36.5   0:08.18 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0 1135m 547m 2576 S    6 36.5   0:08.36 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0 1094m 546m 2576 S    8 36.4   0:08.61 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  998m 546m 2576 S   12 36.4   0:08.97 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  958m 546m 2576 S    6 36.4   0:09.15 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  918m 546m 2576 S    9 36.4   0:09.41 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  886m 545m 2576 S    5 36.4   0:09.56 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  886m 545m 2576 S    0 36.4   0:09.56 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  830m 545m 2576 S    8 36.4   0:09.79 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  830m 545m 2576 S    1 36.4   0:09.81 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  830m 545m 2576 S    1 36.4   0:09.83 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  830m 545m 2576 S    1 36.4   0:09.87 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  830m 545m 2576 S    1 36.4   0:09.90 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  830m 545m 2576 S    1 36.4   0:09.94 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  830m 545m 2576 S    0 36.4   0:09.94 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  830m 545m 2576 S    2 36.4   0:09.99 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  830m 545m 2576 S    1 36.4   0:10.02 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  830m 545m 2576 S    1 36.4   0:10.04 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  830m 545m 2576 S    0 36.4   0:10.04 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  830m 545m 2576 S    1 36.4   0:10.08 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  830m 545m 2576 S    1 36.4   0:10.12 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  830m 545m 2576 S    0 36.4   0:10.13 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  830m 545m 2576 S    1 36.4   0:10.15 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  830m 545m 2576 S    1 36.4   0:10.17 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  830m 545m 2576 S    1 36.4   0:10.19 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  830m 545m 2576 S    1 36.4   0:10.21 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  830m 545m 2576 S    0 36.4   0:10.21 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  830m 545m 2576 S    1 36.4   0:10.24 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  830m 545m 2576 S    0 36.4   0:10.24 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  830m 545m 2576 S    1 36.4   0:10.26 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  833m 548m 2576 S    1 36.5   0:10.28 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  833m 548m 2576 S    0 36.5   0:10.28 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  833m 548m 2576 S    9 36.6   0:10.54 /usr/bin/perl 
/usr/bin/whohas sqlite
13853 pabs      20   0  777m 541m 2576 S   17 36.1   0:11.04 /usr/bin/perl 
/usr/bin/whohas sqlite

-- System Information:
Debian Release: 5.0
  APT prefers stable
  APT policy: (800, 'stable'), (700, 'testing'), (600, 'unstable'), (550, 
'experimental')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.26-1-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages whohas depends on:
ii  libwww-perl                   5.813-1    WWW client/server library for Perl
ii  libxml-simple-perl            2.18-1     Perl module for reading and writin
ii  perl                          5.10.0-19  Larry Wall's Practical Extraction 

-- 
bye,
pabs

http://wiki.debian.org/PaulWise

Attachment: signature.asc
Description: This is a digitally signed message part

Reply via email to