I am running the 4.0.12 version For those tables I don't have FOREIGN KEYS here is the table desc.
CREATE TABLE CLIENTE ( FINGCIOID smallint(6) NOT NULL default '0', FINOTIENDA smallint(6) NOT NULL default '0', FICTEID int(11) NOT NULL default '0', FIDIGITOVER smallint(6) NOT NULL default '0', FIOCUID smallint(6) NOT NULL default '0', FCCTENOMBRE char(18) NOT NULL default '', FCCTEAPATERNO char(18) NOT NULL default '', FCCTEAMATERNO char(18) NOT NULL default '', FCCTEDIRCALLE char(25) NOT NULL default '', FCCTEDIRNOEXT char(5) NOT NULL default '', FCCTEDIRNOINT char(5) NOT NULL default '', FCCTECP char(5) NOT NULL default '', FCCTECOLONIA char(65) NOT NULL default '', FCCTESEXO char(1) NOT NULL default '', FCCTETEL char(15) NOT NULL default '', FCCTERFC char(14) NOT NULL default '', FCCTEFISMOR char(2) NOT NULL default '', FITDAATIENDE smallint(6) NOT NULL default '0', FDCTEFECALT datetime NOT NULL default '0000-00-00 00:00:00', FLCTEECO smallint(6) NOT NULL default '0', FIEDOCIVIL smallint(6) NOT NULL default '0', FNLINEACRED decimal(8,2) NOT NULL default '0.00', FDCTEFECNAC datetime NOT NULL default '0000-00-00 00:00:00', FCNOCOBRADOR char(6) NOT NULL default '', FITRANNO int(11) NOT NULL default '0', KEY cliente (FCCTENOMBRE,FCCTEAPATERNO,FCCTEAMATERNO,FINOTIENDA) ) TYPE=InnoDB;
CREATE TABLE PEDIDO ( FISUCURSAL int(11) NOT NULL default '0', FINOPEDIDO int(11) NOT NULL default '0', FINGCIOID smallint(6) NOT NULL default '0', FICTEID int(11) NOT NULL default '0', FINOTIENDA smallint(6) NOT NULL default '0', FIDIGITOVER smallint(6) NOT NULL default '0', FCEMPNO char(6) NOT NULL default '', FITIPOVENTA smallint(6) NOT NULL default '0', FDPEDFEC datetime NOT NULL default '0000-00-00 00:00:00', FNPEDTOTAL decimal(12,2) NOT NULL default '0.00', FIPEDFACT int(11) NOT NULL default '0', FDFECFACT datetime NOT NULL default '0000-00-00 00:00:00', FIPEDSTAT smallint(6) NOT NULL default '0', FCUSERID char(10) NOT NULL default '', FCWS char(10) NOT NULL default '', FDFECSURT datetime NOT NULL default '0000-00-00 00:00:00', FNPEDSALDO decimal(12,2) NOT NULL default '0.00', FCFOLIOPARAM int(11) NOT NULL default '0', FDFECIMPFACTURA datetime NOT NULL default '0000-00-00 00:00:00', FIDIASSERV smallint(6) NOT NULL default '0' ) TYPE=InnoDB;
And I haven't tried to downgrade my version.
Greetings
From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: Re: ERROR 2013:Lost connection to MySQL server Date: Wed, 2 Jul 2003 00:35:09 +0300
Miguel,
what exact MySQL version you are running?
Have you created FOREIGN KEY constraints to those tables?
Have you downgraded to a lower MySQL version?
Regards,
Heikki
----- Original Message ----- From: ""Miguel Perez"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, July 02, 2003 12:11 AM Subject: Re: ERROR 2013:Lost connection to MySQL server
> The OS I'm using is Red Hat 7.3, and the mysql version is 4.0
>
> The wierd thing is that I could access those tables but just after I
> rebooted my PC
> I couldn't access the 2 tables.
> The log files has the following:
>
> "030701 14:27:38 InnoDB: Assertion failure in thread 36874 in file
> dict0load.c line 677
> InnoDB: We intentionally generate a memory trap.
> InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
> mysqld got signal 11;
> 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. thd=0x8711eb8
> Attempting backtrace. You can use the following information to find out
> where mysqld died. If you see no messages after this, something went
> terribly wrong...
> Cannot determine thread, fp=0xbfe7e0c8, backtrace may not be correct.
> Stack range sanity check OK, backtrace follows:
> 0x80741ea
> 0x8286058
> 0x81193b5
> 0x8108df8
> 0x80cf9c9
> 0x80c9bf4
> 0x8096a76
> 0x809262b
> 0x8091ccf
> 0x8092989
> 0x80e1d18
> 0x807fdd6
> 0x8082638
> 0x807dd5d
> 0x8083b6e
> 0x807cf0f
> 0x828380c 0x82b6f1a
> New value of fp=(nil) failed sanity check, terminating stack trace!
> Please read http://www.mysql.com/doc/en/Using_stack_trace.html and follow
> instructions on how to resolve the stack trace. Resolved
> stack trace is much more helpful in diagnosing the problem, so please do
> resolve it
> Trying to get some variables.
> Some pointers may be invalid and cause the dump to abort...
> thd->query at 0x87170a8 = show create table PEDIDOS
> thd->thread_id=1
> "
>
> I have 500MB in ram.
>
> Greetings
>
> >From: Fred van Engen <[EMAIL PROTECTED]>
> >To: Miguel Perez <[EMAIL PROTECTED]>
> >CC: [EMAIL PROTECTED]
> >Subject: Re: ERROR 2013:Lost connection to MySQL server
> >Date: Tue, 1 Jul 2003 21:23:41 +0200
> >
> >Hi,
> >
> >On Tue, Jul 01, 2003 at 02:13:23PM -0500, Miguel Perez wrote:
> > > I have the following problem, when I try to connect to my DB servicios
> > > I get connected succesfully, but when I try to access certain tables I
> >get
> > > the error
> > > "ERROR 2013: Lost connection to MySQL server during query" but only
with
> > > those certain tables, to be more specific there's only 2 tables that i
> > > can't access, I get that error,
> > > the other ones works fine.
> > >
> >
> >Which version, which OS?
> >
> >
> > > Any ideas or suggestions.
> > >
> >
> >Maybe mysqld crashes? It restarts automatically, on unices at least.
> >
> >Check the mysql error log to find out if it crashed.
> >
> >
> >Regards,
> >
> >Fred.
> >
> >--
> >Fred van Engen XB Networks B.V.
> >email: [EMAIL PROTECTED] Televisieweg 2
> >tel: +31 36 5462400 1322 AC Almere
> >fax: +31 36 5462424 The Netherlands
>
> _________________________________________________________________
> Charla con tus amigos en línea mediante MSN Messenger:
> http://messenger.microsoft.com/es
>
>
> --
> 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]
_________________________________________________________________
MSN Fotos: la forma más fácil de compartir e imprimir fotos. http://photos.msn.es/support/worldwide.aspx
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
