Ошибка сериализации после репликации на магазин : УКМ-4

VitorJ · █ 01.11.2014 23:01

Добрый день!
Подскажите, ни кто не сталкивался с такого рода ошибкой????

Код:

02.11.2014 04:36:51	0x00000264	FATAL	Global	Ошибка сериализации: отсутствует параметр params в XML

Данная ошибка появилась после не корректного выключения сервера, СГО.
Сам сервер СГО работает, но пытаешся подключить к нему новый магазин проходи репликация, причем какая то странная, не полная. Часть информации реплицируется, вторую можно реплицировать путем пере сохранения данных в БД, но так не должно быть. Должно все проскакивать на раз при первичной репликации. Уже весь мозг сломал.

OlegON · █ 01.11.2014 23:07

На ФС нет ошибок? В журнале мускула?

VitorJ · █ 01.11.2014 23:19

Кусок лога с СГО

Код:

2014-11-02 00:09:08 1280 [Warning] Aborted connection 3 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got an error reading communication packets)
2014-11-02 00:09:08 1280 [Warning] Aborted connection 4 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got an error reading communication packets)
2014-11-02 00:09:08 1280 [Warning] Aborted connection 5 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got an error reading communication packets)
2014-11-02 00:09:08 1280 [Warning] Aborted connection 6 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got an error reading communication packets)
2014-11-02 00:09:08 1280 [Warning] Aborted connection 7 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got an error reading communication packets)
2014-11-02 00:09:08 1280 [Warning] Aborted connection 9 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got an error reading communication packets)
2014-11-02 00:09:08 1280 [Warning] Aborted connection 11 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got an error reading communication packets)
2014-11-02 00:09:08 1280 [Warning] Aborted connection 12 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got an error reading communication packets)
2014-11-02 00:09:08 1280 [Warning] Aborted connection 13 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got an error reading communication packets)
2014-11-02 00:09:08 1280 [Warning] Aborted connection 14 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got an error reading communication packets)
2014-11-02 00:09:08 1280 [Warning] Aborted connection 15 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got an error reading communication packets)
2014-11-02 00:09:08 1280 [Warning] Aborted connection 16 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got an error reading communication packets)
2014-11-02 00:09:08 1280 [Warning] Aborted connection 17 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got an error reading communication packets)
2014-11-02 00:09:08 1280 [Warning] Aborted connection 18 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got an error reading communication packets)
2014-11-02 00:09:08 1280 [Warning] Aborted connection 19 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got an error reading communication packets)
2014-11-02 00:09:08 1280 [Warning] Aborted connection 20 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got an error reading communication packets)
2014-11-02 00:09:08 1280 [Warning] Aborted connection 21 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got an error reading communication packets)
2014-11-02 00:09:08 1280 [Warning] Aborted connection 27 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got an error reading communication packets)
2014-11-02 00:09:08 1280 [Warning] Aborted connection 42 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got an error reading communication packets)
2014-11-02 00:22:09 1280 [Warning] Aborted connection 8 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got an error writing communication packets)
2014-11-02 00:27:46 1280 [Warning] Aborted connection 10 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got an error writing communication packets)
2014-11-02 04:02:59 1280 [Warning] Aborted connection 473 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2014-11-02 04:03:01 1280 [Note] MySQL: Normal shutdown

2014-11-02 04:03:01 1280 [Note] Giving 32 client threads a chance to die gracefully
2014-11-02 04:03:01 1280 [Note] Event Scheduler: Purging the queue. 0 events
2014-11-02 04:03:01 1280 [Note] Shutting down slave threads
2014-11-02 04:03:03 1280 [Note] Forcefully disconnecting 22 remaining clients
2014-11-02 04:03:03 1280 [Warning] MySQL: Forcing close of thread 1  user: 'ukm_server'

2014-11-02 04:03:03 1280 [Warning] MySQL: Forcing close of thread 639  user: 'ukm_server'

2014-11-02 04:03:03 1280 [Warning] MySQL: Forcing close of thread 638  user: 'ukm_server'

2014-11-02 04:03:03 1280 [Warning] MySQL: Forcing close of thread 637  user: 'ukm_server'

2014-11-02 04:03:03 1280 [Warning] MySQL: Forcing close of thread 650  user: 'ukm_server'

