Send netdisco-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/netdisco-users
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."
Today's Topics:
1. Re: Special Report needed aka "IP-Inventory with extra
columns" (Andy Ruhl)
2. Re: Special Report needed aka "IP-Inventory with extra
columns" (Andy Ruhl)
3. Re: Netdisco starman process memory leak? (Pavel Skovajsa)
--- Begin Message ---
On Wed, Jul 13, 2016 at 7:03 AM, Sebastian Rösch <[email protected]> wrote:
> As I was not able to get the query working in the webinterface I tried to
> execute a query in the shell…. I was trying to combine the following select
> statement with a join. So I started with executing them for their own. But
> the select doesn´t work, the join statement works, but I would like to limit
> the output of it to nodes from a specific subnet…. I thought this could be
> done in a way like described here:
> http://stackoverflow.com/questions/12970187/nested-select-statement-with-left-join
>
>
>
>
>
> bin/netdisco-do psql -e "COPY (SELECT * FROM node_ip WHERE node_ip.ip LIKE
> '%10.200.%') TO STDOUT WITH CSV HEADER"
>
>
>
> bin/netdisco-do psql -e "COPY (SELECT * FROM node INNER JOIN node_ip ON
> node.mac = node_ip.mac) TO STDOUT WITH CSV HEADER"
The postgres way to limit a search to a subnet given that the column
is of a type of "net address", is something like this:
ip<<'10.200.0.0/16'
Andy
--- End Message ---
--- Begin Message ---
On Wed, Jul 13, 2016 at 10:14 AM, Andy Ruhl <[email protected]> wrote:
> On Wed, Jul 13, 2016 at 7:03 AM, Sebastian Rösch <[email protected]> wrote:
>> As I was not able to get the query working in the webinterface I tried to
>> execute a query in the shell…. I was trying to combine the following select
>> statement with a join. So I started with executing them for their own. But
>> the select doesn´t work, the join statement works, but I would like to limit
>> the output of it to nodes from a specific subnet…. I thought this could be
>> done in a way like described here:
>> http://stackoverflow.com/questions/12970187/nested-select-statement-with-left-join
>>
>>
>>
>>
>>
>> bin/netdisco-do psql -e "COPY (SELECT * FROM node_ip WHERE node_ip.ip LIKE
>> '%10.200.%') TO STDOUT WITH CSV HEADER"
>>
>>
>>
>> bin/netdisco-do psql -e "COPY (SELECT * FROM node INNER JOIN node_ip ON
>> node.mac = node_ip.mac) TO STDOUT WITH CSV HEADER"
>
> The postgres way to limit a search to a subnet given that the column
> is of a type of "net address", is something like this:
>
> ip<<'10.200.0.0/16'
I did a little more homework after I replied and the ip column in
node_ip is in fact of type "inet", so you can use CIDR notation for a
subnet range. The << means "contained within".
Andy
--- End Message ---
--- Begin Message ---
Bump, any ideas?
On Thu, Jul 7, 2016 at 6:17 PM, Pavel Skovajsa <[email protected]>
wrote:
>
> Hello,
>
> I do not know too much about memory leaks, but I found some bad looking
> message on our dedicated Netdisco server below. It is a Ubuntu Server
> 12.04LTS VM with 16Gbps RAM.
>
>
> Can somebody help me out troubleshooting this?
>
> [18969.320254] starman worker invoked oom-killer: gfp_mask=0x280da,
> order=0, oom_score_adj=0
>
> [18969.320259] starman worker cpuset=/ mems_allowed=0
>
> [18969.320262] CPU: 5 PID: 3295 Comm: starman worker Not tainted
> 3.13.0-83-generic #127-Ubuntu
>
> [18969.320264] Hardware name: VMware, Inc. VMware Virtual Platform/440BX
> Desktop Reference Platform, BIOS 6.00 07/30/2013
>
> [18969.320266] 0000000000000000 ffff8800bb9a5a80 ffffffff81725992
> ffff8800368d8000
>
> [18969.320269] ffff8800bb9a5b08 ffffffff8171ff99 ffffffff81067ac6
> ffff8800bb9a5ae0
>
> [18969.320272] ffffffff810c7bfc 0000000000000000 ffff8804bffede38
> 0000000000000000
>
> [18969.320274] Call Trace:
>
> [18969.320282] [<ffffffff81725992>] dump_stack+0x45/0x56
>
> [18969.320286] [<ffffffff8171ff99>] dump_header+0x7f/0x1f1
>
> [18969.320290] [<ffffffff81067ac6>] ? put_online_cpus+0x56/0x80
>
> [18969.320293] [<ffffffff810c7bfc>] ? rcu_oom_notify+0xcc/0xf0
>
> [18969.320296] [<ffffffff811531ee>] oom_kill_process+0x1ce/0x330
>
> [18969.320301] [<ffffffff812d8995>] ? security_capable_noaudit+0x15/0x20
>
> [18969.320304] [<ffffffff81153924>] out_of_memory+0x414/0x450
>
> [18969.320306] [<ffffffff81159c20>] __alloc_pages_nodemask+0xa60/0xb80
>
> [18969.320311] [<ffffffff8119a4aa>] alloc_pages_vma+0x9a/0x140
>
> [18969.320315] [<ffffffff8117aba3>] handle_mm_fault+0xb23/0xf10
>
> [18969.320320] [<ffffffff81731af4>] __do_page_fault+0x184/0x570
>
> [18969.320323] [<ffffffff8117fe7d>] ? vma_merge+0x23d/0x340
>
> [18969.320325] [<ffffffff81180f84>] ? do_brk+0x1d4/0x360
>
> [18969.320328] [<ffffffff81731efa>] do_page_fault+0x1a/0x70
>
> [18969.320330] [<ffffffff8172e228>] page_fault+0x28/0x30
>
> [18969.320332] Mem-Info:
>
> [18969.320333] Node 0 DMA per-cpu:
>
> [18969.320335] CPU 0: hi: 0, btch: 1 usd: 0
>
> [18969.320336] CPU 1: hi: 0, btch: 1 usd: 0
>
> [18969.320337] CPU 2: hi: 0, btch: 1 usd: 0
>
> [18969.320338] CPU 3: hi: 0, btch: 1 usd: 0
>
> [18969.320339] CPU 4: hi: 0, btch: 1 usd: 0
>
> [18969.320340] CPU 5: hi: 0, btch: 1 usd: 0
>
> [18969.320341] Node 0 DMA32 per-cpu:
>
> [18969.320343] CPU 0: hi: 186, btch: 31 usd: 0
>
> [18969.320344] CPU 1: hi: 186, btch: 31 usd: 0
>
> [18969.320345] CPU 2: hi: 186, btch: 31 usd: 0
>
> [18969.320346] CPU 3: hi: 186, btch: 31 usd: 0
>
> [18969.320347] CPU 4: hi: 186, btch: 31 usd: 0
>
> [18969.320348] CPU 5: hi: 186, btch: 31 usd: 0
>
> [18969.320348] Node 0 Normal per-cpu:
>
> [18969.320350] CPU 0: hi: 186, btch: 31 usd: 14
>
> [18969.320351] CPU 1: hi: 186, btch: 31 usd: 0
>
> [18969.320352] CPU 2: hi: 186, btch: 31 usd: 1
>
> [18969.320353] CPU 3: hi: 186, btch: 31 usd: 1
>
> [18969.320354] CPU 4: hi: 186, btch: 31 usd: 30
>
> [18969.320355] CPU 5: hi: 186, btch: 31 usd: 5
>
> [18969.320358] active_anon:4049463 inactive_anon:462121 isolated_anon:128
>
> [18969.320358] active_file:180 inactive_file:263 isolated_file:0
>
> [18969.320358] unevictable:0 dirty:0 writeback:0 unstable:0
>
> [18969.320358] free:35849 slab_reclaimable:5397 slab_unreclaimable:7456
>
> [18969.320358] mapped:34790 shmem:34749 pagetables:22516 bounce:0
>
> [18969.320358] free_cma:0
>
> [18969.320360] Node 0 DMA free:15892kB min:56kB low:68kB high:84kB
> active_anon:0kB inactive_anon:0kB active_file:0kB inactive_file:0kB
> unevictable:0kB isolated(anon):0kB isolated(file):0kB present:15992kB ma
>
> naged:15908kB mlocked:0kB dirty:0kB writeback:0kB mapped:0kB shmem:0kB
> slab_reclaimable:0kB slab_unreclaimable:16kB kernel_stack:0kB
> pagetables:0kB unstable:0kB bounce:0kB free_cma:0kB writeback_tmp:0kB page
>
> s_scanned:0 all_unreclaimable? yes
>
> [18969.320365] lowmem_reserve[]: 0 2975 18040 18040
>
> [18969.320367] Node 0 DMA32 free:71256kB min:11136kB low:13920kB
> high:16704kB active_anon:2361868kB inactive_anon:590636kB active_file:316kB
> inactive_file:0kB unevictable:0kB isolated(anon):0kB isolated(file
>
> ):0kB present:3129216kB managed:3050188kB mlocked:0kB dirty:0kB
> writeback:0kB mapped:20268kB shmem:20216kB slab_reclaimable:2492kB
> slab_unreclaimable:2556kB kernel_stack:144kB pagetables:11864kB unstable:0kB
>
> bounce:0kB free_cma:0kB writeback_tmp:0kB pages_scanned:475
> all_unreclaimable? yes
>
> [18969.320371] lowmem_reserve[]: 0 0 15064 15064
>
> [18969.320373] Node 0 Normal free:56248kB min:56384kB low:70480kB
> high:84576kB active_anon:13835728kB inactive_anon:1257848kB
> active_file:404kB inactive_file:1236kB unevictable:0kB isolated(anon):512kB
> isola
>
> ted(file):0kB present:15728640kB managed:15425988kB mlocked:0kB dirty:8kB
> writeback:0kB mapped:118892kB shmem:118780kB slab_reclaimable:19096kB
> slab_unreclaimable:27252kB kernel_stack:2680kB pagetables:78200
>
> kB unstable:0kB bounce:0kB free_cma:0kB writeback_tmp:0kB
> pages_scanned:11281 all_unreclaimable? yes
>
> [18969.320377] lowmem_reserve[]: 0 0 0 0
>
> [18969.320379] Node 0 DMA: 1*4kB (U) 0*8kB 1*16kB (U) 0*32kB 2*64kB (U)
> 1*128kB (U) 1*256kB (U) 0*512kB 1*1024kB (U) 1*2048kB (R) 3*4096kB (M) =
> 15892kB
>
> [18969.320387] Node 0 DMA32: 124*4kB (UEM) 197*8kB (UEM) 92*16kB (UEM)
> 41*32kB (UEM) 26*64kB (UEM) 13*128kB (UE) 9*256kB (UEM) 6*512kB (UM)
> 4*1024kB (EM) 3*2048kB (UE) 12*4096kB (EMR) = 72952kB
>
> [18969.320396] Node 0 Normal: 53*4kB (EMR) 157*8kB (UER) 120*16kB (UEMR)
> 117*32kB (UEMR) 162*64kB (UEMR) 76*128kB (EM) 21*256kB (UER) 10*512kB (ER)
> 6*1024kB (EMR) 6*2048kB (UMR) 0*4096kB = 56156kB
>
> [18969.320406] Node 0 hugepages_total=0 hugepages_free=0 hugepages_surp=0
> hugepages_size=2048kB
>
> [18969.320407] 40073 total pagecache pages
>
> [18969.320408] 4910 pages in swap cache
>
> [18969.320409] Swap cache stats: add 7745144, delete 7740234, find
> 1733257/1971555
>
> [18969.320410] Free swap = 0kB
>
> [18969.320411] Total swap = 16773116kB
>
> [18969.320412] 4718462 pages RAM
>
> [18969.320413] 0 pages HighMem/MovableOnly
>
> [18969.320414] 75663 pages reserved
>
> [18969.320415] [ pid ] uid tgid total_vm rss nr_ptes swapents
> oom_score_adj name
>
> [18969.320423] [ 461] 0 461 4967 19 14 161 0 upstart-udev-br
>
> [18969.320425] [ 468] 0 468 12816 19 27 148 -1000 systemd-udevd
>
> [18969.320427] [ 661] 102 661 9806 19 23 100 0 dbus-daemon
>
> [18969.320429] [ 684] 101 684 63960 0 27 171 0 rsyslogd
>
> [18969.320431] [ 738] 0 738 10862 20 26 87 0 systemd-logind
>
> [18969.320433] [ 877] 0 877 3949 13 12 176 0 upstart-file-br
>
> [18969.320434] [ 884] 0 884 3880 13 13 118 0 upstart-socket-
>
> [18969.320436] [ 923] 0 923 3634 13 11 40 0 getty
>
> [18969.320437] [ 930] 0 930 3634 13 12 41 0 getty
>
> [18969.320439] [ 940] 0 940 3634 13 11 40 0 getty
>
> [18969.320441] [ 941] 0 941 3634 13 12 39 0 getty
>
> [18969.320444] [ 943] 0 943 3634 13 12 40 0 getty
>
> [18969.320448] [ 965] 0 965 15344 14 34 170 -1000 sshd
>
> [18969.320449] [ 974] 0 974 5913 11 17 45 0 cron
>
> [18969.320451] [ 975] 0 975 4784 0 13 43 0 atd
>
> [18969.320453] [ 1143] 0 1143 1091 9 8 38 0 acpid
>
> [18969.320455] [ 1192] 103 1192 83925 40 60 259 0 whoopsie
>
> [18969.320457] [ 1236] 106 1236 61633 882 58 295 -900 postgres
>
> [18969.320459] [ 1338] 106 1338 61700 26860 117 298 0 postgres
>
> [18969.320460] [ 1339] 106 1339 61633 33107 117 283 0 postgres
>
> [18969.320462] [ 1341] 106 1341 61633 559 52 313 0 postgres
>
> [18969.320463] [ 1342] 106 1342 61836 2740 117 416 0 postgres
>
> [18969.320465] [ 1343] 106 1343 25655 125 47 297 0 postgres
>
> [18969.320466] [ 1385] 0 1385 22942 85 42 140 0 vmtoolsd
>
> [18969.320468] [ 1440] 106 1440 62503 51 58 313 -900 postgres
>
> [18969.320469] [ 1442] 106 1442 62503 5 50 351 0 postgres
>
> [18969.320471] [ 1443] 106 1443 62503 17 52 332 0 postgres
>
> [18969.320472] [ 1444] 106 1444 62503 15 50 341 0 postgres
>
> [18969.320474] [ 1445] 106 1445 62612 88 54 351 0 postgres
>
> [18969.320475] [ 1446] 106 1446 26249 57 47 315 0 postgres
>
> [18969.320477] [ 1484] 107 1484 11376 93 25 603 0 snmpd
>
> [18969.320478] [ 1546] 0 1546 3634 13 12 41 0 getty
>
> [18969.320480] [ 2235] 1000 2235 14781 311 32 2886 0 perl
>
> [18969.320482] [ 2236] 1000 2236 13321 1706 31 716 0 starman master
>
> [18969.320484] [ 2246] 1000 2246 14778 324 33 2872 0 netdisco-daemon
>
> [18969.320485] [ 2247] 1000 2247 40058 512 84 11722 0 netdisco-daemon
>
> [18969.320487] [ 2248] 1000 2248 64533 1558 130 15955 0 netdisco-daemon
>
> [18969.320488] [ 2249] 1000 2249 66711 6592 134 12563 0 netdisco-daemon
>
> [18969.320490] [ 2250] 1000 2250 97349 10516 195 39828 0 netdisco-daemon
>
> [18969.320491] [ 2251] 1000 2251 99375 43920 199 8488 0 netdisco-daemon
>
> [18969.320493] [ 2252] 1000 2252 97962 43043 196 7921 0 netdisco-daemon
>
> [18969.320495] [ 2253] 1000 2253 101568 45543 203 9038 0 netdisco-daemon
>
> [18969.320496] [ 2254] 1000 2254 97421 41704 195 8766 0 netdisco-daemon
>
> [18969.320498] [ 2255] 1000 2255 101035 45731 202 8257 0 netdisco-daemon
>
> [18969.320499] [ 2256] 1000 2256 100013 42864 200 10151 0 netdisco-daemon
>
> [18969.320501] [ 2257] 1000 2257 97733 41970 196 8799 0 netdisco-daemon
>
> [18969.320502] [ 2258] 1000 2258 97678 33951 196 16735 0 netdisco-daemon
>
> [18969.320504] [ 2259] 1000 2259 99366 44169 199 8219 0 netdisco-daemon
>
> [18969.320506] [ 2260] 1000 2260 96403 40856 193 8587 0 netdisco-daemon
>
> [18969.320507] [ 2261] 1000 2261 96418 41222 193 8198 0 netdisco-daemon
>
> [18969.320509] [ 2264] 106 2264 62036 33954 119 498 0 postgres
>
> [18969.320511] [ 2265] 106 2265 65619 35088 126 2495 0 postgres
>
> [18969.320512] [ 2266] 106 2266 66699 34295 128 4360 0 postgres
>
> [18969.320514] [ 2267] 106 2267 65851 34775 127 3086 0 postgres
>
> [18969.320516] [ 2268] 106 2268 65558 34543 126 3243 0 postgres
>
> [18969.320517] [ 2269] 106 2269 65713 34566 126 3003 0 postgres
>
> [18969.320519] [ 2270] 106 2270 66406 36294 128 2350 0 postgres
>
> [18969.320520] [ 2272] 106 2272 65682 35060 126 2799 0 postgres
>
> [18969.320521] [ 2273] 106 2273 65882 33755 127 3865 0 postgres
>
> [18969.320523] [ 2274] 106 2274 65664 34909 126 2926 0 postgres
>
> [18969.320524] [ 2276] 106 2276 64260 33075 124 2895 0 postgres
>
> [18969.320526] [ 2278] 106 2278 66450 34150 128 4238 0 postgres
>
> [18969.320527] [ 2280] 106 2280 65859 34788 127 3033 0 postgres
>
> [18969.320529] [ 2316] 106 2316 61968 599 73 611 0 postgres
>
> [18969.320530] [ 3267] 1000 3267 66711 8556 132 11925 0 starman worker
>
> [18969.320532] [ 3269] 106 3269 62492 33598 120 999 0 postgres
>
> [18969.320534] [ 3291] 1000 3291 66195 6300 131 13676 0 starman worker
>
> [18969.320539] [ 3292] 106 3292 62687 33531 121 1225 0 postgres
>
> [18969.320540] [ 3295] 1000 3295 8007801 3951141 15629 4003012 0 starman
> worker
>
> [18969.320542] [ 3296] 106 3296 63679 33138 122 2152 0 postgres
>
> [18969.320543] [ 3307] 1000 3307 64458 6927 128 11843 0 starman worker
>
> [18969.320545] [ 3309] 106 3309 62121 33558 119 531 0 postgres
>
> [18969.320547] [ 3311] 1000 3311 65742 7468 130 12053 0 starman worker
>
> [18969.320548] [ 3312] 106 3312 62277 33541 120 751 0 postgres
>
> [18969.320550] Out of memory: Kill process 3295 (starman worker ) score
> 903 or sacrifice child
>
> [18969.320595] Killed process 3295 (starman worker ) total-vm:32031204kB,
> anon-rss:15804340kB, file-rss:224kB
>
> [1000564.744888] [sched_delayed] sched: RT throttling activated
>
>
> -pavel skovajsa
>
--- End Message ---
------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity planning
reports.http://sdm.link/zohodev2dev
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
