WampServer 2.5 - Drupal 7-31 installation mysql gone
Posted by: thedi (---.194-178.cust.bluewin.ch)
Date: September 15, 2014 02:21AM

Hi,
I don't have the knowledge to fix this problem by myself and need your help in order to install drupal on my local server for development. I worked for a long time with former WampServer versions without any problem.

I installed WampServer 2.5 because my hoster uses a higher versions and I shortly found a php issue because of these differences.

I installed wampserver2.5-Apache-2.4.9-Mysql-5.6.17-php5.5.12-64b on Windows 7 with regard to all the written advices and configured vhosts. All this works fine.

I create a db over phpMyAdmin, start the Drupal installation process over My Virtual Hosts all starts fine and I can enter the database connection info and most modules get installed but when nearly finished the server goes away.

ResponseText: PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away:

I studied several discussions and changed in my.ini which was untouched before as following:
# The MySQL server
[wampmysqld]
max_allowed_packet = 100M

Same result.

Then I changed the my.ini to go with innodb
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = c:/wamp/bin/mysql/mysql5.6.17/data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = c:/wamp/bin/mysql/mysql5.6.17/data/
innodb_log_arch_dir = c:/wamp/bin/mysql/mysql5.6.17/data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

Still have no success to install drupal. Nearly all modules are installed and the mysql server goes away and I receive this error.

An AJAX HTTP error occurred.
HTTP Result Code: 500 Debugging information follows.
Path: [drupal-test]
StatusText: Service unavailable (with message)
ResponseText: PDOException:
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away:
SELECT expire, value FROM {semaphore} WHERE name = :name;
Array ( [:name] => menu_rebuild ) in lock_may_be_available()
(line 167 of C:\loc\drupal-test\includes\lock.inc).
Uncaught exception thrown in shutdown function.
PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away:
DELETE FROM {semaphore} WHERE (value = :db_condition_placeholder_0) ;
Array ( [:db_condition_placeholder_0] => 263206570541619de29cd94.96926010 )
in lock_release_all()
(line 269 of C:\loc\drupal-test\includes\lock.inc).
Uncaught exception thrown in session handler.PDOException:
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away:
SELECT 1 AS expression FROM {sessions} sessions
WHERE ( (sid = :db_condition_placeholder_0)
AND (ssid = :db_condition_placeholder_1) );
Array ( [:db_condition_placeholder_0] => 8gIWX8MB1aOjT2zQ5Z-upBMtOfpZbLzA7Fw4DfkOnmI [:db_condition_placeholder_1] => )
in _drupal_session_write()
(line 209 of C:\loc\drupal-test\includes\session.inc).

Mysql writes the following to the error.log
014-09-15 00:40:52 5316 [Note] Plugin 'FEDERATED' is disabled.
2014-09-15 00:40:52 5316 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-09-15 00:40:52 5316 [Note] InnoDB: The InnoDB memory heap is disabled
2014-09-15 00:40:52 5316 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-09-15 00:40:52 5316 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-09-15 00:40:52 5316 [Note] InnoDB: Not using CPU crc32 instructions
2014-09-15 00:40:52 5316 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-09-15 00:40:52 5316 [Note] InnoDB: Completed initialization of buffer pool
2014-09-15 00:40:52 5316 [Note] InnoDB: Highest supported file format is Barracuda.
2014-09-15 00:40:53 5316 [Note] InnoDB: 128 rollback segment(s) are active.
2014-09-15 00:40:53 5316 [Note] InnoDB: Waiting for purge to start
2014-09-15 00:40:53 5316 [Note] InnoDB: 5.6.17 started; log sequence number 58843757
2014-09-15 00:40:53 5316 [Note] Server hostname (bind-address): '*'; port: 3306
2014-09-15 00:40:53 5316 [Note] IPv6 is available.
2014-09-15 00:40:53 5316 [Note] - '::' resolves to '::';
2014-09-15 00:40:53 5316 [Note] Server socket created on IP: '::'.
2014-09-15 00:40:53 5316 [Note] Event Scheduler: Loaded 0 events
2014-09-15 00:40:53 5316 [Note] wampmysqld64: ready for connections.
Version: '5.6.17' socket: '' port: 3306 MySQL Community Server (GPL)
2014-09-15 00:42:31 840 InnoDB: Operating system error number 5 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory. It may also be you have created a subdirectory
InnoDB: of the same name as a data file.
2014-09-15 00:42:31 840 InnoDB: Operating system error number 5 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory. It may also be you have created a subdirectory
InnoDB: of the same name as a data file.
2014-09-15 00:42:31 5316 [ERROR] InnoDB: Cannot create file '.\drupal_loc\cache_menu.ibd'

