Embed Notice

HTML Code

<blockquote style="position: relative; padding-left: 55px;"><section><a href="https://ryona.agency/objects/79dc69cb-678c-4e51-8d5b-f2418b176fef">alenshore (anonymous6479@ryona.agency)'s status on Wednesday, 29-Nov-2023 22:33:13 JST</a><a href="https://ryona.agency/users/anonymous6479" title="anonymous6479@ryona.agency"><img src="https://gnusocial.jp/theme/gnusocialjp/default-avatar-stream.png" width="48" height="48" alt="alenshore" style="position: absolute; left: 0; top: 0;">alenshore</a><div><a href="https://ryona.agency/objects/45dd8d95-6f1c-466d-8355-7ebaf9c58272" rel="in-reply-to">in reply to</a><ul><li><li><a href="https://gnusocial.jp/user/206030" title="anonymous6479@ryona.agency">alenshore</a></li></ul></div></section><article><p><a href="https://mitra.social/users/silverpill">@silverpill</a> Debug info for a follow from an onion address:</p>2023-11-28T17:14:27 mitra::mastodon_api::search::helpers [WARN] failed to import profile anyawnymous@rawrxd4mden7rmbobaftao3qjyxbrvj4rrooehkqxlqcsdtnnn2hndid.onion: error sending request for url (<a href="http://rawrxd4mden7rmbobaftao3qjyxbrvj4rrooehkqxlqcsdtnnn2hndid.onion/.well-known/webfinger?resource=acct%3Aanyawnymous%40rawrxd4mden7rmbobaftao3qjyxbrvj4rrooehkqxlqcsdtnnn2hndid.onion">http://rawrxd4mden7rmbobaftao3qjyxbrvj4rrooehkqxlqcsdtnnn2hndid.onion/.well-known/webfinger?resource=acct%3Aanyawnymous%40rawrxd4mden7rmbobaftao3qjyxbrvj4rrooehkqxlqcsdtnnn2hndid.onion</a>): error trying to connect: dns error: failed to lookup address information: Name does not resolve
2023-11-28T17:14:27 tokio_postgres::prepare [DEBUG] preparing query s22: 
        SELECT
            post, actor_profile,
            ARRAY(
        SELECT media_attachment
        FROM media_attachment WHERE post_id = <a href="http://post.id">post.id</a>
        ORDER BY media_attachment.created_at
    ) AS attachments,
            ARRAY(
        SELECT actor_profile
        FROM mention
        JOIN actor_profile ON mention.profile_id = <a href="https://ryona.agency/objects/79dc69cb-678c-4e51-8d5b-f2418b176fef">actor_profile.id</a>
        WHERE post_id = <a href="http://post.id">post.id</a>
    ) AS mentions,
            ARRAY(
        SELECT tag.tag_name FROM tag
        JOIN post_tag ON post_tag.tag_id = <a href="http://tag.id">tag.id</a>
        WHERE post_tag.post_id = <a href="http://post.id">post.id</a>
    ) AS tags,
            ARRAY(
        SELECT post_link.target_id FROM post_link
        WHERE post_link.source_id = <a href="http://post.id">post.id</a>
    ) AS links,
            ARRAY(
        SELECT emoji
        FROM post_emoji
        JOIN emoji ON post_emoji.emoji_id = <a href="http://emoji.id">emoji.id</a>
        WHERE post_emoji.post_id = <a href="http://post.id">post.id</a>
    ) AS emojis
        FROM post
        JOIN actor_profile ON post.author_id = <a href="https://ryona.agency/objects/79dc69cb-678c-4e51-8d5b-f2418b176fef">actor_profile.id</a>
        WHERE <a href="http://post.id">post.id</a> IN (
            SELECT post.in_reply_to_id
            FROM post WHERE <a href="http://post.id">post.id</a> = ANY($1)
            UNION ALL
            SELECT post.repost_of_id
            FROM post WHERE <a href="http://post.id">post.id</a> = ANY($1)
            UNION ALL
            SELECT post_link.target_id
            FROM post_link WHERE post_link.source_id = ANY($1)
            UNION ALL
            SELECT post_link.target_id
            FROM post_link JOIN post ON (post.repost_of_id = post_link.source_id)
            WHERE <a href="http://post.id">post.id</a> = ANY($1)
        )2023-11-28T17:14:27 tokio_postgres::query [DEBUG] executing statement s15 with parameters: [34127]
