Never-Ending Header Update

[spearhead]

I added a few more checks to prevent the notice you get.

I can't really reproduce the problem here... so it's hard to debug 

[andz]

tried r416 for a few hours on an update but it seems that the problem occurred again.

It started perfectly at around 7000 articles/s 4h ago, but after an hour or so it has been back to less than 2000 articles/s and estimates another 8h till finishing.
Let's see if he ever does....

[Styck]

Hmm I think the database slows down if the group's parts-table becomes larger and larger. So it should finish but it'll take a while.

[spearhead]

Hmm I think the database slows down if the group's parts-table becomes larger and larger. So it should finish but it'll take a while.

Maybe postgres has better performance for this stuff.... would be interesting if some one would try it out anyway, now it is technically supported by URD

[andz]

It's been updating now for almost 24hs. Task status is frozen for a while:

Code:

Updating alt.binaries.erotica 68% Running 283m 34s 2009-01-05 12:20:26 2009-01-05 22:03:20 1624 articles/s - total 90044019 articles

But Thread is still running.

Code:

#1. id:3 pid:881 u:andz s:13 cmd:UPDATE 1081 active qt:84365.2005661 st:84365.1735198

I'll update to r425 and give postgres a try.

[andz]

urdd (r425) doesn't start with postgres:

Code:

                     ^ (2)
^ (2)
^ (2)
^] in EXECUTE("UPDATE downloadinfo SET "position" = '0'")
^ (2)
^ (2)
2009-01-06 13:46:34 INFO sighandler (signal: 0) called as parent
2009-01-06 13:46:34 WARNING Warning on line 115 in file /var/www/urd/functions/adodb/drivers/adodb-postgres7.inc.php: pg_query(): Query failed: ERROR: column "position" of relation "downloadinfo" does not exist
^ (2)
^ (2)
2009-01-06 13:46:34 WARNING Warning on line 115 in file /var/www/urd/functions/adodb/drivers/adodb-postgres7.inc.php: pg_query(): Query failed: ERROR: column "position" of relation "downloadinfo" does not exist
2009-01-06 13:46:34 WARNING Warning on line 115 in file /var/www/urd/functions/adodb/drivers/adodb-postgres7.inc.php: pg_query(): Query failed: server closed the connection unexpectedly
^ (2)
2009-01-06 13:46:33 ERROR Cannot connect to server: news.us.Ngroups.NET
2009-01-06 13:46:33 ERROR Connection timed out
2009-01-06 13:46:33 WARNING Warning on line 151 in file /var/www/urd/functions/libs/socket.php: fsockopen(): unable to connect to tcp://news.us.Ngroups.NET:119 (Connection timed out) (2)
2009-01-06 13:46:18 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 13:46:18 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 13:46:17 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 13:46:17 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 13:46:17 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 13:46:17 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 13:46:16 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 13:46:16 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 13:46:16 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 13:46:16 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 13:46:15 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 13:46:15 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 13:46:15 NOTICE Starting urdd
2009-01-06 13:46:15 INFO using authentication as NG018878@Ngroups.NET

[spearhead]

My bad, I forgot to add the new column to the pq database structure. You can add a column to downloadinfo by running the command:
ALTER table downloadinfo ADD COLUMN  "position" integer DEFAULT '0' NOT NULL;

I also updated the urd_pg_sql.db file now

[andz]

ok I update is running, but I still get these messages:

Code:

