Unable to delete a Dispora connection

Anmol Sharma

Wed, 13 Jun 2018 08:48:34 -0700

!Hubzilla Support Forum
Hi
I have a connection from Diaspora which I am unable to delete. The page keeps on loading forever till it gives 500 error on pressing the delete button. I am getting the feeds from this channel but the connection shows the red minus sign.
How can I force delete it ? And what to see in the logs for the errors?

Diaspora Hubzilla

show all 37 comments

Anmol Sharma

Wed, 13 Jun 2018 08:55:05 -0700

The Dispora connection has just changed the name few days ago.

Anmol Sharma

Wed, 13 Jun 2018 09:19:23 -0700

you know? your channel has a problem: If I click in your name ( in this post) I do not get a good thing...mmm

What type of strange things?

Anmol Sharma

Wed, 13 Jun 2018 09:23:58 -0700

@giac hellvecio
Don't you get redirected to my page?

NullSpaceOddity

Wed, 13 Jun 2018 10:16:13 -0700

I get "Requested channel is not available"

Anmol Sharma

Wed, 13 Jun 2018 10:44:23 -0700

@NullSpaceOddity
Do you know the reason for that?

Anmol Sharma

Thu, 14 Jun 2018 13:19:14 -0700

@giac hellvecio
Don't you get redirected to my page?

@giac hellvecio
I guess, you forgot to tell me what do you see?

Anmol Sharma

Thu, 14 Jun 2018 13:23:44 -0700

Requested channel is not available..too

But can you see my post on your wall/post page?

Anmol Sharma

Thu, 14 Jun 2018 13:31:51 -0700

if you are using a MtBkOHlCLAzK-2MNeZtJL_4efHrwSQpcmNmRUxJu05cld8Cx8pRn0GcjWrfD-qi12bjo2qCdZ4XYTPQt0Rdqng broken/invalid than you have and will have problem in the zot planet I suppose

But why its broken?

Anmol Sharma

Thu, 14 Jun 2018 13:33:23 -0700

Can you delete me and add me again? I am going to do same.

giac hellvecio

Thu, 14 Jun 2018 13:39:23 -0700

but, this does not resolve your Unable to delete a Dispora connection, right?

do you still have this problem? or now is ok?

Anmol Sharma

Thu, 14 Jun 2018 13:42:08 -0700

I have this problem with only 2 connection. One dispora channel and other friendica help page. I am able to add and delete the other channels.

Anmol Sharma

Thu, 14 Jun 2018 13:42:32 -0700

I am not able to delete helpers@forum.friendi.ca (friendica instance too).

Anmol Sharma

Thu, 14 Jun 2018 13:53:12 -0700 last edited: Thu, 14 Jun 2018 13:57:32 -0700

And one of my mastodon connection is always added as gnu social and all other mastodon as ActivityPub.

Edit: I was entering the username@domain.tld for mastodon which was being added as gnu social and was not working. When I added domain.tld/@username it was added as ActivityPub and is working now.

giac hellvecio

Thu, 14 Jun 2018 13:59:47 -0700

One dispora channel and other friendica help page...helpers@forum.friendi.ca

and what about others OLD diaspora/friendica connections?

Anmol Sharma

Thu, 14 Jun 2018 14:05:23 -0700

and what about others OLD diaspora/friendica connections?

I can delete all other channels. Only atomjack@diasp.org ( Diaspora) and helpers@forum.friendi.ca (Friendica) can't be deleted.

Anmol Sharma

Thu, 14 Jun 2018 14:07:40 -0700

The error is

pod.datamol.org is currently unable to handle this request.
HTTP ERROR 500

giac hellvecio

Thu, 14 Jun 2018 14:18:23 -0700

perhaps the fact of the MtBkOHlCLAzK-2MNeZtJL_4efHrwSQpcmNmRUxJu05cld8Cx8pRn0GcjWrfD-qi12bjo2qCdZ4XYTPQt0Rdqng with the difficulty in eliminating some diaspora protocol connections has nothing to do with it.

...in any case your MtBkOHlCLAzK-2MNeZtJL_4efHrwSQpcmNmRUxJu05cld8Cx8pRn0GcjWrfD-qi12bjo2qCdZ4XYTPQt0Rdqng is strange apparently because of "Requested channel is not available"

Anmol Sharma

Thu, 14 Jun 2018 14:44:56 -0700

in any case your MtBkOHlCLAzK-2MNeZtJL_4efHrwSQpcmNmRUxJu05cld8Cx8pRn0GcjWrfD-qi12bjo2qCdZ4XYTPQt0Rdqng is strange apparently because of "Requested channel is not available"

