[LV1] 2021-12-21 22:10:18: flush all cache data...
[INF] 2021-12-21 22:10:18: extract start pos 00000045:00000115:0003...
[LV1] nextlsn: 00000045:00000115:0003 un_commit_lsn: 00000045:00000115:0003
[LV1] SQL-> SELECT [Current LSN],[Operation],[Context],[Transaction ID],[End Time],[Page ID],[Slot ID],[Offset in Row],[PartitionId],[Description],[RowLog Contents 0],[RowLog Contents 1] FROM [sys].[fn_dblog]('0x00000045:00000115:0003',NULL) order by [Current LSN]
error at file[sqlserver/svrlog.c] line[277], ZCBUS-41007: expect next current lsn is 00000045:00000115:0003, but get 00000047:00000268:002b, log maybe truncate
error at file[sqlsvr.c] line[727], ZCBUS-41007: expect next current lsn is 00000045:00000115:0003, but get 00000047:00000268:002b, log maybe truncate
error at file[sqlsvr.c] line[803], ZCBUS-41007: expect next current lsn is 00000045:00000115:0003, but get 00000047:00000268:002b, log maybe truncate
error at file[sqlserver/svrlog.c] line[637], ZCBUS-41007: expect next current lsn is 00000045:00000115:0003, but get 00000047:00000268:002b, log maybe truncate
[ERR] svrlog_extract, ZCBUS-41007: expect next current lsn is 00000045:00000115:0003, but get 00000047:00000268:002b, log maybe truncate
[ERR] log_parser_extract, ZCBUS-41007: expect next current lsn is 00000045:00000115:0003, but get 00000047:00000268:002b, log maybe truncate
[LV1] SQL-> replace into bus_push_exception_data(nodeid,module,VERSION,daytime,code,context) values(?,?,?,now(),?,?)
[ERR] sleep 10s and retry...
[LV1] SQL-> select status from bus_cluster_container_customer where customerid=37593 and type='zcbus' and subtype='real'
[LV1] SQL-> select syncflag,realflag from bus_push_status_tb where nodeid=37593
[LV1] SQL-> select status from bus_cluster_container_customer where customerid=37593 and type='zcbus' and subtype='real'
[LV1] SQL-> select syncflag,realflag from bus_push_status_tb where nodeid=37593
[INF] 2021-12-21 22:10:28: check repair tables...
[LV1] SQL-> select r.tableid,r.file_path,r.condition,b.tableSchema,b.tableName,b.realTopic from bus_push_repair_tb r,bus_in_tables b where r.status = 1 and b.nodeid=37593 and r.tableid=b.id limit 1
[LV1] 2021-12-21 22:10:28: flush all cache data...
[INF] 2021-12-21 22:10:28: extract start pos 00000045:00000115:0003...
[INF] set client charset UTF-8
[INF] set TDSVER=auto
[LV1] SQL-> use cdc_testdb
Changed database context to 'cdc_testdb'.
[LV1] SQL-> select @@version
[INF] version: Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
.
[INF] SET ARITHABORT ON
[LV1] SQL-> SET ARITHABORT ON
[LV1] SQL-> SELECT cast(COLLATIONPROPERTY('Chinese_PRC_Stroke_CI_AI_KS_WS', 'CodePage') as bigint)
[INF] charset: 936 GBK
[LV1] SQL-> select cast(SERVERPROPERTY('ProductVersion') as varchar(64))
[INF] version number: 10.
[LV1] SQL-> SELECT cast(COLLATIONPROPERTY('Chinese_PRC_Stroke_CI_AI_KS_WS', 'CodePage') as bigint)
[INF] charset: 936 GBK
[LV1] SQL-> dbcc traceon(3604)
zcbus Message 2528 severity 0 state 1 line 1:
"DBCC execution completed. If DBCC printed error messages, contact your system administrator."
[INF] set client charset UTF-8
[INF] set TDSVER=auto
[LV1] SQL-> use cdc_testdb
Changed database context to 'cdc_testdb'.
[LV1] SQL-> select @@version
[INF] version: Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
.
修改数据库模式为完全模式
文档更新时间: 2021-12-21 04:13 作者:阿力