Gitlab backup: Postgres syntax error
Created by: garnieretienne
Hi, I get an error when trying to backup my data:
gitlab@master:~/gitlab$ bundle exec rake gitlab:backup:create RAILS_ENV=production
Dumping database tables:
- Dumping table events... rake aborted!
PG::Error: ERROR: syntax error at or near "`"
LINE 1: SELECT * FROM `events`
^
: SELECT * FROM `events`
/srv/www/gitlab/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.9/lib/active_record/connection_adapters/postgresql_adapter.rb:1153:in `async_exec'
/srv/www/gitlab/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.9/lib/active_record/connection_adapters/postgresql_adapter.rb:1153:in `exec_no_cache'
/srv/www/gitlab/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.9/lib/active_record/connection_adapters/postgresql_adapter.rb:662:in `block in exec_query'
/srv/www/gitlab/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
/srv/www/gitlab/gitlab/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.9/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/srv/www/gitlab/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
/srv/www/gitlab/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.9/lib/active_record/connection_adapters/postgresql_adapter.rb:661:in `exec_query'
/srv/www/gitlab/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.9/lib/active_record/connection_adapters/postgresql_adapter.rb:1248:in `select'
/srv/www/gitlab/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract/database_statements.rb:18:in `select_all'
/srv/www/gitlab/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract/query_cache.rb:63:in `select_all'
/srv/www/gitlab/gitlab/lib/tasks/gitlab/backup.rake:164:in `block (6 levels) in <top (required)>'
/srv/www/gitlab/gitlab/lib/tasks/gitlab/backup.rake:163:in `open'
/srv/www/gitlab/gitlab/lib/tasks/gitlab/backup.rake:163:in `block (5 levels) in <top (required)>'
/srv/www/gitlab/gitlab/lib/tasks/gitlab/backup.rake:160:in `each'
/srv/www/gitlab/gitlab/lib/tasks/gitlab/backup.rake:160:in `block (4 levels) in <top (required)>'
/srv/www/gitlab/gitlab/lib/tasks/gitlab/backup.rake:8:in `block (3 levels) in <top (required)>'
Tasks: TOP => gitlab:backup:db:create
(See full trace by running task with --trace)Some informations about my config:
gitlab@master:~/gitlab$ bundle exec rake gitlab:env:info RAILS_ENV=production
System information
System: Debian 6.0.6
Current User: gitlab
Using RVM: no
Ruby Version: 1.9.3p327
Gem Version: 1.8.23
Bundler Version:1.2.3
Rake Version: 10.0.1
GitLab information
Version: 4.0.0
Revision: 19cb29e
Directory: /srv/www/gitlab/gitlab
DB Adapter: postgresql
URL: http://git.master.dev
HTTP Clone URL: http://git.master.dev/some-project.git
SSH Clone URL: [email protected]:some-project.git
Using LDAP: no
Using Omniauth: no
Gitolite information
Version: v3.04-42-g2d29cf7
Admin URI: git@localhost:gitolite-admin
Admin Key: gitlab
Repositories: /srv/git/repositories/
Hooks: /srv/git/.gitolite/hooks/
Git: /usr/bin/git