07/21 06:50:28. ERROR Assertion failed: 200166 (17.0.10.6285)[--server/database name--]
Referenced table page does not belong to this table
Had this error after restoring after a ransomware attack. I'm running a VALIDATE on the tables now. Haven't ...
If I run the following statement:
//create a watcom function
CREATE OR REPLACE FUNCTION "DBA"."TEST1" (@val INT)
RETURNS INTEGER
BEGIN
IF (@val = 1) THEN
SET @val = 2;
ENDIF;
RETURN @Val;
END;
//create a t-sql function
CREATE OR...
If I run the following statement:
//create a watcom function
CREATE OR REPLACE FUNCTION "DBA"."TEST1" (@val INT)
RETURNS INTEGER
BEGIN
IF (@val = 1) THEN
SET @val = 2;
ENDIF;
RETURN @Val;
END;
//create a t-sql function
CREATE OR...
We recently upgraded from 11 to 17 (I know) and I've hit a really weird problem with a very simple query.
I'm running a query joining two tables and fetching DISTINCT values from the second table.
The tables are:
CREATE TABLE "DBA"."GenericInfoLinks"...
Hi all,
I have a db mirroring as mode=sync and we've been having a bit of trouble with large UPDATE statements locking out all other connections until the statements and connections has finished. Does anyone think it will be worth the risk of moving ...
The error was in the -oe log
"Specifies a file name to log startup errors, fatal errors, and assertions."
It was created when the database shut itself down.
Yes, the database starts and runs and works "fine".
Are you saying that a full unload/reload...
I added a foreign key in my test DB and all permutations of the query returned results as expected.
So, this is about the difference in behaviour between the server "knowing" where to find the related records and having to search for them?
This is great, guys. Thanks very much. I really don't want to be a in a position to lose transactions but I also can't really go on having large updates lock out all the users.
The mirror is a virtual machine (not my choice) and might be under a more...
I've added this line to the function that returns the shadow table id
EXECUTE('UPDATE "' || @TableName || '" SET IdValue = ' || @ReturnValue || ' WHERE IdValue = (SELECT MAX(IdValue) FROM "' || @TableName || '")')
This forces the table to update an...
I suppose the problem isn't with uncommitted inserts, it's with the fact that the IDs are being used in different tables to where they came from. I'm using the shadow tables as sort of unique Id sequences/caches rather. The other tables that do inser...
