## Expected Behaviour:
Queries and admin page showing the graphs. Pihole seems to be blocking normal, I can see it working at pihole -t
## Actual Behaviour:
Page seems to be always loading the graphs
## Debug Token:
bkh3p3dzzx
Edit: Ran pihole -up, still nothing, new token
qypg9ktvoa
Any ideas?
I have tried searching here and doing the "sudo service pihole-FTL restart" and no go
Please provide the output of
tail -n25 /var/log/pihole-FTL.log
pi@raspberrypi:~ $ tail -n25 /var/log/pihole-FTL.log
[2018-03-08 00:01:05.616] Notice: Increasing queries struct size from 20000 to 3 0000 (2.84 MB)
[2018-03-08 00:01:36.867] Notice: Increasing queries struct size from 30000 to 4 0000 (3.28 MB)
[2018-03-08 00:02:05.077] Notice: Increasing overTime struct size from 31100 to 31200 (3.28 MB)
[2018-03-08 00:02:08.114] Notice: Increasing queries struct size from 40000 to 5 0000 (3.72 MB)
[2018-03-08 00:02:39.360] Notice: Increasing queries struct size from 50000 to 6 0000 (4.16 MB)
[2018-03-08 00:03:10.613] Notice: Increasing queries struct size from 60000 to 7 0000 (4.60 MB)
[2018-03-08 00:03:41.876] Notice: Increasing queries struct size from 70000 to 8 0000 (5.04 MB)
[2018-03-08 00:04:13.150] Notice: Increasing queries struct size from 80000 to 9 0000 (5.48 MB)
[2018-03-08 00:04:44.431] Notice: Increasing queries struct size from 90000 to 1 00000 (5.92 MB)
[2018-03-08 00:05:15.724] Notice: Increasing queries struct size from 100000 to 110000 (6.36 MB)
[2018-03-08 00:05:47.024] Notice: Increasing queries struct size from 110000 to 120000 (6.80 MB)
[2018-03-08 00:06:18.442] Notice: Increasing queries struct size from 120000 to 130000 (7.24 MB)
[2018-03-08 00:06:49.750] Notice: Increasing queries struct size from 130000 to 140000 (7.68 MB)
[2018-03-08 00:07:21.075] Notice: Increasing queries struct size from 140000 to 150000 (8.12 MB)
[2018-03-08 00:07:52.404] Notice: Increasing queries struct size from 150000 to 160000 (8.56 MB)
[2018-03-08 00:08:23.743] Notice: Increasing queries struct size from 160000 to 170000 (9.00 MB)
[2018-03-08 00:08:55.087] Notice: Increasing queries struct size from 170000 to 180000 (9.44 MB)
[2018-03-08 00:09:26.518] Notice: Increasing queries struct size from 180000 to 190000 (9.88 MB)
[2018-03-08 00:09:57.960] Notice: Increasing queries struct size from 190000 to 200000 (10.32 MB)
[2018-03-08 00:10:29.382] Notice: Increasing queries struct size from 200000 to 210000 (10.76 MB)
[2018-03-08 00:10:38.492] Notice: Increasing overTime struct size from 31200 to 31300 (10.76 MB)
[2018-03-08 00:11:00.874] Notice: Increasing queries struct size from 210000 to 220000 (11.20 MB)
[2018-03-08 00:11:32.669] Notice: Increasing queries struct size from 220000 to 230000 (11.64 MB)
[2018-03-08 00:11:48.434] Imported 224950 queries from the long-term database
[2018-03-08 00:11:48.435] Reading from /var/log/pihole.log (rw-r--r--)
Okay, that looks fine. How about
echo ">stats" | nc -v pi.hole 4711
pi@raspberrypi:~ $ echo ">stats" | nc -v pi.hole 4711
nc: connect to pi.hole port 4711 (tcp) failed: Connection refused
Is this still the case after
sudo service pihole-FTL restart
?
If so, what is the output of
sudo -u pihole pihole-FTL debug
?
yeah still the same, I ran the debug, but it seems to have hung, not sure if it still running:
pi@raspberrypi:~ $ sudo -u pihole pihole-FTL debug
[2018-03-08 06:56:45.354] ########## FTL started! ##########
[2018-03-08 06:56:45.355] FTL branch: v3.0
[2018-03-08 06:56:45.355] FTL version: v3.0
[2018-03-08 06:56:45.355] FTL commit: a1b2fa03f8f3e3713b57a26a4e9a062fec0573d7
[2018-03-08 06:56:45.355] FTL date: 2018-02-14 12:45:47 -0800
[2018-03-08 06:56:45.355] FTL user: pihole
[2018-03-08 06:56:45.356] Notice: Found no readable FTL config file
[2018-03-08 06:56:45.356] Using default settings
[2018-03-08 06:56:45.357] Starting config file parsing (/etc/pihole/pihole-FTL.conf)
[2018-03-08 06:56:45.357] SOCKET_LISTENING: only local
[2018-03-08 06:56:45.357] QUERY_DISPLAY: Show queries
[2018-03-08 06:56:45.357] AAAA_QUERY_ANALYSIS: Show AAAA queries
[2018-03-08 06:56:45.357] MAXDBDAYS: max age for stored queries is 365 days
[2018-03-08 06:56:45.358] RESOLVE_IPV6: Resolve IPv6 addresses
[2018-03-08 06:56:45.358] RESOLVE_IPV4: Resolve IPv4 addresses
[2018-03-08 06:56:45.358] DBINTERVAL: saving to DB file every minute
[2018-03-08 06:56:45.358] DBFILE: Using /etc/pihole/pihole-FTL.db
[2018-03-08 06:56:45.358] MAXLOGAGE: Importing up to 24.0 hours of log data
[2018-03-08 06:56:45.359] Finished config file parsing
[2018-03-08 06:56:45.359] PID of FTL process: 15150
[2018-03-08 06:56:45.783] Gravity list entries: 122699
[2018-03-08 06:56:45.784] No blacklist present
[2018-03-08 06:56:45.784] No wildcard blocking list present
[2018-03-08 06:56:45.786] Database initialized
[2018-03-08 06:56:45.786] SELECT * FROM queries WHERE timestamp >= 1520424060
[2018-03-08 06:56:45.789] Notice: Increasing queries struct size from 0 to 10000 (440.12 KB)
[2018-03-08 06:56:45.790] at query time:
[2018-03-08 06:56:45.790] Notice: Increasing domains struct size from 0 to 1000 (460.12 KB)
[2018-03-08 06:56:45.791] at query time:
[2018-03-08 06:56:45.791] Notice: Increasing clients struct size from 0 to 10 (460.28 KB)
[2018-03-08 06:56:45.791] at query time:
[2018-03-08 06:56:45.791] New domain: hgjxexnotsymo (0/1000)
[2018-03-08 06:56:45.792] New client: localhost localhost (0/10)
[2018-03-08 06:56:45.792] Notice: Increasing overTime struct size from 0 to 100 (464.31 KB)
[2018-03-08 06:56:45.792] at query time:
[2018-03-08 06:56:45.792] New domain: rvbvobovazduasi (1/1000)
[2018-03-08 06:56:45.793] New domain: cuzoxpal (2/1000)
[2018-03-08 06:56:45.793] New domain: ssl.gstatic.com (3/1000)
[2018-03-08 06:56:45.793] Notice: Increasing forwarded struct size from 0 to 4 (464.42 KB)
[2018-03-08 06:56:45.793] at query time:
[2018-03-08 06:56:45.804] New forward server: 208.67.220.220 resolver2.opendns.com (0/4)
[2018-03-08 06:56:45.804] New domain: graph.facebook.com (4/1000)
[2018-03-08 06:56:45.811] New client: 10.10.10.74 (1/10)
[2018-03-08 06:56:45.817] New forward server: 208.67.222.222 resolver1.opendns.com (1/4)
[2018-03-08 06:56:45.818] New domain: spectrum.s3.amazonaws.com (5/1000)
[2018-03-08 06:56:45.824] New client: 10.10.10.55 (2/10)
[2018-03-08 06:56:45.832] New client: 10.10.10.9 (3/10)
[2018-03-08 06:56:45.832] New domain: www.google.com (6/1000)
[2018-03-08 06:56:45.839] New client: 10.10.10.100 (4/10)
[2018-03-08 06:56:45.840] New domain: tiles.services.mozilla.com (7/1000)
[2018-03-08 06:56:45.840] New domain: tiles.r53-2.services.mozilla.com (8/1000)
[2018-03-08 06:56:45.840] New domain: android.imap.mail.yahoo.com (9/1000)
[2018-03-08 06:56:45.847] New client: 10.10.10.10 (5/10)
[2018-03-08 06:56:45.848] New domain: stackoverflow.com (10/1000)
[2018-03-08 06:56:45.848] New domain: ajax.googleapis.com (11/1000)
[2018-03-08 06:56:45.848] New domain: cdn.sstatic.net (12/1000)
[2018-03-08 06:56:45.848] New domain: googleapis.l.google.com (13/1000)
[2018-03-08 06:56:45.849] New domain: ocsp.pki.goog (14/1000)
[2018-03-08 06:56:45.849] New domain: www3.l.google.com (15/1000)
[2018-03-08 06:56:45.849] New domain: www.gravatar.com (16/1000)
[2018-03-08 06:56:45.849] New domain: i.stack.imgur.com (17/1000)
[2018-03-08 06:56:45.850] New domain: stack.imgur.com.cdn.cloudflare.net (18/1000)
[2018-03-08 06:56:45.850] New domain: api.github.com (19/1000)
[2018-03-08 06:56:45.850] New domain: www.gstatic.com (20/1000)
[2018-03-08 06:56:45.851] New domain: github.com (21/1000)
[2018-03-08 06:56:45.851] New domain: dakboard.com (22/1000)
[2018-03-08 06:56:45.851] New domain: maxcdn.bootstrapcdn.com (23/1000)
[2018-03-08 06:56:45.851] New domain: fonts.googleapis.com (24/1000)
[2018-03-08 06:56:45.852] New domain: code.jquery.com (25/1000)
[2018-03-08 06:56:45.852] New domain: apis.google.com (26/1000)
[2018-03-08 06:56:45.852] New domain: scontent.fewr1-3.fna.fbcdn.net (27/1000)
[2018-03-08 06:56:45.852] New domain: fonts.gstatic.com (28/1000)
[2018-03-08 06:56:45.853] New domain: www.google-analytics.com (29/1000)
[2018-03-08 06:56:45.853] New domain: clients1.google.com (30/1000)
[2018-03-08 06:56:45.853] New domain: archive.raspberrypi.org (31/1000)
[2018-03-08 06:56:45.853] New domain: mirrordirector.raspbian.org (32/1000)
[2018-03-08 06:56:45.854] New domain: googleadapis.l.google.com (33/1000)
[2018-03-08 06:56:45.854] New domain: 2.gravatar.com (34/1000)
[2018-03-08 06:56:45.854] New domain: 1.gravatar.com (35/1000)
[2018-03-08 06:56:45.855] New domain: 0.gravatar.com (36/1000)
[2018-03-08 06:56:45.855] New domain: gstaticadssl.l.google.com (37/1000)
[2018-03-08 06:56:45.855] New domain: ocsp.int-x3.letsencrypt.org (38/1000)
[2018-03-08 06:56:45.855] New domain: a771.dscq.akamai.net (39/1000)
[2018-03-08 06:56:45.856] New domain: bootstrapcdn.jdorfman.netdna-cdn.com (40/1000)
[2018-03-08 06:56:45.856] New domain: code.jquery.netdna-cdn.com (41/1000)
[2018-03-08 06:56:45.856] New domain: ocsp.comodoca.com (42/1000)
[2018-03-08 06:56:45.863] New client: 10.10.10.84 (6/10)
[2018-03-08 06:56:45.864] New domain: mail.google.com (43/1000)
[2018-03-08 06:56:45.864] New domain: googlemail.l.google.com (44/1000)
[2018-03-08 06:56:45.865] New domain: clients2.google.com (45/1000)
[2018-03-08 06:56:45.865] New domain: clients.l.google.com (46/1000)
[2018-03-08 06:56:45.866] New domain: lh3.googleusercontent.com (47/1000)
[2018-03-08 06:56:45.866] New domain: googlehosted.l.googleusercontent.com (48/1000)
[2018-03-08 06:56:45.867] New domain: play.google.com (49/1000)
[2018-03-08 06:56:45.867] New domain: play.l.google.com (50/1000)
[2018-03-08 06:56:45.868] New domain: accounts.google.com (51/1000)
[2018-03-08 06:56:45.868] New domain: clients6.google.com (52/1000)
[2018-03-08 06:56:45.869] New domain: hangouts.google.com (53/1000)
[2018-03-08 06:56:45.869] New domain: ci6.googleusercontent.com (54/1000)
[2018-03-08 06:56:45.869] New domain: ci4.googleusercontent.com (55/1000)
[2018-03-08 06:56:45.870] New domain: photos-ugc.l.googleusercontent.com (56/1000)
[2018-03-08 06:56:45.870] New domain: notifications.google.com (57/1000)
[2018-03-08 06:56:45.871] New domain: plus.l.google.com (58/1000)
[2018-03-08 06:56:45.871] New domain: plus.google.com (59/1000)
[2018-03-08 06:56:45.871] New domain: people-pa.clients6.google.com (60/1000)
[2018-03-08 06:56:45.872] New domain: lh5.googleusercontent.com (61/1000)
[2018-03-08 06:56:45.872] New domain: lh4.googleusercontent.com (62/1000)
[2018-03-08 06:56:45.873] New domain: lh6.googleusercontent.com (63/1000)
[2018-03-08 06:56:45.873] New domain: 0.client-channel.google.com (64/1000)
[2018-03-08 06:56:45.874] New domain: clients4.google.com (65/1000)
[2018-03-08 06:56:45.874] New domain: dakboard-photos.nyc3.digitaloceanspaces.com (66/1000)
[2018-03-08 06:56:45.875] New domain: safebrowsing.google.com (67/1000)
[2018-03-08 06:56:45.875] New domain: safebrowsing-cache.google.com (68/1000)
[2018-03-08 06:56:45.875] New domain: js.stripe.com (69/1000)
[2018-03-08 06:56:45.876] New domain: stripecdn.map.fastly.net (70/1000)
[2018-03-08 06:56:45.884] New domain: q.stripe.com (71/1000)
[2018-03-08 06:56:45.885] New domain: dynupdate.noip.com (72/1000)
[2018-03-08 06:56:45.885] New domain: ntp-g7g.amazon.com (73/1000)
[2018-03-08 06:56:45.886] New domain: kindle-time.amazon.com (74/1000)
[2018-03-08 06:56:45.887] New domain: update.googleapis.com (75/1000)
[2018-03-08 06:56:45.887] New domain: redirector.gvt1.com (76/1000)
[2018-03-08 06:56:45.888] New domain: r5---sn-vgqskn7e.gvt1.com (77/1000)
[2018-03-08 06:56:45.888] New domain: m.stripe.network (78/1000)
[2018-03-08 06:56:45.889] New domain: r3---sn-vgqsrn76.gvt1.com (79/1000)
[2018-03-08 06:56:45.889] New domain: m.stripe.com (80/1000)
[2018-03-08 06:56:45.889] New domain: stripensrq.global.ssl.fastly.net (81/1000)
[2018-03-08 06:56:45.890] New domain: adservice.google.com (82/1000)
[2018-03-08 06:56:45.891] New domain: pagead46.l.doubleclick.net (83/1000)
[2018-03-08 06:56:45.891] New domain: raw.githubusercontent.com (84/1000)
[2018-03-08 06:56:45.892] New domain: 3.debian.pool.ntp.org (85/1000)
[2018-03-08 06:56:45.892] Notice: Increasing overTime struct size from 100 to 200 (471.21 KB)
[2018-03-08 06:56:45.892] at query time:
[2018-03-08 06:56:45.893] Notice: Increasing overTime struct size from 200 to 300 (476.01 KB)
[2018-03-08 06:56:45.893] at query time:
[2018-03-08 06:56:45.894] Notice: Increasing overTime struct size from 300 to 400 (480.81 KB)
[2018-03-08 06:56:45.894] at query time:
[2018-03-08 06:56:45.895] Notice: Increasing overTime struct size from 400 to 500 (485.61 KB)
[2018-03-08 06:56:45.895] at query time:
[2018-03-08 06:56:45.896] Notice: Increasing overTime struct size from 500 to 600 (490.41 KB)
[2018-03-08 06:56:45.896] at query time:
[2018-03-08 06:56:45.897] Notice: Increasing overTime struct size from 600 to 700 (495.21 KB)
[2018-03-08 06:56:45.897] at query time:
[2018-03-08 06:56:45.898] Notice: Increasing overTime struct size from 700 to 800 (500.01 KB)
[2018-03-08 06:56:45.898] at query time:
[2018-03-08 06:56:45.899] Notice: Increasing overTime struct size from 800 to 900 (504.81 KB)
[2018-03-08 06:56:45.899] at query time:
[2018-03-08 06:56:45.899] Notice: Increasing overTime struct size from 900 to 1000 (509.61 KB)
[2018-03-08 06:56:45.900] at query time:
[2018-03-08 06:56:45.900] Notice: Increasing overTime struct size from 1000 to 1100 (514.41 KB)
[2018-03-08 06:56:45.901] at query time:
[2018-03-08 06:56:45.901] Notice: Increasing overTime struct size from 1100 to 1200 (519.21 KB)
[2018-03-08 06:56:45.902] at query time:
[2018-03-08 06:56:45.902] Notice: Increasing overTime struct size from 1200 to 1300 (524.01 KB)
[2018-03-08 06:56:45.902] at query time:
[2018-03-08 06:56:45.903] Notice: Increasing overTime struct size from 1300 to 1400 (528.81 KB)
[2018-03-08 06:56:45.903] at query time:
[2018-03-08 06:56:45.904] Notice: Increasing overTime struct size from 1400 to 1500 (533.61 KB)
[2018-03-08 06:56:45.904] at query time:
[2018-03-08 06:56:45.905] Notice: Increasing overTime struct size from 1500 to 1600 (538.41 KB)
[2018-03-08 06:56:45.905] at query time:
[2018-03-08 06:56:45.906] Notice: Increasing overTime struct size from 1600 to 1700 (543.21 KB)
[2018-03-08 06:56:45.907] at query time:
[2018-03-08 06:56:45.907] Notice: Increasing overTime struct size from 1700 to 1800 (548.01 KB)
[2018-03-08 06:56:45.907] at query time:
[2018-03-08 06:56:45.908] Notice: Increasing overTime struct size from 1800 to 1900 (552.81 KB)
[2018-03-08 06:56:45.908] at query time:
[2018-03-08 06:56:45.909] Notice: Increasing overTime struct size from 1900 to 2000 (557.61 KB)
[2018-03-08 06:56:45.909] at query time:
[2018-03-08 06:56:45.910] Notice: Increasing overTime struct size from 2000 to 2100 (562.41 KB)
[2018-03-08 06:56:45.910] at query time:
[2018-03-08 06:56:45.910] Notice: Increasing overTime struct size from 2100 to 2200 (567.21 KB)
[2018-03-08 06:56:45.911] at query time:
[2018-03-08 06:56:45.911] Notice: Increasing overTime struct size from 2200 to 2300 (572.01 KB)
[2018-03-08 06:56:45.911] at query time:
[2018-03-08 06:56:45.912] Notice: Increasing overTime struct size from 2300 to 2400 (576.81 KB)
[2018-03-08 06:56:45.912] at query time:
[2018-03-08 06:56:45.913] Notice: Increasing overTime struct size from 2400 to 2500 (581.61 KB)
[2018-03-08 06:56:45.913] at query time:
[2018-03-08 06:56:45.913] Notice: Increasing overTime struct size from 2500 to 2600 (586.41 KB)
[2018-03-08 06:56:45.914] at query time:
[2018-03-08 06:56:45.914] Notice: Increasing overTime struct size from 2600 to 2700 (591.21 KB)
[2018-03-08 06:56:45.914] at query time:
[2018-03-08 06:56:45.915] Notice: Increasing overTime struct size from 2700 to 2800 (596.01 KB)
[2018-03-08 06:56:45.915] at query time:
[2018-03-08 06:56:45.916] Notice: Increasing overTime struct size from 2800 to 2900 (600.81 KB)
[2018-03-08 06:56:45.916] at query time:
[2018-03-08 06:56:45.917] Notice: Increasing overTime struct size from 2900 to 3000 (605.61 KB)
[2018-03-08 06:56:45.917] at query time:
[2018-03-08 06:56:45.917] Notice: Increasing overTime struct size from 3000 to 3100 (610.41 KB)
[2018-03-08 06:56:45.918] at query time:
[2018-03-08 06:56:45.918] Notice: Increasing overTime struct size from 3100 to 3200 (615.21 KB)
[2018-03-08 06:56:45.918] at query time:
[2018-03-08 06:56:45.919] Notice: Increasing overTime struct size from 3200 to 3300 (620.01 KB)
[2018-03-08 06:56:45.919] at query time:
[2018-03-08 06:56:45.919] Notice: Increasing overTime struct size from 3300 to 3400 (624.81 KB)
[2018-03-08 06:56:45.920] at query time:
[2018-03-08 06:56:45.921] Notice: Increasing overTime struct size from 3400 to 3500 (629.61 KB)
[2018-03-08 06:56:45.922] at query time:
[2018-03-08 06:56:45.922] Notice: Increasing overTime struct size from 3500 to 3600 (634.41 KB)
[2018-03-08 06:56:45.923] at query time:
[2018-03-08 06:56:45.923] Notice: Increasing overTime struct size from 3600 to 3700 (639.21 KB)
[2018-03-08 06:56:45.923] at query time:
[2018-03-08 06:56:45.924] Notice: Increasing overTime struct size from 3700 to 3800 (644.01 KB)
[2018-03-08 06:56:45.924] at query time:
[2018-03-08 06:56:45.925] Notice: Increasing overTime struct size from 3800 to 3900 (648.81 KB)
[2018-03-08 06:56:45.925] at query time:
[2018-03-08 06:56:45.925] Notice: Increasing overTime struct size from 3900 to 4000 (653.61 KB)
[2018-03-08 06:56:45.926] at query time:
[2018-03-08 06:56:45.926] Notice: Increasing overTime struct size from 4000 to 4100 (658.41 KB)
[2018-03-08 06:56:45.927] at query time:
[2018-03-08 06:56:45.927] Notice: Increasing overTime struct size from 4100 to 4200 (663.21 KB)
[2018-03-08 06:56:45.927] at query time:
[2018-03-08 06:56:45.928] Notice: Increasing overTime struct size from 4200 to 4300 (668.01 KB)
[2018-03-08 06:56:45.928] at query time:
[2018-03-08 06:56:45.928] Notice: Increasing overTime struct size from 4300 to 4400 (672.81 KB)
[2018-03-08 06:56:45.929] at query time:
[2018-03-08 06:56:45.929] Notice: Increasing overTime struct size from 4400 to 4500 (677.61 KB)
[2018-03-08 06:56:45.929] at query time:
[2018-03-08 06:56:45.930] Notice: Increasing overTime struct size from 4500 to 4600 (682.41 KB)
[2018-03-08 06:56:45.930] at query time:
[2018-03-08 06:56:45.930] Notice: Increasing overTime struct size from 4600 to 4700 (687.21 KB)
[2018-03-08 06:56:45.931] at query time:
[2018-03-08 06:56:45.931] Notice: Increasing overTime struct size from 4700 to 4800 (692.01 KB)
[2018-03-08 06:56:45.931] at query time:
[2018-03-08 06:56:45.932] Notice: Increasing overTime struct size from 4800 to 4900 (696.81 KB)
[2018-03-08 06:56:45.932] at query time:
[2018-03-08 06:56:45.932] Notice: Increasing overTime struct size from 4900 to 5000 (701.61 KB)
[2018-03-08 06:56:45.933] at query time:
[2018-03-08 06:56:45.933] Notice: Increasing overTime struct size from 5000 to 5100 (706.41 KB)
[2018-03-08 06:56:45.933] at query time:
[2018-03-08 06:56:45.934] Notice: Increasing overTime struct size from 5100 to 5200 (711.21 KB)
[2018-03-08 06:56:45.934] at query time:
[2018-03-08 06:56:45.934] Notice: Increasing overTime struct size from 5200 to 5300 (716.01 KB)
[2018-03-08 06:56:45.934] at query time:
[2018-03-08 06:56:45.935] Notice: Increasing overTime struct size from 5300 to 5400 (720.81 KB)
[2018-03-08 06:56:45.935] at query time:
[2018-03-08 06:56:45.935] Notice: Increasing overTime struct size from 5400 to 5500 (725.61 KB)
[2018-03-08 06:56:45.936] at query time:
[2018-03-08 06:56:45.936] Notice: Increasing overTime struct size from 5500 to 5600 (730.41 KB)
[2018-03-08 06:56:45.937] at query time:
[2018-03-08 06:56:45.937] Notice: Increasing overTime struct size from 5600 to 5700 (735.21 KB)
[2018-03-08 06:56:45.937] at query time:
[2018-03-08 06:56:45.938] Notice: Increasing overTime struct size from 5700 to 5800 (740.01 KB)
[2018-03-08 06:56:45.938] at query time:
[2018-03-08 06:56:45.938] Notice: Increasing overTime struct size from 5800 to 5900 (744.81 KB)
[2018-03-08 06:56:45.939] at query time:
[2018-03-08 06:56:45.939] Notice: Increasing overTime struct size from 5900 to 6000 (749.61 KB)
[2018-03-08 06:56:45.939] at query time:
[2018-03-08 06:56:45.940] Notice: Increasing overTime struct size from 6000 to 6100 (754.41 KB)
[2018-03-08 06:56:45.940] at query time:
[2018-03-08 06:56:45.940] Notice: Increasing overTime struct size from 6100 to 6200 (759.21 KB)
[2018-03-08 06:56:45.941] at query time:
[2018-03-08 06:56:45.941] Notice: Increasing overTime struct size from 6200 to 6300 (764.01 KB)
[2018-03-08 06:56:45.941] at query time:
[2018-03-08 06:56:45.942] Notice: Increasing overTime struct size from 6300 to 6400 (768.81 KB)
[2018-03-08 06:56:45.942] at query time:
[2018-03-08 06:56:45.942] Notice: Increasing overTime struct size from 6400 to 6500 (773.61 KB)
[2018-03-08 06:56:45.943] at query time:
[2018-03-08 06:56:45.943] Notice: Increasing overTime struct size from 6500 to 6600 (778.41 KB)
[2018-03-08 06:56:45.943] at query time:
[2018-03-08 06:56:45.944] Notice: Increasing overTime struct size from 6600 to 6700 (783.21 KB)
[2018-03-08 06:56:45.944] at query time:
[2018-03-08 06:56:45.944] Notice: Increasing overTime struct size from 6700 to 6800 (788.01 KB)
[2018-03-08 06:56:45.945] at query time:
[2018-03-08 06:56:45.945] Notice: Increasing overTime struct size from 6800 to 6900 (792.81 KB)
[2018-03-08 06:56:45.945] at query time:
[2018-03-08 06:56:45.946] Notice: Increasing overTime struct size from 6900 to 7000 (797.61 KB)
[2018-03-08 06:56:45.946] at query time:
[2018-03-08 06:56:45.947] Notice: Increasing overTime struct size from 7000 to 7100 (802.41 KB)
[2018-03-08 06:56:45.947] at query time:
[2018-03-08 06:56:45.947] Notice: Increasing overTime struct size from 7100 to 7200 (807.21 KB)
[2018-03-08 06:56:45.948] at query time:
[2018-03-08 06:56:45.948] Notice: Increasing overTime struct size from 7200 to 7300 (812.01 KB)
[2018-03-08 06:56:45.948] at query time:
[2018-03-08 06:56:45.949] Notice: Increasing overTime struct size from 7300 to 7400 (816.81 KB)
[2018-03-08 06:56:45.949] at query time:
[2018-03-08 06:56:45.949] Notice: Increasing overTime struct size from 7400 to 7500 (821.61 KB)
[2018-03-08 06:56:45.950] at query time:
[2018-03-08 06:56:45.950] Notice: Increasing overTime struct size from 7500 to 7600 (826.41 KB)
[2018-03-08 06:56:45.950] at query time:
[2018-03-08 06:56:45.951] Notice: Increasing overTime struct size from 7600 to 7700 (831.21 KB)
[2018-03-08 06:56:45.951] at query time:
[2018-03-08 06:56:45.951] Notice: Increasing overTime struct size from 7700 to 7800 (836.01 KB)
[2018-03-08 06:56:45.952] at query time:
[2018-03-08 06:56:45.952] Notice: Increasing overTime struct size from 7800 to 7900 (840.81 KB)
[2018-03-08 06:56:45.952] at query time:
[2018-03-08 06:56:45.953] Notice: Increasing overTime struct size from 7900 to 8000 (845.61 KB)
[2018-03-08 06:56:45.953] at query time:
[2018-03-08 06:56:45.953] Notice: Increasing overTime struct size from 8000 to 8100 (850.41 KB)
[2018-03-08 06:56:45.954] at query time:
[2018-03-08 06:56:45.954] Notice: Increasing overTime struct size from 8100 to 8200 (855.21 KB)
[2018-03-08 06:56:45.954] at query time:
[2018-03-08 06:56:45.955] Notice: Increasing overTime struct size from 8200 to 8300 (860.01 KB)
[2018-03-08 06:56:45.955] at query time:
[2018-03-08 06:56:45.955] Notice: Increasing overTime struct size from 8300 to 8400 (864.81 KB)
[2018-03-08 06:56:45.956] at query time:
[2018-03-08 06:56:45.956] Notice: Increasing overTime struct size from 8400 to 8500 (869.61 KB)
[2018-03-08 06:56:45.956] at query time:
[2018-03-08 06:56:45.957] Notice: Increasing overTime struct size from 8500 to 8600 (874.41 KB)
[2018-03-08 06:56:45.957] at query time:
[2018-03-08 06:56:45.957] Notice: Increasing overTime struct size from 8600 to 8700 (879.21 KB)
[2018-03-08 06:56:45.958] at query time:
[2018-03-08 06:56:45.958] Notice: Increasing overTime struct size from 8700 to 8800 (884.01 KB)
[2018-03-08 06:56:45.958] at query time:
[2018-03-08 06:56:45.959] Notice: Increasing overTime struct size from 8800 to 8900 (888.81 KB)
[2018-03-08 06:56:45.959] at query time:
[2018-03-08 06:56:45.959] Notice: Increasing overTime struct size from 8900 to 9000 (893.61 KB)
[2018-03-08 06:56:45.960] at query time:
[2018-03-08 06:56:45.960] Notice: Increasing overTime struct size from 9000 to 9100 (898.41 KB)
[2018-03-08 06:56:45.960] at query time:
[2018-03-08 06:56:45.961] Notice: Increasing overTime struct size from 9100 to 9200 (903.21 KB)
[2018-03-08 06:56:45.961] at query time:
[2018-03-08 06:56:45.961] Notice: Increasing overTime struct size from 9200 to 9300 (908.01 KB)
[2018-03-08 06:56:45.961] at query time:
[2018-03-08 06:56:45.962] Notice: Increasing overTime struct size from 9300 to 9400 (912.81 KB)
[2018-03-08 06:56:45.962] at query time:
[2018-03-08 06:56:45.963] Notice: Increasing overTime struct size from 9400 to 9500 (917.61 KB)
[2018-03-08 06:56:45.963] at query time:
[2018-03-08 06:56:45.963] Notice: Increasing overTime struct size from 9500 to 9600 (922.41 KB)
[2018-03-08 06:56:45.963] at query time:
[2018-03-08 06:56:45.964] Notice: Increasing overTime struct size from 9600 to 9700 (927.21 KB)
[2018-03-08 06:56:45.964] at query time:
[2018-03-08 06:56:45.964] Notice: Increasing overTime struct size from 9700 to 9800 (932.01 KB)
[2018-03-08 06:56:45.965] at query time:
[2018-03-08 06:56:45.965] Notice: Increasing overTime struct size from 9800 to 9900 (936.81 KB)
[2018-03-08 06:56:45.965] at query time:
[2018-03-08 06:56:45.966] Notice: Increasing overTime struct size from 9900 to 10000 (941.61 KB)
[2018-03-08 06:56:45.966] at query time:
[2018-03-08 06:56:45.967] Notice: Increasing overTime struct size from 10000 to 10100 (946.41 KB)
[2018-03-08 06:56:45.967] at query time:
[2018-03-08 06:56:45.967] Notice: Increasing overTime struct size from 10100 to 10200 (951.21 KB)
[2018-03-08 06:56:45.968] at query time:
[2018-03-08 06:56:45.968] Notice: Increasing overTime struct size from 10200 to 10300 (956.01 KB)
[2018-03-08 06:56:45.968] at query time:
[2018-03-08 06:56:45.969] Notice: Increasing overTime struct size from 10300 to 10400 (960.81 KB)
[2018-03-08 06:56:45.969] at query time:
[2018-03-08 06:56:45.969] Notice: Increasing overTime struct size from 10400 to 10500 (965.61 KB)
[2018-03-08 06:56:45.970] at query time:
[2018-03-08 06:56:45.970] Notice: Increasing overTime struct size from 10500 to 10600 (970.41 KB)
[2018-03-08 06:56:45.970] at query time:
[2018-03-08 06:56:45.971] Notice: Increasing overTime struct size from 10600 to 10700 (975.21 KB)
[2018-03-08 06:56:45.971] at query time:
[2018-03-08 06:56:45.971] Notice: Increasing overTime struct size from 10700 to 10800 (980.01 KB)
[2018-03-08 06:56:45.972] at query time:
[2018-03-08 06:56:45.972] Notice: Increasing overTime struct size from 10800 to 10900 (984.81 KB)
[2018-03-08 06:56:45.972] at query time:
[2018-03-08 06:56:45.973] Notice: Increasing overTime struct size from 10900 to 11000 (989.61 KB)
[2018-03-08 06:56:45.973] at query time:
[2018-03-08 06:56:45.973] Notice: Increasing overTime struct size from 11000 to 11100 (994.41 KB)
[2018-03-08 06:56:45.974] at query time:
[2018-03-08 06:56:45.974] Notice: Increasing overTime struct size from 11100 to 11200 (999.21 KB)
[2018-03-08 06:56:45.974] at query time:
[2018-03-08 06:56:45.975] Notice: Increasing overTime struct size from 11200 to 11300 (1.00 MB)
[2018-03-08 06:56:45.975] at query time:
[2018-03-08 06:56:45.975] Notice: Increasing overTime struct size from 11300 to 11400 (1.01 MB)
[2018-03-08 06:56:45.976] at query time:
[2018-03-08 06:56:45.976] Notice: Increasing overTime struct size from 11400 to 11500 (1.01 MB)
[2018-03-08 06:56:45.976] at query time:
[2018-03-08 06:56:45.977] Notice: Increasing overTime struct size from 11500 to 11600 (1.02 MB)
[2018-03-08 06:56:45.977] at query time:
[2018-03-08 06:56:45.977] Notice: Increasing overTime struct size from 11600 to 11700 (1.02 MB)
[2018-03-08 06:56:45.978] at query time:
[2018-03-08 06:56:45.978] Notice: Increasing overTime struct size from 11700 to 11800 (1.03 MB)
[2018-03-08 06:56:45.978] at query time:
[2018-03-08 06:56:45.979] Notice: Increasing overTime struct size from 11800 to 11900 (1.03 MB)
[2018-03-08 06:56:45.979] at query time:
[2018-03-08 06:56:45.979] Notice: Increasing overTime struct size from 11900 to 12000 (1.04 MB)
[2018-03-08 06:56:45.980] at query time:
[2018-03-08 06:56:45.980] Notice: Increasing overTime struct size from 12000 to 12100 (1.04 MB)
[2018-03-08 06:56:45.980] at query time:
[2018-03-08 06:56:45.981] Notice: Increasing overTime struct size from 12100 to 12200 (1.05 MB)
[2018-03-08 06:56:45.981] at query time:
[2018-03-08 06:56:45.981] Notice: Increasing overTime struct size from 12200 to 12300 (1.05 MB)
[2018-03-08 06:56:45.982] at query time:
[2018-03-08 06:56:45.982] Notice: Increasing overTime struct size from 12300 to 12400 (1.06 MB)
[2018-03-08 06:56:45.982] at query time:
[2018-03-08 06:56:45.983] Notice: Increasing overTime struct size from 12400 to 12500 (1.06 MB)
[2018-03-08 06:56:45.983] at query time:
[2018-03-08 06:56:45.983] Notice: Increasing overTime struct size from 12500 to 12600 (1.07 MB)
[2018-03-08 06:56:45.984] at query time:
[2018-03-08 06:56:45.984] Notice: Increasing overTime struct size from 12600 to 12700 (1.07 MB)
[2018-03-08 06:56:45.984] at query time:
[2018-03-08 06:56:45.985] Notice: Increasing overTime struct size from 12700 to 12800 (1.08 MB)
[2018-03-08 06:56:45.985] at query time:
[2018-03-08 06:56:45.985] Notice: Increasing overTime struct size from 12800 to 12900 (1.08 MB)
[2018-03-08 06:56:45.985] at query time:
[2018-03-08 06:56:45.986] Notice: Increasing overTime struct size from 12900 to 13000 (1.09 MB)
[2018-03-08 06:56:45.986] at query time:
[2018-03-08 06:56:45.987] Notice: Increasing overTime struct size from 13000 to 13100 (1.09 MB)
[2018-03-08 06:56:45.987] at query time:
[2018-03-08 06:56:45.987] Notice: Increasing overTime struct size from 13100 to 13200 (1.10 MB)
[2018-03-08 06:56:45.987] at query time:
[2018-03-08 06:56:45.988] Notice: Increasing overTime struct size from 13200 to 13300 (1.10 MB)
[2018-03-08 06:56:45.988] at query time:
[2018-03-08 06:56:45.988] Notice: Increasing overTime struct size from 13300 to 13400 (1.10 MB)
[2018-03-08 06:56:45.989] at query time:
[2018-03-08 06:56:45.989] Notice: Increasing overTime struct size from 13400 to 13500 (1.11 MB)
[2018-03-08 06:56:45.990] at query time:
[2018-03-08 06:56:45.990] Notice: Increasing overTime struct size from 13500 to 13600 (1.11 MB)
[2018-03-08 06:56:45.990] at query time:
[2018-03-08 06:56:45.991] Notice: Increasing overTime struct size from 13600 to 13700 (1.12 MB)
[2018-03-08 06:56:45.991] at query time:
[2018-03-08 06:56:45.991] Notice: Increasing overTime struct size from 13700 to 13800 (1.12 MB)
[2018-03-08 06:56:45.992] at query time:
[2018-03-08 06:56:45.992] Notice: Increasing overTime struct size from 13800 to 13900 (1.13 MB)
[2018-03-08 06:56:45.992] at query time:
[2018-03-08 06:56:45.993] Notice: Increasing overTime struct size from 13900 to 14000 (1.13 MB)
[2018-03-08 06:56:45.993] at query time:
[2018-03-08 06:56:45.993] Notice: Increasing overTime struct size from 14000 to 14100 (1.14 MB)
[2018-03-08 06:56:45.993] at query time:
[2018-03-08 06:56:45.994] Notice: Increasing overTime struct size from 14100 to 14200 (1.14 MB)
[2018-03-08 06:56:45.994] at query time:
[2018-03-08 06:56:45.994] Notice: Increasing overTime struct size from 14200 to 14300 (1.15 MB)
[2018-03-08 06:56:45.995] at query time:
[2018-03-08 06:56:45.995] Notice: Increasing overTime struct size from 14300 to 14400 (1.15 MB)
[2018-03-08 06:56:45.995] at query time:
[2018-03-08 06:56:45.996] Notice: Increasing overTime struct size from 14400 to 14500 (1.16 MB)
[2018-03-08 06:56:45.996] at query time:
[2018-03-08 06:56:45.997] Notice: Increasing overTime struct size from 14500 to 14600 (1.16 MB)
[2018-03-08 06:56:45.997] at query time:
[2018-03-08 06:56:45.997] Notice: Increasing overTime struct size from 14600 to 14700 (1.17 MB)
[2018-03-08 06:56:45.997] at query time:
[2018-03-08 06:56:45.998] Notice: Increasing overTime struct size from 14700 to 14800 (1.17 MB)
[2018-03-08 06:56:45.998] at query time:
[2018-03-08 06:56:45.998] Notice: Increasing overTime struct size from 14800 to 14900 (1.18 MB)
[2018-03-08 06:56:45.999] at query time:
[2018-03-08 06:56:45.999] Notice: Increasing overTime struct size from 14900 to 15000 (1.18 MB)
[2018-03-08 06:56:45.999] at query time:
[2018-03-08 06:56:46.000] Notice: Increasing overTime struct size from 15000 to 15100 (1.19 MB)
[2018-03-08 06:56:46.000] at query time:
[2018-03-08 06:56:46.000] Notice: Increasing overTime struct size from 15100 to 15200 (1.19 MB)
[2018-03-08 06:56:46.001] at query time:
[2018-03-08 06:56:46.001] Notice: Increasing overTime struct size from 15200 to 15300 (1.20 MB)
[2018-03-08 06:56:46.001] at query time:
[2018-03-08 06:56:46.002] Notice: Increasing overTime struct size from 15300 to 15400 (1.20 MB)
[2018-03-08 06:56:46.002] at query time:
[2018-03-08 06:56:46.002] Notice: Increasing overTime struct size from 15400 to 15500 (1.21 MB)
[2018-03-08 06:56:46.003] at query time:
[2018-03-08 06:56:46.003] Notice: Increasing overTime struct size from 15500 to 15600 (1.21 MB)
[2018-03-08 06:56:46.003] at query time:
[2018-03-08 06:56:46.004] Notice: Increasing overTime struct size from 15600 to 15700 (1.22 MB)
[2018-03-08 06:56:46.004] at query time:
[2018-03-08 06:56:46.004] Notice: Increasing overTime struct size from 15700 to 15800 (1.22 MB)
[2018-03-08 06:56:46.005] at query time:
[2018-03-08 06:56:46.005] Notice: Increasing overTime struct size from 15800 to 15900 (1.22 MB)
[2018-03-08 06:56:46.005] at query time:
[2018-03-08 06:56:46.006] Notice: Increasing overTime struct size from 15900 to 16000 (1.23 MB)
[2018-03-08 06:56:46.006] at query time:
[2018-03-08 06:56:46.007] Notice: Increasing overTime struct size from 16000 to 16100 (1.23 MB)
[2018-03-08 06:56:46.007] at query time:
[2018-03-08 06:56:46.007] Notice: Increasing overTime struct size from 16100 to 16200 (1.24 MB)
[2018-03-08 06:56:46.008] at query time:
[2018-03-08 06:56:46.008] Notice: Increasing overTime struct size from 16200 to 16300 (1.24 MB)
[2018-03-08 06:56:46.008] at query time:
[2018-03-08 06:56:46.009] Notice: Increasing overTime struct size from 16300 to 16400 (1.25 MB)
[2018-03-08 06:56:46.009] at query time:
[2018-03-08 06:56:46.009] Notice: Increasing overTime struct size from 16400 to 16500 (1.25 MB)
[2018-03-08 06:56:46.010] at query time:
[2018-03-08 06:56:46.010] Notice: Increasing overTime struct size from 16500 to 16600 (1.26 MB)
[2018-03-08 06:56:46.010] at query time:
[2018-03-08 06:56:46.011] Notice: Increasing overTime struct size from 16600 to 16700 (1.26 MB)
[2018-03-08 06:56:46.011] at query time:
[2018-03-08 06:56:46.011] Notice: Increasing overTime struct size from 16700 to 16800 (1.27 MB)
[2018-03-08 06:56:46.012] at query time:
[2018-03-08 06:56:46.012] Notice: Increasing overTime struct size from 16800 to 16900 (1.27 MB)
[2018-03-08 06:56:46.012] at query time:
[2018-03-08 06:56:46.013] Notice: Increasing overTime struct size from 16900 to 17000 (1.28 MB)
[2018-03-08 06:56:46.013] at query time:
[2018-03-08 06:56:46.013] Notice: Increasing overTime struct size from 17000 to 17100 (1.28 MB)
[2018-03-08 06:56:46.014] at query time:
[2018-03-08 06:56:46.014] Notice: Increasing overTime struct size from 17100 to 17200 (1.29 MB)
[2018-03-08 06:56:46.014] at query time:
[2018-03-08 06:56:46.015] Notice: Increasing overTime struct size from 17200 to 17300 (1.29 MB)
[2018-03-08 06:56:46.015] at query time:
[2018-03-08 06:56:46.015] Notice: Increasing overTime struct size from 17300 to 17400 (1.30 MB)
[2018-03-08 06:56:46.015] at query time:
[2018-03-08 06:56:46.016] Notice: Increasing overTime struct size from 17400 to 17500 (1.30 MB)
[2018-03-08 06:56:46.016] at query time:
[2018-03-08 06:56:46.017] Notice: Increasing overTime struct size from 17500 to 17600 (1.31 MB)
[2018-03-08 06:56:46.017] at query time:
[2018-03-08 06:56:46.017] Notice: Increasing overTime struct size from 17600 to 17700 (1.31 MB)
[2018-03-08 06:56:46.018] at query time:
[2018-03-08 06:56:46.018] Notice: Increasing overTime struct size from 17700 to 17800 (1.32 MB)
[2018-03-08 06:56:46.018] at query time:
[2018-03-08 06:56:46.019] Notice: Increasing overTime struct size from 17800 to 17900 (1.32 MB)
[2018-03-08 06:56:46.019] at query time:
[2018-03-08 06:56:46.019] Notice: Increasing overTime struct size from 17900 to 18000 (1.33 MB)
[2018-03-08 06:56:46.020] at query time:
[2018-03-08 06:56:46.020] Notice: Increasing overTime struct size from 18000 to 18100 (1.33 MB)
[2018-03-08 06:56:46.020] at query time:
[2018-03-08 06:56:46.021] Notice: Increasing overTime struct size from 18100 to 18200 (1.34 MB)
[2018-03-08 06:56:46.021] at query time:
[2018-03-08 06:56:46.021] Notice: Increasing overTime struct size from 18200 to 18300 (1.34 MB)
[2018-03-08 06:56:46.022] at query time:
[2018-03-08 06:56:46.022] Notice: Increasing overTime struct size from 18300 to 18400 (1.34 MB)
[2018-03-08 06:56:46.022] at query time:
[2018-03-08 06:56:46.023] Notice: Increasing overTime struct size from 18400 to 18500 (1.35 MB)
[2018-03-08 06:56:46.023] at query time:
[2018-03-08 06:56:46.023] Notice: Increasing overTime struct size from 18500 to 18600 (1.35 MB)
[2018-03-08 06:56:46.024] at query time:
[2018-03-08 06:56:46.024] Notice: Increasing overTime struct size from 18600 to 18700 (1.36 MB)
[2018-03-08 06:56:46.024] at query time:
[2018-03-08 06:56:46.025] Notice: Increasing overTime struct size from 18700 to 18800 (1.36 MB)
[2018-03-08 06:56:46.025] at query time:
[2018-03-08 06:56:46.025] Notice: Increasing overTime struct size from 18800 to 18900 (1.37 MB)
[2018-03-08 06:56:46.026] at query time:
[2018-03-08 06:56:46.026] Notice: Increasing overTime struct size from 18900 to 19000 (1.37 MB)
[2018-03-08 06:56:46.026] at query time:
[2018-03-08 06:56:46.027] Notice: Increasing overTime struct size from 19000 to 19100 (1.38 MB)
[2018-03-08 06:56:46.027] at query time:
[2018-03-08 06:56:46.027] Notice: Increasing overTime struct size from 19100 to 19200 (1.38 MB)
[2018-03-08 06:56:46.028] at query time:
[2018-03-08 06:56:46.028] Notice: Increasing overTime struct size from 19200 to 19300 (1.39 MB)
[2018-03-08 06:56:46.028] at query time:
[2018-03-08 06:56:46.029] Notice: Increasing overTime struct size from 19300 to 19400 (1.39 MB)
[2018-03-08 06:56:46.029] at query time:
[2018-03-08 06:56:46.029] Notice: Increasing overTime struct size from 19400 to 19500 (1.40 MB)
[2018-03-08 06:56:46.030] at query time:
[2018-03-08 06:56:46.030] Notice: Increasing overTime struct size from 19500 to 19600 (1.40 MB)
[2018-03-08 06:56:46.030] at query time:
[2018-03-08 06:56:46.031] Notice: Increasing overTime struct size from 19600 to 19700 (1.41 MB)
[2018-03-08 06:56:46.031] at query time:
[2018-03-08 06:56:46.031] Notice: Increasing overTime struct size from 19700 to 19800 (1.41 MB)
[2018-03-08 06:56:46.032] at query time:
[2018-03-08 06:56:46.032] Notice: Increasing overTime struct size from 19800 to 19900 (1.42 MB)
[2018-03-08 06:56:46.032] at query time:
[2018-03-08 06:56:46.033] Notice: Increasing overTime struct size from 19900 to 20000 (1.42 MB)
[2018-03-08 06:56:46.033] at query time:
[2018-03-08 06:56:46.033] Notice: Increasing overTime struct size from 20000 to 20100 (1.43 MB)
[2018-03-08 06:56:46.034] at query time:
[2018-03-08 06:56:46.034] Notice: Increasing overTime struct size from 20100 to 20200 (1.43 MB)
[2018-03-08 06:56:46.034] at query time:
[2018-03-08 06:56:46.035] Notice: Increasing overTime struct size from 20200 to 20300 (1.44 MB)
[2018-03-08 06:56:46.035] at query time:
[2018-03-08 06:56:46.035] Notice: Increasing overTime struct size from 20300 to 20400 (1.44 MB)
[2018-03-08 06:56:46.036] at query time:
[2018-03-08 06:56:46.036] Notice: Increasing overTime struct size from 20400 to 20500 (1.45 MB)
[2018-03-08 06:56:46.037] at query time:
[2018-03-08 06:56:46.037] Notice: Increasing overTime struct size from 20500 to 20600 (1.45 MB)
[2018-03-08 06:56:46.038] at query time:
[2018-03-08 06:56:46.038] Notice: Increasing overTime struct size from 20600 to 20700 (1.46 MB)
[2018-03-08 06:56:46.038] at query time:
[2018-03-08 06:56:46.039] Notice: Increasing overTime struct size from 20700 to 20800 (1.46 MB)
[2018-03-08 06:56:46.039] at query time:
[2018-03-08 06:56:46.039] Notice: Increasing overTime struct size from 20800 to 20900 (1.46 MB)
[2018-03-08 06:56:46.040] at query time:
[2018-03-08 06:56:46.040] Notice: Increasing overTime struct size from 20900 to 21000 (1.47 MB)
[2018-03-08 06:56:46.040] at query time:
[2018-03-08 06:56:46.041] Notice: Increasing overTime struct size from 21000 to 21100 (1.47 MB)
[2018-03-08 06:56:46.041] at query time:
[2018-03-08 06:56:46.041] Notice: Increasing overTime struct size from 21100 to 21200 (1.48 MB)
[2018-03-08 06:56:46.042] at query time:
[2018-03-08 06:56:46.042] Notice: Increasing overTime struct size from 21200 to 21300 (1.48 MB)
[2018-03-08 06:56:46.042] at query time:
[2018-03-08 06:56:46.043] Notice: Increasing overTime struct size from 21300 to 21400 (1.49 MB)
[2018-03-08 06:56:46.043] at query time:
[2018-03-08 06:56:46.043] Notice: Increasing overTime struct size from 21400 to 21500 (1.49 MB)
[2018-03-08 06:56:46.043] at query time:
[2018-03-08 06:56:46.044] Notice: Increasing overTime struct size from 21500 to 21600 (1.50 MB)
[2018-03-08 06:56:46.044] at query time:
[2018-03-08 06:56:46.045] Notice: Increasing overTime struct size from 21600 to 21700 (1.50 MB)
[2018-03-08 06:56:46.045] at query time:
[2018-03-08 06:56:46.045] Notice: Increasing overTime struct size from 21700 to 21800 (1.51 MB)
[2018-03-08 06:56:46.046] at query time:
[2018-03-08 06:56:46.046] Notice: Increasing overTime struct size from 21800 to 21900 (1.51 MB)
[2018-03-08 06:56:46.046] at query time:
[2018-03-08 06:56:46.047] Notice: Increasing overTime struct size from 21900 to 22000 (1.52 MB)
[2018-03-08 06:56:46.047] at query time:
[2018-03-08 06:56:46.048] Notice: Increasing overTime struct size from 22000 to 22100 (1.52 MB)
[2018-03-08 06:56:46.048] at query time:
[2018-03-08 06:56:46.048] Notice: Increasing overTime struct size from 22100 to 22200 (1.53 MB)
[2018-03-08 06:56:46.048] at query time:
[2018-03-08 06:56:46.049] Notice: Increasing overTime struct size from 22200 to 22300 (1.53 MB)
[2018-03-08 06:56:46.049] at query time:
[2018-03-08 06:56:46.049] Notice: Increasing overTime struct size from 22300 to 22400 (1.54 MB)
[2018-03-08 06:56:46.050] at query time:
[2018-03-08 06:56:46.050] Notice: Increasing overTime struct size from 22400 to 22500 (1.54 MB)
[2018-03-08 06:56:46.050] at query time:
[2018-03-08 06:56:46.051] Notice: Increasing overTime struct size from 22500 to 22600 (1.55 MB)
[2018-03-08 06:56:46.051] at query time:
[2018-03-08 06:56:46.051] Notice: Increasing overTime struct size from 22600 to 22700 (1.55 MB)
[2018-03-08 06:56:46.052] at query time:
[2018-03-08 06:56:46.052] Notice: Increasing overTime struct size from 22700 to 22800 (1.56 MB)
[2018-03-08 06:56:46.052] at query time:
[2018-03-08 06:56:46.053] Notice: Increasing overTime struct size from 22800 to 22900 (1.56 MB)
[2018-03-08 06:56:46.053] at query time:
[2018-03-08 06:56:46.053] Notice: Increasing overTime struct size from 22900 to 23000 (1.57 MB)
[2018-03-08 06:56:46.054] at query time:
[2018-03-08 06:56:46.054] Notice: Increasing overTime struct size from 23000 to 23100 (1.57 MB)
[2018-03-08 06:56:46.054] at query time:
[2018-03-08 06:56:46.055] Notice: Increasing overTime struct size from 23100 to 23200 (1.58 MB)
[2018-03-08 06:56:46.055] at query time:
[2018-03-08 06:56:46.055] Notice: Increasing overTime struct size from 23200 to 23300 (1.58 MB)
[2018-03-08 06:56:46.056] at query time:
[2018-03-08 06:56:46.056] Notice: Increasing overTime struct size from 23300 to 23400 (1.58 MB)
[2018-03-08 06:56:46.057] at query time:
[2018-03-08 06:56:46.057] Notice: Increasing overTime struct size from 23400 to 23500 (1.59 MB)
[2018-03-08 06:56:46.057] at query time:
[2018-03-08 06:56:46.058] Notice: Increasing overTime struct size from 23500 to 23600 (1.59 MB)
[2018-03-08 06:56:46.058] at query time:
[2018-03-08 06:56:46.058] Notice: Increasing overTime struct size from 23600 to 23700 (1.60 MB)
[2018-03-08 06:56:46.059] at query time:
[2018-03-08 06:56:46.059] Notice: Increasing overTime struct size from 23700 to 23800 (1.60 MB)
[2018-03-08 06:56:46.059] at query time:
[2018-03-08 06:56:46.060] Notice: Increasing overTime struct size from 23800 to 23900 (1.61 MB)
[2018-03-08 06:56:46.060] at query time:
[2018-03-08 06:56:46.060] Notice: Increasing overTime struct size from 23900 to 24000 (1.61 MB)
[2018-03-08 06:56:46.061] at query time:
[2018-03-08 06:56:46.061] Notice: Increasing overTime struct size from 24000 to 24100 (1.62 MB)
[2018-03-08 06:56:46.061] at query time:
[2018-03-08 06:56:46.062] Notice: Increasing overTime struct size from 24100 to 24200 (1.62 MB)
[2018-03-08 06:56:46.062] at query time:
[2018-03-08 06:56:46.062] Notice: Increasing overTime struct size from 24200 to 24300 (1.63 MB)
[2018-03-08 06:56:46.063] at query time:
[2018-03-08 06:56:46.063] Notice: Increasing overTime struct size from 24300 to 24400 (1.63 MB)
[2018-03-08 06:56:46.063] at query time:
[2018-03-08 06:56:46.064] Notice: Increasing overTime struct size from 24400 to 24500 (1.64 MB)
[2018-03-08 06:56:46.064] at query time:
[2018-03-08 06:56:46.064] Notice: Increasing overTime struct size from 24500 to 24600 (1.64 MB)
[2018-03-08 06:56:46.065] at query time:
[2018-03-08 06:56:46.065] Notice: Increasing overTime struct size from 24600 to 24700 (1.65 MB)
[2018-03-08 06:56:46.065] at query time:
[2018-03-08 06:56:46.066] Notice: Increasing overTime struct size from 24700 to 24800 (1.65 MB)
[2018-03-08 06:56:46.066] at query time:
[2018-03-08 06:56:46.067] Notice: Increasing overTime struct size from 24800 to 24900 (1.66 MB)
[2018-03-08 06:56:46.067] at query time:
[2018-03-08 06:56:46.067] Notice: Increasing overTime struct size from 24900 to 25000 (1.66 MB)
[2018-03-08 06:56:46.068] at query time:
[2018-03-08 06:56:46.068] Notice: Increasing overTime struct size from 25000 to 25100 (1.67 MB)
[2018-03-08 06:56:46.068] at query time:
[2018-03-08 06:56:46.069] Notice: Increasing overTime struct size from 25100 to 25200 (1.67 MB)
[2018-03-08 06:56:46.069] at query time:
[2018-03-08 06:56:46.069] Notice: Increasing overTime struct size from 25200 to 25300 (1.68 MB)
[2018-03-08 06:56:46.070] at query time:
[2018-03-08 06:56:46.070] Notice: Increasing overTime struct size from 25300 to 25400 (1.68 MB)
[2018-03-08 06:56:46.070] at query time:
[2018-03-08 06:56:46.071] Notice: Increasing overTime struct size from 25400 to 25500 (1.69 MB)
[2018-03-08 06:56:46.071] at query time:
[2018-03-08 06:56:46.071] Notice: Increasing overTime struct size from 25500 to 25600 (1.69 MB)
[2018-03-08 06:56:46.072] at query time:
[2018-03-08 06:56:46.072] Notice: Increasing overTime struct size from 25600 to 25700 (1.70 MB)
[2018-03-08 06:56:46.072] at query time:
[2018-03-08 06:56:46.073] Notice: Increasing overTime struct size from 25700 to 25800 (1.70 MB)
[2018-03-08 06:56:46.073] at query time:
[2018-03-08 06:56:46.073] Notice: Increasing overTime struct size from 25800 to 25900 (1.70 MB)
[2018-03-08 06:56:46.074] at query time:
[2018-03-08 06:56:46.074] Notice: Increasing overTime struct size from 25900 to 26000 (1.71 MB)
[2018-03-08 06:56:46.074] at query time:
[2018-03-08 06:56:46.075] Notice: Increasing overTime struct size from 26000 to 26100 (1.71 MB)
[2018-03-08 06:56:46.075] at query time:
[2018-03-08 06:56:46.075] Notice: Increasing overTime struct size from 26100 to 26200 (1.72 MB)
[2018-03-08 06:56:46.076] at query time:
[2018-03-08 06:56:46.076] Notice: Increasing overTime struct size from 26200 to 26300 (1.72 MB)
[2018-03-08 06:56:46.077] at query time:
[2018-03-08 06:56:46.077] Notice: Increasing overTime struct size from 26300 to 26400 (1.73 MB)
[2018-03-08 06:56:46.077] at query time:
[2018-03-08 06:56:46.078] Notice: Increasing overTime struct size from 26400 to 26500 (1.73 MB)
[2018-03-08 06:56:46.078] at query time:
[2018-03-08 06:56:46.078] Notice: Increasing overTime struct size from 26500 to 26600 (1.74 MB)
[2018-03-08 06:56:46.079] at query time:
[2018-03-08 06:56:46.079] Notice: Increasing overTime struct size from 26600 to 26700 (1.74 MB)
[2018-03-08 06:56:46.079] at query time:
[2018-03-08 06:56:46.080] Notice: Increasing overTime struct size from 26700 to 26800 (1.75 MB)
[2018-03-08 06:56:46.080] at query time:
[2018-03-08 06:56:46.080] Notice: Increasing overTime struct size from 26800 to 26900 (1.75 MB)
[2018-03-08 06:56:46.080] at query time:
[2018-03-08 06:56:46.081] Notice: Increasing overTime struct size from 26900 to 27000 (1.76 MB)
[2018-03-08 06:56:46.081] at query time:
[2018-03-08 06:56:46.081] Notice: Increasing overTime struct size from 27000 to 27100 (1.76 MB)
[2018-03-08 06:56:46.082] at query time:
[2018-03-08 06:56:46.082] Notice: Increasing overTime struct size from 27100 to 27200 (1.77 MB)
[2018-03-08 06:56:46.082] at query time:
[2018-03-08 06:56:46.083] Notice: Increasing overTime struct size from 27200 to 27300 (1.77 MB)
[2018-03-08 06:56:46.083] at query time:
[2018-03-08 06:56:46.083] Notice: Increasing overTime struct size from 27300 to 27400 (1.78 MB)
[2018-03-08 06:56:46.084] at query time:
[2018-03-08 06:56:46.084] Notice: Increasing overTime struct size from 27400 to 27500 (1.78 MB)
[2018-03-08 06:56:46.084] at query time:
[2018-03-08 06:56:46.085] Notice: Increasing overTime struct size from 27500 to 27600 (1.79 MB)
[2018-03-08 06:56:46.085] at query time:
[2018-03-08 06:56:46.085] Notice: Increasing overTime struct size from 27600 to 27700 (1.79 MB)
[2018-03-08 06:56:46.086] at query time:
[2018-03-08 06:56:46.086] Notice: Increasing overTime struct size from 27700 to 27800 (1.80 MB)
[2018-03-08 06:56:46.087] at query time:
[2018-03-08 06:56:46.087] Notice: Increasing overTime struct size from 27800 to 27900 (1.80 MB)
[2018-03-08 06:56:46.087] at query time:
[2018-03-08 06:56:46.087] Notice: Increasing overTime struct size from 27900 to 28000 (1.81 MB)
[2018-03-08 06:56:46.088] at query time:
[2018-03-08 06:56:46.088] Notice: Increasing overTime struct size from 28000 to 28100 (1.81 MB)
[2018-03-08 06:56:46.088] at query time:
[2018-03-08 06:56:46.089] Notice: Increasing overTime struct size from 28100 to 28200 (1.82 MB)
[2018-03-08 06:56:46.089] at query time:
[2018-03-08 06:56:46.089] Notice: Increasing overTime struct size from 28200 to 28300 (1.82 MB)
[2018-03-08 06:56:46.090] at query time:
[2018-03-08 06:56:46.090] Notice: Increasing overTime struct size from 28300 to 28400 (1.82 MB)
[2018-03-08 06:56:46.090] at query time:
[2018-03-08 06:56:46.091] Notice: Increasing overTime struct size from 28400 to 28500 (1.83 MB)
[2018-03-08 06:56:46.091] at query time:
[2018-03-08 06:56:46.091] Notice: Increasing overTime struct size from 28500 to 28600 (1.83 MB)
[2018-03-08 06:56:46.092] at query time:
[2018-03-08 06:56:46.092] Notice: Increasing overTime struct size from 28600 to 28700 (1.84 MB)
[2018-03-08 06:56:46.093] at query time:
[2018-03-08 06:56:46.093] Notice: Increasing overTime struct size from 28700 to 28800 (1.84 MB)
[2018-03-08 06:56:46.093] at query time:
[2018-03-08 06:56:46.094] Notice: Increasing overTime struct size from 28800 to 28900 (1.85 MB)
[2018-03-08 06:56:46.094] at query time:
[2018-03-08 06:56:46.094] Notice: Increasing overTime struct size from 28900 to 29000 (1.85 MB)
[2018-03-08 06:56:46.095] at query time:
[2018-03-08 06:56:46.095] Notice: Increasing overTime struct size from 29000 to 29100 (1.86 MB)
[2018-03-08 06:56:46.095] at query time:
[2018-03-08 06:56:46.096] Notice: Increasing overTime struct size from 29100 to 29200 (1.86 MB)
[2018-03-08 06:56:46.096] at query time:
[2018-03-08 06:56:46.097] Notice: Increasing overTime struct size from 29200 to 29300 (1.87 MB)
[2018-03-08 06:56:46.097] at query time:
[2018-03-08 06:56:46.097] Notice: Increasing overTime struct size from 29300 to 29400 (1.87 MB)
[2018-03-08 06:56:46.098] at query time:
[2018-03-08 06:56:46.098] Notice: Increasing overTime struct size from 29400 to 29500 (1.88 MB)
[2018-03-08 06:56:46.098] at query time:
[2018-03-08 06:56:46.099] Notice: Increasing overTime struct size from 29500 to 29600 (1.88 MB)
[2018-03-08 06:56:46.099] at query time:
[2018-03-08 06:56:46.099] Notice: Increasing overTime struct size from 29600 to 29700 (1.89 MB)
[2018-03-08 06:56:46.100] at query time:
[2018-03-08 06:56:46.100] Notice: Increasing overTime struct size from 29700 to 29800 (1.89 MB)
[2018-03-08 06:56:46.100] at query time:
[2018-03-08 06:56:46.101] Notice: Increasing overTime struct size from 29800 to 29900 (1.90 MB)
[2018-03-08 06:56:46.101] at query time:
[2018-03-08 06:56:46.101] Notice: Increasing overTime struct size from 29900 to 30000 (1.90 MB)
[2018-03-08 06:56:46.102] at query time:
[2018-03-08 06:56:46.102] Notice: Increasing overTime struct size from 30000 to 30100 (1.91 MB)
[2018-03-08 06:56:46.102] at query time:
[2018-03-08 06:56:46.103] Notice: Increasing overTime struct size from 30100 to 30200 (1.91 MB)
[2018-03-08 06:56:46.103] at query time:
[2018-03-08 06:56:46.103] Notice: Increasing overTime struct size from 30200 to 30300 (1.92 MB)
[2018-03-08 06:56:46.104] at query time:
[2018-03-08 06:56:46.104] Notice: Increasing overTime struct size from 30300 to 30400 (1.92 MB)
[2018-03-08 06:56:46.104] at query time:
[2018-03-08 06:56:46.105] Notice: Increasing overTime struct size from 30400 to 30500 (1.93 MB)
[2018-03-08 06:56:46.105] at query time:
[2018-03-08 06:56:46.105] Notice: Increasing overTime struct size from 30500 to 30600 (1.93 MB)
[2018-03-08 06:56:46.106] at query time:
[2018-03-08 06:56:46.106] Notice: Increasing overTime struct size from 30600 to 30700 (1.94 MB)
[2018-03-08 06:56:46.107] at query time:
[2018-03-08 06:56:46.107] Notice: Increasing overTime struct size from 30700 to 30800 (1.94 MB)
[2018-03-08 06:56:46.107] at query time:
[2018-03-08 06:56:46.108] Notice: Increasing overTime struct size from 30800 to 30900 (1.94 MB)
[2018-03-08 06:56:46.108] at query time:
[2018-03-08 06:56:46.108] Notice: Increasing overTime struct size from 30900 to 31000 (1.95 MB)
[2018-03-08 06:56:46.109] at query time:
[2018-03-08 06:56:46.109] Notice: Increasing overTime struct size from 31000 to 31100 (1.95 MB)
[2018-03-08 06:56:46.109] at query time:
[2018-03-08 06:56:46.123] New domain: 0.debian.pool.ntp.org (86/1000)
[2018-03-08 06:56:46.149] New domain: 1.debian.pool.ntp.org (87/1000)
[2018-03-08 06:56:46.175] New domain: 2.debian.pool.ntp.org (88/1000)
[2018-03-08 06:56:51.389] New domain: alt3-safebrowsing.google.com (89/1000)
[2018-03-08 06:57:17.572] Notice: Increasing queries struct size from 10000 to 20000 (2.40 MB)
[2018-03-08 06:57:17.573] at query time:
[2018-03-08 06:57:49.607] Notice: Increasing queries struct size from 20000 to 30000 (2.84 MB)
[2018-03-08 06:57:49.607] at query time:
[2018-03-08 06:58:21.593] Notice: Increasing queries struct size from 30000 to 40000 (3.28 MB)
[2018-03-08 06:58:21.594] at query time:
Let's wait some more minutes. If that doesn't help, we should run pihole-FTL in the debugger, see below.
One question in between: Is your disk full or was it full within the last 48 hours? If so, the file /var/log/pihole-FTL.log night be corrupted leading to this very strange behavior. If this is the case, delete this (and the pihole.log.1 file) to restore normal FTL operation.
Debugging instructions:
sudo -u pihole gdb $(which pihole-FTL)
In the shown prompt, you should enter
run debug
When it again hangs, press Ctrl+C and gdb should show where FTL is at the moment.
It is still running, I stopped it (pasted the new things that were rnning down there) and deleted the logs you mentioned.
Edit: to answer the space, no, not that I am aware of. The Rpi is running Pi-hole and has a chrome kiosk page to display a dakboard page, no other uses for it.
pi@raspberrypi:~ $ df
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/root 14812720 4606180 9541984 33% /
devtmpfs 470180 0 470180 0% /dev
tmpfs 474788 29128 445660 7% /dev/shm
tmpfs 474788 6364 468424 2% /run
tmpfs 5120 4 5116 1% /run/lock
tmpfs 474788 0 474788 0% /sys/fs/cgroup
/dev/mmcblk0p1 42137 21474 20663 51% /boot
tmpfs 94956 0 94956 0% /run/user/999
tmpfs 94956 0 94956 0% /run/user/1000
After running debug I get
pi@raspberrypi:/var/log $ sudo -u pihole gdb $(which pihole-FTL)
GNU gdb (Raspbian 7.12-6) 7.12.0.20161007-git
Copyright (C) 2016 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later http://gnu.org/licenses/gpl.html
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law. Type "show copying"
and "show warranty" for details.
This GDB was configured as "arm-linux-gnueabihf".
Type "show configuration" for configuration details.
For bug reporting instructions, please see:
http://www.gnu.org/software/gdb/bugs/.
Find the GDB manual and other documentation resources online at:
http://www.gnu.org/software/gdb/documentation/.
For help, type "help".
Type "apropos word" to search for commands related to "word"...
Reading symbols from /usr/bin/pihole-FTL...done.
(gdb) run debug
Starting program: /usr/bin/pihole-FTL debug
This account is currently not available.
During startup program exited with code 1.
(gdb) Quit
(gdb) Quit
(gdb)
[2018-03-08 06:58:53.635] Notice: Increasing queries struct size from 40000 to 50000 (3.72 MB)
[2018-03-08 06:58:53.636] at query time:
[2018-03-08 06:59:25.640] Notice: Increasing queries struct size from 50000 to 60000 (4.16 MB)
[2018-03-08 06:59:25.641] at query time:
[2018-03-08 06:59:57.656] Notice: Increasing queries struct size from 60000 to 70000 (4.60 MB)
[2018-03-08 06:59:57.657] at query time:
[2018-03-08 06:59:59.113] New domain: easylist.to (90/1000)
[2018-03-08 06:59:59.126] New domain: secure.fanboy.co.nz (91/1000)
[2018-03-08 06:59:59.140] New domain: easylist-downloads.adblockplus.org (92/1000)
[2018-03-08 07:00:01.269] New domain: www.malwaredomainlist.com (93/1000)
[2018-03-08 07:00:02.340] New domain: mirror.cedia.org.ec (94/1000)
[2018-03-08 07:00:02.353] New domain: mirror1.malwaredomains.com (95/1000)
[2018-03-08 07:00:03.132] New domain: publicsuffix.org (96/1000)
[2018-03-08 07:00:29.715] Notice: Increasing queries struct size from 70000 to 80000 (5.04 MB)
[2018-03-08 07:00:29.716] at query time:
[2018-03-08 07:01:01.994] Notice: Increasing queries struct size from 80000 to 90000 (5.48 MB)
[2018-03-08 07:01:01.996] at query time:
[2018-03-08 07:01:34.040] Notice: Increasing queries struct size from 90000 to 100000 (5.92 MB)
[2018-03-08 07:01:34.041] at query time:
[2018-03-08 07:02:06.187] Notice: Increasing queries struct size from 100000 to 110000 (6.36 MB)
[2018-03-08 07:02:06.188] at query time:
[2018-03-08 07:02:38.365] Notice: Increasing queries struct size from 110000 to 120000 (6.80 MB)
[2018-03-08 07:02:38.367] at query time:
[2018-03-08 07:03:10.557] Notice: Increasing queries struct size from 120000 to 130000 (7.24 MB)
[2018-03-08 07:03:10.558] at query time:
[2018-03-08 07:03:42.749] Notice: Increasing queries struct size from 130000 to 140000 (7.68 MB)
[2018-03-08 07:03:42.751] at query time:
[2018-03-08 07:04:14.954] Notice: Increasing queries struct size from 140000 to 150000 (8.12 MB)
[2018-03-08 07:04:14.955] at query time:
[2018-03-08 07:04:47.212] Notice: Increasing queries struct size from 150000 to 160000 (8.56 MB)
[2018-03-08 07:04:47.214] at query time:
[2018-03-08 07:05:19.430] Notice: Increasing queries struct size from 160000 to 170000 (9.00 MB)
[2018-03-08 07:05:19.431] at query time:
[2018-03-08 07:05:51.633] Notice: Increasing queries struct size from 170000 to 180000 (9.44 MB)
[2018-03-08 07:05:51.634] at query time:
[2018-03-08 07:06:23.965] Notice: Increasing queries struct size from 180000 to 190000 (9.88 MB)
[2018-03-08 07:06:23.966] at query time:
[2018-03-08 07:06:50.572] New domain: phnyldwvhamvws (97/1000)
[2018-03-08 07:06:50.577] New domain: pbvcfakcnt (98/1000)
[2018-03-08 07:06:50.581] New domain: ewouwqiira (99/1000)
[2018-03-08 07:06:56.166] Notice: Increasing queries struct size from 190000 to 200000 (10.32 MB)
[2018-03-08 07:06:56.167] at query time:
[2018-03-08 07:07:28.334] Notice: Increasing queries struct size from 200000 to 210000 (10.76 MB)
[2018-03-08 07:07:28.335] at query time:
[2018-03-08 07:07:37.672] Notice: Increasing overTime struct size from 31200 to 31300 (10.76 MB)
[2018-03-08 07:07:37.673] at query time:
[2018-03-08 07:08:00.521] Notice: Increasing queries struct size from 210000 to 220000 (11.20 MB)
[2018-03-08 07:08:00.522] at query time:
[2018-03-08 07:08:32.734] Notice: Increasing queries struct size from 220000 to 230000 (11.64 MB)
[2018-03-08 07:08:32.735] at query time:
[2018-03-08 07:08:37.771] New domain: wpad.lan (100/1000)
[2018-03-08 07:08:37.814] New domain: translate.googleapis.com (101/1000)
[2018-03-08 07:08:48.683] Imported 224950 queries from the long-term database
[2018-03-08 07:08:48.685] Starting initial log file parsing
[2018-03-08 07:08:48.685] Reading from /var/log/pihole.log (rw-r--r--)
[2018-03-08 07:08:49.322] Finished initial log file parsing
[2018-03-08 07:08:49.323] -> Total DNS queries: 224950
[2018-03-08 07:08:49.323] -> Cached DNS queries: 74
[2018-03-08 07:08:49.323] -> Forwarded DNS queries: 168
[2018-03-08 07:08:49.323] -> Exactly blocked DNS queries: 4
[2018-03-08 07:08:49.324] -> Wildcard blocked DNS queries: 0
[2018-03-08 07:08:49.324] -> Unknown DNS queries: 224704
[2018-03-08 07:08:49.324] -> Unique domains: 102
[2018-03-08 07:08:49.324] -> Unique clients: 7
[2018-03-08 07:08:49.324] -> Known forward destinations: 2
[2018-03-08 07:08:49.324] Successfully accessed setupVars.conf
[2018-03-08 07:08:49.325] Listening on port 4711 for incoming IPv4 telnet connections
[2018-03-08 07:08:49.327] Found 4 IPv4 and 2 IPv6 capable interfaces
[2018-03-08 07:08:49.327] Listening on port 4711 for incoming IPv6 telnet connections
[2018-03-08 07:08:49.328] Listening on Unix socket
[2018-03-08 07:09:00.089] dbquery(INSERT OR REPLACE INTO ftl (id, value) VALUES ( 1, 1520480740 )- SQL error (5): database is locked
[2018-03-08 07:09:00.091] Notice: Queries stored in DB: 0 (took 45.9 ms)
[2018-03-08 07:10:00.051] db_get_FTL_property() - SQL error prepare (5): database is locked
[2018-03-08 07:10:00.052] save_to_DB() - error in trying to get last time stamp from database
[2018-03-08 07:11:00.051] db_get_FTL_property() - SQL error prepare (5): database is locked
[2018-03-08 07:11:00.052] save_to_DB() - error in trying to get last time stamp from database
[2018-03-08 07:12:00.056] db_get_FTL_property() - SQL error prepare (5): database is locked
[2018-03-08 07:12:00.057] save_to_DB() - error in trying to get last time stamp from database
[2018-03-08 07:13:00.054] db_get_FTL_property() - SQL error prepare (5): database is locked
[2018-03-08 07:13:00.055] save_to_DB() - error in trying to get last time stamp from database
[2018-03-08 07:14:00.055] db_get_FTL_property() - SQL error prepare (5): database is locked
[2018-03-08 07:14:00.055] save_to_DB() - error in trying to get last time stamp from database
[2018-03-08 07:15:00.053] db_get_FTL_property() - SQL error prepare (5): database is locked
[2018-03-08 07:15:00.053] save_to_DB() - error in trying to get last time stamp from database
[2018-03-08 07:16:00.049] db_get_FTL_property() - SQL error prepare (5): database is locked
[2018-03-08 07:16:00.050] save_to_DB() - error in trying to get last time stamp from database
[2018-03-08 07:17:00.051] db_get_FTL_property() - SQL error prepare (5): database is locked
[2018-03-08 07:17:00.051] save_to_DB() - error in trying to get last time stamp from database
[2018-03-08 07:18:00.069] dbquery(INSERT OR REPLACE INTO ftl (id, value) VALUES ( 1, 1520480740 )
[2018-03-08 07:18:00.069] Notice: Queries stored in DB: 0 (took 2.5 ms)
[2018-03-08 07:19:00.078] db_get_FTL_property() - SQL error prepare (5): database is locked
[2018-03-08 07:19:00.078] save_to_DB() - error in trying to get last time stamp from database
[2018-03-08 07:20:00.092] db_get_FTL_property() - SQL error prepare (5): database is locked
[2018-03-08 07:20:00.093] save_to_DB() - error in trying to get last time stamp from database
[2018-03-08 07:21:00.011] db_get_FTL_property() - SQL error prepare (5): database is locked
[2018-03-08 07:21:00.012] save_to_DB() - error in trying to get last time stamp from database
[2018-03-08 07:22:03.139] Notice: Queries stored in DB: 0 (took 3124.4 ms)
[2018-03-08 07:23:00.030] db_get_FTL_property() - SQL error prepare (5): database is locked
[2018-03-08 07:23:00.031] save_to_DB() - error in trying to get last time stamp from database
[2018-03-08 07:24:00.240] Notice: Queries stored in DB: 0 (took 212.6 ms)
[2018-03-08 07:25:00.257] Notice: Queries stored in DB: 0 (took 232.1 ms)
[2018-03-08 07:26:00.909] Notice: Queries stored in DB: 0 (took 882.4 ms)
[2018-03-08 07:27:01.651] Notice: Queries stored in DB: 0 (took 1617.7 ms)
[2018-03-08 07:28:00.971] Notice: Queries stored in DB: 0 (took 928.6 ms)
[2018-03-08 07:29:00.053] db_get_FTL_property() - SQL error prepare (5): database is locked
[2018-03-08 07:29:00.053] save_to_DB() - error in trying to get last time stamp from database
[2018-03-08 07:30:00.107] Notice: Queries stored in DB: 0 (took 57.2 ms)
[2018-03-08 07:31:00.993] Notice: Queries stored in DB: 0 (took 943.7 ms)
[2018-03-08 07:32:00.247] Notice: Queries stored in DB: 0 (took 193.1 ms)
[2018-03-08 07:33:00.244] Notice: Queries stored in DB: 0 (took 189.8 ms)
[2018-03-08 07:34:00.254] Notice: Queries stored in DB: 0 (took 195.2 ms)
[2018-03-08 07:35:00.070] db_get_FTL_property() - SQL error prepare (5): database is locked
[2018-03-08 07:35:00.071] save_to_DB() - error in trying to get last time stamp from database
[2018-03-08 07:36:00.080] db_get_FTL_property() - SQL error prepare (5): database is locked
[2018-03-08 07:36:00.081] save_to_DB() - error in trying to get last time stamp from database
[2018-03-08 07:37:00.098] db_get_FTL_property() - SQL error prepare (5): database is locked
[2018-03-08 07:37:00.099] save_to_DB() - error in trying to get last time stamp from database
[2018-03-08 07:38:00.100] dbquery(INSERT OR REPLACE INTO ftl (id, value) VALUES ( 1, 1520480740 )
[2018-03-08 07:38:00.101] Notice: Queries stored in DB: 0 (took 2.6 ms)
Hmm, try
sudo killall pihole-FTL
and try again with the debug command.
Same issue, this is quite interesting
Starting program: /usr/bin/pihole-FTL debug
This account is currently not available.
During startup program exited with code 1.
Solved it by going to settings > Teleporter > Export on "Export your Pi-hole lists as downloadable archive" uninstalling pihole, reinstalling pihole, and re-importing my lists after it was done.
pihole uninstall
Wait for that, then install pihole per the homepage instructions,
Then I had an issue where it would not get git, because of this
sudo nano /etc/resolv.conf
And replaced
nameserver 127.0.0.1
with
nameserver 8.8.8.8
And installation worked.
Okay, very good. Thanks for reporting back!
Thanks for your time! I'll send another cup of coffee donation, been using pihole for some time and it's great!
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.