Database Queue - the simplest queue, even for shared hosting

luceos

peopleinside I don't think there's an interface for that yet. But you can find it in the database under failed_tasks I think.

peopleinside

luceos thanks.
flmaqueue_failed_jobs

I found the records and those seems to be old by February 2024 so maybe... the plugin queue still showing me old things already resolved. I will delete this from the database.

A UI for that will be useful and also a way to clean errors 🙂

93ben

I don't know what is happening but every action (no matter if it's updating, installing or removing/deleting extensions) I try to do results in giving this error...

Cause
Unknown
Composer Command
$ composer
Output
Flarum\ExtensionManager\Job\ComposerCommandJob has been attempted too many times or run too long. The job may have previously timed out.

I have cron set up right as it's been sending me emails with the info of the jobs but for whatever reason the script can't successfully add the extension.

BrodyStone21

luceos Go into your hosting control panel and set up the following task to run every minute:

What does this mean? Like in the administration section, or my web server control panel? I don't understand what exactly I'm supposed to do here.

Also, when would you say a community becomes a "large" community? Ie, when should I switch from DB to Redis queue?

EDIT: Nevermind, I set up a cron job. I don't know how to test that it's working though, is there a way?

Also, what are the best settings for the extension itself?

BrodyStone21

@luceos I'm having issues and I don't know what's causing them. I presume my cron job isn't running correctly or something. It keeps showing inactive and jobs don't move from pending.

Running php flarum schedule:run works to resolve it, and it shows "active" on the dashboard, but obviously manually running it kind of defeats the purpose.

Here is the cron job I have set up in cPanel.

And here it is with crontab -e

ernestdefoe

BrodyStone21 change the 1 to a * and see what happens.

luceos

ernestdefoe good catch, the scheduler needs to run every minute using 5 *. Using 1 will only make it run at 1 minute past each hour.

BrodyStone21

ernestdefoe

That's what I had previously, as I had actually set up using crontab -e, but the same issue occured, so I deleted it, and set it up with cPanel. cPanel had no way to use * for the minute, unless I'm missing something?

It appears to be working now. Which leads me to believe I had only included four * and not five.

I'm going to let it run for a while, and I'll let you know if I have any issues.

BrodyStone21

It has unfortunately occurred again. When I check the admin panel throughout the day, I can see pending jobs that never actually move to active, the scheduler still says active, but the status of the queue stays at inactive until I manually run php flarum scheduled:run.

Do you guys have any ideas? Is this going to prevent new users from signing up?

BrodyStone21

BrodyStone21 @luceos idk if you get notifications unless I directly mention you, but do you have any ideas on how to resolve this? Every morning when I go to check, there are pending jobs, and the status is inactive.

Also, can I clear failed jobs, or retry them somehow?

luceos

BrodyStone21 ping me on discord dm please. I'd love see this fixed for you, but this back and forth is taking time I currently am not in excess of.

BrodyStone21

luceos it's probably too late for you today. I presume you're somewhere in the EU? I will try tomorrow or Monday when I have time earlier on in the day.

huseyinfiliz

Hi, the Flarum cron jobs were working fine until I installed this extension.

My cron job settings: https://ibb.co/DpLtdZ2

Flarum info: https://www.paste.tc/raw/flarum-info

Dashboard > Flarum Cron > Active
Dashboard > Queue > Status: not active | pending: 9

I've seen similar issues in this thread before, but couldn't find any solutions.

luceos

huseyinfiliz can you check the system log files for crons? See if there are any errors, or try manually executing the schedule:run command, but with extra verbosity -vvv.

huseyinfiliz

luceos schedule:run -vvv: https://ibb.co/sbMy5Qd

fof-best-answer.log

flarum-2024-10-24.log

Are these enough?

luceos

huseyinfiliz

[2024-10-24 00:00:02] flarum.ERROR: Symfony\Component\Process\Exception\LogicException: The Process class relies on proc_open, which is not available on your PHP installation. in /var/www/vhosts/removed.org/forum.removed.org/vendor/symfony/process/Process.php:147
Stack trace:

Looks like proc_open is not enabled in your php.ini.

huseyinfiliz

luceos yes, I'm aware of that, and I had disabled proc_open due to my security concerns.

Is there a way to use this extension without enabling proc_open then or do you think enabling proc_open is safe?

When I enable proc_open, the queue appears active in the dashboard, but I can’t check for updates via Composer.

https://forum.removed.org/api/extension-manager/check-for-updates
{"errors":[{"status":"405","code":"method_not_allowed"}]}

The issues started after I installed this extension, but I'm not sure if the problems are related to this extension

