Need some help troubleshooting

An RSS/Atom newsreader with features comparable to commercial newsreaders.
flupps
Harmless
Posts: 5
Joined: Wed Nov 12, 2008 11:33 am

Need some help troubleshooting

Postby flupps » Fri Mar 26, 2010 12:40 pm

Hi!

I'm in a state with my data where something seems screwed up.

Yesterday I started noticing that when reading posts - the aggregate count of unread posts for the folder was not updating (the individual messages' unread icon disappeared, however).

Running an integrity check on the sqlite db produced the following:

sqlite> pragma integrity_check
...> ;
*** in database main ***
Main freelist: freelist leaf count too big on page 101513
Main freelist: invalid page number 141418
On tree page 101554 cell 1: 2nd reference to page 101513
On tree page 101554 cell 2: invalid page number 141422
On page 141387 at right child: invalid page number 141425
rowid 11279 missing from index messages_message_idx
rowid 11279 missing from index messages_folder_idx
SQL error: database disk image is malformed

I did a dump and reload of the data files, I get no errors in the console, nor in Vienna, but I have some strange characteristics happening now.

1. I cannot add new RSS feeds - They get added, but they're never checked for posts, neither retrieve the name of the RSS feed. (I did check with tcpdump, and it seems nothing outgoing happens).
2. Only a small subset of my current feeds get checked for new posts
3. I do not get asked to empty the trash when I quit Vienna

I'd just clean out and restart if it wasn't for the fact that I have a lot of messages flagged and a quite large unread log in some important feeds that would not be captured again if I were to start over.

So, I figured I would try with some queries to see if the integrity is broken somehow.
So, since I had a problem with the aggregate being incorrect before, let's see if messages add up to the folder count:

Code: Select all

sqlite> SELECT f.folder_id, f.unread_count, SUM(m.read_flag=0) FROM folders AS f LEFT JOIN messages AS m ON f.folder_id = m.folder_id GROUP BY f.folder_id;
1|0|NULL
2|0|NULL
3|0|NULL
4|0|NULL
5|0|NULL
6|0|0
7|0|NULL
8|0|0
9|0|0
15|0|0
17|0|0
18|0|NULL
19|0|0
20|0|NULL
21|0|NULL
22|323|323
23|0|NULL
24|0|0
25|0|0
26|0|0
27|306|306
40|0|NULL
41|0|0
43|0|NULL
44|0|0
45|0|NULL
46|0|0
47|54426|54426
48|0|NULL
50|857|857
51|949|949
52|129|129
53|223|223
54|0|NULL
56|120|120
59|0|0
61|0|NULL
62|0|0
63|0|0
66|0|0
67|0|0
68|0|0
69|0|0
70|0|0
71|0|0
72|0|0
75|783|783
76|0|NULL
77|57|57
78|3722|3722
80|0|0
81|0|0
82|0|0
83|6644|6644
87|0|0
88|0|0
89|0|0
90|0|0
92|0|0
94|0|0
96|182|182
97|119|119
98|0|0
99|0|0
100|0|NULL
101|0|0
103|0|0
105|2306|2306
106|0|0
108|0|0
109|0|NULL
110|0|0
111|0|0
112|0|0
113|0|0
114|0|0
115|0|0
116|0|NULL
117|0|NULL
118|0|NULL
119|0|NULL
120|0|0
121|0|0
122|0|0
123|0|0
124|0|0
125|0|0
126|26|26
127|37|37
128|166|166
129|0|0
130|0|0
131|0|0
132|0|NULL
133|0|0
134|0|0
135|295|295
136|0|NULL
137|0|0
138|0|0


Ok, that looked ok, no mismatches.
Let's see if any messages are around that doesn't belong to a folder...

Code: Select all

sqlite> select message_id from messages left join folders on messages.folder_id = folders.folder_id where folders.folder_id is null;                  http://www.wulffmorgenthaler.com/strip.aspx?id=503a60da-03f2-4feb-8be8-77afded8be34
http://www.wulffmorgenthaler.com/strip.aspx?id=9a25e6c9-2d4c-451a-bc20-adb3c8b1db9f
http://www.wulffmorgenthaler.com/strip.aspx?id=de934b58-87ff-4e18-a040-2f3f24a7120c
http://www.wulffmorgenthaler.com/strip.aspx?id=b29cfc86-09e4-455a-953c-1756bfaa8580
http://www.wulffmorgenthaler.com/strip.aspx?id=a0bbcbe5-7505-40f7-983e-32d441048814
http://www.wulffmorgenthaler.com/strip.aspx?id=0957f46a-ec74-450f-bdf3-b60dfc5efcbb
http://www.wulffmorgenthaler.com/strip.aspx?id=58b107ff-5da8-4617-aa21-ef9a3da63c6c
http://www.wulffmorgenthaler.com/strip.aspx?id=3fe2bc1b-0a21-49e1-9c83-e9e9d0b225e8
http://www.wulffmorgenthaler.com/strip.aspx?id=0a212ed4-7047-4d00-8c85-01603fc085e2
http://www.wulffmorgenthaler.com/strip.aspx?id=690c053b-6781-4812-acec-d74d86d844ad
http://www.wulffmorgenthaler.com/strip.aspx?id=8e931713-085b-4062-bc3b-54847f35fb13
http://www.wulffmorgenthaler.com/strip.aspx?id=acd906f3-429f-4c6f-bc53-80fa8beaed37
http://www.wulffmorgenthaler.com/strip.aspx?id=f0e6626f-ca16-456b-8fd2-99c92b5da367
http://www.wulffmorgenthaler.com/strip.aspx?id=8ba9e2e8-7c70-4387-9358-b0d37af3a550
http://www.wulffmorgenthaler.com/strip.aspx?id=c081a54d-1ab3-4b58-bcab-2248145e7e69
http://www.wulffmorgenthaler.com/strip.aspx?id=9997649f-6757-44cc-8b48-f4b36013e934
http://www.wulffmorgenthaler.com/strip.aspx?id=9f96fd71-0dfa-49f5-8ff4-493ee3fbd7bd
http://www.wulffmorgenthaler.com/strip.aspx?id=dc5a46af-40ca-4160-8a93-3aa917281590
http://www.wulffmorgenthaler.com/strip.aspx?id=25000aef-8884-4f68-8abd-f6f979896381
http://www.wulffmorgenthaler.com/strip.aspx?id=62fb4fc0-a45a-4901-b3b3-2a481249f010
http://www.wulffmorgenthaler.com/strip.aspx?id=564d15ec-0f42-475d-92bf-8c65726b4cab
http://www.wulffmorgenthaler.com/strip.aspx?id=dc25fefe-dabb-436a-b133-d1c55936e83f
http://www.wulffmorgenthaler.com/strip.aspx?id=7cce71f4-8528-4ce5-8c7c-6ce35e792bc3
http://www.wulffmorgenthaler.com/strip.aspx?id=e02c164c-5cb3-425e-ad47-c1e8ec64a087
http://www.wulffmorgenthaler.com/strip.aspx?id=57998eab-98e7-4ab1-92fc-5a86b0c54697
http://www.wulffmorgenthaler.com/strip.aspx?id=c615be9c-3f0f-4093-9371-777885d9e0e3
http://www.wulffmorgenthaler.com/strip.aspx?id=020afb62-4bda-4cbc-a7ea-aca1a07696fb
http://www.wulffmorgenthaler.com/strip.aspx?id=b5946179-76ca-4abe-ba23-7edd33125dd9
http://www.wulffmorgenthaler.com/strip.aspx?id=439e5955-6138-4950-bdbe-ddc815806ff1
http://www.wulffmorgenthaler.com/strip.aspx?id=0fe831e6-e4a3-4fdb-9b82-99f89bd0ef67
http://www.wulffmorgenthaler.com/strip.aspx?id=b6d9698c-94bf-43b3-a82f-91031583504c
http://www.wulffmorgenthaler.com/strip.aspx?id=d79e7882-eb63-4afa-b16c-6ea30665984a
http://www.wulffmorgenthaler.com/strip.aspx?id=d8f2c4d3-115c-4819-850c-1e38f8dcc99e
http://www.wulffmorgenthaler.com/strip.aspx?id=b7668b3f-d8b8-4414-bf92-af5890fb8439
http://www.wulffmorgenthaler.com/strip.aspx?id=23de12ce-4187-4780-985a-feb2a986487c
http://www.wulffmorgenthaler.com/strip.aspx?id=28f5f1ef-a0f7-4c0b-8ae0-95589ed22935
http://www.wulffmorgenthaler.com/strip.aspx?id=d7fe1ffb-0866-4032-bd15-9e309ab733b8
http://www.wulffmorgenthaler.com/strip.aspx?id=a7bebd5a-24a7-480c-bd1a-03b3d415b7f0
http://www.wulffmorgenthaler.com/strip.aspx?id=e92c0aa2-7f83-4f4e-a272-bd8076659d33
http://www.wulffmorgenthaler.com/strip.aspx?id=5a71fc52-18e1-4f54-9fad-918fc53fe062
http://www.wulffmorgenthaler.com/strip.aspx?id=0818b33d-090f-4ffb-8e58-f012b9db0229
http://www.wulffmorgenthaler.com/strip.aspx?id=508fc774-557f-4890-8eed-bb46e38e392e
http://www.wulffmorgenthaler.com/strip.aspx?id=590a4aef-a09f-407d-9d87-e800f1bec7f2
http://www.wulffmorgenthaler.com/strip.aspx?id=7581e8a2-f864-4e00-98b7-90a0f8aa2cc7
http://www.wulffmorgenthaler.com/strip.aspx?id=2991993c-24e8-43fb-a33b-3c91abbb74fd
http://www.wulffmorgenthaler.com/strip.aspx?id=cb338a43-a3f7-4029-b0bd-d367053af58a
http://www.wulffmorgenthaler.com/strip.aspx?id=6c6bec3e-1658-4b5f-8d48-3e00c9a6b9c9
http://www.wulffmorgenthaler.com/strip.aspx?id=f2b88bef-682e-456c-843f-a1733a7aa5b3
http://www.wulffmorgenthaler.com/strip.aspx?id=c9192192-c1f3-414e-a085-efd328929626
http://www.wulffmorgenthaler.com/strip.aspx?id=5de1d67c-8cc3-4145-8435-9e6e5e43c945
http://www.wulffmorgenthaler.com/strip.aspx?id=ce3c107a-318b-4d27-9d42-0fdae32dcec6


Ok...
sqlite> delete from messages where message_id IN (select message_id from messages left join folders on messages.folder_id = folders.folder_id where folders.folder_id is null);

Still seems to have some problems :(

Any ideas on what else could we wrong?

Return to “Vienna”

Who is online

Users browsing this forum: No registered users