29 questions
0
votes
0
answers
37
views
Database Integrity Concerns: Missing FK Constraints and Vacuum Process Implications
Version - PostgreSQL 10.21, compiled by Visual C++ build 1800, 64-bit
Platform - Windows
We are currently experiencing issues in the database where foreign key (FK) constraints are missing, leading to ...
1
vote
1
answer
1k
views
AKS not deleting orphaned resources
After some time, I have problems with some of our clusters where auto-delete of orphaned resources stop working. So if I remove a deployment nor the replicaset or the pods are removed, or if I remove ...
1
vote
2
answers
717
views
In Django 3/Python, what is the preferred way to remove orphaned records?
I'm using Django 3 and Python 3.8. I have the following model ...
class Coop(models.Model):
objects = CoopManager()
name = models.CharField(max_length=250, null=False)
types = models....
1
vote
0
answers
75
views
Typo3 v7.6.39 finding orphan files
I have a Typo3 v7.6.39 website and I have a lot of files uploaded in different folders under user_upload. How can I see which files are orphan files (files that are not used or linked on my webpage)?
...
2
votes
1
answer
5k
views
How to delete parent without deleting children in one to many relationship
I am trying to delete a Patient entity without deleting the associated OutboundMessage entities as i want to keep them in the database for reporting/historical purposes. This is the relevant code :
...
1
vote
2
answers
827
views
Symfony2 and Doctrine: One-To-Many with Join Table Orphan Removal
I have an entity, "AnnualReport", which accepts a collection of entities, "AnnualReportStaffing". An annual report has four different Staffing sections and hence four of these collections (...
23
votes
2
answers
7k
views
Prevent Hibernate from deleting orphaned entities while merging an entity having entity associations with orphanRemoval set to true
Taking a very simple example of one-to-many relationship (country -> state).
Country (inverse side) :
@OneToMany(mappedBy = "country", fetch = FetchType.LAZY, cascade = CascadeType.ALL, ...
0
votes
0
answers
635
views
ios - Storing binary data 'externally' in coredata causes orphaned files
I'm not sure whether this is a bug or not, so am asking for advice...
(iOS 7.1.2 on xcode 5.1.1)
My app stores many large data image in coredata. The binary images have their attribute set in the ...
1
vote
1
answer
343
views
How can a PHP programmer identify orphaned PHP files or images for sure?
If a C/C++ programmer wants to tidy out a large C or C++ project, then he can remove some code files (*.c, *.h, *.cpp, ...) that he thinks as possibly orphaned. When he starts the compiler, and it ...
3
votes
0
answers
397
views
hibernate 4.3.0 @OneToMany orphanRemoval=true leaves orphans
I found a lot of discussions on orphanRemoval=true option still leaving orphans, however I do not seem to find the right answer for my problem.
I have a Connector class that has a OneToMany relation ...
0
votes
1
answer
1k
views
orphaned users after restore to new machine not on domain; understanding KB918992
Seeking clarification/confirmation: if I understand correctly, the following considerations about "orphaned users" apply only to those users that are associated with a Windows network security ...
10
votes
3
answers
2k
views
Auto-expire orphaned Subscription (Azure ServiceBus Messaging SubscriptionClient)
The scenario I have in mind is this: Service Bus is used for instance-to-instance communication, so a Subscription is unique per service instance. The end result is that if an instance does not shut ...
3
votes
1
answer
2k
views
Why does OracleAQ Leave Dead Subscribers in the Queue?
This is Oracle 11.2.0.3.
We've got a problem where we use Oracle's JMS over OracleAQ. This works fine except we started noticing the queue getting filled with 1000s, then millions of messages over ...
1
vote
1
answer
970
views
EclipseLink not removing privately owned one-to-many item
I am unable to get Eclipselink to delete a privately owned entity that is mapped as a one-to-many relationship. When I remove the privately owned entity from the one-to-many collection and set the ...
1
vote
5
answers
901
views
Prevent orphaned objects in DB4O when updating fields
I want to store Person objects in DB4O. The Person Location field can be changed over time. So I retrieve a person from the DB and call a method to set the location field to a new Location object. (I ...