Re: Problems compiling PHP with mysql support as a apache DSO on a HPUX11.x box
>>Yes, I read through the numerous threads about this topic but I can't >>solve my problem >> >>After compiling php-4.1.1 with mysql support (mysql-3.23.47) as a DSO >>(./configure --enable-libgcc --with-mysql=/opt/mysql-3.23.47 >>--with-apxs=/opt/apache-1.3.23/bin/apxs) >> >>apache complains with the following error: >> >> >> bin/apachectl start >>/usr/lib/dld.sl: Unresolved symbol: __umoddi3 (code) from >>/opt/mysql-3.23.47/lib/mysql/libmysqlclient.sl.10 >>Syntax error on line 236 of /opt/apache-1.3.23/conf/httpd.conf: >>Cannot load /opt/apache-1.3.23/libexec/libphp4.so into server: No such >>file or directory >>bin/apachectl start: httpd could not be started >> > > Ok, so /opt/apache-1.3.23/libexec/libphp4.so does not exist. > Look at httpd.conf, where are the other Apache modules loaded from? Sorry, didn't mention it, of course /opt/apache-1.3.23/libexec/libphp4.so exist. Apache complains with a systeax error if apache could not load module... Andre - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problems compiling PHP with mysql support as a apache DSO on a HPUX11.x box
Wolfgang Pichler wrote: > Do you have also recompiled apache after compiling php ? > YES > Am Mit, 2002-02-20 um 10.04 schrieb Andre Konopka: > >>Hi, >> >>mmh, maybe it's not a mysql-problem... >>Yes, I read through the numerous threads about this topic but I can't >>solve my problem >> >>After compiling php-4.1.1 with mysql support (mysql-3.23.47) as a DSO >>(./configure --enable-libgcc --with-mysql=/opt/mysql-3.23.47 >>--with-apxs=/opt/apache-1.3.23/bin/apxs) >> >>apache complains with the following error: >> >> >> bin/apachectl start >>/usr/lib/dld.sl: Unresolved symbol: __umoddi3 (code) from >>/opt/mysql-3.23.47/lib/mysql/libmysqlclient.sl.10 >>Syntax error on line 236 of /opt/apache-1.3.23/conf/httpd.conf: >>Cannot load /opt/apache-1.3.23/libexec/libphp4.so into server: No such >>file or directory >>bin/apachectl start: httpd could not be started >> >> >> >>I compiled all the stuff with gcc version 2.95.2 19991024 (release) >> >>Here are the options I used to compile MySQL >> >>CXX=gcc >>CFLAGS="-fomit-frame-pointer -O6 -fpic" >>CXXFLAGS="-felide-constructors -fno-exceptions -fno-rtti -O6" >>./configure --prefix=/opt/mysql-3.23.47 --with-low-memory --with-innodb >> >>chatr >> >> >>Any idea?? >> >> >>- >>Before posting, please check: >> http://www.mysql.com/manual.php (the manual) >> http://lists.mysql.com/ (the list archive) >> >>To request this thread, e-mail <[EMAIL PROTECTED]> >>To unsubscribe, e-mail <[EMAIL PROTECTED]> >>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >> >> >> >> >> > > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problems compiling PHP with mysql support as a apache DSO on a HPUX11.x box
Hi, mmh, maybe it's not a mysql-problem... Yes, I read through the numerous threads about this topic but I can't solve my problem After compiling php-4.1.1 with mysql support (mysql-3.23.47) as a DSO (./configure --enable-libgcc --with-mysql=/opt/mysql-3.23.47 --with-apxs=/opt/apache-1.3.23/bin/apxs) apache complains with the following error: bin/apachectl start /usr/lib/dld.sl: Unresolved symbol: __umoddi3 (code) from /opt/mysql-3.23.47/lib/mysql/libmysqlclient.sl.10 Syntax error on line 236 of /opt/apache-1.3.23/conf/httpd.conf: Cannot load /opt/apache-1.3.23/libexec/libphp4.so into server: No such file or directory bin/apachectl start: httpd could not be started I compiled all the stuff with gcc version 2.95.2 19991024 (release) Here are the options I used to compile MySQL CXX=gcc CFLAGS="-fomit-frame-pointer -O6 -fpic" CXXFLAGS="-felide-constructors -fno-exceptions -fno-rtti -O6" ./configure --prefix=/opt/mysql-3.23.47 --with-low-memory --with-innodb chatr Any idea?? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Why there are no API-function for transactions?
Hi, maybe I'am wrong but I didn't find any transaction-oriented C-API functions??? How can I build a web transaction application with MYSQL/INNOBASE? I would prefer PHP, but PHP uses the C-library to connect to mysql and there are no transaction C-API functions... Thanks Andre - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
need help with select statements
Hi, I have, three tables (one,two, three) with the rows id/value. id is the key for all the tables. with select value from one where id=xx; select value from two where id=xx; select value from three where id=xx; I can select all values from the tables with the id=xx. How can I do this with one select statement. Notice, it's possible that there is an entry for id=xx in table one, but not in table two, or three. Of course ist's possible that there is only a value in table three. The output could be id one.value two.value three.value x1 233 2342 NULL x2 NULL 998NULL x3 33 232 23 Clear enough? Thanks for help Andre - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Why is there no mysql hpux11 binary for hppa1.1 (32 Bit) database
Hi, since .38 there is no longer a HPUX11 binary for the hppa1.1 architecure (32 Bit)?? I think that the 10.20 binary is runnable but I suppose that you compiled it with MIT-threads. On HP-UX11 I would prefer to compile it with native threads, do you agree? The 10.20 binary version isn't compiled with INNOBASE??? Thanks Andre database,sql,query,table - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't compile .40 on HPUX 11.00 - linker problem with innobase
Hi, I can't *link* MySql on my HP-UX box due a linkage problem: ../innobase/lock/liblock.a ../innobase/mtr/libmtr.a ../innobase/page/libpage.a ../innobase/rem/librem.a ../innobase/thr/libthr.a ../innobase/com/libcom.a ../innobase/sync/libsync.a ../innobase/data/libdata.a ../innobase/mach/libmach.a ../innobase/ha/libha.a ../innobase/dyn/libdyn.a ../innobase/mem/libmem.a ../innobase /sync/libsync.a ../innobase/ut/libut.a ../innobase/os/libos.a ../innobase/ut/lib ut.a -lrt ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -lpthread -lcrypt -lnsl -lm -lpthread /usr/bin/ld: Data Linkage Table (+z) overflow in file ../innobase/row/librow.a(row0ins.o) - use +Z option to recompile collect2: ld returned 1 exit status *** Error exit code 1 Stop. *** Error exit code 1 Any idea? I configured MySQl with the following lines: export CXX=gcc export CXXFLAGS="-felide-constructors -fno-exceptions -fno-rtti -O3" ./configure --with-low-memory --with-berkeley-db --with-innodb --prefix=/opt/mysql --disable-shared gcc version 2.95.2 19991024 (release) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: PROPOSAL mysqldump change for InnoDB
Hi, Yes, sounds great, it is possible to implement it in the next version Andre On 17-May-01 Michael Widenius wrote: > > Hi! > >>>>>> "Andre" == Andre Konopka <[EMAIL PROTECTED]> writes: > > Andre> Hi Michael, > Andre> maybe something 'off topic'... > > Andre> I think a option to set 'autocommit=0' is needed. > Andre> Last week I have made some data manipulation, stupidly my 'where > condition' was > Andre> not correct. After pressing 'return', mysql returns with '4576 rows > affected'. > Andre> Not that was I expected... > Andre> I didn't set autocommit=0 after starting mysql, so I have to restore > my DB > > Andre> What do you think about this option? > > We could always add to mysql and 'init-set-command' option, which > would allow you to do in my.cnf: > > [mysql] > init-set-command = 'auto_commit=0' > > It's probably not a good idea to do this by default as this would > confuse a lot of our current users. > > Regard's > Monty > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- E-Mail: [EMAIL PROTECTED] Date: 17-May-01 Time: 16:34:29 () Join the ASCII ribbon campaign against html email /\ and Microsoft attachments. "I heard if you play the NT-4.0-CD backwards, you get a satanic message" "That is nothing, if you play it forward, it installs NT-4.0" -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: can´t compile .38 on hp-ux with gcc-2.95.2/3 internal compil
Hi Heikki, now .38 is up and running Thank you for your fast help Andre On 16-May-01 Heikki Tuuri wrote: > Andre, > > try the following put on the line 330 in mysql/innobase/log/log0log.c > > lsn = log_reserve_and_open(OS_FILE_LOG_BLOCK_SIZE); > > Maybe gcc will compile in a different way then and not crash. Please > report to me if you succeed. I will change the source then. > > Regards, > > Heikki > http://www.innobase.fi > >>Hi, >> >>I got the following error during compilation of MySQL-3.23.38 on my >>HPUX-11 box witg gcc-2.95.2. >> >>log0log.c: In function ´log_pad_current_log_block´: >>log0log.c:330: Internal compiler error at expr.c:2829 >> >>After upgrading to gcc-2.95.3 I got the same error??? >>No problem compiling MySQL .37 on the same box??? >> >>Andre > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- E-Mail: [EMAIL PROTECTED] Date: 17-May-01 Time: 13:22:52 () Join the ASCII ribbon campaign against html email /\ and Microsoft attachments. "I heard if you play the NT-4.0-CD backwards, you get a satanic message" "That is nothing, if you play it forward, it installs NT-4.0" -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: PROPOSAL mysqldump change for InnoDB
Hi Michael, maybe something 'off topic'... I think a option to set 'autocommit=0' is needed. Last week I have made some data manipulation, stupidly my 'where condition' was not correct. After pressing 'return', mysql returns with '4576 rows affected'. Not that was I expected... I didn't set autocommit=0 after starting mysql, so I have to restore my DB What do you think about this option? Andre On 16-May-01 Michael Widenius wrote: > > Hi! > >> "Steve" == Steve Ruby <[EMAIL PROTECTED]> writes: > > Steve> Due to the fact that piping a table from mysqldump to an INNODB table > Steve> can be as much as 30X slower if the insert is not done with > Steve> transactions, > Steve> would it make sense to add some option to mysqldump to make every X > Steve> inserts a transaction. > > Steve> for example > > Steve> mysqldump --transactionrows=10 mydatabase | mysql -hsomeserver > Steve> database > > Steve> where the above would wrap every 100,000 inserts with begin; commit; > Steve> right now it is non-trivial to insert the transaction > Steve> lines every so often, or even around all of the data. > > I don't think we actually need the above option. > > Try using the --quick option to mysqldump. > > This will MUCH faster for InnoDB, because it inserts up to 16M of data > at a time (instead of just single rows). > > Could you test the above on your tables? If it doesn't give adequate > performance, then we have to consider adding begin-ends to mysqldump. > > The problem with having very long transactions is that they could actually > make things go slower because you get much bigger rollback segments. > (I assume that if I am wrong, Heikki will correct me ...) > > Regards, > Monty > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- E-Mail: [EMAIL PROTECTED] Date: 17-May-01 Time: 08:52:00 () Join the ASCII ribbon campaign against html email /\ and Microsoft attachments. "I heard if you play the NT-4.0-CD backwards, you get a satanic message" "That is nothing, if you play it forward, it installs NT-4.0" -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
can´t compile .38 on hp-ux with gcc-2.95.2/3 internal compiler error
Hi, I got the following error during compilation of MySQL-3.23.38 on my HPUX-11 box witg gcc-2.95.2. log0log.c: In function ´log_pad_current_log_block´: log0log.c:330: Internal compiler error at expr.c:2829 After upgrading to gcc-2.95.3 I got the same error??? No problem compiling MySQL .37 on the same box??? Andre - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re:.37 INNO Strange behaviour after deleting a table
Heikki, here are more details ... I' am running mysql-3.23.37 on a hp-ux11 box (with actual patches) I used the following configure options to compile MySQL: CXX=gcc CFLAGS="-fomit-frame-pointer -O6 -fpic" CXXFLAGS="-felide-constructors -fno-exceptions -fno-rtti -O6" ./configure --with-low-memory --with-berkeley-db --with-innodb --prefix=/opt/mysql --disable-shared My backup comes from mysqldump (MySQL dump 8.8), here is the create statement from the ascii file CREATE TABLE passwd ( name_nr int(11) DEFAULT '0' NOT NULL, nr int(11) NOT NULL auto_increment, pw_name varchar(64) DEFAULT '' NOT NULL, pw_passwd varchar(32) DEFAULT '', pw_uid int(11) DEFAULT '0' NOT NULL, pw_gid int(11) DEFAULT '0' NOT NULL, pw_gecos varchar(127) DEFAULT '' NOT NULL, pw_dir varchar(127) DEFAULT '' NOT NULL, shell_nr int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (nr), KEY name_nr (name_nr), UNIQUE pw_name (pw_name), UNIQUE pw_uid (pw_uid) ) type=innobase; # # Dumping data for table 'passwd' # . . . With cat db_backup | /opt/mysql/bin/mysql -r -B -N -u my_db_adm -pvery_secret_password mail I re-create the table structure and recover my data It's absolut no problem to reproduce the behaviour, it's a DB with roundabout 1000 rows. Hope that helps Greetings fro Germany Andre On 08-May-01 Heikki Tuuri wrote: > Andre, > > it might be a bug in the multiversioning code in InnoDB. > Can you describe in detail the situation: > > - What is the CREATE TABLE statement? > - How many rows there are in the table? > - How did you import the table? > - Are you able to repeat the bug if you delete and drop the table, > and create and import it again? > > Regards, > > Heikki > > .. >>Hi, >> >>I accidently delete all my records from a table, but I always make backups!!! >>Okay, I deleted the (empty) table with drop table. >>Than I recreate the table and all the data mith a mysql batch job (from >>mysqldump) .No problem. Than I started the mysql UI and make some test >>queries. >>select * from passwd;All records are displayed >>if I query only for one column I get an empty set back >>select pw_name from passwd where pw_name='pbs013';Empty set (0.00 sec) >>If I query for the whole record all works fine: >>mysql> select * from passwd where pw_name='pbs013'; >>+-++-+---+++--- > + >>--+--+ >>| name_nr | nr | pw_name | pw_passwd | pw_uid | pw_gid | pw_gecos | >>pw_dir | shell_nr | >>+-++-+---+++--- > + >>--+--+ >>| 50 | 50 | pbs013 | deleted | 10013 | 1 | andre konopka | >>/home/pbs013 |1 | >>+-++-+---+++--- > + >>--+--+1 row in set (0.00 sec) >>After restarting mysqld all works as expected??? >>mysql> select pw_name from passwd where pw_name='pbs013';+-+| > pw_name | >>+-+| pbs013 |+-+1 row in set (0.01 sec)Andre >>--E-Mail: [EMAIL PROTECTED] >>Date: 08-May-01Time: 16:28:44 > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- E-Mail: [EMAIL PROTECTED] Date: 09-May-01 Time: 08:29:32 () Join the ASCII ribbon campaign against html email /\ and Microsoft attachments. -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
.37 INNO Strange behaviour after deleting a table
Hi, I accidently delete all my records from a table, but I always make backups!!! Okay, I deleted the (empty) table with drop table. Than I recreate the table and all the data mith a mysql batch job (from mysqldump) . No problem. Than I started the mysql UI and make some test queries. select * from passwd; All records are displayed if I query only for one column I get an empty set back select pw_name from passwd where pw_name='pbs013'; Empty set (0.00 sec) If I query for the whole record all works fine: mysql> select * from passwd where pw_name='pbs013'; +-++-+---+++---+ --+--+ | name_nr | nr | pw_name | pw_passwd | pw_uid | pw_gid | pw_gecos | pw_dir | shell_nr | +-++-+---+++---+ --+--+ | 50 | 50 | pbs013 | deleted | 10013 | 1 | andre konopka | /home/pbs013 |1 | +-++-+---+++---+ --+--+ 1 row in set (0.00 sec) After restarting mysqld all works as expected??? mysql> select pw_name from passwd where pw_name='pbs013'; +-+ | pw_name | +-+ | pbs013 | +-+ 1 row in set (0.01 sec) Andre -- E-Mail: [EMAIL PROTECTED] Date: 08-May-01 Time: 16:28:44 () Join the ASCII ribbon campaign against html email /\ and Microsoft attachments. "I heard if you play the NT-4.0-CD backwards, you get a satanic message" "That is nothing, if you play it forward, it installs NT-4.0" -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
INNO How to set autocommit=0 as default for mysql
Hi, I would like to set autocommit = 0 as the default value when running the mysql frontend. (Maybe with an entry in my.cnf) Is that possible ??? Andre -- E-Mail: [EMAIL PROTECTED] Date: 08-May-01 Time: 15:42:09 () Join the ASCII ribbon campaign against html email /\ and Microsoft attachments. -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: .36 memory fault with innobase on HP-UX11
Hi, I use the following my.cnf: [mysqld] innobase_data_home_dir = /opt/mysql/var/ innobase_data_file_path = ib_data1:10M innobase_log_group_home_dir = /opt/mysql/var/ innobase_log_arch_dir = /opt/mysql/mysql/var/ set-variable = innobase_mirrored_log_groups=1 set-variable = innobase_log_files_in_group=3 set-variable = innobase_log_file_size=5M set-variable = innobase_log_buffer_size=8M innobase_flush_log_at_trx_commit=1 innobase_log_archive=0 set-variable = innobase_buffer_pool_size=16M set-variable = innobase_additional_mem_pool_size=2M set-variable = innobase_file_io_threads=4 set-variable = innobase_lock_wait_timeout=50 After first starting mysql with the start.server script innobase create the necessary files in the /opt/mysql/var directory but than it ends up with a memory fault. .err: 010405 16:45:39 mysqld started Innobase: The first specified data file /opt/mysql/var/ib_data1 did not exist: Innobase: a new database to be created! Innobase: Log file /opt/mysql/var/ib_logfile0 did not exist: new to be created Innobase: Log file /opt/mysql/var/ib_logfile1 did not exist: new to be created 010405 16:45:44 mysqld ended Restarting mysql everytimes reproduces the memory fault. After some experiments I found that the line innobase_log_group_home_dir = /opt/mysql/var/ causes the problem If I start mysql (after removing all ib_files) with the following my.cnf everthing works fine: [mysqld] innobase_data_home_dir = /opt/mysql/var/ innobase_data_file_path = ib_data1:10M #innobase_log_group_home_dir = /opt/mysql/var/ #innobase_log_arch_dir = /opt/mysql/mysql/var/ #set-variable = innobase_mirrored_log_groups=1 #set-variable = innobase_log_files_in_group=3 #set-variable = innobase_log_file_size=5M #set-variable = innobase_log_buffer_size=8M #innobase_flush_log_at_trx_commit=1 #innobase_log_archive=0 #set-variable = innobase_buffer_pool_size=16M #set-variable = innobase_additional_mem_pool_size=2M #set-variable = innobase_file_io_threads=4 #set-variable = innobase_lock_wait_timeout=50 Now I again remove the ib_files and restarted mysqld with the following my.cnf file and mysql crashes with a memory fault again. [mysqld] innobase_data_home_dir = /opt/mysql/var/ innobase_data_file_path = ib_data1:10M innobase_log_group_home_dir = /opt/mysql/var/ The funny thing is, that if you initialize the innobase stuff with the '2 line' my.cnf you can afterwards enable 'innobase_log_group_home_dir = /opt/mysql/var/' and mysqld keeps on running. Any idea? Greetings from Germany Andre -- E-Mail: [EMAIL PROTECTED] Date: 05-Apr-01 Time: 17:17:27 () Join the ASCII ribbon campaign against html email /\ and Microsoft attachments. "I heard if you play the NT-4.0-CD backwards, you get a satanic message" "That is nothing, if you play it forward, it installs NT-4.0" -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Starting .36 with innobase failed on HPUX-11 / problem with my.cnf
Hi, after succesfully compiling mysql-3.23.36 on my HP-UX11 box (Heikki, thank you for your hints), I can't start start the DB with the start.server script. I created a /etc/my.cnf file with the following values: [mysqld] innobase_data_home_dir = /opt/mysql/var/ innobase_log_group_home_dir = /opt/mysql/var innobase_log_arch_dir = /opt/mysql/mysql/var innobase_data_file_path = ib_data1:10M set-variable = innobase_mirrored_log_groups=1 set-variable = innobase_log_files_in_group=3 set-variable = innobase_log_file_size=5M set-variable = innobase_log_buffer_size=8M innobase_flush_log_at_trx_commit=1 innobase_log_archive=0 set-variable = innobase_buffer_pool_size=16M set-variable = innobase_additional_mem_pool_size=2M set-variable = innobase_file_io_threads=4 set-variable = innobase_lock_wait_timeout=50 ~ After starting I found the following error in the .err file: 010405 14:30:32 mysqld started /opt/mysql/libexec/mysqld: unrecognized option `--~' /opt/mysql/libexec/mysqld Ver 3.23.36 for hp-hpux11.00 on hppa1.1 Copyright (C) 2000 MySQL AB & MySQL Finland AB, by Monty and others This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Starts the MySQL server Usage: /opt/mysql/libexec/mysqld [OPTIONS] --ansiUse ANSI SQL s. snip After removing the /etc/my.cnf file the server starts sucessfully, but without initializing the innobase stuff because the necessary pathes/variables are not set. Okay, second I tried, sucessfully, to start mysqld manually with the following commandline /opt/mysql/libexec/mysqld --user=mysql --basedir=/opt/mysql \ --datadir=/opt/mysql/var --innobase_data_home_dir=/opt/mysql/var/ \ --innobase_data_file_path=ib_data1:10M I suppose that mysqld (on HP-UX11) doesn't handle the my.cnf options correctly??? By the way, I need to append a '/' at the end of the innobase_data_home_dir path in contrast to documentation. Greetings from Germany Andre -- E-Mail: [EMAIL PROTECTED] Date: 05-Apr-01 Time: 14:20:03 () Join the ASCII ribbon campaign against html email /\ and Microsoft attachments. "I heard if you play the NT-4.0-CD backwards, you get a satanic message" "That is nothing, if you play it forward, it installs NT-4.0" -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
3.23.36: can't compile under hpux-11
Hi, I have got problems while compiling 3.23.36 under HP-UX11. gcc exited with an internal error. I am using gcc version 2.95.2 19991024 (release) I 'configured' with the following lines: CXX=gcc CXXFLAGS="-felide-constructors -fno-exceptions -fno-rtti -O6" CFLAGS="-fomit-frame-pointer -O6 -fpic" ./configure --with-berkeley-db --with-innobase --prefix=/opt/mysql --disable-shared . . . Making all in ut gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include-g -O2 -DDEBUG_OFF -c ut0byte.c gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include-g -O2 -DDEBUG_OFF -c ut0dbg.c gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include-g -O2 -DDEBUG_OFF -c ut0mem.c In file included from ../include/ut0mem.h:12, from ut0mem.c:9: /opt/gcc/lib/gcc-lib/hppa2.0n-hp-hpux11.00/2.95.2/include/string.h:29: warning: conflicting types for built-in function `memcmp' /opt/gcc/lib/gcc-lib/hppa2.0n-hp-hpux11.00/2.95.2/include/string.h:85: warning: conflicting types for built-in function `memcpy' /opt/gcc/lib/gcc-lib/hppa2.0n-hp-hpux11.00/2.95.2/include/string.h:87: warning: conflicting types for built-in function `memset' gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include-g -O2 -DDEBUG_OFF -c ut0rnd.c gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include-g -O2 -DDEBUG_OFF -c ut0ut.c rm -f libut.a ar cru libut.a ut0byte.o ut0dbg.o ut0mem.o ut0rnd.o ut0ut.o ranlib libut.a Making all in btr gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include-g -O2 -DDEBUG_OFF -c btr0btr.c btr0btr.c: In function `btr_page_free': btr0btr.c:458: Internal compiler error at expr.c:2754 *** Error exit code 1 Stop. What's going on? Andre -- E-Mail: [EMAIL PROTECTED] Date: 03-Apr-01 Time: 12:17:56 () Join the ASCII ribbon campaign against html email /\ and Microsoft attachments. "I heard if you play the NT-4.0-CD backwards, you get a satanic message" "That is nothing, if you play it forward, it installs NT-4.0" -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: scripts/mysql_install_db[284]: 5269 Memory fault(coredum
Hi, I have had the same problem. After deinstalling the last DCE Patch PHSS_19739 everything works okay. Best regards Andre On 18-Jan-01 [EMAIL PROTECTED] wrote: >>Description: > I downloaded the binary for mysql-3.23.30-gamma-hp-hpux10.20-hppa1.1. > And followed the following procedure :- > shell> groupadd mysql > shell> useradd -g mysql mysql > shell> cd /usr/local > shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf - > shell> ln -s mysql-VERSION-OS mysql > shell> cd mysql > shell> scripts/mysql_install_db > > > I'm unable to start the mysql server . It crashes with the following message >:- > ># cd mysql ># scripts/mysql_install_db > Preparing db table > Preparing host table > Preparing user table > Preparing func table > Preparing tables_priv table > Preparing columns_priv table > Installing all prepared tables > scripts/mysql_install_db[284]: 5269 Memory fault(coredump) > Installation of grant tables failed! > > Trying to start manually also ends with the same error message :- > ># bin/safe_mysqld --user=mysql & > [1] 5759 ># Starting mysqld daemon with databases from > /a/stor/hp700_ux100/usr/local/mysql-3.23.30-gamma-hp-hpux10.20-hppa1.1/data > bin/safe_mysqld[216]: 5771 Memory fault > 010118 15:26:28 mysqld ended > > > >>How-To-Repeat: > > > shell> groupadd mysql > shell> useradd -g mysql mysql > shell> cd /usr/local > shell> gunzip < mysql-3.23.30-gamma-hp-hpux10.20-hppa1.1.tar.gz | tar xvf - > shell> ln -s mysql-3.23.30-gamma-hp-hpux10.20-hppa1.1 mysql > shell> cd mysql > shell> scripts/mysql_install_db > >>Fix: > > >>Submitter-Id: [EMAIL PROTECTED] >>Originator: >>Organization: Intel Corp > >>MySQL support: [none] >>Synopsis: scripts/mysql_install_db[284]: 5269 Memory fault(coredump) >>Severity: >>Priority: >>Category: mysql >>Class: >>Release: mysql-3.23.30-gamma (Official MySQL binary) > >>Environment: > > System: HP-UX pdchp49 B.10.20 A 9000/782 2002743626 two-user license > > > Some paths: /usr/local/bin/perl /usr/bin/make /usr/local/bin/gmake > /usr/bin/cc > > Compilation info: CC='gcc' CFLAGS='-DHPUX -I/opt/dce/include > -fomit-frame-pointer -O6 -fpic' CXX='gcc' CXXFLAGS='-DHPUX > -I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti -O6 ' > LDFLAGS='' > LIBC: > -r-xr-xr-x 1 binbin1859584 Jul 16 1999 /lib/libc.1 > -r--r--r-- 1 binbin2453308 Jul 16 1999 /lib/libc.a > lrwxr-xr-x 1 root sys 15 Dec 18 1999 /lib/libc.sl -> > /usr/lib/libc.1 > -r-xr-xr-x 1 binbin1859584 Jul 16 1999 /usr/lib/libc.1 > -r--r--r-- 1 binbin2453308 Jul 16 1999 /usr/lib/libc.a > lrwxr-xr-x 1 root sys 15 Dec 18 1999 /usr/lib/libc.sl -> > /usr/lib/libc.1 > Configure command: ./configure --prefix=/usr/local/mysql > '--with-comment=Official MySQL binary' --with-extra-charsets=complex > --with-pthread --with-named-thread-libs=-ldce --disable-shared > Perl: This is perl, version 4.0 > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- E-Mail: [EMAIL PROTECTED] Date: 18-Jan-01 Time: 11:39:41 This message was sent by XFMail -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
