Problem with database loading

[Beuter Daniel]

Hello Community,
I still needs help.
My problem system is a mysql server with two databases intern und extern.
I have two other different servers which are data collectors we say server1
and server2. They load their data to the mysqlserver hourly.
Server1 writes in intern and server2 writes in extern.
So far so good.
But when they load at same time (in different databases!!!) the connection
of the later one hangs and is not able to load again in the db.
What might be the cause of this strange problem.
Is the mysql server not able to accept 2 write processes in different
databases?
How can I fix that problem. Now I have the only purpose to time the write
processes per cronjob :-(

P.S: The reading at same time is no problem while writing is on, If I read
from web-interface in the tables.
Thanxx for help


mit freundlichem Gruß / kind regards
Daniel Beuter

SIEMENS
I&S IT PS 221 OP4
Network Solutions
Werner von Siemens Str. 60
91052 Erlangen

Fon: +49 (9131) -6303-211
Fax: +49 (9131) 7-42234

mailto:[EMAIL PROTECTED]  
mailto:[EMAIL PROTECTED]  

Problem with database

[Emiliano Marmonti]

I have a site using PHP & Mysql. About a month ago to now one of the tables
gets corrupted with the message Got Error 127... I fix it and everything
works OK, except every time I loose 1 record.

Today I could obtain mysql.err from the machine and I could see whenever an
error is produced by date, previously I have the following line:

020205  9:57:46  Aborted connection 137 to db: 'Biblioteca' user: 'ODBC'
host: `localhost' (Server shutdown in progress)
020205  9:57:46  Aborted connection 124 to db: 'Biblioteca' user: 'ODBC'
host: `localhost' (Server shutdown in progress)
 or

020205 12:55:51  Aborted connection 377 to db: 'Biblioteca' user: 'ODBC'
host: `localhost' (Unknown error)
020205 13:05:37  Aborted connection 504 to db: 'Biblioteca' user: 'ODBC'
host: `localhost' (Unknown error)


It doesn´t seems too clear for me because no ODBC client should be accessing
to the database. Should I suppose that an unautorized ODBC client is
breaking the table or could be another problem?

Thanks a lot.
Emiliano.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Problem with database

[Emiliano Marmonti]

I have a site using PHP & Mysql. About a month ago to now one of the tables
gets corrupted with the message Got Error 127... I fix it and everything
works OK, except every time I loose 1 record.

Today I could obtain mysql.err from the machine and I could see whenever an
error is produced by date, previously I have the following line:

020205  9:57:46  Aborted connection 137 to db: 'Biblioteca' user: 'ODBC'
host: `localhost' (Server shutdown in progress)
020205  9:57:46  Aborted connection 124 to db: 'Biblioteca' user: 'ODBC'
host: `localhost' (Server shutdown in progress)
 or

020205 12:55:51  Aborted connection 377 to db: 'Biblioteca' user: 'ODBC'
host: `localhost' (Unknown error)
020205 13:05:37  Aborted connection 504 to db: 'Biblioteca' user: 'ODBC'
host: `localhost' (Unknown error)


It doesn´t seems too clear for me because no ODBC client should be accessing
to the database. Should I suppose that an unautorized ODBC client is
breaking the table or could be another problem?

Thanks a lot.
Emiliano.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php