#124: New crash in r2120
| Type: | Crash | First reported: | 16 Apr 2010 |
| Status: | Last modified: | 27 Sep 2010 | |
| Occurrences: | 90 | Fixed: | In revision r2702 |
Thread 10 Crashed:
0 libobjc.A.dylib 0x00007fff867452c8 objc_msgSend_vtable11 + 16
1 com.google.code.sequel-pro 0x00000001000763d4 -[SPSQLParser firstOccurrenceOfCharacter:afterIndex:skippingBrackets:ignoringQuotedStrings:] + 340
2 com.google.code.sequel-pro 0x0000000100076279 -[SPSQLParser firstOccurrenceOfCharacter:afterIndex:ignoringQuotedStrings:] + 25
3 com.google.code.sequel-pro 0x000000010007589a -[SPSQLParser trimAndReturnStringToCharacter:trimmingInclusively:returningInclusively:ignoringQuotedStrings:] + 122
4 com.google.code.sequel-pro 0x0000000100075819 -[SPSQLParser trimAndReturnStringToCharacter:trimmingInclusively:returningInclusively:] + 25
5 com.google.code.sequel-pro 0x000000010003af27 -[TableDump importSQLFile:] + 3591
6 com.google.code.sequel-pro 0x000000010003a11a -[TableDump importBackgroundProcess:] + 250
7 com.apple.Foundation 0x00007fff839cdead __NSThread__main__ + 1429
8 libSystem.B.dylib 0x00007fff835918b6 _pthread_start + 331
9 libSystem.B.dylib 0x00007fff83591769 thread_start + 13Comments
I was importing 103kb file into new database. Previously it happened while exporting over SSH.
just tried to batch import stored procedures and functions. If you'd like a copy of them, email me and I will send the file
import mysql dump
Imported an SQL file
DRECKSOFTWARE
come on guys pleae fix this bloody buggy seqelNOT PRO
Import a script file for a custom function
I was importing a sql script.
import an sql file
Seems not to like delimiters
tried to import an arbitrary SQL file (which may have had errors in it)
executing an import script with table updates and a create procedure statement
Imported a 290 MB database
Try to import data from a pg database.
tried importing an sql file output from phpmyadmin; an sql file with a dump of the same database worked with CREATE FUNCTION / PROCEDURE turned off
create procedure
Import of this file:
-- myprocs.sql
-- Ron Patterson, BPWC
delimiter //
drop procedure if exists add_customer//
create procedure add_customer (
in mdr_pin integer,
in mc_contact varchar(255),
in mc_school_nm varchar(255),
in mc_addr1 varchar(100),
in mc_addr2 varchar(100),
in mc_city varchar(100),
in mc_state varchar(4),
in mc_zip_4 varchar(20),
in mc_phone varchar(20),
in mc_fax varchar(20),
in mc_sch_type char(1),
in mc_email varchar(50),
out result integer
)
begin
-- declare continue handler for sqlwarning begin end;
declare continue handler for sqlexception set result = -1;
-- mdr_pin, master_id, mc_contact, mc_school_nm, mc_addr1, mc_addr2, mc_city, mc_state, mc_zip_4, mc_phone, mc_fax, mc_sch_type, mc_email, mc_vg_code, mc_notes, mc_create_dtm, mc_update_dtm, mc_update_by
insert into mdr_customers (mdr_pin, mc_contact, mc_school_nm, mc_addr1, mc_addr2, mc_city, mc_state, mc_zip_4, mc_phone, mc_fax, mc_sch_type, mc_email, mc_create_dtm)
values (mdr_pin, mc_contact, mc_school_nm, mc_addr1, mc_addr2, mc_city, mc_state, mc_zip_4, mc_phone, mc_fax, mc_sch_type, mc_email, now());
select last_insert_id() into result;
end;
//
-- call `add_customer`(123, 'Ron', 'RP', '9876 xyz', null, 'colo sprgs', 'CO', '98765', '719-555-1212', null, 'h', 'ron@foo.com', @result);
delimiter ;
-- myprocs.sql
-- Ron Patterson, BPWC
delimiter //
drop procedure if exists add_customer//
create procedure add_customer (
in mdr_pin integer,
in mc_contact varchar(255),
in mc_school_nm varchar(255),
in mc_addr1 varchar(100),
in mc_addr2 varchar(100),
in mc_city varchar(100),
in mc_state varchar(4),
in mc_zip_4 varchar(20),
in mc_phone varchar(20),
in mc_fax varchar(20),
in mc_sch_type char(1),
in mc_email varchar(50),
out result integer
)
begin
-- declare continue handler for sqlwarning begin end;
declare continue handler for sqlexception set result = -1;
-- mdr_pin, master_id, mc_contact, mc_school_nm, mc_addr1, mc_addr2, mc_city, mc_state, mc_zip_4, mc_phone, mc_fax, mc_sch_type, mc_email, mc_vg_code, mc_notes, mc_create_dtm, mc_update_dtm, mc_update_by
insert into mdr_customers (mdr_pin, mc_contact, mc_school_nm, mc_addr1, mc_addr2, mc_city, mc_state, mc_zip_4, mc_phone, mc_fax, mc_sch_type, mc_email, mc_create_dtm)
values (mdr_pin, mc_contact, mc_school_nm, mc_addr1, mc_addr2, mc_city, mc_state, mc_zip_4, mc_phone, mc_fax, mc_sch_type, mc_email, now());
select last_insert_id() into result;
end;
//
-- call `add_customer`(123, 'Ron', 'RP', '9876 xyz', null, 'colo sprgs', 'CO', '98765', '719-555-1212', null, 'h', 'ron@foo.com', @result);
delimiter ;
I was importing an 88.3Mb database script using File->Import into a newly created database.
Did exactly the same thing as before - imported an 88.3Mb script to create the table sin a fresh database. I am investigatin the file to see if there is anything suspicious. It was created using phpMyAdmin on a remote Linux server.
Status changed to "Fixed". Marked as fixed in r2702.
imported a .sql file
I exported and then imported a database and in the fucking end it crashed!
import sql file
imported a 1.6mb sql file
Imported a DB
importing 4 M sql dump file over ssh connection
import mysqldump
Imported a large database (300 MB or so), then imported some procedures (77k). Sequel Pro quit unexpectedly just after the procedures were imported.
Import exported sql
Import an sql file
I was importing an sql file to create a new database (export from phpmyadmin). The process seemed to hang with 7.4 KB of 7.4 KB completed, but the progress bar was at about 75%. I clicked on cancel and shortly thereafter the app closed.
importing some trigger definitions
importing database dump
imported a sql script
Imported a 7 meg dump
Imported and SQL file (phpMyAdmin export output)
Imported a query
imported sql dump
importing sql dump
installing some mysql-functions
importing sql dump
importing sql dump to localhost from another server
data import crashed sequel pro
import mysql dump
I was importing a mysqldump file
Attempted to open a manually made script.
import large sql database table
import
imported a big database dump
importing DB
pb occurred while importing a dump containing procedures
thx
thx
import sql dump
was importing a 405MB sql file
importing SQL data from another DB
importing sql dump
Imported database schema + data into newly created db
import a sql dump
Imported triggers to remote SQL
Imported an SQL file from my local machine to an SQL DB connected via SSH.
try to import sql file
Was importing stored procedures.
Imported a 33 MB database dump
Imported a SQL dump
i tried to run a SQL dump from PostgreSQL on a MySQL database
Developer