Hot answers tagged

31

No. This hard-coded restriction exists for good reasons related to possible excessive query plan compilation time. You can workaround it by listing the VALUES clauses in a CTE, then INSERTing from the CTE, but I do not recommend it. Break the INSERT statement up into VALUES clauses of <= 1,000 lines each as a workaround, or use an alternative data loading ...


30

I hope you are using LOAD DATA INFILE. Try to use LOAD DATA LOCAL INFILE instead of LOAD DATA INFILE. Other issue might be this, please visit the following links : MySQL LOAD DATA. When you login in MySQL do like below, abdul@xmpp3:~/Desktop/Jiva$ mysql -uroot -p --local-infile Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. ...


30

Simply run mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql -p $ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql -p Enter password: Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it. Warning: Unable to load ...


23

You can do this with a function that runs in the security context of its owner. Function that refreshes the view (create it with the user that owns the MV/table): CREATE OR REPLACE FUNCTION refresh_mvw1() RETURNS void SECURITY DEFINER AS $$ BEGIN REFRESH MATERIALIZED VIEW mvw1 with data; RETURN; END; $$ LANGUAGE plpgsql; Grant execute on the function to ...


22

There are 3 different items in this question: Incomplete startup packet occuring at server start is inconsequential, you may ignore it. Read Incomplete startup packet help needed (in pgsql-general mailing-list) for more. syntax error at or near "exit" at character 1 means that a client issued exit as if it was an SQL statement. The could not exec error when ...


20

I have been banging my head against this error today on OSX Yosemite with MySQL 5.7 recently updated with Homebrew. Following suggestions on StackOverflow and elsewhere, I hunted around after my.cnf files all of which specified bind-address=0.0.0.0. I even removed and reinstalled MySQL following these instructions and then reinstalled using brew install ...


19

If the Windows user account was added to an Active Directory (AD) group in the meantime, and that AD group had permission to run the procedure, then that could create this scenario where a user gained access to a procedure with no changes within SQL Server. Also get the network admin to check if the user logged off and on again. Group membership only gets ...


18

There are 3 methods that MySQL can use to write to the binary logs: STATEMENT This means that every SQL statement on the master is recorded in the log, and executed on the slave. This can cause problems if the SQL statement contains statements such as "NOW()", "RAND()" and anything non-deterministic. This also requires support from the ...


18

'Cannot generate SSPI context' is a generic error. It can be caused by many issues, like an outaded password, clock drift, Active Directory access permissions, failure to register an SPN and so on and so forth. There is no solution to this problem. The only 'solution' is to investigate the cause, as per KB811889 and/or Troubleshooting Kerberos Errors. ...


18

Every time I reboot windows, for some databases comes out this error. (OS Error 21 - Device not ready) This is due to a disk being offline or not being online either at the time SQL Server started, or had transitioned states after SQL Server has been online. 3.If I restart SQL Server the errors disappears Yes, because the databases have been remounted ...


16

Following can be reason for this error The account which user selected on Server Configuration page window ( during installation) is somehow not able to bring SQL Server database engine services online. Either is lacks privilege or it is corrupted. During installation of database engine services SQL Server tries to bring online database services as a ...


16

Msg 8631, Level 17, State 1, Line xxx Internal error: Server stack limit has been reached. Please look for potentially deep nesting in your query, and try to simplify it. This error occurs with long SET or SELECT variable assignment concatenation lists due to the way SQL Server parses and binds this type of statement - as a nested list of two-input ...


15

