At 09:42 AM 5/18/2007, you wrote:
Hi,
It seems to be the Hardware somehow. I tested on another Machine with same
OS,
and everything seems to run now. I am using the same Memory so this is not
the
problem. Both Machines have hardware raid. The only thing left is the
mainboard. Verrrry ugly.
Cheers,
Christoph
Christoph,
Have you tried replacing the network card with the one from the
working machine? Network cards can cause problems under high load but will
appear fine otherwise. Cheers.
Mike
On Friday 18 May 2007 16:48:36 mos wrote:
> Christoph,
> I don't know if this helps or not, but I had a similar problem
> a few years back on a Windows machine. Memory kept getting corrupted and I
> traced the problem to Intel Accelerator that I had running. Intel only
> admitted to the problem with their software months later. My advice is to
> remove every unnecessary service that is running on your client machine and
> server. Also run analysis on your drive to make sure the sectors are ok. It
> is also possible to have bad memory so if you could swap out the memory or
> get it hardware tested, that would help too. If it still fails, put the
> server on a different machine and run the client on the same machine in
> order to eliminate the hardware.
>
> Mike
>
> At 07:33 AM 5/18/2007, you wrote:
> >Hi everybody,
> >
> >On Friday 18 May 2007 14:50:55 Brent Baisley wrote:
> > > You may be running into file system file size "limits". You would need
> > > to make sure the file system you are using is set to handle files
> > > larger than 4GB, in addition, you need to check that the account mysqld
> > > us running under is allowed to create files larger than 4GB. Just
> > > because the OS and file system can handle and access large memory/file
> > > configurations, it doesn't mean the user accounts are permitted to.
> >
> >There are no big databases:
> >sql:~# du -hs /var/lib/mysql
> >1,4G /var/lib/mysql
> >
> >I am using ext3 as Filesystem and don't get any errors from mysql which
> >say that there might be problems with filesize.
> >
> >Some is more info:
> >
> >After doing 1000 inserts , I get the following:
> >
> >mysql> check table community_msgin;
> >+-------------------------+-------+----------+----------------------------
> >------------------+
> >
> >| Table | Op | Msg_type |
> >
> >Msg_text |
> >+-------------------------+-------+----------+----------------------------
> >------------------+
> >
> >| g.community_msgin | check | warning | Table is marked as
> >
> >crashed |
> >
> >| g.community_msgin | check | error | Wrong bytesec: 0-0-0 at
> >
> >linkstart: 416860428 |
> >
> >| g.community_msgin | check | error |
> >
> >Corrupt |
> >+-------------------------+-------+----------+----------------------------
> >------------------+ 3 rows in set (5.80 sec)
> >
> >
> >Then I do a repair:
> >
> >mysql> repair table community_msgin;
> >+-------------------------+--------+----------+---------------------------
> >-----------------------+
> >
> >| Table | Op | Msg_type |
> >
> >Msg_text |
> >+-------------------------+--------+----------+---------------------------
> >-----------------------+
> >
> >| g.community_msgin | repair | info | Wrong bytesec: 0- 0- 0 at
> >
> >416860428; Skipped |
> >
> >| g.community_msgin | repair | info | Wrong bytesec: 0- 0- 0 at
> >
> >416960348; Skipped |
> >
> >| g.community_msgin | repair | warning | Number of rows changed from
> >
> >1143479 to 1143474 |
> >
> >| goolive.community_msgin | repair | status |
> >
> >OK |
> >+-------------------------+--------+----------+---------------------------
> >-----------------------+ 4 rows in set (19.36 sec)
> >
> >Then the table is OK until I insert again.
> >
> >Cheers,
> > Christoph
> >
> > > I'm guessing you are doing a sort on a large dataset and the OS is
> > > stopping you once the sort file reaching the file size limit for the
> > > user account.
> >
> >--
> >NMMN - New Media Markets & Networks GmbH
> >Geschäftsführung: Kfm. Michael Schütt
> >Finanzamt HH-Altona UStID DE 812 699 852 HRB 71102 Hamburg
> >HypoVereinsbank - BLZ 200 300 00 - Konto-Nr. 156 29 82
> >
> >http://www.nmmn.com Tel.: +49 40 284 118 -0
> >Langbehnstrasse 6 Technische Hotline -700
> >22761 Hamburg Fax: -999
> >
> >Rufen Sie uns kostenlos an: http://www.nmmn.com/call/technik
> >
> >--
> >MySQL General Mailing List
> >For list archives: http://lists.mysql.com/mysql
> >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
NMMN - New Media Markets & Networks GmbH
Geschäftsführung: Kfm. Michael Schütt
Finanzamt HH-Altona UStID DE 812 699 852 HRB 71102 Hamburg
HypoVereinsbank - BLZ 200 300 00 - Konto-Nr. 156 29 82
http://www.nmmn.com Tel.: +49 40 284 118 -0
Langbehnstrasse 6 Technische Hotline -700
22761 Hamburg Fax: -999
Rufen Sie uns kostenlos an: http://www.nmmn.com/call/technik
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