When do you get "Requested channel is not available" ? Are you able to remote login to my instance ?

giac hellvecio

Thu, 14 Jun 2018 14:54:33 -0700

if I cut this &f=&zid=giacotoktan%40elsmussols.org&owt=.... part I can see your page/channel

giac hellvecio

Thu, 14 Jun 2018 15:04:59 -0700

remote authentication , the second try, works.

now I can enter and see you without problem...was just a problem of authentication ;)

giac hellvecio

Thu, 14 Jun 2018 15:09:02 -0700

but that ""Requested channel is not available"" message before the 'remote auth' is still strange and disturbing

Anmol Sharma

Thu, 14 Jun 2018 15:19:25 -0700

but that ""Requested channel is not available"" message before the 'remote auth' is still strange and disturbing

Are you sure this behavior is not the default behavior for all other channels which you have not remotely accessed?

giac hellvecio

Thu, 14 Jun 2018 15:28:18 -0700

default behavior or not is still a strange and disturbing message ;)

giac hellvecio

Thu, 14 Jun 2018 15:36:06 -0700

you have 2 ways to exclude a connection, have you tried both?

giac hellvecio

Thu, 14 Jun 2018 16:40:42 -0700

just another assumption:
to delete those 2 connections ( connections with a lot of posts...............................................) you need more memory.
Can you increase memory for hubzilla on your server/machine?

Hubzilla not just delete a connections but also all the posts of that connection.

Anmol Sharma

Thu, 14 Jun 2018 16:52:54 -0700

you need more memory.
Can you increase memory for hubzilla on your server/machine?

How much memory I should increase ?

giac hellvecio

Thu, 14 Jun 2018 17:06:22 -0700 last edited: Thu, 14 Jun 2018 17:06:57 -0700

I don't know this..sorry
, but you can increase, delete connections, and return to normal after ;)

Anmol Sharma

Fri, 15 Jun 2018 04:44:26 -0700

, but you can increase, delete connections, and return to normal after ;)

I tired it, but its not working. I think I will need to remove it from the database. Can you tell me what should be removed in the database?

giac hellvecio

Fri, 15 Jun 2018 06:18:46 -0700

I'm not expert in this, but look in my lately posts, there is some good comment from Mike I think that can help.

Just curious, can you delete posts of these connections? Did you try to delete some post?

Anmol Sharma

Fri, 15 Jun 2018 07:51:23 -0700

Just curious, can you delete posts of these connections? Did you try to delete some post?

Yes I can delete there post. Can you provide me the posts? You will know better what to search on your page.

giac hellvecio

Fri, 15 Jun 2018 09:22:27 -0700

however, they are only indications, because in that case the question was to eliminate an accont from the hub, an account with a lot of connections.

You should ask this to others.

But how much memory did you give "hubzilla" to do the operation? Maybe it was not enough....

giac hellvecio

Fri, 15 Jun 2018 09:27:02 -0700

there are situations of page errors in hubzilla, sometimes the classic blank and empty page, where the main culprit is an "exhaustion" of memory, so it needs more memory, obviously only some issues, maybe your case is different.
You should turn on the LOG system, try deleting the contact, and post the result of the LOG to/for people like MIKE or other good devs and administrators.

Anmol Sharma

Fri, 15 Jun 2018 09:33:49 -0700

But how much memory did you give "hubzilla" to do the operation? Maybe it was not enough....

I tried with 256M. I think its more then enough?

You should turn on the LOG system, try deleting the contact, and post the result of the LOG to/for people like MIKE or other good devs and administrators.

I have log enabled. Lets see if I can find some error in the logs.

giac hellvecio

Fri, 15 Jun 2018 09:40:08 -0700

256M? I think needs more...

Anmol Sharma

Fri, 15 Jun 2018 12:18:41 -0700

In logs I see no error. Only a line

connections.php:347:contact_remove: removing contact 7 for channel 2

Anmol Sharma

Fri, 15 Jun 2018 12:19:23 -0700

256M? I think needs more...

How value should I do?

Mike Macgirvin

Fri, 15 Jun 2018 16:44:08 -0700

Somebody else had a problem deleting connections recently, running out of memory. There's only one query that could cause a problem, where we check if a post was 'filed' by you, but apparently this can exhaust memory for connections who add lots of tags to their posts and sites that rarely or never expire their connection's posts. I don't know what to tell you except I've just done some work to improve the efficiency of that query (should land in Hubzilla dev in a couple of days). Otherwise raise memory as high as you can to delete the connection and then put it back to whatever you had it originally. You just need the process to survive this one tag query.