Page 2 of 2
Re: Sql connnection issue
Posted: Tue Apr 22, 2014 7:57 am
by tgfde
Seeing the following in the /var/lib/pgsql/pgstartup.log...
G: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log fi
Re: Sql connnection issue
Posted: Tue Apr 22, 2014 9:15 am
by slansing
Ah, what is the output of:
Re: Sql connnection issue
Posted: Tue Apr 22, 2014 12:36 pm
by tgfde
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
28G 5.4G 22G 21% /
/dev/sda1 99M 25M 70M 26% /boot
tmpfs 1014M 0 1014M 0% /dev/shm
You have new mail in /var/spool/mail/root
top | head -6
top - 12:35:09 up 20:35, 2 users, load average: 1.79, 0.94, 0.73
Tasks: 160 total, 1 running, 159 sleeping, 0 stopped, 0 zombie
Cpu(s): 6.1%us, 0.5%sy, 0.0%ni, 93.0%id, 0.3%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 2075024k total, 1214296k used, 860728k free, 158612k buffers
Swap: 1048568k total, 0k used, 1048568k free, 674332k cached
free -m
total used free shared buffers cached
Mem: 2026 1186 839 0 154 658
-/+ buffers/cache: 372 1653
Swap: 1023 0 1023
Re: Sql connnection issue
Posted: Tue Apr 22, 2014 1:42 pm
by lmiltchev
Can you restart the postgres, tail the log and show us the output?
Code: Select all
service postgresql restart
tail -50 /var/lib/pgsql/pgstartup.log
Re: Sql connnection issue
Posted: Tue Apr 22, 2014 2:26 pm
by tgfde
Code: Select all
LOG: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write to log file: No space LOG: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
Re: Sql connnection issue
Posted: Tue Apr 22, 2014 3:18 pm
by abrist
1) How did you install XI, or more specifically postgres?
2) Are you using an internal corporate repo?
3) Could you have quotas set for postgres users?
4) Have you run out of inodes?
Re: Sql connnection issue
Posted: Tue Apr 22, 2014 3:20 pm
by tgfde
1. vmware install - everything was pre-installed.
2. no
3. no
4. not sure
df -i
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/mapper/VolGroup00-LogVol00
7569408 95921 7473487 2% /
/dev/sda1 26104 47 26057 1% /boot
tmpfs 223860 1 223859 1% /dev/shm
Re: Sql connnection issue
Posted: Tue Apr 22, 2014 3:27 pm
by abrist
This is just strange. Lets move this to the ticket system so that we can schedule a remote session. Send an email (from your registered email address) to
[email protected]
Re: Sql connnection issue
Posted: Tue Apr 22, 2014 4:03 pm
by tgfde
FYI.
I rebooted the Nagios host and everything seems to be working again. However, this is the same time that everything was working fine yesterday and it failed again at 5pm. We'll monitor and get back to you tomorrow. I will send an email to support if it fails again.
Thanks for the help.
Re: Sql connnection issue
Posted: Tue Apr 22, 2014 4:22 pm
by abrist
Great. I will lock this thread for now. If you need to end up emailing the ticket system, link this thread and call me out by name (Andy). We will fast track you to a remote session.