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 >
![http://s2.ipcamlive.com/.*/7464537492280autoresize.jpg"](http://s2.ipcamlive.com/.*/7464537492280autoresize.jpg"){kind=link}