Hi, I have attached the result of the vtrace. I don't understand a word of its content ;-) ,but I hope the damage is reversible. The query I executed was: "select * from sys.all_tables" Thanx anyway for your interest.
Regards, Filip Sergeys On Mon, 2004-03-08 at 17:16, Becker, Holger wrote: > Filip Sergeys wrote: > > > All of a sudden it has become impossible for certain dbusers to select > > from tables in the sys schema. > > As a result, in sql studio, it is not possible to browse the > > tables list > > in the catalog manager. Also it is not possible in Ms Access > > to link to > > maxdb via odbc because we cannot get the list of tables. Al fail with > > exact the same error message. But the same user is still able > > to select > > data from his own tables. > > Now, the strange thing is that user dba still can select from > > tables in > > the sys schema and can connect with Ms Access. > > I checked the knldiag en knldiag.err files but there is > > nothing relevant > > about this in it. > > It seems to have started after I deleted a massive amount of data from > > the database (I deleted the primary key build up of 5 columns > > from a 10 > > million record table). This took very very long to run, that > > is the only > > indication I have. > > > > Where and how can I check what is happening. I already used the "check > > database structure ,..." in the Data Manager. It did not report any > > specific problems. > > > > The dbversion is 7.5.0 > > The OS is SuSE linux 9.0 Prof. > > Hi, > > it looks like a problem with the catalog information of the dbusers. > Please post a vtrace of a select with the error perhaps this will > bring some ligth into the darkness. > Information about vtrace and how to create it you'll find here: > http://sapdb.2scale.net/moin.cgi/VTrace > > Best regards, > Holger > SAP Labs Berlin -- *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* * System Engineer, Verzekeringen NV * * www.verzekeringen.be * * Oostkaai 23 B-2170 Merksem * * 03/6416673 - 0477/340942 * *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
