Database Queue - the simplest queue, even for shared hosting

luceos · Aug 24, 2024

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 · Aug 24, 2024

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 · Oct 24, 2024

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 · Oct 24, 2024

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 · Oct 24, 2024

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

fof-best-answer.log

flarum-2024-10-24.log

Are these enough?

luceos · Oct 24, 2024

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 · Oct 24, 2024

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 · 19 Jan

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 · 22 Jan

SkakashiS Does anyone know something about this?

GreXXL · 22 Jan

SkakashiS please share your php flarum info output.

SkakashiS · 22 Jan

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,

GreXXL · 22 Jan

SkakashiS you need to contact your hosting provider to change the PHP configuration to allow this function.

SkakashiS · 22 Jan

GreXXL Thanks you!

TOWUK · 27 Jan

update to beta 2.0, ext manager dont work without yhis plugin on beta 2.0 (i use for tests)

luceos · 27 Jan

TOWUK yeah it's happening already: https://packagist.org/packages/flarum-com/database-queue

TOWUK · 28 Jan

luceos dev-main branch installed, thx