I am getting a table is full error but a show table status on the table specified in
the error, which I assume is a temporary table, comes back as the empty set.
I did the same for the two tables being merged and they are way under the limit as far
as pointer size and table size (both having avg. size rows of under 100 bytes - one
having 700 rows, the other having 700,000 rows).
I am guessing it is my union query... I want to union the two tables but leave off
one of the fields (because they will be unique in the two tables and I do not want the
union to key off that)... my syntax is probably illegal or something...
Here is the error...
C:\Documents and Settings\mjessop\My Documents\Python Development\Catalog>build_
catalog.py
Traceback (most recent call last):
File "C:\Documents and Settings\mjessop\My Documents\Python Development\Catalo
g\catalog_gui.py", line 294, in on_run_step_five
self.run_step_five()
File "C:\Documents and Settings\mjessop\My Documents\Python Development\Catalo
g\catalog_gui.py", line 266, in run_step_five
self.catalog_process.merge_works()
File "C:\Documents and Settings\mjessop\My Documents\Python Development\Catalo
g\catalog_model.py", line 542, in merge_works
status = cur.execute(sql)
File "C:\Python22\Lib\site-packages\MySQLdb\cursors.py", line 61, in execute
r = self._query(query)
File "C:\Python22\Lib\site-packages\MySQLdb\cursors.py", line 168, in _query
rowcount = self._BaseCursor__do_query(q)
File "C:\Python22\Lib\site-packages\MySQLdb\cursors.py", line 112, in __do_que
ry
db.query(q)
_mysql_exceptions.OperationalError: (1114, "The table '#sql360_1e_0' is full")
Here is the sql...
sql = "insert into merged_works " +
"(wrk_inst, sinker, trs_inst, aas_inst, title, pub_name) " + \
"select w.wrk_inst, w.sinker, w.trs_inst, w.aas_inst, w.title, w.pub_name " + \
"from works w union all " + \
"select wk.wrk_inst, wk.sinker, wk.trs_inst, wk.aas_inst, wk.title, wk.pub_name " + \
"from worksets wk left join works w2 " + \
"on wk.wrk_inst = w2.wrk_inst " + \
"where w2.wrk_inst is null " + \
"order by sinker asc, title asc"
Thank you.
+++-------------+++--------------+++
+ Michael S. Jessop +
| Senior Web Developer |
+ Copyright Clearance Center, Inc. +
+++-------------+++--------------+++
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
