1.7.0 upgrade - unknown option '--skip-bdb'

Problems with the Windows version of XAMPP, questions, comments, and anything related.

1.7.0 upgrade - unknown option '--skip-bdb'

Postby hanpedro » 02. January 2009 10:41

I've upgraded 1.6.8a to 1.7.0, and got a error message at starting mysql as follows:

090102 18:34:09 [ERROR] K:\xampp\mysql\bin\mysqld-nt.exe: unknown option '--skip-bdb'

According to "http://www.apachefriends.org/winxampp/upgrade-howto.txt", I changed my.cnf:

[By Hand]: Editing "my.cnf" for Mysql => <xampp>\mysgl\bin\my.cnf
Comment out these line with #: innodb_log_arch_dir = "/xampp/mysql/"


How can I solve this problem?
hanpedro
 
Posts: 133
Joined: 09. February 2005 06:03
Operating System: SCientific Linux 6.1 x86

Re: 1.7.0 upgrade - unknown option '--skip-bdb'

Postby Sharley » 02. January 2009 10:48

Comment out the skip-bdb part as it is not contained in the new version my.cnf file and the error message confirms that it is no longer recognized - unknown option.

...so the 2 lines looks like this:
# Uncomment the following if you are NOT using BDB tables
# skip-bdb

Save the file and restart MySQL.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: 1.7.0 upgrade - unknown option '--skip-bdb'

Postby hanpedro » 02. January 2009 11:44

Sharley,

Thank you for your kind relpy.

I solved mysql starting error, but now apache has another problem.

When open localhost, apache dies with "stopped Apache HTTP Server".

The error log is as follows;

[Fri Jan 02 19:41:27 2009] [notice] Server built: Dec 10 2008 00:10:06
[Fri Jan 02 19:41:27 2009] [notice] Parent: Created child process 7464
[Fri Jan 02 19:41:27 2009] [warn] Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Jan 02 19:41:28 2009] [notice] Child 7464: Child process is running
[Fri Jan 02 19:41:28 2009] [notice] Child 7464: Acquired the start mutex.
[Fri Jan 02 19:41:28 2009] [notice] Child 7464: Starting 250 worker threads.
[Fri Jan 02 19:41:28 2009] [notice] Child 7464: Starting thread to listen on port 8080.
[Fri Jan 02 19:41:44 2009] [notice] Parent: child process exited with status 255 -- Restarting.
hanpedro
 
Posts: 133
Joined: 09. February 2005 06:03
Operating System: SCientific Linux 6.1 x86

Re: 1.7.0 upgrade - unknown option '--skip-bdb'

Postby Sharley » 02. January 2009 11:50

Please try and start Apache using the apache_start.bat file in the xampp folder.

It should give a much more detailed error message why Apache can't start.

If your not sure of what the error message means, if you get an error message that is, then you can paste it here so we can evaluate it for you.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: 1.7.0 upgrade - unknown option '--skip-bdb'

Postby hanpedro » 02. January 2009 11:56

I had longer error log.

[Fri Jan 02 19:53:07 2009] [warn] Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Jan 02 19:53:07 2009] [warn] pid file K:/apm_packages/xampp/apache/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Fri Jan 02 19:53:08 2009] [notice] Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i mod_autoindex_color PHP/5.2.8 configured -- resuming normal operations
[Fri Jan 02 19:53:08 2009] [notice] Server built: Dec 10 2008 00:10:06
[Fri Jan 02 19:53:08 2009] [notice] Parent: Created child process 656
[Fri Jan 02 19:53:08 2009] [warn] Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Jan 02 19:53:09 2009] [notice] Child 656: Child process is running
[Fri Jan 02 19:53:09 2009] [notice] Child 656: Acquired the start mutex.
[Fri Jan 02 19:53:09 2009] [notice] Child 656: Starting 250 worker threads.
[Fri Jan 02 19:53:09 2009] [notice] Child 656: Starting thread to listen on port 8080.
[Fri Jan 02 19:55:01 2009] [notice] Parent: child process exited with status 3221225477 -- Restarting.


