Hi Robert,
First of all thank you for a grails plugin that perfectly fills a gap
in the app stack for a number of our projects. The ability to mix
groovy logic with database operations while keeping track of executed
changes really enables us to go crazy with database refactorings
between versions (and for those wondering: yes, that is a good thing)
I have two questions regarding autobase:
1. We're running grails 1.0.4 and are thus currently restricted to
autobase 0.7. When I start our app in 0.7, autobase writes out about
seventy lines of logging. This happens even if the migration in
question has already been run. I've tried to set log4j such as:
sun {
reflect="error"
}
liquibase="error"
but am still getting a boatload of logging. I'm pasting an example at
the bottom of this email. It would be nice if there was a way to tell
autobase to not do any messaging if it's not actually executing
anything. Worth mentioning here is that I have about 30 migrations and
all of them have preconditions.
2. As the above issue was getting to me, I tried upgrading to grails
1.1 and autobase 0.8.x. I installed the autobase plugin from the
plugin repo with an "grails install-plugin autobase" without versions.
This resulted in errors when the plugin was trying to read migration
files from the '.svn' subversion tracking directories under my
migrations directory. There is a bug report marked as fixed here
http://jira.codehaus.org/browse/GRAILSPLUGINS-673, but as far as I can
understand the error still exists in the plugin you get by just
running install-plugin in grails.
Any help on either of the above much appreciated.
Best,
Matias Bjarland
------------ sample of log output in 0.7 ---------------
20090224-12:22:01,421 INFO GrailsWebApplicationContext: Bean factory
for application context
[org.codehaus.groovy.grails.commons.spring.GrailsWebApplicationContext@1af45f4]:
org.springframework.beans.factory.support.DefaultListableBeanFactory@1c9de24
Feb 24, 2009 12:22:04 PM liquibase.database.template.JdbcTemplate
comment
INFO: Lock Database
Feb 24, 2009 12:22:04 PM liquibase.lock.LockHandler acquireLock
INFO: Successfully acquired change log lock
Feb 24, 2009 12:22:04 PM sun.reflect.NativeMethodAccessorImpl invoke0
INFO: Including directory file://Y:/svn/mrgrails/trunk/migrations/Mbjarland
Feb 24, 2009 12:22:04 PM sun.reflect.NativeMethodAccessorImpl invoke0
INFO: Including file file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_account_Migration.groovy
Feb 24, 2009 12:22:05 PM sun.reflect.NativeMethodAccessorImpl invoke0
INFO: Including file
file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_account_view_Migration.groovy
Feb 24, 2009 12:22:05 PM sun.reflect.NativeMethodAccessorImpl invoke0
INFO: Including file
file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_content_location_Migration.groovy
Feb 24, 2009 12:22:05 PM sun.reflect.NativeMethodAccessorImpl invoke0
INFO: Including file file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_content_Migration.groovy
Feb 24, 2009 12:22:05 PM sun.reflect.NativeMethodAccessorImpl invoke0
INFO: Including file
file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_distro_file_Migration.groovy
Feb 24, 2009 12:22:05 PM sun.reflect.NativeMethodAccessorImpl invoke0
INFO: Including file file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_email_Migration.groovy
Feb 24, 2009 12:22:05 PM sun.reflect.NativeMethodAccessorImpl invoke0
INFO: Including file file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_folder_Migration.groovy
Feb 24, 2009 12:22:05 PM sun.reflect.NativeMethodAccessorImpl invoke0
INFO: Including file
file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_folder_state_Migration.groovy
Feb 24, 2009 12:22:05 PM sun.reflect.NativeMethodAccessorImpl invoke0
INFO: Including file file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_format_Migration.groovy
Feb 24, 2009 12:22:05 PM sun.reflect.NativeMethodAccessorImpl invoke0
INFO: Including file
file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_group_member_Migration.groovy
Feb 24, 2009 12:22:05 PM sun.reflect.NativeMethodAccessorImpl invoke0
INFO: Including file
file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_group_permission_Migration.groovy
Feb 24, 2009 12:22:05 PM sun.reflect.NativeMethodAccessorImpl invoke0
INFO: Including file
file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_http_download_Migration.groovy
Feb 24, 2009 12:22:05 PM sun.reflect.NativeMethodAccessorImpl invoke0
INFO: Including file
file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_http_download_range_Migration.groovy
Feb 24, 2009 12:22:05 PM sun.reflect.NativeMethodAccessorImpl invoke0
INFO: Including file file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_market_Migration.groovy
Feb 24, 2009 12:22:05 PM sun.reflect.NativeMethodAccessorImpl invoke0
INFO: Including file
file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_search_account_Migration.groovy
Feb 24, 2009 12:22:05 PM sun.reflect.GeneratedMethodAccessor585 invoke
INFO: Including file
file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_search_content_Migration.groovy
Feb 24, 2009 12:22:05 PM sun.reflect.GeneratedMethodAccessor585 invoke
INFO: Including file
file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_search_email_Migration.groovy
Feb 24, 2009 12:22:05 PM sun.reflect.GeneratedMethodAccessor585 invoke
INFO: Including file file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_search_Migration.groovy
Feb 24, 2009 12:22:05 PM sun.reflect.GeneratedMethodAccessor585 invoke
INFO: Including file
file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_show_type_Migration.groovy
Feb 24, 2009 12:22:05 PM sun.reflect.GeneratedMethodAccessor585 invoke
INFO: Including file
file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_task_log_Migration.groovy
Feb 24, 2009 12:22:05 PM sun.reflect.GeneratedMethodAccessor585 invoke
INFO: Including file file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_task_Migration.groovy
Feb 24, 2009 12:22:06 PM sun.reflect.GeneratedMethodAccessor585 invoke
INFO: Including file
file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_task_user_Migration.groovy
Feb 24, 2009 12:22:06 PM sun.reflect.GeneratedMethodAccessor585 invoke
INFO: Including file
file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_transfer_log_Migration.groovy
Feb 24, 2009 12:22:06 PM sun.reflect.GeneratedMethodAccessor585 invoke
INFO: Including file
file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_upload_id_Migration.groovy
Feb 24, 2009 12:22:06 PM sun.reflect.GeneratedMethodAccessor585 invoke
INFO: Including file file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_user_Migration.groovy
Feb 24, 2009 12:22:06 PM sun.reflect.GeneratedMethodAccessor585 invoke
INFO: Including file
file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_zip_file_Migration.groovy
Feb 24, 2009 12:22:06 PM sun.reflect.GeneratedMethodAccessor585 invoke
INFO: Including file
file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/010_AddVersionColumnTo_mm_zip_state_Migration.groovy
Feb 24, 2009 12:22:06 PM sun.reflect.GeneratedMethodAccessor585 invoke
INFO: Including file
file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/020_AddAndMigrateStatusColumnOn_mm_folder_Migration.groovy
Feb 24, 2009 12:22:06 PM sun.reflect.GeneratedMethodAccessor585 invoke
INFO: Including file
file://Y:/svn/mrgrails/trunk/migrations/Mbjarland/030_AddLeftAndRightColumnTo_mm_folder_Migration.groovy
Feb 24, 2009 12:22:06 PM liquibase.database.AbstractDatabase
getRanChangeSetList
INFO: Reading from `DATABASECHANGELOG`
Feb 24, 2009 12:22:06 PM liquibase.database.template.JdbcTemplate
comment
INFO: Release Database Lock
Feb 24, 2009 12:22:06 PM liquibase.lock.LockHandler releaseLock
INFO: Successfully released change log lock