Jools on Nostr: First of all, sorry for my English, I use a translator. I am using Friendica version ...
First of all, sorry for my English, I use a translator.
I am using Friendica version 2024.12, database version is 1576/1576 and the post update version is 1550/1550.
I have changed my storage in Friendica from “Database” to “Filesystem”.
I have selected /var/friendica_storage as the path -> drwxr-xr-x 258 www-data www-data 4096 2 Mar 15:49 /var/friendica_storage
This setting was also applied:
sudo -u www-data bin/console storage list:
Sel | Name
-----------------------
* | Filesystem
| Database
Then I execute the following:
sudo -u www-data bin/console storage move
[2025-03-02 14:49:46] Moved 5000 files
[2025-03-02 14:49:50] Moved 5000 files
[2025-03-02 14:49:55] Moved 5000 files
[2025-03-02 14:49:59] Moved 5000 files
[2025-03-02 14:50:04] Moved 5000 files
[2025-03-02 14:50:08] Moved 5000 files
[2025-03-02 14:50:13] Moved 5000 files
[2025-03-02 14:50:18] Moved 5000 files
[2025-03-02 14:50:22] Moved 5000 files
[2025-03-02 14:50:27] Moved 5000 files
[2025-03-02 14:50:33] Moved 5000 files
[2025-03-02 14:50:38] Moved 5000 files
[2025-03-02 14:50:43] Moved 5000 files
[2025-03-02 14:50:49] Moved 5000 files
[2025-03-02 14:50:54] Moved 5000 files
[2025-03-02 14:50:59] Moved 5000 files
[2025-03-02 14:51:04] Moved 5000 files
[2025-03-02 14:51:10] Moved 5000 files
[2025-03-02 14:51:16] Moved 5000 files
[2025-03-02 14:51:22] Moved 5000 files
[2025-03-02 14:51:27] Moved 5000 files
[2025-03-02 14:51:32] Moved 5000 files
[2025-03-02 14:51:37] Moved 5000 files
[2025-03-02 14:51:44] Moved 5000 files
[2025-03-02 14:51:49] Moved 5000 files
[2025-03-02 14:51:54] Moved 5000 files
[2025-03-02 14:52:00] Moved 5000 files
[2025-03-02 14:52:02] Moved 2180 files
[2025-03-02 14:52:03] Moved 137180 files total
[Error] Friendica\Console\Storage::doExecute(): Return value must be of type int, null returned
It ends with this error message. But the files are present in the /var/friendica_storage folder.
The query in MariaDB shows that the images are still stored in the database:
MariaDB [xxxxxxxxxxxx]> SELECT COUNT(*) FROM photo WHERE data IS NOT NULL;
+----------+
| COUNT(*) |
+----------+
| 137228 |
+----------+
1 row in set (0,419 sec)
MariaDB [xxxxxxxxxxxx]> SELECT COUNT(*) FROM photo WHERE data IS NOT NULL;
+----------+
| COUNT(*) |
+----------+
| 137246 |
+----------+
1 row in set (0,39 sec)
But probably also in /var/friendica_storage, because this is getting bigger.
So the images are now saved simultaneously in the database AND in the /var/friendica_storage folder, including new images!
I have now tried this process twice and both times the error occurred. I restored my database backup.
What have I done wrong, what can I improve or change?
#Friendica, #Help
Published at
2025-03-02 15:30:26Event JSON
{
"id": "bd747396c732f73f0362732c6fcf32d5afd5f29253857df74e80c7ebd4a8c3d2",
"pubkey": "8ad95b24c2aa43473abc4f30abbab2364280b2ead8b5f28b4b614c12a63897c8",
"created_at": 1740929426,
"kind": 1,
"tags": [
[
"p",
"15b7758904cd6ec9c4d780aed7cca01019b61be45945dea8a68e2d2322a45ecd",
"wss://relay.mostr.pub"
],
[
"p",
"08e210217b9bf22ce53ebf1e27b5ed8dc9db28dc1d82f1f4575eee7b3a76743a",
"wss://relay.mostr.pub"
],
[
"t",
"friendica"
],
[
"t",
"help"
],
[
"proxy",
"https://missocial.de/objects/7b2a4035-9667-c479-9290-a0e981606476",
"activitypub"
]
],
"content": "First of all, sorry for my English, I use a translator.\n\nI am using Friendica version 2024.12, database version is 1576/1576 and the post update version is 1550/1550.\n\n\nI have changed my storage in Friendica from “Database” to “Filesystem”.\n\nI have selected /var/friendica_storage as the path -\u003e drwxr-xr-x 258 www-data www-data 4096 2 Mar 15:49 /var/friendica_storage\n\nThis setting was also applied:\n\nsudo -u www-data bin/console storage list:\n Sel | Name\n-----------------------\n * | Filesystem\n | Database\n\n\nThen I execute the following:\n\nsudo -u www-data bin/console storage move\n[2025-03-02 14:49:46] Moved 5000 files\n[2025-03-02 14:49:50] Moved 5000 files\n[2025-03-02 14:49:55] Moved 5000 files\n[2025-03-02 14:49:59] Moved 5000 files\n[2025-03-02 14:50:04] Moved 5000 files\n[2025-03-02 14:50:08] Moved 5000 files\n[2025-03-02 14:50:13] Moved 5000 files\n[2025-03-02 14:50:18] Moved 5000 files\n[2025-03-02 14:50:22] Moved 5000 files\n[2025-03-02 14:50:27] Moved 5000 files\n[2025-03-02 14:50:33] Moved 5000 files\n[2025-03-02 14:50:38] Moved 5000 files\n[2025-03-02 14:50:43] Moved 5000 files\n[2025-03-02 14:50:49] Moved 5000 files\n[2025-03-02 14:50:54] Moved 5000 files\n[2025-03-02 14:50:59] Moved 5000 files\n[2025-03-02 14:51:04] Moved 5000 files\n[2025-03-02 14:51:10] Moved 5000 files\n[2025-03-02 14:51:16] Moved 5000 files\n[2025-03-02 14:51:22] Moved 5000 files\n[2025-03-02 14:51:27] Moved 5000 files\n[2025-03-02 14:51:32] Moved 5000 files\n[2025-03-02 14:51:37] Moved 5000 files\n[2025-03-02 14:51:44] Moved 5000 files\n[2025-03-02 14:51:49] Moved 5000 files\n[2025-03-02 14:51:54] Moved 5000 files\n[2025-03-02 14:52:00] Moved 5000 files\n[2025-03-02 14:52:02] Moved 2180 files\n[2025-03-02 14:52:03] Moved 137180 files total\n[Error] Friendica\\Console\\Storage::doExecute(): Return value must be of type int, null returned\n\n\nIt ends with this error message. But the files are present in the /var/friendica_storage folder.\n\n\nThe query in MariaDB shows that the images are still stored in the database:\n\nMariaDB [xxxxxxxxxxxx]\u003e SELECT COUNT(*) FROM photo WHERE data IS NOT NULL;\n+----------+\n| COUNT(*) |\n+----------+\n| 137228 |\n+----------+\n1 row in set (0,419 sec)\n\nMariaDB [xxxxxxxxxxxx]\u003e SELECT COUNT(*) FROM photo WHERE data IS NOT NULL;\n+----------+\n| COUNT(*) |\n+----------+\n| 137246 |\n+----------+\n1 row in set (0,39 sec)\n\n\nBut probably also in /var/friendica_storage, because this is getting bigger.\n\nSo the images are now saved simultaneously in the database AND in the /var/friendica_storage folder, including new images!\n\n\nI have now tried this process twice and both times the error occurred. I restored my database backup.\n\nWhat have I done wrong, what can I improve or change?\n\n\n#Friendica, #Help",
"sig": "6ddce509464f7309fff83829537cc60d72413f892c8e99f79f133aac4bd81ac7e77ae6656231aa03af8ab39cd76f21076a1412549a95ed6ba9297d30c764c689"
}