Re: MySQL 5.0.4-beta has been released
Here are the sequence of queries that executed before the server crashed... CREATE TEMPORARY TABLE COMETTRACKER.DELIVERY_TRACKING_ETA ( PACKAGEID BIGINT NOT NULL, RECID_CTASKDATA BIGINT , RECTYPE INT(11) , USERID INT(11) , TIMETAG1 DATETIME , TIMETAG2 DATETIME , P_DATA1 VARCHAR(20) , P_DATA2 VARCHAR(20) , SEQVALUE INT(11) , SEQUENCE_NUM_TRIP INT(11) , COMPANY_CD VARCHAR(6), PRODUCT_CD CHAR(2), IO_NUM VARCHAR(4), BARCODE VARCHAR(25), SEQCODE VARCHAR(6), SEQCODE1 VARCHAR(6), PRIMARY KEY (PACKAGEID), UNIQUE RECIDTASKDATA(RECID_CTASKDATA), KEY COCODE (COMPANY_CD, PRODUCT_CD) ) INSERT INTO COMETTRACKER.DELIVERY_TRACKING_ETA( PACKAGEID, RECID_CTASKDATA, RECTYPE, USERID, TIMETAG1, TIMETAG2, P_DATA1, P_DATA2, SEQVALUE, SEQUENCE_NUM_TRIP, COMPANY_CD, PRODUCT_CD, IO_NUM, BARCODE, SEQCODE, SEQCODE1) SELECT PACKAGEID, RECID_CTASKDATA, RECTYPE, USERID, TIMETAG1, TIMETAG2, P_DATA1, P_DATA2, SEQVALUE, SEQUENCE_NUM_TRIP, COMPANY_CD, PRODUCT_CD, IO_NUM, BARCODE, SEQCODE, SEQCODE1 FROM COMETTRACKER.DELIVERY_TRACKING WHERE TRIP_DATE = "20050519" AND P_DATA1 = "14" AND USERID = "21234" ORDER BY RECID_CTASKDATA CREATE TEMPORARY TABLE COMETTRACKER.DELIVERY_TRACKING_SORT SELECT MIN(SEQVALUE) SEQVALUE, COMPANY_CD, PRODUCT_CD, IO_NUM FROM COMETTRACKER.DELIVERY_TRACKING_ETA WHERE P_DATA1 = "14" AND (P_DATA2 = "" OR P_DATA2 IS NULL) GROUP BY COMPANY_CD ORDER BY COMPANY_CD UPDATE COMETTRACKER.DELIVERY_TRACKING_ETA D, COMETTRACKER.DELIVERY_TRACKING_SORT S SET D.SEQVALUE = S.SEQVALUE WHERE (D.P_DATA2 = "" OR D.P_DATA2 IS NULL) AND (S.COMPANY_CD = D.COMPANY_CD AND S.PRODUCT_CD = D.PRODUCT_CD AND S.IO_NUM = D.IO_NUM) This query below did not execute because "Server Had Gone Away" UPDATE COMETTRACKER.DELIVERY_TRACKING D, COMETTRACKER.DELIVERY_TRACKING_ETA E SET D.SEQVALUE = E.SEQVALUE WHERE (E.PACKAGEID = D.PACKAGEID) - Original Message - From: "Reggie Burnett" <[EMAIL PROTECTED]> To: "Fredrick Bartlett" <[EMAIL PROTECTED]> Cc: "MySQL General List" Sent: Tuesday, April 19, 2005 8:00 AM Subject: Re: MySQL 5.0.4-beta has been released > What were you doing when it failed? What type of connections was it > handling? > > >Hmmm, it ran for about two hours (Win32) then crashed. I don't receive any > >error messages to post. Server just stops??? > > > >- Original Message - > >From: "Martijn Tonies" <[EMAIL PROTECTED]> > >To: "Joerg Bruehe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > >Cc: "MySQL General List" ; > ><[EMAIL PROTECTED]> > >Sent: Tuesday, April 19, 2005 2:42 AM > >Subject: Re: MySQL 5.0.4-beta has been released > > > > > > > > > >>>A new version of MySQL Community Edition 5.0.4-beta Open Source database > >>>management system has been released. This version now includes support > >>> > >>> > >>for > >> > >> > >>>Stored Procedures, Triggers, Views and many other features. It is now > >>>available in source and binary form for a number of platforms from our > >>>download pages at http://dev.mysql.com/downloads/ and mirror sites. > >>> > >>> > >>Woohoo, it works on Windows :-) > >> > >>One thing that it doesn't do yet though, is saving the view > >>definition in a human readable way instead of that auto-generated > >>gibberish :-) > >> > >>With regards, > >> > >>Martijn Tonies > >>Database Workbench - developer tool for InterBase, Firebird, MySQL & MS > >> > >> > >SQL > > > > > >>Server > >>Upscene Productions > >>http://www.upscene.com > >> > >> > >>-- > >>MySQL General Mailing List > >>For list archives: http://lists.mysql.com/mysql > >>To unsubscribe: > >> > >> > >http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > >
Re: MySQL 5.0.4-beta has been released
What were you doing when it failed? What type of connections was it handling? Hmmm, it ran for about two hours (Win32) then crashed. I don't receive any error messages to post. Server just stops??? - Original Message - From: "Martijn Tonies" <[EMAIL PROTECTED]> To: "Joerg Bruehe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: "MySQL General List" ; <[EMAIL PROTECTED]> Sent: Tuesday, April 19, 2005 2:42 AM Subject: Re: MySQL 5.0.4-beta has been released A new version of MySQL Community Edition 5.0.4-beta Open Source database management system has been released. This version now includes support for Stored Procedures, Triggers, Views and many other features. It is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and mirror sites. Woohoo, it works on Windows :-) One thing that it doesn't do yet though, is saving the view definition in a human readable way instead of that auto-generated gibberish :-) With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server Upscene Productions http://www.upscene.com -- 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]
Re: MySQL 5.0.4-beta has been released
Hmmm, it ran for about two hours (Win32) then crashed. I don't receive any error messages to post. Server just stops??? - Original Message - From: "Martijn Tonies" <[EMAIL PROTECTED]> To: "Joerg Bruehe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: "MySQL General List" ; <[EMAIL PROTECTED]> Sent: Tuesday, April 19, 2005 2:42 AM Subject: Re: MySQL 5.0.4-beta has been released > > A new version of MySQL Community Edition 5.0.4-beta Open Source database > > management system has been released. This version now includes support > for > > Stored Procedures, Triggers, Views and many other features. It is now > > available in source and binary form for a number of platforms from our > > download pages at http://dev.mysql.com/downloads/ and mirror sites. > > Woohoo, it works on Windows :-) > > One thing that it doesn't do yet though, is saving the view > definition in a human readable way instead of that auto-generated > gibberish :-) > > With regards, > > Martijn Tonies > Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL > Server > Upscene Productions > http://www.upscene.com > > > -- > 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]
Re: MySQL 5.0.4-beta has been released
> A new version of MySQL Community Edition 5.0.4-beta Open Source database > management system has been released. This version now includes support for > Stored Procedures, Triggers, Views and many other features. It is now > available in source and binary form for a number of platforms from our > download pages at http://dev.mysql.com/downloads/ and mirror sites. Woohoo, it works on Windows :-) One thing that it doesn't do yet though, is saving the view definition in a human readable way instead of that auto-generated gibberish :-) With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 5.0.4-beta has been released
On Mon, 18 Apr 2005 18:04:46 +0200 Joerg Bruehe <[EMAIL PROTECTED]> wrote: > Are you sure it did not get damaged during transfer, or by your > browser? All I can recommend is to try another mirror. I'm using elinks text browser, which has worked great for this in the past. I tried about 4 different mirrors. I'll keep at it and see if I get a better download. Thx, Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 5.0.4-beta has been released
Hi! Am Mo, den 18.04.2005 schrieb Josh Trutwin um 17:46: > On Mon, 18 Apr 2005 13:28:24 +0200 > Joerg Bruehe <[EMAIL PROTECTED]> wrote: > > > [[...]] > > > > Note that not all mirror sites may be up-to-date at this point. If > > you cannot find this version on a particular mirror, please try > > again later or choose another download site. > > > > The mirrors seem to have links to the source tarball, but I've > downloaded 5 different files and each time I get: > > # tar zxvf mysql-5.0.4-beta.tar.gz > > gzip: stdin: not in gzip format > tar: Child returned status 1 > tar: Error exit delayed from previous errors > > Something amiss or am I losing it? Hard to tell - for me, it works on our machine: ~/stage/Downloads/MySQL-5.0> tar ztvf mysql-5.0.4-beta.tar.gz | head drwxrwxrwx 503/100 0 2005-04-16 21:10:24 mysql-5.0.4-beta/ drwxrwxrwx 503/100 0 2005-04-16 21:10:06 mysql-5.0.4-beta/bdb/ -rw-r--r-- 503/1001998 2005-04-16 21:01:45 mysql-5.0.4-beta/bdb/Makefile.in ... and it works on my private PC with a package downloaded from Sunsite Europe: http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-5.0.4-beta.tar.gz/from/http://sunsite.informatik.rwth-aachen.de/mysql/ [EMAIL PROTECTED]:~> tar tzvf /opt/Downloads/mysql-5.0.4-beta.tar.gz | head drwxrwxrwx 503/100 0 2005-04-16 21:10:24 mysql-5.0.4-beta/ drwxrwxrwx 503/100 0 2005-04-16 21:10:06 mysql-5.0.4-beta/bdb/ -rw-r--r-- 503/1001998 2005-04-16 21:01:45 mysql-5.0.4-beta/bdb/Makefile.in ... Are you sure it did not get damaged during transfer, or by your browser? All I can recommend is to try another mirror. HTH, Joerg Bruehe -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 5.0.4-beta has been released
On Mon, 18 Apr 2005 13:28:24 +0200 Joerg Bruehe <[EMAIL PROTECTED]> wrote: > Hi, > > A new version of MySQL Community Edition 5.0.4-beta Open Source > database management system has been released. This version now > includes support for Stored Procedures, Triggers, Views and many > other features. It is now available in source and binary form for a > number of platforms from our download pages at > http://dev.mysql.com/downloads/ and mirror sites. > > Note that not all mirror sites may be up-to-date at this point. If > you cannot find this version on a particular mirror, please try > again later or choose another download site. The mirrors seem to have links to the source tarball, but I've downloaded 5 different files and each time I get: # tar zxvf mysql-5.0.4-beta.tar.gz gzip: stdin: not in gzip format tar: Child returned status 1 tar: Error exit delayed from previous errors Something amiss or am I losing it? Thanks, Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
