MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Ferindo Middleton Date:June 26 2006 7:57pm
Subject:Re: error loading data from file > ERROR 1329 (02000): No data - zero rows fetched, selected, or processed
View as plain text  
Does MySQL have any constraints when it comes to the number columns that it
can accurately support/import in any one table/file. When I see this file
that is failing to get properly read into the database, that's what comes to
mind... It's failing because of some kind of constraint or threshold of the
db so instead of giving a meaningful messgae, it just says: ERROR 1329
(02000): No data - zero rows fetched, selected, or processed

Ferindo

On 6/23/06, Ferindo Middleton <ferindo.middleton@stripped> wrote:
>
>  I guess my general reason for posting this was to ask: "Are there any
> known issues with the LOAD DATA INFILE comand in MySQL?" However, I
> stripped all the data in the file (test.tab) down to one record which
> still wouldn't load. Here is the command:
>
> mysql> LOAD DATA INFILE 'C:/Program Files/Apache Software
> Foundation/Tomcat 5.5/
> webapps/utrad/docs/rebuild_scratch_area/test.tab' INTO TABLE reggie;
>
> The fields inside the file are tab-delimited and look like this:
>
> 16411 5 Rupert Settles Settles Settles 1 esunindyo \N 207 \N 12 \N 2005-01-03
> 2005-01-07 1 1 1 0 \N Deobligation 1 2 \N fmiddleton 0 0 \N \N 11:00:00 \N \N \N 0 0 4 0 0
> \N \N \N 1
>
> The structure of the TABLE reggie is this:
>
> CREATE TABLE `reggie ` (
>   `id` bigint(20) unsigned NOT NULL auto_increment,
>   `title_salutation_id` bigint(20) unsigned NOT NULL,
>   `firstname` varchar(128) NOT NULL,
>   `middlename` varchar(128) NOT NULL default '',
>   `lastname` varchar(128) NOT NULL default '',
>   `suffix` varchar(128) NOT NULL default '',
>   `paper_received` tinyint(1) NOT NULL default '1',
>   `addr` text,
>   `cc_email_list` text,
>   `fortran_id` bigint(20) default NULL,
>   `office` text,
>   `class_id` bigint(20) unsigned NOT NULL,
>   `schedule_id` bigint(20) default NULL,
>   `start_date` date NOT NULL default '0000-00-00',
>   `end_date` date NOT NULL default '0000-00-00',
>   `enrolled` tinyint(1) default NULL,
>   `attended` tinyint(1) default NULL,
>   `completed` tinyint(1) default NULL,
>   `cancelled` tinyint(1) default '0',
>   `cancelled_comments` text,
>   `comments` text,
>   `email_confirmation_sent` tinyint(1) NOT NULL,
>   `employment_status_id` bigint(20) unsigned NOT NULL default '0',
>   `last_updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update
> CURRENT_TIMESTAMP,
>   `last_user_updated` text,
>   `waitlisted` tinyint(1) default '0',
>   `overflow_registrant` tinyint(1) default '0',
>   `attach_hotel_listing_directions` tinyint(1) default NULL,
>   `instructor_legacy` text,
>   `time_legacy` time default NULL,
>   `ssn_legacy` text,
>   `position_grade_title` text,
>   `office_phone_legacy` text,
>   `contractor_legacy` tinyint(1) default NULL,
>   `no_show` tinyint(1) default NULL,
>   `funding_id` bigint(20) unsigned NOT NULL default '0',
>   `incomplete` tinyint(1) default NULL,
>   `prerequisites_completed` tinyint(1) default NULL,
>   `score` smallint(5) unsigned default NULL,
>   `per_diem_cost` decimal(10,0) default NULL,
>   `travel_cost` decimal(10,0) default NULL,
>   `first_migration` tinyint(1) unsigned default NULL,
>   PRIMARY KEY
> (`firstname`,`middlename`,`lastname`,`suffix`,`class_id`,`start_date`,`end_date`),
>   UNIQUE KEY `id` (`id`),
>   KEY `fk_registration_class_id_must_always_match_a_classes_id`
> (`class_id`),
>   KEY `fk_registration_title_id_must_always_match_title_salutations_id`
> (`title_salutation_id`),
>   KEY `fk_registration_bureau_id_must_always_match_a_bureaus_id`
> (`bureau_id`),
>   KEY `fk_funding_id_check_for_registration_and_attendance`
> (`funding_id`),
>   KEY `fk_employment_status_id_check_for_registration_and_attendance`
> (`employment_status_id`),
>   CONSTRAINT
> `fk_employment_status_id_check_for_registration_and_attendance` FOREIGN KEY
> (`employment_status_id`) REFERENCES `employment_statuses` (`id`),
>   CONSTRAINT `fk_funding_id_check_for_registration_and_attendance` FOREIGN
> KEY (`funding_id`) REFERENCES `funding_types` (`id`),
>   CONSTRAINT `fk_registration_bureau_id_must_always_match_a_bureaus_id`
> FOREIGN KEY (`bureau_id`) REFERENCES `bureaus` (`id`),
>   CONSTRAINT `fk_registration_class_id_must_always_match_a_classes_id`
> FOREIGN KEY (`class_id`) REFERENCES `classes` (`id`),
>   CONSTRAINT
> `fk_registration_title_id_must_always_match_title_salutations_id` FOREIGN
> KEY (`title_salutation_id`) REFERENCES `title_salutations` (`id`)
> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
>
> Do you know why this this one data record won't load?... why MySQL says:
> ERROR 1329 (02000): No data - zero rows fetched, selected, or processed
>
> Ferindo
>
> On 6/23/06, Gerald L. Clark <gerald_clark@stripped> wrote:
> >
> > Ferindo Middleton wrote:
> > > I'm trying to load data into a table from a file but I get an error
> > > message:
> > >
> > > ERROR 1329 (02000): No data - zero rows fetched, selected, or
> > processed
> > >
> > > This error message isn't very specific as to what is going wrong and I
> > have
> > > no idea what it is about the data file that is wrong. Of course, I
> > know
> > > that
> > > there is in fact data in the file and that it is proper data types
> > matching
> > > the table structure so I don't know why this error message is occuring
> > or
> > > what it is about the file that's stopping it from being loaded.
> > >
> > Since you did not show us the data, nor the command you used to load the
> > data, we can't tell you what is wrong.
> >
> > --
> > Gerald L. Clark
> > Supplier Systems Corporation
> >
>
>
>
> --
> Ferindo Middleton
> Technical Lead - Research and AUI Infrastructure Development
> Sleekcollar Software
>



-- 
Ferindo Middleton
Technical Lead - Research and AUI Infrastructure Development
Sleekcollar Software

Thread
error loading data from file > ERROR 1329 (02000): No data - zero rows fetched, selected, or processedFerindo Middleton23 Jun
  • Re: error loading data from file > ERROR 1329 (02000): No data -zero rows fetched, selected, or processedGerald L. Clark23 Jun
    • Re: error loading data from file > ERROR 1329 (02000): No data - zero rows fetched, selected, or processedFerindo Middleton23 Jun
      • Re: error loading data from file > ERROR 1329 (02000): No data - zero rows fetched, selected, or processedFerindo Middleton26 Jun
        • Re: error loading data from file > ERROR 1329 (02000): No data -zero rows fetched, selected, or processedDan Buettner26 Jun
          • Re: error loading data from file > ERROR 1329 (02000): No data - zero rows fetched, selected, or processedFerindo Middleton27 Jun