Здравствуйте
After upgrading mysql server from 4.1.3beta to 4.1.9 (FreeBSD 4.8, mysql is installed from ports) I sometimes have the following problem: when some perl client tries to execute INSERT or UPDATE query via DBD::mysql it from time to time (but NOT always ) gets error 1036 (Table 'XXXXXX' is read only). Meanwhile: 1) Mysql user who tries to execute a query has all necessary priveleges 2) File system priveleges are also correctly set. mysqld runs under user mysql. Mysql datadir and ALL database files are owned by it and have 770 privilege mask. 3) The problem refers to MANY tables in different databases, but does NOT turn up systematicaly (by random from time to time). 4) Dumping and restoring problem tables did not solve the case 5) Upgrading DBD and DBI did not help either -- Сергей Аверьянов Руководитель отдела техподдержки ЗАО "Портал" mailto:[EMAIL PROTECTED] icq: 346192719 http://www.portalsoft.ru -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