2014-09-15 00:42:31 5316 [ERROR] InnoDB: TRUNCATE TABLE drupal_loc/cache_menu failed to create a new tablespace
2014-09-15 00:42:31 840 InnoDB: cannot calculate statistics for table "drupal_loc"."cache_menu" because the .ibd file is missing. For help, please refer to [dev.mysql.com]
2014-09-15 00:42:31 840 InnoDB: cannot calculate statistics for table "drupal_loc"."cache_menu" because the .ibd file is missing. For help, please refer to [dev.mysql.com]
2014-09-15 00:42:31 840 InnoDB: cannot calculate statistics for table "drupal_loc"."cache_menu" because the .ibd file is missing. For help, please refer to [dev.mysql.com]
2014-09-15 00:42:31 840 InnoDB: cannot calculate statistics for table "drupal_loc"."cache_menu" because the .ibd file is missing. For help, please refer to [dev.mysql.com]
2014-09-15 00:42:31 840 InnoDB: cannot calculate statistics for table "drupal_loc"."cache_menu" because the .ibd file is missing. For help, please refer to [dev.mysql.com]
2014-09-15 00:42:31 840 InnoDB: cannot calculate statistics for table "drupal_loc"."cache_menu" because the .ibd file is missing. For help, please refer to [dev.mysql.com]
2014-09-15 00:42:32 840 InnoDB: cannot calculate statistics for table "drupal_loc"."cache_menu" because the .ibd file is missing. For help, please refer to [dev.mysql.com]
2014-09-15 00:42:32 840 InnoDB: cannot calculate statistics for table "drupal_loc"."cache_menu" because the .ibd file is missing. For help, please refer to [dev.mysql.com]
2014-09-15 00:42:32 840 InnoDB: cannot calculate statistics for table "drupal_loc"."cache_menu" because the .ibd file is missing. For help, please refer to [dev.mysql.com]
2014-09-15 00:42:32 840 InnoDB: cannot calculate statistics for table "drupal_loc"."cache_menu" because the .ibd file is missing. For help, please refer to [dev.mysql.com]
2014-09-15 00:42:32 840 InnoDB: cannot calculate statistics for table "drupal_loc"."cache_menu" because the .ibd file is missing. For help, please refer to [dev.mysql.com]
2014-09-15 00:42:36 840 InnoDB: cannot calculate statistics for table "drupal_loc"."cache_menu" because the .ibd file is missing. For help, please refer to [dev.mysql.com]
2014-09-15 00:42:36 840 InnoDB: cannot calculate statistics for table "drupal_loc"."cache_menu" because the .ibd file is missing. For help, please refer to [dev.mysql.com]
2014-09-15 00:42:37 840 InnoDB: cannot calculate statistics for table "drupal_loc"."cache_menu" because the .ibd file is missing. For help, please refer to [dev.mysql.com]
2014-09-15 00:42:37 840 InnoDB: cannot calculate statistics for table "drupal_loc"."cache_menu" because the .ibd file is missing. For help, please refer to [dev.mysql.com]
2014-09-15 00:42:37 840 InnoDB: cannot calculate statistics for table "drupal_loc"."cache_menu" because the .ibd file is missing. For help, please refer to [dev.mysql.com]
2014-09-15 00:42:37 840 InnoDB: cannot calculate statistics for table "drupal_loc"."cache_menu" because the .ibd file is missing. For help, please refer to [dev.mysql.com]
2014-09-15 00:42:37 840 InnoDB: cannot calculate statistics for table "drupal_loc"."cache_menu" because the .ibd file is missing. For help, please refer to [dev.mysql.com]
2014-09-15 00:42:39 840 InnoDB: Operating system error number 5 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory. It may also be you have created a subdirectory
InnoDB: of the same name as a data file.
2014-09-15 00:42:39 840 InnoDB: Operating system error number 5 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory. It may also be you have created a subdirectory
InnoDB: of the same name as a data file.
2014-09-15 00:42:39 5316 [ERROR] InnoDB: Cannot create file '.\drupal_loc\cache_field.ibd'

2014-09-15 00:42:39 5316 [ERROR] InnoDB: TRUNCATE TABLE drupal_loc/cache_field failed to create a new tablespace
2014-09-15 00:42:39 840 InnoDB: cannot calculate statistics for table "drupal_loc"."cache_field" because the .ibd file is missing. For help, please refer to [dev.mysql.com]
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
2014-09-15 00:42:39 840 InnoDB: Error: trying to access tablespace 563 page no. 3,
InnoDB: but the tablespace does not exist or is just being dropped.
InnoDB: Error: Unable to read tablespace 563 page no 3 into the buffer pool after 100 attempts
InnoDB: The most probable cause of this error may be that the table has been corrupted.
InnoDB: You can try to fix this problem by using innodb_force_recovery.
InnoDB: Please see reference manual for more details.
InnoDB: Aborting...
2014-09-15 00:42:39 840 InnoDB: Assertion failure in thread 2112 in file buf0buf.cc line 2641
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to [bugs.mysql.com].
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: [dev.mysql.com]
InnoDB: about forcing recovery.


