Skip to main content

Search

Items tagged with: mysql


it's rather offotpic to mention that we still fight with a bunch of legacy databases ran on #mysql which had case sensitive table names, except, they are only c.s. in the filesystem but not according to the server code so various table-level functions may or may not work, may end up with file not found or file already exists. It is a clusterfuck.


Umzug meiner Friendica-Instanz



Question for the #MySQL / #MariaDB buffs, I have three tables defined thus:
CREATE TABLE IF NOT EXISTS `user` (
	`uid` mediumint unsigned NOT NULL auto_increment COMMENT 'sequential ID',
	...
	 PRIMARY KEY(`uid`)
);
CREATE TABLE IF NOT EXISTS `gserver` (
	`id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
	...
	 PRIMARY KEY(`id`)
);

CREATE TABLE IF NOT EXISTS `user-gserver` (
	`uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner User id',
	`gsid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Gserver id',
	...
	PRIMARY KEY(`uid`,`gsid`),
	FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE,
	FOREIGN KEY (`gsid`) REFERENCES `gserver` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE
);

Running the last query triggers the error Foreign key constraint is incorrectly formed. Is there no way to reference multiple tables in foreign keys out of a compound primary key?

#SQL #Database #DBA


"Error: #MySQL server has gone away"

Look... I don't blame them.

#DevLife



#Friendica needs new contributors!

I'm not used to do this, but with the large influx of new users and node admins recently coming from #Twitter, our small team is now behind the curve for handling support requests, bug reports and bring about much-needed features.

The project is built on a #PHP / #MySQL platform, but we also need people to be able to assist others just using the software to give developers some space.

If you're willing and able to help, please follow @Friendica Support and the project on Github: https://github.com/friendica/friendica

Thank you!


Hello !Friendica Support,
anyone any idea what this messages in journalctl mean? I got lots of these before my server crashed and have no Idea what this is.

Mai 28 03:10:26 friendica mariadbd[553]: 2021-05-28  3:10:26 0 [Warning] InnoDB: A long semaphore wait:
Mai 28 03:10:26 friendica mariadbd[553]: --Thread 139676422764096 has waited at row0upd.cc line 179 for 465.00 seconds the semaphore:
Mai 28 03:10:26 friendica mariadbd[553]: S-lock on RW-latch at 0x55a2a8136178 created in file dict0dict.cc line 1041
Mai 28 03:10:26 friendica mariadbd[553]: a writer (thread id 139674262697536) has reserved it in mode  wait exclusive
Mai 28 03:10:26 friendica mariadbd[553]: number of readers 1, waiters flag 1, lock_word: ffffffff
Mai 28 03:10:26 friendica mariadbd[553]: Last time write locked in file dict0stats.cc line 2487


I guess something was wrong with either MariaDB or the VM itself that cause long operation times on the database which led to lots of long running locks. But what do I do with this?

#Friendica #MariaDB #Mysql #Linux #Semaphore


Um 12h gibt es auf dem #CLT2021 heute (14. März) einen Vortrag zur Best Praxis mit #MySQL. Vielleicht ist das ja was für die ein oder andere Person hier im Forum.
!Friendica Admins



So something can't be right here. Since something else is written here. And I can see that myself in my instance under Friendica. Thanks anyway for the information. Stay healthy. But this wasn't right.

@helpers
I tried installing #friendica from #yunohost. But the #ldap authenticate don't work any more. Is there some changes done to the addon?
Secondly the latest release has made the app very sluggish. Is there some settings that needs to be changed in #mysql while installation?
Can friendica be installed with #Postgres ?


@helpers
I tried installing #friendica from #yunohost. But the #ldap authenticate don't work any more. Is there some changes done to the addon?
Secondly the latest release has made the app very sluggish. Is there some settings that needs to be changed in #mysql while installation?
Can friendica be installed with #Postgres ?


I am am running a #mysql optimize, usually the output looks like this:

ylms_friendica.item-activity
note     : Table does not support optimize, doing recreate + analyze instead
status   : OK


But for one table it returned this:

ylms_friendica.item-content
note     : Table does not support optimize, doing recreate + analyze instead
error    : Duplicate entry '' for key 'uri-plink-hash'
status   : Operation failed


Should I worry about that?

!Friendica Support