Re: Bizarre InnoDB Error Message ( trx-active_trans == 0, but trx-conc_state != TRX_NOT_STARTED)

Jason, I am Cc:ing the MySQL General mailing list, so that others who bump into this bug can find this discussion. Jason J. W. Williams wrote: Mr. Tuuri, We have a high degree of UPDATE/INSERT concurrency along with high SELECTs. It causes a deadlock about once every 24 hours. In this case

trouble starting mysqld daemon

Hi! I'm a rookie, so bear with me... Keep getting: Starting mysqld daemon with databases from /opt/mysql/mysql/data Stopping server from pid file /opt/mysql/mysql/data/unknown.pid 061228 17:16:04 mysqld ended After this command bin/safe_mysqld --user=mysql Very open to suggestions

Re: trouble starting mysqld daemon

Check for .err text log files .. they are probably in /opt/mysql/mysql/data/ called servername.err servername is the hostname of your box. On Thu, 28 Dec 2006, Jeff Jones wrote: Hi! I'm a rookie, so bear with me... Keep getting: Starting mysqld daemon with databases from

Re: trouble starting mysqld daemon

Thanks! I think I'm in business. I changed some privileges, examined the logs (which helped a lot), and initialized the database again using mysql_install_db --user=mysql --datadir=/opt/mysql/mysql/data now onto PHP take care Jeff From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED]

Re: SQL syntax

- Original Message - From: Scott Yamahata [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, December 29, 2006 1:29 AM Subject: SQL syntax Hi, I'm getting the following error message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL