Is there is utility which is free to convert ms SQL 7.0 running on windows
NT into a mySQL format, i would be very grateful if someone in here could
help me out.
Thanks.
Karma
----- Original Message -----
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 06, 2003 2:53 PM
Subject: Re: start innodb without transactions
> Carlos,
>
> please send me your my.cnf. How big is the combined size of your log
files?
>
> "
> MySQL/InnoDB-4.0.9, January 14, 2003
>
> Fixed a bug: if the combined size of InnoDB log files was >= 2 GB in a
> 32-bit computer, InnoDB would write log in a wrong position. That could
make
> crash recovery and InnoDB Hot Backup to fail.
> "
>
> In the first printout:
>
> > InnoDB: Starting log scan based on checkpoint at
> > InnoDB: log sequence number 13 1000286684
> > InnoDB: Doing recovery: scanned up to log sequence number 13 1000286208
>
> looks like InnoDB is not able to scan the log file at all, not even up to
> the checkpoint!
>
> > InnoDB: log sequence number 13 1002344016
> > InnoDB: Doing recovery: scanned up to log sequence number 13 1002343936
>
> The same in the next printout. It has written some 2 MB more log but
cannot
> after a crash scan the log at all!
>
> The failing assertion checks when freeing a BLOB or TEXT field that its
> length is right:
>
> if (extern_len - part_len == 0) {
> ut_a(next_page_no == FIL_NULL);
> }
>
> This could be:
>
> 1) a bug in InnoDB's log writing;
> 2) hardware fault, broken disk;
> 3) serious corruption of the OS file system.
>
> If InnoDB fails to scan lots of log in crash recovery, it means that the
> resulting database may have very extensive corruption. That can explain
why
> some of your tables are not visible at all.
>
> There is little hope of recovering your tables. You should resort to a
> backup and upgrade to 4.0.13. Then do some heavy processing, for example,
a
> table import, and crash mysqld artificially by
>
> killall -9 mysqld
>
> Look then if InnoDB is able to scan the log in crash recovery.
>
> Best regards,
>
> Heikki Tuuri
> Innobase Oy
> http://www.innodb.com
> Transactions, foreign keys, and a hot backup tool for MySQL
> Order MySQL technical support from https://order.mysql.com/
>
>
>
> ----- Original Message -----
> From: ""Carlos Proal"" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.mysql
> Sent: Friday, June 06, 2003 7:41 AM
> Subject: Re: start innodb without transactions
>
>
> >
> > Probably i need to describe the whole story:
> > I did a huge insert, a file about 100Mb, and mysql crashed/restarted,
the
> > err file showed:
> > --------------------------------------------------------------
> > 030605 12:11:59 mysqld restarted
> > 030605 12:12:00 InnoDB: Database was not shut down normally.
> > InnoDB: Starting recovery from log files...
> > InnoDB: Starting log scan based on checkpoint at
> > InnoDB: log sequence number 13 1000286684
> > InnoDB: Doing recovery: scanned up to log sequence number 13 1000286208
> > InnoDB: Last MySQL binlog file position 0 756499, file name
> > ./catarina-bin.057
> > 030605 12:12:01 InnoDB: Flushing modified pages from the buffer pool...
> > 030605 12:12:01 InnoDB: Started
> > /centia01/final/database/mysql/libexec/mysqld: ready for connections
> > 030605 12:14:01 InnoDB: Out of memory in additional memory pool.
> > InnoDB: InnoDB will start allocating memory from the OS.
> > InnoDB: You may get better performance if you configure a bigger
> > InnoDB: value in the MySQL my.cnf file for
> > InnoDB: innodb_additional_mem_pool_size.
> > mysqld got signal 10;
> > This could be because you hit a bug. It is also possible that this
binary
> > or one of the libraries it was linked against is corrupt, improperly
> built,
> > or misconfigured. This error can also be caused by malfunctioning
> hardware.
> > We will try our best to scrape up some info that will hopefully help
> > diagnose
> > the problem, but since we have already crashed, something is definitely
> > wrong
> > and this may fail.
> >
> > key_buffer_size=67104768
> > read_buffer_size=131072
> > sort_buffer_size=524280
> > max_used_connections=4
> > max_connections=500
> > threads_connected=4
> > It is possible that mysqld could use up to
> > key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections
=
> > 385528
> > K
> > bytes of memory
> > Hope that's ok; if not, decrease some variables in the equation.
> > ----------------------------------------------------------
> >
> > (i have 256Mb in buffer pool) But the next restart stopped mysql
showing:
> > ----------------------------------------------------------
> > 030605 12:14:30 mysqld restarted
> > 030605 12:14:32 InnoDB: Database was not shut down normally.
> > InnoDB: Starting recovery from log files...
> > InnoDB: Starting log scan based on checkpoint at
> > InnoDB: log sequence number 13 1002344016
> > InnoDB: Doing recovery: scanned up to log sequence number 13 1002343936
> > InnoDB: 1 transaction(s) which must be rolled back or cleaned up
> > InnoDB: Trx id counter is 0 119167744
> > InnoDB: Starting rollback of uncommitted transactions
> > InnoDB: Rolling back trx with id 0 119167355
> > 030605 12:14:32 InnoDB: Assertion failure in thread 1 in file btr0cur.c
> > line 3350
> > InnoDB: We intentionally generate a memory trap.
> > InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
> > mysqld got signal 11;
> > ----------------------------------------------------------
> >
> > i started with force_recovery and indeed i can recover with mysqldump
some
> > databases but i was confused because my first try was with a db that
> > apparently i cant recover, even inside mysql i get the following:
> > ---------------------------------------------------------
> > mysql> desc facturas;
> > ERROR 1016: Can't open file: 'facturas.InnoDB'. (errno: 1)
> > mysql> show table status;
> >
>
+--------------+------+------------+------+----------------+-------------+--
> ---------------+--------------+-----------+----------------+-------------+
--
> -----------+------------+----------------+--------------------------------
--
> ------------------+
> > | Name | Type | Row_format | Rows | Avg_row_length | Data_length
|
> > Max_data_length | Index_length | Data_free | Auto_increment |
Create_time
> |
> > Update_time | Check_time | Create_options | Comment
> > |
> >
>
+--------------+------+------------+------+----------------+-------------+--
> ---------------+--------------+-----------+----------------+-------------+
--
> -----------+------------+----------------+--------------------------------
--
> ------------------+
> > | facturas | NULL | NULL | NULL | NULL | NULL
|
> > NULL | NULL | NULL | NULL | NULL
|
> > NULL | NULL | NULL | Can't open file:
> > 'facturas.InnoDB'. (errno: 1) |
> > | presupuestos | NULL | NULL | NULL | NULL | NULL
|
> > NULL | NULL | NULL | NULL | NULL
|
> > NULL | NULL | NULL | Can't open file:
> > 'presupuestos.InnoDB'. (errno: 1) |
> > | proveedores | NULL | NULL | NULL | NULL | NULL
|
> > NULL | NULL | NULL | NULL | NULL
|
> > NULL | NULL | NULL | Can't open file:
> > 'proveedores.InnoDB'. (errno: 1) |
> > | roles | NULL | NULL | NULL | NULL | NULL
|
> > NULL | NULL | NULL | NULL | NULL
|
> > NULL | NULL | NULL | Can't open file:
> 'roles.InnoDB'.
> > (errno: 1) |
> > | usuarios | NULL | NULL | NULL | NULL | NULL
|
> > NULL | NULL | NULL | NULL | NULL
|
> > NULL | NULL | NULL | Can't open file:
> > 'usuarios.InnoDB'. (errno: 1) |
> >
>
+--------------+------+------------+------+----------------+-------------+--
> ---------------+--------------+-----------+----------------+-------------+
--
> -----------+------------+----------------+--------------------------------
--
> ------------------+
> > 5 rows in set (0.06 sec)
> >
> > ---------------------------------------------------------
> >
> > Heikki, thanx a lot for your help, its really appreciated.
> >
> > Carlos
> >
> >
> >
> >
> > ----Original Message Follows----
> > From: "Heikki Tuuri" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Subject: Re: start innodb without transactions
> > Date: Fri, 6 Jun 2003 04:23:57 +0300
> >
> > Carlos,
> >
> > ----- Original Message -----
> > From: ""Carlos Proal"" <[EMAIL PROTECTED]>
> > Newsgroups: mailing.database.mysql
> > Sent: Friday, June 06, 2003 4:04 AM
> > Subject: start innodb without transactions
> >
> >
> > >
> > > Hi all
> > > Is there any way to start mysql/innodb skipping transactions ?, i had
a
> > > crash and i cant get the database to work.
> > >
> > > i tried the force_recovery option level 3:
> > > # 3 (SRV_FORCE_NO_TRX_UNDO) do not run transaction rollbacks after
> > recovery;
> > >
> > > this way i can get it to work, but as the manual said i cant do any
> > update
> > > query while force_recovery is on and also cant do a mysqldump, so im
> > stucked
> > > :(.
> >
> > why you cannot do a mysqldump? innodb_force_recovery does not prevent
> SELECT
> > queries.
> >
> > > any ideas ?
> > > Im using mysql 4.0.4, solaris 8 sparc .
> >
> > Upgrade to 4.0.13. Also send me the .err log. Database corruption is
> > uncommon in Solaris, interesting to see what is in the .err log.
> >
> > > thanx
> > > Carlos
> >
> > Best regards,
> >
> > Heikki Tuuri
> > Innobase Oy
> > http://www.innodb.com
> > Transactions, foreign keys, and a hot backup tool for MySQL
> > Order MySQL technical support from https://order.mysql.com/
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
> >
> > _________________________________________________________________
> > STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
> > http://join.msn.com/?page=features/junkmail
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> >
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
