I've said I can provide the DB and needed data if it is kept secret :)
-Tee-
On Tue, Sep 20, 2016 at 3:55 PM, Vlad Khorsun
wrote:
> 19.09.2016 14:06, Tommi Prami wrote:
> > Weird part was that I actually pumped the data to the empty database and
> it behaved the same.
> >
> > This is more than
19.09.2016 14:06, Tommi Prami wrote:
> Weird part was that I actually pumped the data to the empty database and it
> behaved the same.
>
> This is more than less puzzling.
>
> And the Backup and restore did not help,. which also, I think, should
> recreate the indexes and so on...
Without rep
Weird part was that I actually pumped the data to the empty database and it
behaved the same.
This is more than less puzzling.
And the Backup and restore did not help,. which also, I think, should
recreate the indexes and so on...
-Tee-
On Thu, Sep 15, 2016 at 10:58 AM, Thomas Steinmaurer
wr
> Whole story here :
>
> https://plus.google.com/105626236962310493174/posts/3UZB71NjUhA
>
> Copy of message
> - - - - - - - - - - - - - - - -
> Is there a tool (or way) to debug database step by step.
>
> Now we have weird situation where delete from one database fails, on
> foreign key error
It is cascade thingy (I am not the DB guy...) So it normally works OK...
If we drop the foreign key and create it again it starts to work. Data from
Both tables gets removed correctly.
Appears the there is small difference in the newly created foreign key.
For this foreign key following stuff in
15.09.2016 9:39, Tommi Prami wrote:
> Foreign key references are present for the record
> Problematic key value is ("TOSITEID" = 945)
>
> Data is there, it can be selected but the delete fails on this DB
Delete fails exactly because data is there. You must delete referencing
records first
and
We use
2.5.6.27020 (32bit)
[#1: Delete - PLAN (TOSITE INDEX (PK_TOSITE))]
violation of FOREIGN KEY constraint "FK_VIENTI_TOSITE" on table "VIENTI"
Foreign key references are present for the record
Problematic key value is ("TOSITEID" = 945)
Data is there, it can be selected but the delete fails
On 15.09.2016 10:14, Tommi Prami wrote:
> Whole story here :
>
> https://plus.google.com/105626236962310493174/posts/3UZB71NjUhA
>
> Copy of message
> - - - - - - - - - - - - - - - -
> Is there a tool (or way) to debug database step by step.
>
> Now we have weird situation where delete from one
Whole story here :
https://plus.google.com/105626236962310493174/posts/3UZB71NjUhA
Copy of message
- - - - - - - - - - - - - - - -
Is there a tool (or way) to debug database step by step.
Now we have weird situation where delete from one database fails, on
foreign key error, which sounds like
