Visit Our UNIX and Linux User Community


Under Consideration: Migrate the Forums to Discourse


 
Thread Tools Search this Thread
The Lounge What is on Your Mind? Under Consideration: Migrate the Forums to Discourse
# 22  
Old 03-10-2020
Quote:
Originally Posted by vgersh99
Quick Q...
do I need a new account for the discourse "side of the house"?
Tried my creds from the main site, getting "Incorrect username, email or password"

Note: No passwords will be ported to any new discourse site. The password hash functions are not the same so porting them would not work.

All users will need to do the 'reset or lost password thing' on the new discourse site. I do not want to spam the world with a mass "reset your password for discourse email" if we decide to go public.

Please keep in mind, if you do it now (update your password on the discourse site), you will have do to it again later, because I plan to dump the discourse DB in a few days and run the whole migration again.

I have learned a few things from the test migration, so I will change the migration script and run it again after this test migration is complete (I think in one more day, the first test run will be done).

This is only a test run to smoke out the goblins, alligators, and vampires hiding in the migration shadows Smilie

FYI Only: I have started another test run on a different server using a modified migration script, so I'm actually doing two initial test migration runs at the moment. Plus, I need to get very good at docker, so I wanted to do it all from scratch again. In this second parallel run, I wrote some initial new code for some of our custom BBCODE and changed the way vB forums are converted to discourse categories.

I'm sure I will find more odd BBCODE issues and unexpected issues when testing various migration paths.

FYI Status, for the post replies migration on test bed 1

Code:
   497977 / 651396 ( 76.4%)  [577 items/min]

This User Gave Thanks to Neo For This Post:
# 23  
Old 03-10-2020
Update:

Posts done... moving on

Code:
importing posts...
   643001 / 651396 ( 98.7%)  [1399431 items/min]  
importing private messages.

Many errors in the script during this process:

Code:
importing private messages...
skipping pm-2068 `to_user_array` is not properly serialized -- {"bcc"=>"madEG"}
pm-2068 has no target (a:1:{s:3:"bcc";s:5:"madEG";})
     1001 / 32205 (  3.1%)  [3078112 items/min]  skipping pm-2084 `to_user_array` is not properly serialized -- {"bcc"=>"vino"}
pm-2084 has no target (a:1:{s:3:"bcc";s:4:"vino";})
     1002 / 32205 (  3.1%)  [3025363 items/min]  skipping pm-2099 `to_user_array` is not properly serialized -- {"bcc"=>"jamcalicut"}
pm-2099 has no target (a:1:{s:3:"bcc";s:10:"jamcalicut";})
     1003 / 32205 (  3.1%)  [2998298 items/min]  skipping pm-2100 `to_user_array` is not properly serialized -- {"bcc"=>"arunkumar_mca"}
pm-2100 has no target (a:1:{s:3:"bcc";s:13:"arunkumar_mca";})
     1004 / 32205 (  3.1%)  [2975087 items/min]  skipping pm-2106 `to_user_array` is not properly serialized -- {"bcc"=>"thanusha"}
pm-2106 has no target (a:1:{s:3:"bcc";s:8:"thanusha";})
     1005 / 32205 (  3.1%)  [2951156 items/min]  skipping pm-2108 `to_user_array` is not properly serialized -- {"bcc"=>"Danielillo300"}
pm-2108 has no target (a:1:{s:3:"bcc";s:13:"Danielillo300";})
     1006 / 32205 (  3.1%)  [2897748 items/min]  skipping pm-2110 `to_user_array` is not properly serialized -- {"bcc"=>"cassj"}
pm-2110 has no target (a:1:{s:3:"bcc";s:5:"cassj";})
     1007 / 32205 (  3.1%)  [2825610 items/min]  skipping pm-2111 `to_user_array` is not properly serialized -- {"bcc"=>"cassj"}
pm-2111 has no target (a:1:{s:3:"bcc";s:5:"cassj";})
     1008 / 32205 (  3.1%)  [2771679 items/min]  skipping pm-2117 `to_user_array` is not properly serialized -- {"bcc"=>"cskumar"}
pm-2117 has no target (a:1:{s:3:"bcc";s:7:"cskumar";})
     1009 / 32205 (  3.1%)  [2722011 items/min]  skipping pm-2118 `to_user_array` is not properly serialized -- {"bcc"=>"cskumar"}
pm-2118 has no target (a:1:{s:3:"bcc";s:7:"cskumar";})
     1010 / 32205 (  3.1%)  [2664881 items/min]  skipping pm-2215 `to_user_array` is not properly serialized -- {"bcc"=>"sharif.rizal"}
pm-2215 has no target (a:1:{s:3:"bcc";s:12:"sharif.rizal";})
     1011 / 32205 (  3.1%)  [2622419 items/min]  skipping pm-2231 `to_user_array` is not properly serialized -- {"bcc"=>"ringofsteel"}
pm-2231 has no target (a:1:{s:3:"bcc";s:11:"ringofsteel";})
     1012 / 32205 (  3.1%)  [2603823 items/min]  skipping pm-2238 `to_user_array` is not properly serialized -- {"bcc"=>"aishu"}
pm-2238 has no target (a:1:{s:3:"bcc";s:5:"aishu";})
     1013 / 32205 (  3.1%)  [2586620 items/min]  skipping pm-2243 `to_user_array` is not properly serialized -- {"bcc"=>"krishnan_6015@y"}
pm-2243 has no target (a:1:{s:3:"bcc";s:15:"krishnan_6015@y";})
     1014 / 32205 (  3.1%)  [2571668 items/min]  skipping pm-2252 `to_user_array` is not properly serialized -- {"bcc"=>"thumper"}
pm-2252 has no target (a:1:{s:3:"bcc";s:7:"thumper";})
     1015 / 32205 (  3.2%)  [2557984 items/min]  skipping pm-2253 `to_user_array` is not properly serialized -- {"bcc"=>"thumper"}
pm-2253 has no target (a:1:{s:3:"bcc";s:7:"thumper";})
     1016 / 32205 (  3.2%)  [2544388 items/min]  skipping pm-2257 `to_user_array` is not properly serialized -- {"bcc"=>"kezzol"}
pm-2257 has no target (a:1:{s:3:"bcc";s:6:"kezzol";})
     1017 / 32205 (  3.2%)  [2529213 items/min]  skipping pm-2260 `to_user_array` is not properly serialized -- {"bcc"=>"elzalem"}
pm-2260 has no target (a:1:{s:3:"bcc";s:7:"elzalem";})
     1018 / 32205 (  3.2%)  [2516010 items/min]  skipping pm-2298 `to_user_array` is not properly serialized -- {"bcc"=>"sakthi_13"}
pm-2298 has no target (a:1:{s:3:"bcc";s:9:"sakthi_13";})
     1019 / 32205 (  3.2%)  [2501264 items/min]  skipping pm-2305 `to_user_array` is not properly serialized -- {"bcc"=>"user_prady"}
