DevHeads.net

Database

Watch 2012 Northern Trust Open Live Online TV Stream golf

Watch 2012 Northern Trust Open Live Online TV Stream golf
2012 0Northern Trust Open
Match Scheduled 16-19th February 2012
Pacific Palisades, California
Purse: $6,600,000
PGA Tour
when will start 2012 Northern Trust Open Live streaming online tv golf match.It will be held on 16th February 2012 and end 19th February 2012.And how can watch 2012 Northern Trust Open online streaming live match.In the world 2012 Northern Trust Open golf streaming PGA Tour are famous to all golf faners.
2012 Northern Trust Open Live Online

Watch Porto vs Manchester City Live Stream Free Soccer Online

Watch Porto vs Manchester City Live Stream Free Soccer Online
Porto vs Manchester City
Match Scheduled 16-02-2012 from 3:05pm (US/Eastern)
Location Estádio Do Dragão (Porto)
UEFA Europa League
Porto vs Manchester City team are known to all soccer faners in the world.UEFA Europa League live streaming soccer match Porto vs Manchester City match is very exciting.
Watch Porto vs Manchester City Live

<a href="http://www.live-stream-free.com/watch-porto-vs-manchester-city-live-stream-free-soccer-online/" title="http://www.live-stream-free.com/watch-porto-vs-manchester-city-live-stream-free-soccer-online/">http://www.live-stream-free.com/watch-porto-vs-manchester-city-live-stre...</a>

^^**wAtcH^^**Aston Villa vs Manchester City Live Stream Soccer Online February 12, 2012

wAtcH Barclays Premier League between Aston Villa vs Manchester City live stream
Are you looking for Aston Villa vs Manchester City Free live streaming link? Then you have come to the correct place. You can watch a live online stream of Aston Villa vs Manchester City right here. The is no need to look anywhere else. The links for the event appear above.

<a href="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html" title="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html">http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs...</a>

<a href="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html" title="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html">http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs...</a>

Rule module implementation Bug problem

Hi Dear,
I have a doubt regarding following procedure , it work fine in Article but not
in "Page" creation (I mean the link is not proper), please help me with a
solution , pls follow the steps and try to create an article and basic page
and click the status link , you got my problem .

To display an 'Add More [Content_type]' link after user saves new content, do the following:

1. Go to admin/config/workflow/rules
2. Click Add New Rule
3. At admin/config/workflow/rules/reaction/add, give your new Rule a name, something like

'Add more content link'

Deadlock when executing multiple select statements from multiple threads

Hello,

We are having a deadlock issue when executing multiple select statements from multiple threads, the issue happens with driver version (9.6.4.0) or newer, doesn't happen on 9.6.3.1 .
I've attached a simple project that triggers the deadlock, tested with visual studio 2017, release x64 build, PostgreSQL 10.3, usually happens after few runs.[please note that the proper database connection string and the table names need to be provided in the code for it to work].
I've also included the stack trace of the two threads in deadlock.

Regards,
Ayman

Re: [ANNOUNCE] psqlODBC 09.06.0500 Released

Buongiorno,

Vedi allegato e di confermare.

Grazie e a presto,
Sebastiano.

 

Sebastiano SchiaviDirettore Generaleseba. ... at sixs dot it SIxS - Soluzioni Informatiche per il SocialeVia Sant'Antonino 41 - Vaiano Cremasco (CR)Tel.0373 386177 – Fax 0373 380216Cell. 3939147485www.sixs.it Informativa privacy: Le informazioni contenute nella presente comunicazione e i relativi allegati possono essere riservati e sono comunque destinati esclusivamente alle persone o alla Società sopraindicati e non sono da considerarsi comunicazioni personali.

MySQL optimization for testing purpose

Hi all,

Looking for some configuration tips to speed execution of our non-regression tests with MySQL.

We do pure functional testing, data persistence is not critical.

Our tests are not using a lot of data, but we create and drop a lot of test tables.

We have concurrency tests (processes locking rows), so this feature matters.