This ended up as a case of not being careful when working as root. I had been researching if SQLCLR on Linux would have access to the app.Config file like it does in Windows (sadly, it does not: SQL Server 2017 on Linux ignores app config file if it exists, or sometimes locks-up if it doesn't (SQLCLR) ) and under certain circumstances SQL Server would ...


14

Check the folowing First check if another instance is runnig in the same machine ps ax | grep mysql Then, check if your file my.cnf (probably in /etc/mysql/ folder) is correctly configured with [mysqld] datadir = /var/lib/mysql/ socket = /var/lib/mysql/mysql.sock Next, you have changed the default data directory, did you gave the right permissions to ...


14

Another possible root cause would be a misunderstanding of how a stored procedure definition is terminated. Take this for example: CREATE OR ALTER PROCEDURE dbo.MyTestProc AS BEGIN SELECT result = 1; END GRANT EXECUTE ON dbo.MyTestProc TO [SomeUser]; The intention here is to define the procedure and then grant permissions to it. However, the first time ...


13

You can use the following syntax: insert into tableName (column1) select '1' union all select '2' union all ... select '1000' union all select '1001' -- Last line should not contain union all and so on. There's no restriction on the number of inserted rows.


13

According to Infinite recompile message in the errorlog on the SQL Programmability & API Development Team Blog, this message is triggered when a statement in a batch recompiles 100 times in a row. This message does not necessarily mean there is a problem; it exists to help troubleshoot statements that might legitimately be recompiling that often (for ...


13

I'd guess the problem is your SQL Server login does not have it's "default database" properly set. This will show you what your "default database" is set to: SELECT sp.name , sp.default_database_name FROM sys.server_principals sp WHERE sp.name = SUSER_SNAME(); You can either change the default database of your login, or you can specify the database in ...


13

It looks like this table was defined with dynamic data masking, and the user that the application uses to access the database doesn't have permission to view masked data (which is good!). This is why the behavior differs between the application and SSMS: I expect you're using a higher-privileged user when running the query from SSMS Here's a demo: CREATE ...


12

Maybe this information is useful. https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-23.html Note This release includes a change to the innodb_index_stats and innodb_table_stats system tables. When upgrading to this release, be sure to run mysql_upgrade in order to include these changes.


11

Perhaps the user had an invalid Kerberos ticket (for example expired), which caused the two "access denied" errors. At some point in time after that the user's workstation contacted a DC and renewed the ticket, allowing the user to execute the procedure the third time.


10

Retrieve column from a table with multiple rows in the else part select case when foo = "bar" then 1 else (select table_name from information_schema.tables) end; As an example, let's use @foo instead of foo mysql> select case when @foo = "bar" then 1 else (select table_name from information_schema.tables) end; ERROR 1242 (21000): Subquery returns more ...


10

The rules that SQL Server uses to derive the type of literals are complex, with some odd behaviours that are maintained these days for backward compatibility. For example, the derived type may depend on whether simple parameterization is applied. There are other (undocumented) considerations as well. With those caveats out of the way, the situation you face ...


10

I think I've found the cause. Most likely the problem is due to "Fast startup" power options. It'a a Windows technique to reduce the boot time; Fast Startup combines elements of a cold shutdown and the hibernate feature. Here you can find another article about pros and cons I have disabled it and the problem seems to be resolved.


9

Your problem has to do with mysql.user and the way you upgraded to MySQL 5.6 If you look my answer to Cannot GRANT privileges as root, I show you the description of mysql.user from MySQL 4.1 to MySQL 5.6. The column plugin is column #41 in mysql.user in MySQL 5.5/5.6 mysql> SELECT column_name,ordinal_position FROM information_schema.columns -> ...


9

There's nothing to fix, really. The message refers to this computed column in the Sales.SalesOrderHeader table: [SalesOrderNumber] AS (isnull(N'SO'+CONVERT([nvarchar](23),[SalesOrderID]),N'*** ERROR ***')), The warning is informational in this case, to be sure you're aware in case it was a problem, as discussed in this Q&A: Type conversion in ...


8

Running locate my.cnf found the file /usr/local/etc/my.cnf Edit that file and set bind-address = 0.0.0.0 Restart mysql: brew services restart mysql


8

I had the same error, trying to debug locally some application that connects to remote DBs. When using php < 5.3, everything worked. When using php 5.3 or greater, error shows up. After hours spent reading and tweaking, i realized this only occurred when connecting as a certain user. All databases i use have new password length (41). I changed the ...


8

The error message is quite clear. The table krneki_2 does not have a column named id_naslov. Unless there is some corruption in system tables or a bug, there is no question about that. So we have to eliminate several possibilities why this appears: There are mismatches between the CREATE TABLE statements and the UPDATE: CREATE TABLE ` krneki_1` ... ...


8

You may just ask it to stop on the first error: $ psql -v ON_ERROR_STOP=on --single-transaction ...


Only top voted, non community-wiki answers of a minimum length are eligible