I started with the first error telling me there is a mysqld does not have access to a directory. But I don't understand which directory this could be and how I can solve it.

Unsure if the further errors are only based on the first one or not.

Any help is very appreciated. I really have no clue how to come to an end here.

Thanks a lot.

Options: ReplyQuote
Re: WampServer 2.5 - Drupal 7-31 installation mysql gone
Posted by: RiggsFolly (---.dynamic.dsl.as9105.com)
Date: September 20, 2014 07:56AM

Please check the drupal install page [www.drupal.org] it sounds like you have somehow done somehing wrong

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: WampServer 2.5 - Drupal 7-31 installation mysql gone
Posted by: Mariska (---.e-nemo.nl)
Date: September 27, 2014 11:57AM

I seem to have the same problem. I posted about it here [stackoverflow.com]

At the moment I wonder whether there is an additional step between installing WAMP and installing Drupal, next to the creation of the settings.php file. The my.ini might need to be transferred to the etc folder as my.cnf and it may need some changes. In my.ini it doesn't say anything about cache and in the error log that seems to be the problem. So I'm looking into that.

Or have you figured it out already? In that case: HOW?

Best regard,
Mariska.

Options: ReplyQuote
Re: WampServer 2.5 - Drupal 7-31 installation mysql gone
Posted by: RiggsFolly (---.dynamic.dsl.as9105.com)
Date: September 27, 2014 12:44PM

Hi Thedi,

I see that you are using the WAMPServer 64 bit install.

There was a tiny bug in the 2.5 release of WAMPServer 2.5 where the my.ini file contained an incorrect section name

i.e.

my.ini ...

Change

[wampmysqld] to [wampmysqld64]

This will make the changes you made to the my.ini take effect where before they were being ignored.

Please see WAMPServer 2.5 release notes and corrections for this and other corrections to that release.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: WampServer 2.5 - Drupal 7-31 installation mysql gone
Posted by: Mariska (---.FTTH.ispfabriek.nl)
Date: September 27, 2014 10:04PM

For me that didn't help. Is there something I'm missing?

I started anew:
- I installed WAMP
- I changed the my.ini and added the 64. I also increased the max_allowed_packet to 256M. I found that both under the [wampmysqld64] and the [mysqldump]. So I raised both numbers
- I downloaded Drupal 7.31.zip
- I copied the folder to www and unpacked it there
- I copied settings.default.php and named it settings.php and made both files writable.
- I made a database in myadminphp
- I opened localhost/drupal and started the installation.

The error always comes at the last moment of installing all modules and it is the same error each time.

I noticed that the word 'cache' is not in the my.ini. Is that correct?

What can I do?

Regards,
Mariska



Edited 1 time(s). Last edit at 09/27/2014 10:51PM by Mariska.

Options: ReplyQuote
Re: WampServer 2.5 - Drupal 7-31 installation mysql gone
Posted by: RiggsFolly (---.dynamic.dsl.as9105.com)
Date: September 28, 2014 02:07PM

After a quick Google I found this on the Drupal Site url=https://www.drupal.org/node/1014172]General error: 2006 MySQL server has gone away in _drupal_session_write()[/url]

and this PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away:


They claim it is fixed in version 7.15, so what version are you using?

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: WampServer 2.5 - Drupal 7-31 installation mysql gone
Posted by: Mariska (---.FTTH.ispfabriek.nl)
Date: September 29, 2014 10:07PM

Verswion 7.31.
I could try an older version.
Could it be a problem that I'm working in Wiondow 8?

Mariska.

Options: ReplyQuote
Re: WampServer 2.5 - Drupal 7-31 installation mysql gone
Posted by: RiggsFolly (---.dynamic.dsl.as9105.com)
Date: September 30, 2014 12:49AM

I dont really know, I have never installed Drupal

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: WampServer 2.5 - Drupal 7-31 installation mysql gone
Posted by: Mariska (---.ftth.telfortglasvezel.nl)
Date: October 02, 2014 12:41AM

Eventually I saw to possibilities:
1. I have installed Drupal, but it contains some errors. It looked like this before. Maybe by adding the cache_field table manually I can fix the errors and complete my installation. As in [www.drupal.org].
2. And this is what I did: download Drupal via Aquia desktop. That worked. FINALLY!



Edited 1 time(s). Last edit at 10/03/2014 10:51PM by Mariska.

Options: ReplyQuote


Sorry, only registered users may post in this forum.