Hello list,
I'm using SapDb 7.4.3.32 on WinXp SP2.
I obtain an general error 9205.
What deos this error mean?
I can reproduce it in the next database schema:
CREATE TABLE "MOBILE"
(
"ID" Integer NOT NULL DEFAULT SERIAL,
"TSTAMP" Timestamp NOT NULL DEFAULT TIMESTAMP,
"ISSI" Integer NOT NULL UNIQUE,
"DESCR" Varchar(100) ASCII NOT NULL DEFAULT '',
PRIMARY KEY ("ID")
)
//
CREATE TABLE "MODULE"
(
"ID" Integer NOT NULL DEFAULT SERIAL,
"TSTAMP" Timestamp NOT NULL DEFAULT TIMESTAMP,
"SERIALNR" Varchar(30) ASCII NOT NULL UNIQUE,
"MOBILE_ID" Integer NOT NULL DEFAULT -1,
PRIMARY KEY ("ID"),
FOREIGN KEY "MOBILE_ID" ("MOBILE_ID")
REFERENCES "MOBILE" ("ID") ON DELETE SET DEFAULT
)
//
CREATE DBPROC TESTPROC (IN objId Integer) AS
SELECT 1 FROM ADMIN.DUAL;
//
CREATE TRIGGER MOBILE_DELETE FOR MOBILE AFTER DELETE EXECUTE
(
SELECT 1 FROM ADMIN.DUAL;
)
//
CREATE TRIGGER MODULE_UPDATE FOR MODULE AFTER UPDATE EXECUTE
(
CALL ADMIN.TESTPROC (:OLD.ID);
)
//
When I try:
INSERT MOBILE (ID, ISSI, DESCR) VALUES (1, 1000, 'Mobile1')
//
INSERT MODULE (SERIALNR, MOBILE_ID) VALUES ('01', 1)
//
DELETE MOBILE WHERE ID = 1
---- Error -------------------------------
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-9205 .
DELETE MOBILE WHERE ID = 1
Manual says:
-9001 to -9799: System error
Explanation:
These error messages should not occur during normal operation on a
consistent database. With some errors, an implicit SHUTDOWN is performed.
User Action:
As a rule, the database should be shut down and you should contact your
local support organization. Create a trace of the last database activities
and save it. Send the trace to your local support organization so they can
trace and rectify the error.
I know, this example is not very usefull,
but my real DB schema is much more complicated.
So I need such a chema: 2 tables with ref.integrity
with triggers and stored procedure call.
How to aviod this error?
Is it some bug?
Thank you, Dusan.
--
Dusan Kolesar
Helsinska 19
040 13 Kosice
Slovakia
e-mail : [EMAIL PROTECTED]
ICQ# : 160507424
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
