Guest

Postby Guest » Tue Jun 01, 2004 12:05 pm

Hi.

I am using 2.0.1 beta since yesterday. Sometimes, while Awasu is updating the channels, I am getting this message:

Can't load the feed itens:
Can't get the next row.

I was using 2.0.1 alpha3 without problems and just copied all 2.0.1 beta files to the Awasu folder.

Thanks in advance.

Guest

Postby Guest » Tue Jun 01, 2004 2:01 pm

Last time I got the "can't get next row" error, the error log showed:

01jun04 10:51:44 Awasu error: Can't update the feed.
- database is locked
01jun04 10:51:44 Delphi: BDN error: Can't update the feed.
- database is locked
01jun04 10:51:44 Slashdot error: Can't update the feed.
- database is locked
01jun04 10:51:44 CSharp Featured Team Posts error: Can't update the feed.
- database is locked
01jun04 10:51:47 kuro5hin.org error: Can't update the feed.
- database is locked
01jun04 10:51:47 Reuters: Top News error: Can't update the feed.
- database is locked
01jun04 10:51:47 Wired News error: Can't update the feed.
- database is locked
01jun04 10:51:47 Awasu error: Can't update the feed.
- database is locked
01jun04 10:51:47 Slashdot error: Can't update the feed.
- database is locked
01jun04 10:51:47 CSharp Featured Team Posts error: Can't update the feed.
- database is locked
01jun04 10:51:47 Reuters: Top News error: Can't update the feed.
- database is locked
01jun04 10:51:47 kuro5hin.org error: Can't update the feed.
- database is locked
01jun04 10:51:47 Awasu error: Can't update the feed.
- database is locked
01jun04 10:51:47 Slashdot error: Can't update the feed.
- database is locked
01jun04 10:51:47 Wired News error: Can't update the feed.
- database is locked
01jun04 10:51:47 CSharp Featured Team Posts error: Can't update the feed.
- database is locked
01jun04 10:51:47 kuro5hin.org error: Can't update the feed.
- database is locked
01jun04 10:51:47 Reuters: Top News error: Can't update the feed.
- database is locked
01jun04 10:51:47 Wired News error: Can't update the feed.
- database is locked

User avatar
dgnc
Posts: 43
Joined: Wed Feb 25, 2004 4:49 pm
Location: London, UK

Postby dgnc » Tue Jun 01, 2004 7:55 pm

I'm getting this problem as well after upgrading from v2.0 AE to 2.01beta AE

A few feeds are going through OK but hte failure rate is over 80%

Guest

Postby Guest » Wed Jun 02, 2004 1:26 am

Anonymous wrote:Can't load the feed itens:
Can't get the next row.


I fixed it... just shutdown Awasu, go to <program files>\awasu\users\<your username>, delete archive.db and restart Awasu.

User avatar
support
Site Admin
Posts: 3022
Joined: Fri Feb 07, 2003 12:48 pm
Location: Melbourne, Australia
Contact:

Postby support » Wed Jun 02, 2004 4:00 am

Can you (and anyone else having this problem) please post your system spec. In particular:

- CPU speed
- how much memory you have
- disk size and speed
- # channels

Create a file called DEBUG.INI in your user's home directory (e.g. C:\Program Files\Awasu\Users\YOUR-NAME\debug.ini) that looks like this:

Code: Select all

[Debug]
DefaultSqliteBusyTimeout=90


The current default value is 60 and you can experiment with this figure to see if it makes a difference (higher values => less chance of a database locked error).

User avatar
dgnc
Posts: 43
Joined: Wed Feb 25, 2004 4:49 pm
Location: London, UK

Postby dgnc » Wed Jun 02, 2004 6:50 am

Configuration
P4 1.9 GHZ
1GB RDRAM
1 of 80GB 5400 RPM HDD over 50% free on both
443 Channels
Win XP Pro SP1 all patches applied

I had to close Awasu and since reloading channels are updating without the message but I don't have any channels open in the browser window

User avatar
support
Site Admin
Posts: 3022
Joined: Fri Feb 07, 2003 12:48 pm
Location: Melbourne, Australia
Contact:

