Problem with connecting to database server

Discussion in 'Server Operation' started by tio289, Feb 5, 2014.

  1. tio289

    tio289 Member

    Hello,

    we use KVM virtualization (Proxmox VE 3) and we have two VMs.

    101 - webserver (apache, mod_php)
    102 - database server (mariadb)

    101 has 3 network interfaces. 2 are bridged to "net"(vmbr0), one to "lan"(vmbr1)
    102 has 1 network interface bridged to "lan"

    Sometimes for less that 1 minute, 101 lost connection to 102. PHP cant connect to mysql. I try to ping servers. when I ping from 101 to 102 its 100% packet loss. But when I ping from 102 to 101 its 0% packet loss.

    After minute(s) its working again normaly. Also restarting apache help, but not everytime.

    I dont know how to solve this. :(

    101
    Code:
    root@web:/home/feldsam# ifconfig
    eth0      Link encap:Ethernet  HWaddr d2:ff:3a:4b:4e:3f  
              inet addr:93.185.103.242  Bcast:93.185.103.255  Mask:255.255.255.0
              inet6 addr: fe80::d0ff:3aff:fe4b:4e3f/64 Scope:Link
              UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
              RX packets:10760037 errors:0 dropped:0 overruns:0 frame:0
              TX packets:27580 errors:0 dropped:0 overruns:0 carrier:0
              collisions:0 txqueuelen:1000 
              RX bytes:2389942182 (2.2 GiB)  TX bytes:57512694 (54.8 MiB)
    
    
    eth2      Link encap:Ethernet  HWaddr de:3c:57:d0:53:9c  
              inet addr:93.185.103.243  Bcast:93.185.103.255  Mask:255.255.255.0
              inet6 addr: fe80::dc3c:57ff:fed0:539c/64 Scope:Link
              UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
              RX packets:3624689 errors:0 dropped:0 overruns:0 frame:0
              TX packets:6030104 errors:0 dropped:0 overruns:0 carrier:0
              collisions:0 txqueuelen:1000 
              RX bytes:1369793737 (1.2 GiB)  TX bytes:14787478397 (13.7 GiB)
    
    
    eth3      Link encap:Ethernet  HWaddr 32:7e:97:96:ee:bb  
              inet addr:10.0.1.1  Bcast:10.0.255.255  Mask:255.255.0.0
              inet6 addr: fe80::307e:97ff:fe96:eebb/64 Scope:Link
              UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
              RX packets:239980906 errors:0 dropped:0 overruns:0 frame:0
              TX packets:233151498 errors:0 dropped:0 overruns:0 carrier:0
              collisions:0 txqueuelen:1000 
              RX bytes:316744952602 (294.9 GiB)  TX bytes:34912096999 (32.5 GiB)
    
    
    lo        Link encap:Local Loopback  
              inet addr:127.0.0.1  Mask:255.0.0.0
              inet6 addr: ::1/128 Scope:Host
              UP LOOPBACK RUNNING  MTU:16436  Metric:1
              RX packets:4922679 errors:0 dropped:0 overruns:0 frame:0
              TX packets:4922679 errors:0 dropped:0 overruns:0 carrier:0
              collisions:0 txqueuelen:0 
              RX bytes:7186122674 (6.6 GiB)  TX bytes:7186122674 (6.6 GiB)
    102
    Code:
    root@mysql0:~# ifconfig
    eth0      Link encap:Ethernet  HWaddr 0a:6f:e9:f2:65:47  
              inet addr:10.0.1.2  Bcast:10.0.255.255  Mask:255.255.0.0
              inet6 addr: fe80::86f:e9ff:fef2:6547/64 Scope:Link
              UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
              RX packets:233528239 errors:0 dropped:0 overruns:0 frame:0
              TX packets:240361563 errors:0 dropped:0 overruns:0 carrier:0
              collisions:0 txqueuelen:1000 
              RX bytes:34967626032 (32.5 GiB)  TX bytes:317241696150 (295.4 GiB)
    
    
    lo        Link encap:Local Loopback  
              inet addr:127.0.0.1  Mask:255.0.0.0
              inet6 addr: ::1/128 Scope:Host
              UP LOOPBACK RUNNING  MTU:16436  Metric:1
              RX packets:0 errors:0 dropped:0 overruns:0 frame:0
              TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
              collisions:0 txqueuelen:0 
              RX bytes:0 (0.0 B)  TX bytes:0 (0.0 B)
    host node
    Code:
    root@node0:~# ifconfig
    eth0      Link encap:Ethernet  HWaddr 00:26:2d:03:15:4c  
              inet6 addr: fe80::226:2dff:fe03:154c/64 Scope:Link
              UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
              RX packets:14727470 errors:0 dropped:0 overruns:0 frame:0
              TX packets:51874174 errors:0 dropped:0 overruns:0 carrier:0
              collisions:0 txqueuelen:1000 
              RX bytes:3281272744 (3.0 GiB)  TX bytes:74233241996 (69.1 GiB)
    
    
    lo        Link encap:Local Loopback  
              inet addr:127.0.0.1  Mask:255.0.0.0
              inet6 addr: ::1/128 Scope:Host
              UP LOOPBACK RUNNING  MTU:16436  Metric:1
              RX packets:99528 errors:0 dropped:0 overruns:0 frame:0
              TX packets:99528 errors:0 dropped:0 overruns:0 carrier:0
              collisions:0 txqueuelen:0 
              RX bytes:79532612 (75.8 MiB)  TX bytes:79532612 (75.8 MiB)
    
    
    tap101i0  Link encap:Ethernet  HWaddr 9e:53:bc:b1:d5:22  
              inet6 addr: fe80::9c53:bcff:feb1:d522/64 Scope:Link
              UP BROADCAST RUNNING PROMISC MULTICAST  MTU:1500  Metric:1
              RX packets:27586 errors:0 dropped:0 overruns:0 frame:0
              TX packets:10848476 errors:0 dropped:0 overruns:71101 carrier:0
              collisions:0 txqueuelen:500 
              RX bytes:57513106 (54.8 MiB)  TX bytes:2408587508 (2.2 GiB)
    
    
    tap101i1  Link encap:Ethernet  HWaddr 9e:ad:7f:78:ff:e8  
              inet6 addr: fe80::9cad:7fff:fe78:ffe8/64 Scope:Link
              UP BROADCAST RUNNING PROMISC MULTICAST  MTU:1500  Metric:1
              RX packets:0 errors:0 dropped:0 overruns:0 frame:0
              TX packets:256 errors:0 dropped:0 overruns:1 carrier:0
              collisions:0 txqueuelen:500 
              RX bytes:0 (0.0 B)  TX bytes:16328 (15.9 KiB)
    
    
    tap101i2  Link encap:Ethernet  HWaddr 2e:ee:86:d3:eb:88  
              inet6 addr: fe80::2cee:86ff:fed3:eb88/64 Scope:Link
              UP BROADCAST RUNNING PROMISC MULTICAST  MTU:1500  Metric:1
              RX packets:6093888 errors:0 dropped:0 overruns:0 frame:0
              TX packets:3634583 errors:0 dropped:0 overruns:2374 carrier:0
              collisions:0 txqueuelen:500 
              RX bytes:14942513137 (13.9 GiB)  TX bytes:1371836380 (1.2 GiB)
    
    
    tap101i3  Link encap:Ethernet  HWaddr c6:73:db:06:6e:1b  
              inet6 addr: fe80::c473:dbff:fe06:6e1b/64 Scope:Link
              UP BROADCAST RUNNING PROMISC MULTICAST  MTU:1500  Metric:1
              RX packets:234467363 errors:0 dropped:0 overruns:0 frame:0
              TX packets:241340823 errors:0 dropped:0 overruns:0 carrier:0
              collisions:0 txqueuelen:500 
              RX bytes:35103230049 (32.6 GiB)  TX bytes:318659148473 (296.7 GiB)
    
    
    tap102i0  Link encap:Ethernet  HWaddr 72:93:d6:91:b9:6f  
              inet6 addr: fe80::7093:d6ff:fe91:b96f/64 Scope:Link
              UP BROADCAST RUNNING PROMISC MULTICAST  MTU:1500  Metric:1
              RX packets:241371961 errors:0 dropped:0 overruns:0 frame:0
              TX packets:234505545 errors:0 dropped:0 overruns:0 carrier:0
              collisions:0 txqueuelen:500 
              RX bytes:318670616073 (296.7 GiB)  TX bytes:35105886938 (32.6 GiB)
    
    
    tap103i0  Link encap:Ethernet  HWaddr a6:d7:c3:0c:c1:ef  
              inet6 addr: fe80::a4d7:c3ff:fe0c:c1ef/64 Scope:Link
              UP BROADCAST RUNNING PROMISC MULTICAST  MTU:1500  Metric:1
              RX packets:19808 errors:0 dropped:0 overruns:0 frame:0
              TX packets:25965 errors:0 dropped:0 overruns:0 carrier:0
              collisions:0 txqueuelen:500 
              RX bytes:7021510 (6.6 MiB)  TX bytes:1855486 (1.7 MiB)
    
    
    tap104i0  Link encap:Ethernet  HWaddr 02:39:70:9e:13:ef  
              inet6 addr: fe80::39:70ff:fe9e:13ef/64 Scope:Link
              UP BROADCAST RUNNING PROMISC MULTICAST  MTU:1500  Metric:1
              RX packets:6763 errors:0 dropped:0 overruns:0 frame:0
              TX packets:8169 errors:0 dropped:0 overruns:0 carrier:0
              collisions:0 txqueuelen:500 
              RX bytes:500953 (489.2 KiB)  TX bytes:913387 (891.9 KiB)
    
    
    venet0    Link encap:UNSPEC  HWaddr 00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00  
              inet6 addr: fe80::1/128 Scope:Link
              UP BROADCAST POINTOPOINT RUNNING NOARP  MTU:1500  Metric:1
              RX packets:0 errors:0 dropped:0 overruns:0 frame:0
              TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
              collisions:0 txqueuelen:0 
              RX bytes:0 (0.0 B)  TX bytes:0 (0.0 B)
    
    
    veth100.0 Link encap:Ethernet  HWaddr 9e:32:eb:11:b4:3c  
              inet6 addr: fe80::9c32:ebff:fe11:b43c/64 Scope:Link
              UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
              RX packets:17413 errors:0 dropped:0 overruns:0 frame:0
              TX packets:26205 errors:0 dropped:4 overruns:0 carrier:0
              collisions:0 txqueuelen:0 
              RX bytes:3306150 (3.1 MiB)  TX bytes:1763990 (1.6 MiB)
    
    
    veth108.0 Link encap:Ethernet  HWaddr aa:37:3d:5f:ec:fb  
              inet6 addr: fe80::a837:3dff:fe5f:ecfb/64 Scope:Link
              UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
              RX packets:69358 errors:0 dropped:0 overruns:0 frame:0
              TX packets:861764 errors:0 dropped:1999012 overruns:0 carrier:0
              collisions:0 txqueuelen:0 
              RX bytes:9893335 (9.4 MiB)  TX bytes:68907763 (65.7 MiB)
    
    
    vmbr0     Link encap:Ethernet  HWaddr 00:26:2d:03:15:4c  
              inet addr:93.185.103.99  Bcast:93.185.103.255  Mask:255.255.255.0
              inet6 addr: fe80::226:2dff:fe03:154c/64 Scope:Link
              UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
              RX packets:3097045 errors:0 dropped:0 overruns:0 frame:0
              TX packets:2126900 errors:0 dropped:0 overruns:0 carrier:0
              collisions:0 txqueuelen:0 
              RX bytes:173136112 (165.1 MiB)  TX bytes:56399550513 (52.5 GiB)
    
    
    vmbr1     Link encap:Ethernet  HWaddr 9e:32:eb:11:b4:3c  
              inet addr:10.0.254.254  Bcast:10.0.255.255  Mask:255.255.0.0
              inet6 addr: fe80::2015:79ff:fee8:3f71/64 Scope:Link
              UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
              RX packets:64925 errors:0 dropped:0 overruns:0 frame:0
              TX packets:84355 errors:0 dropped:0 overruns:0 carrier:0
              collisions:0 txqueuelen:0 
              RX bytes:20854793 (19.8 MiB)  TX bytes:6529228 (6.2 MiB)
    EDIT:
    Hi, I solved it yet.
    I have another VM on same bridge with the same IP as has webserver So my big fail.
     
    Last edited: Feb 5, 2014

Share This Page