2023-11-28T17:14:27 tokio_postgres::query [DEBUG] executing statement s16 with parameters: [34125]
2023-11-28T17:14:27 tokio_postgres::query [DEBUG] executing statement s15 with parameters: [34171]
2023-11-28T17:14:27 tokio_postgres::query [DEBUG] executing statement s15 with parameters: [34172]
2023-11-28T17:14:27 tokio_postgres::query [DEBUG] executing statement s16 with parameters: [34170]
2023-11-28T17:14:27 tokio_postgres::query [DEBUG] executing statement s15 with parameters: [34082]
2023-11-28T17:14:27 tokio_postgres::query [DEBUG] executing statement s15 with parameters: [34434]
2023-11-28T17:14:27 tokio_postgres::query [DEBUG] executing statement s15 with parameters: [34435]
2023-11-28T17:14:27 tokio_postgres::query [DEBUG] executing statement s16 with parameters: [34433]
2023-11-28T17:14:27 tokio_postgres::query [DEBUG] executing statement s22 with parameters: [[]]
2023-11-28T17:14:27 tokio_postgres::prepare [DEBUG] preparing query s23: 
        SELECT post_id
        FROM post_reaction
        WHERE author_id = $1 AND post_id = ANY($2)2023-11-28T17:14:27 tokio_postgres::query [DEBUG] executing statement s23 with parameters: [018bebff-f677-dd27-344d-a5a2528079ae, []]
2023-11-28T17:14:27 tokio_postgres::prepare [DEBUG] preparing query s24: 
        SELECT <a href="http://post.id">post.id</a>
        FROM post
        WHERE <a href="http://post.id">post.id</a> = ANY($2) AND EXISTS (
            SELECT 1 FROM post AS repost
            WHERE repost.author_id = $1 AND repost.repost_of_id = <a href="http://post.id">post.id</a>
        )2023-11-28T17:14:27 tokio_postgres::query [DEBUG] executing statement s24 with parameters: [018bebff-f677-dd27-344d-a5a2528079ae, []]
2023-11-28T17:14:27 actix_web::middleware::logger [INFO] GET /api/v2/search?q=%40anyawnymous%40rawrxd4mden7rmbobaftao3qjyxbrvj4rrooehkqxlqcsdtnnn2hndid.onion HTTP/1.1 : 200 : 127.0.0.1
2023-11-28T17:14:37 tokio_postgres::prepare [DEBUG] preparing query s25: 
        UPDATE background_job
        SET
            job_status = $1,
            updated_at = CURRENT_TIMESTAMP
        WHERE id IN (
            SELECT id
            FROM background_job
            WHERE
                job_type = $2
                AND scheduled_for &lt; CURRENT_TIMESTAMP
                AND (
                    -- queued
                    job_status = $3
                    -- running
                    OR job_status = $1
                    AND updated_at &lt; CURRENT_TIMESTAMP - $5::text::interval
                )
            ORDER BY
                -- queued jobs first
                job_status ASC,
                scheduled_for ASC
            LIMIT $4
        )
        RETURNING background_job
2023-11-28T17:16:13 actix_web::middleware::logger [INFO] GET /api/v2/search?q=%40relay%40http%3A%2F%2Frawrxd4mden7rmbobaftao3qjyxbrvj4rrooehkqxlqcsdtnnn2hndid.onion HTTP/1.1 : 200 : 127.0.0.1
2023-11-28T17:16:13 tokio_postgres::prepare [DEBUG] preparing query s56: 
        SELECT user_account, actor_profile
        FROM oauth_token
        JOIN user_account ON oauth_token.owner_id = <a href="https://ryona.agency/objects/79dc69cb-678c-4e51-8d5b-f2418b176fef">user_account.id</a>
        JOIN actor_profile ON <a href="https://ryona.agency/objects/79dc69cb-678c-4e51-8d5b-f2418b176fef">user_account.id</a> = <a href="https://ryona.agency/objects/79dc69cb-678c-4e51-8d5b-f2418b176fef">actor_profile.id</a>
        WHERE
            oauth_token.token = $1
            AND oauth_token.expires_at &gt; CURRENT_TIMESTAMP2023-11-28T17:16:13 tokio_postgres::query [DEBUG] executing statement s56 with parameters: ["M_SZCjLVgeA_iEeAKZCDyDHNzxI"]
2023-11-28T17:16:13 tokio_postgres::prepare [DEBUG] preparing query s57: 
        SELECT timeline_marker
        FROM timeline_marker
        WHERE user_id = $1 AND timeline = $22023-11-28T17:16:13 tokio_postgres::query [DEBUG] executing statement s57 with parameters: [018bebff-f677-dd27-344d-a5a2528079ae, Notifications]