And my box is vista x64 for reference.
hanpedro
 
Posts: 133
Joined: 09. February 2005 06:03
Operating System: SCientific Linux 6.1 x86

Re: 1.7.0 upgrade - unknown option '--skip-bdb'

Postby Sharley » 02. January 2009 12:08

Try this fix even though it is for a PDO issue it might help with yours:
viewtopic.php?f=16&t=32617

This post had your issue and was fixed from the above post.
viewtopic.php?f=16&t=32507

There could be an issue with one of the upgrade dlls and if you replace the one in the above fix it may help but it will do no harm.

Did you run the mysql_upgrade.exe file from the mysql folder after doing the XAMPP upgrade?

Can you check the Windows event viewer for any clues.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: 1.7.0 upgrade - unknown option '--skip-bdb'

Postby hanpedro » 02. January 2009 12:36

Sharley,

Thank you for your further replies.

I didn't run " mysql_upgrade.exe ", after reading your reply I ran it.

Now I amfollowing your instructions. After doing this I'll post result.


=============================


I got this error log.

[Fri Jan 02 20:40:13 2009] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Fri Jan 02 20:40:15 2009] [notice] Child 5528: Exit event signaled. Child process is ending.
[Fri Jan 02 20:40:16 2009] [notice] Parent: Child process exited successfully.
[Fri Jan 02 20:42:16 2009] [warn] Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Jan 02 20:42:17 2009] [notice] Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i mod_autoindex_color PHP/5.2.9-dev configured -- resuming normal operations
[Fri Jan 02 20:42:17 2009] [notice] Server built: Dec 10 2008 00:10:06
[Fri Jan 02 20:42:17 2009] [notice] Parent: Created child process 6280
[Fri Jan 02 20:42:18 2009] [warn] Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Jan 02 20:42:19 2009] [notice] Child 6280: Child process is running
[Fri Jan 02 20:42:19 2009] [notice] Child 6280: Acquired the start mutex.
[Fri Jan 02 20:42:19 2009] [notice] Child 6280: Starting 250 worker threads.
[Fri Jan 02 20:42:19 2009] [notice] Child 6280: Starting thread to listen on port 8080.


Mysql also made error logs.

090102 19:40:04 InnoDB: Started; log sequence number 0 43655
090102 19:40:04 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_Z
090102 19:40:04 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
090102 19:40:04 [Note] K:\apm_packages\xampp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '5.1.30-community' socket: '' port: 3306 MySQL Community Server (GPL)
090102 20:18:47 [ERROR] Invalid (old?) table or database name '$g4[singo_reason_table]'
090102 20:41:58 [ERROR] Invalid (old?) table or database name '$g4[singo_reason_table]
hanpedro
 
Posts: 133
Joined: 09. February 2005 06:03
Operating System: SCientific Linux 6.1 x86

Re: 1.7.0 upgrade - unknown option '--skip-bdb'

Postby Ghostridah » 16. April 2009 18:11

I encounter the same problem as hanpedro got with his MySQL Server since my update from 1.7.0 to 1.7.1

Did anyone find a solution?

Thanks for your answers!
Ghostridah
 
Posts: 3
Joined: 16. April 2009 18:06

Re: 1.7.0 upgrade - unknown option '--skip-bdb'

Postby Ghostridah » 17. April 2009 15:45

Sorry... i don't want to spam but isnt there anyone who got a solution?
I tried to replace the event table with a backup of the previous version (1.7.0) but it still wont work (well the table size was equal so i dont think the patch changed anything).
My MySQL server has gone for 3 days now and i'm hosting several projects on it... i need to get it work!

If anyone got a solution PLEASE post it!
Ghostridah
 
Posts: 3
Joined: 16. April 2009 18:06


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 61 guests