The Wayback Machine - https://web.archive.org/web/20201110223428/https://github.com/CachetHQ/Cachet/issues/4063
Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Null value in column "reserved" violates not-null constraint #4063

Open
rpartapsing opened this issue Jul 18, 2020 · 2 comments
Open

Null value in column "reserved" violates not-null constraint #4063

rpartapsing opened this issue Jul 18, 2020 · 2 comments
Labels

Comments

@rpartapsing
Copy link

@rpartapsing rpartapsing commented Jul 18, 2020

Hi,

This is me trying to create a maintenance with the "notify subscribers" ticked.
Also I don't see any maintenances showing up in the dashboard.

Please help since this is out main feature.

Illuminate \ Database \ QueryException (23502)
SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "reserved" violates not-null constraint DETAIL: Failing row contains (3, default, {"displayName":"CachetHQ\Cachet\Notifications\Schedule\NewSc..., 0, null, null, 1595073621, 1595073621). (SQL: insert into "jobs" ("queue", "attempts", "reserved_at", "available_at", "created_at", "payload") values (default, 0, , 1595073621, 1595073621, {"displayName":"CachetHQ\Cachet\Notifications\Schedule\NewScheduleNotification","job":"Illuminate\Queue\CallQueuedHandler@call","maxTries":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"Illuminate\Notifications\SendQueuedNotifications","command":"O:48:"Illuminate\Notifications\SendQueuedNotifications":11:{s:11:"notifiables";O:45:"Illuminate\Contracts\Database\ModelIdentifier":4:{s:5:"class";s:33:"CachetHQ\Cachet\Models\Subscriber";s:2:"id";i:1;s:9:"relations";a:1:{i:0;s:13:"subscriptions";}s:10:"connection";s:5:"pgsql";}s:12:"notification";O:62:"CachetHQ\Cachet\Notifications\Schedule\NewScheduleNotification":9:{s:11:"\u0000*\u0000schedule";O:44:"CachetHQ\Cachet\Presenters\SchedulePresenter":2:{s:8:"\u0000*\u0000dates";O:42:"CachetHQ\Cachet\Services\Dates\DateFactory":2:{s:14:"\u0000*\u0000appTimezone";s:3:"UTC";s:17:"\u0000*\u0000cachetTimezone";s:16:"Europe/Amsterdam";}s:16:"\u0000*\u0000wrappedObject";O:31:"CachetHQ\Cachet\Models\Schedule":30:{s:13:"\u0000*\u0000attributes";a:8:{s:6:"status";s:1:"0";s:12:"completed_at";s:19:"2020-07-25 10:00:00";s:4:"name";s:4:"rree";s:7:"message";s:4:"eedd";s:12:"scheduled_at";s:19:"2020-07-18 10:00:00";s:10:"updated_at";s:19:"2020-07-18 12:00:21";s:10:"created_at";s:19:"2020-07-18 12:00:21";s:2:"id";i:4;}s:8:"\u0000*\u0000casts";a:5:{s:4:"name";s:6:"string";s:7:"message";s:6:"string";s:6:"status";s:3:"int";s:12:"scheduled_at";s:8:"datetime";s:12:"completed_at";s:8:"datetime";}s:11:"\u0000*\u0000fillable";a:7:{i:0;s:4:"name";i:1;s:7:"message";i:2;s:6:"status";i:3;s:12:"scheduled_at";i:4;s:12:"completed_at";i:5;s:10:"created_at";i:6;s:10:"updated_at";}s:5:"rules";a:3:{s:4:"name";s:15:"required|string";s:7:"message";s:15:"nullable|string";s:6:"status";s:24:"required|int|between:0,2";}s:13:"\u0000*\u0000searchable";a:3:{i:0;s:2:"id";i:1;s:4:"name";i:2;s:6:"status";}s:11:"\u0000*\u0000sortable";a:7:{i:0;s:2:"id";i:1;s:4:"name";i:2;s:6:"status";i:3;s:12:"scheduled_at";i:4;s:12:"completed_at";i:5;s:10:"created_at";i:6;s:10:"updated_at";}s:7:"\u0000*\u0000with";a:1:{i:0;s:10:"components";}s:13:"\u0000*\u0000connection";s:5:"pgsql";s:8:"\u0000*\u0000table";s:9:"schedules";s:13:"\u0000*\u0000primaryKey";s:2:"id";s:10:"\u0000*\u0000keyType";s:3:"int";s:12:"incrementing";b:1;s:12:"\u0000*\u0000withCount";a:0:{}s:10:"\u0000*\u0000perPage";i:15;s:6:"exists";b:1;s:18:"wasRecentlyCreated";b:1;s:11:"\u0000*\u0000original";a:8:{s:6:"status";s:1:"0";s:12:"completed_at";s:19:"2020-07-25 10:00:00";s:4:"name";s:4:"rree";s:7:"message";s:4:"eedd";s:12:"scheduled_at";s:19:"2020-07-18 10:00:00";s:10:"updated_at";s:19:"2020-07-18 12:00:21";s:10:"created_at";s:19:"2020-07-18 12:00:21";s:2:"id";i:4;}s:10:"\u0000*\u0000changes";a:0:{}s:8:"\u0000*\u0000dates";a:0:{}s:13:"\u0000*\u0000dateFormat";N;s:10:"\u0000*\u0000appends";a:0:{}s:19:"\u0000*\u0000dispatchesEvents";a:0:{}s:14:"\u0000*\u0000observables";a:0:{}s:12:"\u0000*\u0000relations";a:0:{}s:10:"\u0000*\u0000touches";a:0:{}s:10:"timestamps";b:1;s:9:"\u0000*\u0000hidden";a:0:{}s:10:"\u0000*\u0000visible";a:0:{}s:10:"\u0000*\u0000guarded";a:1:{i:0;s:1:"";}s:16:"\u0000\u0000forceDeleting";b:0;}}s:2:"id";s:36:"78753d4f-a7af-46b0-863a-1cdf28ebb003";s:6:"locale";N;s:10:"connection";N;s:5:"queue";N;s:15:"chainConnection";N;s:10:"chainQueue";N;s:5:"delay";N;s:7:"chained";a:0:{}}s:8:"channels";a:1:{i:0;s:4:"mail";}s:5:"tries";N;s:7:"timeout";N;s:10:"connection";N;s:5:"queue";N;s:15:"chainConnection";N;s:10:"chainQueue";N;s:5:"delay";N;s:7:"chained";a:0:{}}"}}) returning "id")

@welcome
Copy link

@welcome welcome bot commented Jul 18, 2020

👋 Thank you for opening your first issue. I'm just an automated bot that's here to help you get the information you need quicker, so please ignore this message if it doesn't apply to your issue.
If you're looking for support, you should try the Slack group by registering your email address at https://cachethq-slack.herokuapp.com. Alternatively, email [email protected] for our Professional support service (please note, this a paid service.)
If you're issue is with documentation, you can suggest edits by clicking the Suggest Edits link on any page, or open an issue at https://github.com/CachetHQ/Docs

@triage-new-issues triage-new-issues bot added the triage label Jul 18, 2020
@venkz
Copy link

@venkz venkz commented Aug 5, 2020

Facing the same issue. Can someone please look into this.

On cachet-docker 2.4.0-dev

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants
You can’t perform that action at this time.