1. [2019-11-26 07:44:33] movim.ERROR: Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`movim`.`rosters`, CONSTRAINT `rosters_session_id_foreign` FOREIGN KEY (`session_id`) REFERENCES `sessions` (`id`) ON DELETE CASCADE) (SQL: insert into `rosters` (`ask`, `created_at`, `group`, `jid`, `name`, `session_id`, `subscription`, `updated_at`) values (?, 2019-11-26 07:44:33, , 917016350537@chat.webrtc.co.il, Deeppp, lrOCBGEro8JQkS8pnIgn4LbIOs4P4eCu, both, 2019-11-26 07:44:33), (?, 2019-11-26 07:44:33, , 917567978886@chat.webrtc.co.il, Deeppp, lrOCBGEro8JQkS8pnIgn4LbIOs4P4eCu, both, 2019-11-26 07:44:33), (?, 2019-11-26 07:44:33, , 919925757126@chat.webrtc.co.il,  , lrOCBGEro8JQkS8pnIgn4LbIOs4P4eCu, both, 2019-11-26 07:44:33), (?, 2019-11-26 07:44:33, , 919328638322@chat.webrtc.co.il, Mayur Itpl, lrOCBGEro8JQkS8pnIgn4LbIOs4P4eCu, both, 2019-11-26 07:44:33), (?, 2019-11-26 07:44:33, , 919625757127@chat.webrtc.co.il,  , lrOCBGEro8JQkS8pnIgn4LbIOs4P4eCu, both, 2019-11-26 07:44:33), (?, 2019-11-26 07:44:33, , 919512412221@chat.webrtc.co.il,  , lrOCBGEro8JQkS8pnIgn4LbIOs4P4eCu, ?, 2019-11-26 07:44:33), (?, 2019-11-26 07:44:33, , 919586082989@chat.webrtc.co.il, Deeppp, lrOCBGEro8JQkS8pnIgn4LbIOs4P4eCu, both, 2019-11-26 07:44:33), (?, 2019-11-26 07:44:33, , 918401143062@chat.webrtc.co.il,  , lrOCBGEro8JQkS8pnIgn4LbIOs4P4eCu, ?, 2019-11-26 07:44:33)) in /var/www/movim/vendor/illuminate/database/Connection.php (line 664) Trace #0 /var/www/movim/vendor/illuminate/database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('insert into `ro...', Array, Object(Closure)) #1 /var/www/movim/vendor/illuminate/database/Connection.php(459): Illuminate\Database\Connection->run('insert into `ro...', Array, Object(Closure)) #2 /var/www/movim/vendor/illuminate/database/Connection.php(411): Illuminate\Database\Connection->statement('insert into `ro...', Array) #3 /var/www/movim/vendor/illuminate/database/Query/Builder.php(2646): Illuminate\Database\Connection->insert('insert into `ro...', Array) #4 /var/www/movim/vendor/illuminate/database/Eloquent/Builder.php(1353): Illuminate\Database\Query\Builder->insert(Array) #5 /var/www/movim/vendor/illuminate/support/Traits/ForwardsCalls.php(23): Illuminate\Database\Eloquent\Builder->__call('insert', Array) #6 /var/www/movim/vendor/illuminate/database/Eloquent/Model.php(1618): Illuminate\Database\Eloquent\Model->forwardCallTo(Object(Illuminate\Database\Eloquent\Builder), 'insert', Array) #7 /var/www/movim/vendor/illuminate/database/Eloquent/Model.php(1630): Illuminate\Database\Eloquent\Model->__call('insert', Array) #8 /var/www/movim/app/Roster.php(73): Illuminate\Database\Eloquent\Model::__callStatic('insert', Array) #9 /var/www/movim/lib/moxl/src/Moxl/Xec/Action/Roster/GetList.php(29): App\Roster::saveMany(Array) #10 /var/www/movim/lib/moxl/src/Moxl/Xec/Handler.php(61): Moxl\Xec\Action\Roster\GetList->handle(Object(SimpleXMLElement)) #11 /var/www/movim/linker.php(33): Moxl\Xec\Handler::handle(Object(SimpleXMLElement)) #12 [internal function]: {closure}(Object(SimpleXMLElement)) #13 /var/www/movim/lib/moxl/src/Moxl/Parser.php(104): call_user_func_array(Object(Closure), Array) #14 [internal function]: Moxl\Parser->end(Resource id #381, 'iq') #15 /var/www/movim/lib/moxl/src/Moxl/Parser.php(49): xml_parse(Resource id #381, '<iq xml:lang='e...', false) #16 /var/www/movim/linker.php(252): Moxl\Parser->parse('<iq xml:lang='e...') #17 /var/www/movim/vendor/evenement/evenement/src/Evenement/EventEmitterTrait.php(123): {closure}('<iq xml:lang='e...') #18 /var/www/movim/vendor/react/stream/src/Util.php(71): Evenement\EventEmitter->emit('data', Array) #19 /var/www/movim/vendor/evenement/evenement/src/Evenement/EventEmitterTrait.php(123): React\Stream\Util::React\Stream\{closure}('<iq xml:lang='e...') #20 /var/www/movim/vendor/react/stream/src/DuplexResourceStream.php(193): Evenement\EventEmitter->emit('data', Array) #21 /var/www/movim/vendor/react/event-loop/src/StreamSelectLoop.php(244): React\Stream\DuplexResourceStream->handleData(Resource id #298) #22 /var/www/movim/vendor/react/event-loop/src/StreamSelectLoop.php(211): React\EventLoop\StreamSelectLoop->waitForStreamActivity(3280647) #23 /var/www/movim/linker.php(282): React\EventLoop\StreamSelectLoop->run() #24 {main} [] []
2.  
3.  
4.  
5. [2019-11-26 07:44:58] movim.ERROR: Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`movim`.`rosters`, CONSTRAINT `rosters_session_id_foreign` FOREIGN KEY (`session_id`) REFERENCES `sessions` (`id`) ON DELETE CASCADE) (SQL: insert into `rosters` (`ask`, `created_at`, `group`, `jid`, `name`, `session_id`, `subscription`, `updated_at`) values (?, 2019-11-26 07:44:58, , 917016350537@chat.webrtc.co.il, Deeppp, lrOCBGEro8JQkS8pnIgn4LbIOs4P4eCu, both, 2019-11-26 07:44:58), (?, 2019-11-26 07:44:58, , 917567978886@chat.webrtc.co.il, Deeppp, lrOCBGEro8JQkS8pnIgn4LbIOs4P4eCu, both, 2019-11-26 07:44:58), (?, 2019-11-26 07:44:58, , 919925757126@chat.webrtc.co.il,  , lrOCBGEro8JQkS8pnIgn4LbIOs4P4eCu, both, 2019-11-26 07:44:58), (?, 2019-11-26 07:44:58, , 919328638322@chat.webrtc.co.il, Mayur Itpl, lrOCBGEro8JQkS8pnIgn4LbIOs4P4eCu, both, 2019-11-26 07:44:58), (?, 2019-11-26 07:44:58, , 919625757127@chat.webrtc.co.il,  , lrOCBGEro8JQkS8pnIgn4LbIOs4P4eCu, both, 2019-11-26 07:44:58), (?, 2019-11-26 07:44:58, , 919512412221@chat.webrtc.co.il,  , lrOCBGEro8JQkS8pnIgn4LbIOs4P4eCu, ?, 2019-11-26 07:44:58), (?, 2019-11-26 07:44:58, , 919586082989@chat.webrtc.co.il, Deeppp, lrOCBGEro8JQkS8pnIgn4LbIOs4P4eCu, both, 2019-11-26 07:44:58), (?, 2019-11-26 07:44:58, , 918401143062@chat.webrtc.co.il,  , lrOCBGEro8JQkS8pnIgn4LbIOs4P4eCu, ?, 2019-11-26 07:44:58)) in /var/www/movim/vendor/illuminate/database/Connection.php (line 664) Trace #0 /var/www/movim/vendor/illuminate/database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('insert into `ro...', Array, Object(Closure)) #1 /var/www/movim/vendor/illuminate/database/Connection.php(459): Illuminate\Database\Connection->run('insert into `ro...', Array, Object(Closure)) #2 /var/www/movim/vendor/illuminate/database/Connection.php(411): Illuminate\Database\Connection->statement('insert into `ro...', Array) #3 /var/www/movim/vendor/illuminate/database/Query/Builder.php(2646): Illuminate\Database\Connection->insert('insert into `ro...', Array) #4 /var/www/movim/vendor/illuminate/database/Eloquent/Builder.php(1353): Illuminate\Database\Query\Builder->insert(Array) #5 /var/www/movim/vendor/illuminate/support/Traits/ForwardsCalls.php(23): Illuminate\Database\Eloquent\Builder->__call('insert', Array) #6 /var/www/movim/vendor/illuminate/database/Eloquent/Model.php(1618): Illuminate\Database\Eloquent\Model->forwardCallTo(Object(Illuminate\Database\Eloquent\Builder), 'insert', Array) #7 /var/www/movim/vendor/illuminate/database/Eloquent/Model.php(1630): Illuminate\Database\Eloquent\Model->__call('insert', Array) #8 /var/www/movim/app/Roster.php(73): Illuminate\Database\Eloquent\Model::__callStatic('insert', Array) #9 /var/www/movim/lib/moxl/src/Moxl/Xec/Action/Roster/GetList.php(29): App\Roster::saveMany(Array) #10 /var/www/movim/lib/moxl/src/Moxl/Xec/Handler.php(61): Moxl\Xec\Action\Roster\GetList->handle(Object(SimpleXMLElement)) #11 /var/www/movim/linker.php(33): Moxl\Xec\Handler::handle(Object(SimpleXMLElement)) #12 [internal function]: {closure}(Object(SimpleXMLElement)) #13 /var/www/movim/lib/moxl/src/Moxl/Parser.php(104): call_user_func_array(Object(Closure), Array) #14 [internal function]: Moxl\Parser->end(Resource id #381, 'iq') #15 /var/www/movim/lib/moxl/src/Moxl/Parser.php(49): xml_parse(Resource id #381, '<iq xml:lang='e...', false) #16 /var/www/movim/linker.php(252): Moxl\Parser->parse('<iq xml:lang='e...') #17 /var/www/movim/vendor/evenement/evenement/src/Evenement/EventEmitterTrait.php(123): {closure}('<iq xml:lang='e...') #18 /var/www/movim/vendor/react/stream/src/Util.php(71): Evenement\EventEmitter->emit('data', Array) #19 /var/www/movim/vendor/evenement/evenement/src/Evenement/EventEmitterTrait.php(123): React\Stream\Util::React\Stream\{closure}('<iq xml:lang='e...') #20 /var/www/movim/vendor/react/stream/src/DuplexResourceStream.php(193): Evenement\EventEmitter->emit('data', Array) #21 /var/www/movim/vendor/react/event-loop/src/StreamSelectLoop.php(244): React\Stream\DuplexResourceStream->handleData(Resource id #298) #22 /var/www/movim/vendor/react/event-loop/src/StreamSelectLoop.php(211): React\EventLoop\StreamSelectLoop->waitForStreamActivity(3319771) #23 /var/www/movim/linker.php(282): React\EventLoop\StreamSelectLoop->run() #24 {main} [] []