microsoft / mssql-support Goto Github PK

workspace to share scripts and utilities used by mssql support team

License: MIT License

TSQL 19.45% Batchfile 0.69% PowerShell 6.15% Jupyter Notebook 73.71%

mssql-support's Introduction

Contributing

This project welcomes contributions and suggestions. Most contributions require you to agree to a Contributor License Agreement (CLA) declaring that you have the right to, and actually do, grant us the rights to use your contribution. For details, visit https://cla.microsoft.com.

When you submit a pull request, a CLA-bot will automatically determine whether you need to provide a CLA and decorate the PR appropriately (e.g., label, comment). Simply follow the instructions provided by the bot. You will only need to do this once across all repos using our CLA.

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact [email protected] with any additional questions or comments.

mssql-support's People

Contributors

Stargazers

Watchers

Forkers

bhaskers-blu-org2 taffywrinkle claudiusgonzo rtanikella15 saitorhan ramakoni1 tommyau20 biswaranjansahu19 illbatting jnixmsft haiyingyu test-mass-forker-org-1 pijocoder felipesantw

mssql-support's Issues

Error while setting up mssql Server on Linux Ubuntu 20.04

I recently tried to install the Microsoft SQL Server on my Server and got the following error:

Enter the SQL Server system administrator password:
Confirm the SQL Server system administrator password:
Configuring SQL Server...

This program has encountered a fatal error and cannot continue running at Mon Jan 16 19:16:18 2023
The following diagnostic information is available:

         Reason: 0x00000001
         Signal: SIGABRT - Aborted (6)
          Stack:
                 IP               Function
                 ---------------- --------------------------------------
                 000055d51aa8b5b2 <unknown>
                 000055d51aa8afd0 <unknown>
                 000055d51aa8a66f <unknown>
                 00007fb84f3d7090 killpg+0x40
                 00007fb84f3d700b gsignal+0xcb
                 00007fb84f3b6859 abort+0x12b
                 000055d51aa30e9a <unknown>
                 000055d51aabbeba <unknown>
        Process: 10388 - sqlservr
         Thread: 10490 (application thread 0x1b4)
    Instance Id: a1122980-ea43-4a2b-b9ee-c91c8822cc72
       Crash Id: c824e192-6acf-4d96-9c69-32badae80e59
    Build stamp: d81e9b6de06534e649bd57dd609aa3050f5e380f361b7f8a80a80eeb71e7422c
   Distribution: Ubuntu 20.04.5 LTS
     Processors: 4
   Total Memory: 8589934592 bytes
      Timestamp: Mon Jan 16 19:16:18 2023
     Last errno: 2
Last errno text: No such file or directory
Capturing a dump of 10388
Successfully captured dump: /var/opt/mssql/log/core.sqlservr.1_16_2023_19_16_18.10388
Executing: /opt/mssql/bin/handle-crash.sh with parameters
     handle-crash.sh
     /opt/mssql/bin/sqlservr
     10388
     /opt/mssql/bin
     /var/opt/mssql/log/

     a1122980-ea43-4a2b-b9ee-c91c8822cc72
     c824e192-6acf-4d96-9c69-32badae80e59

     /var/opt/mssql/log/core.sqlservr.1_16_2023_19_16_18.10388

Ubuntu 20.04.5 LTS
Capturing core dump and information to /var/opt/mssql/log...
/usr/bin/find: ‘/proc/10388/map_files’: Operation not permitted
/usr/bin/find: ‘/proc/10388/map_files’: Operation not permitted
/usr/bin/find: ‘/proc/10388/map_files’: Operation not permitted
/usr/bin/find: ‘/proc/10388/map_files’: Operation not permitted
Hint: You are currently not seeing messages from other users and the system.
      Users in groups 'adm', 'systemd-journal' can see all messages.
      Pass -q to turn off this notice.
No journal files were opened due to insufficient permissions.
Hint: You are currently not seeing messages from other users and the system.
      Users in groups 'adm', 'systemd-journal' can see all messages.
      Pass -q to turn off this notice.