pm-2305 has no target (a:1:{s:3:"bcc";s:10:"user_prady";})
     1020 / 32205 (  3.2%)  [2488480 items/min]  skipping pm-2312 `to_user_array` is not properly serialized -- {"bcc"=>"mvictorvijayan"}
pm-2312 has no target (a:1:{s:3:"bcc";s:14:"mvictorvijayan";})
     1021 / 32205 (  3.2%)  [2474183 items/min]  skipping pm-2318 `to_user_array` is not properly serialized -- {"bcc"=>"Tanvirk"}
pm-2318 has no target (a:1:{s:3:"bcc";s:7:"Tanvirk";})
     1022 / 32205 (  3.2%)  [2461119 items/min]  skipping pm-2322 `to_user_array` is not properly serialized -- {"bcc"=>"Tanvirk"}
pm-2322 has no target (a:1:{s:3:"bcc";s:7:"Tanvirk";})
     1023 / 32205 (  3.2%)  [2444303 items/min]  skipping pm-2330 `to_user_array` is not properly serialized -- {"bcc"=>"nathan"}
pm-2330 has no target (a:1:{s:3:"bcc";s:6:"nathan";})
     1024 / 32205 (  3.2%)  [2432051 items/min]  skipping pm-2331 `to_user_array` is not properly serialized -- {"bcc"=>"nathan"}
pm-2331 has no target (a:1:{s:3:"bcc";s:6:"nathan";})
     1025 / 32205 (  3.2%)  [2419670 items/min]  skipping pm-2341 `to_user_array` is not properly serialized -- {"bcc"=>"udhayashankar"}
pm-2341 has no target (a:1:{s:3:"bcc";s:13:"udhayashankar";})
     1026 / 32205 (  3.2%)  [2405570 items/min]  skipping pm-2391 `to_user_array` is not properly serialized -- {"bcc"=>"royal"}
pm-2391 has no target (a:1:{s:3:"bcc";s:5:"royal";})
     1027 / 32205 (  3.2%)  [2393610 items/min]  skipping pm-2401 `to_user_array` is not properly serialized -- {"bcc"=>"deckard"}
pm-2401 has no target (a:1:{s:3:"bcc";s:7:"deckard";})
     1028 / 32205 (  3.2%)  [2382157 items/min]  skipping pm-2404 `to_user_array` is not properly serialized -- {"bcc"=>"MaestroRage"}
pm-2404 has no target (a:1:{s:3:"bcc";s:11:"MaestroRage";})
     1029 / 32205 (  3.2%)  [2289484 items/min]  skipping pm-2405 `to_user_array` is not properly serialized -- {"bcc"=>"zoom"}
pm-2405 has no target (a:1:{s:3:"bcc";s:4:"zoom";})
     1030 / 32205 (  3.2%)  [2233536 items/min]  skipping pm-2465 `to_user_array` is not properly serialized -- {"bcc"=>"bhanu6us"}
pm-2465 has no target (a:1:{s:3:"bcc";s:8:"bhanu6us";})
     1031 / 32205 (  3.2%)  [2220898 items/min]  skipping pm-2468 `to_user_array` is not properly serialized -- {"bcc"=>"srichunduru"}
pm-2468 has no target (a:1:{s:3:"bcc";s:11:"srichunduru";})
     1032 / 32205 (  3.2%)  [2208509 items/min]  skipping pm-2480 `to_user_array` is not properly serialized -- {"bcc"=>"Sergiu-IT"}
pm-2480 has no target (a:1:{s:3:"bcc";s:9:"Sergiu-IT";})
     1033 / 32205 (  3.2%)  [2198099 items/min]  skipping pm-2496 `to_user_array` is not properly serialized -- {"bcc"=>"vpandey"}
pm-2496 has no target (a:1:{s:3:"bcc";s:7:"vpandey";})
     1034 / 32205 (  3.2%)  [2188659 items/min]  skipping pm-2514 `to_user_array` is not properly serialized -- {"bcc"=>"Vitamin254"}
pm-2514 has no target (a:1:{s:3:"bcc";s:10:"Vitamin254";})
     1035 / 32205 (  3.2%)  [2179013 items/min]  skipping pm-2523 `to_user_array` is not properly serialized -- {"bcc"=>"bryan_adams"}
pm-2523 has no target (a:1:{s:3:"bcc";s:11:"bryan_adams";})
     1036 / 32205 (  3.2%)  [2169872 items/min]  skipping pm-2545 `to_user_array` is not properly serialized -- {"bcc"=>"malaisamya"}
pm-2545 has no target (a:1:{s:3:"bcc";s:10:"malaisamya";})
     1037 / 32205 (  3.2%)  [2160851 items/min]  skipping pm-4109 `to_user_array` is not properly serialized -- {"bcc"=>"qwbouqd"}
pm-4109 has no target (a:1:{s:3:"bcc";s:7:"qwbouqd";})
     3001 / 32205 (  9.3%)  [2560004 items/min]  skipping pm-4191 `to_user_array` is not properly serialized -- {"bcc"=>"grial"}
pm-4191 has no target (a:1:{s:3:"bcc";s:5:"grial";})
     3002 / 32205 (  9.3%)  [2544677 items/min]  skipping pm-4192 `to_user_array` is not properly serialized -- {"bcc"=>"grial"}
pm-4192 has no target (a:1:{s:3:"bcc";s:5:"grial";})
     3003 / 32205 (  9.3%)  [2528097 items/min]  skipping pm-4200 `to_user_array` is not properly serialized -- {"bcc"=>"eagercyber"}
pm-4200 has no target (a:1:{s:3:"bcc";s:10:"eagercyber";})
     3004 / 32205 (  9.3%)  [2513525 items/min]  skipping pm-4207 `to_user_array` is not properly serialized -- {"bcc"=>"eagercyber"}
pm-4207 has no target (a:1:{s:3:"bcc";s:10:"eagercyber";})
     3005 / 32205 (  9.3%)  [2494515 items/min]  skipping pm-4230 `to_user_array` is not properly serialized -- {"bcc"=>"cassj"}
pm-4230 has no target (a:1:{s:3:"bcc";s:5:"cassj";})
     3006 / 32205 (  9.3%)  [2466508 items/min]  skipping pm-4231 `to_user_array` is not properly serialized -- {"bcc"=>"cassj"}
pm-4231 has no target (a:1:{s:3:"bcc";s:5:"cassj";})
     3007 / 32205 (  9.3%)  [2444195 items/min]  skipping pm-4232 `to_user_array` is not properly serialized -- {"bcc"=>"eagercyber"}
pm-4232 has no target (a:1:{s:3:"bcc";s:10:"eagercyber";})
     3008 / 32205 (  9.3%)  [2425517 items/min]  skipping pm-4248 `to_user_array` is not properly serialized -- {"bcc"=>"vino"}
pm-4248 has no target (a:1:{s:3:"bcc";s:4:"vino";})
     3009 / 32205 (  9.3%)  [2410828 items/min]  skipping pm-4249 `to_user_array` is not properly serialized -- {"bcc"=>"vino"}
