[Bucardo-general] Wrong value for one field
Ioana Danes
ioanadanes at gmail.com
Tue Aug 9 15:22:37 UTC 2016
On Mon, Aug 8, 2016 at 3:14 PM, Ioana Danes <ioanadanes at gmail.com> wrote:
> Hello Greg,
>
> On Mon, Aug 8, 2016 at 2:54 PM, Greg Sabino Mullane <greg at endpoint.com>
> 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 = nobody at example.com
> default_email_host = localhost
> default_email_port = 25
> default_email_to = nobody at example.com
> 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 greg at endpoint.com
>> End Point Corporation
>> PGP Key: 0x14964AC8
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20160809/481451f4/attachment.html>
More information about the Bucardo-general
mailing list