Re: Invalidate Content Error

[Dave Neuman]

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 <naa...@qwilt.com> 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 <neu...@apache.org> 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 <naa...@qwilt.com> 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 |
> naam...@qwilt.com
>