Project

General

Profile

Unable to show time_entries in projects (Internal Error)

Added by Pavel Potcheptsov over 11 years ago

OpenIdAuthentication.store is nil. Using in-memory store.
Started GET "/projects/it/time_entries" for 127.0.0.1 at 2013-01-23 16:43:15 +0100
Processing by TimelogController#index as HTML
  Parameters: {"project_id"=>"it"}
  Current user: ppo (id=95)
Completed 500 Internal Server Error in 625ms

ActiveRecord::StatementInvalid (Mysql2::Error: Error writing file '/tmp/MYMLnpAz' (Errcode: 122): SELECT  `time_entries`.`id` AS t0_r0, `time_entries`.`project_id` AS t0_r1, `time_entries`.`user_id` AS t0_r2, `time_entries`.`issue_id` AS t0_r3, `time_entries`.`hours` AS t0_r4, `time_entries`.`comments` AS t0_r5, `time_entries`.`activity_id` AS t0_r6, `time_entries`.`spent_on` AS t0_r7, `time_entries`.`tyear` AS t0_r8, `time_entries`.`tmonth` AS t0_r9, `time_entries`.`tweek` AS t0_r10, `time_entries`.`created_on` AS t0_r11, `time_entries`.`updated_on` AS t0_r12, `time_entries`.`start_time` AS t0_r13, `time_entries`.`billed_hours` AS t0_r14, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`description` AS t1_r2, `projects`.`homepage` AS t1_r3, `projects`.`is_public` AS t1_r4, `projects`.`parent_id` AS t1_r5, `projects`.`created_on` AS t1_r6, `projects`.`updated_on` AS t1_r7, `projects`.`identifier` AS t1_r8, `projects`.`status` AS t1_r9, `projects`.`lft` AS t1_r10, `projects`.`rgt` AS t1_r11, `projects`.`customer_id` AS t1_r12, `enumerations`.`id` AS t2_r0, `enumerations`.`name` AS t2_r1, `enumerations`.`position` AS t2_r2, `enumerations`.`is_default` AS t2_r3, `enumerations`.`type` AS t2_r4, `enumerations`.`active` AS t2_r5, `enumerations`.`project_id` AS t2_r6, `enumerations`.`parent_id` AS t2_r7, `enumerations`.`position_name` AS t2_r8, `users`.`id` AS t3_r0, `users`.`login` AS t3_r1, `users`.`hashed_password` AS t3_r2, `users`.`firstname` AS t3_r3, `users`.`lastname` AS t3_r4, `users`.`mail` AS t3_r5, `users`.`admin` AS t3_r6, `users`.`status` AS t3_r7, `users`.`last_login_on` AS t3_r8, `users`.`language` AS t3_r9, `users`.`auth_source_id` AS t3_r10, `users`.`created_on` AS t3_r11, `users`.`updated_on` AS t3_r12, `users`.`type` AS t3_r13, `users`.`identity_url` AS t3_r14, `users`.`mail_notification` AS t3_r15, `users`.`salt` AS t3_r16, `issues`.`id` AS t4_r0, `issues`.`tracker_id` AS t4_r1, `issues`.`project_id` AS t4_r2, `issues`.`subject` AS t4_r3, `issues`.`description` AS t4_r4, `issues`.`due_date` AS t4_r5, `issues`.`category_id` AS t4_r6, `issues`.`status_id` AS t4_r7, `issues`.`assigned_to_id` AS t4_r8, `issues`.`priority_id` AS t4_r9, `issues`.`fixed_version_id` AS t4_r10, `issues`.`author_id` AS t4_r11, `issues`.`lock_version` AS t4_r12, `issues`.`created_on` AS t4_r13, `issues`.`updated_on` AS t4_r14, `issues`.`start_date` AS t4_r15, `issues`.`done_ratio` AS t4_r16, `issues`.`estimated_hours` AS t4_r17, `issues`.`parent_id` AS t4_r18, `issues`.`votes_value` AS t4_r19, `issues`.`parent_id_new` AS t4_r20, `issues`.`root_id` AS t4_r21, `issues`.`lft_` AS t4_r22, `issues`.`rgt_` AS t4_r23, `issues`.`lft` AS t4_r24, `issues`.`rgt` AS t4_r25, `issues`.`is_private` AS t4_r26, `trackers`.`id` AS t5_r0, `trackers`.`name` AS t5_r1, `trackers`.`is_in_chlog` AS t5_r2, `trackers`.`position` AS t5_r3, `trackers`.`is_in_roadmap` AS t5_r4, `trackers`.`fields_bits` AS t5_r5 FROM `time_entries` LEFT OUTER JOIN `projects` ON `projects`.`id` = `time_entries`.`project_id` LEFT OUTER JOIN `enumerations` ON `enumerations`.`id` = `time_entries`.`activity_id` AND `enumerations`.`type` IN ('TimeEntryActivity') LEFT OUTER JOIN `users` ON `users`.`id` = `time_entries`.`user_id` AND `users`.`type` IN ('User', 'AnonymousUser') LEFT OUTER JOIN `issues` ON `issues`.`id` = `time_entries`.`issue_id` LEFT OUTER JOIN `trackers` ON `trackers`.`id` = `issues`.`tracker_id` WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='time_tracking')) AND ((projects.id = 78 OR (projects.lft > 510 AND projects.rgt < 523))) ORDER BY spent_on DESC, time_entries.created_on DESC LIMIT 10 OFFSET 0):
  app/controllers/timelog_controller.rb:63:in `block (2 levels) in index'
  app/controllers/timelog_controller.rb:58:in `index'

Redmine 2.2.2.stable.11244
Environment:
  Redmine version                          2.2.2.stable.11244
  Ruby version                             1.9.3 (i686-linux)
  Rails version                            3.2.11
  Environment                              production
  Database adapter                         Mysql2
Redmine plugins:
  redmine_drafts                           0.2.0
  redmine_fields_permissions               1.0.0
  redmine_hide_estimated_hours             1.0.3
  redmine_lightbox                         0.0.1
  redmine_timesheet_plugin                 0.7.0


[root@redmine rm2.2.2]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_rm2-lv_root
                      4.0G  1.8G  2.1G  46% /
tmpfs                 492M     0  492M   0% /dev/shm
/dev/vda1             485M   65M  395M  15% /boot
none                  492M  4.0K  492M   1% /tmp
192.168.188.200:/redmine
                      5.4T  472G  5.0T   9% /mnt
[root@redmine rm2.2.2]# df -i
Filesystem            Inodes   IUsed   IFree IUse% Mounted on
/dev/mapper/vg_rm2-lv_root
                      263472  100958  162514   39% /
tmpfs                 125780       1  125779    1% /dev/shm
/dev/vda1             128016      44  127972    1% /boot
none                  125780       6  125774    1% /tmp
192.168.188.200:/redmine
                     365993984 1336905 364657079    1% /mnt

Replies (3)

RE: Unable to show time_entries in projects (Internal Error) - Added by Pavel Potcheptsov over 11 years ago

[root@redmine rm2.2.2]# ruby -v
ruby 1.9.3p327 (2012-11-10 revision 37606) [i686-linux]


[root@redmine rm2.2.2]# bundle show
Gems included by the bundle:
  * actionmailer (3.2.11)
  * actionpack (3.2.11)
  * activemodel (3.2.11)
  * activerecord (3.2.11)
  * activeresource (3.2.11)
  * activesupport (3.2.11)
  * arel (3.0.2)
  * builder (3.0.0)
  * bundler (1.2.3)
  * coderay (1.0.8)
  * erubis (2.7.0)
  * hike (1.2.1)
  * i18n (0.6.1)
  * journey (1.0.4)
  * jquery-rails (2.0.3)
  * json (1.7.6)
  * mail (2.4.4)
  * mime-types (1.19)
  * multi_json (1.5.0)
  * mysql2 (0.3.11)
  * net-ldap (0.3.1)
  * polyglot (0.3.3)
  * rack (1.4.4)
  * rack-cache (1.2)
  * rack-openid (1.3.1)
  * rack-ssl (1.3.2)
  * rack-test (0.6.2)
  * rails (3.2.11)
  * railties (3.2.11)
  * rake (10.0.3)
  * rdoc (3.12)
  * rmagick (2.13.1)
  * ruby-openid (2.1.8)
  * sprockets (2.2.2)
  * thor (0.16.0)
  * tilt (1.3.3)
  * treetop (1.4.12)
  * tzinfo (0.3.35)

RE: Unable to show time_entries in projects (Internal Error) - Added by Pavel Potcheptsov over 11 years ago

when I go to report and reduce data range to last week or month - it works.
but with all time - it fails.

    (1-3/3)