vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| --0__=88BBE515DFE3E7248f9e8a93df938690918c88BBE515DF E3E724 Content-type: multipart/alternative; Boundary="1__=88BBE515DFE3E7248f9e8a93df938690918c 88BBE515DFE3E724" --1__=88BBE515DFE3E7248f9e8a93df938690918c88BBE515DF E3E724 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable R u getting this error while starting up the instance ? If yes, run the following command: $ > getprivgrp It should show something like: global privileges: CHOWN informix: MLOCK If not, then the problem is that informix user does not have MLOCK privileges to work with Async I/O. In order to fix this problem do the following: 1. Log in as root user 2. Create a file /etc/privgroup and then add the following line in the file: <groupname> MLOCK (where groupname is the group to which informix belongs to) 3. Execute the following cmd: $> setprivgrp -f /etc/privgroup 4. Verify whether its done it right or not. $ > getprivgrp Also, verify whether you are actually running out memory or not ? HTH Thanx much Rajib Sarkar Advisory Software Engineer DB2/UDB Regional Advanced Support IBM Data Management Group If we all did the things we are capable of doing, we would literally astound ourselves. -- T. Edison = sshumilov@gmail.c = om = Sent by: = To owner-informix-li informix-list@iiug.org = st@iiug.org = cc = Subj= ect 01/11/2005 10:56 hpkaioaddseg: ASYNC_ADDSEG faile= d, AM errno =3D 1 --> please help = = = Please respond to = sshumilov = = = Hi everybody! we tried to increase the size of SHMVIRTSIZE previously it was 94000 and SHMADD 8000 I tried to change SHMVIRTSIZE to 110000 and got an error... 18:42:36 HPUX Version B.11.00 -> Using flag/select style KAIO 18:42:36 hpkaioaddseg: ASYNC_ADDSEG failed, errno =3D 1 18:42:36 hpkaioaddseg: ASYNC_ADDSEG failed, errno =3D 1 18:42:37 Assert Failed: kaiothread() ERROR 18:42:37 Informix Dynamic Server Version 7.30.UC6 18:42:37 Who: Session(0, @, 0, 0) Thread(139, kaio, 0, 5) File: kaio.c Line: 2048 18:42:37 stack trace for pid 18065 written to /tmp/af.8b808c 18:42:37 Assert Failed: kaiothread() ERROR 18:42:37 Informix Dynamic Server Version 7.30.UC6 18:42:37 Who: Session(1, informix@dserver, 0, 0) Thread(140, kaio, 0, 1) File: kaio.c Line: 2048 18:42:37 stack trace for pid 18061 written to /tmp/af.8c808c 18:46:29 See Also: /tmp/af.8c808c 18:46:29 kaio.c, line 2048, thread 140, proc id 18061, kaiothread() ERROR. 18:46:29 PANIC: Attempting to bring system down 18:46:37 Segment locked: addr=3D0xc2f35000, size=3D543285248 can anyone tell me what it means and how can I increase the size of SHMVIRTSIZE because we get a lot of extents... Thank you in advance!!! Sergey = --1__=88BBE515DFE3E7248f9e8a93df938690918c88BBE515DF E3E724 Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> <p>R u getting this error while starting up the instance ?<br> <br> If yes, run the following command:<br> <br> $ > getprivgrp<br> <br> It should show something like:<br> global privileges: CHOWN<br> informix: MLOCK<br> <br> If not, then the problem is that informix user does not have MLOCK priv= ileges to work with Async I/O. In order to fix this problem do the foll= owing:<br> <br> 1. Log in as root user<br> 2. Create a file /etc/privgroup and then add the following line in the = file:<br> <groupname> MLOCK (where groupname is the group to which inf= ormix belongs to)<br> <br> 3. Execute the following cmd:<br> <br> $> setprivgrp -f /etc/privgroup<br> <br> 4. Verify whether its done it right or not.<br> <br> $ > getprivgrp<br> <br> Also, verify whether you are actually running out memory or not ?<br> <br> HTH<br> <br> Thanx much<br> Rajib Sarkar<br> Advisory Software Engineer<br> DB2/UDB Regional Advanced Support<br> IBM Data Management Group<br> <br> <br> If we all did the things we are capable of doing, we would literally as= tound ourselves. -- T. Edison<br> <br> <img src=3D"cid:10__=3D88BBE515DFE3E7248f9e8a93df938@us .ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for sshumilov@gmail.com= ">sshumilov@gmail.com<br> <br> <br> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D88BBE51= 5DFE3E7248f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul><b><font size=3D"2">sshumilov@gmail.com</font></b><font size=3D"2">= </font><br> <font size=3D"2">Sent by: owner-informix-list@iiug.org</font> <p><font size=3D"2">01/11/2005 10:56 AM</font> <table border=3D"1"> <tr valign=3D"top"><td width=3D"168" bgcolor=3D"#FFFFFF"><div align=3D"= center"><font size=3D"2">Please respond to<br> sshumilov</font></div></td></tr> </table> </ul> </ul> </ul> </ul> </td><td width=3D"60%"> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE515DFE3E7248f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D88BBE515DFE3E7248f9e8a93df938@us .ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">informix-list@iiug.org</font></td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE515DFE3E7248f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D88BBE515DFE3E7248f9e8a93df938@us .ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> </td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE515DFE3E7248f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt= h=3D"100%"><img src=3D"cid:30__=3D88BBE515DFE3E7248f9e8a93df938@us .ibm.= com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">hpkaioaddseg: ASYNC_ADDSEG failed, errno =3D 1 --> = please help</font></td></tr> </table> <table border=3D"0" cellspacing=3D"0" cellpadding=3D"0"> <tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D88BBE515DFE3= E7248f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt= =3D""></td><td width=3D"336"><img src=3D"cid:30__=3D88BBE515DFE3E7248f9= e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><= /td></tr> </table> </td></tr> </table> <br> <tt>Hi everybody!<br> <br> we tried to increase the size of SHMVIRTSIZE<br> previously it was 94000 and SHMADD 8000<br> I tried to change SHMVIRTSIZE to 110000 and got an error...<br> <br> 18:42:36 HPUX Version B.11.00 -> Using flag/select style= KAIO<br> 18:42:36 hpkaioaddseg: ASYNC_ADDSEG failed, errno =3D 1<br> 18:42:36 hpkaioaddseg: ASYNC_ADDSEG failed, errno =3D 1<br> 18:42:37 Assert Failed: kaiothread() ERROR<br> 18:42:37 Informix Dynamic Server Version 7.30.UC6 <br> 18:42:37 Who: Session(0, @, 0, 0)<br> Thread(139, kaio, 0, 5)<br> File: kaio.c Line: 2048<br> 18:42:37 stack trace for pid 18065 written to /tmp/af.8b808c<br> 18:42:37 Assert Failed: kaiothread() ERROR<br> 18:42:37 Informix Dynamic Server Version 7.30.UC6 <br> 18:42:37 Who: Session(1, informix@dserver, 0, 0)<br> Thread(140, kaio, 0, 1)<br> File: kaio.c Line: 2048<br> 18:42:37 stack trace for pid 18061 written to /tmp/af.8c808c<br> 18:46:29 See Also: /tmp/af.8c808c<br> 18:46:29 kaio.c, line 2048, thread 140, proc id 18061, kaiothread= ()<br> ERROR.<br> 18:46:29 PANIC: Attempting to bring system down<br> 18:46:37 Segment locked: addr=3D0xc2f35000, size=3D543285248 <br>= <br> can anyone tell me what it means and how can I increase the size of<br>= SHMVIRTSIZE because we get a lot of extents...<br> <br> Thank you in advance!!!<br> <br> <br> Sergey<br> </tt><br> </body></html>= --1__=88BBE515DFE3E7248f9e8a93df938690918c88BBE515DF E3E724-- --0__=88BBE515DFE3E7248f9e8a93df938690918c88BBE515DF E3E724 Content-type: image/gif; name="graycol.gif" Content-Disposition: inline; filename="graycol.gif" Content-ID: <10__=88BBE515DFE3E7248f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYX J0U2F2ZXIhAAA7 --0__=88BBE515DFE3E7248f9e8a93df938690918c88BBE515DF E3E724 Content-type: image/gif; name="pic18640.gif" Content-Disposition: inline; filename="pic18640.gif" Content-ID: <20__=88BBE515DFE3E7248f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZe ZgLVA9YVCpnGagVjV171aRVrYR RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFil KQdI8GA5IcpApeJQt8L09lmgkH LZikoU5wjqcyAMMFrJIDPAKvCFletKSev1HBw8KrxtjZ2tvc3d 5VyKtCKW3jfz4uMKmq3xu4N0nK BVoJQmx2LGVOmrqNjjJf2hHAQo/eDwJGTKhQMcgQEEAnEjFS98+RnW3smGkZU6ncCWav/4wYOnAI TihRL/4FEwbp28BXMMcoscQCVxlepL4IGDSCyJyVQOu0o7CjmLN50OZl qWmyFy5/6yBBuji0AxFR M00oQAqNIstqI6qKHUsWRAEAvagsmfUEAImyxgbmUpJk3IklNU tJOUAVLoUr1+wqDGTE4zk+T6FG uQb3SizBCwatiiUgCBN8vrz+zFjVyQ8FWkOlg4NQiZMB5QS8QO 3mpOaKnL0Z2EKvNMSILEThKhCg zMKPVxYJh23qm9KNW7pArPynMqZDiErsTMqI+LRi3QAgkFUbXp uFKhSYZALd0O5RKa2z9EYKBbpb qxIKsjUPRgD7I2XYV6wyrOw92ykExP8NW4URhknC5dKGE4v4NE NQj2jXjmfNgOZDaXb5glRmXQ33 YEWQYNcZFnrYcIQLNzyTFDQNkXIff0ExVlY4srziQk43inZgL4 rwxxINMvpFFAz1KOODHiu+4aEw NEjFl5B3JIKWKF3k6I9bfUGp5ZZcdunll5IA4cuHvQQJ5gcsoC WOOUwgltIwAKRxJgbIkJAQZEq0 2YliZnpZZ4BH3CnYOXldOUOfQoYDqF1LFHbXCrO8xmRsfoXDXJ 6ChjCAH3QlhJcT6VWE6FCkfCco CgrMFsROrIEX3o2whVjWDjoJccN3LdggSGXLCdLEgHr1lyU3O3 QxhgohNKXJCWv8JQr/PDdaqd6w 2rj1inLiGeiCJoDspAoQlYE6QWLSECehcWIYxIQES6zhbn1iIm THEQyqJ4eIxJJoUBc+3CbBuwZE V5cJPPkIjFDdeEabQbd6WgICTxiiz0f5dBKquXF6k4senwEhYG nKEFJeGrxUZy8dB8gmAXI/sPvH ESfCwVt5hTgYiqQqtdRNHQIU1PJ33ZqmzgE90OwLaoJcnMop1W iMmgkPHQRIrwgFuNV90A3doNKT mrKIN07AnGcI9BQjhCBN4RfA1qIZnMqorJCogKfGQnxSCDilTV IA0yl5ciTovgLuBDKFUDE9aQcw 9SA+rjSNf9/M1gxrj6VwDTS0IUSElMzBfsj0NFXR2kwsV1A5IF1grLgLL/r1R40BZEnuBWgmQEyb jqRwSAt6bqMCOFkvKFN2GPPkUzIm/SCF8z8pVzpbjVnMsy0vOr1hw3SaSRUhpY09v0z0J1FnwzPl fmh+xl4WtR0zGu24I4KbMQm3lnVu2oNWxI9W/lcyzA+mCKF4DBikxb/+UWtOGRiFP8qEwAayIgIA Ow== --0__=88BBE515DFE3E7248f9e8a93df938690918c88BBE515DF E3E724 Content-type: image/gif; name="ecblank.gif" Content-Disposition: inline; filename="ecblank.gif" Content-ID: <30__=88BBE515DFE3E7248f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAABAIAAAAAAAP///yH5BAEAAAEALAAAAAAQAAEAAAIEjI8ZBQA7 --0__=88BBE515DFE3E7248f9e8a93df938690918c88BBE515DF E3E724-- sending to informix-list |