pm-4249 has no target (a:1:{s:3:"bcc";s:4:"vino";})
     3010 / 32205 (  9.3%)  [2391919 items/min]  skipping pm-4253 `to_user_array` is not properly serialized -- {"bcc"=>"vino"}
pm-4253 has no target (a:1:{s:3:"bcc";s:4:"vino";})
     3011 / 32205 (  9.3%)  [2359778 items/min]  skipping pm-4311 `to_user_array` is not properly serialized -- {"bcc"=>"gopikgunda"}
pm-4311 has no target (a:1:{s:3:"bcc";s:10:"gopikgunda";})
     3012 / 32205 (  9.4%)  [2347049 items/min]  skipping pm-4342 `to_user_array` is not properly serialized -- {"bcc"=>"phonedog365"}
pm-4342 has no target (a:1:{s:3:"bcc";s:11:"phonedog365";})
     3013 / 32205 (  9.4%)  [2328462 items/min]  skipping pm-4345 `to_user_array` is not properly serialized -- {"bcc"=>"Shivdatta"}
pm-4345 has no target (a:1:{s:3:"bcc";s:9:"Shivdatta";})
     3014 / 32205 (  9.4%)  [2316168 items/min]  skipping pm-4352 `to_user_array` is not properly serialized -- {"bcc"=>"rockdude"}
pm-4352 has no target (a:1:{s:3:"bcc";s:8:"rockdude";})
     3015 / 32205 (  9.4%)  [2297222 items/min]  skipping pm-4386 `to_user_array` is not properly serialized -- {"bcc"=>"cassj"}
pm-4386 has no target (a:1:{s:3:"bcc";s:5:"cassj";})
     3016 / 32205 (  9.4%)  [2283626 items/min]  skipping pm-4407 `to_user_array` is not properly serialized -- {"bcc"=>"raghav1982"}
pm-4407 has no target (a:1:{s:3:"bcc";s:10:"raghav1982";})
     3017 / 32205 (  9.4%)  [2279684 items/min]  skipping pm-4418 `to_user_array` is not properly serialized -- {"bcc"=>"ramen_noodle"}
pm-4418 has no target (a:1:{s:3:"bcc";s:12:"ramen_noodle";})
     3018 / 32205 (  9.4%)  [2275916 items/min]  skipping pm-4539 `to_user_array` is not properly serialized -- {"bcc"=>"Sachin Gupta"}
pm-4539 has no target (a:1:{s:3:"bcc";s:12:"Sachin Gupta";})
     3019 / 32205 (  9.4%)  [2272013 items/min]  skipping pm-4546 `to_user_array` is not properly serialized -- {"bcc"=>"cong-lv"}
pm-4546 has no target (a:1:{s:3:"bcc";s:7:"cong-lv";})
     3020 / 32205 (  9.4%)  [2253112 items/min]  skipping pm-4611 `to_user_array` is not properly serialized -- {"bcc"=>"gobinath"}
pm-4611 has no target (a:1:{s:3:"bcc";s:8:"gobinath";})
     3021 / 32205 (  9.4%)  [2237404 items/min]  skipping pm-4614 `to_user_array` is not properly serialized -- {"bcc"=>"scarfake"}
pm-4614 has no target (a:1:{s:3:"bcc";s:8:"scarfake";})
     3022 / 32205 (  9.4%)  [2224658 items/min]  skipping pm-4616 `to_user_array` is not properly serialized -- {"bcc"=>"blowtorch"}
pm-4616 has no target (a:1:{s:3:"bcc";s:9:"blowtorch";})
     3023 / 32205 (  9.4%)  [2215103 items/min]  skipping pm-5456 `to_user_array` is not properly serialized -- {"bcc"=>"Franzlebord"}
pm-5456 has no target (a:1:{s:3:"bcc";s:11:"Franzlebord";})
     4001 / 32205 ( 12.4%)  [2550217 items/min]  skipping pm-5467 `to_user_array` is not properly serialized -- {"bcc"=>"moertono"}
pm-5467 has no target (a:1:{s:3:"bcc";s:8:"moertono";})
     4002 / 32205 ( 12.4%)  [2534546 items/min]  skipping pm-5468 `to_user_array` is not properly serialized -- {"bcc"=>"bullz26"}
pm-5468 has no target (a:1:{s:3:"bcc";s:7:"bullz26";})
     4003 / 32205 ( 12.4%)  [2523394 items/min]  skipping pm-5492 `to_user_array` is not properly serialized -- {"bcc"=>"justintjacob"}
pm-5492 has no target (a:1:{s:3:"bcc";s:12:"justintjacob";})
     4004 / 32205 ( 12.4%)  [2519003 items/min]  skipping pm-5497 `to_user_array` is not properly serialized -- {"bcc"=>"paruthiveeran"}
pm-5497 has no target (a:1:{s:3:"bcc";s:13:"paruthiveeran";})
    23003 / 32205 ( 71.4%)  [1579206 items/min]  
importing attachments...

# 24  
Old 03-10-2020
Now:

Code:
Closing topics...

Postprocessing posts...
  1059653 / 1059653 (100.0%)  
Creating Permalink File...

# 25  
Old 03-10-2020
Yeah... first test run migration is done:

Code:
Creating Permalink File...


updating banned users
     2259 / 3134 ( 72.1%)  Not found: 302148143
     2316 / 3134 ( 73.9%)  Not found: 302147997
     2444 / 3134 ( 78.0%)  Not found: 302147691
     2578 / 3134 ( 82.3%)  Not found: 302153403
     2580 / 3134 ( 82.3%)  Not found: 302153629
     3018 / 3134 ( 96.3%)  Not found: 302180317
     3025 / 3134 ( 96.5%)  Not found: 302180659
     3026 / 3134 ( 96.6%)  Not found: 302180687
     3034 / 3134 ( 96.8%)  Not found: 302180878
     3053 / 3134 ( 97.4%)  Not found: 302181312
     3056 / 3134 ( 97.5%)  Not found: 302181310
     3062 / 3134 ( 97.7%)  Not found: 302181411
     3077 / 3134 ( 98.2%)  Not found: 302179968
     3134 / 3134 (100.0%)  

Updating topic status

Updating bumped_at on topics

Updating last posted at on users

Updating last seen at on users

Updating topic reply counts...
   137992 / 137992 (100.0%)  [9664 items/min]     
Updating first_post_created_at...

Updating user post_count...

Updating user topic_count...

Updating topic users

Updating post timings

Updating featured topic users

Updating featured topics in categories
      123 / 123 (100.0%)  [626 items/min]  n]  
Updating user topic reply counts
   137992 / 137992 (100.0%)  [9643 items/min]     
Resetting topic counters


Done

I'm gonna run the script again on the same DBs (no changes, no DB flushes, etc)
This User Gave Thanks to Neo For This Post:
# 26  
Old 03-11-2020
wooohoooo Smilie Smilie

