store | blogs | forums | twitter | facebook | wiki | downloads | support portal
Atomic Secure Linux
It is currently Wed Aug 21, 2019 3:29 am

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: rsync mysql problem
Unread postPosted: Mon Sep 24, 2012 6:16 am 
Offline
Forum User
Forum User

Joined: Mon Jul 23, 2012 5:22 am
Posts: 60
Location: Salisbury
Just got the msgl dump from my server and wanted to back it up to a second server (I've been doing this before) but this time I get the following error when I use
rsync -v -e ssh mysql_24_09_2012.sql.gz root@plesk2.domain.co.uk:~ command to move it to the second server


mysql_24_09_2012.sql.gz
rsync: writefd_unbuffered failed to write 4 bytes to socket [sender]: Broken pipe (32)
rsync: write failed on "/root/mysql_24_09_2012.sql.gz": No space left on device (28)
rsync error: error in file IO (code 11) at receiver.c(301) [receiver=3.0.6]
rsync: connection unexpectedly closed (28 bytes received so far) [sender]
rsync error: error in rsync protocol data stream (code 12) at io.c(600) [sender=3.0.6]


What could I do?
Thanks


Top
 Profile  
Reply with quote  
 Post subject: Re: rsync mysql problem
Unread postPosted: Mon Sep 24, 2012 7:32 am 
Offline
Long Time Forum Regular
Long Time Forum Regular

Joined: Sat Aug 20, 2005 9:30 am
Posts: 2813
Location: The Netherlands
Quote:
rsync: write failed on "/root/mysql_24_09_2012.sql.gz": No space left on device (28)


Looks like the /root filesystem on plesk2.domain.co.uk is full.

_________________
Lemonbit Internet Dedicated Server Management


Top
 Profile  
Reply with quote  
 Post subject: Re: rsync mysql problem
Unread postPosted: Mon Sep 24, 2012 7:49 am 
Offline
Forum User
Forum User

Joined: Mon Jul 23, 2012 5:22 am
Posts: 60
Location: Salisbury
Does that mean all our server is full?
How can we check that?

Does it mean we need to remove things and that's the only option ?

Thanks


Top
 Profile  
Reply with quote  
 Post subject: Re: rsync mysql problem
Unread postPosted: Mon Sep 24, 2012 8:03 am 
Offline
Long Time Forum Regular
Long Time Forum Regular

Joined: Sat Aug 20, 2005 9:30 am
Posts: 2813
Location: The Netherlands
mist_firefly wrote:
Does that mean all our server is full?


Note necessarily. It could be that /root is a separate filesystem.

mist_firefly wrote:
How can we check that?


For instance by running df -h on the server.

mist_firefly wrote:
Does it mean we need to remove things and that's the only option ?


Maybe the server has multiple filesystems and others might have more space available. You could then rsync the file to another filesystem.

_________________
Lemonbit Internet Dedicated Server Management


Top
 Profile  
Reply with quote  
 Post subject: Re: rsync mysql problem
Unread postPosted: Mon Sep 24, 2012 8:28 am 
Offline
Forum User
Forum User

Joined: Mon Jul 23, 2012 5:22 am
Posts: 60
Location: Salisbury
Thanks for the help

I did a df -h and got the following


Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
225G 225G 0 100% /
/dev/sda1 99M 32M 63M 34% /boot
tmpfs 3.0G 0 3.0G 0% /dev/shm
tmpfs 3.0G 0 3.0G 0% /usr/local/psa/handlers/before-local
tmpfs 3.0G 0 3.0G 0% /usr/local/psa/handlers/before-queue
tmpfs 3.0G 0 3.0G 0% /usr/local/psa/handlers/before-remote
tmpfs 3.0G 7.5M 3.0G 1% /usr/local/psa/handlers/info
tmpfs 3.0G 0 3.0G 0% /usr/local/psa/handlers/spool


Could you please help me read this. (does it mean my root is 225 G and it's full and the rest of the directories are only 3 G?)
On our server we have more file systems but they don't seem to show on this list. (or maybe I'm just reading it wrong)


Top
 Profile  
Reply with quote  
 Post subject: Re: rsync mysql problem
Unread postPosted: Mon Sep 24, 2012 9:02 am 
Offline
Long Time Forum Regular
Long Time Forum Regular

Joined: Sat Aug 20, 2005 9:30 am
Posts: 2813
Location: The Netherlands
mist_firefly wrote:
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
225G 225G 0 100% /
/dev/sda1 99M 32M 63M 34% /boot
tmpfs 3.0G 0 3.0G 0% /dev/shm
tmpfs 3.0G 0 3.0G 0% /usr/local/psa/handlers/before-local
tmpfs 3.0G 0 3.0G 0% /usr/local/psa/handlers/before-queue
tmpfs 3.0G 0 3.0G 0% /usr/local/psa/handlers/before-remote
tmpfs 3.0G 7.5M 3.0G 1% /usr/local/psa/handlers/info
tmpfs 3.0G 0 3.0G 0% /usr/local/psa/handlers/spool


Could you please help me read this. (does it mean my root is 225 G and it's full and the rest of the directories are only 3 G?)


This indeed says that the / filesystem is 225 GB and completely full, so you'll need to free up some space by deleting files. The tmpfs filesystems are in-memory filesystems created by Plesk.

mist_firefly wrote:
On our server we have more file systems but they don't seem to show on this list. (or maybe I'm just reading it wrong)


The output of df shows all filesystems by default. What other filesystems do you think you have? Maybe they are not mounted?

_________________
Lemonbit Internet Dedicated Server Management


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group