Skip Navigation

User banner
Posts
13
Comments
262
Joined
2 yr. ago

  • FYI, you are setting your comments to language "Afaraf" to me...

    EDIT: it is set for the entire Post?

  • See my newer comment, I may have tried a community of the same name on a different Instance. I am NOT getting "Subscribed", but instead stuck "Pending" to lemmit.online

  • Ok, there are multiple communities by that name on different servers.

    From lemmy.ml using the native web application on a desktop browser, it is showing me

    So now we are back to suggesting that these two Instance servers are not correctly talking to each other if 'subscribe' will not complete and stays stuck 'pending'.

    EDIT: now I can get it to subscribe, past "Pending". I have no idea what is gong on within these two servers, but I too see no content flowing.

  • I don't think it is normal behavior for every new local user to be sent out to the current 1500+ lemmy instances out there.

    I think the process of cloning your profile is more like: 1) you post or comment in a community, 2) that specific remote instance has to have a subscriber to that community, 3) once the post or comment comes to that specific remote instance, it will grab your person profile from the home-instance of you as a person.

    If anyone knows otherwise, please chime in. I'll work on adding testing code to lemmy_server to document the behaviors and their evolution.

    EDIT:

    It doesn’t show my avatar, banner or bio.

    So the profile is there, but not showing avatar. Ok, I saw this a couple months ago when I was creating accounts on various Lemmy servers for testing. It seems to me there is a high amount of replication delay in EDIT to the profile. Try editing your bio to ass a word or something, see if it goes out. I found it was taking days.

  • I was able to join that community from lemmy.ml, so the join/subscribe connection is working.

  • There are always underlying assumptions made by people who support industrial-age work for every human being. Things like... 9 to 5 work schedule (or longer) being compatible with their genetics, year round - winter or summer. Paperwork appreciation, having to fill out job applications often with high amounts of redundancy in the questions and formats. Red tape for getting paychecks and accounting. Dress codes and even uniform requirements. Businessmen preferences for rectangle and high-rise buildings that few other animals from Earth seem to construct or use to build loyal followers.

    With generic randomness alone, I suspect that 20%+ of a population on Pale Blue Dot never fit in with what their local society considers perfectly "normal" conformity and biological needs in industrialized world.

  • Same thing I've seen past 60 days with Lemmy. The major sites throwing massive hardware. "Wow, Lemmy now deletes a single post in 7 seconds".

  • You are speaking as someone who is home, transportation, and water secure. Someone with a marginally less stable life

    Exactly. I'm in Arizona right now and it's incredibly hot with no break from the heat. Equipment overheating is a real issue, my development computers and phones have all had problems.

  •  
        
       --> crates/db_schema/src/aggregates/site_aggregates.rs:12:35
        |
    12  |     site_aggregates::dsl::site_id.eq(1).first::<Self>(conn).await
        |                                   ^^ `schema::site_aggregates::columns::site_id` is not an iterator
        |
       ::: crates/db_schema/src/schema.rs:817:9
        |
    817 |         site_id -> Int4,
        |         -------
        |         |
        |         method `eq` not found for this struct
        |         doesn't satisfy `_: Iterator`
        |
        = note: the following trait bounds were not satisfied:
                `schema::site_aggregates::columns::site_id: Iterator`
                which is required by `&mut schema::site_aggregates::columns::site_id: Iterator`
    
    
      
  •  
        
    site_aggregates::table.filter(site_aggregates::site_id.eq(1)).first::<Self>(conn).await
                                                           ^^ `schema::site_aggregates::columns::site_id` is not an iterator
    
    
    
      
  • FYI, some major PostgreSQL optimization has been found with the stored procedures: https://github.com/LemmyNet/lemmy/pull/3704

    This should really help with Beehaw and other sites that have local users creating posts and comments, as the runaway site_aggregates queries were creating unnecessary writes.

  • I imagine they have full offsite backups they can pull data from. That's why we have documentary shows like Mr. Robot, never forget 5/9!

  • I linked your post on !lemmy_helper@lemmy.ml - as I started out building a list of direct PostgreSQL queries with that webapp last month. Thank you for sharing.

  • I now see that the stated intent is to retain anonymized comments as Reddit does

    You cite a conversation from November 4, 2022.

    A Febuary 6, 2023 comment from developers https://github.com/LemmyNet/lemmy/issues/2624#issuecomment-1419559651 says "The correct way privacy-wise, is to delete your account through your profile settings, which overwrites all your content to remove any info."

    The intention is to routinely purge all content of users who delete their account. In fact, there are open GitHub issues about serious performance problems in executing this code, even with a relatively small amount of content. Developers in the past 2 days have commented on this and made no mention of intention to retain content.

  • This is unfortunately only possible if you still own the original domain. Think about it this way: if you could migrate domains without proving you own the original, then what’s stopping a bad actor from migrating any domain they want?

    I'm suggesting a whitelist, that each peer has to put in a substitute list of vlemmy.ml==vlemmy.ml to re-federate.

    Much like Reddit, comments continue to exist even when the author deletes their account.

    That is NOT how the testing code of lemmy_server tests things, nor how the GitHub front page advertises Lemmy.