Srini, Scalr was never tested on MySQL 5.5 . This mentions in our wiki - scalr requires MySQL 5.1.X. Maybe this is an issue.
Regards, Igor On 14 March 2012 15:50, Srini <[email protected]> wrote: > 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. -- You received this message because you are subscribed to the Google Groups "scalr-discuss" group. 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.
