Redis sessions, cache & queues

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

i delete /forum/ now its looks like working

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

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?

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

fatihaysel

This post Right?

On distributions with systemd (e.g. Ubuntu), it's also possible to create a system service without installing anything. Here's an example:

/etc/systemd/system/flarum-queue.service


[Unit]
Description=flarum-queue
After=network.target
StartLimitIntervalSec=0

[Service]
Type=simple
User=deploy
WorkingDirectory=/var/www/flarum
ExecStart=/usr/bin/php flarum queue:work
Restart=always
RestartSec=5

[Install]
WantedBy=multi-user.target
Then, once:

sudo systemctl start flarum-queue
sudo systemctl enable flarum-queue

matteocontrini

fatihaysel yes, although it's not the only way. That's what I did with no issues so far

fatihaysel

Thank you @matteocontrini

« Previous Page Next Page »