Good luck, seems promising so far, cant wait! Smilie
This User Gave Thanks to sea For This Post:
# 27  
Old 03-11-2020
Quote:
Originally Posted by sea
wooohoooo Smilie Smilie

Good luck, seems promising so far, cant wait! Smilie
Discourse is a work-of-art, so I am also excited to see this and it is looking very promising this will actually work out.

Finally after all these years, a better forum!
# 28  
Old 03-11-2020
Below is the complete "second full script run" and here is "the plan":
  • Modify vbulletin.rb migration script as required based on errors, missing customer BBCODE tags, and other "first order" issues.
  • rake db:drop db:create db:migrate.
  • dump the vB3 DB again from the main server
  • rerun migration from the start on a '"raked" db

Code:
root@localhost-app:/var/www/discourse# su discourse -c 'bundle exec ruby script/import_scripts/vbulletin.rb'
discourse:@localhost wants vb5
Loading existing groups...
Loading existing users...
Loading existing categories...
Loading existing posts...
Loading existing topics...

importing groups...
       20 / 20 (100.0%)  [1936324 items/min]  
importing users
   138001 / 138120 ( 99.9%)  [1442012 items/min]   
Creating groups membership...
	Unregistered_Not_Log
	Registered
	Users_Awaiting_Email
	_COPPA_Users_Awaitin
	Super_Moderators
	Administrators
	Read_Only
	Moderators1
	Banned_by_Moderators
	Advisors
	Supporter
	Bouncing_Email
	Elite_Member
	VIP_Member
	Signatures
	Recruiter
	Robots
	Novice_Users
	Event_Predictions_Ma
	Banned_User_IDs

importing all cateories top level categories...
      119 / 119 (100.0%)  [2774499 items/min]  
importing topics...
   200012 / 240477 ( 83.2%)  [920310 items/min]  Exception while creating post thread-243715. Skipping.
PG::InFailedSqlTransaction: ERROR:  current transaction is aborted, commands ignored until end of transaction block
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-1.1.6/lib/patches/db/pg.rb:110:in `exec'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-1.1.6/lib/patches/db/pg.rb:110:in `async_exec'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:65:in `block (2 levels) in query'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.1/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.1/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.1/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:64:in `block in query'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract_adapter.rb:718:in `block (2 levels) in log'
/usr/local/lib/ruby/2.6.0/monitor.rb:235:in `mon_synchronize'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract_adapter.rb:717:in `block in log'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.1/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract_adapter.rb:708:in `log'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:63:in `query'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract/database_statements.rb:102:in `query_values'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/postgresql/schema_statements.rb:356:in `primary_keys'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract/schema_statements.rb:147:in `primary_key'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/schema_cache.rb:49:in `primary_keys'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/attribute_methods/primary_key.rb:93:in `get_primary_key'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/attribute_methods/primary_key.rb:80:in `reset_primary_key'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/attribute_methods/primary_key.rb:68:in `primary_key'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/relation/delegation.rb:90:in `primary_key'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/relation.rb:570:in `delete_all'
/var/www/discourse/app/models/topic_link.rb:285:in `cleanup_entries'
/var/www/discourse/app/models/topic_link.rb:139:in `extract_from'
/var/www/discourse/lib/post_creator.rb:572:in `extract_links'
/var/www/discourse/lib/post_creator.rb:180:in `block in create'
/var/www/discourse/lib/post_creator.rb:359:in `block in transaction'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract/database_statements.rb:281:in `block in transaction'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract/transaction.rb:280:in `block in within_new_transaction'
/usr/local/lib/ruby/2.6.0/monitor.rb:235:in `mon_synchronize'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract/transaction.rb:278:in `within_new_transaction'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract/database_statements.rb:281:in `transaction'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/transactions.rb:212:in `transaction'
/var/www/discourse/lib/post_creator.rb:358:in `transaction'
/var/www/discourse/lib/post_creator.rb:174:in `create'
/var/www/discourse/script/import_scripts/base.rb:567:in `create_post'
/var/www/discourse/script/import_scripts/base.rb:515:in `block in create_posts'
/var/www/discourse/script/import_scripts/base.rb:502:in `each'
/var/www/discourse/script/import_scripts/base.rb:502:in `create_posts'
script/import_scripts/vbulletin.rb:330:in `block in import_topics'
/var/www/discourse/script/import_scripts/base.rb:882:in `block in batches'
/var/www/discourse/script/import_scripts/base.rb:881:in `loop'
/var/www/discourse/script/import_scripts/base.rb:881:in `batches'
script/import_scripts/vbulletin.rb:313:in `import_topics'
script/import_scripts/vbulletin.rb:85:in `execute'
/var/www/discourse/script/import_scripts/base.rb:47:in `perform'
script/import_scripts/vbulletin.rb:954:in `<main>'
   201001 / 240477 ( 83.6%)  [332847 items/min]  xException while creating post thread-243734. Skipping.
PG::InFailedSqlTransaction: ERROR:  current transaction is aborted, commands ignored until end of transaction block
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-1.1.6/lib/patches/db/pg.rb:110:in `exec'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-1.1.6/lib/patches/db/pg.rb:110:in `async_exec'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:65:in `block (2 levels) in query'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.1/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.1/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.1/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:64:in `block in query'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract_adapter.rb:718:in `block (2 levels) in log'
/usr/local/lib/ruby/2.6.0/monitor.rb:235:in `mon_synchronize'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract_adapter.rb:717:in `block in log'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.1/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract_adapter.rb:708:in `log'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:63:in `query'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract/database_statements.rb:102:in `query_values'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/postgresql/schema_statements.rb:356:in `primary_keys'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract/schema_statements.rb:147:in `primary_key'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/schema_cache.rb:49:in `primary_keys'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/attribute_methods/primary_key.rb:93:in `get_primary_key'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/attribute_methods/primary_key.rb:80:in `reset_primary_key'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/attribute_methods/primary_key.rb:68:in `primary_key'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/relation/delegation.rb:90:in `primary_key'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/relation.rb:570:in `delete_all'
/var/www/discourse/app/models/topic_link.rb:285:in `cleanup_entries'
/var/www/discourse/app/models/topic_link.rb:139:in `extract_from'
/var/www/discourse/lib/post_creator.rb:572:in `extract_links'
/var/www/discourse/lib/post_creator.rb:180:in `block in create'
/var/www/discourse/lib/post_creator.rb:359:in `block in transaction'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract/database_statements.rb:281:in `block in transaction'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract/transaction.rb:280:in `block in within_new_transaction'
/usr/local/lib/ruby/2.6.0/monitor.rb:235:in `mon_synchronize'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract/transaction.rb:278:in `within_new_transaction'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract/database_statements.rb:281:in `transaction'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/transactions.rb:212:in `transaction'
/var/www/discourse/lib/post_creator.rb:358:in `transaction'
/var/www/discourse/lib/post_creator.rb:174:in `create'
/var/www/discourse/script/import_scripts/base.rb:567:in `create_post'
/var/www/discourse/script/import_scripts/base.rb:515:in `block in create_posts'
/var/www/discourse/script/import_scripts/base.rb:502:in `each'
/var/www/discourse/script/import_scripts/base.rb:502:in `create_posts'
script/import_scripts/vbulletin.rb:330:in `block in import_topics'
/var/www/discourse/script/import_scripts/base.rb:882:in `block in batches'
/var/www/discourse/script/import_scripts/base.rb:881:in `loop'
/var/www/discourse/script/import_scripts/base.rb:881:in `batches'
script/import_scripts/vbulletin.rb:313:in `import_topics'
script/import_scripts/vbulletin.rb:85:in `execute'
/var/www/discourse/script/import_scripts/base.rb:47:in `perform'
script/import_scripts/vbulletin.rb:954:in `<main>'
   201002 / 240477 ( 83.6%)  [231079 items/min]  Exception while creating post thread-243762. Skipping.
