Tio

tio@social.trom.tf

A bunch of atoms that are curious about the world, but furious about the society. We should help all humans to have a decent life without any strings attached, so that we can understand us, the atoms, and the rest of the universe. And create a smarter and saner society.

Since 2005 I make documentaries, write books, and enable many trade-free platforms for everyone.

Network posts

Earth

@tio:matrix.org

https://www.tiotrom.com/

Tio

4 years ago

Tio
4 years ago

!Friendica Admins The network tab shows a 502 Nginx error at times after updating to the latest Friendica stable. Weird. Everything else works 100% fine. Including the network streams of the local timeline, global, or groups that I have. Also, for other users works, for a few does not. Maybe it is a post in the network stream that can mess with the entire thing? I looked at the logs and see some stuff like:

DB Error: Unknown column 'network-thread-view.uri-id' in 'where clause' 
DBA::selectToArray, Network::getItems, Network::rawContent, call_user_func, Module::run, App::runFrontend 
SELECT * FROM `network-item-view` WHERE (`unseen` = 1 AND `gravity` = 0 AND `uid` = 2 AND ((`contact-id` = '7704') OR EXISTS(SELECT `uri-id` FROM `post-user-view` WHERE `post-user-view`.`parent-uri-id` = `network-thread-view`.`uri-id` AND (`contact-id` = '7704' AND `gravity` = 3 AND `vid` = 7 AND `uid` = 2)))) ORDER BY `received` DESC LIMIT 100

DB Error: Unknown column 'network-thread-view.uri-id' in 'where clause' 
DBA::selectToArray, Network::getItems, Network::rawContent, call_user_func, Module::run, App::runFrontend 
SELECT * FROM `network-item-view` WHERE (`unseen` = 1 AND `gravity` = 0 AND `uid` = 2 AND ((`contact-id` = '7704') OR EXISTS(SELECT `uri-id` FROM `post-user-view` WHERE `post-user-view`.`parent-uri-id` = `network-thread-view`.`uri-id` AND (`contact-id` = '7704' AND `gravity` = 3 AND `vid` = 7 AND `uid` = 2)))) ORDER BY `received` DESC LIMIT 100

Or:

DB Error: Data too long for column 'url' at row 1
Media::insert, Processor::storeAttachmentAsMedia, Processor::storeAttachments, Processor::updateItem, Receiver::processActivity, Receiver::processInbox, Inbox::rawContent, call_user_func 

INSERT INTO `post-media` (`uri-id`, `type`, `url`, `mimetype`, `height`) VALUES (1772025, 16, 'magnet:?xs=https%3A%2F%2Fvideo.blast-info.fr%2Flazy-static%2Ftorrents%2F5db5a5a7-932f-449e-9163-2a0066acdca1-720-hls.torrent&amp;xt=urn:btih:ffcb895c28be069315e5ca9b7dfb6c7481e8a5be&amp;dn=CRISE+FINANCI%C3%88RE+%3A+VA-T-ON+PERDRE+NOTRE+ARGENT+SI+LES+BANQUES+S\'EFFONDRENT+%3F&amp;tr=https%3A%2F%2Fvideo.blast-info.fr%2Ftracker%2Fannounce&amp;tr=wss%3A%2F%2Fvideo.blast-info.fr%3A443%2Ftracker%2Fsocket&amp;ws=https%3A%2F%2Fvideo.blast-info.fr%2Fstatic%2Fstreaming-playlists%2Fhls%2F5db5a5a7-932f-449e-9163-2a0066acdca1%2F5db5a5a7-932f-449e-9163-2a0066acdca1-720-fragmented.mp4', 'application/x-bittorrent;x-scheme-handler/magnet', 720) ON DUPLICATE KEY UPDATE `uri-id` = 1772025, `type` = 16, `url` = 'magnet:?xs=https%3A%2F%2Fvideo.blast-info.fr%2Flazy-static%2Ftorrents%2F5db5a5a7-932f-449e-9163-2a0066acdca1-720-hls.torrent&amp;xt=urn:btih:ffcb895c28be069315e5ca9b7dfb6c7481e8a5be&amp;dn=CRISE+FINANCI%C3%88RE+%3A+VA-T-ON+PERDRE+NOTRE+ARGENT+SI+LES+BANQUES+S\'EFFONDRENT+%3F&amp;tr=https%3A%2F%2Fvideo.blast-info.fr%2Ftracker%2Fannounce&amp;tr=wss%3A%2F%2Fvideo.blast-info.fr%3A443%2Ftracker%2Fsocket&amp;ws=https%3A%2F%2Fvideo.blast-info.fr%2Fstatic%2Fstreaming-playlists%2Fhls%2F5db5a5a7-932f-449e-9163-2a0066acdca1%2F5db5a5a7-932f-449e-9163-2a0066acdca1-720-fragmented.mp4', `mimetype` = 'application/x-bittorrent;x-scheme-handler/magnet', `height` = 720

