I'm looking for help on fixing a problem I'm facing while creating an
index on a database.
I'm seeing:
-bash-3.00# heroku rake db:migrate
(in /disk1/home/slugs/11503_64b8d98_b9b7/mnt)
== Addingindex: migrating
=====================================================
-- add_index("users", "facebook_uid")
/disk1/home/slugs/11503_64b8d98_b9b7/mnt/config/boot.rb:26:Warning:
Gem::SourceIndex#search support for String patterns is deprecated
rake aborted!
PGError: ERROR: canceling statement due to statement timeout
: CREATE INDEX "index_users_on_facebook_uid" ON users
("facebook_uid")
(See full trace by running task with --trace)
-bash-3.00#
The database has about half a million records. The indexing should
take about a minute or two. The statement timeout happens within a few
seconds, so maybe the timeout value is set too low?
I'd appreciate any pointers I can get towards solving this issue.
Thanks!
- Anand Chhatpar
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Heroku" 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/heroku?hl=en
-~----------~----~----~----~------~----~------~--~---