Are there some InnoDB params to enable or disable to speed up our tests?

Some tests behave a bit strange, sometimes one of our test takes 1 min 30 secs, sometimes
it takes only 15 seconds...

How can this happen?

Any log I could enable and provide here?

Thanks in

SSL connection string documentation

Example of pqopt on 3rd screen: sslroot=c:\\root.crt
Example of pappy in connection string:
pqopt={sslroot=c:/root.crt}
Could you please post drove me crazy trying to figure it out.

psqlODBC 10.02.0000 Released

Hi, all.

We are pleased to annouce the release of psqlODBC 10.02.0000.
please see the notes at:
<a href="https://odbc.postgresql.org/docs/release.html" title="https://odbc.postgresql.org/docs/release.html">https://odbc.postgresql.org/docs/release.html</a>

psqlODBC may be downloaded from in source, Windows Installer,
merge module, and basic zip file formats.

New Windows installer installs both 32-bit and 64-bit driver at once
on 64-bit OS.

Mroonga 8.01 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 8.01 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready. It uses Groonga as a storage
and fulltext search engine.

Document:
<a href="http://mroonga.org/docs/" title="http://mroonga.org/docs/">http://mroonga.org/docs/</a>

How to install: Install Guide
<a href="http://mroonga.org/docs/install.html" title="http://mroonga.org/docs/install.html">http://mroonga.org/docs/install.html</a>

How to upgrade: Upgrade Guide
<a href="http://mroonga.org/docs/upgrade.html" title="http://mroonga.org/docs/upgrade.html">http://mroonga.org/docs/upgrade.html</a>

Blog:
<a href="http://mroonga.org/en/blog/2018/03/29/mroonga-8.01.html" title="http://mroonga.org/en/blog/2018/03/29/mroonga-8.01.html">http://mroonga.org/en/blog/2018/03/29/mroonga-8.01.html</a>

Changes:
<a href="http://mroonga.org/docs/news.html#release-8.01" title="http://mroonga.org/docs/news.html#release-8.01">http://mroonga.org/docs/news.html#release-8.01</a>

In this release, Mroonga requires latest Groonga 8.0.1 to fix bugs.

Postgres Foreign Data Wrapper and DB2 LUW

Is there a web page describing how to set up a PG FDW to talk to DB2 LUW ver 10.5 ?

Thanks.

How to get the MySQL Command-Line Tool to display Unicode properly?

Five months ago I posted the query shown below on StackOverflow.  I got
one reply which was not of much help.  So I am trying again, hoping a
more MySQL-centric forum might be able to solve my problem.

Roger House

How to get the MySQL Command-Line Tool to display Unicode properly?

I use a Python program to write text containing Unicode characters to a
MySQL database. As an example, two of the characters are

|u'\u2640' a symbol for Venus or female u'\u2642' a symbol for Mars or male |

I use utf8mb4 for virtually all character sets involved with MySQL.

MySQL Connector/Java 5.1.46 GA has been released

Dear MySQL Users,

MySQL Connector/J 5.1.46, a maintenance release of the production 5.1
branch has been released. Connector/J is the Type-IV pure-Java JDBC
driver for MySQL.

MySQL Connector Java is available in source and binary form from the
Connector/J download pages at
<a href="http://dev.mysql.com/downloads/connector/j/5.1.html" title="http://dev.mysql.com/downloads/connector/j/5.1.html">http://dev.mysql.com/downloads/connector/j/5.1.html</a>
and mirror sites as well as Maven-2 repositories.

MySQL Connector Java (Commercial) is already available for download on the
My Oracle Support (MOS) website.

Compilation fails with XLC in AIX

Hi,

I am compiling PostgreSQL ODBC driver 10.01.0000 in AIX using XLC compiler.
Compilation fails with the following error.

ld: 0711-317 ERROR: Undefined symbol: .getExeName
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more
information.
Makefile:573: recipe for target 'psqlodbcw.la' failed
gmake[1]: *** [psqlodbcw.la] Error 8
gmake[1]: Leaving directory
'/home/root/postgres_source/psqlodbc-10.01.0000'
Makefile:479: recipe for target 'all' failed
gmake: *** [all] Error 2

