Форум OlegON > Программы и оборудование для автоматизации торговли > Кассовые программы > УКМ-4

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

18.04.2024 14:50


01.11.2014 23:01
VitorJ
 
Добрый день!
Подскажите, ни кто не сталкивался с такого рода ошибкой????
Код:
02.11.2014 04:36:51	0x00000264	FATAL	Global	Ошибка сериализации: отсутствует параметр params в XML
Данная ошибка появилась после не корректного выключения сервера, СГО.
Сам сервер СГО работает, но пытаешся подключить к нему новый магазин проходи репликация, причем какая то странная, не полная. Часть информации реплицируется, вторую можно реплицировать путем пере сохранения данных в БД, но так не должно быть. Должно все проскакивать на раз при первичной репликации. Уже весь мозг сломал.
01.11.2014 23:07
OlegON
 
На ФС нет ошибок? В журнале мускула?
01.11.2014 23:19
VitorJ
 
Кусок лога с СГО
Код:
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)
Самые первые записи что не мог обработать пакет, после этого все и завалилось
01.11.2014 23:22
VitorJ
 
На магазине

Код:
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)
01.11.2014 23:27
VitorJ
 
Извиняюсь конечно, но видать уже все мозг отказывает ФС это что???
02.11.2014 09:04
OlegON
 
ФС - это Файловая Система, в журнале что из этого относится ко времени репликации?
02.11.2014 11:27
VitorJ
 
Добрый день!
В журналах все чисто, восстановил БД из резервной копии, работает!
Но как то не хочется, выхватывать такие сюрпризы.
05.11.2014 10:16
Павел Сосновских
 
Цитата:
VitorJ ошибка появилась после не корректного выключения сервера, СГО
это причина.
последствия - повреждение бд.
если она работала(судя по логам это так), скорее всего помог бы mysqlcheck
Часовой пояс GMT +3, время: 14:50.

Форум на базе vBulletin®
Copyright © Jelsoft Enterprises Ltd.
В случае заимствования информации гипертекстовая индексируемая ссылка на Форум обязательна.