actually, I didn't look closely enough. It is now complaining about a different table. Thanks!
On Tue, Jan 24, 2017 at 11:13 AM, Naama Shoresh <[email protected]> wrote: > 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 <+972%2072-222-1706> | Mobile: >> +972-52-3401999 <+972%2052-340-1999> | >> > > > [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 <+972%2072-222-1706> | Mobile: > +972-52-3401999 <+972%2052-340-1999> | [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}