2023-11-28T17:16:13 actix_web::middleware::logger [INFO] GET /api/v1/markers?timeline%5B%5D=notifications HTTP/1.1 : 200 : 127.0.0.1
<p>Either way I get no results.</p></article><footer><a rel="bookmark" href="https://gnusocial.jp/conversation/2357258#notice-4725937">In conversation</a><time datetime="2023-11-29T22:33:13+09:00" title="Wednesday, 29-Nov-2023 22:33:13 JST">about a year ago</time> <span>from <span><a href="https://ryona.agency/objects/79dc69cb-678c-4e51-8d5b-f2418b176fef" rel="external" title="Sent from ryona.agency via ActivityPub">ryona.agency</a></span></span><a href="https://ryona.agency/objects/79dc69cb-678c-4e51-8d5b-f2418b176fef">permalink</a><h4>Attachments</h4><ol><li><label><a rel="external" href="https://gnusocial.jp/attachment/1897534">Untitled attachment</a></label><br></li><li><label><a rel="external" href="https://gnusocial.jp/attachment/1897535">Untitled attachment</a></label><br></li><li><article><header><div>No result found on File_thumbnail lookup.</div><h5><a href="http://post.id/">Under Construction</a></h5><div></div></header><div></div><footer></footer></article></li><li><label><a rel="external" href="https://gnusocial.jp/attachment/1897537">Untitled attachment</a></label><br></li><li><article><header><div>No result found on File_thumbnail lookup.</div><h5><a href="https://tag.id/">https://tag.id/</a></h5><div></div></header><div></div><footer></footer></article></li><li><label><a rel="external" href="https://gnusocial.jp/attachment/1897539">Untitled attachment</a></label><br></li><li><label><a rel="external" href="https://gnusocial.jp/attachment/1897540">Untitled attachment</a></label><br></li></ol></footer></blockquote>

Corresponding Notice

