Redis sessions, cache & queues

matteocontrini

luceos sorry, it's still me. I created that table, but I don't see anything being inserted when a job fails. I tried with both queue_failed and failed_jobs (from the Laravel docs) as table names, without success. (Database prefix excluded.)

Am I missing something?

luceos

matteocontrini I totally forgot that part 🙈


use Illuminate\Database\ConnectionInterface;
use Illuminate\Queue\Failed\DatabaseFailedJobProvider;
// ..
        $container->bind('queue.failer', function () use ($container) {
            return new DatabaseFailedJobProvider(
                $container->make(ConnectionResolverInterface::class),
                'flarum',
                'queue_failed'
            );
        });
// ..

This is what I added in my code as well. This could best be an extender.

TLDR this is becoming far more complicated than a simple "create the table"; if I have some time the coming weeks I will create a proper package/extension to add this logic.

matteocontrini

luceos it appears it's still not working...

I created an extender:

use Flarum\Extend\ExtenderInterface;
use Flarum\Extension\Extension;
use Illuminate\Contracts\Container\Container;
use Illuminate\Database\ConnectionResolverInterface;
use Illuminate\Queue\Failed\DatabaseFailedJobProvider;

class BindQueueFailer implements ExtenderInterface
{

    public function extend(Container $container, Extension $extension = null)
    {
        $container->bind('queue.failer', function () use ($container) {
            return new DatabaseFailedJobProvider(
                $container->make(ConnectionResolverInterface::class),
                'flarum',
                'queue_failed'
            );
        });
    }
}

Which I'm pretty sure is executed because with my advanced PHP skills I put a die() and it did die 🙂

The migration was run and the queue_failed table is there.

I run php flarum queue:work and made a job fail:

[2021-02-25 13:21:49][jaNSua02JCkpUeEP30Usn4bPJqZ2mGxl] Processing: Flarum\Notification\Job\SendNotificationsJob
[2021-02-25 13:21:49][jaNSua02JCkpUeEP30Usn4bPJqZ2mGxl] Processed:  Flarum\Notification\Job\SendNotificationsJob
[2021-02-25 13:21:49][NqDgK5eQotXESgiS1qToWFhNfQ2CKIpz] Processing: Flarum\Notification\Job\SendEmailNotificationJob
[2021-02-25 13:21:49][NqDgK5eQotXESgiS1qToWFhNfQ2CKIpz] Failed:     Flarum\Notification\Job\SendEmailNotificationJob
[2021-02-25 13:21:49][7WzqpIpXQe4KRPWLWdc6d6PFfJONWYOH] Processing: Flarum\Subscriptions\Job\SendReplyNotification
[2021-02-25 13:21:49][7WzqpIpXQe4KRPWLWdc6d6PFfJONWYOH] Processed:  Flarum\Subscriptions\Job\SendReplyNotification

The table is still empty. Something I could look at? 😅

Thanks! 😃

matteocontrini

Ok, an update. I looked at the logs and it says:

Next Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'connection' cannot be null (SQL: insert into `queue_failed` (`connection`, `queue`, `payload`, `exception`, `failed_at`) values (?, default, [...]

What am I doing wrong 😭

luceos

matteocontrini interesting 😂 truth be told I'm not even sure it works on my end yet. So I guess this is trial-and-error. Can you manually set the connection field to be nullable in your database editor?

matteocontrini

luceos done and it works now, finally 😃

connection is null obviously, but I'm not even sure what that should stand for so that's fine, I guess 😅

luceos

matteocontrini queue has a queue and connection value; it stems from the laravel source that flarum uses. Their stub doesn't even have it nullable. As we only have one connection I bet it is caused by the Flarum implementation somewhere 😎

luceos

0.3.0-beta for flarum beta 16 released, update:

composer require blomstra/flarum-redis -W

or if you have your dependency set to * just use

composer update blomstra/flarum-redis -W

This is a beta because it hasn't been tested in production yet.

MohdKhan

luceos give HTTP ERROR 500.
after adding code to extend.php

MohdKhan

its Works after adding :0.3.0-beta with composer require code.

fatihaysel

how can we set up Redis on 1 server 2 domain

[deleted]

fatihaysel Yes, but you need to be sure you use different databases for each instance you want to run. Redis supports up to 15, with the default being 1, so your next one would be 2, etc..

matteocontrini

[deleted] just to nitpick... The maximum number of databases can be changed in the Redis configuration and there's no hard limit except memory, I think 🙂

[deleted]

matteocontrini agreed, but the default out of the box after install is 15.

fatihaysel

Thank you [deleted] matteocontrini

i change database to 2 but I got,

 php_network_getaddresses: getaddrinfo failed: Name does not resolve [tcp://127.0.0.1/forum/
  :6379]

error

fatihaysel

Thank you for your informations rob006 matteocontrini [deleted] for your contribution to learning new things. 😃
how can I solve READONLY You can't write against a read only replica error
i am using mondedie/flarum beta 15. I install setup redis. After run this code php flarum queue:work it is working. But, after a certain period of time(2 hour) it is not working. What should I do for it to work continuously? Do you have any advice?

rob006

[deleted] Actually it is 16 databases by default. And default one is 0, not 1 (at least from Redis perspective - config example from first post explicitly uses 1 as database, so default Redis database does not matter in this case).

fatihaysel

i delete /forum/ now its looks like working

fatihaysel

redis is working with code php flarum queue:work but after a while Redis not working. Is there any other solution instead of running this code each time?

matteocontrini

fatihaysel you don't need to run it "each time", you should create for example a system service as mentioned a few posts above

Geraldlzc

matteocontrini WorkingDirectory、ExecStart, I don't know how to configure these two parameters. Can you tell me.

« Previous Page Next Page »