Fmstrat / Fmstrat/plex-db-sync
processing tags time out ?
- Dominant language
- Shell
- Stars
- 151
- Forks
- 23
- PR merge metrics
- No merged PRs in 30d
Description
what is this part ? is it normal to take time like that? :P it took exactly 5 min , maybe a time out ?
[Fri Jan 13 **04:26:43** UTC 2023] _-=-:
select ts1.*, t1.tag, m1.guid from taggings1 ts1, tags1 t1, metadata_items1 m1 where ts1.tag_id=t1.id and ts1.metadata_item_id=m1.id and t1.tag_type=11 and m1.guid in (select guid from metadata_items2) and m1.guid not in (select distinct m2.guid from taggings2 ts2, tags2 t2, metadata_items2 m2 where ts2.tag_id=t2.id and ts2.metadata_item_id=m2.id and t2.tag_type=11 and t2.tag=t1.tag);_
[Fri Jan 13 **04:31:43** UTC 2023] _-=-:
select distinct t2.* from taggings2 ts2, tags2 t2, metadata_items2 m2 where ts2.tag_id=t2.id and ts2.metadata_item_id=m2.id and t2.tag_type=11 and m2.guid in (select guid from metadata_items1) and t2.tag not in (select tag from tags1);_
```[Fri Jan 13 04:26:29 UTC 2023] Checking for changes... [Fri Jan 13 04:26:30 UTC 2023] UP1: 1673581440 - UP2: 1673583816
Found
[Fri Jan 13 04:26:38 UTC 2023] Processing tags...
[Fri Jan 13 04:26:38 UTC 2023] -=-: select distinct t1.* from taggings1 ts1, tags1 t1, metadata_items1 m1 where ts1.tag_id=t1.id and ts1.metadata_item_id=m1.id and t1.tag_type=11 and m1.guid in (select guid from metadata_items2) and t1.tag not in (select tag from tags2);
[Fri Jan 13 04:26:43 UTC 2023] -=-: select ts1.*, t1.tag, m1.guid from taggings1 ts1, tags1 t1, metadata_items1 m1 where ts1.tag_id=t1.id and ts1.metadata_item_id=m1.id and t1.tag_type=11 and m1.guid in (select guid from metadata_items2) and m1.guid not in (select distinct m2.guid from taggings2 ts2, tags2 t2, metadata_items2 m2 where ts2.tag_id=t2.id and ts2.metadata_item_id=m2.id and t2.tag_type=11 and t2.tag=t1.tag);
[Fri Jan 13 04:31:43 UTC 2023] -=-: select distinct t2.* from taggings2 ts2, tags2 t2, metadata_items2 m2 where ts2.tag_id=t2.id and ts2.metadata_item_id=m2.id and t2.tag_type=11 and m2.guid in (select guid from metadata_items1) and t2.tag not in (select tag from tags1);
[Fri Jan 13 04:31:49 UTC 2023] -=-: select ts2.*, t2.tag, m2.guid from taggings2 ts2, tags2 t2, metadata_items2 m2 where ts2.tag_id=t2.id and ts2.metadata_item_id=m2.id and t2.tag_type=11 and m2.guid in (select guid from metadata_items1) and m2.guid not in (select distinct m1.guid from taggings1 ts1, tags1 t1, metadata_items1 m1 where ts1.tag_id=t1.id and ts1.metadata_item_id=m1.id and t1.tag_type=11 and t1.tag=t2.tag);
[Fri Jan 13 04:36:49 UTC 2023] -=-: select id, name from accounts where lower(name) not in () order by id;
[Fri Jan 13 04:36:50 UTC 2023] -=-: select id, name from accounts where lower(name) not in () order by id;
[Fri Jan 13 04:36:50 UTC 2023] Processing for (0)...```
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.