PG::InFailedSqlTransaction: ERROR:  current transaction is aborted, commands ignored until end of transaction block
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-1.1.6/lib/patches/db/pg.rb:110:in `exec'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-1.1.6/lib/patches/db/pg.rb:110:in `async_exec'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:65:in `block (2 levels) in query'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.1/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.1/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.1/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:64:in `block in query'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract_adapter.rb:718:in `block (2 levels) in log'
/usr/local/lib/ruby/2.6.0/monitor.rb:235:in `mon_synchronize'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract_adapter.rb:717:in `block in log'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.1/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract_adapter.rb:708:in `log'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:63:in `query'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract/database_statements.rb:102:in `query_values'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/postgresql/schema_statements.rb:356:in `primary_keys'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract/schema_statements.rb:147:in `primary_key'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/schema_cache.rb:49:in `primary_keys'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/attribute_methods/primary_key.rb:93:in `get_primary_key'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/attribute_methods/primary_key.rb:80:in `reset_primary_key'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/attribute_methods/primary_key.rb:68:in `primary_key'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/relation/delegation.rb:90:in `primary_key'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/relation.rb:570:in `delete_all'
/var/www/discourse/app/models/topic_link.rb:285:in `cleanup_entries'
/var/www/discourse/app/models/topic_link.rb:139:in `extract_from'
/var/www/discourse/lib/post_creator.rb:572:in `extract_links'
/var/www/discourse/lib/post_creator.rb:180:in `block in create'
/var/www/discourse/lib/post_creator.rb:359:in `block in transaction'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract/database_statements.rb:281:in `block in transaction'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract/transaction.rb:280:in `block in within_new_transaction'
/usr/local/lib/ruby/2.6.0/monitor.rb:235:in `mon_synchronize'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract/transaction.rb:278:in `within_new_transaction'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/connection_adapters/abstract/database_statements.rb:281:in `transaction'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.1/lib/active_record/transactions.rb:212:in `transaction'
/var/www/discourse/lib/post_creator.rb:358:in `transaction'
/var/www/discourse/lib/post_creator.rb:174:in `create'
/var/www/discourse/script/import_scripts/base.rb:567:in `create_post'
/var/www/discourse/script/import_scripts/base.rb:515:in `block in create_posts'
/var/www/discourse/script/import_scripts/base.rb:502:in `each'
/var/www/discourse/script/import_scripts/base.rb:502:in `create_posts'
script/import_scripts/vbulletin.rb:330:in `block in import_topics'
/var/www/discourse/script/import_scripts/base.rb:882:in `block in batches'
/var/www/discourse/script/import_scripts/base.rb:881:in `loop'
/var/www/discourse/script/import_scripts/base.rb:881:in `batches'
script/import_scripts/vbulletin.rb:313:in `import_topics'
script/import_scripts/vbulletin.rb:85:in `execute'
/var/www/discourse/script/import_scripts/base.rb:47:in `perform'
script/import_scripts/vbulletin.rb:954:in `<main>'
   236002 / 240477 ( 98.1%)  [179988 items/min]  
importing posts...
   643001 / 651396 ( 98.7%)  [1974503 items/min]  
importing private messages...
skipping pm-2068 `to_user_array` is not properly serialized -- {"bcc"=>"madEG"}
pm-2068 has no target (a:1:{s:3:"bcc";s:5:"madEG";})
     1001 / 32205 (  3.1%)  [4272085 items/min]  skipping pm-2084 `to_user_array` is not properly serialized -- {"bcc"=>"vino"}
pm-2084 has no target (a:1:{s:3:"bcc";s:4:"vino";})
     1002 / 32205 (  3.1%)  [3945003 items/min]  skipping pm-2099 `to_user_array` is not properly serialized -- {"bcc"=>"jamcalicut"}
pm-2099 has no target (a:1:{s:3:"bcc";s:10:"jamcalicut";})
     1003 / 32205 (  3.1%)  [3655451 items/min]  skipping pm-2100 `to_user_array` is not properly serialized -- {"bcc"=>"arunkumar_mca"}
pm-2100 has no target (a:1:{s:3:"bcc";s:13:"arunkumar_mca";})
     1004 / 32205 (  3.1%)  [3458157 items/min]  skipping pm-2106 `to_user_array` is not properly serialized -- {"bcc"=>"thanusha"}
pm-2106 has no target (a:1:{s:3:"bcc";s:8:"thanusha";})
     1005 / 32205 (  3.1%)  [3408788 items/min]  skipping pm-2108 `to_user_array` is not properly serialized -- {"bcc"=>"Danielillo300"}
pm-2108 has no target (a:1:{s:3:"bcc";s:13:"Danielillo300";})
     1006 / 32205 (  3.1%)  [3371808 items/min]  skipping pm-2110 `to_user_array` is not properly serialized -- {"bcc"=>"cassj"}
pm-2110 has no target (a:1:{s:3:"bcc";s:5:"cassj";})
     1007 / 32205 (  3.1%)  [3336760 items/min]  skipping pm-2111 `to_user_array` is not properly serialized -- {"bcc"=>"cassj"}
pm-2111 has no target (a:1:{s:3:"bcc";s:5:"cassj";})
     1008 / 32205 (  3.1%)  [3304712 items/min]  skipping pm-2117 `to_user_array` is not properly serialized -- {"bcc"=>"cskumar"}
pm-2117 has no target (a:1:{s:3:"bcc";s:7:"cskumar";})
     1009 / 32205 (  3.1%)  [3272906 items/min]  skipping pm-2118 `to_user_array` is not properly serialized -- {"bcc"=>"cskumar"}
pm-2118 has no target (a:1:{s:3:"bcc";s:7:"cskumar";})
     1010 / 32205 (  3.1%)  [3243364 items/min]  skipping pm-2215 `to_user_array` is not properly serialized -- {"bcc"=>"sharif.rizal"}
pm-2215 has no target (a:1:{s:3:"bcc";s:12:"sharif.rizal";})
     1011 / 32205 (  3.1%)  [3176725 items/min]  skipping pm-2231 `to_user_array` is not properly serialized -- {"bcc"=>"ringofsteel"}
