Randomly no connection to internet websites but could ping urls works.

Hi guys.
I know there are some thread similar, but this one is different and very strange.

Randomly, once or twice a day, for about one to 5 minutes, we are loosing connection to internet.
Right after that time every thing go back to normal again.

Few thing to noticed:

1. We still can ping Urls

2. DNS seems to work.

3. Accessing URL which are in the DMZ doesn't work as well.

4. I'm not sure if there are more fore shorter time, but this what i know of from my customers.

 

Any help will be appreciate.
[:)]

Goldy

Parents
  • Shalom Goldy,

    1. Not sure what you mean.  Are these pings to FQDNs on the Internet?

    2. My gut feeling is that cached FQDNs work but that your ISP has a problem and will not allow resolution of un-cached FQDNs.  How is DNS configured compared to DNS best practice?

    3. Are you running split DNS?  Is the Internal-to-DMZ traffic handled by the UTM's web proxy?

    4. Is this happening at multiple locations?

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
  • Hi Bob.
    [:)]

    1. Ping to 8.8.8.8 or Youtube (for example) works.

    2. I don't think it's DNS issue sins dns work fine and resolving are ok. (Ping - google.com, Nslookup...)

    3. strangely, it's comes and go randomly, and for about few seconds to 2 minutes.

    4. When it's happens, it's effect all my Lan.

    5. When it's happens, I can't connect connect to the firewall (web) eather.

    6. When it's happens, I can't connect to to the web service of my mail (In the DMZ).

    7. In all cases, ping still works fine.

    It seems kind of issue with the TCP, since ICMP works.
    Very strange :)

    Thanks

    Yaron Gold

     

  • What does Sophos Support say about this strange phenomenon, Yaron?

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
  • The don't for now. [:D]

    Right now they try to resolve first another issue:

    Root partition is filling up - please check. Current usage: 85%
    HA Status          : HA SLAVE (node id: 2)

    This is something to do with  Postgres in my SLAVE device.
    (That what they think).

    Maybe i'ts all connected.

    I hop so...

  • What version are you on?

    What result do you get from the following?  Also, run the same command after switching to the Slave with ha_utils ssh.

    du -shx /var/storage/* | sort -rh | head -10

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
  • Hi Bob.

    9.703-3

    > 3.1G    /var/storage/swapfile
    > 701M    /var/storage/chroot-http
    > 132M    /var/storage/chroot-clientlessvpn
    > 94M     /var/storage/chroot-smtp
    > 29M     /var/storage/chroot-revers
    > 17M     /var/storage/chroot-pop3
    > 3.9M    /var/storage/chroot-ftp
    > 16K
    > 16K     /var/storage/agent
    > 4.0K    /var/storage/pgsql92

     

    [Y]

  • Looks good.  What about on the Slave?

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
  • We are having the exact same issue. Several times a week the webproxy stops working and people are unable to browse the web. The webproxy log shows this when it happens, no other traffic is logged.

     

    2020:07:17-16:44:12 firewall-1 httpproxy[7061]: id="0003" severity="info" sys="SecureWeb" sub="http" request="(nil)" function="confd_config_reload_func" file="confd-client.c" line="658" message="reloading config done, new version 30092"

    2020:07:17-16:45:23 firewall-1 httpproxy[7061]: id="0003" severity="info" sys="SecureWeb" sub="http" request="(nil)" function="confd_config_reload_func" file="confd-client.c" line="594" message="reloading config"

    2020:07:17-16:45:24 firewall-1 httpproxy[7061]: id="0003" severity="info" sys="SecureWeb" sub="http" request="(nil)" function="confd_config_reload_func" file="confd-client.c" line="658" message="reloading config done, new version 30094"

    2020:07:17-16:45:36 firewall-1 httpproxy[7061]: id="0003" severity="info" sys="SecureWeb" sub="http" request="(nil)" function="confd_config_reload_func" file="confd-client.c" line="594" message="reloading config"

    2020:07:17-16:45:36 firewall-1 httpproxy[7061]: id="0003" severity="info" sys="SecureWeb" sub="http" request="(nil)" function="confd_config_reload_func" file="confd-client.c" line="658" message="reloading config done, new version 30095"

    2020:07:17-16:45:56 firewall-1 httpproxy[7061]: id="0003" severity="info" sys="SecureWeb" sub="http" request="(nil)" function="confd_config_reload_func" file="confd-client.c" line="594" message="reloading config"

    2020:07:17-16:45:57 firewall-1 httpproxy[7061]: id="0003" severity="info" sys="SecureWeb" sub="http" request="(nil)" function="confd_config_reload_func" file="confd-client.c" line="658" message="reloading config done, new version 30096"

    2020:07:17-16:45:58 firewall-1 httpproxy[7061]: id="0003" severity="info" sys="SecureWeb" sub="http" request="(nil)" function="confd_config_reload_func" file="confd-client.c" line="594" message="reloading config"

    2020:07:17-16:45:59 firewall-1 httpproxy[7061]: id="0003" severity="info" sys="SecureWeb" sub="http" request="(nil)" function="confd_config_reload_func" file="confd-client.c" line="658" message="reloading config done, new version 30097"

    2020:07:17-16:46:22 firewall-1 httpproxy[7061]: id="0003" severity="info" sys="SecureWeb" sub="http" request="(nil)" function="confd_config_reload_func" file="confd-client.c" line="594" message="reloading config"

    2020:07:17-16:46:23 firewall-1 httpproxy[7061]: id="0003" severity="info" sys="SecureWeb" sub="http" request="(nil)" function="confd_config_reload_func" file="confd-client.c" line="658" message="reloading config done, new version 30100"

    after about 5 minutes the proxy is working again without me doing anything and people are able to browse the internet again. During the webproxy outage all other traffic (firewall and NAT rules) is working fine.

    running version 9.703-3

    space on master and slave:

    <M> firewall:/home/login # du -shx /var/storage/* | sort -rh | head -10
    13G /var/storage/chroot-http
    3.8G /var/storage/pgsql92
    3.1G /var/storage/swapfile
    291M /var/storage/logfilter
    144M /var/storage/cores
    95M /var/storage/chroot-smtp
    94M /var/storage/chroot-reverseproxy
    88M /var/storage/chroot-clientlessvpn
    18M /var/storage/chroot-pop3
    7.9M /var/storage/samba
    <M> firewall:/home/login # ha_utils ssh

    <S> firewall:/home/login # du -shx /var/storage/* | sort -rh | head -10
    3.8G /var/storage/pgsql92
    3.1G /var/storage/swapfile
    947M /var/storage/chroot-http
    289M /var/storage/logfilter
    168M /var/storage/cores
    125M /var/storage/WAF20181030.pcap
    108M /var/storage/WAF.pcap
    92M /var/storage/chroot-smtp
    88M /var/storage/chroot-clientlessvpn
    73M /var/storage/chroot-reverseproxy
    <S> firewall:/home/login #

    Franc.

  • Hoi Franc,

    About four years ago, member Adam Mickiewicz reported a similar reload issue.  He found that the reloads were caused by DNS Host and DNS Group definitions in the Transparent Mode Skiplist re-resolving near the same time.  Could this be your issue?

    What do you learn from the following compared to your log lines above?

    zgrep '17\-16\:45' /var/log/confd/2020/07/*17*|grep resolve|grep -oP 'objname=".*?"'|sort -n|uniq -c

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
  • Hoi Bob,

    here are the results of your command:

    <M> firewall:/home/login # zgrep '17\-16\:45' /var/log/confd/2020/07/*17*|grep resolve|grep -oP 'objname=".*?"'|sort -n|uniq -c
    1 objname="iprep4.t.ctmail.com"
    <M> firewall:/home/login #

    Groeten,

    Fanc.

Reply Children
  • Checked it also:

    1 objname="iprep4.t.ctmail.com"
          1 objname="microsoft_9"

  • Sounds like both of you guys should get a case open with Sophos Support.

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
  • We already have. Sophos is taking a look next week.

  • Thanks Bob.

    Already did.[:)]

     

    I'll inform you when something new will come up.

  • Hi Franc.

    Could you please check the root partition to see how full it is?
    Together with the above issue, we are having "Root partition is filling up - please check. Current usage: 86%".
    I'm suspect it's related to the the connections issue.
    The blame seems on Postgress.DB, but we don't know why.

  • It looks like Franc has a problem with PostgreSQL on his Slave, Yaron.  Did you check your Slave as above?  What do you guys see from the following?

    ll /var/storage/pgsql92/data/pg_xlog

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
  • Hi,

    I'm not getting those root error message.

     

    DF on master:


    <M> firewall:/home/login # df -h
    Filesystem Size Used Avail Use% Mounted on
    /dev/sda6 5.2G 3.0G 1.9G 62% /
    udev 5.9G 100K 5.9G 1% /dev
    tmpfs 5.9G 52K 5.9G 1% /dev/shm
    /dev/sda1 331M 16M 295M 5% /boot
    /dev/sda5 62G 20G 39G 34% /var/storage
    /dev/sda7 81G 54G 23G 71% /var/log
    /dev/sda8 3.5G 127M 3.2G 4% /tmp
    /dev 5.9G 100K 5.9G 1% /var/storage/chroot-clientlessvpn/dev
    tmpfs 5.9G 0 5.9G 0% /var/sec/chroot-httpd/dev/shm
    /dev 5.9G 100K 5.9G 1% /var/sec/chroot-openvpn/dev
    /dev 5.9G 100K 5.9G 1% /var/sec/chroot-ppp/dev
    /dev 5.9G 100K 5.9G 1% /var/sec/chroot-pppoe/dev
    /dev 5.9G 100K 5.9G 1% /var/sec/chroot-pptp/dev
    /dev 5.9G 100K 5.9G 1% /var/sec/chroot-pptpc/dev
    /dev 5.9G 100K 5.9G 1% /var/sec/chroot-restd/dev
    tmpfs 5.9G 0 5.9G 0% /var/storage/chroot-reverseproxy/dev/shm
    /opt/tmpfs 5.2G 3.0G 1.9G 62% /var/sec/chroot-httpd/opt/tmpfs
    /etc/nwd.d/route 5.2G 3.0G 1.9G 62% /var/sec/chroot-ipsec/etc/nwd.d/route
    /var/storage/chroot-smtp/spool 62G 20G 39G 34% /var/sec/chroot-httpd/var/spx/spool
    /var/storage/chroot-smtp/spx 62G 20G 39G 34% /var/sec/chroot-httpd/var/spx/public/images/spx
    tmpfs 5.9G 308K 5.9G 1% /var/storage/chroot-http/tmp
    /var/sec/chroot-afc/var/run/navl 5.2G 3.0G 1.9G 62% /var/storage/chroot-http/var/run/navl
    tmpfs 5.9G 188K 5.9G 1% /var/storage/chroot-smtp/tmp/ram

    On slave:

    <S> firewall:/home/login # df -h
    Filesystem Size Used Avail Use% Mounted on
    /dev/sda6 5.2G 3.0G 1.9G 62% /
    udev 5.9G 100K 5.9G 1% /dev
    tmpfs 5.9G 52K 5.9G 1% /dev/shm
    /dev/sda1 331M 16M 295M 5% /boot
    /dev/sda5 62G 8.7G 50G 15% /var/storage
    /dev/sda7 81G 54G 23G 71% /var/log
    /dev/sda8 3.5G 96M 3.2G 3% /tmp
    /dev 5.9G 100K 5.9G 1% /var/storage/chroot-clientlessvpn/dev
    tmpfs 5.9G 0 5.9G 0% /var/sec/chroot-httpd/dev/shm
    /dev 5.9G 100K 5.9G 1% /var/sec/chroot-openvpn/dev
    /dev 5.9G 100K 5.9G 1% /var/sec/chroot-ppp/dev
    /dev 5.9G 100K 5.9G 1% /var/sec/chroot-pppoe/dev
    /dev 5.9G 100K 5.9G 1% /var/sec/chroot-pptp/dev
    /dev 5.9G 100K 5.9G 1% /var/sec/chroot-pptpc/dev
    /dev 5.9G 100K 5.9G 1% /var/sec/chroot-restd/dev
    tmpfs 5.9G 0 5.9G 0% /var/storage/chroot-reverseproxy/dev/shm
    /opt/tmpfs 5.2G 3.0G 1.9G 62% /var/sec/chroot-httpd/opt/tmpfs
    /etc/nwd.d/route 5.2G 3.0G 1.9G 62% /var/sec/chroot-ipsec/etc/nwd.d/route
    /var/storage/chroot-smtp/spool 62G 8.7G 50G 15% /var/sec/chroot-httpd/var/spx/spool
    /var/storage/chroot-smtp/spx 62G 8.7G 50G 15% /var/sec/chroot-httpd/var/spx/public/images/spx
    tmpfs 5.9G 116K 5.9G 1% /var/storage/chroot-smtp/tmp/ram
    tmpfs 5.9G 0 5.9G 0% /var/storage/chroot-http/tmp
    /var/sec/chroot-afc/var/run/navl 5.2G 3.0G 1.9G 62% /var/storage/chroot-http/var/run/navl
    <S> firewall:/home/login #

  • Hi Bob,

     

    here are the results:

     

    <M> firewall:/home/login # ll /var/storage/pgsql92/data/pg_xlog
    total 3751964
    -rw------- 1 postgres postgres 309 Jul 7 01:52 000000010000092900000063.000000A4.backup
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 0000000100000949000000E1
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 0000000100000949000000E2
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 0000000100000949000000E3
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 0000000100000949000000E4
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 0000000100000949000000E5
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 0000000100000949000000E6
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 0000000100000949000000E7
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 0000000100000949000000E8
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 0000000100000949000000E9
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 0000000100000949000000EA
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 0000000100000949000000EB
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 0000000100000949000000EC
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 0000000100000949000000ED
    -rw------- 1 postgres postgres 16777216 Jul 20 18:44 0000000100000949000000EE
    -rw------- 1 postgres postgres 16777216 Jul 20 18:44 0000000100000949000000EF
    -rw------- 1 postgres postgres 16777216 Jul 20 18:44 0000000100000949000000F0
    -rw------- 1 postgres postgres 16777216 Jul 20 18:44 0000000100000949000000F1
    -rw------- 1 postgres postgres 16777216 Jul 20 18:44 0000000100000949000000F2
    -rw------- 1 postgres postgres 16777216 Jul 20 18:44 0000000100000949000000F3
    -rw------- 1 postgres postgres 16777216 Jul 20 18:45 0000000100000949000000F4
    -rw------- 1 postgres postgres 16777216 Jul 20 18:45 0000000100000949000000F5
    -rw------- 1 postgres postgres 16777216 Jul 20 18:45 0000000100000949000000F6
    -rw------- 1 postgres postgres 16777216 Jul 20 18:45 0000000100000949000000F7
    -rw------- 1 postgres postgres 16777216 Jul 20 18:45 0000000100000949000000F8
    -rw------- 1 postgres postgres 16777216 Jul 20 18:45 0000000100000949000000F9
    -rw------- 1 postgres postgres 16777216 Jul 20 18:45 0000000100000949000000FA
    -rw------- 1 postgres postgres 16777216 Jul 20 18:48 0000000100000949000000FB
    -rw------- 1 postgres postgres 16777216 Jul 20 18:50 0000000100000949000000FC
    -rw------- 1 postgres postgres 16777216 Jul 20 18:52 0000000100000949000000FD
    -rw------- 1 postgres postgres 16777216 Jul 20 18:55 0000000100000949000000FE
    -rw------- 1 postgres postgres 16777216 Jul 20 18:58 000000010000094A00000000
    -rw------- 1 postgres postgres 16777216 Jul 20 19:00 000000010000094A00000001
    -rw------- 1 postgres postgres 16777216 Jul 20 19:03 000000010000094A00000002
    -rw------- 1 postgres postgres 16777216 Jul 20 19:06 000000010000094A00000003
    -rw------- 1 postgres postgres 16777216 Jul 20 19:09 000000010000094A00000004
    -rw------- 1 postgres postgres 16777216 Jul 20 19:14 000000010000094A00000005
    -rw------- 1 postgres postgres 16777216 Jul 20 19:16 000000010000094A00000006
    -rw------- 1 postgres postgres 16777216 Jul 20 19:19 000000010000094A00000007
    -rw------- 1 postgres postgres 16777216 Jul 20 19:23 000000010000094A00000008
    -rw------- 1 postgres postgres 16777216 Jul 20 19:25 000000010000094A00000009
    -rw------- 1 postgres postgres 16777216 Jul 20 19:30 000000010000094A0000000A
    -rw------- 1 postgres postgres 16777216 Jul 20 19:33 000000010000094A0000000B
    -rw------- 1 postgres postgres 16777216 Jul 20 19:38 000000010000094A0000000C
    -rw------- 1 postgres postgres 16777216 Jul 20 19:40 000000010000094A0000000D
    -rw------- 1 postgres postgres 16777216 Jul 20 19:44 000000010000094A0000000E
    -rw------- 1 postgres postgres 16777216 Jul 20 19:46 000000010000094A0000000F
    -rw------- 1 postgres postgres 16777216 Jul 20 19:50 000000010000094A00000010
    -rw------- 1 postgres postgres 16777216 Jul 20 19:54 000000010000094A00000011
    -rw------- 1 postgres postgres 16777216 Jul 20 19:57 000000010000094A00000012
    -rw------- 1 postgres postgres 16777216 Jul 20 20:00 000000010000094A00000013
    -rw------- 1 postgres postgres 16777216 Jul 20 20:03 000000010000094A00000014
    -rw------- 1 postgres postgres 16777216 Jul 20 20:07 000000010000094A00000015
    -rw------- 1 postgres postgres 16777216 Jul 20 20:10 000000010000094A00000016
    -rw------- 1 postgres postgres 16777216 Jul 20 20:15 000000010000094A00000017
    -rw------- 1 postgres postgres 16777216 Jul 20 20:18 000000010000094A00000018
    -rw------- 1 postgres postgres 16777216 Jul 20 20:23 000000010000094A00000019
    -rw------- 1 postgres postgres 16777216 Jul 20 20:27 000000010000094A0000001A
    -rw------- 1 postgres postgres 16777216 Jul 20 20:31 000000010000094A0000001B
    -rw------- 1 postgres postgres 16777216 Jul 20 20:35 000000010000094A0000001C
    -rw------- 1 postgres postgres 16777216 Jul 20 20:40 000000010000094A0000001D
    -rw------- 1 postgres postgres 16777216 Jul 20 20:45 000000010000094A0000001E
    -rw------- 1 postgres postgres 16777216 Jul 20 20:50 000000010000094A0000001F
    -rw------- 1 postgres postgres 16777216 Jul 20 20:55 000000010000094A00000020
    -rw------- 1 postgres postgres 16777216 Jul 20 21:01 000000010000094A00000021
    -rw------- 1 postgres postgres 16777216 Jul 20 21:05 000000010000094A00000022
    -rw------- 1 postgres postgres 16777216 Jul 20 21:10 000000010000094A00000023
    -rw------- 1 postgres postgres 16777216 Jul 20 21:15 000000010000094A00000024
    -rw------- 1 postgres postgres 16777216 Jul 20 21:20 000000010000094A00000025
    -rw------- 1 postgres postgres 16777216 Jul 20 21:25 000000010000094A00000026
    -rw------- 1 postgres postgres 16777216 Jul 20 21:31 000000010000094A00000027
    -rw------- 1 postgres postgres 16777216 Jul 20 21:36 000000010000094A00000028
    -rw------- 1 postgres postgres 16777216 Jul 20 21:43 000000010000094A00000029
    -rw------- 1 postgres postgres 16777216 Jul 20 21:47 000000010000094A0000002A
    -rw------- 1 postgres postgres 16777216 Jul 20 21:53 000000010000094A0000002B
    -rw------- 1 postgres postgres 16777216 Jul 20 21:58 000000010000094A0000002C
    -rw------- 1 postgres postgres 16777216 Jul 20 22:03 000000010000094A0000002D
    -rw------- 1 postgres postgres 16777216 Jul 20 22:09 000000010000094A0000002E
    -rw------- 1 postgres postgres 16777216 Jul 20 22:15 000000010000094A0000002F
    -rw------- 1 postgres postgres 16777216 Jul 20 22:20 000000010000094A00000030
    -rw------- 1 postgres postgres 16777216 Jul 20 22:26 000000010000094A00000031
    -rw------- 1 postgres postgres 16777216 Jul 20 22:32 000000010000094A00000032
    -rw------- 1 postgres postgres 16777216 Jul 20 22:38 000000010000094A00000033
    -rw------- 1 postgres postgres 16777216 Jul 20 22:44 000000010000094A00000034
    -rw------- 1 postgres postgres 16777216 Jul 20 22:49 000000010000094A00000035
    -rw------- 1 postgres postgres 16777216 Jul 20 22:55 000000010000094A00000036
    -rw------- 1 postgres postgres 16777216 Jul 20 23:00 000000010000094A00000037
    -rw------- 1 postgres postgres 16777216 Jul 20 23:05 000000010000094A00000038
    -rw------- 1 postgres postgres 16777216 Jul 20 23:11 000000010000094A00000039
    -rw------- 1 postgres postgres 16777216 Jul 20 23:18 000000010000094A0000003A
    -rw------- 1 postgres postgres 16777216 Jul 20 23:24 000000010000094A0000003B
    -rw------- 1 postgres postgres 16777216 Jul 20 23:30 000000010000094A0000003C
    -rw------- 1 postgres postgres 16777216 Jul 20 23:35 000000010000094A0000003D
    -rw------- 1 postgres postgres 16777216 Jul 20 23:43 000000010000094A0000003E
    -rw------- 1 postgres postgres 16777216 Jul 20 23:48 000000010000094A0000003F
    -rw------- 1 postgres postgres 16777216 Jul 20 23:54 000000010000094A00000040
    -rw------- 1 postgres postgres 16777216 Jul 21 00:00 000000010000094A00000041
    -rw------- 1 postgres postgres 16777216 Jul 21 00:09 000000010000094A00000042
    -rw------- 1 postgres postgres 16777216 Jul 21 00:19 000000010000094A00000043
    -rw------- 1 postgres postgres 16777216 Jul 21 00:28 000000010000094A00000044
    -rw------- 1 postgres postgres 16777216 Jul 21 00:37 000000010000094A00000045
    -rw------- 1 postgres postgres 16777216 Jul 21 00:40 000000010000094A00000046
    -rw------- 1 postgres postgres 16777216 Jul 20 16:30 000000010000094A00000047
    -rw------- 1 postgres postgres 16777216 Jul 20 16:01 000000010000094A00000048
    -rw------- 1 postgres postgres 16777216 Jul 20 17:51 000000010000094A00000049
    -rw------- 1 postgres postgres 16777216 Jul 20 15:43 000000010000094A0000004A
    -rw------- 1 postgres postgres 16777216 Jul 20 16:21 000000010000094A0000004B
    -rw------- 1 postgres postgres 16777216 Jul 20 18:35 000000010000094A0000004C
    -rw------- 1 postgres postgres 16777216 Jul 20 16:27 000000010000094A0000004D
    -rw------- 1 postgres postgres 16777216 Jul 20 18:30 000000010000094A0000004E
    -rw------- 1 postgres postgres 16777216 Jul 20 16:41 000000010000094A0000004F
    -rw------- 1 postgres postgres 16777216 Jul 20 18:02 000000010000094A00000050
    -rw------- 1 postgres postgres 16777216 Jul 20 15:36 000000010000094A00000051
    -rw------- 1 postgres postgres 16777216 Jul 20 16:46 000000010000094A00000052
    -rw------- 1 postgres postgres 16777216 Jul 20 17:47 000000010000094A00000053
    -rw------- 1 postgres postgres 16777216 Jul 20 18:40 000000010000094A00000054
    -rw------- 1 postgres postgres 16777216 Jul 20 18:40 000000010000094A00000055
    -rw------- 1 postgres postgres 16777216 Jul 20 16:17 000000010000094A00000056
    -rw------- 1 postgres postgres 16777216 Jul 20 17:33 000000010000094A00000057
    -rw------- 1 postgres postgres 16777216 Jul 20 17:38 000000010000094A00000058
    -rw------- 1 postgres postgres 16777216 Jul 20 17:25 000000010000094A00000059
    -rw------- 1 postgres postgres 16777216 Jul 20 18:40 000000010000094A0000005A
    -rw------- 1 postgres postgres 16777216 Jul 20 18:40 000000010000094A0000005B
    -rw------- 1 postgres postgres 16777216 Jul 20 16:32 000000010000094A0000005C
    -rw------- 1 postgres postgres 16777216 Jul 20 16:43 000000010000094A0000005D
    -rw------- 1 postgres postgres 16777216 Jul 20 18:40 000000010000094A0000005E
    -rw------- 1 postgres postgres 16777216 Jul 20 17:11 000000010000094A0000005F
    -rw------- 1 postgres postgres 16777216 Jul 20 18:17 000000010000094A00000060
    -rw------- 1 postgres postgres 16777216 Jul 20 18:40 000000010000094A00000061
    -rw------- 1 postgres postgres 16777216 Jul 20 15:58 000000010000094A00000062
    -rw------- 1 postgres postgres 16777216 Jul 20 18:40 000000010000094A00000063
    -rw------- 1 postgres postgres 16777216 Jul 20 16:39 000000010000094A00000064
    -rw------- 1 postgres postgres 16777216 Jul 20 16:11 000000010000094A00000065
    -rw------- 1 postgres postgres 16777216 Jul 20 16:53 000000010000094A00000066
    -rw------- 1 postgres postgres 16777216 Jul 20 15:55 000000010000094A00000067
    -rw------- 1 postgres postgres 16777216 Jul 20 17:00 000000010000094A00000068
    -rw------- 1 postgres postgres 16777216 Jul 20 16:23 000000010000094A00000069
    -rw------- 1 postgres postgres 16777216 Jul 20 16:36 000000010000094A0000006A
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A0000006B
    -rw------- 1 postgres postgres 16777216 Jul 20 18:41 000000010000094A0000006C
    -rw------- 1 postgres postgres 16777216 Jul 20 18:41 000000010000094A0000006D
    -rw------- 1 postgres postgres 16777216 Jul 20 18:41 000000010000094A0000006E
    -rw------- 1 postgres postgres 16777216 Jul 20 18:41 000000010000094A0000006F
    -rw------- 1 postgres postgres 16777216 Jul 20 18:41 000000010000094A00000070
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000071
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000072
    -rw------- 1 postgres postgres 16777216 Jul 20 18:41 000000010000094A00000073
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000074
    -rw------- 1 postgres postgres 16777216 Jul 20 18:41 000000010000094A00000075
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000076
    -rw------- 1 postgres postgres 16777216 Jul 20 18:41 000000010000094A00000077
    -rw------- 1 postgres postgres 16777216 Jul 20 18:41 000000010000094A00000078
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000079
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A0000007A
    -rw------- 1 postgres postgres 16777216 Jul 20 18:41 000000010000094A0000007B
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A0000007C
    -rw------- 1 postgres postgres 16777216 Jul 20 18:41 000000010000094A0000007D
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A0000007E
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A0000007F
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000080
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000081
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000082
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000083
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000084
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000085
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000086
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000087
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000088
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000089
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A0000008A
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A0000008B
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A0000008C
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A0000008D
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A0000008E
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A0000008F
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000090
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000091
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000092
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000093
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000094
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000095
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000096
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000097
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000098
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A00000099
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A0000009A
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A0000009B
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A0000009C
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A0000009D
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A0000009E
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A0000009F
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A000000A0
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A000000A1
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A000000A2
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A000000A3
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A000000A4
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A000000A5
    -rw------- 1 postgres postgres 16777216 Jul 20 18:42 000000010000094A000000A6
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000A7
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000A8
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000A9
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000AA
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000AB
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000AC
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000AD
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000AE
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000AF
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000B0
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000B1
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000B2
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000B3
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000B4
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000B5
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000B6
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000B7
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000B8
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000B9
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000BA
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000BB
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000BC
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000BD
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000BE
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000BF
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000C0
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000C1
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000C2
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000C3
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000C4
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000C5
    -rw------- 1 postgres postgres 16777216 Jul 20 18:43 000000010000094A000000C6
    drwx------ 2 postgres postgres 20480 Jul 21 00:39 archive_status
    <M> firewall:/home/login #

  • Hi Bob,

    the problem is not specific to the slave. On what do you base that we have a problem with PostgreSQL?

    We have this issue for a couple of weeks now and we switched to the other node about 2 weeks ago. Since last week the issue also occurs on the new master.

    Franc.

  • You right.

    Just the same with us.
    We also change Master/Slave about two weeks ago, but the alert I'm getting still the same.
    Franc, do you also getting those alerts concerning the partition feeling up?

     

    Goldy.

    PS, Sophos insist opening two different cases - the internet drops and the Postgress issue.