Problem Note 60564: Running the METALIB procedure results in a segmentation violation and duplicate index objects
When you use the METALIB procedure to update metadata for a database table that has indexes, you might get a Segmentation Violation or an array out of bound error. Also, duplicate index objects are created in the metadata.
When this problem occurs, you see messages similar to the following in the SAS log:
ERROR: An exception has been encountered.
Please contact technical support and provide them with the following traceback information:
The SAS task name is [METALIB ]
Segmentation Violation
Traceback of the Exception:
/opt/sas/sas_94/SASFoundation/9.4/sasexe/sas() [0x525d5e]
/opt/sas/sas_94/SASFoundation/9.4/sasexe/sas() [0x41ebee]
/opt/sas/sas_94/SASFoundation/9.4/sasexe/tkmk.so(bkt_signal_handler+0x144) [0x7f7a83ed3514]
/lib64/libpthread.so.0() [0x3b80e0f7e0]
/opt/sas/sas_94/SASFoundation/9.4/sasexe/sasmetas(addndx+0x224) [0x7f7a3b355584]
/opt/sas/sas_94/SASFoundation/9.4/sasexe/sasmetas(cmpindices+0x2b2) [0x7f7a3b354d42]
/opt/sas/sas_94/SASFoundation/9.4/sasexe/sasmetas(updmeta+0x211d) [0x7f7a3b33c6bd]
/opt/sas/sas_94/SASFoundation/9.4/sasexe/sasmetas(refmeta+0x1489) [0x7f7a3b338fd9]
/opt/sas/sas_94/SASFoundation/9.4/sasexe/sasmetas(sasmetas+0x209a) [0x7f7a3b32d32a]
/opt/sas/sas_94/SASFoundation/9.4/sasexe/sas(vvtentr+0x101) [0x41e801]
/lib64/libpthread.so.0() [0x3b80e07aa1]
/lib64/libc.so.6(clone+0x6d) [0x3b80ae893d]
When you encounter this problem, jobs requiring table metadata might fail, and you might see unpredictable results in the table metadata.
The problem occurs when the index columns are not returned in a list ordered by index name by the database management system (DBMS) query. PROC METALIB builds an incorrect list for the data source indexes.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | Base SAS | Windows 7 Enterprise x64 | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 |
Windows 7 Professional x64 | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 |
64-bit Enabled AIX | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 |
Microsoft Windows Server 2012 Std | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 |
Microsoft Windows Server 2012 R2 Std | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 |
Microsoft Windows Server 2012 R2 Datacenter | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 |
Microsoft Windows Server 2012 Datacenter | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 |
Microsoft Windows Server 2008 for x64 | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 |
Microsoft Windows Server 2008 R2 | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 |
Microsoft Windows 8.1 Pro x64 | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 |
Microsoft® Windows® for x64 | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 |
z/OS 64-bit | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 |
64-bit Enabled Solaris | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 |
Microsoft Windows 8 Pro x64 | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 |
Microsoft Windows 8 Enterprise x64 | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 |
Microsoft Windows 10 | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 |
Solaris for x64 | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 |
HP-UX IPF | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 |
Linux for x64 | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 |
z/OS | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 |
Microsoft Windows 8.1 Enterprise 32-bit | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 |
Microsoft Windows 8.1 Enterprise x64 | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 |
Microsoft Windows 8.1 Pro 32-bit | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | medium |
Date Modified: | 2017-06-02 14:37:39 |
Date Created: | 2017-06-02 09:11:39 |