It seems to be MySQL error. Please follow MySQL
documentation.
"Briggs, Gary" wrote:
>
> Fabulous!
>
> Well, it hasn't broken again yet, but If it does...
>
> Hmmm.
>
> At the same time, though, I'm getting the following error:
>
> <snip>
> Can't create a new thread (errno 11). If you are not out of available
> memory, you can consult the manual for a possible OS-dependent bug
> <snip>
>
> The machine I'm running this on has 4G of virtual memory. I'm NOT out of
> available memory. And it's solaris 2.6.
>
> My my.cnf file contains the following:
>
> [client]
> port = 54000
> socket = /tmp/mysql.sock
>
> [mysqld]
> port = 54000
> socket = /tmp/mysql.sock
> #set-variable = max_allowed_packet=4M
> set-variable = wait_timeout=120
> set-variable = flush_time=200
> set-variable = key_buffer=124M
> set-variable = table_cache=512
> set-variable = sort_buffer=16M
> set-variable = record_buffer=12M
>
> [isamchk]
> set-variable = key_buffer=16M
>
> Am I missing something really obvious?
>
> Thank-you very much,
> Gary (=
>
> > -----Original Message-----
> > From: Shane Wegner [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, March 08, 2001 10:56 PM
> > To: [EMAIL PROTECTED]
> > Subject: patch: limit MySQL insert packets
> >
> > Hi,
> >
> > The default MySQL max packet length is 1mb. Often this
> > length can be exceeded as Mnogosearch is now using extended
> > inserts. This patch limits insert queries into dict tables
> > to 512k. Applies against Mnogosearch 3.11.
> >
> > --- sql.c.orig Thu Mar 8 13:48:58 2001
> > +++ sql.c Thu Mar 8 14:10:46 2001
> > @@ -2251,6 +2251,18 @@
> >
> > sprintf(qe,"(%d,%d,%d)",url_id,UdmStrCRC32(Indexer->Word[i].word),Indexer-
> > >Word[i].count);
> > }
> > qe=qe+strlen(qe);
> > + /* Insert 512k packets max to stay *
> > + * under MySQL's default limit. */
> > + if (strlen(qb) >= 512000){
> > + sql_query(Indexer,qb);
> > +
> > if(UdmDBErrorCode(Indexer->db))return(IND_ERROR);
> > +
> > if(Indexer->Conf->DBMode==UDM_DBMODE_MULTI)
> > + sprintf(qb,"INSERT INTO %s
> > (url_id,word,intag) VALUES ",tbl_nm);
> > + else
> > + sprintf(qb,"INSERT INTO %s
> > (url_id,word_id,intag) VALUES ",tbl_nm);
> > + qe=qb+strlen(qb);
> > + have_words = 0;
> > + }
> > }
> > }
> > if(have_words){
> >
> >
> > --
> > Shane Wegner: [EMAIL PROTECTED]
> > http://www.cm.nu/~shane/
> > PGP: 1024D/FFE3035D
> > A0ED DAC4 77EC D674 5487
> > 5B5C 4F89 9A4E FFE3 035D
> > ___________________________________________
> > If you want to unsubscribe send "unsubscribe general"
> > to [EMAIL PROTECTED]
> >
> ___________________________________________
> If you want to unsubscribe send "unsubscribe general"
> to [EMAIL PROTECTED]
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
