[Bucardo-general] ERROR No space left on device

[Kiriakos Tsourapas]

Hi,

I have a master-master replication working fine for about a month now.
Today, it stopped working with the following error :

Jun 28 11:40:23 lydia Bucardo[18281]: KID Kid exiting at cleanup_kid. Sync "MassSMs", Target "Athina_MassSMs" public.flights Reason: DBD::Pg::st execute failed: ERROR:  could not write to hash-join temporary file: No space left on device at /usr/lib/perl5/site_perl/5.10.0/Bucardo.pm line 4548.  main error: none source error: none target error: 7 States://53100

It looks like there is no space left somewhere but I don't know where Bucardo is writing and where to free up space.

This is my df -h output :
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/system_8811-LogVol1
                     2.9G  1.6G  1.2G  58% /
udev                  3.9G  428K  3.9G   1% /dev
/dev/sda2             198M   60M  129M  32% /boot
/dev/mapper/system_8811-LogVol2
                     504M   18M  462M   4% /tmp
/dev/mapper/system_8811-LogVol5
                      46G  4.1G   39G  10% /usr
/dev/mapper/system_8811-LogVolHome
                      25G  1.1G   23G   5% /home
/dev/mapper/system_8811-LogVol4
                     2.0G  796M  1.1G  43% /var
/dev/sdb1             4.5T  116G  4.2T   3% /local

The line 4548 of Bucardo.pm :
                                if ($synctype eq 'swap') {
line 4548 :                     $deltacount{alltarget} += $deltacount{target}{$S}{$T} = $sth{target}{$g}{getdelta}->execute();
                                        $sth{target}{$g}{getdelta}->finish() if $deltacount{target}{$S}{$T} =~ s/0E0/0/o;
                                        $self->glog(qq{Target delta count for $S.$T: $deltacount{target}{$S}{$T}}, 6);
                                }


Waiting for your suggestions !


Best regards,
Kiriakos Tsourapas

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20100628/1cd0671d/attachment.html