pm-2231 has no target (a:1:{s:3:"bcc";s:11:"ringofsteel";})
     1012 / 32205 (  3.1%)  [3028294 items/min]  skipping pm-2238 `to_user_array` is not properly serialized -- {"bcc"=>"aishu"}
pm-2238 has no target (a:1:{s:3:"bcc";s:5:"aishu";})
     1013 / 32205 (  3.1%)  [2866952 items/min]  skipping pm-2243 `to_user_array` is not properly serialized -- {"bcc"=>"krishnan_6015@y"}
pm-2243 has no target (a:1:{s:3:"bcc";s:15:"krishnan_6015@y";})
     1014 / 32205 (  3.1%)  [2745019 items/min]  skipping pm-2252 `to_user_array` is not properly serialized -- {"bcc"=>"thumper"}
pm-2252 has no target (a:1:{s:3:"bcc";s:7:"thumper";})
     1015 / 32205 (  3.2%)  [2626413 items/min]  skipping pm-2253 `to_user_array` is not properly serialized -- {"bcc"=>"thumper"}
pm-2253 has no target (a:1:{s:3:"bcc";s:7:"thumper";})
     1016 / 32205 (  3.2%)  [2533819 items/min]  skipping pm-2257 `to_user_array` is not properly serialized -- {"bcc"=>"kezzol"}
pm-2257 has no target (a:1:{s:3:"bcc";s:6:"kezzol";})
     1017 / 32205 (  3.2%)  [2442497 items/min]  skipping pm-2260 `to_user_array` is not properly serialized -- {"bcc"=>"elzalem"}
pm-2260 has no target (a:1:{s:3:"bcc";s:7:"elzalem";})
     1018 / 32205 (  3.2%)  [2365107 items/min]  skipping pm-2298 `to_user_array` is not properly serialized -- {"bcc"=>"sakthi_13"}
pm-2298 has no target (a:1:{s:3:"bcc";s:9:"sakthi_13";})
     1019 / 32205 (  3.2%)  [2304363 items/min]  skipping pm-2305 `to_user_array` is not properly serialized -- {"bcc"=>"user_prady"}
pm-2305 has no target (a:1:{s:3:"bcc";s:10:"user_prady";})
     1020 / 32205 (  3.2%)  [2191179 items/min]  skipping pm-2312 `to_user_array` is not properly serialized -- {"bcc"=>"mvictorvijayan"}
pm-2312 has no target (a:1:{s:3:"bcc";s:14:"mvictorvijayan";})
     1021 / 32205 (  3.2%)  [2142214 items/min]  skipping pm-2318 `to_user_array` is not properly serialized -- {"bcc"=>"Tanvirk"}
pm-2318 has no target (a:1:{s:3:"bcc";s:7:"Tanvirk";})
     1022 / 32205 (  3.2%)  [2097679 items/min]  skipping pm-2322 `to_user_array` is not properly serialized -- {"bcc"=>"Tanvirk"}
pm-2322 has no target (a:1:{s:3:"bcc";s:7:"Tanvirk";})
     1023 / 32205 (  3.2%)  [2051908 items/min]  skipping pm-2330 `to_user_array` is not properly serialized -- {"bcc"=>"nathan"}
pm-2330 has no target (a:1:{s:3:"bcc";s:6:"nathan";})
     1024 / 32205 (  3.2%)  [2012734 items/min]  skipping pm-2331 `to_user_array` is not properly serialized -- {"bcc"=>"nathan"}
pm-2331 has no target (a:1:{s:3:"bcc";s:6:"nathan";})
     1025 / 32205 (  3.2%)  [1971348 items/min]  skipping pm-2341 `to_user_array` is not properly serialized -- {"bcc"=>"udhayashankar"}
pm-2341 has no target (a:1:{s:3:"bcc";s:13:"udhayashankar";})
     1026 / 32205 (  3.2%)  [1936010 items/min]  skipping pm-2391 `to_user_array` is not properly serialized -- {"bcc"=>"royal"}
pm-2391 has no target (a:1:{s:3:"bcc";s:5:"royal";})
     1027 / 32205 (  3.2%)  [1910726 items/min]  skipping pm-2401 `to_user_array` is not properly serialized -- {"bcc"=>"deckard"}
pm-2401 has no target (a:1:{s:3:"bcc";s:7:"deckard";})
     1028 / 32205 (  3.2%)  [1876185 items/min]  skipping pm-2404 `to_user_array` is not properly serialized -- {"bcc"=>"MaestroRage"}
pm-2404 has no target (a:1:{s:3:"bcc";s:11:"MaestroRage";})
     1029 / 32205 (  3.2%)  [1842665 items/min]  skipping pm-2405 `to_user_array` is not properly serialized -- {"bcc"=>"zoom"}
pm-2405 has no target (a:1:{s:3:"bcc";s:4:"zoom";})
     1030 / 32205 (  3.2%)  [1798485 items/min]  skipping pm-2465 `to_user_array` is not properly serialized -- {"bcc"=>"bhanu6us"}
pm-2465 has no target (a:1:{s:3:"bcc";s:8:"bhanu6us";})
     1031 / 32205 (  3.2%)  [1756238 items/min]  skipping pm-2468 `to_user_array` is not properly serialized -- {"bcc"=>"srichunduru"}
pm-2468 has no target (a:1:{s:3:"bcc";s:11:"srichunduru";})
     1032 / 32205 (  3.2%)  [1723526 items/min]  skipping pm-2480 `to_user_array` is not properly serialized -- {"bcc"=>"Sergiu-IT"}
pm-2480 has no target (a:1:{s:3:"bcc";s:9:"Sergiu-IT";})
     1033 / 32205 (  3.2%)  [1686706 items/min]  skipping pm-2496 `to_user_array` is not properly serialized -- {"bcc"=>"vpandey"}
pm-2496 has no target (a:1:{s:3:"bcc";s:7:"vpandey";})
     1034 / 32205 (  3.2%)  [1645478 items/min]  skipping pm-2514 `to_user_array` is not properly serialized -- {"bcc"=>"Vitamin254"}
pm-2514 has no target (a:1:{s:3:"bcc";s:10:"Vitamin254";})
     1035 / 32205 (  3.2%)  [1617776 items/min]  skipping pm-2523 `to_user_array` is not properly serialized -- {"bcc"=>"bryan_adams"}
pm-2523 has no target (a:1:{s:3:"bcc";s:11:"bryan_adams";})
     1036 / 32205 (  3.2%)  [1592926 items/min]  skipping pm-2545 `to_user_array` is not properly serialized -- {"bcc"=>"malaisamya"}
pm-2545 has no target (a:1:{s:3:"bcc";s:10:"malaisamya";})
     1037 / 32205 (  3.2%)  [1561748 items/min]  skipping pm-4109 `to_user_array` is not properly serialized -- {"bcc"=>"qwbouqd"}
