From: Anhaus, Thomas (thomas.anhaussap.com)
Date: Tue Oct 04 2005 - 03:21:45 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Carlos Yabut wrote :

>
>-----Original Message-----
>From: Carlos Yabut [mailto:c_yabutyahoo.com]
>Sent: Saturday, October 01, 2005 9:37 AM
>To: maxdblists.mysql.com
>Subject: 9205 error
>
>I am having the same problem as the one i reported
>about 3 months ago. I got disctracted but I thought it
>would be fixed with the newest release. I am now using
>MAXDB 7.6.0.12. My existing set up is SAPDB 7.4.0.3.
>I did a complete backup using the database manager of
>a database i created with this server. And then I
>restored the backup the the new 7.6.0.12 server. After
>I updated the SYSTEM TABLES I am getting the following
>error.
>
>Auto Commit: On, SQL Mode: Internal, Isolation Level:
>Committed
> General error;-9205 POS(1) System error: AK Catalog
>information not found:0000000000000000007200
>SELECT DISTINCT schemaname FROM domain.triggers WHERE
>TRIGGERNAME LIKE '%'
>
>I need to move to the new version to take advantage of
>your SYNC option.
>
>thanks
>

I fear it will not be possible to fix the problem just by
a new release, because it seems that there's some inconsistency inside
the
persistent part of the catalog.
Please send me a trace of the select statement that produces the error.
Maybe it's possible to identify the corresponding trigger or table and
to drop and recreate it afterwards.

Best Regards,
Thomas

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]