Postby support » Wed Jun 02, 2004 8:28 am

dgnc wrote:I had to close Awasu and since reloading channels are updating without the message but I don't have any channels open in the browser window


Does the problem happen again if you have channel windows open?

User avatar
dgnc
Posts: 43
Joined: Wed Feb 25, 2004 4:49 pm
Location: London, UK

Postby dgnc » Wed Jun 02, 2004 10:45 am

I have 50-60 channels open and have set the debug.ini file up with the parameter at 90

So far no problems but am not sure if it is the 90 or the closing down and restarting of awasu that was the fix.

Incidentally when I first loaded up Awasu after updating to 2.01 AE all the feeds came out as http://etc.. in the My Channels pane (5 still are). An 'update all' seemed to cure this.

Is there an easy way to find out the number of channels you are subscribed to?

Massuda

Postby Massuda » Wed Jun 02, 2004 11:59 am

I was the original poster of this thread... after archive.db was deleted, never get the error message anymore.

support wrote:Can you (and anyone else having this problem) please post your system spec.


I am using a P4 2.66GHz, 256 MB RAM, HD 18GB (55% free), running Windows XP Pro (all patches installed). I have 24 channels.

support wrote:Create a file called DEBUG.INI in your user's home directory [...]


OK.

Massuda

Postby Massuda » Wed Jun 02, 2004 12:22 pm

Massuda wrote:I am using a P4 2.66GHz, 256 MB RAM, HD 18GB (55% free), running Windows XP Pro (all patches installed). I have 24 channels.


I forgot to mention... I am using Awasu Personal Edition.

User avatar
support
Site Admin
Posts: 3022
Joined: Fri Feb 07, 2003 12:48 pm
Location: Melbourne, Australia
Contact:

Postby support » Thu Jun 03, 2004 4:38 am

dgnc wrote:Incidentally when I first loaded up Awasu after updating to 2.01 AE all the feeds came out as http://etc.. in the My Channels pane (5 still are). An 'update all' seemed to cure this.


This will happen if the channel's last feed does not provide a name - Awasu falls back to showing the feed URL. When you first ran 2.0.1, all the old feed information was wiped clean and hence Awasu didn't have any feed names. But after you did the first (successful) update, a feed name became available and Awasu uses that instead.

dgnc wrote:Is there an easy way to find out the number of channels you are subscribed to?


Apply a channel filter that hides at least one channel (e.g. "New content"). The channel count will then be shown at the top of the Control Center. Or you could just count the number of .CHANNEL files - dir *.channel /b | wc -l :-)

User avatar
dgnc
Posts: 43
Joined: Wed Feb 25, 2004 4:49 pm
Location: London, UK

Postby dgnc » Tue Jun 08, 2004 7:47 pm

It started doing the database locked out thing again. No Browser panes were open at the time. Closed Awasu up the DEBUG.INI parameter to 180. Opened it again and it seems to be updating OK now.

User avatar
dgnc
Posts: 43
Joined: Wed Feb 25, 2004 4:49 pm
Location: London, UK

Postby dgnc » Tue Jun 22, 2004 7:07 pm

It has started giving the database locked error. The parameter is set to 180. Will now set it to 360 and try again

excerpt from activity log below

e.g.

