|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
RE: A bit strange! - General error;-8 POS(1) Execution failed, pa rse again.
From: Filip Sergeys (filip.sergeys
verzekeringen.be)
Date: Mon Mar 08 2004 - 11:04:30 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]