- Главная Список форумов Ошибки Open Server
- Поиск
-
- Текущее время: 25 апр 2024, 02:49
- Часовой пояс: UTC+03:00
MSSQL по идее занимает порты 1433-1434, так что не знаю причем тут у вас порт 80. Он ни MySQL ни MSSQL не нужен.shama186 писал(а):Здравствуйте!
Если у меня установлен локальный сервер MS SQL Express, а мне нужно параллельно работать с Open-Server, то как запустить их паралелльно, т.к. порт 80 занимает как я понял процесс 4, скорее всего MSSQL, т.к. IIS отключен, до установки MSSQL-ля openserver нормально запускался. Мне нужна параллельная работа обоих серверов.
В логах запуска вижу следующую картину:innodb_buffer_pool_size = 10M
innodb_additional_mem_pool_size = 1M
innodb_log_file_size = 10M
innodb_log_buffer_size = 1M
innodb_log_files_in_group = 2
Проблема появилась из-за внезапного отключения питания. Я не мастак в области администрирования mysql, поэтому спрошу тут (хоть и думаю, что это вопрос скорее не сюда, а на хабр). Как мне запуститься? Что значат эти записи в логах? Если отключить модуль mysql? то сервер стартует нормально. При повторных попытках запуска содержимое логов не меняется. Т.е. меняется время, но не цифры.2013-05-07 18:29:45 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2013-05-07 18:29:45 3228 [Note] Plugin 'FEDERATED' is disabled.
2013-05-07 18:29:45 3228 [Note] InnoDB: The InnoDB memory heap is disabled
2013-05-07 18:29:45 3228 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-05-07 18:29:45 3228 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-05-07 18:29:45 3228 [Note] InnoDB: CPU does not support crc32 instructions
2013-05-07 18:29:45 3228 [Note] InnoDB: Initializing buffer pool, size = 150.0M
2013-05-07 18:29:46 3228 [Note] InnoDB: Completed initialization of buffer pool
2013-05-07 18:29:46 3228 [Note] InnoDB: Highest supported file format is Barracuda.
2013-05-07 18:29:46 3228 [Note] InnoDB: Log scan progressed past the checkpoint lsn 54863872365
2013-05-07 18:29:46 3228 [Note] InnoDB: Database was not shutdown normally!
2013-05-07 18:29:46 3228 [Note] InnoDB: Starting crash recovery.
2013-05-07 18:29:46 3228 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-05-07 18:29:46 3228 [Note] InnoDB: Restoring possible half-written data pages
2013-05-07 18:29:46 3228 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 54869114880
InnoDB: Doing recovery: scanned up to log sequence number 54874357760
InnoDB: Doing recovery: scanned up to log sequence number 54875883727
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 3135 row operations to undo
InnoDB: Trx id counter is 455680
2013-05-07 18:29:53 3228 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 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
но все равно запуск не происходит2013-05-07 18:49:12 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2013-05-07 18:49:13 4084 [Note] Plugin 'FEDERATED' is disabled.
2013-05-07 18:49:13 4084 [Note] InnoDB: The InnoDB memory heap is disabled
2013-05-07 18:49:13 4084 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-05-07 18:49:13 4084 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-05-07 18:49:13 4084 [Note] InnoDB: CPU does not support crc32 instructions
2013-05-07 18:49:13 4084 [Note] InnoDB: Initializing buffer pool, size = 150.0M
2013-05-07 18:49:13 4084 [Note] InnoDB: Completed initialization of buffer pool
2013-05-07 18:49:14 4084 [Note] InnoDB: Highest supported file format is Barracuda.
2013-05-07 18:49:14 4084 [Note] InnoDB: Log scan progressed past the checkpoint lsn 54863872365
2013-05-07 18:49:14 4084 [Note] InnoDB: Database was not shutdown normally!
2013-05-07 18:49:14 4084 [Note] InnoDB: Starting crash recovery.
2013-05-07 18:49:14 4084 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-05-07 18:49:14 4084 [Note] InnoDB: Restoring possible half-written data pages
2013-05-07 18:49:14 4084 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 54869114880
InnoDB: Doing recovery: scanned up to log sequence number 54874357760
InnoDB: Doing recovery: scanned up to log sequence number 54875883727
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 3135 row operations to undo
InnoDB: Trx id counter is 455680
2013-05-07 18:49:21 4084 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 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
2013-05-07 18:50:07 4084 [Note] InnoDB: 128 rollback segment(s) are active.
InnoDB: Starting in background the rollback of uncommitted transactions
2013-05-07 18:50:07 3d8 InnoDB: Rolling back trx with id 452285, 3135 rows to undo
InnoDB: Progress in percents: 12013-05-07 18:50:07 4084 [Note] InnoDB: Waiting for purge to start
2013-05-07 18:50:07 4084 [Note] InnoDB: 1.2.10 started; log sequence number 54875883727
2 32013-05-07 18:50:08 4084 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2013-05-07 18:50:08 4084 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2013-05-07 18:50:08 4084 [Note] Server socket created on IP: '127.0.0.1'.
В настройках Open Server - Разное - количество проверок запуска сервера, увеличьте параметр до 200, тогда сервер будет 10 минут запускаться и ждать восстановления баз, если этот процесс длительный. Если надо пол часа - больше поставьте.XAKEPEHOK писал(а):но все равно запуск не происходит
[main] start=10 allow=1 emformat=txt maxmemcache=64 cgiprocess=6 pginitencode=UTF8 pginitlocale=Russian_Russia.1251 ip=127.0.0.1 mysql_driver="MySQL-5.1.68" pg_driver="PostgreSQL-9.2.4" mongo_driver="MongoDB-2.4.1(Win7+)" dbdriver1=1 dbdriver2=0 dbdriver3=0 mysqlcharset=utf8_general_ci phpdriver="PHP-5.3.23" httpdriver="Apache-2.2.24" httpcharset=notset logreadsize=256 showversion=0 astart=0 crdisk=1 crpath=0 crdomain=2 showfvr=0 showprogs=1 hdomains=1 balloon=1 favorite=0 showswitch=1 debugmode=0 stext=0 sbrowser=0 email=0 vdisk=W selfhosts=0 webdir="domains" browser="" textred="" filebrowser="" sfilebrowser=0 upurl=http://open-server.ru/update/ durl=http://open-server.ru/download.html folders="public_html www\htdocs www http htdocs docs web httpdocs public html site" [ports] mysqlport=3306 postgresqlport=5432 mongodbport=27017 httpport=80 httpsport=443 httpbackport=8080 ftpport=21 phpport=9000 memcacheport=11211 [ftp] ftp=0 ftpcommandtimeout=600 ftpconnecttimeout=60 [sendmail] smtp_server= smtp_port= auth_username= auth_password= smtp_ssl=0 pop3_server= pop3_username= pop3_password= force_sender=3. Параметры системы: