API tools faq
paste
Guest User

Untitled

a guest
Mar 7th, 2018
105
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.54 KB | None | 0 0
raw download clone embed print report
  1. [Import 52] Preparing to convert...2007-08-24 18:10:47
  2. SQL (0.001431) BEGIN
  3. Import Update (0.001353) UPDATE imports SET `created_at` = '2007-08-24 18:09:02', `error_count` = 0, `ignore_first_row` = 1, `skip_duplicates` = 1, `status` = 'in progress', `currently_imported` = 0, `person_database_id` = 2, `lists` = NULL, `total_imported` = 100000, `file_size` = 12199378, `file_name` = 'import.csv.1188004066', `reactivate` = 0, `account_id` = 1, `separator` = 'Comma', `column_field_match` = '--- \n- 0\n- 2\n- 12\n- 42\n- 52\n- 72\n- 92\n- 102\n- 82\n', `updated_at` = '2007-08-24 18:10:47' WHERE id = 52
  4. SQL (0.015382) COMMIT
  5. PersonAttributeColumn Columns (0.003177) SHOW FIELDS FROM person_attribute_columns
  6. PersonAttributeColumn Load (0.000948) SELECT * FROM person_attribute_columns WHERE (person_attribute_columns.id = 2)
  7. DataType Columns (0.001570) SHOW FIELDS FROM data_types
  8. DataType Load (0.000696) SELECT * FROM data_types WHERE (data_types.id = 1)
  9. PersonAttributeColumnOption Columns (0.001464) SHOW FIELDS FROM person_attribute_column_options
  10. PersonAttributeColumnOption Load (0.004299) SELECT * FROM person_attribute_column_options WHERE (person_attribute_column_options.person_attribute_column_id = 2) ORDER BY position
  11. PersonAttributeColumn Load (0.001527) SELECT * FROM person_attribute_columns WHERE (person_attribute_columns.id = 12)
  12. DataType Load (0.002197) SELECT * FROM data_types WHERE (data_types.id = 1)
  13. PersonAttributeColumnOption Load (0.001131) SELECT * FROM person_attribute_column_options WHERE (person_attribute_column_options.person_attribute_column_id = 12) ORDER BY position
  14. PersonAttributeColumn Load (0.000874) SELECT * FROM person_attribute_columns WHERE (person_attribute_columns.id = 42)
  15. DataType Load (0.001009) SELECT * FROM data_types WHERE (data_types.id = 1)
  16. PersonAttributeColumnOption Load (0.001230) SELECT * FROM person_attribute_column_options WHERE (person_attribute_column_options.person_attribute_column_id = 42) ORDER BY position
  17. PersonAttributeColumn Load (0.001306) SELECT * FROM person_attribute_columns WHERE (person_attribute_columns.id = 52)
  18. DataType Load (0.000694) SELECT * FROM data_types WHERE (data_types.id = 1)
  19. PersonAttributeColumnOption Load (0.000939) SELECT * FROM person_attribute_column_options WHERE (person_attribute_column_options.person_attribute_column_id = 52) ORDER BY position
  20. PersonAttributeColumn Load (0.001177) SELECT * FROM person_attribute_columns WHERE (person_attribute_columns.id = 72)
  21. DataType Load (0.001127) SELECT * FROM data_types WHERE (data_types.id = 1)
  22. PersonAttributeColumnOption Load (0.001142) SELECT * FROM person_attribute_column_options WHERE (person_attribute_column_options.person_attribute_column_id = 72) ORDER BY position
  23. PersonAttributeColumn Load (0.001170) SELECT * FROM person_attribute_columns WHERE (person_attribute_columns.id = 92)
  24. DataType Load (0.000708) SELECT * FROM data_types WHERE (data_types.id = 1)
  25. PersonAttributeColumnOption Load (0.000976) SELECT * FROM person_attribute_column_options WHERE (person_attribute_column_options.person_attribute_column_id = 92) ORDER BY position
  26. PersonAttributeColumn Load (0.000899) SELECT * FROM person_attribute_columns WHERE (person_attribute_columns.id = 102)
  27. DataType Load (0.000692) SELECT * FROM data_types WHERE (data_types.id = 1)
  28. PersonAttributeColumnOption Load (0.000953) SELECT * FROM person_attribute_column_options WHERE (person_attribute_column_options.person_attribute_column_id = 102) ORDER BY position
  29. PersonAttributeColumn Load (0.000877) SELECT * FROM person_attribute_columns WHERE (person_attribute_columns.id = 82)
  30. DataType Load (0.000775) SELECT * FROM data_types WHERE (data_types.id = 1)
  31. PersonAttributeColumnOption Load (0.001017) SELECT * FROM person_attribute_column_options WHERE (person_attribute_column_options.person_attribute_column_id = 82) ORDER BY position
  32. Person Columns (0.001597) SHOW FIELDS FROM people
  33. Person Load (0.026041) SELECT * FROM people WHERE (people.`person_database_id` = 2)
  34. [Import 52] Converting the file...2007-08-24 18:10:47
  35. [Import 52] Importing people...2007-08-24 18:11:07
  36. allow_concurrency=true
  37. SQL (11.666983) UPDATE people SET created_at=updated_at WHERE person_database_id=2 AND created_at IS NULL
  38. [Import 52] Correlating new inserts to original data...2007-08-24 18:11:22
  39. Person Load (1.572655) SELECT * FROM people WHERE (people.`person_database_id` = 2)
  40. allow_concurrency=true
  41. [Import 52] Importing tracks...2007-08-24 18:11:54
  42. [Import 52] Importing list memberships...2007-08-24 18:11:59
  43. [Import 52] Importing person attributes...2007-08-24 18:11:59
  44. allow_concurrency=true
  45. allow_concurrency=true
  46. [Import 52] Setting created_at for tracks...2007-08-24 18:13:13
  47. SQL (0.000000) Mysql::Error: MySQL server has gone away: UPDATE tracks SET created_at=CURRENT_TIME WHERE created_at IS NULL
  48. allow_concurrency=true
  49. allow_concurrency=true
  50. SQL (0.000000) Mysql::Error: MySQL server has gone away: SELECT count(*) AS count_all FROM people
  51. allow_concurrency=true
  52. SQL (0.000000) Mysql::Error: MySQL server has gone away: SELECT count(*) AS count_all FROM people
  53. Resource Load (0.001330) SELECT * FROM resources WHERE (resources.`account_id` = 1) LIMIT 1
  54. allow_concurrency=true
  55. SQL (0.000549) SET SQL_AUTO_IS_NULL=0
  56. Resource Columns (0.009700) SHOW FIELDS FROM resources
  57. Resource Load (0.001232) SELECT * FROM resources WHERE (resources.`account_id` = 1) LIMIT 1
  58. SQL (0.000466) SET SQL_AUTO_IS_NULL=0
  59. Person Columns (0.006306) SHOW FIELDS FROM people
  60. SQL (0.848215) SELECT count(*) AS count_all FROM people
  61.  
  62.  
  63.  
  64. ##################### Console log
  65.  
  66. Loading staging environment.
  67. External>> External.use_account 1
  68. => #<ActiveRecord::Base::ConnectionSpecification:0xb7233ff4 @adapter_method="mysql_connection", @config={:username=>[FILTERED], :adapter=>"mysql", :password=>[FILTERED], :database=>"ss_test_0", :host=>[FILTERED]}>
  69. >> Benchmark.bm do |x| x.report do Import.find(52).import end end user system total real
  70. ss_test_0.people: Records: 100000 Deleted: 0 Skipped: 0 Warnings: 0
  71. ss_test_0.tracks: Records: 100000 Deleted: 0 Skipped: 0 Warnings: 0
  72. ss_test_0.list_memberships: Records: 0 Deleted: 0 Skipped: 0 Warnings: 0
  73. mysqlimport: Error: Lost connection to MySQL server during query, when using table: person_attributes
  74. ActiveRecord::StatementInvalid: Mysql::Error: MySQL server has gone away: UPDATE tracks SET created_at=CURRENT_TIME WHERE created_at IS NULL
  75. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/connection_adapters/abstract_adapter.rb:128:in `log'
  76. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/connection_adapters/mysql_adapter.rb:243:in `execute'
  77. from ./script/../config/../config/../app/models/import.rb:156:in `import'
  78. from (irb):3
  79. from /usr/local/lib/ruby/1.8/benchmark.rb:293:in `measure'
  80. from /usr/local/lib/ruby/1.8/benchmark.rb:377:in `report'
  81. from (irb):3
  82. from /usr/local/lib/ruby/1.8/benchmark.rb:177:in `benchmark'
  83. from /usr/local/lib/ruby/1.8/benchmark.rb:207:in `bm'
  84. from (irb):3
  85. >> Person.count
  86. ActiveRecord::StatementInvalid: Mysql::Error: MySQL server has gone away: SELECT count(*) AS count_all FROM people
  87. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/connection_adapters/abstract_adapter.rb:128:in `log'
  88. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/connection_adapters/mysql_adapter.rb:243:in `execute'
  89. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/connection_adapters/mysql_adapter.rb:399:in `select'
  90. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/connection_adapters/abstract/database_statements.rb:13:in `select_one'
  91. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/connection_adapters/abstract/database_statements.rb:19:in `select_value'
  92. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/calculations.rb:212:in `execute_simple_calculation'
  93. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/calculations.rb:121:in `calculate'
  94. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/calculations.rb:117:in `catch'
  95. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/calculations.rb:117:in `calculate'
  96. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/calculations.rb:45:in `count'
  97. from (irb):4
  98. >> Person.count
  99. ActiveRecord::StatementInvalid: Mysql::Error: MySQL server has gone away: SELECT count(*) AS count_all FROM people
  100. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/connection_adapters/abstract_adapter.rb:128:in `log'
  101. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/connection_adapters/mysql_adapter.rb:243:in `execute'
  102. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/connection_adapters/mysql_adapter.rb:399:in `select'
  103. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/connection_adapters/abstract/database_statements.rb:13:in `select_one'
  104. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/connection_adapters/abstract/database_statements.rb:19:in `select_value'
  105. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/calculations.rb:212:in `execute_simple_calculation'
  106. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/calculations.rb:121:in `calculate'
  107. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/calculations.rb:117:in `catch'
  108. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/calculations.rb:117:in `calculate'
  109. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/calculations.rb:45:in `count'
  110. from (irb):5
  111. >> External.use_account 1
  112. => #<ActiveRecord::Base::ConnectionSpecification:0xae0f5600 @adapter_method="mysql_connection", @config={:username=>[FILTERED], :adapter=>"mysql", :password=>[FILTERED], :database=>"ss_test_0", :host=>[FILTERED]}>
  113. >> Person.count
  114. Mysql::Error: Can't connect to MySQL server on '[FILTERED]' (111)
  115. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/connection_adapters/mysql_adapter.rb:389:in `real_connect'
  116. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/connection_adapters/mysql_adapter.rb:389:in `connect'
  117. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/connection_adapters/mysql_adapter.rb:152:in `initialize'
  118. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/connection_adapters/mysql_adapter.rb:82:in `new'
  119. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/connection_adapters/mysql_adapter.rb:82:in `mysql_connection'
  120. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:262:in `send'
  121. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:262:in `connection_without_query_cache='
  122. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/query_cache.rb:54:in `connection='
  123. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:230:in `retrieve_connection'
  124. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in `connection'
  125. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/calculations.rb:212:in `execute_simple_calculation'
  126. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/calculations.rb:121:in `calculate'
  127. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/calculations.rb:117:in `catch'
  128. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/calculations.rb:117:in `calculate'
  129. from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/calculations.rb:45:in `count'
  130. from (irb):7
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!