getExeName is no more there after this commit "Move the implemetation of
GetExeName() from psqlodbc.c(psq

Lost Data Connection

I have been successfully using the following PostgreSQL connection string in multiple Excel 2010 vba applications running on 64 bit Windows 7 systems. I have moved to a Window 10 system and my application will randomly lose its connection to the DSN. It may take 5000 calls one time and then 400 calls the next. I am using a Unicode driver. I wrote a sample program that makes the same call in a loop. The code will randomly fail on Window 10 and run flawlessly on Window 7.

ANN: Upscene releases Database Workbench 5.4.2

Upscene releases Database Workbench 5.4.2

Upscene Productions is proud to announce the availability of
the next version of the popular multi-DBMS development tool:

" Database Workbench 5.4.2 “

This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version of PostgreSQL.

Out of operation records in local data manager far below MaxNoOfConcurrentOperations

Hi,

we run a MySQL-Cluster, currently version 7.4.15, where we get "Out of
operation records in local data manager" at approximately 55000 rows
updated or deleted in one transaction,
even though MaxNoOfConcurrentOperations=300000.

Any ideas, why 300000 operation records are not enough for 55000 rows?

regards,
Hendrik Woltersdorf

FinTech Group AG
Peter-Breuer-Str.

ODBC embedded Postgres

Hello,

We have an embedded Postgres database installed along with Vcenter Vmware
app. We wanted to connect it with ODBC connection, Is it possible? If yes,
what version of ODBC i need to install and are there any changes we will
need to make on Postgres SQL side?

Procedure error handling Best Practice

Long time Oracle PL/SQL coder but new to MySQL.

I have an error handler that looks like this ...

declare continue handler for sqlexception
begin
get diagnostics condition 1 @p3 = returned_sqlstate, @p4 = message_text;
set v_there_was_an_error_while_inserting_a_lead_summary := true;

insert into rit.rit_audit_message(severity,
message,
process_name,

summary_detail_map,
createdby2qmp_user,

Silent MALLOC/REALLOC error

Hello, psqlODBC team.

When we fetch large data via psqlodbc, we sometimes fail to
get all rows completely without any API's error responses;
SQLExecDirect returns SQL_SUCCESS and SQLFetch returns just SQL_NODATA.
But there are QR_REALLOC_error reported in mylog at that time.

I reproduced it by tweaking QR_REALLOC_return_with_error macro
to intentionally fail to allocate memory frequently.

MySQL Connector/C++ 8.0.7-rc has been released

Dear MySQL users,

MySQL Connector/C++ 8.0.7-rc is the release candidate (RC)
of the MySQL Connector/C++ 8.0 series.

Connector/C++ 8.0 can be used to access MySQL implementing Document
Store or in a traditional way, using SQL queries.

DBLink problem between Oracle and PostGreSQL

Dear all,

I'm not sure if it is the correct address to send this king of request,
but we are currently struggling with a problem between Oracle and
PostGreSQL, passing through ODBC, so I take my change.
The situation is the following:
. On Oracle side:
 - Windows Server 2012 R2
 - Oracle 11g r2 (11.2.0.1.0)

. On PostGreSQL:
 - PostgreSQL 9.4.13
 - No details on servers or configuration, we don't have access to this.

. ODBC PostGreSQL Drivers 10.01.00.00

=> The problem is the following:
. We are currently unable to use a DBLink from Oracle to PostGreSQL, via
ODBC.

Re: mysql_upgrade then mysqld. I feel very ID-10-T PEBKAC today

Please don't bother to answer, I did figure it out, I'm sorry, for a bad
question and worse followup. Apparently I'm a spammer as well.

Apparently the error was caused by something else besides plugins in
my configuration. After carefully running --initialize from scratch
and modifying my.ini I was able to get mysqld.exe up and running just
fine on Windows 64 for MySQL 8.0 RC.

mysql_upgrade then mysqld. I feel very ID-10-T PEBKAC today

2018-02-23T14:02:33.962240Z 0 [ERROR] [MY-010735] Can't open the
mysql.plugin table. Please run mysql_upgrade to create it.

How do I run mysql_upgrade if the mysqld server won't start?

Man how stupid am I?

help with downloading postgres server and client

I downloaded downloaded installer from this site (
<a href="https://www.postgresql.org/download/windows/" title="https://www.postgresql.org/download/windows/">https://www.postgresql.org/download/windows/</a>) but this is not what I want
or it came with a whole bunch of other plugging that I don't need. All I
need a server and pgadmin. I also tried to download the binary files but I
have no luck.

could you please point me the right direction?

SQLError SqlState wrong when postgres backend dies

Hi,

The SQLError function is returning the last statement level SqlState value if called after the postgres backend dies.

For exampel, if prior to the death of the postgres backend the last SQL statement that had an error returned an SqlState="23505"(due to a unique index problem) then after the postgres backend dies the next SQL statement will fail and SQLError returns:-

NativeError=26 SqlState="23505" ErrorMsg=Could not send Query(connection dead)

So ErrorMsg is correct but SqlState is not.

I was using psqlodbc-09.05.0400 but repeated my test with 10.01.0000 and got the same result.

Optimize fails due to duplicate rows error but no duplicates found

Good day guys,

I am hoping this mail finds you well.

I am at a bit of a loss here...

We are trying to run optimize against a table in order to reclaim disk space from archived data which has been removed.

However, after running for over an hour , the optimize fails stating there is a duplicate entry in the table.

We have now spent 2 days using various methods but we are unable to find any duplicates in the primary key and also nothing on the unique key fields.

Any idea on why optimize would still be failing ?

Regards

PostgreSQL) How to use Bind Variable with ODBC Driver V10?

Hello. 

I hope my email finds you well. 

I am developing query tool for PostgreSQL using ODBC Driver (recent release ODBC v10).

The product that I am developing uses the SQLDescribeParam() function before the query SQLExec() when using Bind Variable. 

SQLDescribeParam () function normally works on 'psqlodbc_09_06_0500-x86', when using Bind Variable. 

However, in 'psqlodbc_10_00_0000-x86' and later versions, error occurs and Bind Variable cannot be used. 

Normal queries that do not use the SQLDescribeParam () function work fine. 

For your reference, below is the example of the query that

NUMERIC type makes trouble in MS Access

Hi there,

I'm experiencing problems with the ODBC driver on Windows 7 (and 10)
on 32 and 64 bit in Microsoft Access 2003, 2010 and 2016 (32, 64 bit).

My PostgreSQL server runs on Debian (64-bit): 9.6.7-1.pgdg80+1
Tested ODBC drivers: psqlodbc_09_06_0500 & psqlodbc_10_01_0000

Summary of the problem:
The current behavior of the ODBC driver creates an error in Access,
since the incoming values are longer than the field type. This leads
into a truncation warning (with many messageboxes) and no values
are shown at all.

Patch for an encoding bug in the derive_locale_encoding function

Hello!

I've found a bug while I was working with the driver.

Mroonga 8.00 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 8.00 has been released!
This is a major version up! But It keeps backward compatibility.
You can upgrade to 8.0.0 without rebuilding database.

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready.

ANN: Upscene releases Database Workbench 5.4.0

Upscene Productions is proud to announce the availability of
the next version of the popular multi-DBMS development tool:

" Database Workbench 5.4.0 "

This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version of PostgreSQL.

MySQL Connector/Python 8.0.6-rc has been released

Dear MySQL users,

MySQL Connector/Python 8.0.6-rc is the first release candidate version
of the MySQL Connector Python 8.0 series. This series adds support for
the new X DevAPI. The X DevAPI enables application developers to write
code that combines the strengths of the relational and document models
using a modern, NoSQL-like syntax that does not assume previous
experience writing traditional SQL.

To learn more about how to write applications using the X DevAPI, see
<a href="http://dev.mysql.com/doc/x-devapi-userguide/en/" title="http://dev.mysql.com/doc/x-devapi-userguide/en/">http://dev.mysql.com/doc/x-devapi-userguide/en/</a>.

MySQL Cluster 7.6.4-dmr has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance (with optional
    checkpointing to disk)
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master geographic replication

  - 99.999% High Availability with no single point of failure
    and on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http, Memcached
    and JavaScript/Node.js)

MySQL Cluster 7.6.4-dmr, has been released and can be downloaded from

<a href="http://www.mysql.com/dow" title="http://www.mysql.com/dow">http://www.mysql.com/dow</a>

ODBC - Retrieving info messages - RAISE NOTICE

Hi,

When executing a PL/pgsql query using powershell with ODBC (yes, a somehow special setup), it is possible to register to the event "InfoMessage" (with Register-ObjectEvent) to retrieve all messages that are created for example by using "RAISE NOTICE".
While this works fine when using MS SQL and the SqlConnection (all print statements are retrieved), it does not work with Postgres and the OdbcConnection, here, only the last message ("3") is retrieved, when a statement like
DO $$
RAISE NOTICE '1';
RAISE NOTICE '2';
RAISE NOTICE '3';
END$$;
is executed.

Maybe this is a general constraint wh

MySQL Connector/Java 8.0.9-rc has been released

Dear MySQL users,

MySQL Connector/Java 8.0.9-rc is the first Release Candidate
of the 8.0 branch of MySQL Connector/J, providing an insight into
upcoming features. It is suitable for use with MySQL Server versions
5.5, 5.6, 5.7, and 8.0.

MySQL Connector/Net 8.0.10-rc has been released

Dear MySQL users,

MySQL Connector/Net 8.0.10 is the first release candidate of MySQL
Connector/Net to add support for the new X DevAPI. The X DevAPI enables
application developers to write code that combines the strengths of the
relational and document models using a modern, NoSQL-like syntax that
does not assume previous experience writing traditional SQL.

To learn more about how to write applications using the X DevAPI, see
<a href="http://dev.mysql.com/doc/x-devapi-userguide/en/index.html" title="http://dev.mysql.com/doc/x-devapi-userguide/en/index.html">http://dev.mysql.com/doc/x-devapi-userguide/en/index.html</a>.

Mroonga 7.11 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 7.11 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready.

statement timeout with psqlODBC 09.05.300+

Hi,

This ticket is related to
<a href="http://www.postgresql-archive.org/BUG-odbc-statement-timeout-gets-set-to-30000-td5992591.html" title="http://www.postgresql-archive.org/BUG-odbc-statement-timeout-gets-set-to-30000-td5992591.html">http://www.postgresql-archive.org/BUG-odbc-statement-timeout-gets-set-to...</a>

The client using the ODBC Driver is on Windows 7, must be x86 compatible,
and connect to a 9.6 postgresql database.
from 09.05.300+ version of the ODBC driver x86 (tested up to 10.01), queries
which used to work fine with drivers 08.x now throw "ERROR: canceling
statement due to statement timeout;"

It seems that there is now a default setting for statement timeout coming
with 9.5+ versions of the driver (less than 1 mn), and I did not find any
way to change this settin

MySQL Community Server 8.0.4-rc has been released (part 3/3)

[If you just recived an email with 8.0.3-rc in the title, please
ignore that. Sorry for the confusion]

* For builds on 32-bit platforms with Undefined Behavior
Sanitizer enabled, a stack-overrun check could cause a
server exit. (Bug #27224961)

* The server could hang during spatial reference system
(SRS) creation while another session was using that SRS.
(Bug #27220467)

* A lock for the privilege cache was acquired unnecessarily
during privilege-checking operations not involving table
permissions.

MySQL Community Server 8.0.3-rc has been released (part 3/3)

* For builds on 32-bit platforms with Undefined Behavior
Sanitizer enabled, a stack-overrun check could cause a
server exit. (Bug #27224961)

* The server could hang during spatial reference system
(SRS) creation while another session was using that SRS.
(Bug #27220467)

* A lock for the privilege cache was acquired unnecessarily
during privilege-checking operations not involving table
permissions.

MySQL Community Server 8.0.4-rc has been released (part 2/3)

Bugs Fixed

* Important Change: The following changes are made to the
PERIOD_ADD() and PERIOD_DIFF() functions:

+ A period value used with one of these functions may
not be negative.

+ The month part of a period value may not be equal to
0.
A period value used with one of these functions for which
at least one of these conditions is true now causes the
function to fail with an error.

MySQL Community Server 8.0.4-rc has been released (part 1/3)

[Due to size limitations, the announcement is split in 3. This is part 1.]

MySQL Server 8.0.4-rc (Release Candidate) is a new version of the world's
most popular open source database.

MySQL Cluster 7.4.19 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master geographic replication
  - 99.999% High Availability with no single point of failure
    and on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http, Memcached
    and JavaScript/Node.js)

MySQL Cluster 7.4 makes significant advances in performance;
operational efficiency (such as enhanced reporting and faster restarts
and upg

MySQL Cluster 7.4.18 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master geographic replication
  - 99.999% High Availability with no single point of failure
    and on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http, Memcached
    and JavaScript/Node.js)

MySQL Cluster 7.4 makes significant advances in performance;
operational efficiency (such as enhanced reporting and faster restarts
and upg

Java threads waiting on Mysql connections, but Mysql shows no evidence of this

I posted this question on StackOverflow, here's a link to my question:
<a href="https://stackoverflow.com/questions/48388562/java-threads-waiting-" title="https://stackoverflow.com/questions/48388562/java-threads-waiting-">https://stackoverflow.com/questions/48388562/java-threads-waiting-</a>
on-mysql-connections-but-mysql-shows-no-evidence-of-this

In summary, my java code is waiting for a connection indefinitely, but
mysql doesn't seem to show this is the case. I'd appreciate if someone
could answer on the stackoverflow post. Thanks!

Examples of savepoints and transactions

Hi,
I have a system that uses begin and commit transactions. It works like a dream! ;)
Now I want to test it by creating test data. This how ever cannot be rolled back. I think the solution for rolling back test data is to use savepoints and rollback. I think it is hard to find examples of this scenario. Are there some good guides or tutorials out there somewhere? Any suggestions are welcome.

Best regards
Lars Nielsen

MySQL Connector fails on non existing function with NullPointerException

I'm seeing a failure in the MySQL JDBC Connector with some tests of ours.

Can't get my query to return wanted data

Hi
I am running mysql 5.7.20 in ubuntu linux 17.10

I have 2 tables, member and status with contents like

member:
ident, given, surname
1 fred jones
2 john howard
3 henry wales
4 jenny brown

status:
ident year
1 2017
2 2017
3 2017
4 2017
1 2018
3 2018

I want my query to return the name and ident from the member table for all
members that has not got an entry in status with year=2018

I have been working on the following query to achieve this, but it only
returns data when there is no `year` entries for a selected year.

MySQL Cluster 7.3.20 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance (with optional
    checkpointing to disk)
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master geographic replication

  - 99.999% High Availability with no single point of failure
    and on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http, Memcached
    and JavaScript/Node.js)

MySQL Cluster 7.3.20, has been released and can be downloaded from

<a href="http://www.mysql.com/downlo" title="http://www.mysql.com/downlo">http://www.mysql.com/downlo</a>

MySQL Cluster 7.5.9 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance (with optional
    checkpointing to disk)
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master geographic replication

  - 99.999% High Availability with no single point of failure
    and on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http, Memcached
    and JavaScript/Node.js)

MySQL Cluster 7.5.9, has been released and can be downloaded from

  <a href="http://www.mysql.com/down" title="http://www.mysql.com/down">http://www.mysql.com/down</a>

MySQL Community Server 5.6.39 has been released

Dear MySQL users,

MySQL Server 5.6.39, a new version of the popular Open Source
Database Management System, has been released. MySQL 5.6.39 is
recommended for use on production systems.

For an overview of what's new in MySQL 5.6, please see

<a href="http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html" title="http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html">http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html</a>

Starting with 5.6.11, Microsoft Windows packages for MySQL 5.6
are available both as a "full" installer and as a "web" installer.
The full installer is significantly larger and comes bundled with
the latest software releases available.

MySQL Community Server 5.7.21 has been released

Dear MySQL users,

MySQL Server 5.7.21, a new version of the popular Open Source
Database Management System, has been released.

Bug in is_setting_search_path

Hello,

I have found a bug in the is_setting_search_path function (connection.c line 1597).

The search loop is currently:

for (; *q; q++)
{
if (IS_NOT_SPACE(*q))
{
if (strnicmp(q, "search_path", 11) == 0)
return TRUE;
q++;
while (IS_NOT_SPACE(*q))
q++;
}
}

The inner while(IS_NOT_SPACE(*q)) loop will terminate if a null is reached.

In MySQL 8.0, how does one recognize roles?

Hi,

In MySQL 8.0, if you use CREATE ROLE, it seems to create an entry in mysql.users

But how does one distinguish between roles and users?

With regards,

Martijn Tonies
Upscene Productions
<a href="http://www.upscene.com" title="http://www.upscene.com">http://www.upscene.com</a>

Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.

Mroonga 7.10 - Fast fulltext search for all languages on,MySQL

Hi,

Mroonga 7.10 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready.

RE: psqlODBC 10.01.0000 Released -- what about 9.6.6?

Hi,

I can see that the 09.06.0500 driver disappeared from <a href="https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/" title="https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/">https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/</a>
Will it be back? Will there be an update for PostgreSQL 9.6.6?

Q: OPTIMIZE TABLE - internal error 122 during operation

Hello,

We have an NDB cluster and we experience 'mysterious' database-full errors.

Our setup is the following:

- server_mgm: Management Node
- server_1: Data Node 1
- server_2: Data Node 2

(Host names are explanatory.)

config.ini:

[NDBD DEFAULT]
NoOfReplicas=2
MaxNoOfExecutionThreads=4
DataMemory=6G
IndexMemory=1G
LockPagesInMainMemory=1
# tuning
MaxNoOfConcurrentTransactions = 8192
MaxNoOfConcurrentOperations = 65536
MaxNoOfConcurrentScans = 500
# end of tuning

[NDB_MGMD]
NodeId=1
HostName=server_mgm

[NDBD]
NodeId=11
HostName=server_1
DataDir=/var/lib/mysql-cluster
StopOnErro

psqlODBC 10.01.0000 Released

Hi, all.

We are pleased to annouce the release of psqlODBC 10.01.0000.
please see the notes at:
<a href="https://odbc.postgresql.org/docs/release.html" title="https://odbc.postgresql.org/docs/release.html">https://odbc.postgresql.org/docs/release.html</a>

psqlODBC may be downloaded from in source, Windows Installer,
merge module, and basic zip file formats.

New Windows installer installs both 32-bit and 64-bit driver at once
on 64-bit OS.

Memory leak when using SQLParamData and SQLPutData

Hi,

When executing a prepared insert statement and using SQL_DATA_AT_EXEC parameters that will be sent with SQLParamData and SQLPutData, the driver will leak memory for parameters. The memory will not be deallocated not even the handles are freed and the program disconnects from the database.

I am attaching a small project to demonstrate the bug. You can also browse the project at <a href="https://hub.darcs.net/mihaigiurgeanu/psqlodbc-insert-leak" title="https://hub.darcs.net/mihaigiurgeanu/psqlodbc-insert-leak">https://hub.darcs.net/mihaigiurgeanu/psqlodbc-insert-leak</a>

Thanks,
Mihai

Syndicate content