2014-11-02 04:03:03 1280 [Warning] MySQL: Forcing close of thread 651  user: 'ukm_server'

2014-11-02 04:03:03 1280 [Warning] MySQL: Forcing close of thread 641  user: 'ukm_server'

2014-11-02 04:03:03 1280 [Warning] MySQL: Forcing close of thread 647  user: 'ukm_server'

2014-11-02 04:03:03 1280 [Warning] MySQL: Forcing close of thread 649  user: 'ukm_server'

2014-11-02 04:03:03 1280 [Warning] MySQL: Forcing close of thread 636  user: 'ukm_server'

2014-11-02 04:03:03 1280 [Warning] MySQL: Forcing close of thread 646  user: 'ukm_server'

2014-11-02 04:03:03 1280 [Warning] MySQL: Forcing close of thread 645  user: 'ukm_server'

2014-11-02 04:03:03 1280 [Warning] MySQL: Forcing close of thread 643  user: 'ukm_server'

2014-11-02 04:03:03 1280 [Warning] MySQL: Forcing close of thread 644  user: 'ukm_server'

2014-11-02 04:03:03 1280 [Warning] MySQL: Forcing close of thread 642  user: 'ukm_server'

2014-11-02 04:03:03 1280 [Warning] MySQL: Forcing close of thread 648  user: 'ukm_server'

2014-11-02 04:03:03 1280 [Warning] MySQL: Forcing close of thread 453  user: 'ukm_web'

2014-11-02 04:03:03 1280 [Warning] MySQL: Forcing close of thread 652  user: 'ukm_server'

2014-11-02 04:03:03 1280 [Warning] MySQL: Forcing close of thread 653  user: 'ukm_server'

2014-11-02 04:03:03 1280 [Warning] MySQL: Forcing close of thread 654  user: 'ukm_server'

2014-11-02 04:03:03 1280 [Warning] MySQL: Forcing close of thread 675  user: 'ukm_server'

2014-11-02 04:03:03 1280 [Warning] MySQL: Forcing close of thread 660  user: 'ukm_server'

2014-11-02 04:03:03 1280 [Note] Binlog end
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'partition'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_METRICS'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_CMP'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'INNODB_TRX'
2014-11-02 04:03:03 1280 [Note] Shutting down plugin 'InnoDB'
2014-11-02 04:03:03 1280 [Note] InnoDB: FTS optimize thread exiting.
2014-11-02 04:03:03 1280 [Note] InnoDB: Starting shutdown...
2014-11-02 04:03:05 1280 [Note] InnoDB: Shutdown completed; log sequence number 150170580396
2014-11-02 04:03:05 1280 [Note] Shutting down plugin 'BLACKHOLE'
2014-11-02 04:03:05 1280 [Note] Shutting down plugin 'ARCHIVE'
2014-11-02 04:03:05 1280 [Note] Shutting down plugin 'MRG_MYISAM'
2014-11-02 04:03:05 1280 [Note] Shutting down plugin 'MyISAM'
2014-11-02 04:03:05 1280 [Note] Shutting down plugin 'MEMORY'
2014-11-02 04:03:05 1280 [Note] Shutting down plugin 'CSV'
2014-11-02 04:03:05 1280 [Note] Shutting down plugin 'sha256_password'
2014-11-02 04:03:05 1280 [Note] Shutting down plugin 'mysql_old_password'
2014-11-02 04:03:05 1280 [Note] Shutting down plugin 'mysql_native_password'
2014-11-02 04:03:05 1280 [Note] Shutting down plugin 'binlog'
2014-11-02 04:03:05 1280 [Note] MySQL: Shutdown complete

