Hide Forgot
Description of problem: After some upgrades my website stops working. I'm using a scalable PHP app, with a MySql cartridge. I've installed Drupal on it. I think Drupal can no longer connect to the database, as when I use an alternate index.php file, it can be accessed. If I use Drupal's index.php file, I see the HAproxy page that shows an L7STS/500 error. I think it can no longer access the MySql cartridge, even though it's using openshift variables. http://ab-outpune.rhcloud.com/ Version-Release number of selected component (if applicable): How reproducible: Steps to Reproduce: 1. 2. 3. Actual results: Expected results: Additional info:
Figured out the problem. All my MySql settings got reset. I'd changed the log file sizes for INNODB in my.cnf, and MySql wouldn't start. Deleted the log files, and everythings working now. But, I can no longer edit my.cnf.
@aboutpune Can you let me know what settings you set and what you set them to? We can either make the values configurable or adjust them for everyone depending on the request.
I wanted tables to be created in INNODB by default, and I wanted to play around with the memory settings to get better performance. Since I was using a separate gear for the database, I wanted to allocate a sizable chuck of RAM to it. default-storage-engine = INNODB #INNODB # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high innodb_buffer_pool_size = 96M innodb_additional_mem_pool_size = 2M # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 24M innodb_log_buffer_size = 24M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50
Fixed with: https://github.com/openshift/origin-server/pull/3599 You'll need to run: rhc env set OPENSHIFT_MYSQL_DEFAULT_STORAGE_ENGINE=INNODB -a <myapp> && rhc cartridge restart -c mysql-5.1 -a <myapp> and all the other config is done by default for a mysql of a scaled app.
Commit pushed to master at https://github.com/openshift/origin-server https://github.com/openshift/origin-server/commit/160dd519f5f07128e7070b2e8264a6d9c381dc0f Bug 1002894
Checked on devenv_3773. Database engine variable OPENSHIFT_MYSQL_DEFAULT_STORAGE_ENGINE works. Default database engine is set according to this variable now. "MyISAM" if the var is not set. Other variables in my.cnf is set according to the app ( scaling/non-scaling). And for scaling app, the settings are the same as comment 3. Mark it as verified.
When testing against hotfix 2.0.33, I am unable to see the mysql folder in the app, that is, the ~/mysql folder. I am able to use mysql (adding tables and data) but the folder is gone. rhc app create php1s php-5.3 mysql-5.1 -s rhc env set OPENSHIFT_MYSQL_DEFAULT_STORAGE_ENGINE=INNODB -a php1s rhc cartridge restart -c mysql-5.1 -a php1s SSH to the app. No mysql folder: cat ~/mysql/conf/my.cnf mysql/conf/my.cnf: No such file or directory
@Chris Ryan With a scaled app, mysql is on a separate gear from php. I assume you are sshing to the HEAD gear with just php above.
Sorry, false alarm. You are correct, it was the HEAD gear.