[2024-10-24 11:29:02] flarum.ERROR: Error: Call to undefined function Symfony\Component\Process\proc_get_status() in /var/www/vhosts/removed.org/forum.removed.org/vendor/symfony/process/Process.php:1346
Stack trace:
#0 /var/www/vhosts/removed.org/forum.removed.org/vendor/symfony/process/Process.php(368): Symfony\Component\Process\Process->updateStatus()
#1 /var/www/vhosts/removed.org/forum.removed.org/vendor/symfony/process/Process.php(253): Symfony\Component\Process\Process->start()
#2 /var/www/vhosts/removed.org/forum.removed.org/vendor/illuminate/console/Scheduling/Event.php(227): Symfony\Component\Process\Process->run()
#3 /var/www/vhosts/removed.org/forum.removed.org/vendor/illuminate/console/Scheduling/Event.php(201): Illuminate\Console\Scheduling\Event->runCommandInForeground()
#4 /var/www/vhosts/removed.org/forum.removed.org/vendor/illuminate/console/Scheduling/ScheduleRunCommand.php(143): Illuminate\Console\Scheduling\Event->run()
#5 /var/www/vhosts/removed.org/forum.removed.org/vendor/illuminate/console/Scheduling/ScheduleRunCommand.php(102): Illuminate\Console\Scheduling\ScheduleRunCommand->runEvent()
#6 /var/www/vhosts/removed.org/forum.removed.org/vendor/flarum/core/src/Foundation/Console/ScheduleRunCommand.php(39): Illuminate\Console\Scheduling\ScheduleRunCommand->handle()
#7 /var/www/vhosts/removed.org/forum.removed.org/vendor/illuminate/container/BoundMethod.php(36): Flarum\Foundation\Console\ScheduleRunCommand->handle()
#8 /var/www/vhosts/removed.org/forum.removed.org/vendor/illuminate/container/Util.php(40): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#9 /var/www/vhosts/removed.org/forum.removed.org/vendor/illuminate/container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#10 /var/www/vhosts/removed.org/forum.removed.org/vendor/illuminate/container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#11 /var/www/vhosts/removed.org/forum.removed.org/vendor/illuminate/container/Container.php(653): Illuminate\Container\BoundMethod::call()
#12 /var/www/vhosts/removed.org/forum.removed.org/vendor/illuminate/console/Command.php(136): Illuminate\Container\Container->call()
#13 /var/www/vhosts/removed.org/forum.removed.org/vendor/symfony/console/Command/Command.php(298): Illuminate\Console\Command->execute()
#14 /var/www/vhosts/removed.org/forum.removed.org/vendor/illuminate/console/Command.php(120): Symfony\Component\Console\Command\Command->run()
#15 /var/www/vhosts/removed.org/forum.removed.org/vendor/symfony/console/Application.php(1058): Illuminate\Console\Command->run()
#16 /var/www/vhosts/removed.org/forum.removed.org/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#17 /var/www/vhosts/removed.org/forum.removed.org/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#18 /var/www/vhosts/removed.org/forum.removed.org/vendor/flarum/core/src/Console/Server.php(42): Symfony\Component\Console\Application->run()
#19 /var/www/vhosts/removed.org/forum.removed.org/flarum(24): Flarum\Console\Server->listen()
#20 {main}

Edit: I have removed proc_get_status from the disable_functions list, and now it seems like I can check for updates through the Extension Manager.

Edit 2: The Extension Manager has stopped giving errors, and I even updated a extension.

However, now I can't clear the cache from the admin panel. I didn't experience any issues when clearing the cache via SSH.
{"errors":[{"status":"405","code":"method_not_allowed"}]}

Latest Update: For now, I’ve restored the entire system to a backup due to numerous issues arising, as removing the extension or even downgrading Flarum didn’t work. Thank you for your help.

Last Latest Update: I’m starting to think this issue is related to the 1.8.8 version.

I reverted to a backup using version 1.8.7, and I didn’t install any new extensions. Clearing the cache was working. I updated through the Extension Manager, but clearing the cache is no longer working.

SkakashiS

Hello,

I have just installed it, is this usual:

Scheduler; Active
Queue Overview
Status: Inactive
Queue: default
Pending Jobs: 0
Failed Jobs: 0

I have the status inactive but the scheduler it seems to be correctly configurated.

SkakashiS

SkakashiS Does anyone know something about this?

GreXXL

SkakashiS please share your php flarum info output.

SkakashiS

GreXXL I don't have access to SSH. I hope this information can help:

Flarum: 1.8.9
PHP: 8.1.31
MySQL: 10.11.10-MariaDB-cll-lve
Scheduler: Active
Queue Driver: database
Sesion Driver: file
Laravel: 8.83.27

Composer JSON:

