On Mon, Aug 8, 2016 at 3:14 PM, Ioana Danes <[email protected]> wrote:
> Hello Greg, > > On Mon, Aug 8, 2016 at 2:54 PM, Greg Sabino Mullane <[email protected]> > wrote: > >> On Mon, Aug 08, 2016 at 02:14:06PM -0400, Ioana Danes wrote: >> > So I either have a replication issue + index corruption on db3 or a data >> > corruption on db3... >> > >> > Any ideas, thoughts? >> >> Can you send the table structure, along with the information about the >> syncs? >> >> > Here is the table structure, Unfortunately I had to rename the table and > the fields for security reasons please let me know of that is all right > > Table "mytable " > > > > Column | Type | Modifiers > > ---------------------+--------------------------+-------------------- > > Field1 | bigint | not null > > Field2 | integer | not null > > Field3 | integer | not null > > Field4 | bigint | not null > > Field5 | integer | not null > > Field6 | integer | not null default 1 > > Field7 | integer | not null default 1 > > Field8 | integer | > > Field9 | numeric | not null > > Field10 | character varying(64) | > > Field11 | character varying(100) | > > Field12 | character varying(100) | not null > > Field13 | character varying(2048) | not null > > Field14 | timestamp with time zone | not null > > Field15 | bigint | > > Field16 | integer | not null default 0 > > Field17 | numeric | not null default 0 > > Indexes: > > "pk_mytable" PRIMARY KEY, btree (Field1) > > "ix_1" btree (Field14) > > "ix_2" btree (Field5) > > "ix_3" btree (Field3) > > "ix_4" btree (Field4) > > Foreign-key constraints: > > …. > > Triggers: > > bucardo_delta AFTER INSERT OR DELETE OR UPDATE ON mytable FOR EACH > ROW EXECUTE PROCEDURE bucardo.delta_mytable () > > bucardo_note_trunc_sync_13 AFTER TRUNCATE mytable FOR EACH STATEMENT > EXECUTE PROCEDURE bucardo.bucardo_note_truncation('sync_13') > > bucardo_note_trunc_sync_main AFTER TRUNCATE ON mytable FOR EACH > STATEMENT EXECUTE PROCEDURE bucardo.bucardo_note_truncation('sync_main') > > > bucardo show all > > autosync_ddl = newcol > bucardo_initial_version = 5.4.1 > bucardo_vac = 1 > bucardo_version = 5.4.1 > ctl_checkonkids_time = 10 > ctl_createkid_time = 0.5 > ctl_sleep = 0.2 > default_conflict_strategy = bucardo_latest > default_email_from = [email protected] > default_email_host = localhost > default_email_port = 25 > default_email_to = [email protected] > email_auth_pass = > email_auth_user = > email_debug_file = > endsync_sleep = 1.0 > flatfile_dir = . > host_safety_check = > isolation_level = repeatable read > kid_deadlock_sleep = 0.5 > kid_nodeltarows_sleep = 0.5 > kid_pingtime = 60 > kid_restart_sleep = 1 > kid_serial_sleep = 0.5 > kid_sleep = 0.5 > log_conflict_file = /var/log/bucardo/bucardo_conflict.log > log_level = normal > log_microsecond = 0 > log_showlevel = 0 > log_showline = 0 > log_showpid = 1 > log_showsyncname = 1 > log_showtime = 3 > mcp_dbproblem_sleep = 15 > mcp_loop_sleep = 0.2 > mcp_pingtime = 60 > mcp_vactime = 60 > piddir = /var/run/bucardo > quick_delta_check = 1 > reason_file = /var/log/bucardo/bucardo.restart.reason.txt > reload_config_timeout = 30 > semaphore_table = bucardo_status > statement_chunk_size = 5000 > stats_script_url = http://www.bucardo.org/ > stopfile = fullstopbucardo > syslog_facility = log_local1 > tcp_keepalives_count = 0 > tcp_keepalives_idle = 0 > tcp_keepalives_interval = 0 > vac_run = 30 > vac_sleep = 120 > warning_file = bucardo.warning.log > > > bucardo status all > ====================================================================== > Last good : Aug 08, 2016 15:10:49 (time to run: 1s) > Rows deleted/inserted : 0 / 0 > Last bad : Aug 08, 2016 08:50:05 (time until fail: 1s) > Sync name : sync_13 > Current state : Good > Source relgroup/database : herd_all / bucardo_db1 > Tables in sync : 199 > Status : Active > Check time : None > Overdue time : 00:00:00 > Expired time : 00:00:00 > Stayalive/Kidsalive : Yes / Yes > Rebuild index : No > Autokick : No > Onetimecopy : No > Last error: : Failed : DBD::Pg::db do failed: FATAL: > terminating connection due to administrator command server closed the > connection unexpectedly This probably means the server terminated > abnormally before or while processing the request. at > /usr/share/perl5/vendor_perl/Bucardo.pm line 5133. Line: 5041 Main DB > state: ? Error: none DB bucardo_db1 state: ? Error: none DB bucardo_db3 > state: 57P01 Error: 7 (KID 5802) > ====================================================================== > > db1 has 1 sync: > - sync_13: db1 -> db3 > > db2 has 2 syncs: > - sync_main: 2 way replication between db1 and db2 (db1 <-> db2) > - sync_23: db2 -> db3 > > At the time of the replication db1 was the main database. > > please let me know if you need anything else. > > Thank you, > ioana > > (bucardo show all will provide the latter) >> >> -- >> Greg Sabino Mullane [email protected] >> End Point Corporation >> PGP Key: 0x14964AC8 >> > >
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
