Bizzare sqlerror codes 
Author Message
 Bizzare sqlerror codes

HELP!!!

I put a multiple user order entry system on line 4 weeks ago.  Since then I've
started getting very strange errors that didn't show up in testing. (Do they
ever?) I'm getting a mixed bag of

              -46  Protocol family not supported
              -113 The file is locked
              -242 could not open database table
              -311 Cannot open system catalog  

The -113 and -242 errors happen on tables that are "read only" reference tables.
Therefore, I can't figure out why the entire table would be locked. What could
make it impossible to open the system catalog?  I don't even have error -46
in my Informix manual.  What is it?

I suspect that these errors are only a symptom of some other problem.
Unfortunately, I can't figure out what to even look for |-(.  Any ideas from
out in netland?  The occurence of these errors are increasing in frequency and
I need all the help I can get.

BTW: I am running Informix 4.0 and SCO UNIX 3.2 on a Compaq SystemPro/486

Thanks in advance for the help!!

Patrice Badger
Mediatech Inc.

Tel:    312-828-9223 x293
FAX:    312-828-0982



Sun, 16 Oct 1994 01:18:04 GMT
 Bizzare sqlerror codes


writes:
|>               -46  Protocol family not supported
|> I don't even have error -46
|> in my Informix manual.  What is it?

That's because it's a Unix error that's just being passed on by Informix.
I believe the protocol family it's referring to is the network protocol,
indicating that something isn't configured correctly for a network request.

That's as far as I can go: I don't use networked versions of Informix :-(

Good Luck!

--
Harry Bochner



Sun, 16 Oct 1994 05:22:57 GMT
 Bizzare sqlerror codes
->From: uunet!mediatech.COM!patrice (Patrice Badger)
->Subject: Bizzare sqlerror codes
->Date: Tue, 28 Apr 92 11:25:13 CDT

->X-Informix-List-Id: <list.1113>
->
->I put a multiple user order entry system on line 4 weeks ago.  Since then I've
->started getting very strange errors that didn't show up in testing. (Do they
->ever?) I'm getting a mixed bag of
->
->              -46  Protocol family not supported
->              -113 The file is locked
->              -242 could not open database table
->              -311 Cannot open system catalog
->
->The -113 and -242 errors happen on tables that are "read only" reference tables.
->Therefore, I can't figure out why the entire table would be locked. What could
->make it impossible to open the system catalog?  I don't even have error -46
->in my Informix manual.  What is it?
->
->I suspect that these errors are only a symptom of some other problem.
->Unfortunately, I can't figure out what to even look for |-(.  Any ideas from
->out in netland?  The occurence of these errors are increasing in frequency and
->I need all the help I can get.
->
->BTW: I am running Informix 4.0 and SCO UNIX 3.2 on a Compaq SystemPro/486

You need to read some of the documentation in the release directory
provided with the Informix software.  You don't say so, but you are using
Standard Engine.  On BSD machines, error -46 is as printed above, and error
-79 is "No record locks available".  On System V machines, the error number
-46 should be translated as "No record locks available".

All these problem clearly point to a requirement to reconfigure the kernel
with an increased number of locks.  How many you actually need depends on
the workload; I would double the exsiting number, and keep doing so until
the problem went away.  If feeling very virtuous, I might then back off the
last figure -- more likely, I'd be too busy on the next job to do more than
be thankful that the problem's gone away.

Yours,



Sun, 16 Oct 1994 23:43:12 GMT
 Bizzare sqlerror codes
[stuff deleted]

Quote:
>ever?) I'm getting a mixed bag of

>              -46  Protocol family not supported

I've had this one too!!

Error numbers below 100 are UNIX errors.  Look at the file
/usr/include/sys/errno.h.  On our SCO box we find the line:

#define ENOLCK  46      /* No record locks available.           */

which seems to indicate that you have locking problems.

Regards,
--

Co-Cam Computer Group, Abbotsford, Vic.



Mon, 17 Oct 1994 06:28:15 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. JDBC Emit SQLError code for communication errors

2. JDBC Emit SQLError code for communication errors

3. Bizzare result

4. Bizzare Miscalculation

5. Bizzare EM error #1056

6. Bizzare problem with variables used in joins

7. Bizzare Performance problem

8. Bizzare problems with datbases?!?

9. Bizzare ADO Recordset issue

10. bizzare problem

11. VB4 Invalid Page Fault with bizzare text formatting

12. GUI, Java, Oracle, Bizzare errors, Please HELP!


 
Powered by phpBB® Forum Software