Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4542

ReadThreadFactory::CreateReadThread: read() error InetStreamSocket::readToMagic: Remote is closed

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 5.5.1
    • Fix Version/s: 22.08
    • Component/s: Storage Manager
    • Labels:
      None
    • Environment:
      RHEL 7, Virtualized On Prem

      Description

      Customer often hit the following errors during DDL. This system is using S3 storage compatible object storage.

      Feb 17 08:00:58 x01tfcdb2a writeengine[17168]: 58.397392 |0|0|0| E 19 CAL0001: ReadThreadFactory::CreateReadThread: read() error InetStreamSocket::readToMagic: Remote is closed
      Feb 17 10:09:36 x01tfcdb2a ExeMgr[17145]: 36.976327 |2147483676|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='ofadev_db' and tablename='cs_test6' --columnRIDs/FE; ||
      Feb 17 10:09:37 x01tfcdb2a ExeMgr[17145]: 37.046950 |2147483676|0|0| D 16 CAL0042: End SQL statement
      Feb 17 10:09:37 x01tfcdb2a ExeMgr[17145]: 37.073842 |28|0|0| D 16 CAL0041: Start SQL statement: select * from cs_test6; |ofadev_db|
      Feb 17 10:09:37 x01tfcdb2a ExeMgr[17145]: 37.087941 |28|0|0| D 16 CAL0042: End SQL statement
      Feb 17 10:22:13 x01tfcdb2a IDBFile[13591]: 13.462810 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so
      Feb 17 10:22:36 x01tfcdb2a StorageManager[16913]: SessionManager Caught Signal 15
      Feb 17 10:22:36 x01tfcdb2a StorageManager[16913]: Shutdown StorageManager...
      Feb 17 10:22:36 x01tfcdb2a StorageManager[16913]: Ownership: releasing ownership of data1
      Feb 17 10:22:36 x01tfcdb2a StorageManager[16913]: StorageManager Shutdown Complete.
      ....
      Feb 18 07:32:10 x01tfcdb2a writeengine[15283]: 10.768606 |0|0|0| E 19 CAL0001: ReadThreadFactory::CreateReadThread: read() error InetStreamSocket::readToMagic: Remote is closed
      Feb 18 09:32:57 x01tfcdb2a ExeMgr[15258]: 57.920154 |2147483692|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='ofadev_db' and tablename='cs_test8' --columnRIDs/FE; ||
      Feb 18 09:32:57 x01tfcdb2a ExeMgr[15258]: 57.941173 |2147483692|0|0| D 16 CAL0042: End SQL statement
      Feb 18 09:32:57 x01tfcdb2a ExeMgr[15258]: 57.956631 |44|0|0| D 16 CAL0041: Start SQL statement: select * from cs_test8; |ofadev_db|
      Feb 18 09:32:57 x01tfcdb2a ExeMgr[15258]: 57.962278 |44|0|0| D 16 CAL0042: End SQL statement
      Feb 18 09:33:43 x01tfcdb2a IDBFile[18424]: 43.610045 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so
      Feb 18 09:34:07 x01tfcdb2a StorageManager[14788]: SessionManager Caught Signal 15
      Feb 18 09:34:07 x01tfcdb2a StorageManager[14788]: Shutdown StorageManager...
      Feb 18 09:34:07 x01tfcdb2a StorageManager[14788]: Ownership: releasing ownership of data1
      Feb 18 09:34:07 x01tfcdb2a StorageManager[14788]: StorageManager Shutdown Complete.
      Feb 18 09:35:49 x01tfcdb2a StorageManager[19815]: Using the config file found at /etc/columnstore/storagemanager.cnf
      Feb 18 09:35:50 x01tfcdb2a StorageManager[19815]: S3Storage: S3 connectivity & permissions are OK
      

      User can make this work again after stopping/starting the cluster, but it seems it is temporary workaround.

      More details is the support ticket.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            allen.lee@mariadb.com Allen Lee
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.