Skip to content

Instantly share code, notes, and snippets.

@mbn18

mbn18/log Secret

Created February 24, 2016 19:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mbn18/2105abdce89a619d57cd to your computer and use it in GitHub Desktop.
Save mbn18/2105abdce89a619d57cd to your computer and use it in GitHub Desktop.
Error in bucardo 5.4.1
(16753) [Wed Feb 24 14:43:37 2016] KID (sa_sync) New kid, sync "sa_sync" alive=1 Parent=15676 PID=16753 kicked=1
(16753) [Wed Feb 24 14:43:37 2016] KID (sa_sync) Delta count for sa_master.public.chat_entries : 408
(16753) [Wed Feb 24 14:43:37 2016] KID (sa_sync) Warning! Aborting due to exception for public.chat_entries:? Error was DBD::Pg::db pg_result failed: ERROR: malformed array literal: "ARRAY(0x2084238)"\nLINE 1: ...RE ("tag_id","private_to","seq_id") IN ( ('35508','ARRAY(0x2...\n ^\nDETAIL: Array value must start with "{" or dimension information. at /usr/local/share/perl5/Bucardo.pm line 9536.
(16753) [Wed Feb 24 14:43:37 2016] KID (sa_sync) Kid has died, error is: DBD::Pg::db pg_result failed: ERROR: malformed array literal: "ARRAY(0x2084238)"\nLINE 1: ...RE ("tag_id","private_to","seq_id") IN ( ('35508','ARRAY(0x2...\n ^\nDETAIL: Array value must start with "{" or dimension information. at /usr/local/share/perl5/Bucardo.pm line 9536. Line: 5041 Main DB state: ? Error: none DB sa_master state: ? Error: none DB sa_slave state: 22P02 Error: 7
(16753) [Wed Feb 24 14:43:37 2016] KID (sa_sync) Kid 16753 exiting at cleanup_kid. Sync "sa_sync" public.chat_entries Reason: DBD::Pg::db pg_result failed: ERROR: malformed array literal: "ARRAY(0x2084238)"\nLINE 1: ...RE ("tag_id","private_to","seq_id") IN ( ('35508','ARRAY(0x2...\n ^\nDETAIL: Array value must start with "{" or dimension information. at /usr/local/share/perl5/Bucardo.pm line 9536. Line: 5041 Main DB state: ? Error: none DB sa_master state: ? Error: none DB sa_slave state: 22P02 Error: 7
(15661) [Wed Feb 24 14:43:37 2016] MCP Starting check_sync_health
@mbn18
Copy link
Author

mbn18 commented Feb 24, 2016

 \d chat_entries
                         Table "public.chat_entries"
   Column   |            Type             |            Modifiers             
------------+-----------------------------+----------------------------------
 tag_id     | integer                     | not null
 seq_id     | bigint                      | not null
 user_id    | integer                     | not null
 created_at | timestamp without time zone | not null
 private_to | integer[]                   | not null default '{}'::integer[]
 user_nick  | text                        | not null
 content    | text                        | 
Indexes:
    "chat_entries_pkey" PRIMARY KEY, btree (tag_id, private_to, seq_id)
    "index_chat_entries_for_history" btree (tag_id, private_to, created_at)
    "index_chat_entries_on_user_id_and_created_at" btree (user_id, created_at)
    "private_to_idx" gin (private_to gin__int_ops)

@mbn18
Copy link
Author

mbn18 commented Feb 26, 2016

This is the test result

Bucardo-5.4.1]$ make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01-basic.t ................. ok     
t/02-bctl-customname.t ....... ok     
t/02-bctl-db.t ............... ok     
t/02-bctl-dbg.t .............. ok     
t/02-bctl-herd.t ............. ok   
t/02-bctl-sync.t ............. ok   
t/02-bctl-table.t ............ ok     
t/10-fullcopy.t .............. 47/83 
#   Failed test 'Sequence bucardo_test_seq1 NOT the same'
#   at t/BucardoTesting.pm line 1941.
# start_value is different on A vs B: 20 vs 1
# min_value is different on A vs B: 10 vs 1
# max_value is different on A vs B: 100 vs 9223372036854775807
# start_value is different on A vs C: 20 vs 1
# min_value is different on A vs C: 10 vs 1
# max_value is different on A vs C: 100 vs 9223372036854775807
# start_value is different on A vs D: 20 vs 1
# min_value is different on A vs D: 10 vs 1
# max_value is different on A vs D: 100 vs 9223372036854775807
t/10-fullcopy.t .............. 83/83 # Looks like you failed 1 test of 83.
t/10-fullcopy.t .............. Dubious, test returned 1 (wstat 256, 0x100)
Failed 1/83 subtests 
t/10-makedelta.t ............. ok     
t/10-object-names.t .......... skipped: Test skipped unless DBD::Pg is version 3 or higher: this is 2.15.1
t/20-drizzle.t ............... skipped: Cannot test Drizzle unless the Perl module DBD::drizzle is installed
t/20-mariadb.t ............... skipped: Cannot test MariaDB unless the Perl module DBD::mysql is installed
t/20-mongo.t ................. skipped: Cannot test mongo unless the Perl module MongoDB is installed
t/20-mysql.t ................. skipped: Cannot test MySQL unless the Perl module DBD::mysql is installed
t/20-oracle.t ................ skipped: Cannot test Oracle unless the Perl module DBD::Oracle is installed
t/20-postgres.t .............. ok       
t/20-redis.t ................. skipped: Cannot test Redis unless the Perl module Redis is installed
t/20-sqlite.t ................ ok     
t/30-crash.t ................. ok    
t/30-delta.t ................. 32/164
#   Failed test 'The delta table delta_public_bucardo_test8 contains the correct id'
#   at t/30-delta.t line 114.
#     Structures begin differing at:
#          $got->[0][0] = 'x31005a'
#     $expected->[0][0] = '1Z'
Died at t/30-delta.t line 114.
# Looks like you planned 164 tests but ran 52.
# Looks like you failed 1 test of 52 run.
t/30-delta.t ................. Dubious, test returned 1 (wstat 256, 0x100)
Failed 113/164 subtests 
t/40-conflict.t .............. ok     
t/40-customcode-exception.t .. ok    
t/40-serializable.t .......... ok     
t/50-star.t .................. ok    
t/98-cleanup.t ............... ok   
t/99-signature.t ............. skipped: Test skipped unless environment variable RELEASE_TESTING is set

Test Summary Report
-------------------
t/10-fullcopy.t            (Wstat: 256 Tests: 83 Failed: 1)
  Failed test:  81
  Non-zero exit status: 1
t/30-delta.t               (Wstat: 256 Tests: 52 Failed: 1)
  Failed test:  52
  Non-zero exit status: 1
  Parse errors: Bad plan.  You planned 164 tests but ran 52.
Files=26, Tests=1543, 300 wallclock secs ( 0.40 usr  0.06 sys + 88.33 cusr 12.31 csys = 101.10 CPU)
Result: FAIL
Failed 2/26 test programs. 2/1543 subtests failed.
make: *** [test_dynamic] Error 255

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment