Once my scalr server runs for a day or so, instance always remained in a pending state. After trouble shooting various touch points, I finally figured out it is a strange issue with MySQL.
Here is what happens: 1. The message sent from the scalarizr on the instance is received by the scalr server. 2. The message is also logged in the syslog table. 3. The control queue handler runs an insert statement on the database table messages. 4. The insert is successful and there is no exception, BUT the data is not present in the messages table! I ran phpmysqladmin and connected to the database. Then ran the sql statement to insert the data. A successful message was displayed and row id was displayed. However the DATA WAS NOT IN the table, select * returned empty table. I then restarted mysqld and everything was fine! The issue seems to be inserts into the messages table are not succeeding for some reason once mysqld has been running for some time (typically overnight) My setup: Centos 5.6, PHP 5.3.10 and MySQL 5.5.20 (I got the php from the remi repo and the mysql-libs from remi have a dependency on mysql5 from the remi repo, so had to install the mysql 5.5 server from there) The my.cnf file had minimum settings as below: ------------------------------------------ [mysqld] user=mysql datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid -------------------------------------------------------------------------- Any ideas? Thanks for your help on this, really appreciate it. Unless I fix this I am stuck :( Cheers Srini -- You received this message because you are subscribed to the Google Groups "scalr-discuss" group. To view this discussion on the web visit https://groups.google.com/d/msg/scalr-discuss/-/XCr2cBaVcFgJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/scalr-discuss?hl=en.
