Jump to content
Search In
  • More options...
Find results that contain...
Find results in...

Всем привет!
Ребята, есть проблема.
На сервере рандомно, в течении нескольких часов выкидывает всех в лобби. После этого на сервере пропадают все машины, то есть база становится девственной и спавнит новые машины.
После рестарта машины возвращаются И суммируются с новосозданными.

Возможно ли это из-за, того что я в mysql прописал event_scheduller=on, так как без него эвенты не работали?

Вот логи ошибок:

2014-05-27 14:43:25 1868 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2014-05-27 14:43:26 1868 [Note] Giving 1 client threads a chance to die gracefully
2014-05-27 14:43:26 1868 [Note] Event Scheduler: Killing the scheduler thread, thread id 1
2014-05-27 14:43:26 1868 [Note] Event Scheduler: Waiting for the scheduler thread to reply
2014-05-27 14:43:26 1868 [Note] Event Scheduler: Stopped
2014-05-27 14:43:26 1868 [Note] Event Scheduler: Purging the queue. 6 events
2014-05-27 14:43:26 1868 [Note] Shutting down slave threads
2014-05-27 14:43:26 1868 [Note] Forcefully disconnecting 0 remaining clients
2014-05-27 14:43:26 1868 [Note] Binlog end
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'partition'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_METRICS'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_CMP'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'INNODB_TRX'
2014-05-27 14:43:31 1868 [Note] Shutting down plugin 'InnoDB'
2014-05-27 14:43:31 1868 [Note] InnoDB: FTS optimize thread exiting.
2014-05-27 14:43:31 1868 [Note] InnoDB: Starting shutdown...
2014-05-27 16:53:17 1812 [Note] Plugin 'FEDERATED' is disabled.
2014-05-27 16:53:17 738 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-05-27 16:53:17 1812 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-05-27 16:53:17 1812 [Note] InnoDB: The InnoDB memory heap is disabled
2014-05-27 16:53:17 1812 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-05-27 16:53:17 1812 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-05-27 16:53:17 1812 [Note] InnoDB: Not using CPU crc32 instructions
2014-05-27 16:53:17 1812 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-05-27 16:53:17 1812 [Note] InnoDB: Completed initialization of buffer pool
2014-05-27 16:53:17 1812 [Note] InnoDB: Highest supported file format is Barracuda.
2014-05-27 16:53:17 1812 [Note] InnoDB: Log scan progressed past the checkpoint lsn 245698205
2014-05-27 16:53:17 1812 [Note] InnoDB: Database was not shutdown normally!
2014-05-27 16:53:17 1812 [Note] InnoDB: Starting crash recovery.
2014-05-27 16:53:17 1812 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-05-27 16:53:19 1812 [Note] InnoDB: Restoring possible half-written data pages 
2014-05-27 16:53:19 1812 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 245698423
2014-05-27 16:53:19 1812 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
InnoDB: Apply batch completed
2014-05-27 16:53:20 1812 [Note] InnoDB: 128 rollback segment(s) are active.
2014-05-27 16:53:20 1812 [Note] InnoDB: Waiting for purge to start
2014-05-27 16:53:20 1812 [Note] InnoDB: 5.6.16 started; log sequence number 245698423
2014-05-27 16:53:20 1812 [Note] Server hostname (bind-address): '*'; port: 3306
2014-05-27 16:53:20 1812 [Note] IPv6 is available.
2014-05-27 16:53:20 1812 [Note]   - '::' resolves to '::';
2014-05-27 16:53:20 1812 [Note] Server socket created on IP: '::'.
2014-05-27 16:53:20 1812 [Note] Event Scheduler: Loaded 6 events
2014-05-27 16:53:20 1812 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.

База идет с Xamppo-м. Я продолжаю гуглить в яндексе, но надеюсь вы мне поможете)

UPD.  Только что опять выкинуло всех в лобби, но в логах базы, всё пусто.

Edited by Tooker (see edit history)

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0
 

ты проверь повторяется ли проблема с отключенным event_scheduller, если нет значит смотри что ты напортачил в эвентах.

Share this post


Link to post
Share on other sites



Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Similar Content

    • By Vintem87
      Доброго всем времени суток, в общем есть проблемка с сервером, 6 часов безрезультатного поиска решения проблемы ни чего не дали.
      Прошу вашей помощи
      Проблема в следующем, когда я захожу на сервер уже нажав ОК у меня доходит до стадии связанной с autentification и все.
      Дальше проходит какое-то время и его выкидывает в зал ожидания, без всяких надписей и ошибок, и так у любого что пытается присоединиться.
      Если нужна более подробная инфа, вы говорите, выложу что надо
       
      Иногда выкидывает с такой ошибкой
      на скриншоте ниже
       

      Пожалуйста, Войдите или Зарегистрируйтесь, чтобы увидеть это: Вложение.
    • By BigCrazyCat
      После некоторого времени всех игроков выкидывает в лобби и идет как бы рестарт миссии. В чем может быть трабла?
×
×
  • Create New...

Important Information

By using this site, you automaticly agree to our Guidelines and Privacy Policy.
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.