Danbooru 2 Issues Topic

albert said:

I've synced over any missing files over the id of 3,000,000. AFAIK this shouldn't happen anymore going forward. If it does, please link the post and most importantly the image URL it's using.

post #2219291 is missing, URL for image is https://danbooru.donmai.us/data/8544b08801941e4e13e864f4190a7b47.png
additonally post #2219126 is missing, but I refreshed and it showed up...and then I refreshed and it was gone, direct link when it was gone is https://danbooru.donmai.us/data/c3dc0ae8d4df07d1cb7aeec413c7feef.png

ion288 said:

Those are tagged loli and shota. You need a gold level account to see those.

happens for free tags too

post #2459202
post #2485690

mj1234 said:

happens for free tags too

post #2459202
post #2485690

See if one of https://hijiribe.donmai.us/posts/2459202 or https://sonohara.donmai.us/posts/2459202 works instead.

it worked

I'm always getting "ERROR: canceling statement due to statement timeout" for numerous tags with Grabber when I'm viewing 200 images per page.
example: http://danbooru.donmai.us/posts?utf8=%E2%9C%93&tags=sakura_kyouko+-comic&ms=1&limit=200

mj1234 said:

I'm always getting "ERROR: canceling statement due to statement timeout" for numerous tags with Grabber when I'm viewing 200 images per page.
example: http://danbooru.donmai.us/posts?utf8=%E2%9C%93&tags=sakura_kyouko+-comic&ms=1&limit=200

That’s nothing unusual. As a member-level user, your database timeout is 3 seconds (help:users), which is rarely enough to retrieve 200 posts. Unless you upgrade, you have to reduce the amount of posts per page.

Will posts lower than 3,000,000 be synced?

mj1234 said:

it worked

I'm always getting "ERROR: canceling statement due to statement timeout" for numerous tags with Grabber when I'm viewing 200 images per page.
example: http://danbooru.donmai.us/posts?utf8=%E2%9C%93&tags=sakura_kyouko+-comic&ms=1&limit=200

i'm also getting the same statement timeout on a builder account, 2 search tags only and limit of 20:
official_art copytags:0 limit:20

kittey said:

That’s nothing unusual. As a member-level user, your database timeout is 3 seconds (help:users), which is rarely enough to retrieve 200 posts. Unless you upgrade, you have to reduce the amount of posts per page.

it works fine for other tags and almost everything else, so I don't think that's the issue here

mj1234 said:

it works fine for other tags and almost everything else, so I don't think that's the issue here

Not all queries are the same. Some are more complex than others and require the database to search for longer.

For example...

ghostrigger said:

i'm also getting the same statement timeout on a builder account, 2 search tags only and limit of 20:
official_art copytags:0 limit:20

That’s one of those searches that attempts to find the intersection of two large and almost disjoint sets. Those are prone to time out even for builders. Apparently, there are only 13 posts matching that search, so the database has to do a full search. Try adding order:score to use the (inexplicably faster) score index: official_art copytags:0 order:score

kittey said:
...

That’s one of those searches that attempts to find the intersection of two large and almost disjoint sets. Those are prone to time out even for builders. Apparently, there are only 13 posts matching that search, so the database has to do a full search. Try adding order:score to use the (inexplicably faster) score index: official_art copytags:0 order:score

wow. thanks. never knew using score could produce something really helpful.

@albert
post #2777195 is missing, url for the file is https://danbooru.donmai.us/data/0ab5101e7dee1feac2dcded4ab190f9d.jpg
additonally
post #2704246 is missing url for image is https://danbooru.donmai.us/data/99d7dff0f735b7974233fe23c67f2d25.png

DeusExCalamus said:

@albert
post #2777195 is missing, url for the file is https://danbooru.donmai.us/data/0ab5101e7dee1feac2dcded4ab190f9d.jpg

Only on sonohara, though; hijiribe is just fine.

It seems I'm still seeing everything on sonohara and hijiribe fail to load on Windows 8.1 because of a TLS configuration problem.

Sonohara and hijiribe works fine* without TLS on plain HTTP, but it fails to load with TLS/HTTPS.

*sonohara seems to render pages with images that point to https://hijiribe.donmai.us/, and that doesn't work, since hijiribe and sonohara's HTTPS configuration doesn't work on Windows 8.1.

@albert
Would it be possible to delete flagged posts that are pending approval longer than three days? I think it would be quite unfair towards the flagger if those things are prnding longer approval than they should.
For normal pending posts older than 3 days I don't really the need to delete them as quickly as possible but would be a nice side effect as well.

Provence said:

@albert
Would it be possible to delete flagged posts that are pending approval longer than three days? I think it would be quite unfair towards the flagger if those things are prnding longer approval than they should.
For normal pending posts older than 3 days I don't really the need to delete them as quickly as possible but would be a nice side effect as well.

Agree with Provence here (but posts pending approval for 3+ days should be deleted, in my opinion). Approval queue is currently broken as posts are not getting deleted after being flagged or pending for 3 days. It’s pretty annoying when something gets reapproved after being flagged/pending for a week, or even more.

My bad. I figured out the cause (incorrect permissions). I'm running through all the maintenance tasks manually now.

albert said:

My bad. I figured out the cause (incorrect permissions). I'm running through all the maintenance tasks manually now.

What about the missing images?

So good news, I think I finally figured out the cause of the missing images from hijiribe. Please continue to report any missing images here.

Replacing tumblr images doesn't fix the soure to the URL page of an image but links to the image directly, instead:
http://hijiribe.donmai.us/post_versions?search%5Bpost_id%5D=2677964

It will fix the source if you use http://dayuh.tumblr.com/post/158543871957 as the source when replacing the post. If you don't know the html page, and you replace the post with http://data.tumblr.com/6e481ad41fdbaeb32618626906defda9/tumblr_inline_on0al390L11tj3m5z_raw.jpg, then it won't fix the source, since Danbooru doesn't know the html page either. This is what happened in this case.