Danbooru 2 Issues Topic

Schrobby said:

Trying to add tags results in a ~200 line error message starting with:

PG::QueryCanceled exception raised

    ERROR: canceling statement due to statement timeout
    /var/www/danbooru2/shared/bundle/ruby/2.1.0/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:834:in `get_last_result'
    /var/www/danbooru2/shared/bundle/ruby/2.1.0/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:834:in `block in exec_cache'
    /var/www/danbooru2/shared/bundle/ruby/2.1.0/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract_adapter.rb:373:in `block in log'

Having the same issue for uploading as well

Schrobby said:

Trying to add tags results in a ~200 line error message starting with:

PG::QueryCanceled exception raised

    ERROR: canceling statement due to statement timeout
    /var/www/danbooru2/shared/bundle/ruby/2.1.0/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:834:in `get_last_result'
    /var/www/danbooru2/shared/bundle/ruby/2.1.0/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:834:in `block in exec_cache'
    /var/www/danbooru2/shared/bundle/ruby/2.1.0/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract_adapter.rb:373:in `block in log'

Getting similar results with attempting to post a comment, and translation notes aren't saving either. Guess something's choking the pipeline somewhere.

Works again. Thanks for the fast fix.

Kikimaru said:

I can't access the Aliases page;
NoMethodError exception raised

Type-kun said:

This one is the culprit. Not sure what causes the error in the listing, but probably "copyright:" bit.

This is still the case.

hemoglobin said:

This is still the case.

The site hasn't been updated with the fix yet.

Quick feature request; when editing a post from a search result listing (by selecting Edit from the dropdown box), include the Parent box. Would help muchly when cleaning up after people who don't know the difference between a pool and parent/child relationship.

OOZ662 said:

Quick feature request; when editing a post from a search result listing (by selecting Edit from the dropdown box), include the Parent box. Would help muchly when cleaning up after people who don't know the difference between a pool and parent/child relationship.

You can just use the parent metatag. parent:1234 to set the parent as 1234, or parent:none to remove the parent.

Toks said:

or parent:none to remove the parent.

Didn't realized that worked. Spiff.

I've been mowing down the solo solo_focus tag combination as per their respective wiki articles. At first there were 19 pages. Now, around one hundred post changes later, the search still accuses 19 pages. When trying to check that 19th possibly-empty page, "Error: canceling due to statement timeout" comes up.

The limit seem to be around the 9th page as of now for me.

Chucu said:

I've been mowing down the solo solo_focus tag combination as per their respective wiki articles. At first there were 19 pages. Now, around one hundred post changes later, the search still accuses 19 pages. When trying to check that 19th possibly-empty page, "Error: canceling due to statement timeout" comes up.

The limit seem to be around the 9th page as of now for me.

From the big tag changes I've done, I think the number of pages reported for a tag search is cached. If it wasn't timing out, checking the 19th page would confirm it to be empty.

The reason it's timing out is probably because solo solo_focus is the small cross-section of two individually giant tags. This type of search is strenuous by nature and tends to time out often.

Yeah, there are currently 12 pages in that search. To check this you could search for solo solo_focus limit:20. The limit:20 won't actually change the search (assuming your limit is 20 to begin with) but it will count as a separate query for the purpose of the cache, allowing you to see the updated number of pages.

As for the timeout, I don't think there's any good way for a basic member to get around it, and it will probably happen more and more the fewer posts are in that query. But for gold+ users with a higher tag limit they could use the id metatag to partition results to make it faster. e.g. search for solo solo_focus id:1900000.., then solo solo_focus id:1800000..1900000, etc.

The update to auto-include pixiv artist commentary seems a bit... flaky. For images like pixiv #50311972 and pixiv #49908330, I get the "something broke" page with the bookmarklet, "Error: undefined" if I go to the upload page and click Fetch data, and {"success": false, "message": "\"\\xE9\" from ASCII-8BIT to UTF-8"} from the API.

EDIT: Though it's working now...

I'm pretty sure I didn't check the "Include Commentary" box when uploading post #2030503 but it still included the commentary. Or it could be that I checked it on accident since its clickable area extends the entire width of the page, like how the "Upload for approval" box used to. In any case, that clickable area needs to be brought down.

Ars said:

I'm pretty sure I didn't check the "Include Commentary" box when uploading post #2030503 but it still included the commentary. Or it could be that I checked it on accident since its clickable area extends the entire width of the page, like how the "Upload for approval" box used to. In any case, that clickable area needs to be brought down.

Yeah, it's including the commentary regardless.

Also, speaking of commentaries, I know it's almost been a year but I'd still like to see issue #2238 implemented.

Ars said:

Also, speaking of commentaries, I know it's almost been a year but I'd still like to see issue #2238 implemented.

The reason I don't like that idea is that it encourages people to copy the same commentary to many posts. e.g. There's a 20 page comic on Pixiv with commentary and someone decides to post the same commentary on all 20 pages or something. That's basically just spam and all it accomplishes is making things harder on translators since then they have to copy their translation to 20 posts too (including any edits to the translation).

Maybe a "Move artist commentary" feature that deletes the commentary from the post you're on while moving it to the new post, that way it can only be used for moving commentary from child -> parent and can't be used to duplicate commentary.

The new "Include commentary" is great to see.
I would like if it could also include the date of the post. Oftentimes the date is important for context.
Metadata beyond the date, like the programs used, would also be nice.

A function to copy commentary would really help. It would be possible to copy it to multiple posts, true, but copy notes allows the same and I see no note spamming yet.

K, till the commentary switch works it'd be nice if the function could be removed from the upload page. It's quite tedious to manually delete it everytime.

Schrobby said:

K, till the commentary switch works it'd be nice if the function could be removed from the upload page. It's quite tedious to manually delete it everytime.

Toks already made the fix, but someone should dmail Albert, so that he actually applies it.