MySQL suddenly quits

[tariel]

When I want to add the data to one table, after clicking on a submit button, MySQL shows the message "DBUG: Test signal" and then it says that "this program has performed an illegal operation..." and it closes the connection. I tried to add the data both with a php script and with PhpMyAdmin - everywhere is the same result. What can I do about it ? It really annoying, since i can't continue my work further because of this problem.

[tomkleijkers]

I don't know what you're trying to parse but i think Mysql has been f*cked up. Try reinstalling mysql.

[tariel]

I don't know what you're trying to parse

nothing special , just a simple insert query :
"INSERT INTO ct_agenda (ct_agenda_id, ct_agenda_date, ct_agenda_time, ct_agenda_title, ct_agenda_desc, ct_pair_id, ct_centre_id) VALUES ('1', '2002-10-19', '10:00:00', 'introduction', 'introduction to the subject of the project', '1', '1'); "

After that MySQL says: "Lost connection to MySQL server during query."

[jordy]

does the mysql bin dies or safe_mysqld also? if so you might want to take a peek at the mysql error log.. if you find something intresting just post it here.

Had the same problem on one of the customers servers. the problem was the termination of mysql connections. To avoid this start the mysql server with the following command:

/safe_mysqld --open-files-limit=256

[tariel]

Thanks to everyone. I found the bug. 😃 The problem was that the table didn't have a primary key specified for some reason. But again it's a bit weird that MySQL reacted to this problem in a such way. It could just give an error