Hi!

On Fri, Aug 29, 2008 at 4:58 PM, Michael Galloway <mgx AT ornl DOT gov> wrote:
> On Fri, Aug 29, 2008 at 04:48:57PM +0000, Jose Ildefonso Camargo Tolosa wrote:
>> Hi!
>>
>> That is a DB issue, did you correctly tuned pgsql's parameters? I
>> mean, you got plenety of ram, you must tell postgres to use it! (and
>> to use cache).
>>
>
> :-\ its pretty much default paramters.
>
> shared_buffers = 32MB                   # min 128kB or max_connections*16kB
> max_fsm_pages = 204800          # min max_fsm_relations*16, 6 bytes each
>

Not good... not goot at all.... your disk i/o should be HIGH right now :-S .

The DB discussion is off-topic, so we can continue that one off-list.

>
> any suggestions? if i wait long enough i assume it will finish, pending queue
> is getting long:
>
>  1415 Increme  rockhopper.2008-08-24_21.05.46 is waiting on max Storage jobs
>  1416 Increme  mus.2008-08-24_21.05.47 is waiting on max Storage jobs
>  1417 Full    BackupCatalog.2008-08-24_23.10.48 is waiting execution
>  1419 Increme  molbio.2008-08-25_20.05.51 is waiting execution
>  1420 Increme  moldyn.2008-08-25_21.05.52 is waiting execution
>  1421 Increme  rockhopper.2008-08-25_21.05.53 is waiting execution
>  1422 Increme  mus.2008-08-25_21.05.54 is waiting execution
>  1423 Full    BackupCatalog.2008-08-25_23.10.55 is waiting execution
>  1424 Increme  birch.2008-08-25_23.25.56 is waiting execution
>  1425 Increme  bioinfo.2008-08-26_01.05.57 is waiting execution
>  1426 Increme  molbio.2008-08-26_20.05.58 is waiting execution
>  1427 Increme  moldyn.2008-08-26_21.05.59 is waiting execution
>  1428 Increme  rockhopper.2008-08-26_21.05.00 is waiting execution
>  1429 Increme  mus.2008-08-26_21.05.01 is waiting execution
>  1430 Full    BackupCatalog.2008-08-26_23.10.02 is waiting execution
>  1431 Increme  bioinfo.2008-08-27_01.05.03 is waiting execution
>  1432 Increme  molbio.2008-08-27_20.05.05 is waiting execution
>  1433 Increme  mspec.2008-08-27_20.06.06 is waiting execution
>  1434 Increme  moldyn.2008-08-27_21.05.07 is waiting execution
>  1435 Increme  rockhopper.2008-08-27_21.06.08 is waiting execution
>  1436 Increme  mus.2008-08-27_21.06.09 is waiting execution
>  1437 Full    BackupCatalog.2008-08-27_23.10.10 is waiting execution
>  1438 Increme  bioinfo.2008-08-28_01.05.11 is waiting execution
>

I would start canceling jobs, in order to avoid the "duplicates" util
it finish, at that point, optimize DB.

> thanks for any help!
>
> -- michael

NP,

Ildefonso Camargo

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users