pm-4109 has no target (a:1:{s:3:"bcc";s:7:"qwbouqd";})
     3001 / 32205 (  9.3%)  [2795148 items/min]  skipping pm-4191 `to_user_array` is not properly serialized -- {"bcc"=>"grial"}
pm-4191 has no target (a:1:{s:3:"bcc";s:5:"grial";})
     3002 / 32205 (  9.3%)  [2776634 items/min]  skipping pm-4192 `to_user_array` is not properly serialized -- {"bcc"=>"grial"}
pm-4192 has no target (a:1:{s:3:"bcc";s:5:"grial";})
     3003 / 32205 (  9.3%)  [2753579 items/min]  skipping pm-4200 `to_user_array` is not properly serialized -- {"bcc"=>"eagercyber"}
pm-4200 has no target (a:1:{s:3:"bcc";s:10:"eagercyber";})
     3004 / 32205 (  9.3%)  [2736076 items/min]  skipping pm-4207 `to_user_array` is not properly serialized -- {"bcc"=>"eagercyber"}
pm-4207 has no target (a:1:{s:3:"bcc";s:10:"eagercyber";})
     3005 / 32205 (  9.3%)  [2717066 items/min]  skipping pm-4230 `to_user_array` is not properly serialized -- {"bcc"=>"cassj"}
pm-4230 has no target (a:1:{s:3:"bcc";s:5:"cassj";})
     3006 / 32205 (  9.3%)  [2698241 items/min]  skipping pm-4231 `to_user_array` is not properly serialized -- {"bcc"=>"cassj"}
pm-4231 has no target (a:1:{s:3:"bcc";s:5:"cassj";})
     3007 / 32205 (  9.3%)  [2681802 items/min]  skipping pm-4232 `to_user_array` is not properly serialized -- {"bcc"=>"eagercyber"}
pm-4232 has no target (a:1:{s:3:"bcc";s:10:"eagercyber";})
     3008 / 32205 (  9.3%)  [2665656 items/min]  skipping pm-4248 `to_user_array` is not properly serialized -- {"bcc"=>"vino"}
pm-4248 has no target (a:1:{s:3:"bcc";s:4:"vino";})
     3009 / 32205 (  9.3%)  [2649867 items/min]  skipping pm-4249 `to_user_array` is not properly serialized -- {"bcc"=>"vino"}
pm-4249 has no target (a:1:{s:3:"bcc";s:4:"vino";})
     3010 / 32205 (  9.3%)  [2635744 items/min]  skipping pm-4253 `to_user_array` is not properly serialized -- {"bcc"=>"vino"}
pm-4253 has no target (a:1:{s:3:"bcc";s:4:"vino";})
     3011 / 32205 (  9.3%)  [2619564 items/min]  skipping pm-4311 `to_user_array` is not properly serialized -- {"bcc"=>"gopikgunda"}
pm-4311 has no target (a:1:{s:3:"bcc";s:10:"gopikgunda";})
     3012 / 32205 (  9.4%)  [2607145 items/min]  skipping pm-4342 `to_user_array` is not properly serialized -- {"bcc"=>"phonedog365"}
pm-4342 has no target (a:1:{s:3:"bcc";s:11:"phonedog365";})
     3013 / 32205 (  9.4%)  [2592727 items/min]  skipping pm-4345 `to_user_array` is not properly serialized -- {"bcc"=>"Shivdatta"}
pm-4345 has no target (a:1:{s:3:"bcc";s:9:"Shivdatta";})
     3014 / 32205 (  9.4%)  [2574597 items/min]  skipping pm-4352 `to_user_array` is not properly serialized -- {"bcc"=>"rockdude"}
pm-4352 has no target (a:1:{s:3:"bcc";s:8:"rockdude";})
     3015 / 32205 (  9.4%)  [2562711 items/min]  skipping pm-4386 `to_user_array` is not properly serialized -- {"bcc"=>"cassj"}
pm-4386 has no target (a:1:{s:3:"bcc";s:5:"cassj";})
     3016 / 32205 (  9.4%)  [2549188 items/min]  skipping pm-4407 `to_user_array` is not properly serialized -- {"bcc"=>"raghav1982"}
pm-4407 has no target (a:1:{s:3:"bcc";s:10:"raghav1982";})
     3017 / 32205 (  9.4%)  [2533763 items/min]  skipping pm-4418 `to_user_array` is not properly serialized -- {"bcc"=>"ramen_noodle"}
pm-4418 has no target (a:1:{s:3:"bcc";s:12:"ramen_noodle";})
     3018 / 32205 (  9.4%)  [2521530 items/min]  skipping pm-4539 `to_user_array` is not properly serialized -- {"bcc"=>"Sachin Gupta"}
pm-4539 has no target (a:1:{s:3:"bcc";s:12:"Sachin Gupta";})
     3019 / 32205 (  9.4%)  [2507763 items/min]  skipping pm-4546 `to_user_array` is not properly serialized -- {"bcc"=>"cong-lv"}
pm-4546 has no target (a:1:{s:3:"bcc";s:7:"cong-lv";})
     3020 / 32205 (  9.4%)  [2495731 items/min]  skipping pm-4611 `to_user_array` is not properly serialized -- {"bcc"=>"gobinath"}
pm-4611 has no target (a:1:{s:3:"bcc";s:8:"gobinath";})
     3021 / 32205 (  9.4%)  [2481966 items/min]  skipping pm-4614 `to_user_array` is not properly serialized -- {"bcc"=>"scarfake"}
pm-4614 has no target (a:1:{s:3:"bcc";s:8:"scarfake";})
     3022 / 32205 (  9.4%)  [2470577 items/min]  skipping pm-4616 `to_user_array` is not properly serialized -- {"bcc"=>"blowtorch"}
pm-4616 has no target (a:1:{s:3:"bcc";s:9:"blowtorch";})
     3023 / 32205 (  9.4%)  [2454502 items/min]  skipping pm-5456 `to_user_array` is not properly serialized -- {"bcc"=>"Franzlebord"}
pm-5456 has no target (a:1:{s:3:"bcc";s:11:"Franzlebord";})
     4001 / 32205 ( 12.4%)  [2624597 items/min]  skipping pm-5467 `to_user_array` is not properly serialized -- {"bcc"=>"moertono"}
pm-5467 has no target (a:1:{s:3:"bcc";s:8:"moertono";})
     4002 / 32205 ( 12.4%)  [2608371 items/min]  skipping pm-5468 `to_user_array` is not properly serialized -- {"bcc"=>"bullz26"}
pm-5468 has no target (a:1:{s:3:"bcc";s:7:"bullz26";})
     4003 / 32205 ( 12.4%)  [2596854 items/min]  skipping pm-5492 `to_user_array` is not properly serialized -- {"bcc"=>"justintjacob"}
pm-5492 has no target (a:1:{s:3:"bcc";s:12:"justintjacob";})
     4004 / 32205 ( 12.4%)  [2582107 items/min]  skipping pm-5497 `to_user_array` is not properly serialized -- {"bcc"=>"paruthiveeran"}
