Error: insufficient disk space
Posted: Wed Jul 18, 2018 12:24 pm
I am using PATSTAT 2018 spring version.
I am running the following query:
SELECT a1.appln_id, a1.appln_auth + a1.appln_nr + a1.appln_kind AS Application_Number, a1.appln_filing_date, a1.granted, appln_title, appln_abstract, pp.publn_date, person_name, person_address, person_ctry_code, ipc_class_symbol, LEFT(ipc_class_symbol, 3), cpc_class_symbol, ipcn.nace2_code, an.nace2_code, nace2_descr, pp2.publn_auth + pp2.publn_nr + pp2.publn_kind AS Cited_Publications, a2.appln_auth + a2.appln_nr + a2.appln_kind AS Cited_Applications FROM tls201_appln a1
LEFT JOIN tls202_appln_title apt ON a1.appln_id = apt.appln_id
LEFT JOIN tls203_appln_abstr aa ON a1.appln_id = aa.appln_id
LEFT JOIN tls211_pat_publn pp ON a1.appln_id = pp.appln_id
LEFT JOIN tls207_pers_appln pa ON a1.appln_id = pa.appln_id
LEFT JOIN tls206_person p ON pa.person_id = p.person_id
LEFT JOIN tls209_appln_ipc ai ON a1.appln_id = ai.appln_id
LEFT JOIN tls224_appln_cpc ac ON a1.appln_id = ac.appln_id
LEFT JOIN tls229_appln_nace2 an ON a1.appln_id = an.appln_id
LEFT JOIN tls902_ipc_nace2 ipcn ON an.nace2_code = ipcn.nace2_code
LEFT JOIN tls212_citation c ON pp.pat_publn_id = c.pat_publn_id
LEFT JOIN tls211_pat_publn pp2 ON c.cited_pat_publn_id = pp2.pat_publn_id
LEFT JOIN tls201_appln a2 ON c.cited_appln_id = a2.appln_id
WHERE a1.granted = 1 AND
(LEFT(ipc_class_symbol, 3) IN ('A01', 'A23', 'A47', 'A61', 'B01', 'B02', 'B04', 'B05', 'B26', 'B27', 'B29', 'B31', 'B81', 'B82', 'C02', 'C05', 'C07', 'CO8', 'C09', 'C10', 'C11', 'C12', 'C13', 'C14', 'E03', 'E04', 'G02', 'G03', 'G06', 'G08', 'G16', 'H12') OR LEFT(ipc_class_symbol, 1) IN ('D'))
AND ((appln_title LIKE '%bio%') OR (appln_abstract LIKE '%bio%'))
After approximate 2 hours of running time I am getting following error:
Error Code: 1101, SQL State: S00010] Could not allocate a new page for database 'TEMPDB' because of insufficient disk space in filegroup 'DEFAULT'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Is it because of lots of Joins and text search I am using in my query or any other reason? Thanks in advance.
I am running the following query:
SELECT a1.appln_id, a1.appln_auth + a1.appln_nr + a1.appln_kind AS Application_Number, a1.appln_filing_date, a1.granted, appln_title, appln_abstract, pp.publn_date, person_name, person_address, person_ctry_code, ipc_class_symbol, LEFT(ipc_class_symbol, 3), cpc_class_symbol, ipcn.nace2_code, an.nace2_code, nace2_descr, pp2.publn_auth + pp2.publn_nr + pp2.publn_kind AS Cited_Publications, a2.appln_auth + a2.appln_nr + a2.appln_kind AS Cited_Applications FROM tls201_appln a1
LEFT JOIN tls202_appln_title apt ON a1.appln_id = apt.appln_id
LEFT JOIN tls203_appln_abstr aa ON a1.appln_id = aa.appln_id
LEFT JOIN tls211_pat_publn pp ON a1.appln_id = pp.appln_id
LEFT JOIN tls207_pers_appln pa ON a1.appln_id = pa.appln_id
LEFT JOIN tls206_person p ON pa.person_id = p.person_id
LEFT JOIN tls209_appln_ipc ai ON a1.appln_id = ai.appln_id
LEFT JOIN tls224_appln_cpc ac ON a1.appln_id = ac.appln_id
LEFT JOIN tls229_appln_nace2 an ON a1.appln_id = an.appln_id
LEFT JOIN tls902_ipc_nace2 ipcn ON an.nace2_code = ipcn.nace2_code
LEFT JOIN tls212_citation c ON pp.pat_publn_id = c.pat_publn_id
LEFT JOIN tls211_pat_publn pp2 ON c.cited_pat_publn_id = pp2.pat_publn_id
LEFT JOIN tls201_appln a2 ON c.cited_appln_id = a2.appln_id
WHERE a1.granted = 1 AND
(LEFT(ipc_class_symbol, 3) IN ('A01', 'A23', 'A47', 'A61', 'B01', 'B02', 'B04', 'B05', 'B26', 'B27', 'B29', 'B31', 'B81', 'B82', 'C02', 'C05', 'C07', 'CO8', 'C09', 'C10', 'C11', 'C12', 'C13', 'C14', 'E03', 'E04', 'G02', 'G03', 'G06', 'G08', 'G16', 'H12') OR LEFT(ipc_class_symbol, 1) IN ('D'))
AND ((appln_title LIKE '%bio%') OR (appln_abstract LIKE '%bio%'))
After approximate 2 hours of running time I am getting following error:
Error Code: 1101, SQL State: S00010] Could not allocate a new page for database 'TEMPDB' because of insufficient disk space in filegroup 'DEFAULT'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Is it because of lots of Joins and text search I am using in my query or any other reason? Thanks in advance.