Embed this notice
alenshore (anonymous6479@ryona.agency)'s status on Wednesday, 29-Nov-2023 22:33:13 JSTalenshore
in reply to
- silverpill
- alenshore
@silverpill Debug info for a follow from an onion address:
2023-11-28T17:14:27 mitra::mastodon_api::search::helpers [WARN] failed to import profile anyawnymous@rawrxd4mden7rmbobaftao3qjyxbrvj4rrooehkqxlqcsdtnnn2hndid.onion: error sending request for url (http://rawrxd4mden7rmbobaftao3qjyxbrvj4rrooehkqxlqcsdtnnn2hndid.onion/.well-known/webfinger?resource=acct%3Aanyawnymous%40rawrxd4mden7rmbobaftao3qjyxbrvj4rrooehkqxlqcsdtnnn2hndid.onion): error trying to connect: dns error: failed to lookup address information: Name does not resolve 2023-11-28T17:14:27 tokio_postgres::prepare [DEBUG] preparing query s22: SELECT post, actor_profile, ARRAY( SELECT media_attachment FROM media_attachment WHERE post_id = post.id ORDER BY media_attachment.created_at ) AS attachments, ARRAY( SELECT actor_profile FROM mention JOIN actor_profile ON mention.profile_id = actor_profile.id WHERE post_id = post.id ) AS mentions, ARRAY( SELECT tag.tag_name FROM tag JOIN post_tag ON post_tag.tag_id = tag.id WHERE post_tag.post_id = post.id ) AS tags, ARRAY( SELECT post_link.target_id FROM post_link WHERE post_link.source_id = post.id ) AS links, ARRAY( SELECT emoji FROM post_emoji JOIN emoji ON post_emoji.emoji_id = emoji.id WHERE post_emoji.post_id = post.id ) AS emojis FROM post JOIN actor_profile ON post.author_id = actor_profile.id WHERE post.id IN ( SELECT post.in_reply_to_id FROM post WHERE post.id = ANY($1) UNION ALL SELECT post.repost_of_id FROM post WHERE post.id = ANY($1) UNION ALL SELECT post_link.target_id FROM post_link WHERE post_link.source_id = ANY($1) UNION ALL SELECT post_link.target_id FROM post_link JOIN post ON (post.repost_of_id = post_link.source_id) WHERE post.id = ANY($1) ) 2023-11-28T17:14:27 tokio_postgres::query [DEBUG] executing statement s15 with parameters: [34127] 2023-11-28T17:14:27 tokio_postgres::query [DEBUG] executing statement s16 with parameters: [34125] 2023-11-28T17:14:27 tokio_postgres::query [DEBUG] executing statement s15 with parameters: [34171] 2023-11-28T17:14:27 tokio_postgres::query [DEBUG] executing statement s15 with parameters: [34172] 2023-11-28T17:14:27 tokio_postgres::query [DEBUG] executing statement s16 with parameters: [34170] 2023-11-28T17:14:27 tokio_postgres::query [DEBUG] executing statement s15 with parameters: [34082] 2023-11-28T17:14:27 tokio_postgres::query [DEBUG] executing statement s15 with parameters: [34434] 2023-11-28T17:14:27 tokio_postgres::query [DEBUG] executing statement s15 with parameters: [34435] 2023-11-28T17:14:27 tokio_postgres::query [DEBUG] executing statement s16 with parameters: [34433] 2023-11-28T17:14:27 tokio_postgres::query [DEBUG] executing statement s22 with parameters: [[]] 2023-11-28T17:14:27 tokio_postgres::prepare [DEBUG] preparing query s23: SELECT post_id FROM post_reaction WHERE author_id = $1 AND post_id = ANY($2) 2023-11-28T17:14:27 tokio_postgres::query [DEBUG] executing statement s23 with parameters: [018bebff-f677-dd27-344d-a5a2528079ae, []] 2023-11-28T17:14:27 tokio_postgres::prepare [DEBUG] preparing query s24: SELECT post.id FROM post WHERE post.id = ANY($2) AND EXISTS ( SELECT 1 FROM post AS repost WHERE repost.author_id = $1 AND repost.repost_of_id = post.id ) 2023-11-28T17:14:27 tokio_postgres::query [DEBUG] executing statement s24 with parameters: [018bebff-f677-dd27-344d-a5a2528079ae, []] 2023-11-28T17:14:27 actix_web::middleware::logger [INFO] GET /api/v2/search?q=%40anyawnymous%40rawrxd4mden7rmbobaftao3qjyxbrvj4rrooehkqxlqcsdtnnn2hndid.onion HTTP/1.1 : 200 : 127.0.0.1 2023-11-28T17:14:37 tokio_postgres::prepare [DEBUG] preparing query s25: UPDATE background_job SET job_status = $1, updated_at = CURRENT_TIMESTAMP WHERE id IN ( SELECT id FROM background_job WHERE job_type = $2 AND scheduled_for < CURRENT_TIMESTAMP AND ( -- queued job_status = $3 -- running OR job_status = $1 AND updated_at < CURRENT_TIMESTAMP - $5::text::interval ) ORDER BY -- queued jobs first job_status ASC, scheduled_for ASC LIMIT $4 ) RETURNING background_job 2023-11-28T17:16:13 actix_web::middleware::logger [INFO] GET /api/v2/search?q=%40relay%40http%3A%2F%2Frawrxd4mden7rmbobaftao3qjyxbrvj4rrooehkqxlqcsdtnnn2hndid.onion HTTP/1.1 : 200 : 127.0.0.1 2023-11-28T17:16:13 tokio_postgres::prepare [DEBUG] preparing query s56: SELECT user_account, actor_profile FROM oauth_token JOIN user_account ON oauth_token.owner_id = user_account.id JOIN actor_profile ON user_account.id = actor_profile.id WHERE oauth_token.token = $1 AND oauth_token.expires_at > CURRENT_TIMESTAMP 2023-11-28T17:16:13 tokio_postgres::query [DEBUG] executing statement s56 with parameters: ["M_SZCjLVgeA_iEeAKZCDyDHNzxI"] 2023-11-28T17:16:13 tokio_postgres::prepare [DEBUG] preparing query s57: SELECT timeline_marker FROM timeline_marker WHERE user_id = $1 AND timeline = $2 2023-11-28T17:16:13 tokio_postgres::query [DEBUG] executing statement s57 with parameters: [018bebff-f677-dd27-344d-a5a2528079ae, Notifications] 2023-11-28T17:16:13 actix_web::middleware::logger [INFO] GET /api/v1/markers?timeline%5B%5D=notifications HTTP/1.1 : 200 : 127.0.0.1
Either way I get no results.
In conversationabout a year ago from ryona.agencypermalink
Attachments
1. Untitled attachment
2. Untitled attachment
3. No result found on File_thumbnail lookup.
  Under Construction
4. Untitled attachment
5. No result found on File_thumbnail lookup.
  https://tag.id/
6. Untitled attachment
7. Untitled attachment

Public

Embed Notice

HTML Code

Corresponding Notice