pm-5497 has no target (a:1:{s:3:"bcc";s:13:"paruthiveeran";})
    23003 / 32205 ( 71.4%)  [2098805 items/min]  
importing attachments...
   815812 / 651396 (125.2%)  SQL Error
Table 'vb5.filedata' doesn't exist
SELECT a.attachmentid attachment_id, a.userid user_id, a.filedataid file_id, a.filename filename,
                  LENGTH(fd.filedata) AS dbsize, filedata, a.caption caption
             FROM attachment a
             LEFT JOIN filedata fd ON fd.filedataid = a.filedataid
            WHERE a.attachmentid = 2723
   834322 / 651396 (128.1%)  SQL Error
Table 'vb5.filedata' doesn't exist
SELECT a.attachmentid attachment_id, a.userid user_id, a.filedataid file_id, a.filename filename,
                  LENGTH(fd.filedata) AS dbsize, filedata, a.caption caption
             FROM attachment a
             LEFT JOIN filedata fd ON fd.filedataid = a.filedataid
            WHERE a.attachmentid = 3135
SQL Error
Table 'vb5.filedata' doesn't exist
SELECT a.attachmentid attachment_id, a.userid user_id, a.filedataid file_id, a.filename filename,
                  LENGTH(fd.filedata) AS dbsize, filedata, a.caption caption
             FROM attachment a
             LEFT JOIN filedata fd ON fd.filedataid = a.filedataid
            WHERE a.attachmentid = 3135
  1013769 / 651396 (155.6%)  SQL Error
Table 'vb5.filedata' doesn't exist
SELECT a.attachmentid attachment_id, a.userid user_id, a.filedataid file_id, a.filename filename,
                  LENGTH(fd.filedata) AS dbsize, filedata, a.caption caption
             FROM attachment a
             LEFT JOIN filedata fd ON fd.filedataid = a.filedataid
            WHERE a.attachmentid = 7575
SQL Error
Table 'vb5.filedata' doesn't exist
SELECT a.attachmentid attachment_id, a.userid user_id, a.filedataid file_id, a.filename filename,
                  LENGTH(fd.filedata) AS dbsize, filedata, a.caption caption
             FROM attachment a
             LEFT JOIN filedata fd ON fd.filedataid = a.filedataid
            WHERE a.attachmentid = 7576
SQL Error
Table 'vb5.filedata' doesn't exist
SELECT a.attachmentid attachment_id, a.userid user_id, a.filedataid file_id, a.filename filename,
                  LENGTH(fd.filedata) AS dbsize, filedata, a.caption caption
             FROM attachment a
             LEFT JOIN filedata fd ON fd.filedataid = a.filedataid
            WHERE a.attachmentid = 7577
SQL Error
Table 'vb5.filedata' doesn't exist
SELECT a.attachmentid attachment_id, a.userid user_id, a.filedataid file_id, a.filename filename,
                  LENGTH(fd.filedata) AS dbsize, filedata, a.caption caption
             FROM attachment a
             LEFT JOIN filedata fd ON fd.filedataid = a.filedataid
            WHERE a.attachmentid = 7578
SQL Error
Table 'vb5.filedata' doesn't exist
SELECT a.attachmentid attachment_id, a.userid user_id, a.filedataid file_id, a.filename filename,
                  LENGTH(fd.filedata) AS dbsize, filedata, a.caption caption
             FROM attachment a
             LEFT JOIN filedata fd ON fd.filedataid = a.filedataid
            WHERE a.attachmentid = 7584
  1059653 / 651396 (162.7%)  
Closing topics...

Postprocessing posts...
  1059653 / 1059653 (100.0%)  
Creating Permalink File...


Updating bumped_at on topics

Updating last posted at on users

Updating last seen at on users

Updating topic reply counts...
   137992 / 137992 (100.0%)  [7363 items/min]     
Updating first_post_created_at...

Updating user post_count...

Updating user topic_count...

Updating topic users

Updating post timings

Updating featured topic users

Updating featured topics in categories
      123 / 123 (100.0%)  [619 items/min]  n]  
Updating user topic reply counts
   137992 / 137992 (100.0%)  [6994 items/min]  ]  
Resetting topic counters


Done (01h 54min 23sec)


Previous Thread | Next Thread
Test Your Knowledge in Computers #775
Difficulty: Medium
UML state machine is a significantly enhanced realization of the mathematical concept of a finite automaton in computer science applications.
True or False?

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Migrate from FTP to SFTP

Hi,I am using following code for FTP in shell script file and it is working.Now I want to migrate from FTP to SFTP.What code changes/steps I have to perform for SFTP ? ftp -in <<FIN open $SAP_UP_SERVER user $SAP_UP_USER $SAP_UP_PASSWORD asc put... (7 Replies)
Discussion started by: Nitin Varshneya
7 Replies

2. BSD

Migrate a Hard Disk

hi Has anyone already tried to migrate a hard disk with FreeBSD using recoverdisk? (1 Reply)
Discussion started by: ccc
1 Replies

3. Linux

Mysql Migrate

Hi , I would like to (MYSQL) migrate the all the data from solari's to linux box. I have checked whether mysql is installed or not. rpm -qa | grep -i mysql I confirmed !!!! I want to know the following points. 1) How can get to know what are mysql data files and location as well.... (4 Replies)
Discussion started by: Mani_apr08
4 Replies

4. Solaris

Migrate from MPXIO to Powerpath

Here is the issue: I am building a database server using Solaris 10x86 U8. The system is jumpstarted with mpxio enabled and booting from the san. We need to have powerpath 5.3 installed and would like to have powerpath take control of the the boot san as well or have mpxio control the san... (2 Replies)
Discussion started by: nabru72
2 Replies

5. Solaris

Can you migrate UFS to ZFS ?

I have some UFS volumes (non root), that I would like to change into ZFS volumes. Is this possible ? I think the only method is to create a new zfs volume and copy the data accoss, this would take a long time for us. Is there a quicker way ? Regards (5 Replies)
Discussion started by: wjones
5 Replies

6. Solaris

Migrate oracle solaris 5.8 5.9

If I have an oracle 9 database environment on a san running solaris 5.8 as the os. Can I plug the san into a Solaris 5.9 environment and have the database work ? - as long as binaries are on the san (1 Reply)
Discussion started by: tim-carroll@com
1 Replies

7. UNIX for Dummies Questions & Answers

Pipe not taken into consideration

I'm trying to see every file which my group (staff) has in a certain directory, recursively. The pipe ls -l -R | grep staff is not working exactly as I want, as for every directory to which my user does not have access, a line like: ls: ./directory/lost+found: The file access permissions do not... (5 Replies)
Discussion started by: panchopp
5 Replies

8. UNIX for Dummies Questions & Answers

How to migrate ?

Currently, I am planning a migration between machine which under True64UNIX. The new machine will run with higher version O/S. My question is, is there any solution on migrating one machine to another which with different O/S version? My goal is keeping minimum impact to the users. Excuse my... (1 Reply)
Discussion started by: coolmans
1 Replies

Featured Tech Videos