I checked. The exact same error. It seemed weird to me, too. On Tue, Jan 24, 2017 at 11:12 AM, Oren Shemesh <[email protected]> wrote:
> [1:1] > > R U sure that the exact same error repeats ? > It seems that now the constraint is satisfied, so if there is an error, it > will be a different one ... > > (Not that I know SQL, but my sqenglish is good enough :-) > > On Tue, Jan 24, 2017 at 10:57 AM, Naama Shoresh <[email protected]> wrote: > > > I tried adding a row to the job_agent table: > > mysql> select * from job_agent; > > +----+-------+----------------------------+--------+-------- > -------------+ > > | id | name | description | active | last_updated > | > > +----+-------+----------------------------+--------+-------- > -------------+ > > | 1 | PURGE | Description of Purge Agent | 1 | 2017-01-24 08:50:22 > | > > | 2 | dummy | Description of Purge Agent | 1 | 2017-01-01 10:28:43 > | > > +----+-------+----------------------------+--------+-------- > -------------+ > > 2 rows in set (0.00 sec) > > > > But the error repeats. > > Any ideas? > > > > Thanks, > > Naama > > > > On Tue, Jan 24, 2017 at 12:17 AM, Dave Neuman <[email protected]> wrote: > > > > > The error message says that you are trying to submit a job with an > Agent > > id > > > of 1, which doesn't exist. > > > ```INSERT INTO job ( agent, asset_type, asset_url, > > > entered_time, job_deliveryservice, job_user, keyword, object_name, > > > object_type, parameters, start_time, status) VALUES ( ?, ?, ?, ?, ?, ?, > > ?, > > > ?, ?, ?, ?, ? )" with ParamValues: 0=1, 1="file", 2=" > > > http://s2.ipcamlive.com/.*/7464537492280autoresize.jpg";, 3='2017-01-22 > > > 13:04:53', 4='312', 5='59', 6="PURGE", 7=undef, 8=undef, 9="TTL:48h", > > > 10='2017-01-22 13:05:22', 11=1] at /opt/traffic_ops/app/lib/UI/Job.pm > > line > > > 146``` > > > I am not sure how that agent is supposed to be created, this might be a > > > bug. Can you please submit an issue? > > > The workaround would be to create an agent with id = 1. > > > > > > Thanks, > > > Dave > > > > > > On Mon, Jan 23, 2017 at 3:05 PM, Naama Shoresh <[email protected]> > wrote: > > > > > > > No, only this one: > > > > (2,'dummy','Description of Purge Agent',1,'2017-01-04 13:16:30') > > > > > > > > What does that mean? > > > > > > > > Thanks, > > > > Naama > > > > > > > > On Mon, Jan 23, 2017 at 5:27 PM, Dave Neuman <[email protected]> > > wrote: > > > > > > > > > Do you have an agent in your job_agent table with the id of 1? > > > > > > > > > > > > > > > On Mon, Jan 23, 2017 at 5:42 AM, Naama Shoresh <[email protected]> > > > wrote: > > > > > > > > > > > Hi, > > > > > > > > > > > > When trying to invalidate content from the TO UI, I get the > > following > > > > > fatal > > > > > > error message: > > > > > > > > > > > > Traffic Ops fatal error occurred while processing your request. > > > > > > ------------------------------ > > > > > > Error at line 146 ( my $insert = $self->db->resultset('Job')-> > > > create() > > > > > > ------------------------------ > > > > > > DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: > > > > DBD::mysql::st > > > > > > execute failed: Cannot add or update a child row: a foreign key > > > > > constraint > > > > > > fails (`traffic_ops_db`.`job`, CONSTRAINT `fk_job_agent_id1` > > FOREIGN > > > > KEY > > > > > > (`agent`) REFERENCES `job_agent` (`id`) ON DELETE CASCADE ON > UPDATE > > > NO > > > > > > ACTION) [for Statement "INSERT INTO job ( agent, asset_type, > > > asset_url, > > > > > > entered_time, job_deliveryservice, job_user, keyword, > object_name, > > > > > > object_type, parameters, start_time, status) VALUES ( ?, ?, ?, ?, > > ?, > > > ?, > > > > > ?, > > > > > > ?, ?, ?, ?, ? )" with ParamValues: 0=1, 1="file", 2=" > > > > > > http://s2.ipcamlive.com/.*/7464537492280autoresize.jpg";, > > > 3='2017-01-22 > > > > > > 13:04:53', 4='312', 5='59', 6="PURGE", 7=undef, 8=undef, > > 9="TTL:48h", > > > > > > 10='2017-01-22 13:05:22', 11=1] at /opt/traffic_ops/app/lib/UI/ > > > Job.pm > > > > > line > > > > > > 146 > > > > > > > > > > > > In traffic_ops log file I see this message: > > > > > > [2017-01-23 12:31:47,834] [ERROR] DBIx::Class::Storage::DBI::_ > > > > > > dbh_execute(): > > > > > > DBI Exception: DBD::mysql::st execute failed: Cannot add or > update > > a > > > > > child > > > > > > row: a foreign key constraint fails (`traffic_ops_db`.`job`, > > > CONSTRAINT > > > > > > `fk_job_agent_id1` FOREIGN KEY (`agent`) REFERENCES `job_agent` > > > (`id`) > > > > ON > > > > > > DELETE CASCADE ON UPDATE NO ACTION) [for Statement "INSERT INTO > > job ( > > > > > > agent, asset_type, asset_url, entered_time, job_deliveryservice, > > > > > job_user, > > > > > > keyword, object_name, object_type, parameters, start_time, > status) > > > > > VALUES ( > > > > > > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" with ParamValues: 0=1, > > > 1="file", > > > > > 2=" > > > > > > http://images1.ynet.co.il/foo/.*";, 3='2017-01-23 12:31:47', > > 4='311', > > > > > > 5='59', 6="PURGE", 7=undef, 8=undef, 9="TTL:48h", 10='2017-01-23 > > > > > 12:32:22', > > > > > > 11=1] at /opt/traffic_ops/app/lib/UI/Job.pm line 146 > > > > > > [2017-01-23 12:31:47,835] [ERROR] > > > > > > > > > > > > > > > > > > Any idea why this happens? > > > > > > > > > > > > Thanks, > > > > > > Naama > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > *Naama Shoresh* > > > > Qwilt | Work: +972-72-2221706 | Mobile: +972-52-3401999 | > > > > [email protected] > > > > > > > > > > > > > > > -- > > *Naama Shoresh* > > Qwilt | Work: +972-72-2221706 | Mobile: +972-52-3401999 | > > [email protected] > > > > > > -- > > *Oren Shemesh* > Qwilt | Work: +972-72-2221637| Mobile: +972-50-2281168 | [email protected] > <[email protected]> > -- *Naama Shoresh* Qwilt | Work: +972-72-2221706 | Mobile: +972-52-3401999 | [email protected]
![http://s2.ipcamlive.com/.*/7464537492280autoresize.jpg"](http://s2.ipcamlive.com/.*/7464537492280autoresize.jpg"){kind=link}