{
    "name": "flarum/flarum",
    "description": "Delightfully simple forum software.",
    "type": "project",
    "keywords": [
        "forum",
        "discussion"
    ],
    "homepage": "https://flarum.org/",
    "license": "MIT",
    "authors": [
        {
            "name": "Flarum",
            "email": "info@flarum.org",
            "homepage": "https://flarum.org/team"
        }
    ],
    "support": {
        "issues": "https://github.com/flarum/core/issues",
        "source": "https://github.com/flarum/flarum",
        "docs": "https://docs.flarum.org/"
    },
    "require": {
        "acpl/mobile-tab": "*",
        "afrux/asirem": "*",
        "afrux/forum-widgets-core": "*",
        "afrux/online-users-widget": "*",
        "askvortsov/flarum-markdown-tables": "*",
        "askvortsov/flarum-rich-text": "*",
        "blomstra/database-queue": "*",
        "blomstra/fontawesome": "*",
        "datlechin/flarum-birthdays": "*",
        "datlechin/flarum-simple-tour-guide": "*",
        "flarum-lang/spanish": "*",
        "flarum/approval": "*",
        "flarum/bbcode": "*",
        "flarum/core": "^1.8",
        "flarum/emoji": "*",
        "flarum/extension-manager": "*",
        "flarum/flags": "*",
        "flarum/lang-english": "*",
        "flarum/likes": "*",
        "flarum/lock": "*",
        "flarum/markdown": "*",
        "flarum/mentions": "*",
        "flarum/nicknames": "*",
        "flarum/statistics": "*",
        "flarum/sticky": "*",
        "flarum/subscriptions": "*",
        "flarum/suspend": "*",
        "flarum/tags": "*",
        "fof/analytics": "*",
        "fof/byobu": "*",
        "fof/cookie-consent": "*",
        "fof/html-errors": "*",
        "fof/links": "*",
        "fof/moderator-notes": "*",
        "fof/oauth": "*",
        "fof/pages": "*",
        "fof/recaptcha": "*",
        "fof/sitemap": "*",
        "fof/socialprofile": "*",
        "fof/terms": "*",
        "fof/upload": "*",
        "fof/user-bio": "*",
        "fof/user-directory": "*",
        "fof/webhooks": "*",
        "gtdxyz/flarum-ext-badges": "*",
        "huseyinfiliz/modern-footer": "*",
        "ianm/follow-users": "*",
        "ianm/syndication": "*",
        "ianm/twofactor": "*",
        "justoverclock/auto-post-count-badge": "*",
        "justoverclock/christmas-snow-effect": "*",
        "justoverclock/flarum-ext-welcomebox": "*",
        "justoverclock/last-registered-users": "*",
        "michaelbelgium/flarum-discussion-views": "*",
        "v17development/flarum-seo": "*",
        "xypp/flarum-invite-user": "*"
    },
    "config": {
        "preferred-install": "dist",
        "sort-packages": true
    },
    "prefer-stable": true,
    "minimum-stability": "stable",
    "repositories": []
}

In particular, I have this extension with version 1.1.0.

@edit: I have seen this error (multiple times) in Flarum logs.

[2025-01-22 16:29:03] flarum.ERROR: Symfony\Component\Process\Exception\LogicException: The Process class relies on proc_open, which is not available on your PHP installation. in ******/public_html/vendor/symfony/process/Process.php:147
Stack trace:
#0 ******/public_html/vendor/symfony/process/Process.php(195): Symfony\Component\Process\Process->__construct()
#1 ******/public_html/vendor/illuminate/console/Scheduling/Event.php(226): Symfony\Component\Process\Process::fromShellCommandline()
#2 ******/public_html/vendor/illuminate/console/Scheduling/Event.php(201): Illuminate\Console\Scheduling\Event->runCommandInForeground()
#3 ******/public_html/vendor/illuminate/console/Scheduling/ScheduleRunCommand.php(143): Illuminate\Console\Scheduling\Event->run()
#4 ******/public_html/vendor/illuminate/console/Scheduling/ScheduleRunCommand.php(102): Illuminate\Console\Scheduling\ScheduleRunCommand->runEvent()
#5 ******/public_html/vendor/flarum/core/src/Foundation/Console/ScheduleRunCommand.php(39): Illuminate\Console\Scheduling\ScheduleRunCommand->handle()
#6 ******/public_html/vendor/illuminate/container/BoundMethod.php(36): Flarum\Foundation\Console\ScheduleRunCommand->handle()
#7 ******/public_html/vendor/illuminate/container/Util.php(40): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#8 ******/public_html/vendor/illuminate/container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#9 ******/public_html/vendor/illuminate/container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#10 ******/public_html/vendor/illuminate/container/Container.php(653): Illuminate\Container\BoundMethod::call()
#11 ******/public_html/vendor/illuminate/console/Command.php(136): Illuminate\Container\Container->call()
#12 ******/public_html/vendor/symfony/console/Command/Command.php(298): Illuminate\Console\Command->execute()
#13 ******/public_html/vendor/illuminate/console/Command.php(121): Symfony\Component\Console\Command\Command->run()
#14 ******/public_html/vendor/symfony/console/Application.php(1058): Illuminate\Console\Command->run()
#15 ******/public_html/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#16 ******/public_html/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#17 ******/public_html/vendor/flarum/core/src/Console/Server.php(42): Symfony\Component\Console\Application->run()
#18 ******/public_html/flarum(24): Flarum\Console\Server->listen()
#19 {main}

Regards,

« Previous Page