[INSTRM-1952] insert pfs_config_sps failed Created: 27/Apr/23 Updated: 27/Apr/23 Resolved: 27/Apr/23 |
|
| Status: | Done |
| Project: | Instrument control development |
| Component/s: | ics_utils |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Normal |
| Reporter: | arnaud.lefur | Assignee: | arnaud.lefur |
| Resolution: | Done | Votes: | 0 |
| Labels: | EngRun | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Description |
|
Just happened last night. 2023-04-26 14:41:31.144Z cmds 20 CommandLink.py:121 > 2 176 i sequence=24057,None,darks,"cplTest_afterDF","","iic dark exptime=60 cam=n1",failed,"OpdbInsertFailed(pfs_config_sps) with insert or update on table 'pfs_config_sps' violates foreign key constraint 'pfs_config_sps_visit0_fkey' DETAIL: Key (visit0)=(92009) is not present in table 'pfs_config'.)" 2023-04-26 14:41:31.153Z cmds 20 CommandLink.py:121 > 2 176 f text="OpdbInsertFailed(pfs_config_sps) with insert or update on table 'pfs_config_sps' violates foreign key constraint 'pfs_confi g_sps_visit0_fkey' DETAIL: Key (visit0)=(92009) is not present in table 'pfs_config'.)" visit0 were pointing to fpsVisit but in this context the convergence was on going, so the fps.pfsConfig wasn't created yet. Always point visit0 to the current PfsConfig0. |
| Comments |
| Comment by arnaud.lefur [ 27/Apr/23 ] |
|
merged as ics_utils:1.7.2 |