No journal files were opened due to insufficient permissions.
/usr/bin/tail: cannot open '/var/log/syslog' for reading: Permission denied
Mon Jan 16 19:16:19 CET 2023 Capturing program information
Dump already generated: /var/opt/mssql/log/core.sqlservr.1_16_2023_19_16_18.10388, moving to /var/opt/mssql/log/core.sqlservr.10388.temp/core.sqlservr.10388.gdmp
Moving logs to /var/opt/mssql/log/core.sqlservr.10388.temp/log/paldumper-debug.log
Mon Jan 16 19:16:19 CET 2023 Capturing program binaries
Mon Jan 16 19:16:20 CET 2023 Compressing the dump files
Core dump and information are being compressed in the background. When
complete, they can be found in the following location:
  /var/opt/mssql/log/core.sqlservr.01_16_2023_19_16_19.10388.tbz2
Initial setup of Microsoft SQL Server failed. Please consult the ERRORLOG
in /var/opt/mssql/log for more information.

I would be glad if somebody can help me solving this error. I chose The developer Edition, but get the same error message, when trying different licenses.

If you need mor information hit me up!

typo in mssql error string?

I receive this error message using the wrong clause "FETCH NEXT 0 ROWS ONLY". I thought it was a wrapper library message, but I get it from mssql-cli as well

The number of rows provided for a FETCH clause must be greater then zero.

Shouldn't it be:
The number of rows provided for a FETCH clause must be greater thAn zero.

linux mssql-server 15.0.4073-23.4

This repo is missing important files

There are important files that Microsoft projects should all have that are not present in this repository. A pull request has been opened to add the missing file(s). When the pr is merged this issue will be closed automatically.

Microsoft teams can learn more about this effort and share feedback within the open source guidance available internally.

Merge this pull request

SQL_Express_Backups.sql typo in variable name

I just tried using your SQL_Express_Backups.sql file to do Backups as described https://docs.microsoft.com/en-us/troubleshoot/sql/admin/schedule-automate-backup-database. Unfortunately, creating the SP doesn't work because in line 25, there is a typo and DatabaseName should actually be databaseName.

I would have created a PR, but the CLA process seems a bit much for a minor thing like this.

Demetrius's S22+

SQL_Express_Backups.sql - declaration of @backupLocation and @BackupFile do not match

mssql-support/sample-scripts/backup_restore/SQL_Express_Backups.sql

Line 22 in 5461722

@backupLocation nvarchar(200)

mssql-support/sample-scripts/backup_restore/SQL_Express_Backups.sql

Line 56 in 5461722

DECLARE @BackupFile varchar(100)

mssql-support/sample-scripts/backup_restore/SQL_Express_Backups.sql

Lines 70 to 75 in 5461722

 IF @backupType = 'F' 

 SET @BackupFile = @backupLocation+REPLACE(REPLACE(@DBNAME, '[',''),']','')+ '_FULL_'+ @dateTime+ '.BAK' 

 ELSE IF @backupType = 'D' 

 SET @BackupFile = @backupLocation+REPLACE(REPLACE(@DBNAME, '[',''),']','')+ '_DIFF_'+ @dateTime+ '.BAK' 

 ELSE IF @backupType = 'L' 

 SET @BackupFile = @backupLocation+REPLACE(REPLACE(@DBNAME, '[',''),']','')+ '_LOG_'+ @dateTime+ '.TRN'

With long paths, @BackUpFile is truncated after 100 characters.

microsoft / mssql-support Goto Github PK

mssql-support's Introduction

Contributing

mssql-support's People

Contributors

Stargazers

Watchers

Forkers

mssql-support's Issues

Error while setting up mssql Server on Linux Ubuntu 20.04

typo in mssql error string?

This repo is missing important files

SQL_Express_Backups.sql typo in variable name

Demetrius's S22+

SQL_Express_Backups.sql - declaration of @backupLocation and @BackupFile do not match

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent

	IF @backupType = 'F'
	SET @BackupFile = @backupLocation+REPLACE(REPLACE(@DBNAME, '[',''),']','')+ '_FULL_'+ @dateTime+ '.BAK'
	ELSE IF @backupType = 'D'
	SET @BackupFile = @backupLocation+REPLACE(REPLACE(@DBNAME, '[',''),']','')+ '_DIFF_'+ @dateTime+ '.BAK'
	ELSE IF @backupType = 'L'
	SET @BackupFile = @backupLocation+REPLACE(REPLACE(@DBNAME, '[',''),']','')+ '_LOG_'+ @dateTime+ '.TRN'