https://bugs.gpodder.org/show_bug.cgi?id=933
Summary: Duplicate Episode Log Entries
Product: my.gPodder.org
Version: unspecified
Platform: PC
OS/Version: Linux
Status: NEW
Severity: feature request
Priority: low
Component: Generic
AssignedTo: [email protected]
ReportedBy: [email protected]
CC: [email protected]
We currently have lots of obviously duplicate entries in the episode log
(mainly for delete events). If this continues it could turn out to be a
performance problem.
SELECT user_id, episode_id, action, timestamp, count(*) AS c FROM episode_log
GROUP BY user_id, episode_id, action, DATE(timestamp) ORDER BY c DESC LIMIT 10;
+---------+------------+--------+---------------------+-----+
| user_id | episode_id | action | timestamp | c |
+---------+------------+--------+---------------------+-----+
| 7511 | 450062 | delete | 2010-03-07 20:09:30 | 294 |
| 7511 | 506777 | play | 2010-03-09 10:20:34 | 194 |
| 7511 | 333539 | delete | 2010-03-07 17:50:29 | 190 |
| 7511 | 333547 | delete | 2010-03-07 17:50:29 | 190 |
| 7511 | 333555 | delete | 2010-03-07 17:50:30 | 190 |
| 7511 | 333563 | delete | 2010-03-07 17:50:30 | 190 |
| 7511 | 333571 | delete | 2010-03-07 17:50:30 | 190 |
| 7511 | 333579 | delete | 2010-03-07 17:50:30 | 190 |
| 7511 | 333587 | delete | 2010-03-07 17:50:31 | 190 |
| 7511 | 333595 | delete | 2010-03-07 17:50:31 | 190 |
+---------+------------+--------+---------------------+-----+
When looking at the results at about row 20.000 they still contain duplicates
SELECT user_id, episode_id, action, timestamp, count(*) AS c FROM episode_log
GROUP BY user_id, episode_id, action, DATE(timestamp) ORDER BY c DESC LIMIT
20000, 10;
+---------+------------+----------+---------------------+---+
| user_id | episode_id | action | timestamp | c |
+---------+------------+----------+---------------------+---+
| 5 | 140438 | download | 2010-02-08 15:48:03 | 7 |
| 6822 | 143468 | download | 2010-03-03 14:41:15 | 7 |
| 5 | 130498 | download | 2010-02-12 14:57:45 | 7 |
| 6822 | 143476 | download | 2010-03-03 14:41:15 | 7 |
| 6822 | 143484 | download | 2010-03-03 14:41:16 | 7 |
| 6822 | 143489 | download | 2010-03-03 14:48:14 | 7 |
| 6822 | 143497 | download | 2010-03-03 14:48:14 | 7 |
| 6822 | 143505 | download | 2010-03-03 14:48:48 | 7 |
| 6822 | 143513 | download | 2010-03-03 14:48:48 | 7 |
| 6822 | 143521 | download | 2010-03-03 14:48:48 | 7 |
+---------+------------+----------+---------------------+---+
What exactly causes these duplicates is still unknown.
--
Configure bugmail: https://bugs.gpodder.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.
_______________________________________________
gPodder-Bugs mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/gpodder-bugs