2014-11-02 04:06:53 1604 [Note] Plugin 'FEDERATED' is disabled.
2014-11-02 04:06:54 1604 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-11-02 04:06:54 1604 [Note] InnoDB: The InnoDB memory heap is disabled
2014-11-02 04:06:54 1604 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-11-02 04:06:54 1604 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-11-02 04:06:54 1604 [Note] InnoDB: Not using CPU crc32 instructions
2014-11-02 04:06:54 1604 [Note] InnoDB: Initializing buffer pool, size = 80.0M
2014-11-02 04:06:54 1604 [Note] InnoDB: Completed initialization of buffer pool
2014-11-02 04:06:54 1604 [Note] InnoDB: Highest supported file format is Barracuda.
2014-11-02 04:06:55 1604 [Note] InnoDB: 128 rollback segment(s) are active.
2014-11-02 04:06:55 1604 [Note] InnoDB: Waiting for purge to start
2014-11-02 04:06:55 1604 [Note] InnoDB: 5.6.17 started; log sequence number 150170580396
2014-11-02 04:06:55 1604 [Note] Server hostname (bind-address): '*'; port: 3306
2014-11-02 04:06:55 1604 [Note] IPv6 is available.
2014-11-02 04:06:55 1604 [Note]   - '::' resolves to '::';
2014-11-02 04:06:55 1604 [Note] Server socket created on IP: '::'.
2014-11-02 04:06:56 1604 [Note] Event Scheduler: Loaded 0 events
2014-11-02 04:06:56 1604 [Note] MySQL: ready for connections.
Version: '5.6.17'  socket: ''  port: 3306  MySQL Community Server (GPL)

Самые первые записи что не мог обработать пакет, после этого все и завалилось

VitorJ · █ 01.11.2014 23:22

На магазине

Код:

2014-11-02 03:11:50 6148 [Note] Plugin 'FEDERATED' is disabled.
2014-11-02 03:11:50 6148 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-11-02 03:11:50 6148 [Note] InnoDB: The InnoDB memory heap is disabled
2014-11-02 03:11:50 6148 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-11-02 03:11:50 6148 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-11-02 03:11:51 6148 [Note] InnoDB: Not using CPU crc32 instructions
2014-11-02 03:11:51 6148 [Note] InnoDB: Initializing buffer pool, size = 80.0M
2014-11-02 03:11:51 6148 [Note] InnoDB: Completed initialization of buffer pool
2014-11-02 03:11:51 6148 [Note] InnoDB: Setting log file .\ib_logfile101 size to 20 MB
2014-11-02 03:11:51 6148 [Note] InnoDB: Setting log file .\ib_logfile1 size to 20 MB
2014-11-02 03:11:52 6148 [Note] InnoDB: Renaming log file .\ib_logfile101 to .\ib_logfile0
2014-11-02 03:11:52 6148 [Warning] InnoDB: New log files created, LSN=1625977
2014-11-02 03:11:52 6148 [Note] InnoDB: Highest supported file format is Barracuda.
2014-11-02 03:11:52 6148 [Note] InnoDB: 128 rollback segment(s) are active.
2014-11-02 03:11:52 6148 [Note] InnoDB: Waiting for purge to start
2014-11-02 03:11:53 6148 [Note] InnoDB: 5.6.17 started; log sequence number 1626124
2014-11-02 03:11:53 6148 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 8eb1ede6-61f2-11e4-86e4-10bf4872898d.
2014-11-02 03:11:53 6148 [Note] Server hostname (bind-address): '*'; port: 3306
2014-11-02 03:11:55 6148 [Note] IPv6 is not available.
2014-11-02 03:11:55 6148 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2014-11-02 03:11:55 6148 [Note] Server socket created on IP: '0.0.0.0'.
2014-11-02 03:11:56 6148 [Note] Event Scheduler: Loaded 0 events
2014-11-02 03:11:56 6148 [Note] MySQL: ready for connections.
Version: '5.6.17'  socket: ''  port: 3306  MySQL Community Server (GPL)

VitorJ · █ 01.11.2014 23:27

Извиняюсь конечно, но видать уже все мозг отказывает ФС это что???

OlegON · █ 02.11.2014 09:04

ФС - это Файловая Система, в журнале что из этого относится ко времени репликации?

VitorJ · █ 02.11.2014 11:27

Добрый день!
В журналах все чисто, восстановил БД из резервной копии, работает!
Но как то не хочется, выхватывать такие сюрпризы.

Павел Сосновских · █ 05.11.2014 10:16

Цитата:

VitorJ ➤ ошибка появилась после не корректного выключения сервера, СГО

это причина.
последствия - повреждение бд.
если она работала(судя по логам это так), скорее всего помог бы mysqlcheck