Hello,
After migration from 7.3 to 7.5.0.30 I keep receiving
"General error;-9404 POS(1) System error: AK System error: VAK724 1"
after executing the query below, which is very similar to
http://archives.neohapsis.com/archives/dev/sapdb/2005-q1/0830.html
I did a quick search and it seems to me that the bug was already fixed,
as we can read at:
http://dev.mysql.com/doc/maxdb/changes/changes_7.5.00.26.html
I have also tried to set OPTIM_INV_ONLY parameter to 'No" but
it hasn't helped either.
The query is:
SELECT DISTINCT
R.REC_ID, R.REQUEST_ID
FROM
TALD_ADMIN.CONTACTS C,TALD_ADMIN.CONTACTS Z, TALD_ADMIN.REQUESTS R
WHERE
(Z.CONTACT_ID = R.CALLER_ID)
AND (C.CONTACT_ID = R.CONTACT_ID)
AND (((STATUS_ID='ZAMKNIÊTE')
AND(CLOSE_DATE <=SUBDATE(DATE,90)
AND CLOSE_DATE IS NOT NULL ))
OR ((OPEN_DATE <=SUBDATE(DATE,90)) AND STATUS_ID='ANULOWANE'))
and the EXPLAIN for it gives me:
C INDEX002 INDEX SCAN 141
ONLY INDEX ACCESSED
R IDX_CONTACT_ID JOIN VIA INDEXED COLUMN 3634
Z INDEX002 JOIN VIA INDEXED COLUMN 141
NO TEMPORARY RESULTS CREATED
RESULT IS COPIED , COSTVALUE IS 5349
what looks rather OK.
Has anyone any idea what could be the reason for this error and how to
workaround it?
Best regards,
Marcin Pytel
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
