Sql connnection issue

[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

[slansing]

Ah, what is the output of:

Code: Select all

df -h

top | head -6

free -m

[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

[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

[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

[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?

Code: Select all

df -i

[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

[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]

[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.

[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.