Skip to Content
0
Former Member
Dec 07, 2009 at 10:30 AM

What went wrong ?

247 Views

Dear all,

I`m trying to figure out what went wrong with my database.

During the higher load the users were suddenly getting DBIF_RSQL_SQL_ERROR, no matter what they wanted to do. When checking system I found many messages like:

Database error -1000 at OPC access to table REPOLOAD

> POS(1) Too many lock requests

> Include ??? line 0000.

Run-time error "DBIF_REPO_SQL_ERROR" occurred

Run-time error "DBIF_RSQL_SQL_ERROR" occurred

Database error -1000 at OPC

> POS(1) Too many lock requests

Database error -1000 at OPC

> POS(1) Too many lock requests

Database error -1000 at OPC

> POS(1) Too many lock requests

Database error -1000 at EXE

> POS(1) Too many lock requests

According to documentation I found error -1000:

1000: Too many lock requests

Explanation

There are too many locks or lock requests.

User Request

You can try to repeat the SQL statement at a later time or cancel the transaction. If this situation occurs frequently, then the MAXLOCKS general database parameter is too small and should be increased

Database kernel showed following messages:

2009-12-07 16:04:18 8126 ERR 5 Catalog Catalog update failed,IFR_ERROR=-1000,DESCRIPTION=UNDEFINED

2009-12-07 16:05:13 8170 ERR 5 Catalog Catalog update failed,IFR_ERROR=-1000,DESCRIPTION=UNDEFINED

2009-12-07 16:10:13 8182 ERR 5 Catalog Catalog update failed,IFR_ERROR=-1000,DESCRIPTION=UNDEFINED

2009-12-07 16:15:09 8229 ERR 5 Catalog Catalog update failed,IFR_ERROR=-1000,DESCRIPTION=UNDEFINED

2009-12-07 16:15:13 8123 ERR 5 Catalog Catalog update failed,IFR_ERROR=-1000,DESCRIPTION=UNDEFINED

So do you think it is just about MAXLOCKS parameter or also with catalog cache sizing could be wrong ?

Version : MaxDB 7.6.6.7.

Thank you for your comments.

Pavol