^ (2)
^ (2)
^ (2)
^ (2)
^] in EXECUTE("UPDATE downloadinfo SET "position" = '0'")
^ (2)
^ (2)
^ (2)
^ (2)
^ (2)
^ (2)
^ (2)
^ (2)
^] in EXECUTE("UPDATE downloadinfo SET "position" = '0'")
^ (2)
^ (2)
^ (2)
^] in EXECUTE("SELECT ID FROM groups WHERE active='1'")
^ (2)
^ (2)
^ (2)
^ (2)
^] in EXECUTE("UPDATE queueinfo SET "priority" = '50' WHERE "id"= '0'")
^ (2)
2009-01-06 14:22:52 NOTICE Getting headers 189743630 to 280353188
2009-01-06 14:22:51 NOTICE Determining first articles number for alt.binaries.erotica
2009-01-06 14:22:51 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:22:51 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:21:33 WARNING Warning on line 115 in file /var/www/urd/functions/adodb/drivers/adodb-postgres7.inc.php: pg_query(): Query failed: ERROR: column "id" does not exist
2009-01-06 14:21:33 WARNING Warning on line 115 in file /var/www/urd/functions/adodb/drivers/adodb-postgres7.inc.php: pg_query(): Query failed: ERROR: column "id" does not exist
2009-01-06 14:20:52 NOTICE Done with grouplist from server. Inserted 6458, Updated 0
2009-01-06 14:20:52 INFO sighandler (signal: 0) called as child
2009-01-06 14:20:45 NOTICE Getting grouplist from server.
2009-01-06 14:20:45 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:20:43 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:15:19 WARNING Warning on line 115 in file /var/www/urd/functions/adodb/drivers/adodb-postgres7.inc.php: pg_query(): Query failed: ERROR: column "id" does not exist
2009-01-06 14:15:19 ERROR Restore failed: Could not execute SQL query "UPDATE queueinfo SET "priority" = '50' WHERE "id"= '0'" postgres7 error: [-1: ERROR: column "id" does not exist
2009-01-06 14:15:19 WARNING Warning on line 115 in file /var/www/urd/functions/adodb/drivers/adodb-postgres7.inc.php: pg_query(): Query failed: ERROR: column "id" does not exist
2009-01-06 14:15:18 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:15:18 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:15:18 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:15:17 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:15:17 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:15:17 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:15:17 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:15:16 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:15:16 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:15:16 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:15:16 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:15:15 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:15:15 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:15:15 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:15:15 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:15:14 NOTICE Starting urdd
2009-01-06 14:15:14 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:00:04 WARNING Warning on line 115 in file /var/www/urd/functions/adodb/drivers/adodb-postgres7.inc.php: pg_query(): Query failed: ERROR: column "position" of relation "downloadinfo" does not exist
2009-01-06 14:00:04 WARNING Warning on line 115 in file /var/www/urd/functions/adodb/drivers/adodb-postgres7.inc.php: pg_query(): Query failed: ERROR: column "position" of relation "downloadinfo" does not exist
2009-01-06 14:00:04 CRITICAL Opening socket failed? Could not execute SQL query "UPDATE downloadinfo SET "position" = '0'" postgres7 error: [-1: ERROR: column "position" of relation "downloadinfo" does not exist
2009-01-06 14:00:04 INFO sighandler (signal: 0) called as parent
2009-01-06 14:00:04 WARNING Warning on line 115 in file /var/www/urd/functions/adodb/drivers/adodb-postgres7.inc.php: pg_query(): Query failed: ERROR: column "position" of relation "downloadinfo" does not exist
2009-01-06 14:00:04 WARNING Warning on line 115 in file /var/www/urd/functions/adodb/drivers/adodb-postgres7.inc.php: pg_query(): Query failed: ERROR: column "position" of relation "downloadinfo" does not exist
2009-01-06 13:59:55 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 13:59:54 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 13:59:54 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 13:59:54 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 13:59:54 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 13:59:53 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 13:59:53 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 13:59:53 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 13:59:53 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 13:59:52 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 13:59:52 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 13:59:52 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 13:59:52 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 13:59:51 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 13:59:51 NOTICE Starting urdd

ID /= id ?

[spearhead]

ok I update is running, but I still get these messages:

ID /= id ?

In MySQL it is, in PGSQL it isn't... the latter is case sensitive unfort.... I fixed this. Also PG doesn't like ID or anything with ID in queries unless it is quoted. I do some more testing with pgsql later myself. I tested it before when I fixed URD to work with PG, but now there are some changes again, that may give troubles on PG as we both work mainly with mysql.


>column "position" of relation "downloadinfo" does not exist
Have you updated the database configuration to include position in de table  downloadinfo?

[andz]

yes I included that column, but there was some old output in the previous post.
r427 is now running like this:

Code:

2009-01-06 14:46:41 DEBUG read line: [SHOW threads]
2009-01-06 14:46:41 NOTICE Select failed 189829629: No such article found (No Such Article)
2009-01-06 14:46:41 DEBUG fn:do_show_jobs() pid:27704 (6029312 6029312)
2009-01-06 14:46:41 DEBUG fn:do_show_queue() pid:27704 (6029312 6029312)
2009-01-06 14:46:41 DEBUG read line: [SHOW jobs]
2009-01-06 14:46:41 DEBUG fn:do_show() pid:27704 (6029312 6029312)
2009-01-06 14:46:39 NOTICE Select failed 189815629: No such article found (No Such Article)
2009-01-06 14:46:39 NOTICE Select failed 189813629: No such article found (No Such Article)
2009-01-06 14:46:38 NOTICE Select failed 189811629: No such article found (No Such Article)
2009-01-06 14:46:37 DEBUG read line: [SET scheduler on ]
2009-01-06 14:46:37 DEBUG fn:do_set() pid:27704 (6029312 6029312)
2009-01-06 14:46:37 WARNING Warning on line 115 in file /var/www/urd/functions/adodb/drivers/adodb-postgres7.inc.php: pg_query(): Query failed: ERROR: column "ID" does not exist
2009-01-06 14:46:37 WARNING Warning on line 115 in file /var/www/urd/functions/adodb/drivers/adodb-postgres7.inc.php: pg_query(): Query failed: ERROR: column "ID" does not exist
2009-01-06 14:46:37 NOTICE Select failed 189799629: No such article found (No Such Article)
2009-01-06 14:46:37 DEBUG Incoming connection from host localhost:55853
2009-01-06 14:46:37 DEBUG read line: [USER andz]
2009-01-06 14:46:37 DEBUG fn:do_diskfree() pid:27704 (6029312 6029312)
2009-01-06 14:46:37 DEBUG read line: [DISKFREE b]
2009-01-06 14:46:37 DEBUG fn:do_diskfree() pid:27704 (6029312 6029312)
2009-01-06 14:46:37 DEBUG read line: [PASS md5:f910522c2c221dd183099d785efb2d2b]
2009-01-06 14:46:37 DEBUG read line: [DISKFREE h]
2009-01-06 14:46:36 NOTICE Select failed 189797629: No such article found (No Such Article)
2009-01-06 14:46:35 NOTICE Select failed 189791629: No such article found (No Such Article)
2009-01-06 14:46:34 NOTICE Select failed 189785629: No such article found (No Such Article)
2009-01-06 14:46:28 NOTICE Getting headers 189743630 to 280357277
2009-01-06 14:46:27 NOTICE Determining first articles number for alt.binaries.erotica
2009-01-06 14:46:27 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:46:26 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:44:59 NOTICE Done with grouplist from server. Inserted 0, Updated 6458
2009-01-06 14:44:59 INFO sighandler (signal: 0) called as child
2009-01-06 14:44:52 NOTICE Getting grouplist from server.
2009-01-06 14:44:52 WARNING Warning on line 482 in file /var/www/urd/urdd/urdd.php: socket_bind(): unable to bind address [98]: Address already in use (2)
2009-01-06 14:44:52 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:44:52 NOTICE Restored 'GROUPS '
2009-01-06 14:44:52 INFO Error: Address already in use (98)
2009-01-06 14:44:52 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:44:52 ERROR No listening sockets could be established
2009-01-06 14:44:52 INFO sighandler (signal: 0) called as parent
2009-01-06 14:44:52 WARNING Warning on line 500 in file /var/www/urd/urdd/urdd.php: socket_bind(): unable to bind address [98]: Address already in use (2)
2009-01-06 14:44:52 INFO Error: Address already in use (98)
2009-01-06 14:44:51 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:44:51 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:44:51 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:44:51 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:44:50 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:44:50 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:44:50 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:44:50 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:44:50 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:44:50 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:44:50 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:44:50 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:44:49 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:44:49 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:44:49 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:44:49 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:44:49 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:44:49 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:44:49 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:44:49 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:44:48 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:44:48 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:44:48 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:44:48 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:44:48 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:44:48 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:44:47 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:44:47 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:44:47 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 14:44:47 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 14:44:47 NOTICE Starting urdd

[spearhead]

 socket_bind(): unable to bind address [98] usually means you have another instance of Urdd running.

Do you know what caused the  ERROR: column "ID" does not exist?

[andz]

This time the update ended, but a little early and like this:

Code:

2009-01-06 15:14:06 DEBUG Deleted 0 binaries
2009-01-06 15:14:06 DEBUG Child exited (rc: 0)
2009-01-06 15:14:06 DEBUG Something else happen (0) probably a thread just ended
2009-01-06 15:14:05 DEBUG fn:queue_purge_expire() pid:27704 (6029312 6029312)
2009-01-06 15:14:05 DEBUG pushing on the queue 9
2009-01-06 15:14:05 DEBUG Something else happen (0) probably a thread just ended
2009-01-06 15:14:05 DEBUG pushing on the queue
2009-01-06 15:14:05 INFO sighandler (signal: 0) called as child
2009-01-06 15:14:05 DEBUG Connecting to postgres8 @ localhost
2009-01-06 15:14:05 ERROR Timeout occurred (10)
2009-01-06 15:14:05 WARNING Cannot get messages:
2009-01-06 15:14:05 DEBUG Child exited (rc: 0)
2009-01-06 15:14:05 ERROR Error while updating alt.binaries.erotica: Timeout occurred
2009-01-06 15:14:05 DEBUG Deleting expired posts
2009-01-06 15:14:05 INFO Deleting 0 binaries
2009-01-06 15:14:05 DEBUG Connecting to postgres8 @ localhost
2009-01-06 15:14:05 DEBUG fn:do_expire() pid:28773 (6029312 6029312)
2009-01-06 15:14:05 DEBUG fn:expire_binaries() pid:28773 (6029312 6029312)
2009-01-06 15:14:05 DEBUG worker forked
2009-01-06 15:14:05 DEBUG fn:queue_delete() pid:27704 (6029312 6029312)
2009-01-06 15:14:05 DEBUG fn:handle_queue_item() pid:28773 (6029312 6029312)
2009-01-06 15:14:03 DEBUG read line: [PASS md5:f910522c2c221dd183099d785efb2d2b]
2009-01-06 15:14:03 DEBUG read line: [USER andz]
2009-01-06 15:14:03 DEBUG Incoming connection from host localhost:57248
2009-01-06 15:14:03 DEBUG read line: [DISKFREE h]
2009-01-06 15:14:03 DEBUG fn:do_diskfree() pid:27704 (6029312 6029312)
2009-01-06 15:14:03 DEBUG fn:do_diskfree() pid:27704 (6029312 6029312)
2009-01-06 15:14:03 DEBUG read line: [DISKFREE b]

After the update table "parts_1081" is empty and no sets are available.

I'll start over with r431, but I do not know what caused the "ID" message. Every time I just purge all groups, unsubscribe from all, upgrade/restart urdd and subscribe to alt.binaries.erotica again.

[spearhead]

looks like a misconfiguration of the usenet servers... it doesn't seem to connect to the newsserver

[andz]

that's strange because I've got no timeout problems with pan.

now I tried to download articles and expire nothing from timeout to timeout:

Code:

2009-01-06 20:46:20 NOTICE Select failed 190171394: No such article found (No Such Article)
2009-01-06 20:46:20 WARNING Warning on line 115 in file /var/www/urd/functions/adodb/drivers/adodb-postgres7.inc.php: pg_query(): Query failed: ERROR: column "ID" does not exist
2009-01-06 20:46:20 WARNING Warning on line 115 in file /var/www/urd/functions/adodb/drivers/adodb-postgres7.inc.php: pg_query(): Query failed: ERROR: column "ID" does not exist
2009-01-06 20:46:20 WARNING Could not execute SQL query "DELETE FROM schedule where "ID" = '3'" postgres7 error: [-1: ERROR: column "ID" does not exist
2009-01-06 20:46:19 NOTICE Select failed 190169394: No such article found (No Such Article)
2009-01-06 20:46:18 NOTICE Select failed 190159394: No such article found (No Such Article)
2009-01-06 20:46:18 NOTICE Select failed 190161394: No such article found (No Such Article)
2009-01-06 20:46:18 NOTICE Select failed 190163394: No such article found (No Such Article)
2009-01-06 20:46:17 NOTICE Select failed 190155394: No such article found (No Such Article)
2009-01-06 20:46:17 NOTICE Select failed 190157394: No such article found (No Such Article)
2009-01-06 20:46:15 NOTICE Select failed 190143394: No such article found (No Such Article)
2009-01-06 20:46:12 NOTICE Select failed 190121394: No such article found (No Such Article)
2009-01-06 20:46:11 NOTICE Select failed 190115394: No such article found (No Such Article)
2009-01-06 20:46:09 NOTICE Select failed 190105394: No such article found (No Such Article)
2009-01-06 20:46:09 NOTICE Select failed 190103394: No such article found (No Such Article)
2009-01-06 20:46:08 NOTICE Select failed 190099394: No such article found (No Such Article)
2009-01-06 20:46:08 NOTICE Select failed 190095394: No such article found (No Such Article)
2009-01-06 20:46:04 NOTICE Select failed 190067394: No such article found (No Such Article)
2009-01-06 20:46:03 NOTICE Select failed 190063394: No such article found (No Such Article)
2009-01-06 20:46:02 NOTICE Select failed 190055394: No such article found (No Such Article)
2009-01-06 20:46:01 NOTICE Select failed 190051394: No such article found (No Such Article)
2009-01-06 20:45:59 NOTICE Select failed 190037394: No such article found (No Such Article)
2009-01-06 20:45:58 NOTICE Select failed 190033394: No such article found (No Such Article)
2009-01-06 20:45:57 NOTICE Select failed 190025394: No such article found (No Such Article)
2009-01-06 20:45:46 NOTICE Select failed 189959394: No such article found (No Such Article)
2009-01-06 20:45:44 NOTICE Select failed 189945394: No such article found (No Such Article)
2009-01-06 20:45:42 NOTICE Select failed 189931394: No such article found (No Such Article)
2009-01-06 20:45:39 NOTICE Select failed 189915394: No such article found (No Such Article)
2009-01-06 20:45:34 NOTICE Select failed 189879394: No such article found (No Such Article)
2009-01-06 20:45:32 NOTICE Select failed 189863394: No such article found (No Such Article)
2009-01-06 20:45:30 NOTICE Select failed 189849394: No such article found (No Such Article)
2009-01-06 20:45:29 NOTICE Select failed 189847394: No such article found (No Such Article)
2009-01-06 20:45:28 NOTICE Select failed 189843394: No such article found (No Such Article)
2009-01-06 20:45:26 NOTICE Select failed 189829394: No such article found (No Such Article)
2009-01-06 20:45:24 NOTICE Select failed 189815394: No such article found (No Such Article)
2009-01-06 20:45:24 NOTICE Select failed 189813394: No such article found (No Such Article)
2009-01-06 20:45:23 NOTICE Select failed 189805394: No such article found (No Such Article)
2009-01-06 20:45:23 NOTICE Select failed 189811394: No such article found (No Such Article)
2009-01-06 20:45:22 NOTICE Select failed 189799394: No such article found (No Such Article)
2009-01-06 20:45:21 NOTICE Select failed 189797394: No such article found (No Such Article)
2009-01-06 20:45:20 NOTICE Select failed 189789394: No such article found (No Such Article)
2009-01-06 20:45:19 NOTICE Select failed 189785394: No such article found (No Such Article)
2009-01-06 20:45:10 NOTICE Getting headers 189745395 to 280528735
2009-01-06 20:45:09 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 20:45:09 NOTICE Determining first articles number for alt.binaries.erotica
2009-01-06 20:45:01 INFO Connecting to NNTP server: news.us.Ngroups.NET

upon every log update the following message occurs and disappears again:

Code:

^] in EXECUTE("DELETE FROM schedule where "ID" = '3'")
^ (2)
2009-01-06 20:55:54 NOTICE Select failed 193413708: No such article found (No Such Article)
^ (2)
2009-01-06 20:55:53 NOTICE Select failed 193411708: No such article found (No Such Article)

[spearhead]

I fixed the problem with the ID

[spearhead]

Can you post the log right from the start till at least

DEBUG fn:reload_scheduled_jobs() pid:27936

[andz]

ok
r432:

Code:

2009-01-06 23:28:08 DEBUG fn:__destruct() pid:14600 (5767168 5767168)
2009-01-06 23:28:08 DEBUG fn:__destruct() pid:14600 (5767168 5767168)
2009-01-06 23:28:08 DEBUG fn:disconnect() pid:14600 (5767168 5767168)
2009-01-06 23:28:08 DEBUG fn:__destruct() pid:14600 (5767168 5767168)
2009-01-06 23:28:08 DEBUG fn:disconnect() pid:14600 (5767168 5767168)
2009-01-06 23:28:08 DEBUG fn:restore_old_queue() pid:14600 (6029312 6029312)
2009-01-06 23:28:08 DEBUG fn:disconnect() pid:14600 (5767168 5767168)
2009-01-06 23:28:08 DEBUG fn:server() pid:14600 (5767168 5767168)
2009-01-06 23:28:08 DEBUG fn:reload_scheduled_jobs() pid:14600 (6029312 6029312)
2009-01-06 23:28:08 DEBUG fn:listen_socket() pid:14600 (5767168 5767168)
2009-01-06 23:28:08 DEBUG fn:set_handlers() pid:14600 (5767168 5767168)
2009-01-06 23:28:07 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 23:28:07 DEBUG fn:connect() pid:14600 (5767168 5767168)
2009-01-06 23:28:07 DEBUG fn:__construct() pid:14600 (5767168 5767168)
2009-01-06 23:28:07 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 23:28:07 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 23:28:07 DEBUG fn:disconnect() pid:14600 (5767168 5767168)
2009-01-06 23:28:07 DEBUG fn:__destruct() pid:14600 (5767168 5767168)
2009-01-06 23:28:07 DEBUG fn:disconnect() pid:14600 (5767168 5767168)
2009-01-06 23:28:07 DEBUG fn:__destruct() pid:14600 (5767168 5767168)
2009-01-06 23:28:06 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 23:28:06 DEBUG fn:connect() pid:14600 (5767168 5767168)
2009-01-06 23:28:06 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 23:28:06 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 23:28:06 DEBUG fn:__construct() pid:14600 (5767168 5767168)
2009-01-06 23:28:06 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 23:28:06 DEBUG fn:__construct() pid:14600 (5767168 5767168)
2009-01-06 23:28:06 DEBUG fn:connect() pid:14600 (5767168 5767168)
2009-01-06 23:28:05 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 23:28:05 DEBUG fn:__construct() pid:14600 (5767168 5767168)
2009-01-06 23:28:05 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 23:28:05 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 23:28:05 DEBUG fn:connect() pid:14600 (5767168 5767168)
2009-01-06 23:28:05 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 23:28:05 DEBUG fn:__construct() pid:14600 (5767168 5767168)
2009-01-06 23:28:05 DEBUG fn:connect() pid:14600 (5767168 5767168)
2009-01-06 23:28:04 DEBUG fn:__construct() pid:14600 (5242880 5242880)
2009-01-06 23:28:04 NOTICE Starting urdd
2009-01-06 23:28:04 DEBUG fn:connect() pid:14600 (5242880 5242880)
2009-01-06 23:28:04 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 23:27:46 DEBUG read line: [SHUTDOWN]

r434:

Code:

2009-01-06 23:31:56 DEBUG fn:disconnect() pid:14779 (5767168 5767168)
2009-01-06 23:31:56 DEBUG fn:__destruct() pid:14779 (5767168 5767168)
2009-01-06 23:31:56 DEBUG fn:__destruct() pid:14779 (5767168 5767168)
2009-01-06 23:31:56 DEBUG fn:__destruct() pid:14779 (5767168 5767168)
2009-01-06 23:31:56 DEBUG fn:disconnect() pid:14779 (5767168 5767168)
2009-01-06 23:31:56 DEBUG fn:disconnect() pid:14779 (5767168 5767168)
2009-01-06 23:31:56 DEBUG fn:__destruct() pid:14779 (5767168 5767168)
2009-01-06 23:31:56 DEBUG fn:disconnect() pid:14779 (5767168 5767168)
2009-01-06 23:31:56 DEBUG fn:restore_old_queue() pid:14779 (6029312 6029312)
2009-01-06 23:31:56 DEBUG fn:reload_scheduled_jobs() pid:14779 (6029312 6029312)
2009-01-06 23:31:56 DEBUG fn:server() pid:14779 (5767168 5767168)
2009-01-06 23:31:56 DEBUG fn:__destruct() pid:14779 (5767168 5767168)
2009-01-06 23:31:56 DEBUG fn:disconnect() pid:14779 (5767168 5767168)
2009-01-06 23:31:56 DEBUG fn:set_handlers() pid:14779 (5767168 5767168)
2009-01-06 23:31:56 DEBUG fn:listen_socket() pid:14779 (5767168 5767168)
2009-01-06 23:31:55 DEBUG fn:__construct() pid:14779 (5767168 5767168)
2009-01-06 23:31:55 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 23:31:55 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 23:31:55 DEBUG fn:connect() pid:14779 (5767168 5767168)
2009-01-06 23:31:55 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 23:31:55 DEBUG fn:__destruct() pid:14779 (5767168 5767168)
2009-01-06 23:31:55 DEBUG fn:disconnect() pid:14779 (5767168 5767168)
2009-01-06 23:31:54 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 23:31:54 DEBUG fn:connect() pid:14779 (5767168 5767168)
2009-01-06 23:31:54 DEBUG fn:__construct() pid:14779 (5767168 5767168)
2009-01-06 23:31:54 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 23:31:54 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 23:31:54 DEBUG fn:__construct() pid:14779 (5767168 5767168)
2009-01-06 23:31:54 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 23:31:54 DEBUG fn:connect() pid:14779 (5767168 5767168)
2009-01-06 23:31:53 DEBUG fn:connect() pid:14779 (5767168 5767168)
2009-01-06 23:31:53 DEBUG fn:__construct() pid:14779 (5767168 5767168)
2009-01-06 23:31:53 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 23:31:53 INFO using authentication as NG018878@Ngroups.NET
2009-01-06 23:31:53 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 23:31:53 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 23:31:53 DEBUG fn:connect() pid:14779 (5767168 5767168)
2009-01-06 23:31:53 DEBUG fn:__construct() pid:14779 (5767168 5767168)
2009-01-06 23:31:52 NOTICE Starting urdd
2009-01-06 23:31:52 DEBUG fn:__construct() pid:14779 (5242880 5242880)
2009-01-06 23:31:52 DEBUG fn:connect() pid:14779 (5242880 5242880)
2009-01-06 23:31:52 INFO Connecting to NNTP server: news.us.Ngroups.NET
2009-01-06 23:31:32 DEBUG read line: [SHUTDOWN]

[andz]

r434 detailed timeout output:

Code:

2009-01-06 23:43:48 DEBUG fn:do_diskfree() pid:14779 (6029312 6029312)
2009-01-06 23:43:48 DEBUG read line: [DISKFREE b]
2009-01-06 23:43:48 DEBUG fn:do_diskfree() pid:14779 (6029312 6029312)
2009-01-06 23:43:47 DEBUG #1 /var/www/urd/functions/libs/nntp_client.php(709): Base_NNTP_Client->cmdFastXOver('192565709-19256...')
2009-01-06 23:43:47 DEBUG #2 /var/www/urd/functions/nntp.class.php(533): NNTP_Client->get_fast_overview(192565709, 192567708)
2009-01-06 23:43:47 DEBUG #3 /var/www/urd/functions/nntp.class.php(350): URD_NNTP->get_headers(Array, '189745395', '280574075', Object(action))
2009-01-06 23:43:47 DEBUG #4 /var/www/urd/urdd/do_functions.php(256): URD_NNTP->update_newsgroup(Array, Object(action))
2009-01-06 23:43:47 DEBUG #0 /var/www/urd/functions/libs/base_nntp_client.php(1180): Base_NNTP_Client->_sendCommand('XOVER 192565709...')
2009-01-06 23:43:47 NOTICE Select failed 192565708: Timeout occurred
2009-01-06 23:43:47 DEBUG #5 /var/www/urd/urdd/urdd.php(108): do_update(Object(action), Object(DatabaseConnection))
2009-01-06 23:43:47 DEBUG fn:disconnect() pid:14860 (6291456 6291456)
2009-01-06 23:43:47 WARNING Cannot get messages:
2009-01-06 23:43:47 ERROR Not connected (10)
2009-01-06 23:43:47 ERROR Error while updating alt.binaries.erotica: Not connected
2009-01-06 23:43:47 DEBUG #8 /var/www/urd/urdd/urdd.php(605): server(Array, Object(DatabaseConnection), Object(server_data))
2009-01-06 23:43:47 DEBUG #6 /var/www/urd/urdd/urdd.php(246): handle_queue_item(Object(DatabaseConnection), Object(server_data), Object(action))
2009-01-06 23:43:47 INFO shutdown handler called as child
2009-01-06 23:43:47 DEBUG Child exited (rc: 0)
2009-01-06 23:43:47 DEBUG Something else happen (0) probably a thread just ended
2009-01-06 23:43:47 DEBUG fn:disconnect() pid:14860 (6291456 6291456)
2009-01-06 23:43:47 DEBUG fn:shutdown_handler() pid:14860 (6291456 6291456)
2009-01-06 23:43:47 DEBUG fn:__destruct() pid:14860 (6291456 6291456)
2009-01-06 23:43:47 DEBUG #7 /var/www/urd/urdd/urdd.php(372): check_queue(Object(DatabaseConnection), Object(conn_list), Object(server_data))
2009-01-06 23:43:47 DEBUG #9 {main}

[spearhead]

there is something really weird in that log of yours everything seems double.... and the connects in the beginning must be sequential they can't be interleaved?

How did you switch from mysql to postgresql?

[andz]

I installed postgres and php5 pg extension via apt-get. Then changed pw of user postgres and created a database named urd with that user via pgAdmin3.
Then I removed file .installed from directory /var/www/urd, then "svn up" and installed urd from there again without an error.

[spearhead]

it seems that more ppl (incl Styck) have trouble with the new timeout code.... the funny thing is it works like a charm here, so it is really hard to debug and I haven't any clue what is going wrong.

[andz]

I'm trying r478 right now, but I'm still getting a timeout at socket timeout = 240. It starts perfectly at 7000 articles/s. Database gets filled with articles, but soon estimated time raises from 4h to over 1 day. After a few hours then a timeout occurs.

Can I send you the complete log?

[spearhead]

I'm trying r478 right now, but I'm still getting a timeout at socket timeout = 240. It starts perfectly at 7000 articles/s. Database gets filled with articles, but soon estimated time raises from 4h to over 1 day. After a few hours then a timeout occurs.

Can I send you the complete log?

interesting... the timeout should occur when URDD doesn't get any results from the news server or can't write to it anymore... I guess that is what happens. but sure send me the log file .

[andz]

did send you a log and a part of that table. looks like there are a lot of duplicate articles in there.

[andz]

I'm testing r521 right now and still there are many duplicate articles in table "parts_1082".
The update of a.b.erotica started 8h ago and is at 30% right now.
The bigger it gets, the more articles are duplicate.
It's at around 9mio lines right now, 500 articles/sec and will end in 5 days!

Code:

9498979;"000158c8413f25adc6d0efd5ccdb7c7f";"part110of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219643;110;397104;0
9492553;"000158c8413f25adc6d0efd5ccdb7c7f";"part68of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219349;68;396956;0
9489041;"000158c8413f25adc6d0efd5ccdb7c7f";"part51of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219221;51;397308;0
9494882;"000158c8413f25adc6d0efd5ccdb7c7f";"part77of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219435;77;396922;0
9497697;"000158c8413f25adc6d0efd5ccdb7c7f";"part88of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219523;88;397227;0
9493600;"000158c8413f25adc6d0efd5ccdb7c7f";"part73of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219391;73;396833;0
9487915;"000158c8413f25adc6d0efd5ccdb7c7f";"part35of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219089;35;396981;0
9492036;"000158c8413f25adc6d0efd5ccdb7c7f";"part65of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219332;65;397483;0
9499174;"000158c8413f25adc6d0efd5ccdb7c7f";"part114of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219665;114;396732;0
9495551;"000158c8413f25adc6d0efd5ccdb7c7f";"part79of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219456;79;397160;0
9487471;"000158c8413f25adc6d0efd5ccdb7c7f";"part27of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219032;27;396824;0
9491556;"000158c8413f25adc6d0efd5ccdb7c7f";"part62of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219312;62;397195;0
9498229;"000158c8413f25adc6d0efd5ccdb7c7f";"part94of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219551;94;396923;0
9492443;"000158c8413f25adc6d0efd5ccdb7c7f";"part67of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219344;67;397062;0
9487519;"000158c8413f25adc6d0efd5ccdb7c7f";"part28of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219037;28;397148;0
9494263;"000158c8413f25adc6d0efd5ccdb7c7f";"part75of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219416;75;397241;0
9496907;"000158c8413f25adc6d0efd5ccdb7c7f";"part84of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219499;84;396893;0
9495193;"000158c8413f25adc6d0efd5ccdb7c7f";"part78of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219445;78;396786;0
9487846;"000158c8413f25adc6d0efd5ccdb7c7f";"part34of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219079;34;396813;0
9490558;"000158c8413f25adc6d0efd5ccdb7c7f";"part58of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219277;58;396931;0
9497953;"000158c8413f25adc6d0efd5ccdb7c7f";"part90of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219531;90;397105;0
9491416;"000158c8413f25adc6d0efd5ccdb7c7f";"part61of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219306;61;397461;0
9485892;"000158c8413f25adc6d0efd5ccdb7c7f";"part8of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219218840;8;396738;0
9493048;"000158c8413f25adc6d0efd5ccdb7c7f";"part70of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219366;70;397423;0
9498719;"000158c8413f25adc6d0efd5ccdb7c7f";"part104of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219612;104;397080;0
9491904;"000158c8413f25adc6d0efd5ccdb7c7f";"part64of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219326;64;396788;0
9488322;"000158c8413f25adc6d0efd5ccdb7c7f";"part41of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219141;41;397111;0
9493864;"000158c8413f25adc6d0efd5ccdb7c7f";"part74of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219401;74;396508;0
9498477;"000158c8413f25adc6d0efd5ccdb7c7f";"part98of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219579;98;396544;0
9491211;"000158c8413f25adc6d0efd5ccdb7c7f";"part60of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219298;60;397531;0
9487287;"000158c8413f25adc6d0efd5ccdb7c7f";"part25of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219011;25;397196;0
9495906;"000158c8413f25adc6d0efd5ccdb7c7f";"part80of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219468;80;397354;0
9496627;"000158c8413f25adc6d0efd5ccdb7c7f";"part83of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219490;83;397234;0
9492788;"000158c8413f25adc6d0efd5ccdb7c7f";"part69of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219357;69;397196;0
9489991;"000158c8413f25adc6d0efd5ccdb7c7f";"part56of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219257;56;396673;0
9493453;"000158c8413f25adc6d0efd5ccdb7c7f";"part72of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219383;72;397285;0
9499317;"000158c8413f25adc6d0efd5ccdb7c7f";"part118of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219684;118;397339;0
9493177;"000158c8413f25adc6d0efd5ccdb7c7f";"part71of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219372;71;397589;0
9488773;"000158c8413f25adc6d0efd5ccdb7c7f";"part46of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219195;46;396655;0
9490955;"000158c8413f25adc6d0efd5ccdb7c7f";"part59of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219290;59;396773;0
9496190;"000158c8413f25adc6d0efd5ccdb7c7f";"part81of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219476;81;397253;0
9494499;"000158c8413f25adc6d0efd5ccdb7c7f";"part76of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219423;76;397008;0
9487022;"000158c8413f25adc6d0efd5ccdb7c7f";"part21of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219218981;21;396822;0
9491786;"000158c8413f25adc6d0efd5ccdb7c7f";"part63of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219322;63;397035;0
9498534;"000158c8413f25adc6d0efd5ccdb7c7f";"part99of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219585;99;396915;0
9492227;"000158c8413f25adc6d0efd5ccdb7c7f";"part66of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219338;66;397166;0
9488207;"000158c8413f25adc6d0efd5ccdb7c7f";"part39of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219126;39;397140;0
9497020;"000158c8413f25adc6d0efd5ccdb7c7f";"part85of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219502;85;396877;0
9487652;"000158c8413f25adc6d0efd5ccdb7c7f";"part31of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219054;31;397167;0
9498621;"000158c8413f25adc6d0efd5ccdb7c7f";"part100of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219596;100;396928;0
9485810;"000158c8413f25adc6d0efd5ccdb7c7f";"part7of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219218832;7;397017;0
9498128;"000158c8413f25adc6d0efd5ccdb7c7f";"part92of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219538;92;396981;0
9485754;"000158c8413f25adc6d0efd5ccdb7c7f";"part6of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219218825;6;397075;0
9499508;"000158c8413f25adc6d0efd5ccdb7c7f";"part121of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219708;121;397006;0
9486145;"000158c8413f25adc6d0efd5ccdb7c7f";"part12of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219218871;12;397142;0
9499454;"000158c8413f25adc6d0efd5ccdb7c7f";"part120of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219701;120;397063;0
9485650;"000158c8413f25adc6d0efd5ccdb7c7f";"part4of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219218814;4;396748;0
9498354;"000158c8413f25adc6d0efd5ccdb7c7f";"part96of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219565;96;397078;0
9485688;"000158c8413f25adc6d0efd5ccdb7c7f";"part5of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219218818;5;397196;0
9498640;"000158c8413f25adc6d0efd5ccdb7c7f";"part101of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219601;101;396565;0
9488260;"000158c8413f25adc6d0efd5ccdb7c7f";"part40of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219134;40;396871;0
9499112;"000158c8413f25adc6d0efd5ccdb7c7f";"part112of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219658;112;397076;0
9486002;"000158c8413f25adc6d0efd5ccdb7c7f";"part9of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219218852;9;397003;0
9499011;"000158c8413f25adc6d0efd5ccdb7c7f";"part111of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219646;111;396781;0
9489340;"000158c8413f25adc6d0efd5ccdb7c7f";"part53of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219234;53;396932;0
9499225;"000158c8413f25adc6d0efd5ccdb7c7f";"part115of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219672;115;397066;0
9486808;"000158c8413f25adc6d0efd5ccdb7c7f";"part19of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219218955;19;396961;0
9498814;"000158c8413f25adc6d0efd5ccdb7c7f";"part106of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219624;106;396769;0
9486704;"000158c8413f25adc6d0efd5ccdb7c7f";"part18of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219218943;18;397127;0
9497427;"000158c8413f25adc6d0efd5ccdb7c7f";"part87of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219515;87;396643;0
9487773;"000158c8413f25adc6d0efd5ccdb7c7f";"part33of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219069;33;396972;0
9498068;"000158c8413f25adc6d0efd5ccdb7c7f";"part91of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219535;91;396864;0
9488814;"000158c8413f25adc6d0efd5ccdb7c7f";"part47of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219200;47;396972;0
9498671;"000158c8413f25adc6d0efd5ccdb7c7f";"part102of123.ZsifwFTv2NTYIlZubvs$@powerpost2000AA.local";"AAA presents #0506 Nikkis Playmates Pictures  147/152 "Roxys Tryout For The Bears.zip" yEnc";"AAA@power-post.org (AAA)";1219219605;102;396581;0