22jun04 19:41:08 Getting the latest feed from ATSNN News Feed All Current News.
22jun04 19:41:08 Getting the latest feed from Publish Tips.
22jun04 19:41:08 Publish Tips error: Can't update the feed.
- database is locked
22jun04 19:41:08 Getting the latest feed from TomorrowYesterday - A Dennis T Cheung Blog.
22jun04 19:41:08 Getting the latest feed from All Headline News - Software News and Headlines.
22jun04 19:41:08 TomorrowYesterday - A Dennis T Cheung Blog error: Can't update the feed.
- database is locked
22jun04 19:41:08 All Headline News - Software News and Headlines error: Can't update the feed.
- database is locked
22jun04 19:41:09 Getting the latest feed from Joho the Blog.
22jun04 19:41:09 Getting the latest feed from Publish Tips.
22jun04 19:41:09 Publish Tips error: Can't update the feed.
- database is locked
22jun04 19:41:09 Getting the latest feed from TomorrowYesterday - A Dennis T Cheung Blog.
22jun04 19:41:09 TomorrowYesterday - A Dennis T Cheung Blog error: Can't update the feed.
- database is locked
22jun04 19:41:09 ATSNN News Feed All Current News error: Can't update the feed.
- database is locked
22jun04 19:41:10 Getting the latest feed from TomorrowYesterday - A Dennis T Cheung Blog.
22jun04 19:41:10 Getting the latest feed from All Headline News - Software News and Headlines.
22jun04 19:41:10 All Headline News - Software News and Headlines error: Can't update the feed.
- database is locked
22jun04 19:41:10 Updated channel Joho the Blog OK.
22jun04 19:41:10 Getting the latest feed from Publish Tips.
22jun04 19:41:10 Getting the latest feed from All Headline News - Software News and Headlines.
22jun04 19:41:10 Publish Tips error: Can't update the feed.
- database is locked
22jun04 19:41:11 All Headline News - Software News and Headlines error: Can't update the feed.
- database is locked
22jun04 19:44:12 Getting the latest feed from All Headline News - Web Developers News and Headlines.
22jun04 19:44:13 Updated channel All Headline News - Web Developers News and Headlines OK.
22jun04 19:45:13 Getting the latest feed from All Headline News - Computer Hardware News and Headlines.
22jun04 19:45:14 Updated channel All Headline News - Computer Hardware News and Headlines OK.
22jun04 19:46:14 Getting the latest feed from Salon.com.
22jun04 19:46:14 Getting the latest feed from All Headline News - Computer Security News and Headlines.
22jun04 19:46:14 All Headline News - Computer Security News and Headlines error: Can't update the feed.
- database is locked
22jun04 19:46:14 Getting the latest feed from News-Medical Pharmaceutical News Feed.
22jun04 19:46:14 News-Medical Pharmaceutical News Feed error: Can't update the feed.
- database is locked
22jun04 19:46:14 Getting the latest feed from News-Medical Medical Patent News Feed.
22jun04 19:46:14 News-Medical Medical Patent News Feed error: Can't update the feed.
- database is locked
22jun04 19:46:14 Getting the latest feed from All Headline News - Computer Security News and Headlines.
22jun04 19:46:14 All Headline News - Computer Security News and Headlines error: Can't update the feed.
- database is locked
22jun04 19:46:15 Getting the latest feed from News-Medical Pharmaceutical News Feed.
22jun04 19:46:15 Getting the latest feed from All Headline News - Computer Security News and Headlines.
22jun04 19:46:15 News-Medical Pharmaceutical News Feed error: Can't update the feed.
- database is locked
22jun04 19:46:15 Salon.com error: Can't update the feed.
- database is locked
22jun04 19:46:16 Getting the latest feed from News-Medical Medical Patent News Feed.
22jun04 19:46:16 Getting the latest feed from News-Medical Pharmaceutical News Feed.
22jun04 19:46:16 All Headline News - Computer Security News and Headlines error: Can't update the feed.
- database is locked
22jun04 19:46:16 News-Medical Pharmaceutical News Feed error: Can't update the feed.
- database is locked
22jun04 19:46:17 Updated channel News-Medical Medical Patent News Feed OK.
22jun04 19:49:18 Getting the latest feed from All Headline News - technology News and Headlines.
22jun04 19:49:20 Updated channel All Headline News - technology News and Headlines OK.
22jun04 19:50:21 Getting the latest feed from All Headline News - Child Abuse News and Headlines.
22jun04 19:50:21 Updated channel All Headline News - Child Abuse News and Headlines OK.
22jun04 19:51:22 Getting the latest feed from AnandTech Article Channel.
22jun04 19:51:22 Getting the latest feed from kottke.org.
22jun04 19:51:22 kottke.org error: Can't update the feed.
- database is locked
22jun04 19:51:22 Getting the latest feed from 0xDECAFBAD Blog.
22jun04 19:51:22 0xDECAFBAD Blog error: Can't update the feed.
- database is locked
22jun04 19:51:22 Getting the latest feed from Cool Tools.
22jun04 19:51:22 Getting the latest feed from Big ol' Network World Fusion feed.
22jun04 19:51:22 Big ol' Network World Fusion feed error: Can't update the feed.
- database is locked
22jun04 19:51:23 Getting the latest feed from kottke.org remaindered links.
22jun04 19:51:23 AnandTech Article Channel error: Can't update the feed.
- database is locked
22jun04 19:51:23 Updated channel Cool Tools OK.
22jun04 19:51:23 Getting the latest feed from Ananova.
22jun04 19:51:23 Getting the latest feed from AP World News.
22jun04 19:51:24 Updated channel Ananova OK.
22jun04 19:51:24 Getting the latest feed from Reuters Television: World News.
22jun04 19:51:24 AP World News error: Can't update the feed.
- database is locked
22jun04 19:51:25 Getting the latest feed from Instapundit.com.
22jun04 19:51:25 Instapundit.com error: Can't update the feed.
- database is locked
22jun04 19:51:25 Getting the latest feed from John Robb's Weblog.
22jun04 19:51:25 John Robb's Weblog error: Can't update the feed.
- database is locked
22jun04 19:51:25 Reuters Television: World News error: Can't update the feed.
- database is locked
22jun04 19:51:26 Getting the latest feed from Rogi - Alive And Direct!.
22jun04 19:51:26 Rogi - Alive And Direct! error: Can't update the feed.
- database is locked
22jun04 19:51:26 Updated channel kottke.org remaindered links OK.
22jun04 19:51:27 Getting the latest feed from kottke.org.
22jun04 19:51:27 Getting the latest feed from 0xDECAFBAD Blog.
22jun04 19:51:27 0xDECAFBAD Blog error: Can't update the feed.
- database is locked
22jun04 19:51:27 Getting the latest feed from Big ol' Network World Fusion feed.
22jun04 19:51:27 Big ol' Network World Fusion feed error: Can't update the feed.
- database is locked
22jun04 19:51:27 Getting the latest feed from Instapundit.com.
22jun04 19:51:27 Instapundit.com error: Can't update the feed.
- database is locked
22jun04 19:51:28 Getting the latest feed from John Robb's Weblog.
22jun04 19:51:28 Getting the latest feed from Rogi - Alive And Direct!.
22jun04 19:51:28 John Robb's Weblog error: Can't update the feed.
- database is locked
22jun04 19:51:28 Getting the latest feed from 0xDECAFBAD Blog.
22jun04 19:51:29 Rogi - Alive And Direct! error: Can't update the feed.
- database is locked
22jun04 19:51:29 Updated channel kottke.org OK.
22jun04 19:51:30 Getting the latest feed from Big ol' Network World Fusion feed.
22jun04 19:51:30 Getting the latest feed from Instapundit.com.
22jun04 19:51:30 Big ol' Network World Fusion feed error: Can't update the feed.
- database is locked
22jun04 19:51:31 Getting the latest feed from John Robb's Weblog.
22jun04 19:51:33 0xDECAFBAD Blog error: Can't update the feed.
- database is locked
22jun04 19:51:34 John Robb's Weblog error: Can't update the feed.
- database is locked
22jun04 19:51:33 Updated channel Instapundit.com OK.

User avatar
support
Site Admin
Posts: 3022
Joined: Fri Feb 07, 2003 12:48 pm
Location: Melbourne, Australia
Contact:

Postby support » Wed Jun 23, 2004 4:36 am

dgnc wrote:It has started giving the database locked error. The parameter is set to 180. Will now set it to 360 and try again


Thanks for letting us know. I'm starting to suspect that this might have something to do with the automatic optimization of the database. Try turning it off (Search tab of the Program Options) and see if it makes a difference.

Massuda

Postby Massuda » Wed Jun 23, 2004 1:55 pm

I got the database locked error again... just restarted Awasu and it seems OK. I have noticed that I got these errors almost at the same day that dgnc.

About the automatic optimization... my settings are:

    automatically optimize every 2 days
    archive content, keep for 2 weeks


HTH


Return to “Awasu - Bug Reports”

Who is online

Users browsing this forum: No registered users and 0 guests