Or:

home timeline is no array

twitter_sync_run

Any ideas? Didn't see this behavior before.

!Friendica Admins

reshared this

in reply to Tio

utzer [Friendica]

in reply to Tio 4 years ago from Fediverse

@Tio your update did not finish. I think the command is bin/console postupdate to execute the remaining things, but also @Michael Vogel told me before to never run this.
See your version of postupdate here: social.trom.tf/friendica

compared to my server here: social.yl.ms/friendica

@Michael 🇺🇦 @Tio

Tio likes this.

in reply to utzer [Friendica]

Tio

in reply to utzer [Friendica] 4 years ago

Oh thats helpful to know. So how to fix it if @Michael Vogel says that command is not ok to run? :D

@Michael 🇺🇦

in reply to Tio

utzer [Friendica]

in reply to Tio 4 years ago from Fediverse

@Tio I think he or someone else will know. When did you update? It sometimes takes a few days to update.

@Tio

in reply to utzer [Friendica]

Tio

in reply to utzer [Friendica] 4 years ago

A few days? wow. I updated yesterday. How do I know if it is still running and such?

Unknown parent

utzer [Friendica]

Unknown parent 4 years ago from Fediverse

@Michael Vogel @Tio and how can he check for the running postupdate?

@Michael 🇺🇦 @Tio

Unknown parent

Tio

Unknown parent 4 years ago

So could the 502 nginx error be due to an impartial upgrading like @utzer was saying?

@utzer [Friendica]

Unknown parent

Tio

Unknown parent 4 years ago

ops...you have any idea why this may happen? or what should i do to debug?

in reply to Tio

Tio

in reply to Tio 4 years ago

Maybe I'll open an issue via github for this. It is a weird one. Our server copes well with everything so must be an issue with the upgrade/config.

in reply to Tio

Tio

in reply to Tio 4 years ago

Does this mean my friendica is not fully updated?

in reply to Tio

Tio

in reply to Tio 4 years ago

Ok so the 502 nginx error can happen on other pages too, like my profile social.trom.tf/profile/tio . The weird part is that it throws that error while I am logged in but I can access the same url via incognito (public).

I saw this error before and what fixed it was to change some nginx settings such as

pm = ondemand
pm.max_children = 50
pm.max_requests = 100

But after the latest stable update these settings seem to not fix it. Anyone has any clue?

in reply to Tio

aaron

in reply to Tio 4 years ago

I do experience that issue too, for example if I click on "community". However, when I change my account (I have multiple ones), then I can access the "community" tab. Very weird.

in reply to aaron

Tio

in reply to aaron 4 years ago

ahaammm.....so this might be related to the yunohost package then!? we need to investigate further. Another thing I noticed: the Network tab might not work but then it may work again. But my profile page once it stopped working it didn not work again. I suspect is because the network tab shows different posts while my homepage shows the same posts. What if some posts are messing things up? Maybe long ones?

in reply to Tio

utzer [Friendica]

in reply to Tio 4 years ago from Fediverse

@Tio @aaron is there a proxy running in front of the Friendica webserver? 502 is bad gateway, my proxy throws that when the Apache behind is not running.

en.wikipedia.org/wiki/List_of_…

@Tio @aaron

in reply to utzer [Friendica]

Tio

in reply to utzer [Friendica] 4 years ago

But why would happen now after the latest friendica update and not before? And how to check if a proxy is running in front of Friendica?

in reply to Tio

utzer [Friendica]

in reply to Tio 4 years ago from Fediverse

@Tio @aaron well if it is a proxy, then the webserver behind would be the one stopped, maybe it restarts. Check your logs, journalctl for the time when you geht the 502. Maybe "just" overloaded and not taking new connections anymore.

@Tio @aaron

Unknown parent

utzer [Friendica]

Unknown parent 4 years ago from Fediverse

@Hans Wolters @Tio oh interesting. Surely wrong error code.

@Tio @Hans Wolters

in reply to Tio

Tio

in reply to Tio 4 years ago

Here's how maybe we made it work social.trom.tf/display/dbc8dc4…

utzer [Friendica] likes this.

in reply to Tio

utzer [Friendica]

in reply to Tio 4 years ago from Fediverse

@Tio cool, thanks for the feedback.

Would be cool if the Yunohost Friendica app could be improved, I would certainly love to see that!
Would be great if more people could just get a Pi4 and run Friendica from there home. Thanks for the effort!

@Tio

like this

Unknown parent

Tio

Unknown parent 4 years ago

Yah as said in the post lets see....

⇧

Tio 4 years ago •

Tio
4 years ago